MES_Client/TGMES/Core.StlMes.Client.PipeLeaveFactory/02.发货作业/frmTallYsheet.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 Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.StlMes.Client.YdmBase;
using System.Text.RegularExpressions;
using Infragistics.Win;
using Core.StlMes.Client.YdmPipeManage.Tool;
using Core.StlMes.Client.SaleOrder.ReviewForm;
using Core.StlMes.Client.YdmPipeManage;

namespace Core.StlMes.Client.PipeLeaveFactory
{
    public partial class frmTallYsheet : FrmBase
    {
        /// <summary>
        /// 获取仓库权限
        /// </summary>
        private string[] _storagerPur;
        private string departid;//对应部门ID
        private string departname;//对应部门
        private string management_no;//对应科室id
        private string management_name;//对应科室
        private string batchDay = "";//日批复数
        private string velDay = "";//日申请数
        private string appflag = "";//是否审批
        private string askMonth = "";
        private string sendPlan = "";
        private string wagPlan = "";
        private double carPlan = 0;

        public frmTallYsheet()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }
        private void frmTallYsheet_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            StratBillTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            EndBillTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            SendStratTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            SendEndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            InComboAll();
            management_no = this.UserInfo.GetDeptid();
            management_name = this.UserInfo.GetDepartment();
            departid = ClsBaseInfo.GetDepartIdBySectionId(UserInfo.GetDeptid(), this.ob);
            departname = ClsBaseInfo.GetDepartBySectionId(UserInfo.GetDeptid(), this.ob);
            //if(!this.CustomInfo.Equals("120504"))
            //{
            //    this.GridBill.DisplayLayout.Bands[0].Columns["LocationName"].Hidden = true;
            //}
            if (this.CustomInfo == "120504")
            {
                labelText.Visible = true;
                labelText.Text = "总计：";
                ultraExpandableGroupBox1.Visible = true;
                
                queryCarTare();
                //列自适应
                GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            else
            {
                labelText.Visible = false;
                ultraExpandableGroupBox1.Visible = false;
            }


        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Key.Equals("0"))
                    {
                        doQueryAll();
                    }
                    else if (ultraTabControl1.SelectedTab.Key.Equals("1"))
                    {
                        doQuerySend();
                    }
                    break;
                case "Add":
                    doAdd();
                    break;
                case "DeleteAll":// 整单作废
                    doDeleteAll();
                    break;
                case "Refresh"://刷新
                    doRefresh();
                    break;
                case "Export"://导出
                    GridHelper.ulGridToExcel(GridBill, "理货编制");
                    break;
                case "BillPrint":
                    doBillPrint();
                    break;
                case "Print":
                    Print();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 提单打印
        /// </summary>
        private void Print()
        {
            string billNo = "";
            int count = 0;
            foreach (UltraGridRow row in GridBill.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHOOSE"].Text) == true)
                {
                    count += 1;
                    billNo = row.Cells["BILL_NO"].Text.Trim();
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要打印的提货单号！");
                return;
            }
            if (count > 1)
            {
                MessageUtil.ShowTips("请勾选一个提货单号打印！");
                return;
            }
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeBillOfLadingClose.getBillStatus", new Object[] { billNo }, this.ob);
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["BILL_STATUS"].ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("该提单是编制状态，请下发之后再打印提单！");
                    return;
                }
            }
            string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepYdmBillCar.cpt&op=view" + "&billno=" + billNo;


            FrmDocPrintExcel fBug = new FrmDocPrintExcel(ob, strurl);

            fBug.AutoSize = true;
            fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            // fBug.WindowState = FormWindowState.Maximized;
            fBug.Text = "提货单打印";
            fBug.ShowDialog();
            doQueryAll();

        }

        private void doBillPrint()
        {
            string TallyNo = "";
            UltraGridRow ugr = this.ultraGrid3.ActiveRow;
            if (ugr == null) { MessageUtil.ShowTips("无数据，请确认！"); return; }
            TallyNo = ugr.Cells["TALLYSHEET_NO"].Text.Trim();

            string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepYdmTallysheet.cpt&op=view" + "&no=" + TallyNo;


            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

            ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.updatePintFlag", new object[] { time, TallyNo, ugr.Cells["BILL_NO"].Text.Trim() }, ob);

            FrmDocPrintExcel fBug = new FrmDocPrintExcel(ob, strurl);

            fBug.AutoSize = true;
            fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            //fBug.WindowState = FormWindowState.Maximized;
            fBug.Text = "理货单打印";
            fBug.ShowDialog();
            doQuerySend();
        }
        /// <summary>
        /// 加载Combo绑定数据
        /// </summary>
        private void InComboAll()
        {
            //客户信息
            //YdmBaseClass.InitComboEditor(cmbCustomer, "com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryCustomer", "CUSTOMER_NO", ob, false);
            _storagerPur = BaseMethod.WarehousePermissions("", this.ValidDataPurviewIds, ob);

            BaseMethod.InitStorage(cmbStorager, "", this.ValidDataPurviewIds, ob);
            BaseMethod.InitStorage(cmbStoragerTally, "", this.ValidDataPurviewIds, ob);
            ////承运单位
            //DataTable dtCarrierUnit = ClsBaseInfo.GetComBaseInfo("1109", ob);
            //if (dtCarrierUnit != null && dtCarrierUnit.Rows.Count > 0)
            //{
            //    Object[] obj = new Object[] { "", "" };
            //    DataRow dr = dtCarrierUnit.NewRow();
            //    dr.ItemArray = obj;
            //    dtCarrierUnit.Rows.InsertAt(dr, 0);
            //}
            //cmbCarrierUnit.DataSource = dtCarrierUnit;
            //cmbCarrierUnit.DisplayMember = "BASENAME";
            //cmbCarrierUnit.ValueMember = "BASECODE";


            DataTable dtCarrierUnit = ServerHelper.GetData("com.steering.pss.ydm.base.WarehousePermissions.getTransUnit", new object[] { }, ob);
            if (dtCarrierUnit != null && dtCarrierUnit.Rows.Count > 0)
            {
                Object[] obj = new Object[] { "", "" };
                DataRow dr = dtCarrierUnit.NewRow();
                dr.ItemArray = obj;
                dtCarrierUnit.Rows.InsertAt(dr, 0);
            }
            cmbCarrierUnit.DataSource = dtCarrierUnit;
            cmbCarrierUnit.DisplayMember = "CARRIER_NAME";
            cmbCarrierUnit.ValueMember = "CARRIER_CODE"; 
            
            ClsBaseInfo.SetComboItemHeight(cmbCarrierUnit);

            ClsBaseInfo.SetComboItemHeight(cmbProvin);

            ClsBaseInfo.SetComboItemHeight(cmbType);

            ClsBaseInfo.SetComboItemHeight(cmbStatus);

        }
        /// <summary>
        /// 查询理货信息
        /// </summary>
        private void doQuerySend()
        {
            ArrayList list = new ArrayList();

            string strStart = "";//开始时间
            string strEnt = "";//结束时间
            string strSend = "";
            string storager = "";
            string strBill = "";
            if (chkStoragerTally.Checked && string.IsNullOrEmpty(cmbStoragerTally.Text.Trim()))
            {
                MessageBox.Show("请选择仓库！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (chkStoragerTally.Checked)
            {
                storager = cmbStoragerTally.Value.ToString();
            }
            if (DataTimeUtil.JudgeTime(DateTime.Parse(SendStratTime.Value.ToString()), DateTime.Parse(SendEndTime.Value.ToString())) == 0)
            {
                MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                return;
            }
            if (chkSendList.Checked && string.IsNullOrEmpty(txtSend.Text.Trim()))
            {
                MessageBox.Show("请输入理货单号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (chkTalBill.Checked && string.IsNullOrEmpty(txtTalBill.Text.Trim()))
            {
                MessageBox.Show("请输入提货单号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (chktime.Checked)
            {
                strStart = SendStratTime.Value.ToString();
                strEnt = SendEndTime.Value.ToString();
            }
            if (chkSendList.Checked)
            {
                strSend = txtSend.Text.Trim();
            }
            if (chkTalBill.Checked) { strBill = txtTalBill.Text.Trim(); }
            string strStata = "";
            if (chkStarta.Checked) { strStata = cmbStarta.Value.ToString(); }

            list.Add(strStart);
            list.Add(strStart);
            list.Add(strStart);
            list.Add(strEnt);
            list.Add(strEnt);
            list.Add(strSend);
            list.Add(strBill);

            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryPerformance", new object[] { list, _storagerPur, storager, strStata }, ob);
            GridHelper.CopyDataToDatatable(dt, this.dataBiList, true);
            if (dt.Rows.Count == 0)
            {
                GridHelper.ClearGridDataSourceData(GridCar);
                GridHelper.ClearGridDataSourceData(ultraGrid1);
            }
        }

        /// <summary>
        /// 查询提单信息
        /// </summary>
        private void doQueryAll()
        {
            if (!ValidQuery()) return;
            ArrayList list = new ArrayList();
            string strStartTime = "";//开始时间
            string strEntTime = "";//结束时间
            string strType = "";//出厂方式
            string strStatus = "";
            string strStoager = "";//仓库
            string strBill = "";//提单号
            string strCustomer = "";//客户
            string strOrder = "";
            string strLuJuse = "";//炉号

            if (chkType.Checked)
            {
                strType = cmbType.Value.ToString();
            }
            if (chkCustomer.Checked)
            {
                strCustomer = txtCustomer.Text.Trim();
            }

            if (chkBillList.Checked)
            {
                strBill = txtBillList.Text.Trim();
            }
            if (chkStrong.Checked) { strStoager = cmbStorager.Value.ToString(); }
            if (chkBillDate.Checked)
            {
                strStartTime = StratBillTime.Value.ToString();
                strEntTime = EndBillTime.Value.ToString();
            }
            if (chkBillType.Checked)
            {
                strStatus = cmbStatus.Value.ToString();
            }
            else
            {
                strStatus = "0";
            }
            if (chkOrder.Checked)
            {
                strOrder = txtOrderNo.Text.Trim();
            }
            if (chkLu.Checked)
            {
                strLuJuse = txtLuJudge.Text.Trim();
            }


            list.Clear();
            list.Add(strBill);
            list.Add(strCustomer);
            list.Add(strType);
            list.Add(strStoager);
            list.Add(strStartTime);
            list.Add(strEntTime);
            list.Add(strOrder);
            list.Add(strLuJuse);
            DataTable dtBill = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryBillInfo", new object[] { list, strStatus, _storagerPur,this.CustomInfo }, ob);
            GridHelper.CopyDataToDatatable(dtBill, this.dataBill, true);
            this.dataBill.AcceptChanges();
            foreach (UltraGridRow ugr in GridBill.Rows)
            {
                if (ugr.Cells["PLAN_TRANS_TYPE"].Text.Trim().Equals("铁运"))
                {
                    if (ugr.Cells["STORAGE_NO"].Text.Trim() != ugr.Cells["VSTEL"].Text.Trim())
                    {
                        for (int i = 0; i < _storagerPur.Length; i++)
                        {

                            if (_storagerPur[i].ToString() == ugr.Cells["VSTEL"].Text.Trim())
                            {
                                ugr.Cells["VSTEL_DESC"].Appearance.BackColor = Color.FromArgb(224, 224, 224);
                                ugr.Cells["VSTEL_DESC"].Appearance.BackHatchStyle = BackHatchStyle.None;
                                ugr.Cells["VSTEL_DESC"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                                ugr.Cells["VSTEL_DESC"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Button;
                            }
                            else
                            {
                                ugr.Cells["STORAGE_NAME"].Appearance.BackColor = Color.FromArgb(224, 224, 224);
                                ugr.Cells["STORAGE_NAME"].Appearance.BackHatchStyle = BackHatchStyle.None;
                                ugr.Cells["STORAGE_NAME"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                                ugr.Cells["STORAGE_NAME"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Button;
                            }

                        }                       
                    }
                }
            }

            listView1.Items.Clear();
            txtSendList.Text = "";
            txtAskPlanID.Text = "";
            cmbCarrierUnit.Text = "";
            cmbTranWagOn.Text = "";
            cmbProvin.Text = "";
            comCarType.Text = "";
            txtAskDay.Text = "";
        }
        /// <summary>
        /// 新增操作
        /// </summary>
        ///       
        private void doAdd()
        {
            ArrayList addList = new ArrayList();
            ArrayList pram = new ArrayList();
            UltraGridRow ugrBill = this.GridBill.ActiveRow;
            int conut = 0;
            string sendTall = "";
            double batchDayVar = carPlan;
            string sfjl = ""; // 是否计量预报
            if (string.IsNullOrEmpty(txtSendList.Text.Trim()))
            {
                AutSendList();
            }
            sendTall = txtSendList.Text.Trim();

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in GridBill.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {

                    conut += 1;
                    ArrayList list = new ArrayList();
                    list.Add(uRow.Cells["BILL_NO"].Text.Trim());
                    DataTable dtLadType = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryBillType", new object[] { list }, ob);
                    if (dtLadType.Rows.Count > 0)
                    {
                        if (dtLadType.Rows[0]["LOADVEHICLE_TYPE"].ToString() == "1")//判断提单类型（1.实际，2.虚拟）                        
                        {
                            if (dtLadType.Rows[0]["BILL_STATUS"].ToString() != "1" && dtLadType.Rows[0]["BILL_STATUS"].ToString() != "3")//判断订单状态是否关闭，是否有效
                            {
                                MessageUtil.ShowTips("该条提单不是下发或执行状态，不能进行此操作！");
                                return;
                            }
                        }
                        else
                        {
                            //zhoujl 2024.11.13 虚拟提单不允许操作
                            MessageUtil.ShowTips("该提单是虚拟提单，不能进行此操作！");
                            return;
                           /* if (dtLadType.Rows[0]["ISPRECLOSE"].ToString() == "0")//判断虚拟提单划断标志（0.未划断，1.划断，2.划断结算）
                            {
                                MessageUtil.ShowTips("该提单是虚拟提单,未关闭状态不能进行此操作！");
                                return;
                            }
                            if (dtLadType.Rows[0]["BILL_STATUS"].ToString() != "1" && dtLadType.Rows[0]["BILL_STATUS"].ToString() != "3")//判断订单状态是否关闭，是否有效
                            {
                                MessageUtil.ShowTips("该条提单不是下发或执行状态，不能进行此操作！");
                                return;
                            }
                            if (uRow.Cells["BILL_NO"].Text.Trim().StartsWith("FT"))//判断订单状态是否关闭，是否有效
                            {
                                MessageUtil.ShowTips("该提单是虚拟提单，不能进行此操作！");
                                return;
                            }*/

                        }

                    }

                    if ("120504".Equals(this.CustomInfo) && uRow.Cells["LOADVEHICLE_TYPE"].Text.Equals("实际"))
                    {
                        list = new ArrayList();
                        list.Add(uRow.Cells["ORD_LN_PK"].Text.Trim());
                        DataTable xdlh = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryBillTypeXd", new object[] { list }, ob);
                        if (xdlh.Rows.Count > 0)
                        {
                            //MessageUtil.ShowTips("该合同" + uRow.Cells["ORDER_NO"].Text + "/" + uRow.Cells["ORDER_SEQ"].Text + "有虚单未理货，请优先进行虚单理货装车！");
                            //return;
                        }
                    }

                    if (uRow.Cells["PLAN_COUNT"].Value.ToString() == "0" || uRow.Cells["PLAN_COUNT"].Value.ToString() == "")
                    {
                        MessageUtil.ShowTips("理货支数不能为零或为空！");
                        return;
                    }
                    if (uRow.Cells["STORAGE_NO"].Text.Trim() == "") { MessageUtil.ShowWarning("仓库号为空，不能进行此操作！"); return; }
                    //if (string.IsNullOrEmpty(txtSendList.Text.Trim()))
                    //{
                    //    MessageUtil.ShowWarning("理货单号不能为空，请选择或生成！");
                    //    return;
                    //}

                    //if (uRow.Cells["PLAN_TRANS_TYPE"].Text.Equals("铁运") && uRow.Cells["STORAGE_NO"].Value != uRow.Cells["VSTEL"].Value)
                    //{
                    //    MessageUtil.ShowTips("您选择的数据有出库地点与装车地点不一致,请维护！");
                    //    return;
                    //}

                    
                    if(_storagerPur.Length==1)
                    {
                        if (_storagerPur[0].ToString() != uRow.Cells["VSTEL"].Text.Trim())
                        {
                            MessageUtil.ShowTips("您所在仓库与装车地点不一致，不能进行此操作！");
                            return;
                        }
                    }
                    //if (uRow.Cells["PLAN_TRANS_TYPE"].Text.Equals("铁运"))
                    //{
                    if (uRow.Cells["STORAGE_NO"].Text.Trim() != uRow.Cells["VSTEL"].Text.Trim())
                    {
                        if (!uRow.Cells["MOVE_LOAD_FLAG"].Text.Trim().Equals("入库接收"))
                        {
                            MessageUtil.ShowTips("请确认倒库入库接收！");
                            return;
                        }
                    }
                    //}
                }
            }
            //DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryTallType", new object[] { txtBillList.Text.Trim(), sendTall }, ob);

            // if (!dt.Rows[0]["BILL_NO"].ToString().Equals("")&&dt.Rows[0]["BILL_NO"].ToString() != txtAskPlanID.Text.Trim())
            // {
            //     MessageUtil.ShowWarning("该理货单号已存在[" + dt.Rows[0]["BILL_NO"].ToString() + "]该提单下，请重新选择！");
            //     return;
            // }
            // if (!dt.Rows[0]["LOADVEHICLE_FLAG"].ToString().Equals("0") && !dt.Rows[0]["LOADVEHICLE_FLAG"].ToString().Equals(""))
            // {
            //     MessageUtil.ShowWarning("该理货单号已装车，请重新选择！");
            //     return;
            // }

            if (conut == 0)
            {
                MessageUtil.ShowTips("请选择提单信息！");
                return;
            }
            if (listView1.Items.Count <= 0) { MessageUtil.ShowTips("车辆信息不能为空！"); return; }


            string strAccorCar = "";//回报方式，0，按车、1，按批
            if (chkAccorCar.Checked)
                strAccorCar = "0";
            else
                strAccorCar = "1";

            ArrayList dtList = new ArrayList();
            pram.Clear();
            for (int i = 0; i < listView1.Items.Count; i++)
            {
                ArrayList pram1 = new ArrayList();
                pram1.Add(sendTall);//理货单（发货单号)
                pram1.Add(listView1.Items[i].SubItems[0].Text.Trim());
                pram1.Add(listView1.Items[i].SubItems[1].Text.Trim());
                pram1.Add(listView1.Items[i].SubItems[2].Text.Trim());
                pram1.Add(listView1.Items[i].SubItems[3].Text.Trim());
                pram1.Add(listView1.Items[i].SubItems[4].Text.Trim());
                pram1.Add(askMonth);
                pram1.Add(sendPlan);//日请车主键
                pram1.Add(wagPlan);
                pram1.Add(txtAskPlanID.Text.Trim());
                pram1.Add(batchDay);
                pram1.Add(batchDayVar.ToString());
                pram.Add(pram1);
                batchDayVar++;
            }

            #region 新增到理货单材料表
            string strEndTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");//理货时间
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in GridBill.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    //if (uRow.Cells["PLAN_COUNT"].Value.ToString() == "0")
                    //{
                    //    MessageUtil.ShowTips("可理货量为零，不能进行理货！");
                    //    uRow.Cells["CHOOSE"].Value = false;
                    //    return;
                    //}
                    ArrayList list = new ArrayList();
                    list.Add(uRow.Cells["BILL_NO"].Text.Trim());//提货单号 
                    list.Add(uRow.Cells["DELIVERY_NO"].Text.Trim());
                    list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text);
                    list.Add(uRow.Cells["BATCH_NO"].Text);
                    list.Add(uRow.Cells["PLAN_COUNT"].Value.ToString());
                    list.Add(uRow.Cells["ORDER_NO"].Text.Trim());
                    list.Add(uRow.Cells["ORDER_SEQ"].Text.Trim());
                    list.Add(this.UserInfo.GetUserName());//创建人
                    list.Add(strEndTime);
                    list.Add(sendTall);
                    list.Add(uRow.Cells["STORAGE_NO"].Text.Trim());
                    list.Add(strAccorCar);
                    list.Add(uRow.Cells["ORD_PK"].Text.Trim());
                    list.Add(uRow.Cells["ORD_LN_PK"].Text.Trim());
                    list.Add(uRow.Cells["ORD_LN_DLY_PK"].Text.Trim());
                    list.Add(management_no);//科室id
                    list.Add(management_name);//科室
                    list.Add(departid);//部门id
                    list.Add(departname);//部门
                    list.Add(uRow.Cells["SALE_ORG"].Text.Trim());
                    list.Add(uRow.Cells["SALE_ORG_DESC"].Text.Trim());
                    list.Add(uRow.Cells["GROUP_NO"].Text);
                    list.Add(uRow.Cells["VSTEL"].Text.Trim());
                    list.Add(uRow.Cells["VSTEL_DESC"].Text.Trim());
                    list.Add(uRow.Cells["PORT_NO"].Text.Trim());
                    list.Add(uRow.Cells["PORT_DESC"].Text.Trim());
                    list.Add(uRow.Cells["CREDIT_NO"].Text.Trim());
                    list.Add(uRow.Cells["LOCATION_NO"].Text);//料位
                    list.Add(uRow.Cells["MEMO1"].Text);//备注
                    if (uRow.Cells["PRT_FLAG"].Text.Trim().Equals("是") && "120501".Equals(this.CustomInfo) && "汽运".Equals(uRow.Cells["PLAN_TRANS_TYPE"].Text.Trim())
                        && !uRow.Cells["IS_OVERSTOCK"].Text.Trim().Equals("1"))
                    {
                        sfjl = "1";
                    }
                    addList.Add(list);
                }
            }
            Dictionary<string, int> DValue = new Dictionary<string, int>();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in GridBill.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    string strValue = uRow.Cells["BILL_NO"].Text.Trim() + sendTall + uRow.Cells["ORD_PK"].Text.Trim() + uRow.Cells["ORD_LN_PK"].Text.Trim() + uRow.Cells["ORD_LN_DLY_PK"].Text.Trim();
                    if (!DValue.ContainsKey(strValue))
                        DValue.Add(strValue, uRow.RowSelectorNumber);
                }
            }
            Dictionary<string, int>.ValueCollection valueCol = DValue.Values;
            ArrayList listvalue = new ArrayList();
            #region 新增到理货单主表
            foreach (int intvalue in valueCol)
            {
                for (int i = 0; i < GridBill.Rows.Count; i++)
                {
                    if (intvalue - 1 == i)
                    {
                        ArrayList list = new ArrayList();
                        Infragistics.Win.UltraWinGrid.UltraGridRow urg = GridBill.Rows[i];
                        list.Add(urg.Cells["BILL_NO"].Text.Trim());
                        list.Add(sendTall);
                        list.Add(urg.Cells["ORDER_NO"].Text.Trim());
                        list.Add(urg.Cells["ORDER_SEQ"].Text.Trim());
                        list.Add(urg.Cells["DELIVERY_NO"].Text.Trim());
                        list.Add(urg.Cells["VSTEL"].Text.Trim());
                        list.Add(strAccorCar);
                        list.Add(this.UserInfo.GetUserName());//创建人
                        list.Add(strEndTime);
                        list.Add(management_no);//科室id
                        list.Add(management_name);//科室
                        list.Add(departid);//部门id
                        list.Add(departname);//部门
                        list.Add(urg.Cells["ORD_PK"].Text.Trim());
                        list.Add(urg.Cells["ORD_LN_PK"].Text.Trim());
                        list.Add(urg.Cells["ORD_LN_DLY_PK"].Text.Trim());
                        list.Add(urg.Cells["PORT_NO"].Text.Trim());
                        list.Add(urg.Cells["PORT_DESC"].Text.Trim());
                        list.Add(urg.Cells["CREDIT_NO"].Text.Trim());
                        listvalue.Add(list);
                        break;
                    }
                }
            }
            #endregion
            if (listvalue.Count == 0)
            {
                MessageUtil.ShowTips("数据异常!");
                return;
            }

            //count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.addTallyInfo", new object[] { addList }, ob);
            #endregion
            string strVstel = ugrBill.Cells["VSTEL"].Text.ToString().Substring(1, 2);//仓库地址

            string SendList = "TP" + strVstel + DateTime.Now.ToString("yyMMdd");
            if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

            
                ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet";
                ccp.MethodName = "addTallySheet";
                ccp.ServerParams = new object[] { pram, addList, listvalue, sfjl };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                 MessageUtil.ShowTips(ccp.ReturnInfo);
                 if (ccp.ReturnInfo.Equals("理货成功!"))
                 {
                     listView1.Items.Clear();
                     txtSendList.Text = "";
                     txtAskPlanID.Text = "";
                     batchDay = "";
                     velDay = "";
                     appflag = "";
                     askMonth = "";
                     sendPlan = "";
                     wagPlan = "";
                     doQueryAll();
                 }
            }
        }

        //理货单整单作废
        private void doDeleteAll()
        {
            ArrayList pram = new ArrayList();
            int count = 0;
            int isDelete = 0;
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid3.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                { isDelete += 1; }
            }
            if (isDelete == 0)
            {
                MessageUtil.ShowTips("请选择需要操作的理货单记录！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销？") == DialogResult.No) return;
            string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            pram.Clear();

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid3.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {

                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryTallType", new object[] { uRow.Cells["BILL_NO"].Text.Trim(), uRow.Cells["TALLYSHEET_NO"].Text.Trim() }, ob);
                    if (!dt.Rows[0]["LOADVEHICLE_FLAG"].ToString().Equals("0") || dt.Rows[0]["LOADVEHICLE_FLAG"].ToString().Equals(""))
                    {
                        MessageUtil.ShowTips("该理货单号不是未装车，不能撤销理货！");
                        return;
                    }

                    ArrayList list = new ArrayList();
                    list.Add(uRow.Cells["BILL_NO"].Text.Trim());
                    list.Add(uRow.Cells["TALLYSHEET_NO"].Text.Trim());
                    list.Add(this.UserInfo.GetUserName());
                    list.Add(strTime);
                    list.Add(uRow.Cells["TRANS_TYPE"].Text.Trim());
                    pram.Add(list);
                }
            }
            count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.upDateAllInfo", new object[] { pram }, ob);

            if (count != 0)
            {
                MessageUtil.ShowTips("撤销成功！");
            }
            doQuerySend();
        }

        /// <summary>
        /// 刷新操作
        /// </summary>
        private void doRefresh()
        {
            cmbTranWagOn.Text = "";
            cmbProvin.Text = "";
            chkVirtual.Checked = true;
            listView1.Items.Clear();
            txtSendList.Text = "";
            txtAskPlanID.Text = "";
            InComboAll();

        }
        /// <summary>
        /// 查询时验证必填项
        /// </summary>
        /// <returns></returns>
        private bool ValidQuery()
        {
            if (DataTimeUtil.JudgeTime(DateTime.Parse(StratBillTime.Value.ToString()), DateTime.Parse(EndBillTime.Value.ToString())) == 0)
            {
                MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                return false;
            }
            if (chkBillList.Checked && string.IsNullOrEmpty(txtBillList.Text.Trim()))
            {
                MessageBox.Show("请输入提货单号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkCustomer.Checked && string.IsNullOrEmpty(txtCustomer.Text.Trim()))
            {
                MessageBox.Show("请输入订货单位！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkStrong.Checked && string.IsNullOrEmpty(cmbStorager.Text.Trim()))
            {
                MessageBox.Show("请选择仓库！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkLu.Checked && string.IsNullOrEmpty(txtLuJudge.Text.Trim()))
            {
                MessageBox.Show("请输入炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkOrder.Checked && string.IsNullOrEmpty(txtOrderNo.Text.Trim()))
            {
                MessageBox.Show("请输入合同号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            return true;
        }
        /// <summary>
        /// 验证Checked是否勾选，显示控件可编辑 打勾表示可编辑，不打勾表示不可编辑
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chk_CheckedChanged(object sender, EventArgs e)
        {
            if (chkBillList.Checked) { txtBillList.Enabled = true; } else { txtBillList.Enabled = false; }
            if (chkCustomer.Checked) { txtCustomer.Enabled = true; } else { txtCustomer.Enabled = false; }
            if (chkSendList.Checked) { txtSend.Enabled = true; } else { txtSend.Enabled = false; txtSend.Text = ""; }
            if (chkStrong.Checked) { cmbStorager.Enabled = true; } else { cmbStorager.Enabled = false; cmbStorager.Text = ""; }
            if (chktime.Checked) { SendStratTime.Enabled = true; SendEndTime.Enabled = true; } else { SendStratTime.Enabled = false; SendEndTime.Enabled = false; }
            if (chkType.Checked) { cmbType.Enabled = true; } else { cmbType.Enabled = false; }
            if (chkBillDate.Checked) { StratBillTime.Enabled = true; EndBillTime.Enabled = true; } else { StratBillTime.Enabled = false; EndBillTime.Enabled = false; }
            if (chkBillType.Checked) { cmbStatus.Enabled = true; } else { cmbStatus.Enabled = false; }
            if (chkOrder.Checked) { txtOrderNo.Enabled = true; } else { txtOrderNo.Enabled = false; }
            if (chkLu.Checked) { txtLuJudge.Enabled = true; } else { txtLuJudge.Enabled = false; }
            if (chkStoragerTally.Checked) { cmbStoragerTally.Enabled = true; } else { cmbStoragerTally.Enabled = false; }
            if (chkTalBill.Checked) { txtTalBill.Enabled = true; } else { txtTalBill.Enabled = false; }
            if (chkStarta.Checked) { cmbStarta.Enabled = true; } else { cmbStarta.Enabled = false; }

        }

        /// <summary>
        /// 获取理货单号
        /// </summary>
        private void AutSendList()
        {
            ArrayList pram = new ArrayList();
            ArrayList pram1 = new ArrayList();
            UltraGridRow ugr = this.GridBill.ActiveRow;
            if (ugr == null) return;
            string strTally = "";
            int count = 0;
            foreach (UltraGridRow row in GridBill.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHOOSE"].Text) == true)
                {
                    count += 1;
                    pram.Clear();
                    pram.Add(row.Cells["VSTEL"].Text.ToString());
                    pram.Add(DateTime.Now.ToString("yyMMdd"));
                    pram.Add(DateTime.Now.ToString("yyyy-MM-dd"));
                    pram.Add(row.Cells["VSTEL"].Text.ToString());
                    pram1.Clear();
                    pram1.Add(DateTime.Now.ToString("yyMMdd"));
                    pram1.Add(DateTime.Now.ToString("yyyy-MM-dd"));
                    break;
                }
            }
            if (count == 0) return;
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.querySendList", new object[] { pram }, ob);
            if (this.CustomInfo == "120504")
            {
                dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.querySendListTh", new object[] { pram1 }, ob);
            }
            strTally = dt.Rows[0]["TALLYSHEET_NO"].ToString();
            DataTable dt2 = (DataTable)txtSendList.DataSource;
            Object[] obj = new Object[] { strTally };
            DataRow dr = dt2.NewRow();
            dr.ItemArray = obj;
            if (dt2.Rows.Count > 0)
            {
                if (strTally != dt2.Rows[0]["TALLYSHEET_NO"].ToString())
                {
                    dt2.Rows.InsertAt(dr, 0);
                }
            }
            else
            {
                dt2.Rows.InsertAt(dr, 0);
            }
            txtSendList.SelectedIndex = 0;
        }
        private void GridBill_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = this.GridBill.ActiveRow;
            utbCarNo.DataSource = null;
            if (this.GridBill.Rows.Count <= 0)
                return;
            if (ugr == null) return;
            if (ugr.IsFilterRow) return;
            cmbCarrierUnit.Text = "";
            cmbTranWagOn.Text = "";
            cmbProvin.Text = "";
            if (Convert.ToBoolean(ugr.Cells["CHOOSE"].Text) == true)
            {
                if (ugr.Cells["PLAN_TRANS_TYPE"].Text.Equals("汽运"))
                {
                    listView1.Items.Clear();
                    txtAskDay.Text = "";
                    comCarType.Text = "";
                    cmbProvin.Appearance.BackColor = Color.LightCyan;
                    cmbProvin.ReadOnly = false;
                    txtAskDay.Enabled = false;
                    comCarType.ReadOnly = true;       
                }
                else
                {
                    cmbProvin.ReadOnly = true;
                    cmbProvin.Appearance.BackColor = Color.WhiteSmoke;
                    txtAskDay.Enabled = true;
                    comCarType.ReadOnly = false;
                    comCarType.Text = "60吨车皮";
                }
            }
            if (ugr.Cells["SUPPLY_UNIT"].Value.ToString() == "120504")
            {
                utbCarNo.Visible = true;
                btThAdd.Visible = true;
                ultraLabel5.Visible = true;
                label3.Visible = true;
                DataTable dtCarNo = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryCarNoWeightInfoNew",
                    new Object[] { ugr.Cells["BILL_NO"].Value.ToString() }, this.ob);
                if (dtCarNo.Rows.Count > 0)
                {
                    utbCarNo.DataSource = dtCarNo;
                    utbCarNo.DisplayMember = "CAR_NO";
                    utbCarNo.ValueMember = "RECORD_DATE";
                    utbCarNo.SelectedIndex = 0;
                }
                queryCarTare();
            }
            else
            {
                utbCarNo.Visible = false;
                btThAdd.Visible = false;
                ultraLabel5.Visible = false;
            }
        }
        /// <summary>
        /// 根据提单信息提单号，查询对应的理货信息
        /// </summary>
        private void doQueryAchievem()
        {
            UltraGridRow ugr = this.GridBill.ActiveRow;
            ArrayList pram = new ArrayList();
            if (ugr == null) return;
            pram.Clear();
            pram.Add(ugr.Cells["BILL_NO"].Text.Trim());
            pram.Add(ugr.Cells["ORDER_NO"].Text.Trim());
            pram.Add(ugr.Cells["ORDER_SEQ"].Text.Trim());
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryPerformance", new object[] { pram }, ob);
            GridHelper.CopyDataToDatatable(dt, this.dataBiList, true);
            GridHelper.RefreshAndAutoSize(ultraGrid3);
            if (ultraGrid3.Rows.Count <= 0)
            {
                DataTable dtnu = new DataTable();
                GridHelper.CopyDataToDatatable(dtnu, this.dataOut, true);
                GridHelper.CopyDataToDatatable(dtnu, this.dataCar, true);
            }
        }
        /// <summary>
        /// 判断输入的理货支数、提单支数比
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GridBill_CellChange(object sender, CellEventArgs e)
        {
            GridBill.UpdateData();
            UltraGridRow ugr = GridBill.ActiveRow;
            string actcount = ugr.Cells["ACT_COUNT"].Value.ToString();//提单量
            string plannum = ugr.Cells["PLAN_COUNT"].Value.ToString();//未理货量
            string beencount = ugr.Cells["BEEN_COUNT"].Value.ToString();//已理货量

            if (plannum == "")
            {
                plannum = "0";
                ugr.Cells["PLAN_COUNT"].Value = "0";
            }
            if (e.Cell.Column.Key.Equals("PLAN_COUNT"))
            {

                if (plannum != "" && plannum != "0")
                {
                    if (Convert.ToInt32(plannum) > Convert.ToInt32(actcount) - Convert.ToInt32(beencount))
                    {
                        MessageUtil.ShowWarning("可理货量不能大于提单量与已理货量之差！");
                        ugr.Cells["PLAN_COUNT"].Value = (double.Parse(ugr.Cells["ACT_COUNT"].Value.ToString()) - double.Parse(ugr.Cells["BEEN_COUNT"].Value.ToString())).ToString();
                        ugr.Cells["PLAN_WEIGHT"].Value = (double.Parse(ugr.Cells["ACT_WEIGHT"].Value.ToString()) - double.Parse(ugr.Cells["BEEN_WEIGHT"].Value.ToString())).ToString("f3");
                        ugr.Cells["PLAN_LEN"].Value = (double.Parse(ugr.Cells["ACT_LEN"].Value.ToString()) - double.Parse(ugr.Cells["BEEN_LEN"].Value.ToString())).ToString("f2"); 
                        return;
                    }
                }
                #region 获取库存每一支的重量
                ArrayList list = new ArrayList();
                list.Add(ugr.Cells["BILL_NO"].Text.Trim());
                list.Add(ugr.Cells["JUDGE_STOVE_NO"].Text.Trim());
                list.Add(ugr.Cells["BATCH_NO"].Text.Trim());
                //list.Add(ugr.Cells["ORD_PK"].Text.Trim());
                //list.Add(ugr.Cells["ORD_LN_PK"].Text.Trim());
                list.Add(ugr.Cells["ORD_LN_DLY_PK"].Text.Trim());
                list.Add(ugr.Cells["STORAGE_NO"].Text.Trim());
                list.Add(ugr.Cells["GROUP_NO"].Text.Trim());
                list.Add((double.Parse(ugr.Cells["PLAN_COUNT"].Value.ToString()) + 1).ToString());
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryMatBillC", new object[] { list }, ob);
                ugr.Cells["PLAN_WEIGHT"].Value = dt.Rows[0]["ACT_WEIGHT"].ToString();
                ugr.Cells["PLAN_LEN"].Value = dt.Rows[0]["ACT_LEN"].ToString();
                #endregion
            }
            if (e.Cell.Column.Key.Equals("CHOOSE"))
            {
                string strBill = "";
                string strBillList = "";
                string strStorag = "";
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in GridBill.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                    {
                        strBill = uRow.Cells["BILL_NO"].Text.Trim();
                        strStorag = uRow.Cells["VSTEL"].Text.Trim();

                        if (uRow.Cells["PLAN_TRANS_TYPE"].Text.Equals("汽运"))
                        {
                            txtAskDay.Text = "";
                            comCarType.Text = "";
                            listView1.Items.Clear();
                            cmbProvin.Appearance.BackColor = Color.LightCyan;
                            cmbProvin.ReadOnly = false;
                            txtAskDay.Enabled = false;
                            comCarType.ReadOnly = true;
                        }
                        else
                        {
                            cmbProvin.ReadOnly = true;
                            cmbProvin.Appearance.BackColor = Color.WhiteSmoke;
                            txtAskDay.Enabled = true;
                            comCarType.ReadOnly = false;
                            comCarType.Text = "60吨车皮";
                        }

                    }
                }
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in GridBill.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                    {
                        strBillList = uRow.Cells["BILL_NO"].Text.Trim();
                        if (this.CustomInfo == "120504")
                        {
                            if (strBill != strBillList && strBill != "")
                            {
                                MessageUtil.ShowTips("您选择的提货单号不一致，请重新选择！");
                                ugr.Cells["CHOOSE"].Value = false;
                                return;
                            }
                        }
                        else
                        {
                            if (strBill != strBillList && strBill != "" || strStorag != uRow.Cells["VSTEL"].Text.Trim())
                            {
                                MessageUtil.ShowTips("您选择的提货单号,或仓库号不一致，请重新选择！");
                                ugr.Cells["CHOOSE"].Value = false;
                                return;
                            }
                            if (strBill != strBillList && strBill != "")
                            {
                                MessageUtil.ShowTips("您选择的提货单号不一致，请重新选择！");
                                ugr.Cells["CHOOSE"].Value = false;
                                return;
                            }
                        }
                        txtAskPlanID.Text = ugr.Cells["BILL_NO"].Text;
                    }
                }
                string strstorag = "";
                strstorag = e.Cell.Row.Cells["VSTEL"].Text.Trim();
                ArrayList list = new ArrayList();
                list.Add(strstorag);
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.querySendList1", new object[] { list }, ob);
                txtSendList.DataSource = dt;
                txtSendList.DisplayMember = "TALLYSHEET_NO";
                Object[] obj = new Object[] { "" };
                DataRow dr = dt.NewRow();
                dr.ItemArray = obj;
                dt.Rows.Add(dr);
            }
            if (this.CustomInfo == "120504")
            {
                int count = 0;
                double weight = 0;
                foreach (UltraGridRow row in GridBill.Rows)
                {
                    if (Convert.ToBoolean(row.Cells["CHOOSE"].Text) == true)
                    {
                        count += Convert.ToInt16(row.Cells["PLAN_COUNT"].Value.ToString());
                        weight += Convert.ToDouble(row.Cells["PLAN_WEIGHT"].Value.ToString());
                    }
                }
                labelText.Text = "总计：" + count + "支  " + weight + "吨";
            }
        }
        /// <summary>
        /// 输入理货单号按回车 查询理货信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtSendList_KeyUp(object sender, KeyEventArgs e)
        {

            ListViewItem item = new ListViewItem();
            ArrayList pram = new ArrayList();
            pram.Clear();
            pram.Add(txtSendList.Text.Trim());
            pram.Add(txtAskPlanID.Text.Trim());
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryPerforIn", new object[] { pram }, ob);
            listView1.Items.Clear();
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    item = new ListViewItem();
                    item.SubItems[0].Text = dt.Rows[i]["VEHICLE_NO"].ToString();
                    item.SubItems.Add(dt.Rows[i]["CARRY_COMPANY_CODE"].ToString());
                    item.SubItems.Add(dt.Rows[i]["CARRY_COMPANY_NAME"].ToString());
                    listView1.Items.Add(item);
                    listView1.FullRowSelect = true;
                }

            }
        }


        private void ultraGrid3_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = this.ultraGrid3.ActiveRow;
            UltraGridRow ugrBi = this.GridBill.ActiveRow;
            if (this.ultraGrid3.Rows.Count <= 0) return;
            if (ugr == null) return;
            if (ugr.IsFilterRow) return;

            ArrayList pram = new ArrayList();
            pram.Clear();
            pram.Add(ugr.Cells["BILL_NO"].Text.Trim());
            pram.Add(ugr.Cells["TALLYSHEET_NO"].Text.Trim());

            DataTable dtTa = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryTallyInfoMat", new object[] { pram }, ob);
            GridHelper.CopyDataToDatatable(dtTa, this.dataOut, true);


            DataTable dtCar = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryTallyInfo", new object[] { ugr.Cells["TALLYSHEET_NO"].Text.Trim() }, ob);
            GridHelper.CopyDataToDatatable(dtCar, this.dataCar, true);
        }
        //车船号、承运单位添加
        private void btAdd_Click(object sender, EventArgs e)
        {
            UltraGridRow ugr = this.GridBill.ActiveRow;
            int inBathDay = 0;
            if (ugr == null) { MessageUtil.ShowWarning("提单主信息不能为空！"); return; }
            ListViewItem item = new ListViewItem();
            string strCarriervalue = "";
            if (ugr.Cells["PLAN_TRANS_TYPE"].Text.Trim().Equals("汽运"))
            {
                if (cmbProvin.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("车牌信息不全！");
                    return;
                }
            }
            if (cmbTranWagOn.Text.Trim() == "")
            {
                MessageUtil.ShowTips("请输入车船号！");
                return;
            }
            if (cmbCarrierUnit.Text.Trim() != "")
            {
                strCarriervalue = cmbCarrierUnit.Value.ToString();
            }
            for (int i = 0; i < listView1.Items.Count; i++)
            {
                inBathDay += 1;
                if (listView1.Items[i].SubItems[0].Text == cmbProvin.Text.Trim() + cmbTranWagOn.Text.Trim())
                {
                    MessageUtil.ShowTips("同一车号只能添加一个！");
                    return;
                }
            }
            if (!ugr.Cells["PLAN_TRANS_TYPE"].Text.Trim().Equals("汽运"))
            {
                if (txtAskDay.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("请选择日请车批车号！");
                    return;
                }
                if (comCarType.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("请选择车皮类型！");
                    return;
                }
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryAskTallyT", new object[] { sendPlan, txtAskPlanID.Text.Trim() }, ob);
                carPlan = double.Parse(dt.Rows[0]["BATCHDAY"].ToString());
                if (appflag.Equals("未审批"))
                {
                    if (int.Parse(dt.Rows[0]["BATCHDAY"].ToString()) == int.Parse(velDay))
                    {
                        MessageUtil.ShowTips("输入的车皮号不能大于日申请数");
                        return;
                    }
                    if (inBathDay > int.Parse(velDay) - 1)
                    {
                        MessageUtil.ShowTips("输入的车皮号不能大于日申请数！");
                        return;
                    }
                }
                else
                {
                    if (int.Parse(dt.Rows[0]["BATCHDAY"].ToString()) == int.Parse(batchDay))
                    {
                        MessageUtil.ShowTips("输入的车皮号不能大于日批复数");
                        return;
                    }
                    if (inBathDay > int.Parse(batchDay) - 1)
                    {
                        MessageUtil.ShowTips("输入的车皮号不能大于日批复数！");
                        return;
                    }
                }
            }
            item.SubItems[0].Text = cmbProvin.Text.Trim() + cmbTranWagOn.Text.Trim();
            item.SubItems.Add(strCarriervalue);
            item.SubItems.Add(cmbCarrierUnit.Text.Trim());
            item.SubItems.Add(txtAskDay.Text.Trim());
            item.SubItems.Add(comCarType.Text.Trim());
            listView1.Items.Add(item);
            listView1.FullRowSelect = true;

        }
        //车船号、承运单位删除
        private void btDelete_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count > 0)
                listView1.SelectedItems[0].Remove();
            listView1.Refresh();
        }

        private void frmPipeStow_Shown(object sender, EventArgs e)
        {
            //if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("DeleteAll")) { toolMenu.Toolbars[0].Tools["DeleteAll"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("BillPrint")) { toolMenu.Toolbars[0].Tools["BillPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
        }

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

            }
        }

        private void ultraGrid3_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            //try
            //{
            //    ultraGrid3.UpdateData();

            //    foreach (UltraGridRow r in ultraGrid3.Rows)
            //    {
            //        r.Cells["CHOOSE"].Value = r.Selected;
            //    }
            //}
            //catch { }
            foreach (UltraGridRow uRow in ultraGrid3.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHOOSE"].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)
            {
                if (ultraTabControl1.SelectedTab.Key.Equals("0"))
                {
                    doQueryAll();
                }
                else if (ultraTabControl1.SelectedTab.Key.Equals("1"))
                {
                    doQuerySend();
                }
            }
        }

        /// <summary>
        /// 托选
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GridBill_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            try
            {
                GridBill.UpdateData();
                UltraGridRow ugr = GridBill.ActiveRow;
                string billStorges = "";
                foreach (UltraGridRow row in GridBill.Rows)
                {
                    if (Convert.ToBoolean(row.Cells["CHOOSE"].Text) == true)
                    {
                        billStorges = row.Cells["BILL_NO"].Text.Trim() + row.Cells["VSTEL"].Text.Trim();

                        if (row.Cells["PLAN_TRANS_TYPE"].Text.Equals("汽运"))
                        {
                            txtAskDay.Text = "";
                            comCarType.Text = "";
                            listView1.Items.Clear();
                            cmbProvin.Appearance.BackColor = Color.LightCyan;
                            cmbProvin.ReadOnly = false;
                            txtAskDay.Enabled = false;
                            comCarType.ReadOnly = true;
                          
                        }
                        else
                        {
                            cmbProvin.ReadOnly = true;
                            cmbProvin.Appearance.BackColor = Color.WhiteSmoke;
                            txtAskDay.Enabled = true;
                            comCarType.ReadOnly = false;
                            comCarType.Text="60吨车皮";
                        }
                    }
                }
                foreach (UltraGridRow r in GridBill.Rows)
                {
                    if (r.Selected)
                    {
                        //txtAskPlanID.Text = "";
                        if (billStorges == r.Cells["BILL_NO"].Text.Trim() + r.Cells["VSTEL"].Text.Trim() || billStorges == "")
                        {
                            r.Cells["CHOOSE"].Value = true;
                            txtAskPlanID.Text = r.Cells["BILL_NO"].Text;
                            string strstorag = "";
                            strstorag = r.Cells["VSTEL"].Text.Trim();
                            ArrayList list = new ArrayList();
                            list.Add(strstorag);
                            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.querySendList1", new object[] { list }, ob);
                            txtSendList.DataSource = dt;
                            txtSendList.DisplayMember = "TALLYSHEET_NO";
                            Object[] obj = new Object[] { "" };
                            DataRow dr = dt.NewRow();
                            dr.ItemArray = obj;
                            dt.Rows.Add(dr);
                        }
                        else
                        {
                            r.Cells["CHOOSE"].Value = false;
                            txtAskPlanID.Text = "";
                        }
                    }
                }
            }
            catch { }
        }

        /// <summary>
        /// 日请车弹窗
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtAskDay_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            GridBill.UpdateData();
            UltraGridRow ugr = GridBill.ActiveRow;
            if (ugr == null) return;
            string billNo = "";// txtAskPlanID.Text.Trim().ToString();
            //if (billNo == "")
            //{
            //    if (MessageUtil.ShowYesNoAndQuestion("提货单号为空,是否继续？") == DialogResult.No) return;
            //}
            string stationNo = "";
            string spLine = "";
            string reveNo = "";
            Dictionary<string, int> DValue = new Dictionary<string, int>();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in GridBill.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    billNo = uRow.Cells["BILL_NO"].Text.Trim();
                    stationNo = uRow.Cells["STATION_NO"].Value.ToString();
                    spLine = uRow.Cells["SPCL_LN_NO"].Value.ToString();
                    reveNo = uRow.Cells["RECEIV_NO"].Value.ToString();
                    break;
                   
                }
            }      
            FrmAskDayPlan fpdc = new FrmAskDayPlan(billNo, stationNo, spLine, reveNo, 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)
            {
                //获取弹出窗体的属性值
                txtAskDay.Text = fpdc.AskDay;
                batchDay = fpdc.BatchDay;
                velDay = fpdc.VelDay;
                appflag = fpdc.AppFalg;
                askMonth = fpdc.AskMonth;
                sendPlan = fpdc.SendPlan;
                wagPlan = fpdc.WagPlan;
            }
        }

        /// <summary>
        /// 按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GridBill_ClickCellButton(object sender, CellEventArgs e)
        {
            GridBill.UpdateData();
            UltraGridRow ugr = GridBill.ActiveRow;
            if (ugr == null) return;
            string billNo = ugr.Cells["BILL_NO"].Value.ToString();
            string storage = "";
            string strVstel = "";
            if (e.Cell.Column.Key.Equals("STORAGE_NAME"))
            {
                storage = ugr.Cells["STORAGE_NO"].Text.Trim();
                FrmPuorLib fpl = new FrmPuorLib(billNo, ob, storage, management_no, management_name, departid, departname);
                fpl.AutoSize = true;
                fpl.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                fpl.ShowDialog();
            }
            else
            {
                strVstel = ugr.Cells["VSTEL"].Text.Trim();
                FrmPuorInList fplnList = new FrmPuorInList(billNo, ob, strVstel, management_no, management_name, departid, departname);
                fplnList.AutoSize = true;
                fplnList.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                fplnList.ShowDialog();
            }
            doQueryAll();
        }

        private void cmbTranWagOn_KeyPress(object sender, KeyPressEventArgs e)
        {

            if (!char.IsDigit(e.KeyChar))
                if (!char.IsLetter(e.KeyChar))
                {
                    MessageBox.Show("只能输入数字或英文字母", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    e.Handled = true;
                }

        }

        private void btThAdd_Click(object sender, EventArgs e)
        {
            UltraGridRow ugr = this.GridBill.ActiveRow;
            int inBathDay = 0;
            if (ugr == null) { MessageUtil.ShowWarning("提单主信息不能为空！"); return; }
            ListViewItem item = new ListViewItem();
            string strCarriervalue = "";
            if (utbCarNo.SelectedIndex < 0)
            {
                MessageUtil.ShowTips("请选择车船号！");
                return;
            }
            if (cmbCarrierUnit.Text.Trim() != "")
            {
                strCarriervalue = cmbCarrierUnit.Value.ToString();
            }
            for (int i = 0; i < listView1.Items.Count; i++)
            {
                inBathDay += 1;
                if (listView1.Items[i].SubItems[0].Text == utbCarNo.Text.Trim())
                {
                    MessageUtil.ShowTips("同一车号只能添加一个！");
                    return;
                }
            }
            if (!ugr.Cells["PLAN_TRANS_TYPE"].Text.Trim().Equals("汽运"))
            {
                if (txtAskDay.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("请选择日请车批车号！");
                    return;
                }
                if (comCarType.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("请选择车皮类型！");
                    return;
                }
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmTallYsheet.queryAskTallyT", new object[] { sendPlan, txtAskPlanID.Text.Trim() }, ob);
                carPlan = double.Parse(dt.Rows[0]["BATCHDAY"].ToString());
                if (appflag.Equals("未审批"))
                {
                    if (int.Parse(dt.Rows[0]["BATCHDAY"].ToString()) == int.Parse(velDay))
                    {
                        MessageUtil.ShowTips("输入的车皮号不能大于日申请数");
                        return;
                    }
                    if (inBathDay > int.Parse(velDay) - 1)
                    {
                        MessageUtil.ShowTips("输入的车皮号不能大于日申请数！");
                        return;
                    }
                }
                else
                {
                    if (int.Parse(dt.Rows[0]["BATCHDAY"].ToString()) == int.Parse(batchDay))
                    {
                        MessageUtil.ShowTips("输入的车皮号不能大于日批复数");
                        return;
                    }
                    if (inBathDay > int.Parse(batchDay) - 1)
                    {
                        MessageUtil.ShowTips("输入的车皮号不能大于日批复数！");
                        return;
                    }
                }
            }
            item.SubItems[0].Text = utbCarNo.Text.Trim() ;
            item.SubItems.Add(strCarriervalue);
            item.SubItems.Add(cmbCarrierUnit.Text.Trim());
            item.SubItems.Add(txtAskDay.Text.Trim());
            item.SubItems.Add(comCarType.Text.Trim());
            listView1.Items.Add(item);
            listView1.FullRowSelect = true;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            int bNum = GridBill.DisplayLayout.Bands.Count;
            if (bNum > 0)
            {
                for (int j = 0; j < bNum; j++)
                {
                    GridBill.DisplayLayout.Bands[j].ColumnFilters.ClearAllFilters();
                }
            }
            //if (cl != null){
            //    if (cl.GetType().Equals(typeof(UltraTabControl))){
            //        int tabNum=((UltraTabControl)cl).Tabs.Count;
            //        int currentNum = ((UltraTabControl)cl).ActiveTab.Index;
            //        for (int i = 0; i < tabNum; i++)
            //        {
            //            UltraTabPageControl tcl=((UltraTabControl)cl).Tabs[i].TabPage;
            //            foreach (Control l in tcl.Controls)
            //            {
            //                if (l.GetType().Equals(typeof(UltraGrid)))
            //                {
            //                    if (currentNum == i)
            //                    {
            //                        if (bl)
            //                        {
            //                            ((UltraGrid)l).DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.True;
            //                            ClsGridHelper.RefreshAndAutoSize((UltraGrid)l);
            //                        }
            //                        else
            //                        {
            //                            int bNum = ((UltraGrid)l).DisplayLayout.Bands.Count;
            //                            if (bNum > 0)
            //                            {
            //                                for (int j = 0; j < bNum; j++)
            //                                {
            //                                    ((UltraGrid)l).DisplayLayout.Bands[j].ColumnFilters.ClearAllFilters();
            //                                }
            //                            }
            //                            ((UltraGrid)l).DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.False;
            //                        }
            //                    }
            //                }
            //            }
            //        }
            //    }
            //}
            //else
            //{
            //    if (ug != null)
            //    {
            //        if (bl)
            //        {
            //            ug.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.True;
            //            ClsGridHelper.RefreshAndAutoSize(ug);
            //        }
            //        else
            //        {
            //            int bNum = ug.DisplayLayout.Bands.Count;
            //            if (bNum > 0)
            //            {
            //                for (int j = 0; j < bNum; j++)
            //                {
            //                    ug.DisplayLayout.Bands[j].ColumnFilters.ClearAllFilters();
            //                }
            //            }
            //            ug.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.False;
            //        }
            //    }
            //}
        
        }

        private void utbCarNo_ValueChanged(object sender, EventArgs e)
        {
            label3.Text = utbCarNo.Value.ToString();
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            if (this.CustomInfo == "120504")
            {
                queryCarTare();
            }
        }
        private void queryCarTare()
        {
            if (this.CustomInfo == "120504")
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryCarNoWeightInfoNewBySteel1", new object[] { }, ob);
                GridHelper.CopyDataToDatatable(dt, this.dataCarTare, true);
                foreach (UltraGridRow row in ultraGrid2.Rows)
                {
                    string state = row.Cells["STATE"].Value.ToString2();
                    if (state.Equals("0"))
                    {
                        row.Cells["STATE"].Value = "装车中";
                        row.CellAppearance.BackColor = Color.Yellow;
                    }
                    else if (state.Equals("1"))
                    {
                        row.Cells["STATE"].Value = "装车完毕";
                        row.CellAppearance.BackColor = Color.Green;
                    }
                    else
                    {
                        row.Cells["STATE"].Value = "未装车";
                        row.CellAppearance.BackColor = Color.White;
                    }
                }
            }
        }
    }
}