MES_Client/TGMES/Core.StlMes.Client.PipeLeaveFactory/01.出厂计划/frmShipmentApp.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.Control;
using System.Collections;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.YdmBase;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win.UltraWinGrid;
using Core.StlMes.Client.PipeLeaveFactory.Tool;
using Infragistics.Win;
using Core.StlMes.Client.PipeLeaveFactory.YdmObject;
using Core.Mes.Client.Comm.Format;

namespace Core.StlMes.Client.PipeLeaveFactory
{
    public partial class frmShipmentApp : FrmBase
    {
        /// <summary>
        /// 用户销售组织权限
        /// </summary>
        private string[] _salgPermissions = null;
        private string posit = "";//定位

        private string departid;//对应部门ID
        private string departname;//对应部门
        private string management_no;//对应科室id
        private string management_name;//对应科室
        ArrayList pram = new ArrayList();
        public frmShipmentApp()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void frmShipmentApp_Load(object sender, EventArgs e)
        {
            ClsBaseInfo.SetComboItemHeight(cmbAppFalg);
            _salgPermissions = InitPermissions();

            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            StratTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            //专用线
            YdmBaseClass.InitComboEditor(TxtLine, "com.steering.pss.ydm.pipeleavefactory.FrmPipeSendList.queryPrivateSid", "SPCL_LN_NO", ob, false);
            //到站
            YdmBaseClass.InitComboEditor(ComStation, "com.steering.pss.ydm.pipeleavefactory.FrmPipeSendList.queryArriveStation", "STATION_NO", ob, false);
            InAskMonth();
            BaseHelper.InitMonth(ComMonth);
            BaseHelper.InitYear(ComYear);
            ComMonth.Value = string.Format("{0:00}", DateTime.Now.Month);
            ComYear.Value = DateTime.Now.Year.ToString();

            management_no = this.UserInfo.GetDeptid();
            management_name = this.UserInfo.GetDepartment();
            departid = ClsBaseInfo.GetDepartIdBySectionId(UserInfo.GetDeptid(), this.ob);
            departname = ClsBaseInfo.GetDepartBySectionId(UserInfo.GetDeptid(), this.ob);

        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQuery();
                    break;
                case "Add":
                    doAdd();
                    break;
                case "Delete":
                    doDelete();
                    break;
                case "Update":
                    doUpdate();
                    break;
                case "App":
                    doApp();
                    break;
                case "DeleteApp":
                    doDeleteApp();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ultraGrid1, "铁运月请车批车");
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 查询请车批车号
        /// </summary>
        private void InAskMonth()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doQueryAskMonth", new object[] { DateTime.Now.ToString("yyyy-MM") }, ob);
            ComAskMonth.DataSource = dt;
            ComAskMonth.ValueMember = "ASK_MONTH_NO";
            Object[] obj = new Object[] { ""};
            DataRow dr = dt.NewRow();
            dr.ItemArray = obj;
            dt.Rows.Add(dr);
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void doQuery()
        {
            if (ultraTabControl1.SelectedTab.Key.Equals("1"))
            {
                string strFalg = "";//审批状态
                string stratTime = "";
                string endTime = "";
                string askMonth = "";
             
                if (chkFlag.Checked)
                {
                    strFalg = cmbAppFalg.Value.ToString();
                }

                if (ultraCheckEditor5.Checked)
                {
                    stratTime = StratTime.Value.ToString();
                    endTime = EndTime.Value.ToString();

                    if (DateTime.Parse(stratTime) > DateTime.Parse(endTime))
                    {
                        MessageUtil.ShowTips("您所选择时间区间不正确，请重新选择！");
                        return;
                    }
                }
               
                if (ChkAskMonth.Checked)
                {
                    if (txtAskMonth.Text.Trim() == "")
                    {
                        MessageUtil.ShowTips("月请车批车不能为空！");
                        return;
                    }
                    askMonth = txtAskMonth.Text.Trim();
                }
                pram.Clear();
                pram.Add(askMonth);
                pram.Add(strFalg);
                pram.Add(stratTime);
                pram.Add(stratTime);
                pram.Add(stratTime);
                pram.Add(endTime);
                pram.Add(endTime);
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doQuery", new object[] { pram, this.ValidDataPurviewIds }, this.ob);
                GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);

                for (int i = 0; i < ultraGrid1.Rows.Count; i++)
                {
                    string strindex = ultraGrid1.Rows[i].Cells["ASK_MONTH_PK"].Value.ToString();
                    if (strindex == posit)
                    {
                        UltraGridRow row = ultraGrid1.Rows[i];
                        row.Activate();
                    }
                }
            }
            else
            {
                ArrayList param = new ArrayList();
                string planTime = "";
                if (ChcDelivyTime.Checked && ComYear.Value != null && ComMonth.Value != null) { planTime = ComYear.Value.ToString() + ComMonth.Value.ToString(); }
                string station = "";
                if (ChcStation.Checked && ComStation.Value != null) { station = ComStation.Value.ToString(); }
                string spcl = "";
                if (ChcLine.Checked && TxtLine.Value != null) { spcl = TxtLine.Value.ToString(); }
                string ordeNo = "";
                if (ChcOrderNo1.Checked) { ordeNo = TxtOrderNo1.Text.Trim(); }
                string reciveNm = "";
                if (ChcRecive.Checked) { reciveNm = ComRevice.Text.Trim(); }
                param.Add(planTime);
                param.Add(station);
                param.Add(spcl);
                param.Add(ordeNo);
                param.Add(reciveNm);
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.querySendPlanM", new object[] { param, this.ValidDataPurviewIds }, this.ob);
                GridHelper.CopyDataToDatatable(ref dt, ref dataTable4, true);
                if (dt == null || dt.Rows.Count == 0)
                {
                    GridHelper.ClearGridDataSourceData(ultraGrid4);
                }
                for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                {
                    string strindex = ultraGrid2.Rows[i].Cells["PLAN_YEAR_MONTH"].Value.ToString() + ultraGrid2.Rows[i].Cells["STATION_NO"].Value.ToString() + ultraGrid2.Rows[i].Cells["SPCL_LN_NO"].Value.ToString() + ultraGrid2.Rows[i].Cells["RECEIV_NO"].Value.ToString();
                    if (strindex == posit)
                    {
                        UltraGridRow row = ultraGrid2.Rows[i];
                        row.Activate();
                    }
                }
                InAskMonth();
                ComAskMonth.Text = "";
            }
            posit = "";
        }
        /// <summary>
        /// 新增请车
        /// </summary>
        private void doAdd()
        {
            ultraGrid2.UpdateData();
            UltraGridRow ugr = this.ultraGrid2.ActiveRow;
            int isSelect = 0;
            ArrayList list = new ArrayList();
            string strTime = DateTime.Now.ToString();

            string askMonth = "";

            if (ComAskMonth.Text.Trim() == "")
            {
                doAskMonthNo();
            }
            askMonth = ComAskMonth.Text.Trim();

            if (ugr == null)
            {
                MessageUtil.ShowTips("无数据,不能进行此操作！");
                return;
            }    
            foreach (UltraGridRow row in ultraGrid2.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    isSelect += 1;
                    if (row.Cells["VEHICLE_NUM"].Text.Trim() == "" || row.Cells["VEHICLE_NUM"].Text.Trim().Equals("0"))
                    {
                        MessageUtil.ShowTips("请输月请车数！");
                        return;
                    }
                    YdmZcAskMonthEntity sendM = new YdmZcAskMonthEntity();
                    ArrayList listmonth= new ArrayList();
                    string spclno = "N";

                 

                    if (row.Cells["SPCL_LN_NO"].Text.Trim() != "")
                    {
                        spclno = row.Cells["SPCL_LN_NO"].Text.Trim();
                    }
                    listmonth.Add(row.Cells["PLAN_YEAR_MONTH"].Text.Trim());
                    listmonth.Add(row.Cells["STATION_NO"].Text.Trim());
                    listmonth.Add(spclno);
                    listmonth.Add(row.Cells["RECEIV_NO"].Text.Trim());
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doQueryMonthask", new object[] { listmonth }, this.ob);
                    string strwaflag = "1";
                    if (dt.Rows.Count > 0)
                    {
                        if (dt.Rows[0]["ASK_MONTH_NO"].ToString() != askMonth)
                        {
                            //if (MessageUtil.ShowYesNoAndQuestion("该请车记录已存在,是否继续添加补充请车？") == DialogResult.No) return;
                            strwaflag = "2";
                        }
                    }
                    sendM.AskMonthNo = askMonth;
                    sendM.SendPlanNo = row.Cells["PLAN_YEAR_MONTH"].Text.Trim();
                    sendM.StationNo = row.Cells["STATION_NO"].Text.Trim();
                    sendM.StationNm = row.Cells["STATION_NM"].Text.Trim();
                    sendM.SpclLnNo = row.Cells["SPCL_LN_NO"].Text.Trim();
                    sendM.SpclLnNm = row.Cells["SPCL_LN_NM"].Text.Trim();
                    sendM.ReceivNo = row.Cells["RECEIV_NO"].Text.Trim();
                    sendM.ReceivNm = row.Cells["RECEIV_NM"].Text.Trim();
                    //sendM.SaleOrg = row.Cells["SALE_ORG"].Text.Trim();
                    //sendM.SaleOrgDesc = row.Cells["SALE_ORG_DESC"].Text.Trim();
                    sendM.WagonsFlag = strwaflag;
                    sendM.DepartmentCode = departid;
                    sendM.DepartmentDesc = departname;
                    sendM.ManagementNo = management_no;
                    sendM.ManagementName = management_name;
                    sendM.CreateName = this.UserInfo.GetUserName();
                    sendM.CreateTime = strTime;
                    sendM.VehicleMonthNum = row.Cells["VEHICLE_NUM"].Value.ToString().Trim();
                    list.Add(JSONFormat.Format(sendM));
                }
            }
            if (isSelect == 0)
            {
                MessageUtil.ShowTips("请选择操作数据！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否新增请车？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp";
            ccp.MethodName = "doAdd";
            ccp.ServerParams = new object[] { list };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("新增请车成功！") || ccp.ReturnInfo.Equals("修改请车成功！"))
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                    posit = ugr.Cells["PLAN_YEAR_MONTH"].Text.Trim() + ugr.Cells["STATION_NO"].Text.Trim() + ugr.Cells["SPCL_LN_NO"].Text.Trim() + ugr.Cells["RECEIV_NO"].Text.Trim();
                    doQuery();
                }

            }

        }
        /// <summary>
        /// 取消请车
        /// </summary>
        private void doDelete()
        {
            ultraGrid1.UpdateData();
            UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            int isSelect = 0;
            ArrayList list1 = new ArrayList();
            if (ugr == null)
            {
                MessageUtil.ShowTips("无数据,不能进行此操作！");
                return;
            }
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    isSelect += 1;
                    if (!doQueryFalg(row)) return;
                    ArrayList list = new ArrayList();                
                    list.Add(row.Cells["ASK_MONTH_PK"].Text.Trim());
                    //list.Add(row.Cells["PLAN_YEAR_MONTH"].Text.Trim());
                    //list.Add(row.Cells["STATION_NO"].Text.Trim());
                    //list.Add(row.Cells["SPCL_LN_NO"].Text.Trim());
                    //list.Add(row.Cells["RECEIV_NO"].Text.Trim());
                    //list.Add(wflag);
                    list1.Add(list);
                }
            }
            if (isSelect == 0) { MessageUtil.ShowTips("请选择要操作的数据！"); return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否取消请车？") == DialogResult.No) return;

            int count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doDeleteAdd", new object[] { list1 }, ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("撤销请车成功！");
                doQuery();
            }

        }

        /// <summary>
        /// 修改
        /// </summary>
        private void doUpdate()
        {
            ultraGrid1.UpdateData();
            int isSelect = 0;//修改
            string strTime = DateTime.Now.ToString();
            ArrayList listUp = new ArrayList();
            UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
            {
                MessageUtil.ShowTips("无数据,不能进行此操作！");
                return;
            }
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    isSelect += 1;
                    //if (row.Cells["WAGONS_PLAN_NO"].Text.Trim() == "")
                    //{
                    //    MessageUtil.ShowTips("请输入车皮运号！");
                    //    return;
                    //}
                    if (row.Cells["BATCH_MONTH_NUM"].Text.Trim() == "")
                    {
                        MessageUtil.ShowTips("批复数不能为空！");
                        return;
                    }
                    if (!doQueryFalg(row)) return;
                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["WAGONS_PLAN_NO"].Value.ToString());
                    list.Add(row.Cells["BATCH_MONTH_NUM"].Value.ToString());
                    list.Add(this.UserInfo.GetUserName());
                    list.Add(strTime);
                    list.Add(row.Cells["ASK_MONTH_PK"].Value.ToString());
                    listUp.Add(list);
                }
            }
            if (isSelect == 0)
            {
                MessageUtil.ShowTips("请选择您要操作的记录！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.No) return;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp";
            ccp.MethodName = "doUpdate";
            ccp.ServerParams = new object[] { listUp };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips("修改成功！");
                posit = ugr.Cells["ASK_MONTH_PK"].Text.Trim();
                doQuery();
            }
        }

        /// <summary>
        /// 审批
        /// </summary>
        private void doApp()
        {
            ultraGrid1.UpdateData();
            ArrayList listUp = new ArrayList();
            UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null) return;
            int isSelect = 0;//修改，审批
            string strTime = DateTime.Now.ToString();
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    isSelect += 1;
                    pram.Clear();
                    pram.Add(row.Cells["ASK_MONTH_PK"].Value.ToString());
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doQueryFalg", new object[] { pram }, ob);
                    if (dt.Rows.Count > 0)
                    {
                        if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1"))
                        {
                            MessageUtil.ShowTips("你选中的记录已审批，请重新选择！");
                            return;
                        }
                        //if (dt.Rows[0]["WAGONS_PLAN_NO"].ToString().Equals(""))
                        //{
                        //    MessageUtil.ShowTips("您选择的记录未修改车皮运号,不能进行此操作！");
                        //    return;
                        //}
                        if (dt.Rows[0]["BATCH_MONTH_NUM"].ToString().Equals("0"))
                        {
                            MessageUtil.ShowTips("您选择的记录没有批复数,不能进行此操作！");
                            return;
                        }

                    }
                    else
                    {
                        MessageUtil.ShowTips("你选中的记录已不存在，请重新选择！");
                        return;
                    }
                    ArrayList list = new ArrayList();
                    list.Add(this.UserInfo.GetUserName());
                    list.Add(strTime);
                    list.Add(row.Cells["ASK_MONTH_PK"].Value.ToString());
                    listUp.Add(list);
                }
            }

            if (isSelect == 0)
            {
                MessageUtil.ShowTips("请选择您要操作的记录！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认审批？") == DialogResult.No) return;
            int count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doApp", new object[] { listUp }, ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("审批通过！");
                posit = ugr.Cells["ASK_MONTH_PK"].Text.Trim();
                doQuery();
            }
        }
        /// <summary>
        /// 取消审批
        /// </summary>
        private void doDeleteApp()
        {
            ArrayList listUp = new ArrayList();
            UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null) return;
            int isSelect = 0;//
            string strTime = DateTime.Now.ToString();
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    isSelect += 1;
                    pram.Clear();
                    pram.Add(row.Cells["ASK_MONTH_PK"].Value.ToString());
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doQueryFalg", new object[] { pram }, ob);
                    if (dt.Rows.Count > 0)
                    {
                        if (dt.Rows[0]["APP_FLAG"].ToString().Equals("0"))
                        {
                            MessageUtil.ShowTips("你选中的记录未审批，请重新选择！");
                            return;
                        }

                    }
                    else
                    {
                        MessageUtil.ShowTips("你选中的记录已不存在，请重新选择！");
                        return;
                    }
                    pram.Clear();
                    //pram.Add(row.Cells["ASK_MONTH_PK"].Value.ToString());
                    //pram.Add(row.Cells["SEND_PLAN_NO"].Value.ToString());
                    //DataTable dtAskDay = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doQueryDayFalg", new object[] { pram }, ob);
                    //if (dtAskDay.Rows.Count > 0)
                    //{
                    //    MessageUtil.ShowTips("该月请车批车号已做日请车,不能取消审批！");
                    //    return;
                    //}

                    ArrayList list = new ArrayList();
                    list.Add(this.UserInfo.GetUserName());
                    list.Add(strTime);
                    list.Add(row.Cells["ASK_MONTH_PK"].Value.ToString());
                    listUp.Add(list);
                }
            }

            if (isSelect == 0)
            {
                MessageUtil.ShowTips("请选择您要操作的记录！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认取消审批？") == DialogResult.No) return;
            int count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doDeleteApp", new object[] { listUp }, ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("取消审批成功！");
                posit = ugr.Cells["ASK_MONTH_PK"].Text.Trim();
                doQuery();
            }
        }


        /// <summary>
        /// 判断修改,审批条件
        /// </summary>
        /// <param name="ugr">选中的行ultraGrid1.ActiveRow</param>
        /// <returns>返回true之通过,flase不通过</returns>
        private bool doQueryFalg(UltraGridRow ugr)
        {
            if (ugr == null) return false;
            pram.Clear();
            pram.Add(ugr.Cells["ASK_MONTH_PK"].Value.ToString());
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doQueryFalg", new object[] { pram }, ob);
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1"))
                {
                    MessageUtil.ShowTips("你选中的记录已审批，请重新选择！");
                    return false;
                }
            }
            else
            {
                MessageUtil.ShowTips("你选中的记录已不存在，请重新选择！");
                return false;
            }

            return true;
        }

        /// <summary>
        /// 获取用户的销售组织权限
        /// </summary>
        /// <returns></returns>
        private string[] InitPermissions()
        {
            ArrayList list = new ArrayList();
            string[] userDptIds = this.ValidDataPurviewIds;
            for (int i = 0; i < userDptIds.Length; i++)
            {
                string userDptId = userDptIds[i];
                if (userDptId.Length < 6)
                {
                    if (!list.Contains("100101"))
                    {
                        list.Add("100101");
                    }
                    if (!list.Contains("100102"))
                    {
                        list.Add("100102");
                    }
                    if (!list.Contains("100103"))
                    {
                        list.Add("100103");
                    }
                    string[] strs = new string[list.Count];
                    for (int j = 0; j < list.Count; j++)
                    {
                        strs[j] = list[j].ToString();
                    }
                    return strs;
                }
                else
                {
                    if (userDptId.StartsWith("002002"))
                    {
                        if (!list.Contains("100102"))
                        {
                            list.Add("100102");
                        }
                    }
                    else
                    {
                        if (userDptId.Length < 9)
                        {
                            if (!list.Contains("100101"))
                            {
                                list.Add("100101");
                            }
                            if (!list.Contains("100103"))
                            {
                                list.Add("100103");
                            }
                        }
                        else
                        {
                            if (userDptId.StartsWith("002001004"))
                            {
                                if (!list.Contains("100101"))
                                {
                                    list.Add("100101");
                                }
                            }
                            else
                            {
                                if (!list.Contains("100103"))
                                {
                                    list.Add("100103");
                                }
                            }
                        }
                    }
                }
            }
            if (list.Count == 0)
            {
                return null;
            }
            else
            {
                string[] strs = new string[list.Count];
                for (int i = 0; i < list.Count; i++)
                {
                    strs[i] = list[i].ToString();
                }
                return strs;
            }

        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            ultraGrid2.UpdateData();
            UltraGridRow ugr = ultraGrid2.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            ArrayList list = new ArrayList();
            string spclno = "N";
            if (ugr.Cells["SPCL_LN_NO"].Text.Trim() != "") 
            {
                spclno = ugr.Cells["SPCL_LN_NO"].Text.Trim();
            }

            list.Add(ugr.Cells["PLAN_YEAR_MONTH"].Text.Trim());
            list.Add(ugr.Cells["STATION_NO"].Text.Trim());
            list.Add(spclno);
            list.Add(ugr.Cells["RECEIV_NO"].Text.Trim());
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.querySendPlanMat", new object[] { list,this.ValidDataPurviewIds }, this.ob);
            string[] _sendPlan = null;
            if (dt.Rows.Count > 0)
            {
                _sendPlan = new string[dt.Rows.Count];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    _sendPlan[i] = dt.Rows[i][0].ToString();
                }

                DataTable dtc = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.querySendPlanC", new object[] { _sendPlan }, this.ob);
                GridHelper.CopyDataToDatatable(ref dtc, ref dataTable5, true);
            }

           
        }

        /// <summary>
        /// Check选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Chk_CheckedChanged(object sender, EventArgs e)
        {
            if (ChcDelivyTime.Checked) { ComYear.Enabled = true; ComMonth.Enabled = true; } else { ComYear.Enabled = false; ComMonth.Enabled = false; }
            if (ChcStation.Checked) { ComStation.Enabled = true; } else { ComStation.Enabled = false; }
            if (ChcLine.Checked) { TxtLine.Enabled = true; } else { TxtLine.Enabled = false; }
            if (ChcOrderNo1.Checked) { TxtOrderNo1.Enabled = true; } else { TxtOrderNo1.Enabled = false; }
            if (ChcRecive.Checked) { ComRevice.Enabled = true; } else { ComRevice.Enabled = false; }

            if (chkFlag.Checked) { cmbAppFalg.Enabled = true; } else { cmbAppFalg.Enabled = false; }
            if (ultraCheckEditor5.Checked) { StratTime.Enabled = true; EndTime.Enabled = true; } else { StratTime.Enabled = false; EndTime.Enabled = false; }
            if (ChkAskMonth.Checked) { txtAskMonth.Enabled = true; } else { txtAskMonth.Enabled = false; }
        }


        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("App")) { toolMenu.Toolbars[0].Tools["App"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("DeleteApp")) { toolMenu.Toolbars[0].Tools["DeleteApp"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
            else
            {
                if (toolMenu.Toolbars[0].Tools.Exists("App")) { toolMenu.Toolbars[0].Tools["App"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("DeleteApp")) { toolMenu.Toolbars[0].Tools["DeleteApp"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True; }
            }
        }

        private void frmShipmentApp_Shown(object sender, EventArgs e)
        {
            if (toolMenu.Toolbars[0].Tools.Exists("App")) { toolMenu.Toolbars[0].Tools["App"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("DeleteApp")) { toolMenu.Toolbars[0].Tools["DeleteApp"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; }
            
        }

        private void ultraGrid2_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            //try
            //{
            //    ultraGrid2.UpdateData();

            //    foreach (UltraGridRow r in ultraGrid2.Rows)
            //    {
            //        r.Cells["CHK"].Value = r.Selected;
            //    }
            //}
            //catch { }
            foreach (UltraGridRow uRow in ultraGrid2.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
        }

        /// <summary>
        /// 自动生成请车批车号
        /// </summary>
        private void doAskMonthNo() 
        {
            string strTallyLoad = "";
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentApp.doQueryAskMonth", new object[] { DateTime.Now.ToString("yyyy-MM") }, ob);
            if (dt.Rows.Count <= 0)
            {
                strTallyLoad = DateTime.Now.ToString("yyyyMM") + "001";
            }
            else
            {
                string dtAsk = dt.Rows[0]["ASK_MONTH_NO"].ToString();
                string AskMonth = dtAsk.Substring(6, 3);
                string strLsh = "";//流水号
                if (double.Parse(AskMonth) < 9)
                {
                    strLsh = "00" + Convert.ToDouble(double.Parse(AskMonth) + 1).ToString();
                }
                else if (double.Parse(AskMonth) < 99)
                {
                    strLsh = "0" + Convert.ToDouble(double.Parse(AskMonth) + 1).ToString();
                }
                else
                {
                    strLsh = Convert.ToDouble(double.Parse(AskMonth) + 1).ToString();
                }
                strTallyLoad = DateTime.Now.ToString("yyyyMM") + strLsh;
            }
            DataTable dt2 = (DataTable)ComAskMonth.DataSource;
            Object[] obj = new Object[] { strTallyLoad };
            DataRow dr = dt2.NewRow();
            dr.ItemArray = obj;
            if (dt2.Rows.Count > 0)
            {
                if (strTallyLoad != dt2.Rows[0]["ASK_MONTH_NO"].ToString())
                {
                    dt2.Rows.InsertAt(dr, 0);
                }
            }
            else
            {
                dt2.Rows.InsertAt(dr, 0);
            }
            ComAskMonth.SelectedIndex = 0;
        }

        private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            //try
            //{
            //    ultraGrid1.UpdateData();

            //    foreach (UltraGridRow r in ultraGrid1.Rows)
            //    {
            //        r.Cells["CHK"].Value = r.Selected;
            //    }
            //}
            //catch { }
            foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
        }

        /// <summary>
        /// 按回车键触发查询按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ContPublic_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter) 
            {
                doQuery();
            }
        }

    }
}