MES_Client/TGMES/Core.StlMes.Client.YdmBase/frmStorageDefine.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using System.Collections;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win;

namespace Core.StlMes.Client.YdmBase
{
    public partial class frmStorageDefine : FrmBase
    {
        private string  cmb_staskENo = "";//作业单位编码
        public frmStorageDefine()
        {
            InitializeComponent();
        }
        bool isvalid = false;
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.doQuery();
                    break;
                case "Add":
                    this.doAdd();
                    break;
                case "Update":
                    this.doUpdate();
                    break;
                case "Delete":
                    this.doDelete();
                    break;
                case "Resume":
                    DoResume();
                    break;
                case "Refresh":
                    DoRefresh();
                    break;
                case "Export":
                    DoExportGridData();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 导出
        /// </summary>
        private void DoExportGridData()
        {
            GridHelper.ulGridToExcel(gdStorage, this.Text);
        }
        /// <summary>
        /// 删除
        /// </summary>
        private void doDelete()
        {
            UltraGridRow row = this.gdStorage.ActiveRow;
            if (row == null || row.Index < 0)
            {
                MessageBox.Show("请选择需要作废的数据行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            //库号编码
            string storageCode = txt_NO01.Text + txt_NO02.Text + txt_NO03.Text;
            if (gdStorage.ActiveRow.Cells["VALIDFLAG"].Value.ToString() == "无效")
            {
                MessageBox.Show("选择的数据已经作废!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            
            string storeN0 = this.gdStorage.ActiveRow.Cells["STORAGE_NO"].Text.ToString();
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmStorageDefineSur.getStoreLocation", new object[] { storeN0 }, this.ob);
            if (int.Parse(dt.Rows[0][0].ToString())> 0)
            {
                MessageBox.Show("库位基础信息中已引用该库号，不允许作废该数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                DataTable dt1 = ServerHelper.GetData("com.steering.pss.ydm.base.YdmStorageDefineSur.getButTressData", new object[] { storeN0 }, this.ob);
                if (int.Parse(dt1.Rows[0][0].ToString()) > 0)
                {
                    MessageBox.Show("此库号已放置物品，不允许作废该数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            if (MessageBox.Show("是否确认作废数据!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
            {
                return;
            }

            ArrayList parm = new ArrayList();
            parm.Add(storageCode);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.base.YdmStorageDefineSur";
            ccp.MethodName = "storageCancelUpdate";
            ccp.ServerParams = new object[] { parm };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp.ReturnCode == -1) return;
            MessageBox.Show("操作成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            doQuery();
            YdmBaseClass.Postioning(gdStorage, "STORAGE_NO", storageCode);
        }
        /// <summary>
        /// 恢复
        /// </summary>
        private void DoResume()
        {
            UltraGridRow row = this.gdStorage.ActiveRow;
            if (row == null || row.Index < 0)
            {
                MessageBox.Show("请选择需要恢复的数据行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            //库号编码
            string storageCode = txt_NO01.Text + txt_NO02.Text + txt_NO03.Text;
            if (gdStorage.ActiveRow.Cells["VALIDFLAG"].Value.ToString() == "有效")
            {
                MessageBox.Show("选择的数据已经有效!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (MessageBox.Show("是否确认恢复数据!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
            {
                return;
            }
            ArrayList parm = new ArrayList();
            parm.Add(storageCode);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.base.YdmStorageDefineSur";
            ccp.MethodName = "storageResume";
            ccp.ServerParams = new object[] { parm };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp.ReturnCode == -1) return;
            MessageBox.Show("操作成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            doQuery();
            YdmBaseClass.Postioning(gdStorage, "STORAGE_NO", storageCode);
        }
        /// <summary>
        /// 修改
        /// </summary>
        private void doUpdate()
        {
            string memo = "";
            string storageType = "";
            string storageTypeName = "";
            string storageClassCode = "";
            string storageClassName = "";
            string addressCode = "";
            string addressName = "";
            string taskUnitCode = "";
            string taskUnitName = "";
            string upSectionCode = "";
            string upSectionName = "";
            string upDepartmentCode = "";
            string upDepartmentName = "";
            string Xaxis = "";
            string Yaxis = "";
            string groupCode = "";
            string groupName = "";
            string isCarUser = "";
            string isCarUserBill = "";
            string isLoading = "";
            string isUnloading = "";
            string seamArea = "";
            UltraGridRow ugr = gdStorage.ActiveRow;
            if (ugr == null)
            {
                MessageBox.Show("请选择你要修改的记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (ugr.Cells["VALIDFLAG"].Value.ToString() == "无效")
            {
                MessageBox.Show("数据无效，无法修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            //库号编码
            string storageCode = txt_NO01.Text.Trim() + txt_NO02.Text.Trim() + txt_NO03.Text.Trim();
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmStorageDefineSur.storageRepeatCode", new Object[] { storageCode }, this.ob);
            string repeat = dt.Rows[0][0].ToString();
            if (repeat == "0")
            {
                MessageBox.Show("您修改的库号'" + storageCode + "'还未入系统!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            //库号描述
            string storageName = txt_stonameE.Text.Trim();
            //仓库类型
            if (cmb_stoSty.Text == "")
            {
                MessageBox.Show("请选择仓库类型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                storageType = cmb_stoSty.Value.ToString().Trim();
                storageTypeName = cmb_stoSty.Text.Trim();
            }
            //仓库类别
            if (cmb_stoClass.Text == "")
            {
                MessageBox.Show("请选择仓库类别!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {            
                storageClassCode  = cmb_stoClass.Value.ToString().Trim();
                storageClassName = cmb_stoClass.Text.Trim();
            }
            //地址编码
            if (cmb_adressNo.Text == "")
            {
                MessageBox.Show("请选择地址编码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                 addressCode = cmb_adressNo.Value.ToString().Trim();
                 addressName= cmb_adressNo.Text.Trim();
            }
            //作业科室
            if (this.cmb_ksNo.Text == "")
            {
                MessageBox.Show("请选择作业科室!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                taskUnitCode = cmb_ksNo.Value.ToString();
                taskUnitName = cmb_ksNo.Text.Trim();
            }
            //作业单位
            if (this.cmb_taskNo.Text == "")
            {
                MessageBox.Show("请选择作业单位!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                upSectionCode = this.cmb_taskNo.Value.ToString();
                upSectionName = cmb_taskNo.Text.Trim();
            }
            //管理分组
            if (this.GroupName.Text == "")
            {
                MessageBox.Show("请选择仓库分组!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                groupCode = this.GroupName.Value.ToString();
                groupName = GroupName.Text.Trim();
            }
            //上级部门
            if (cmd_DapartNO.Text == "")
            {
                MessageBox.Show("请选择部门!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;     
            }
            else
            {
                upDepartmentCode = cmd_DapartNO.Value.ToString().Trim();
                upDepartmentName = cmd_DapartNO.Text.Trim();
            }
            //X坐标轴
            if (txt_x.Text == "")
            {
                MessageBox.Show("请输入X坐标轴!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                Xaxis = txt_x.Text.Trim();
            }
            //Y坐标轴
            if (txt_y.Text == "")
            {
                MessageBox.Show("请输入Y坐标轴!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                Yaxis = txt_y.Text.Trim();
            }

            memo = txt_memo.Text.Trim();
            string Virtualflag = "";
            if (chk_Virtual.Checked)
            {
                Virtualflag = "1";
            }
            else
            {
                Virtualflag = "0";
            }
            ArrayList parm = new ArrayList();
            ArrayList list = new ArrayList();
            if (!this.cmb_stoSty.Text.Trim().Equals(this.gdStorage.ActiveRow.Cells["STORAGE_ATTR_NAME"].Text.ToString()))
            {
                MessageBox.Show("仓库类型不允许修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (!this.cmb_stoClass.Text.Trim().Equals(this.gdStorage.ActiveRow.Cells["STORAGE_TYPE_NAME"].Text.ToString()))
            {
                MessageBox.Show("仓库类别不允许修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (!this.cmb_adressNo.Text.Trim().Equals(this.gdStorage.ActiveRow.Cells["STORAGE_ADDR_NAME"].Text.ToString()))
            {
                MessageBox.Show("仓库地址编码不允许修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (!storageCode.Equals(this.gdStorage.ActiveRow.Cells["STORAGE_NO"].Text.ToString()))
            {
                MessageBox.Show("仓库库号不允许修改!","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
                return;
            }
            bool bol = this.chk_Virtual.Checked;
            if (bol.ToString().ToLower() != (this.gdStorage.ActiveRow.Cells["DUMMY_FLAG"].Value.ToString().ToLower()))
            {
                MessageBox.Show("仓库是否虚拟不允许修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            isCarUser = this.isCarUser.Text;
            if (isCarUser == "")
            {
                isCarUser = "0";
            }
            else
            {
                isCarUser = this.isCarUser.Value.ToString2();
            }
            isCarUserBill = this.isCarUserBill.Text;
            if (isCarUserBill == "")
            {
                isCarUserBill = "0";
            }
            else
            {
                isCarUserBill = this.isCarUserBill.Value.ToString2();
            }
            isLoading = this.ultraIsLoading.Text;
            if (isLoading == "")
            {
                isLoading = "0";
            }else
            {
                isLoading = this.ultraIsLoading.Value.ToString2();
            }
            isUnloading = this.ultraIsUnloading.Text;
            if (isUnloading == "")
            {
                isUnloading = "0";
            }
            else
            {
                isUnloading = this.ultraIsUnloading.Value.ToString2();
            }
            seamArea = this.SEAMAREA.Text;
            if (seamArea == "")
            {
                seamArea = "0";
            }
            else
            {
                seamArea = this.SEAMAREA.Value.ToString2();
            }
            parm.Add(storageName);
            
            parm.Add(storageType);
            
            parm.Add(storageTypeName);
            parm.Add(storageClassCode);
            parm.Add(storageClassName);

            //创建一个序号。
            //int index_seq = GetMaxSeq();
            //parm.Add(index_seq);

            parm.Add(addressCode);
            parm.Add(addressName);
            parm.Add(taskUnitCode);
            parm.Add(taskUnitName);
            parm.Add(upDepartmentCode);
            parm.Add(upDepartmentName);
            parm.Add(Xaxis);


            parm.Add(Yaxis);
            parm.Add(memo);
            parm.Add(Virtualflag);
            //parm.Add(Effectiveflag);
            parm.Add(this.UserInfo.GetUserName());
            parm.Add(upSectionCode);
            parm.Add(upSectionName);
            parm.Add(groupCode);
            parm.Add(groupName);
            parm.Add(isCarUser);
            parm.Add(isCarUserBill);
            parm.Add(isLoading);
            parm.Add(isUnloading);
            parm.Add(seamArea);
            if (storageCode.Equals(this.gdStorage.ActiveRow.Cells["STORAGE_NO"].Text.ToString()))
            {
                parm.Add(storageCode);
            }
            else
            {
                MessageBox.Show("库号不允许修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
           
            if (MessageBox.Show("是否确认修改？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.base.YdmStorageDefineSur";
            ccp.MethodName = "storageCodeUpdate";
            ccp.ServerParams = new object[] { parm };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp.ReturnCode == -1)
            {
                return;
            }
            else
            {
                list.Add(taskUnitCode);
                list.Add(taskUnitName);
                list.Add(upSectionCode);
                list.Add(upSectionName);
                list.Add(this.UserInfo.GetUserName());
                list.Add(storageCode);
                ccp.ServerName = "com.steering.pss.ydm.base.YdmStorageDefineSur";
                ccp.MethodName = "storageCodeUpdateLaction";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode == -1)
                {
                    return;
                }
                else
                {
                    MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    doQuery();
                    YdmBaseClass.Postioning(gdStorage, "STORAGE_NO", storageCode);
                }
            }
        }
        /// <summary>
        /// 新增
        /// </summary>
        private void doAdd()
        {

            string memo = "";
            string storageType = "";
            string storageTypeName = "";
            string storageClassCode = "";
            string storageClassName = "";
            string addressCode = "";
            string addressName = "";
            string taskUnitCode = "";
            string taskUnitName = "";
            string upSectionCode = "";
            string upSectionName = "";
            string upDepartmentCode = "";
            string upDepartmentName = "";
            string Xaxis = "";
            string Yaxis = "";
            string storageName = "";
            string groupCode = "";
            string groupName = "";
            //库号编码
            if (this.txt_NO03.Text == "")
            {
                MessageBox.Show("请输入该库的临时编号", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            string storageCode = txt_NO01.Text.Trim() + txt_NO02.Text.Trim() + txt_NO03.Text.Trim();
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmStorageDefineSur.storageRepeatCode", new Object[] { storageCode }, this.ob);
            string repeat = dt.Rows[0][0].ToString();
            if (repeat == "1")
            {
                MessageBox.Show("输入的库号编码重复!,请重新选库", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                //cmb_stoSty.Text = "";
                //cmb_adressNo.Text = "";
                return;
            }
            //库号描述
            if (txt_stonameE.Text == "")
            {
                MessageBox.Show("请输入仓库描述!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                 storageName = txt_stonameE.Text.Trim();
            }
            //仓库类型
            if (cmb_stoSty.Text == "")
            {
                MessageBox.Show("请选择仓库类型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                storageType = cmb_stoSty.Value.ToString().Trim();
                storageTypeName = cmb_stoSty.Text.Trim();
            }
            //仓库类别
            if (cmb_stoClass.Text == "")
            {
                MessageBox.Show("请选择仓库类别!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                 storageClassCode  = cmb_stoClass.Value.ToString().Trim();
                 storageClassName = cmb_stoClass.Text.Trim();
            }
            //管理分组
            if (this.GroupName.Text == "")
            {
                MessageBox.Show("请选择仓库组!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                groupCode = this.GroupName.Value.ToString();
                groupName = GroupName.Text.Trim();
            }
            //地址编码
            if (cmb_adressNo.Text == "")
            {
                MessageBox.Show("请选择地址编码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
               addressCode  = cmb_adressNo.Value.ToString().Trim();
               addressName = cmb_adressNo.Text.Trim();
            }
            //作业科室
            if (cmb_ksNo.Text == "")
            {
                MessageBox.Show("请选择作业科室!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                taskUnitCode = cmb_ksNo.Value.ToString();
                taskUnitName = cmb_ksNo.Text.Trim();
            }

            //作业单位
            if (cmb_taskNo.Text == "")
            {
                MessageBox.Show("请选择作业单位!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
                //upSectionCode = "";
                //upSectionName = "";
            }else
            {
                upSectionCode = cmb_taskNo.Value.ToString();
                upSectionName = cmb_taskNo.Text.Trim();
            }

            //上级部门
            if (cmd_DapartNO.Text == "")
            {
                MessageBox.Show("请选择上级部门!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
                //upDepartmentCode = "";
                //upDepartmentName = "";
            }
            else
            {
                upDepartmentCode = cmd_DapartNO.Value.ToString().Trim();
                upDepartmentName = cmd_DapartNO.Text.Trim();
            }
            //X坐标轴
            if (txt_x.Text == "")
            {
                MessageBox.Show("请输入X坐标轴!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                if (StringUtil.IsNumber(txt_x.Text.Trim()))
                {
                    Xaxis = txt_x.Text.Trim();
                }
                else
                {
                    MessageBox.Show("X坐标需为全数字!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            //Y坐标轴
            if (txt_y.Text == "")
            {
                MessageBox.Show("请输入Y坐标轴!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                if (StringUtil.IsNumber(txt_y.Text.Trim()))
                {
                    Yaxis = txt_y.Text.Trim();
                }
                else
                {
                    MessageBox.Show("Y坐标需为全数字!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }

            memo = txt_memo.Text.Trim();
            string Virtualflag = "";
            if (chk_Virtual.Checked)
            {
                Virtualflag = "1";
            }
            else
            {
                Virtualflag = "0";
            }
            string carUser = this.isCarUser.Text.Trim();
            if (carUser == "")
            {
                carUser = "0";
            }
            else
            {
                carUser = this.isCarUser.Value.ToString2();
            }

            string carUserBill = this.isCarUserBill.Text.Trim();
            if (carUserBill == "")
            {
                carUserBill = "0";
            }
            else
            {
                carUserBill = this.isCarUserBill.Value.ToString2();
            }

            //string gradeText = cmbGZType.Text.Trim();
            ArrayList parm = new ArrayList();

            parm.Add(storageCode);
            parm.Add(storageName);

            parm.Add(storageType);
            parm.Add(storageTypeName);
            parm.Add(storageClassCode);
            parm.Add(storageClassName);

            //创建一个序号。
            //int index_seq = GetMaxSeq();
            //parm.Add(index_seq);

            parm.Add(addressCode);
            parm.Add(addressName);
            parm.Add(taskUnitCode);
            parm.Add(taskUnitName);

            parm.Add(upDepartmentCode);
            parm.Add(upDepartmentName);
            
            parm.Add(Xaxis);


            parm.Add(Yaxis);
            parm.Add(memo);
            parm.Add(Virtualflag);

            parm.Add(this.UserInfo.GetUserName());
            parm.Add(upSectionCode);
            parm.Add(upSectionName);
            parm.Add(groupCode);
            parm.Add(groupName);
            parm.Add(carUser);
            parm.Add(carUserBill);
            parm.Add(this.SEAMAREA.Value.ToString2());
           
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.base.YdmStorageDefineSur";
            ccp.MethodName = "storageCodeAdd";
            ccp.ServerParams = new object[] { parm };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp.ReturnCode == -1) return;
            MessageBox.Show("增加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            doQuery();
            YdmBaseClass.Postioning(gdStorage, "STORAGE_NO", storageCode);

        }
        /// <summary>
        /// 查询
        /// </summary>
        private void doQuery()
        {

            string departMent = this.UserInfo.GetDepartment();
            //库存编码
            string storage = "";
            if (chk_stono.Checked)
            {
                if (txt_stonameQ.Text == "")
                {
                    MessageBox.Show("请输入库位编码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    storage = txt_stonameQ.Text;
                }

            }
            //作业科室 
              string unit = "";
              if (ultraCheckEditor2.Checked)
              {
                  if (cmb_department.Text == "")
                  {
                      MessageBox.Show("请输入作业科室!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                      return;
                      unit = "";
                  }
                  else
                  {
                      unit = this.cmb_department.Value.ToString().Trim(); //cbm_staskQ.SelectedNode.Tag.ToString().Trim();//ultraComboEditor1.Value.ToString().Trim()
                  }
              }
            //是否包含有效
            if (ultraCheckEditor1.Checked)
            {
                isvalid = true;
            }
            string[] arr = YdmBaseClass.BaseSection(this.ValidDataPurviewIds, this.ob);
            string titleName = txt_stonameQ.Text.Trim();
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmStorageDefineSur.storageName", new Object[] { storage, unit, isvalid, departMent, arr }, this.ob);
            gdStorage.DataSource = dt;
            YdmBaseClass.SetGridRowColor(gdStorage);
            YdmBaseClass.SetColAutoSizeExceptMemo(gdStorage);
            

        }
        /// <summary>
        /// 刷新
        /// </summary>
        private void DoRefresh()
        {
            BindStorage();
            AddressCodeBind();
            StorageClass();
            //getDepartMent();
            getDepartMent1();
            getDepartMent2();
            getMaxDepart();
            //QueryTree();

        }

        private void getDepartMent()
        {
            //string[] arr = this.ValidDataPurviewIds;
            DataTable dt = new DataTable();
            string flag = "0";
            string userName = this.UserInfo.GetUserName();
            string departMent = ClsBaseInfo.GetDepartBySectionId(UserInfo.GetDeptid(), this.ob);
            if (userName.Equals("admin"))
            {
                dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.departQuery", new object[] { departMent, flag }, this.ob);

                if (dt.Rows.Count > 0)
                { 
                    cmb_department.DataSource = dt;
                    cmb_department.DisplayMember = "DEPARTNAME";
                    cmb_department.ValueMember = "DEPARTID";
                    this.cmb_department.SelectedIndex = -1;

                }
            }
            else
            {
                flag = "1";
                dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.departQuery", new object[] { departMent, flag }, this.ob);
                if (dt.Rows.Count > 0)
                {
                    cmb_department.DataSource = dt;
                    cmb_department.DisplayMember = "DEPARTNAME";
                    cmb_department.ValueMember = "DEPARTID";
                    this.cmb_department.SelectedIndex = 0;

                }
            }
        }

        private void getDepartMent1()
        {
            DataTable dt = new DataTable();
            string flag = "0";
            string userName = this.UserInfo.GetUserName();
            string departMent = ClsBaseInfo.GetDepartBySectionId(UserInfo.GetDeptid(), this.ob);
            if (userName.Equals("admin"))
            {
                dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.departQuery", new object[] { departMent, flag }, this.ob);

                if (dt.Rows.Count > 0)
                {
                    cmb_taskNo.DataSource = dt;
                    cmb_taskNo.DisplayMember = "DEPARTNAME";
                    cmb_taskNo.ValueMember = "DEPARTID";


                }
            }
            else
            {
                flag = "1";
                dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.departQuery", new object[] { departMent, flag }, this.ob);
                if (dt.Rows.Count > 0)
                {
                    cmb_taskNo.DataSource = dt;
                    cmb_taskNo.DisplayMember = "DEPARTNAME";
                    cmb_taskNo.ValueMember = "DEPARTID";
                    this.cmb_taskNo.SelectedIndex = 0;

                }
            }
        }
        private void getDepartMent2()
        {
            DataTable dt = new DataTable();
            string flag = "0";
            string userName = this.UserInfo.GetUserName();
            string departMent = ClsBaseInfo.GetDepartBySectionId(UserInfo.GetDeptid(), this.ob);
            dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.departQuery", new object[] { departMent, flag }, this.ob);

            if (dt.Rows.Count > 0)
            {
                cmd_DapartNO.DataSource = dt;
                cmd_DapartNO.DisplayMember = "DEPARTNAME";
                cmd_DapartNO.ValueMember = "DEPARTID";


            }
        }

        /// <summary>
        /// 初始化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void frmStorageDefine_Load(object sender, EventArgs e)
        {

            BindStorage();
            AddressCodeBind();
            StorageClass(); 
           // QueryTree();
            //getDepartMent();
            getMaxDepart();
            getDepartMent1();
            getDepartMent2();
            getGroupStoage(); 
           //cbm_staskQ.Text=this.UserInfo.GetDepartment();
           //treeSelect(cbm_staskQ.Text);
            this.ultraCheckEditor1.Visible = false;
            this.cmb_department.Enabled = false;
            YdmBaseClass.InitSection(cmb_department,this.ValidDataPurviewIds,this.ob);
            YdmBaseClass.InitSection(cmb_ksNo, this.ValidDataPurviewIds, this.ob);

       
            
        }

        /// <summary>
        /// 加载作业科室
        /// </summary>
        private void getMaxDepart()
        {
            string[] arr = this.ValidDataPurviewIds;
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmStorageDefineSur.getMaxDepartMent", new object[] { arr }, this.ob);
            if (dt.Rows.Count > 0)
            {
                cmb_ksNo.DataSource = dt;
                cmb_ksNo.DisplayMember = "DEPARTNAME";
                cmb_ksNo.ValueMember = "DEPARTID";
            }
        }
        /// <summary>
        /// 管理分组
        /// </summary>
        private void getGroupStoage()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmStorageDefineSur.getGroupStoage", new object[] { "8019" }, this.ob);
            if (dt.Rows.Count > 0)
            {
                GroupName.DataSource = dt;
                GroupName.DisplayMember = "BASENAME";
                GroupName.ValueMember = "BASECODE";
            }
        }
        //刷新Tree
        public void QueryTree()
        {
            //this.cmb_staskE.Nodes.Clear();
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.departQuery", null, this.ob);
            //树控件递归绑定方法。
            //Bind_Tv(dt, cbm_staskQ.Nodes, null, "DEPARTID", "PID", "DEPARTNAME");
            //YdmBaseClass.MakeTree(dt, "PID", null, "DEPARTID", "DEPARTNAME", cbm_staskQ.Nodes,-1);
            //YdmBaseClass.MakeTree(dt, "PID", null, "DEPARTID", "DEPARTNAME", cmb_staskE.Nodes, -1);
        }

        /// <summary>
        /// 绑定仓库类型
        /// </summary>
        private void BindStorage()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.storageBind", null, this.ob);
            cmb_stoSty.DataSource = dt;
            cmb_stoSty.DisplayMember = "BASENAME";
            cmb_stoSty.ValueMember = "BASECODE";
        }
        /// <summary>
        /// 绑定地址编码
        /// </summary>
        private void AddressCodeBind()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.addressCodeBind", null, this.ob);
            cmb_adressNo.DataSource = dt;
            cmb_adressNo.DisplayMember = "BASENAME";
            cmb_adressNo.ValueMember = "BASECODE";
        }
        /// <summary>
        /// 绑定仓库类别  
        /// </summary>
        private void StorageClass()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.storageClass", null, this.ob);
            cmb_stoClass.DataSource = dt;
            cmb_stoClass.DisplayMember = "BASENAME";
            cmb_stoClass.ValueMember = "BASECODE";
        }
        private void ultraTextEditor4_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            //string strl = txt_NO01.Text.Trim() + txt_NO02.Text.Trim();

            //DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.storageEendCode", new object[]{strl}, this.ob);
            //if (dt.Rows.Count == 0)
            //{
            //    txt_NO03.Text = "1";
            //}
            //else
            //{
            //    txt_NO03.Text = dt.Rows[0][0].ToString();
            //}

            //if (txt_NO03.Text == "9")
            //{
            //    txt_NO03.Text = "A";
            //}
            //else
            //{
            //    string iCode = txt_NO03.Text;
            //    char eCode = Convert.ToChar(iCode);
            //    try
            //    {
            //        txt_NO03.Text = Convert.ToString((char)((int)eCode + 1));
            //        //txt_stonameE.Text = cmb_stoSty.Text.Trim()+ cmb_adressNo.Text.Trim() + txt_NO03.Text + "号仓库";
            //    }
            //    catch { }
            //}
        }

        private void gdStorage_AfterRowActivate(object sender, EventArgs e)
        {
            if (gdStorage.Rows.Count == 0)
            {
                return;
            }
            if (gdStorage.ActiveRow != null)
            {
                txt_NO01.Text = gdStorage.ActiveRow.Cells["STORAGE_NO"].Value.ToString().Substring(0, 1).ToString();
                txt_NO02.Text = gdStorage.ActiveRow.Cells["STORAGE_NO"].Value.ToString().Substring(1, 2).ToString();
                txt_NO03.Text = gdStorage.ActiveRow.Cells["STORAGE_NO"].Value.ToString().Substring(3).ToString();
                cmb_adressNo.Text = gdStorage.ActiveRow.Cells["STORAGE_ADDR_NAME"].Value.ToString();
                cmb_stoSty.Text = gdStorage.ActiveRow.Cells["STORAGE_ATTR_NAME"].Value.ToString();
                cmb_stoClass.Text = gdStorage.ActiveRow.Cells["STORAGE_TYPE_NAME"].Value.ToString();
                //treeSelect(gdStorage.ActiveRow.Cells["MANAGEMENT_NAME"].Value == null ? "" : gdStorage.ActiveRow.Cells["MANAGEMENT_NAME"].Value.ToString());
                this.cmb_ksNo.Text = gdStorage.ActiveRow.Cells["MANAGEMENT_NAME"].Value.ToString();
                this.cmb_taskNo.Text = gdStorage.ActiveRow.Cells["DEPARTMENT_DESC"].Value.ToString();
                //cmb_staskE.SelectedNode.Tag = gdStorage.ActiveRow.Cells["MANAGEMENT_NO"].Value.ToString();
                this.cmd_DapartNO.Text = gdStorage.ActiveRow.Cells["HL_MANAGEMENT_NAME"].Value.ToString();

                txt_x.Text = gdStorage.ActiveRow.Cells["X_COORDINATE"].Value.ToString();
                txt_y.Text = gdStorage.ActiveRow.Cells["Y_COORDINATE"].Value.ToString();
                txt_memo.Text = gdStorage.ActiveRow.Cells["MEMO"].Value.ToString();
                txt_stonameE.Text = gdStorage.ActiveRow.Cells["STORAGE_NAME"].Value.ToString();
                GroupName.Text = gdStorage.ActiveRow.Cells["STOCK_GROUP_NAME"].Value.ToString();
                if (gdStorage.ActiveRow.Cells["DUMMY_FLAG"].Value.ToString().ToUpper() == "TRUE")
                {
                    chk_Virtual.Checked = true;
                }
                else
                {
                    chk_Virtual.Checked = false;
                }
                this.isCarUser.Text = gdStorage.ActiveRow.Cells["IS_CAR_TAKING"].Value.ToString();
                this.isCarUserBill.Text = gdStorage.ActiveRow.Cells["IS_CAR_TAKING_BILL"].Value.ToString();
                this.ultraIsLoading.Text = gdStorage.ActiveRow.Cells["IS_CRANE_LOADING"].Value.ToString();
                this.ultraIsUnloading.Text = gdStorage.ActiveRow.Cells["IS_CRANE_UNLOADING"].Value.ToString();
                this.SEAMAREA.Text = gdStorage.ActiveRow.Cells["SEAM_AREA"].Value.ToString();
                //DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.getSuperior", new object[] { gdStorage.ActiveRow.Cells["MANAGEMENT_NO"].Value.ToString() }, this.ob);
                //cmd_DapartNO.DataSource = dt;
                //cmd_DapartNO.DisplayMember = "REMARK";
                //cmd_DapartNO.ValueMember = "PID";
                //cmd_DapartNO.SelectedIndex = 0;

                //cmd_DapartNO.Text = gdStorage.ActiveRow.Cells["HL_MANAGEMENT_NAME"].Text.ToString();
            }
        }

        //展开下拉列表树节点
        //public void treeSelect(string Name)
        //{
        //    if (!string.IsNullOrEmpty(Name))
        //    {

        //        for (int e = 0; e < this.cmb_staskE.Nodes.Count; e++)
        //        {
        //            cmb_staskE.Nodes[e].Collapse();
        //            //combelonCity = "";
        //            //展开一级节点  LX 修改
        //            if (this.cmb_staskE.Nodes[e].Text.Equals(Name) || this.cmb_staskE.Nodes[e].Tag.Equals(Name))
        //            {
        //                this.cmb_staskE.Nodes[e].Expand();
        //                this.cmb_staskE.Nodes[e].ExpandAll();
        //                cmb_staskE.Text = this.cmb_staskE.Nodes[e].Text.ToString();
        //                cmb_staskENo = this.cmb_staskE.Nodes[e].Tag.ToString();
        //                //combleTo = this.cmb_staskE.Nodes[e].ToolTipText;
        //                return;
        //            }

        //            //展开二级节点
        //            for (int w = 0; w < this.cmb_staskE.Nodes[e].Nodes.Count; w++)
        //            {
        //                if (this.cmb_staskE.Nodes[e].Nodes[w].Text.Equals(Name) || this.cmb_staskE.Nodes[e].Nodes[w].Tag.Equals(Name))
        //                {
        //                    this.cmb_staskE.Nodes[e].Expand();
        //                    this.cmb_staskE.Nodes[e].Nodes[w].ExpandAll();
        //                    cmb_staskE.Text = this.cmb_staskE.Nodes[e].Nodes[w].Text.ToString();
        //                    cmb_staskENo = this.cmb_staskE.Nodes[e].Nodes[w].Tag.ToString();
        //                    //combleTo = this.cmb_staskE.Nodes[e].Nodes[w].ToolTipText;
        //                    return;
        //                }
        //            }
        //            //展开三级子节点
        //            for (int w = 0; w < this.cmb_staskE.Nodes[e].Nodes.Count; w++)
        //            {
        //                for (int r = 0; r < this.cmb_staskE.Nodes[e].Nodes[w].Nodes.Count; r++)
        //                {
        //                    if (this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Text.Equals(Name) || this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Tag.Equals(Name))
        //                    {
        //                        this.cmb_staskE.Nodes[e].Expand();
        //                        this.cmb_staskE.Nodes[e].Nodes[w].Expand();
        //                        this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].ExpandAll();
        //                        cmb_staskE.Text = this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Text.ToString();
        //                        cmb_staskENo = this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Tag.ToString();
        //                        //combleTo = this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].ToolTipText;
        //                        return;
        //                    }
        //                }
        //            }
        //            //展开四级子节点
        //            for (int w = 0; w < this.cmb_staskE.Nodes[e].Nodes.Count; w++)
        //            {
        //                for (int r = 0; r < this.cmb_staskE.Nodes[e].Nodes[w].Nodes.Count; r++)
        //                {
        //                    for (int x = 0; x < this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Nodes.Count; x++)
        //                    {
        //                        if (this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Nodes[x].Text.Equals(Name) || this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Nodes[x].Tag.Equals(Name))
        //                        {
        //                            this.cmb_staskE.Nodes[e].Expand();
        //                            this.cmb_staskE.Nodes[e].Nodes[w].Expand();
        //                            this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Expand();
        //                            this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Nodes[x].ExpandAll();
        //                            cmb_staskE.Text = this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Nodes[x].Text.ToString();
        //                            cmb_staskENo = this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Nodes[x].Tag.ToString();
        //                            //combleTo = this.cmb_staskE.Nodes[e].Nodes[w].Nodes[r].Nodes[x].ToolTipText;
        //                            return;
        //                        }
        //                    }
        //                }
        //            }
        //        }
        //    }
        //}

        private void chk_stono_CheckedChanged(object sender, EventArgs e)
        {
            this.txt_stonameQ.Enabled = this.chk_stono.Checked;
        }

        private void cmb_stoSty_ValueChanged(object sender, EventArgs e)
        {

            string strSty = "";
            if (cmb_stoSty.Text != "")
                strSty = cmb_stoSty.Value.ToString();

            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.getStorageMemo", new object[] { strSty }, this.ob);
            if (dt.Rows.Count == 0)
            {
                return;
            }
            txt_NO01.Text = dt.Rows[0]["MEMO"].ToString();

            //if (cmb_stoSty.Text != "" && cmb_adressNo.Text != "")
            //{
            //txt_stonameE.Text = cmb_stoSty.Text.Trim() + cmb_adressNo.Text.Trim() + txt_NO03.Text.Trim() + "号仓库";
            //}
        }

        private void cmb_adressNo_ValueChanged(object sender, EventArgs e)
        {
            string strSty = "";
            if (cmb_adressNo.Text != "")
                strSty = cmb_adressNo.Value.ToString();
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.getStorageMemo", new object[] { strSty }, this.ob);
            if (dt.Rows.Count == 0)
            {
                return;
            }
            txt_NO02.Text = dt.Rows[0]["MEMO"].ToString();
            //txt_stonameE.Text = cmb_stoSty.Text.Trim() + cmb_adressNo.Text.Trim() + txt_NO03.Text.Trim() + "号仓库";

        }

        private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckEditor1.Checked)
                isvalid = true;
            else
                isvalid = false;
        }

        //private void txt_NO03_TextChanged(object sender, EventArgs e)
        //{
        //    txt_stonameE.Text = cmb_stoSty.Text.Trim()+ cmb_adressNo.Text.Trim() + txt_NO03.Text + "号仓库";
        //}

        /// <summary>
        /// 上级单位根据选择的作业单位查找
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cmb_staskE_DropDownClosed(object sender, EventArgs e)
        {
            //treeSelect(cmb_staskE.Text.Trim());
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmBaseQuery.getSuperior", new object[] { cmb_staskENo }, this.ob);
            cmd_DapartNO.DataSource = dt;
            cmd_DapartNO.DisplayMember = "REMARK";
            cmd_DapartNO.ValueMember = "PID";
            cmd_DapartNO.SelectedIndex = 0;
        }
        /// <summary>
        /// 判断Y轴坐标是否输入格式正确
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txt_y_TextChanged(object sender, EventArgs e)
        {
            bool bt = StringUtil.IsNumber(this.txt_x.Text);
            if (!bt)
            {
                MessageBox.Show("X坐标需为全数字!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
        }

        private void cmb_taskNo_ValueChanged(object sender, EventArgs e)
        {

            if (this.cmb_taskNo.Text != "")
            {
                string value = this.cmb_taskNo.Value.ToString();
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.YdmStorageDefineSur.departMentKs", new object[] { value }, this.ob);
                //if (dt.Rows.Count > 0)
                //{
                    this.cmb_ksNo.DataSource = dt;
                    this.cmb_ksNo.ValueMember = "DEPARTID";
                    this.cmb_ksNo.DisplayMember = "DEPARTNAME";
                    this.cmb_ksNo.SelectedIndex = -1;
                    if (gdStorage.Rows.Count > 0)
                    {
                        this.cmb_ksNo.Text = this.gdStorage.ActiveRow.Cells["MANAGEMENT_NAME"].Value.ToString();
                    }
                //}
            }
        }

        private void frmStorageDefine_Shown(object sender, EventArgs e)
        {
            //toolMenu.Toolbars[0].Tools["Resume"].InstanceProps.Visible = DefaultableBoolean.False;

        }

        private void ultraCheckEditor2_CheckedChanged(object sender, EventArgs e)
        {
            cmb_department.Enabled = this.ultraCheckEditor2.Checked;
        }

        //private void txt_NO03_ValueChanged(object sender, EventArgs e)
        //{
        //    txt_stonameE.Text = cmb_stoSty.Text.Trim() + cmb_adressNo.Text.Trim() + txt_NO03.Text.Trim() + "号仓库";
        //}
    }
}