MES_Client/TGMES/Core.StlMes.Client.PipeLeaveFactory/01.出厂计划/frmShipmentDayApp.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.YdmObject;
using Core.Mes.Client.Comm.Format;
using Core.StlMes.Client.PipeLeaveFactory.Tool;
using Infragistics.Win;

namespace Core.StlMes.Client.PipeLeaveFactory
{
    public partial class frmShipmentDayApp : FrmBase
    { 

        /// <summary>
        /// 用户销售组织权限
        /// </summary>
        private string[] _salgPermissions = null;
        private string posit = "";//定位
        ArrayList pram = new ArrayList();

        private string departid;//对应部门ID
        private string departname;//对应部门
        private string management_no;//对应科室id
        private string management_name;//对应科室

        public frmShipmentDayApp()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void frmShipmentDayApp_Load(object sender, EventArgs e)
        {
            ClsBaseInfo.SetComboItemHeight(cmbAppFalg);

            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天

            billNoStime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            BillNoEtime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            DelvryTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            _salgPermissions = InitPermissions();
            EntityHelper.ShowGridCaption<YdmZcBillCEntity>(ultraGridBillC.DisplayLayout.Bands[0]);

            //收货单位
            BaseHelper.InitOrderUnit(ComRevice, _salgPermissions, this.ob);
            //专用线
            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);
            InAskDay();


            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 InAskDay()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryAskDay", new object[] { DateTime.Now.ToString("yyyy-MM-dd") }, ob);
            ComAskDay.DataSource = dt;
            ComAskDay.ValueMember = "ASK_DAY_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 strStrattime = "";
                string strEndtime = "";
                string strAskDay = "";
                if (chkDate.Checked)
                {
                    strStrattime = DelvryTime.Value.ToString(); strEndtime = EndTime.Value.ToString();
                    if (DateTime.Parse(DelvryTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString()))
                    {
                        MessageUtil.ShowTips("您所选择时间区间不正确，请重新选择！");
                        return;
                    }
                }
                if (chkFlag.Checked)
                {
                    strFalg = cmbAppFalg.Value.ToString();
                }
                if (ChkAskDay.Checked)
                {
                    if (txtAskDay.Text.Trim() == "")
                    {
                        MessageUtil.ShowTips("日请车批车不能为空！");
                        return;
                    }
                    strAskDay = txtAskDay.Text.Trim();
                }
                pram.Clear();
                pram.Add(strAskDay);
                pram.Add(strFalg);
                pram.Add(strStrattime); pram.Add(strStrattime); pram.Add(strStrattime);
                pram.Add(strEndtime); pram.Add(strEndtime);
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.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_DAY_PK"].Value.ToString();
                    if (strindex == posit)
                    {
                        UltraGridRow row = ultraGrid1.Rows[i];
                        row.Activate();
                    }
                }
            }
            else 
            {
                ArrayList param = new ArrayList();
                string BillStartTime = "";
                string BillEndTime = "";
                if (ChcBillTime.Checked)
                {
                    BillStartTime = billNoStime.Value.ToString(); BillEndTime = BillNoEtime.Value.ToString();
                    if (DateTime.Parse(BillStartTime) > DateTime.Parse(BillEndTime))
                    {
                        MessageUtil.ShowTips("您所选择时间区间不正确，请重新选择！");
                        return;
                    }
                }
                string order="";
                if (ChcOrderNo1.Checked) { order = TxtOrderNo1.Text.Trim(); }
                //string status = "";
                //if (ChcStatus.Checked) { status = ComStatus.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 reciveNm = "";
                if (ChcRecive.Checked) { reciveNm = ComRevice.Text.Trim(); }
                param.Add(BillStartTime);
                param.Add(BillStartTime);
                param.Add(BillStartTime);
                param.Add(BillEndTime);
                param.Add(BillEndTime);
                param.Add(order);
                param.Add(station);
                param.Add(spcl);
                param.Add(reciveNm);
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryBilM", new object[] { param, this.ValidDataPurviewIds }, this.ob);
                GridHelper.CopyDataToDatatable(ref dt, ref BillTable, true);
                if (dt.Rows.Count <=0)
                {
                    List<YdmZcBillCEntity> listBillC = EntityHelper.GetData<YdmZcBillCEntity>("com.steering.pss.ydm.pipeleavefactory.FrmPipeTrainBill.queryBillC", new object[] { "" }, this.ob);
                    ydmZcBillCEntityBindingSource.DataSource = listBillC;
                }

                for (int i = 0; i < ultraGridBillM.Rows.Count; i++)
                {
                    string strindex = ultraGridBillM.Rows[i].Cells["BILL_NO"].Value.ToString();
                    if (strindex == posit)
                    {
                        UltraGridRow row = ultraGridBillM.Rows[i];
                        row.Activate();
                    }
                }
                InAskDay();
                ComAskDay.Text = "";
            }
            posit = "";
        }
        /// <summary>
        /// 新增日请车
        /// </summary>
        private void doAdd()
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null) { MessageUtil.ShowTips("无数据，不能进行此操作！"); return; }
            int isSelect = 0;
            ArrayList list = new ArrayList();
            string strTime = DateTime.Now.ToString();
            string askDay = "";
            if (ComAskDay.Text.Trim() == "") 
            {
                doAskDayNo();
            }
            askDay = ComAskDay.Text.Trim();
            foreach (UltraGridRow row in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    isSelect += 1;
                    if (row.Cells["VEHICLE_DAY_NUM"].Text.Trim() == "0" || row.Cells["VEHICLE_DAY_NUM"].Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("请输日请车数！");
                        return;
                    }
                    string spclNo = "N";
                    if (!row.Cells["SPCL_LN_NO"].Value.ToString().Equals(""))
                    {
                        spclNo = row.Cells["SPCL_LN_NO"].Value.ToString();
                    }
                     pram.Clear();
                     pram.Add(askDay);
                     pram.Add(row.Cells["ASK_MONTH_NO"].Value.ToString());
                     pram.Add(row.Cells["BILL_NO"].Value.ToString());
                     pram.Add(row.Cells["STATION_NO"].Value.ToString());
                     pram.Add(spclNo);
                     pram.Add(row.Cells["RECEIV_NO"].Value.ToString());
                     DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalg", new object[] { pram }, ob);
                     if (dt.Rows.Count > 0)
                     {
                         if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1"))
                         {
                             MessageUtil.ShowTips("您要请车的该条数据已日请车审批，请重新选择！");
                             return;
                         }
                     }
                    YdmZcAskDayEntity ydm = new YdmZcAskDayEntity();
                    ydm.AskDayNo = askDay;
                    ydm.AskMonthNo = row.Cells["ASK_MONTH_NO"].Text.Trim();
                    ydm.BillNo = row.Cells["BILL_NO"].Text.Trim();
                    ydm.WagonsPlanNo = row.Cells["WAGONS_PLAN_NO"].Text.Trim();

                    ArrayList listmonth = new ArrayList();
                    listmonth.Add(row.Cells["ASK_MONTH_NO"].Text.Trim());
                    listmonth.Add(row.Cells["BILL_NO"].Value.ToString());
                    listmonth.Add(row.Cells["STATION_NO"].Text.Trim());
                    listmonth.Add(spclNo);
                    listmonth.Add(row.Cells["RECEIV_NO"].Text.Trim());
                    DataTable dtDay = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryDayAsk", new object[] { listmonth }, this.ob);
                    string strwaflag = "1";
                    if (dtDay.Rows.Count > 0)
                    {
                        if (dtDay.Rows[0]["ASK_DAY_NO"].ToString() != askDay)
                        {
                            //if (MessageUtil.ShowYesNoAndQuestion("该请车记录已存在,是否继续添加补充请车？") == DialogResult.No) return;
                            strwaflag = "2";
                        }
                    }
                    ydm.WagonsFlag = strwaflag;
                    ydm.SpclLnNm = row.Cells["SPCL_LN_NM"].Text.Trim();
                    ydm.SpclLnNo = row.Cells["SPCL_LN_NO"].Text.Trim();
                    ydm.StationNm = row.Cells["STATION_NM"].Text.Trim();
                    ydm.StationNo = row.Cells["STATION_NO"].Text.Trim();
                    ydm.ReceivNm = row.Cells["RECEIV_NM"].Text.Trim();
                    ydm.ReceivNo = row.Cells["RECEIV_NO"].Text.Trim();
                    ydm.PurName = this.UserInfo.GetUserName();
                    ydm.PurTime = strTime;
                    ydm.DepartmentCode = departid;
                    ydm.DepartmentDesc = departname;
                    ydm.ManagementName = management_name;
                    ydm.ManagementNo = management_no;
                    ydm.CreateName = this.UserInfo.GetUserName();
                    ydm.CreateTime = strTime;
                    ydm.VehicleDayNum = row.Cells["VEHICLE_DAY_NUM"].Text.Trim();
                    ydm.Memo = row.Cells["MEMODAY"].Text.Trim();
                    ydm.SendPlanNo = row.Cells["ASK_MONTH_PK"].Value;//月请车PK值
                    list.Add(JSONFormat.Format(ydm));
                }
            }
            if (isSelect==0) 
            {
                MessageUtil.ShowTips("请选择要操作的数据！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否新增日请车？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp";
            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["BILL_NO"].Text.Trim();
                    doQuery();
                }

            }

        }
        /// <summary>
        /// 取消日请车
        /// </summary>
        private void doDelete()
        {
            ultraGrid1.UpdateData();
            UltraGridRow ugr = ultraGrid1.ActiveRow;
            if (ugr == null) { MessageUtil.ShowTips("无数据，不能进行此操作！"); return; }
            int isSelect = 0;
            ArrayList list1 = new ArrayList();
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    isSelect += 1;
                    pram.Clear();
                    pram.Add(row.Cells["ASK_DAY_PK"].Value.ToString());
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalgAsk", new object[] { pram }, ob);
                    if (dt.Rows.Count > 0)
                    {
                        if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1"))
                        {
                            MessageUtil.ShowTips("您选择的该条数据已日请车审批，请重新选择！");
                            return;
                        }
                    }
                   
                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["ASK_DAY_PK"].Value.ToString());
                    list1.Add(list);
                }
            }
            if (isSelect == 0)
            {
                MessageUtil.ShowTips("请选择要操作的数据！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否取消日请车？") == DialogResult.No) return;

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


        }

        /// <summary>
        /// 修改
        /// </summary>
        private void doUpdate()
        {
            ultraGrid1.UpdateData();
            ArrayList listUp = new ArrayList();
            UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null) return;
            int isSelect = 0;//修改，审批
            string strtime = "";
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text)==true)
                {
                    isSelect += 1;
                    if (!doQueryFalg(row)) return;
                    if (row.Cells["BATCH_DAY_NUM"].Value.ToString() == "")
                    {
                        MessageUtil.ShowTips("批复数不能为空,请重新输入！");
                        return;
                    }

                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["BATCH_DAY_NUM"].Value.ToString());
                    list.Add(row.Cells["ACT_DAY_60NUM"].Value.ToString());
                    list.Add(row.Cells["ACT_DAY_70NUM"].Value.ToString());
                    list.Add(this.UserInfo.GetUserName());
                    list.Add(strtime);
                    list.Add(row.Cells["ASK_DAY_PK"].Text.Trim());
                    listUp.Add(list);
                }
            }
            if (isSelect == 0)
            {
                MessageUtil.ShowTips("请选择您要操作的记录！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.No) return;
            int count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doUpdate", new object[] { listUp }, ob);
            if(count>0)
            {
                MessageUtil.ShowTips("修改成功！");
                posit = ugr.Cells["ASK_DAY_PK"].Text.Trim();
                doQuery();
            }
          
        }

        /// <summary>
        /// 审批
        /// </summary>
        private void doApp()
        {
            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_DAY_PK"].Value.ToString());
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalgAsk", 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]["BATCH_DAY_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_DAY_PK"].Value.ToString());

                    string spcl = "N";
                    if (!row.Cells["SPCL_LN_NO"].Value.ToString().Equals(""))
                    {
                        spcl = row.Cells["SPCL_LN_NO"].Value.ToString();
                    }
                    list.Add(row.Cells["BATCH_DAY_NUM"].Value.ToString());
                    list.Add(row.Cells["STATION_NO"].Value.ToString());
                    list.Add(spcl);
                    list.Add(row.Cells["RECEIV_NO"].Value.ToString());
                    list.Add(row.Cells["ASK_MONTH_NO"].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.FrmShipmentDayApp.doApp", new object[] { listUp }, ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("审批通过！");
                posit = ugr.Cells["ASK_DAY_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_DAY_PK"].Value.ToString());
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalgAsk", new object[] { pram }, ob);
                    if (dt.Rows.Count > 0)
                    {
                        if (dt.Rows[0]["APP_FLAG"].ToString().Equals("0"))
                        {
                            MessageUtil.ShowTips("您选中的记录未审批，请重新选择！");
                            return;
                        }
                        if (double.Parse(dt.Rows[0]["ACT_DAY_NUM"].ToString()) > 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_DAY_PK"].Value.ToString());

                    string spcl = "N";
                    if (!row.Cells["SPCL_LN_NO"].Value.ToString().Equals(""))
                    {
                        spcl = row.Cells["SPCL_LN_NO"].Value.ToString();
                    }
                    list.Add(row.Cells["BATCH_DAY_NUM"].Value.ToString());
                    list.Add(row.Cells["STATION_NO"].Value.ToString());
                    list.Add(spcl);
                    list.Add(row.Cells["RECEIV_NO"].Value.ToString());
                    list.Add(row.Cells["ASK_MONTH_NO"].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.FrmShipmentDayApp.doDeleteApp", new object[] { listUp }, ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("取消成功！");
                posit = ugr.Cells["ASK_DAY_PK"].Text.Trim();
                doQuery();
            }
        }

        /// <summary>
        /// 判断修改,审批条件
        /// </summary>
        /// <param name="ugr">选中的行ultraGrid1.ActiveRow</param>
        /// <returns>返回true之通过,flase不通过</returns>
        private bool doQueryFalg(UltraGridRow ugr) 
        {
            pram.Clear();
            pram.Add(ugr.Cells["ASK_DAY_PK"].Value.ToString());
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalgAsk", new object[] { pram }, ob);
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1"))
                {
                    MessageUtil.ShowTips("您选中的记录已审批，请重新选择！");
                    return false;
                }
                if (ugr.Cells["BATCH_DAY_NUM"].Text=="")
                {
                    MessageUtil.ShowTips("批复数不能为空,不能进行此操作！");
                    return false;
                }
                if (double.Parse(dt.Rows[0]["VEHICLE_DAY_NUM"].ToString()) < double.Parse(ugr.Cells["BATCH_DAY_NUM"].Value.ToString()))
                {
                    MessageUtil.ShowTips("您输入的批复数大于日请车数,不能进行此操作！");
                    return false;
                }
            }
            else 
            {
                MessageUtil.ShowTips("您选中的记录已不存在，请重新选择！");
                return false;
            }
            return true;       
        } 

        /// <summary>
        ///  Check选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Chk_CheckedChanged(object sender, EventArgs e)
        {
            if (chkDate.Checked) { DelvryTime.Enabled = true; EndTime.Enabled = true; } else { DelvryTime.Enabled = false; EndTime.Enabled = false; }
            if (chkFlag.Checked) { cmbAppFalg.Enabled = true; } else { cmbAppFalg.Enabled = false; }
            if (ChkAskDay.Checked) { txtAskDay.Enabled = true; } else { txtAskDay.Enabled = false; }
            if (ChcBillTime.Checked) { billNoStime.Enabled = true; BillNoEtime.Enabled = true; } else { billNoStime.Enabled = false; BillNoEtime.Enabled = false; }
            if (ChcOrderNo1.Checked) { TxtOrderNo1.Enabled = true; } else { TxtOrderNo1.Enabled = false; }
            //if (ChcStatus.Checked) { ComStatus.Enabled = true; } else { ComStatus.Enabled = false; }
            if (ChcStation.Checked) { ComStation.Enabled = true; } else { ComStation.Enabled = false; }
            if (ChcLine.Checked) { TxtLine.Enabled = true; } else { TxtLine.Enabled = false; }
            if (ChcRecive.Checked) { ComRevice.Enabled = true; } else { ComRevice.Enabled = false; }
        }
        /// <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 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;
                }
            }
        }

        private void ultraGridBillM_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            List<YdmZcBillCEntity> listBillC = EntityHelper.GetData<YdmZcBillCEntity>("com.steering.pss.ydm.pipeleavefactory.FrmPipeTrainBill.queryBillC", new object[] { ugr.Cells["BILL_NO"].Text }, this.ob);
            ydmZcBillCEntityBindingSource.DataSource = listBillC;
            
        }

        /// <summary>
        ///  日请车批车号
        /// </summary>
        private void doAskDayNo() 
        {
            string strTallyLoad = "";
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryAskDay", new object[] { DateTime.Now.ToString("yyyy-MM-dd") }, ob);
            if (dt.Rows.Count <= 0)
            {
                strTallyLoad = DateTime.Now.ToString("yyyyMMdd") + "001";
            }
            else
            {
                string dtAsk = dt.Rows[0]["ASK_DAY_NO"].ToString();
                string AskDay = dtAsk.Substring(8, 3);
                string strLsh = "";//流水号
                if (double.Parse(AskDay) < 9)
                {
                    strLsh = "00" + Convert.ToDouble(double.Parse(AskDay) + 1).ToString();
                }
                else if (double.Parse(AskDay) < 99)
                {
                    strLsh = "0" + Convert.ToDouble(double.Parse(AskDay) + 1).ToString();
                }
                else
                {
                    strLsh = Convert.ToDouble(double.Parse(AskDay) + 1).ToString();
                }
                strTallyLoad = DateTime.Now.ToString("yyyyMMdd") + strLsh;
            }
            DataTable dt2 = (DataTable)ComAskDay.DataSource;
            Object[] obj = new Object[] { strTallyLoad };
            DataRow dr = dt2.NewRow();
            dr.ItemArray = obj;
            if (dt2.Rows.Count > 0)
            {
                if (strTallyLoad != dt2.Rows[0]["ASK_DAY_NO"].ToString())
                {
                    dt2.Rows.InsertAt(dr, 0);
                }
            }
            else
            {
                dt2.Rows.InsertAt(dr, 0);
            }
            ComAskDay.SelectedIndex = 0;
        }
        private void ultraGridBillM_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            //try
            //{
            //    ultraGridBillM.UpdateData();

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

        }

        /// <summary>
        /// Grid内置按钮点击
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridBillM_ClickCellButton(object sender, CellEventArgs e)
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;

            string statin = ugr.Cells["STATION_NO"].Value.ToString();
            string receiv = ugr.Cells["RECEIV_NO"].Value.ToString();
            string spLine = ugr.Cells["SPCL_LN_NO"].Value.ToString();
            FrmPleDayCar fpdc = new FrmPleDayCar(statin, receiv, spLine, ob);
            fpdc.AutoSize = true;
            fpdc.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fpdc.Text = "月请车信息";
            fpdc.ShowDialog();
            if (fpdc.DialogResult == System.Windows.Forms.DialogResult.OK)
            {
                //获取弹出窗体的属性值
                ugr.Cells["ASK_MONTH_NO"].Value = fpdc.AskMonth;
                ugr.Cells["WAGONS_PLAN_NO"].Value = fpdc.Wagons;
                ugr.Cells["VEHICLE_MONTH_NUM"].Value = fpdc.VelMonth;
                ugr.Cells["BATCH_MONTH_NUM"].Value = fpdc.BathMonth;
                ugr.Cells["WAGONS_FLAG"].Value = fpdc.Wagflag;
                ugr.Cells["ACT_MONTH_NUM"].Value = fpdc.ActMonthNum;
                ugr.Cells["ASK_MONTH_PK"].Value = fpdc.AskDayNoPk;
                
            }

        }

        /// <summary>
        /// Grid列内容改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridBillM_CellChange(object sender, CellEventArgs e)
        {

            if (e.Cell.Column.Key.Equals("VEHICLE_DAY_NUM")) 
            {
                if (e.Cell.Row.Cells["BATCH_MONTH_NUM"].Text.Equals(""))
                {
                    MessageUtil.ShowTips("月批复数不能为空！");
                    e.Cell.Row.Cells["VEHICLE_DAY_NUM"].Value = "0";
                    return;
                }
            }
        }

        /// <summary>
        /// 初始化隐藏按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void frmShipmentDayApp_Shown(object sender, EventArgs e)
        {
            if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].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("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; }
        }

        /// <summary>
        /// 切换Tab隐藏按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (e.Tab.TabControl.SelectedTab.Key.Equals("0"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].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("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; }

            }
            else
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].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("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; }
            }
        }

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