MES_Client/TGMES/Core.StlMes.Client.PipeLeaveFactory/01.出厂计划/frmPipeCarBill.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using Core.StlMes.Client.PipeLeaveFactory.YdmObject;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.YdmBase;
using Infragistics.Win;
using Core.StlMes.Client.PipeLeaveFactory.Tool;
using com.steering.pss.ydm.entity;
using Core.StlMes.Client.SaleOrder.ReviewForm;
using Core.StlMes.Client.YdmPipeManage;
using Infragistics.Win.UltraWinEditors;
using Core.StlMes.Client.PipeLeaveFactory.Dialog;
using System.Text.RegularExpressions;
using Pur.Entity;

namespace Core.StlMes.Client.PipeLeaveFactory
{
    public partial class frmPipeCarBill : FrmBase
    {
        /// <summary>
        /// 登入用户的销售组织权限
        /// </summary>
        private string[] _salgPermissions;
        private string _sendPlanNo = "";
        private string _ordLnDlyPk = "";
        private string _orderNo = "";
        UltraComboEditor uceVstel = new UltraComboEditor();//装车地点
        UltraComboEditor uceStorag = new UltraComboEditor();//出库地点
        UltraComboEditor uceReceivN = new UltraComboEditor();//收货单位
        UltraComboEditor uceDelvryN = new UltraComboEditor();//收货单位
        private string departid;//对应部门ID
        private string departname;//对应部门
        private string management_no;//对应科室id
        private string management_name;//对应科室

        private string customInfoIndex = "";//界面划分
        private string supplyUnit = "";//制造商代码

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

        private void frmPipeCarBill_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<YdmZcBillCEntity>(ultraGridBillC.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<YdmZcBillMEntity>(ultraGridBillM.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<MatInfoEntity>(ultraGridSourse.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PreTrackNoticeEntity>(ultraGrid1.DisplayLayout.Bands[0]);

            _salgPermissions = BaseHelper.InitPermissions(this.ValidDataPurviewIds, ob);
            doDropDown();
            BillStime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
            BillEtime.Value = DateTime.Parse(DateTime.Now.AddDays(10).ToString("yyyy-MM-dd"));
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            PlanStartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            PlanEndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");

            YdmBaseClass.SetComboItemHeight(ComStatus);
            YdmBaseClass.SetComboItemHeight(ComBillStratus);
            //字段可读
            BaseHelper.setOtherColumnReadOnly(ultraGridOrderInfo, new string[] { "" });
            BaseHelper.setOtherColumnReadOnly(ultraGridSendPlan, new string[] { "" });
            BaseHelper.setOtherColumnReadOnly(ultraGridBillM, new string[] { "CHK", "ReceivNo", "DelvryWhereabouts", "Realinvoiceno1" });
            BaseHelper.setOtherColumnReadOnly(ultraGridBillC, new string[] { "CANCELDOWN", "StorageNo", "CHK" });
            BaseHelper.setOtherColumnReadOnly(ultraGridSourse, new string[] { "CHK", "ActCount", "SendNum", "BoundNum" });
            //字段位置
            BaseHelper.InitCellPosition(ultraGridSourse, new string[] { "ActCount", "ActWeight", "KcWeight", "KcCount", "YbWeight", "YbCount", "SendNum", "BoundNum" });
            BaseHelper.InitCellPosition(ultraGridOrderInfo, new string[] { "PREP_WT", "PLAN_WT", "WGT_ESTMT" });
            BaseHelper.InitCellPosition(ultraGridSendPlan, new string[] { "PLAN_WT" });
            BaseHelper.InitCellPosition(ultraGridBillM, new string[] { "PlanWt", "PlanNum", "PlanTotlLen", "SendNum" });
            BaseHelper.InitCellPosition(ultraGridBillC, new string[] { "ActHeight", "ActDimater", "ActLenMin1", "ActLenMax1", "ActCount", "ActWeight", "PrepWeight", "PrepCount", "BeenCount", "BeenWeight", "PrepLen", "BeenLen", "ActLen", "SendNum" });
            //字段格式
            BaseHelper.setUltraGridColumnMaxInput(ultraGridSendPlan, new string[] { "PLAN_WT" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGridSourse, new string[] { "ActWeight", "KcWeight", "YbWeight","SendNum" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGridOrderInfo, new string[] { "PLAN_WT", "PREP_WT", "WGT_ESTMT" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGridBillM, new string[] { "PlanWt", "SendNum" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGridBillC, new string[] { "ActWeight", "PrepWeight", "BeenWeight", "SendNum" });
            //长度
            BaseHelper.setUltraGridColumnMaxInputLen(ultraGridSourse, new string[] { "ActLen", "YbLen", "KcLen" });
            BaseHelper.setUltraGridColumnMaxInputLen(ultraGridBillM, new string[] { "PlanTotlLen" });
            BaseHelper.setUltraGridColumnMaxInputLen(ultraGridBillC, new string[] { "PrepLen", "BeenLen", "ActLen" });
            //统计字段(吨)
            BaseHelper.GridColumnSum(ultraGridOrderInfo, new string[] { "PLAN_WT", "PREP_WT", "WGT_ESTMT" });
            BaseHelper.GridColumnSum(ultraGridSourse, new string[] { "ActWeight", "KcWeight", "YbWeight","SendNum" });
            BaseHelper.GridColumnSum(ultraGridBillM, new string[] { "PlanWt","SendNum" });
            BaseHelper.GridColumnSum(ultraGridBillC, new string[] { "ActWeight", "PrepWeight", "BeenWeight", "SendNum" });
            BaseHelper.GridColumnSum(ultraGridSendPlan, new string[] { "PLAN_WT" });

            //统计字段(支)
            BaseHelper.GridColumnCount(ultraGridSourse, new string[] { "ActCount", "KcCount",  "YbCount" });
            BaseHelper.GridColumnCount(ultraGridBillM, new string[] { "PlanNum" });
            BaseHelper.GridColumnCount(ultraGridBillC, new string[] { "ActCount",  "PrepCount", "BeenCount" });

            //统计字段(长度)
            BaseHelper.GridColumnCountLen(ultraGridSourse, new string[] { "ActLen", "YbLen", "KcLen" });
            BaseHelper.GridColumnCountLen(ultraGridBillM, new string[] { "PlanTotlLen" });
            BaseHelper.GridColumnCountLen(ultraGridBillC, new string[] { "PrepLen", "BeenLen", "ActLen" });
            string[] customInfoStrArr = this.CustomInfo.Split('_');
            customInfoIndex = customInfoStrArr[0];
            if (customInfoStrArr.Length>1) { supplyUnit = customInfoStrArr[1];}         

            DivideInterface(customInfoIndex);

            YdmBaseClass.InitComboEditor(uceVstel, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
            YdmBaseClass.BindColumn(uceVstel, "Vstel", this.Controls, this.ultraGridSourse, 0);

            YdmBaseClass.InitComboEditor(uceStorag, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
            YdmBaseClass.BindColumn(uceStorag, "StorageNo", this.Controls, this.ultraGridBillC, 0);

            YdmBaseClass.InitComboEditor(uceReceivN, "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.getReceivNo", "CUSTOMER_NO", this.ob, false);
            YdmBaseClass.BindColumn(uceReceivN, "ReceivNo", this.Controls, this.ultraGridBillM, 0);

            YdmBaseClass.InitComboEditor(uceDelvryN, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
            YdmBaseClass.BindColumn(uceDelvryN, "DelvryWhereabouts", this.Controls, this.ultraGridBillM, 0);
            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("1_120504"))
            //{
            //    this.ultraGridSourse.DisplayLayout.Bands[0].Columns["LocationName"].Hidden = true;
            //    this.ultraGridBillC.DisplayLayout.Bands[0].Columns["LocationName"].Hidden = true;
                
            //}
            if (this.CustomInfo.ToString().Equals("1_120504"))
            {
                ultraExpandableGroupBox3.Visible = true;
            }
            if (_salgPermissions.Length == 1)
            {
                if (_salgPermissions[0].Equals("100102"))
                {
                    cmbPord.DataSource = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.getPortDesc", new object[] { "1108" }, this.ob);
                    cmbPord.DisplayMember = "BASENAME";
                    cmbPord.ValueMember = "BASECODE";
                }
                else
                {
                    this.ultraGroupBox5.Location = new System.Drawing.Point(0, 289);
                    this.ultraGroupBox5.Size = new System.Drawing.Size(1502, 49);
                    this.ultraGroupBox5.TabIndex = 10;
                    btCredNo.Visible = false;
                    txtCredNo.Visible = false;
                    btPord.Visible = false;
                    cmbPord.Visible = false;
                    ultraLabel4.Visible = false;
                    ultraTextEditor1.Visible = false;
                    ultraLabel5.Visible = false;
                    ultraTextEditor2.Visible = false;
                }
            }
            else
            {
                cmbPord.DataSource = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.getPortDesc", new object[] { "1108" }, this.ob);
                cmbPord.DisplayMember = "BASENAME";
                cmbPord.ValueMember = "BASECODE";
            }
            
        }

        /// <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 "Update":
                    DoDelete();
                    break;
                case "Down":
                    DoDown();
                    break;
                case "Refresh":
                    DoRefresh();
                    break;
                case "Export":
                    Export();
                    break;
                case "CancelDown":
                    CancelDown();
                    break;
                case "BillDrawOff":
                    BillDrawOff();
                    break;
                case "CancelBillDrawOff":
                    CancelBillDrawOff();
                    break;
                case "Print":
                    Print();
                    break;
                case "BillOut":
                    doBillOut();//客户库直接出库
                    break;
                case "UpdatePrt":
                    doUpdatePrt();//过磅修改
                    break;
                case "UpdateStoage":
                    doUpdateStoage();//修改出库地点
                    break;

                case "DeleteBillOut":
                    doDeleteBillOut();//撤销出库
                    break;
                case "UpdateReceivNo":
                    UpdateReceivNo();//修改收货单位
                    break;
                case "UpdateItemNo":
                    UpdateItemNo();//修改项目号/订单号
                    break;
                case "UpdateDelvryWhereabouts":
                    UpdateDelvryWhereabouts();//修改发货去向
                    break;
                case "UpdateRealinvoiceno1":
                    UpdateRealinvoiceno1();//修改发货去向
                    break;
                case "UpdateLetDeliveryFlag":
                    UpdateLetDeliveryFlag();//修改关联交易状态
                    break;
                case "UpdateStoveTicketFlag":
                    UpdateStoveTicketFlag();//修改是否齐炉状态
                    break;
                case "Close":
                    this.Close();
                    break;
                case "WarehouseTransferNotice":
                    this.WarehouseTransferNotice("RepYdmBillWarehouseTransfer");
                    break;
                case "WarehouseTransferNoticeWG":
                    this.WarehouseTransferNotice("RepYdmBillWarehouseTransferWG");
                    break;
            }
        }

        private void UpdateStoveTicketFlag()
        {
            ultraGridBillC.UpdateData();
            ultraGridBillM.UpdateData();
            UltraGridRow ugr1 = ultraGridBillM.ActiveRow;
            if (ugr1 == null) return;
            int count = 0;
            ArrayList list1 = new ArrayList();

            foreach (UltraGridRow row in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    if (!row.Cells["billStatus"].Value.ToString().Equals("提单编制") || !row.Cells["LetDeliveryFlag"].Value.ToString().Equals("未确认"))
                    {
                        //MessageUtil.ShowTips("提货单号:" + row.Cells["BillNo"].Value.ToString() + "不是提单编制状态，且关联交易状态不是未确认状态，不允许修改!");
                        //return;
                    }
                    count += 1;
                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["BillNo"].Value.ToString());
                    list.Add(row.Cells["StoveTicketFlag"].Value.ToString());
                    list1.Add(list);

                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要修改提单信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改是否齐炉状态") == DialogResult.No) return;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "UpdateStoveTicketFlag";
            ccp.ServerParams = new object[] { list1 };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == -1) return;
            if (ccp.ReturnInfo.Equals("修改成功！"))
            {
                DoQueryBillNo();
            }
        }

        private void UpdateLetDeliveryFlag()
        {
            ultraGridBillC.UpdateData();
            ultraGridBillM.UpdateData();
            UltraGridRow ugr1 = ultraGridBillM.ActiveRow;
            if (ugr1 == null) return;
            int count = 0;
            ArrayList list1 = new ArrayList();

            foreach (UltraGridRow row in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    if (!row.Cells["billStatus"].Value.ToString().Equals("提单编制"))
                    {
                        MessageUtil.ShowTips("提货单号:" + row.Cells["BillNo"].Value.ToString() + "不是提单编制状态，不允许修改!");
                        return;
                    }
                    count += 1;
                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["BillNo"].Value.ToString());
                    list.Add(row.Cells["LetDeliveryFlag"].Value.ToString());
                    list1.Add(list);

                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要修改提单信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改关联交易状态") == DialogResult.No) return;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "UpdateLetDeliveryFlag";
            ccp.ServerParams = new object[] { list1 };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == -1) return;
            if (ccp.ReturnInfo.Equals("修改成功！"))
            {
                DoQueryBillNo();
            }
        }

        private void WarehouseTransferNotice(string rep)
        {
            this.ultraGridBillM.UpdateData();
            int rowcount = ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'").Count();
            if (rowcount <= 0) return;
            
            string strurl = "";

            strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet="+rep+".cpt&&op=view";
            FrmRepExcel fBug = new FrmRepExcel(ob, strurl,"BILL_NO=" + string.Join("','", ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'").Select(a => a.GetValue("BillNo")).ToArray()) + "&NAME=");
            fBug.AutoSize = true;
            fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fBug.WindowState = FormWindowState.Maximized;
            fBug.Text = "转库通知单";
            fBug.Show();
        }

        private void Export()
        {
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                GridHelper.ulGridToExcel(ultraGridSendPlan, "计划信息");
            }
            else
            {
                int count = 0;
                List<string> _billNo = new List<string>();
                foreach (UltraGridRow ugr in ultraGridBillM.Rows)
                {
                    if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                    {
                        count += 1;
                        _billNo.Add(ugr.Cells["BillNo"].Text.Trim());
                    }
                }
                if (count== 0)
                {
                    MessageUtil.ShowTips("请选择需要导出的提单!");
                    return;
                }
                FrmBillDiaLog fpdc = new FrmBillDiaLog(_billNo.ToArray(), ob);
                fpdc.AutoSize = true;
                fpdc.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                fpdc.Text = "导出提单信息";
                fpdc.ShowDialog();
            }
            
        }

        /// <summary>
        /// 划分界面
        /// </summary>
        /// <param name="custInfo"></param>
        private void DivideInterface(string custInfo)
        {
            if (custInfo.Equals("2"))
            {
                ultraTabControl1.Tabs[0].Visible = false;
                if (this.CustomInfo.ToString().Equals("2_120504"))
                {
                    ultraTabControl1.Tabs[2].Visible = false;
                }
            }
            else
            {
                ultraTabControl1.Tabs[1].Text = "提单信息";
                ultraTabControl1.Tabs[2].Visible = false;
            }
        }
        /// <summary>
        /// 绑定下拉框数据
        /// </summary>
        private void doDropDown()
        {
            BaseHelper.InitYear(ComYear);
            BaseHelper.InitMonth(ComMonth);
            ComYear.Value = DateTime.Now.Year.ToString();
            ComMonth.Value = DateTime.Now.ToString("MM");
            BaseHelper.InitOrderUnit(ComCustomer, _salgPermissions, this.ob);
            BaseHelper.InitReceivingUnit(ComReceiv, _salgPermissions, this.ob);
            BaseHelper.InitOrderUnit(ComCustomer1, _salgPermissions, this.ob);
            BaseHelper.InitReceivingUnit(ComReceiv1, _salgPermissions, this.ob);

        }

        //刷新
        private void DoRefresh()
        {
            doDropDown();
        }

        /// <summary>
        /// Checkbox 选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chk_CheckedChanged(object sender, EventArgs e)
        {
            //计划
            if (ChcPlanTime.Checked) { ComYear.Enabled = true; ComMonth.Enabled = true; } else { ComYear.Enabled = false; ComMonth.Enabled = false; }
            if (ChcOrderNo.Checked) { TxtOrderNo.Enabled = true; } else { TxtOrderNo.Enabled = false; }
            if (ChcStatus.Checked) { ComStatus.Enabled = true; } else { ComStatus.Enabled = false; }
            if (ChcBillNo.Checked) { TxtBillNo.Enabled = true; } else { TxtBillNo.Enabled = false; }
            if (ChcPlanNo.Checked) { TxtPlanNo.Enabled = true; } else { TxtPlanNo.Enabled = false; }
            if (ChcCustomer.Checked) { ComCustomer.Enabled = true; } else { ComCustomer.Enabled = false; }
            if (ChcReceiv.Checked) { ComReceiv.Enabled = true; } else { ComReceiv.Enabled = false; }
            //提单
            if (ChcBillTime.Checked) { PlanStartTime.Enabled = true; PlanEndTime.Enabled = true; } else { PlanStartTime.Enabled = false; PlanEndTime.Enabled = false; }
            if (ChcOrderNo1.Checked) { TxtOrderNo1.Enabled = true; } else { TxtOrderNo1.Enabled = false; }
            if (ChcBillStatus.Checked) { ComBillStratus.Enabled = true; } else { ComBillStratus.Enabled = false; }
            if (ChcBillNo1.Checked) { TxtBillNo1.Enabled = true; } else { TxtBillNo1.Enabled = false; }
            if (ChcPlanNo1.Checked) { TxtPlanNo1.Enabled = true; } else { TxtPlanNo1.Enabled = false; }
            if (ChcReceiv1.Checked) { ComReceiv1.Enabled = true; } else { ComReceiv1.Enabled = false; }
            if (ChcCustomer1.Checked) { ComCustomer1.Enabled = true; } else { ComCustomer1.Enabled = false; }
            if (OutKU.Checked) { OutTxt.Enabled = true; } else { OutTxt.Enabled = false; }
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery()
        {
           
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                if (!ValidQuery()) return;
                DoQuerySendPlanNo();
            }
            else if (ultraTabControl1.SelectedTab.Key.Equals("2"))
            {
                DoQueryTrackNotice();
            }
            else
            {
                if (!ValidQuery1()) return;
                DoQueryBillNo();
            }
        }

        /// <summary>
        /// 查询记录预报
        /// </summary>
        private void DoQueryTrackNotice()
        {
            PreTrackNoticeEntity preTrackNoticeEntity = new PreTrackNoticeEntity();
            preTrackNoticeEntity.MatterName = txtMatterName.Text.Trim();
            preTrackNoticeEntity.ContractNo = txtContractNo.Text.Trim();
            preTrackNoticeEntity.CustomerSupplierName = txtCustomerSupplierName.Text.Trim();
            string json = JSONFormat.Format(preTrackNoticeEntity);
            string startTime = txt_startTime.Value.ToString("yyyy-MM-dd");
            string endTime = txt_endTime.Value.ToString("yyyy-MM-dd");
            List<PreTrackNoticeEntity> data = EntityHelper.GetData<PreTrackNoticeEntity>(
                       "com.steering.pss.ydm.pipeleavefactory.PreTrackNoticeService.query",
                       new Object[] { json, startTime, endTime }, ob);
            preTrackNoticeEntityBindingSource.DataSource = data;
            
        }

        /// <summary>
        /// 查询发运计划
        /// </summary>
        private void DoQuerySendPlanNo()
        {
            string yearMonth = "";
            string orderNo = "";
            string strStatus = "";//状态
            string strPlanNo = "";
            string strBillNo = "";
            string strCusomtor = "";
            string strRever = "";
            //年月
            if (ChcPlanTime.Checked && ComYear.Value != null && ComMonth.Value != null)
            {
                yearMonth = ComYear.Value.ToString() + ComMonth.Value.ToString();
            }
            //合同
            if (ChcOrderNo.Checked)
            {
                orderNo = TxtOrderNo.Text.Trim();
            }
            //状态
            if (ChcStatus.Checked && ComStatus.Value != null)
            {
                strStatus = ComStatus.Value.ToString().Trim();
            }
            //发运计划号
            if (ChcPlanNo.Checked)
            {
                strPlanNo = TxtPlanNo.Text.Trim();
            }
            if (ChcBillNo.Checked)
            {
                strBillNo = TxtBillNo.Text.Trim();
            }
            //订货单位
            if (ChcCustomer.Checked)
            {
                strCusomtor = ComCustomer.Text.Trim();
            }
            //收货单位
            if (ChcReceiv.Checked)
            {
                strRever = ComReceiv.Text.Trim();
            }
            if (orderNo.Equals("") && yearMonth.Equals("") && strStatus.Equals("") && strPlanNo.Equals("") && strCusomtor.Equals("") && strRever.Equals("") && strBillNo.Equals(""))
            {
                MessageUtil.ShowTips("请至少选择一个查询条件!");
                return;
            }
            ArrayList param = new ArrayList();
            param.Add(yearMonth);
            param.Add(orderNo);
            param.Add(strStatus);
            param.Add(strPlanNo);
            param.Add(strBillNo);
            param.Add(strCusomtor);
            param.Add(strRever);
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.querySendPlan", new object[] { param, this.ValidDataPurviewIds,supplyUnit }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
            //GridHelper.RefreshAndAutoSize(ultraGrid2);
            if (dt.Rows.Count == 0)
            {
                GridHelper.ClearGridDataSourceData(ultraGridOrderInfo);
                GridHelper.ClearGridDataSourceData(ultraGridSourse);
            }
            PraFlag.Checked = false;
        }

        /// <summary>
        /// 查询合同信息
        /// </summary>
        /// <param name="sendPlanNo"></param>
        private void QueryOrderInfo(string sendPlanNo)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryOrderInfo", new object[] { sendPlanNo }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
            if (dt == null || dt.Rows.Count == 0)
            {
                GridHelper.ClearGridDataSourceData(ultraGridSourse);
            }
            //UltraGridColumn[] col = new UltraGridColumn[] { ultraGridOrderInfo.DisplayLayout.Bands[0].Columns["PSC_DESC"]};
            //GridHelper.RefreshAndAutoSizeExceptColumns(ultraGridOrderInfo, col);
        }

        /// <summary>
        /// 初始化提单号
        /// </summary>
        /// <param name="sendPlanNo"></param>
        private void InitBillNo(string sendPlanNo)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.getBillNoBySendPlanNo", new object[] { sendPlanNo, "110501" }, this.ob);
            DataRow dr = dt.NewRow();
            dr["BILL_NO"] = "";
            dr["BILL_NO"] = "";
            dt.Rows.Add(dr);
            ComBillNo.DataSource = dt;
            ComBillNo.DisplayMember = "BILL_NO";
            ComBillNo.ValueMember = "BILL_NO";

        }

        private void ultraGridSendPlan_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridSendPlan.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            QueryOrderInfo(ugr.Cells["SEND_PLAN_NO"].Text);
            InitBillNo(ugr.Cells["SEND_PLAN_NO"].Text);
            if (_ordLnDlyPk.Length > 0)
            {
                BaseHelper.UltraGridLocation(ultraGridOrderInfo, new string[] { "ORD_LN_DLY_PK" }, new string[] { _ordLnDlyPk });
                _ordLnDlyPk = "";
            }
            txtCredNo.Text = "";
            cmbPord.Text = "";
            PraFlag.Checked = false;
            if (ugr.Cells["SUPPLY_UNIT"].Value.ToString() == "120504")
                PraFlag.Checked = true;

        }

        /// <summary>
        /// 查询库存资源信息
        /// </summary>
        /// <param name="ordPk"></param>
        /// <param name="ordLnPk"></param>
        /// <param name="ordLnDlyPk"></param>
        private void QuerySourse(UltraGridRow row,string ordPk, string ordLnPk, string ordLnDlyPk)
        {
            ArrayList param = new ArrayList();
            //param.Add(ordPk);
            //param.Add(ordLnPk);
            param.Add(ordLnDlyPk);
            List<MatInfoEntity> listBillM = EntityHelper.GetData<MatInfoEntity>("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryMatInfo", new object[] { param,this.CustomInfo }, this.ob);
            matInfoEntityBindingSource.DataSource = listBillM;
            UltraGridColumn[] col = new UltraGridColumn[] { ultraGridSourse.DisplayLayout.Bands[0].Columns["StdName"], ultraGridSourse.DisplayLayout.Bands[0].Columns["CHK"], ultraGridSourse.DisplayLayout.Bands[0].Columns["ActCount"], ultraGridSourse.DisplayLayout.Bands[0].Columns["YbCount"] };
            GridHelper.RefreshAndAutoSizeExceptColumns(ultraGridSourse, col);
            foreach (UltraGridRow ugr in ultraGridSourse.Rows)
            {
                ugr.Cells["Vstel"].Value = ugr.Cells["StorageNo"].Value.ToString();
            }
            if (row.Cells["ORDER_UNIT"].Text.Trim().Equals("米") || row.Cells["ORDER_UNIT"].Text.Trim().Equals("英尺"))
            {
                foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                {
                    ugr1.Cells["SendNum"].Value = ugr1.Cells["ActLen"].Value.ToString();
                    if (row.Cells["ORDER_UNIT"].Text.Trim().Equals("英尺"))
                    {
                        ugr1.Cells["SendNum"].Value = Math.Round(Double.Parse(ugr1.Cells["ActLen"].Value.ToString2()) * 3.281, 2);
                    }
                    ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                }

            }
            else if (row.Cells["ORDER_UNIT"].Text.Equals("支") || row.Cells["ORDER_UNIT"].Text.Equals("个"))
            {
                foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                {
                    ugr1.Cells["SendNum"].Value = ugr1.Cells["ActCount"].Value.ToString();
                    //ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                    ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                }
            }
            else
            {
                foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                {
                    //ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    //ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    //ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                    ugr1.Cells["SendNum"].Appearance.BackColor = Color.Transparent;
                    ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                    ugr1.Cells["SendNum"].Value = ugr1.Cells["ActWeight"].Value.ToString();
                }
            }
           
        }

        private void ultraGridOrderInfo_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridOrderInfo.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            
            if (ultraGridSendPlan.ActiveRow.Cells["SUPPLY_UNIT"].Value.ToString() != "120504")
            {
                ChcVirtual.Checked = false;
                if (!string.IsNullOrWhiteSpace(ugr.Cells["OUTBOUND_CALCULATE"].Text.ToString2()))
                {
                    PraFlag.Enabled = false;
                    if (!ugr.Cells["OUTBOUND_CALCULATE"].Text.ToString2().Equals("0"))
                    {
                        PraFlag.Checked = true;
                    }
                }
                else
                {
                    PraFlag.Enabled = true;
                    PraFlag.Checked = false;
                }
            }

            //if (!ugr.Cells["PRD_CLS"].Text.Equals("405005"))//判断是否坯子
            //{
                ultraGridPipeMat.Visible = false;
                ultraGridSourse.Visible = true;
                QuerySourse(ugr, ugr.Cells["ORD_PK"].Text, ugr.Cells["ORD_LN_PK"].Text, ugr.Cells["ORD_LN_DLY_PK"].Text);
            //}
            //else
            //{
            //    ultraGridPipeMat.Visible = true;
            //    ultraGridSourse.Visible = false;
            //    QueryPipeMat(ugr, ugr.Cells["ORD_LN_DLY_PK"].Text.Trim());
   
            //}
            ultraGroupBox3.Text = "资源信息区";
        }
        /// <summary>
        /// 查询管坯库存
        /// </summary>
        /// <param name="row"></param>
        /// <param name="ordLnDlyPk"></param>
        private void QueryPipeMat(UltraGridRow row, string ordLnDlyPk)
        {
            EntityHelper.ShowGridCaption<PipeMatGpMEntity>(ultraGridPipeMat.DisplayLayout.Bands[0]);
            YdmBaseClass.InitComboEditor(uceVstel, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
            YdmBaseClass.BindColumn(uceVstel, "Vstel", this.Controls, this.ultraGridPipeMat, 0);

            BaseHelper.setUltraGridColumnMaxInput(ultraGridPipeMat, new string[] { "ActWeight", "YbWeight", "KcWeight", "SendNum" });

            List<PipeMatGpMEntity> listSourse = EntityHelper.GetData<PipeMatGpMEntity>("com.steering.pss.ydm.acasleavefactory.CoreCasCarBill.queryPipeMat", new object[] { ordLnDlyPk }, this.ob);
            pipeMatGpMbindingSource.DataSource = listSourse;
            UltraGridColumn[] col = new UltraGridColumn[] {ultraGridPipeMat.DisplayLayout.Bands[0].Columns["CHK"],
                ultraGridPipeMat.DisplayLayout.Bands[0].Columns["ActCount"], ultraGridPipeMat.DisplayLayout.Bands[0].Columns["YbCount"],ultraGridPipeMat.DisplayLayout.Bands[0].Columns["Vstel"] };
            GridHelper.RefreshAndAutoSizeExceptColumns(ultraGridPipeMat, col);
            foreach (UltraGridRow ugr in ultraGridPipeMat.Rows)
            {
                ugr.Cells["Vstel"].Value = ugr.Cells["StorageNo"].Value.ToString();
            }
            if (row.Cells["ORDER_UNIT"].Text.Trim().Equals("米") || row.Cells["ORDER_UNIT"].Text.Trim().Equals("英尺"))
            {
                foreach (UltraGridRow ugr1 in ultraGridPipeMat.Rows)
                {
                    ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                }

            }
            else if (row.Cells["ORDER_UNIT"].Text.Equals("支") || row.Cells["ORDER_UNIT"].Text.Equals("个"))
            {
                foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                {
                    ugr1.Cells["SendNum"].Value = ugr1.Cells["ActCount"].Value.ToString();
                    ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                }
            }
            else
            {
                foreach (UltraGridRow ugr1 in ultraGridPipeMat.Rows)
                {
                    //ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    //ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                    ugr1.Cells["SendNum"].Value = ugr1.Cells["ActWeight"].Value.ToString();
                }
            }
        }
        /// <summary>
        /// 查询提单信息
        /// </summary>
        private void DoQueryBillNo()
        {
            string beginTime = "1999-01-1";
            string endTime = "2999-01-01";
            string prdcls = "";
            if (ChcBillTime.Checked && PlanEndTime.Value != null && PlanStartTime.Value != null)
            {
                beginTime = PlanStartTime.Value.ToString();
                endTime = PlanEndTime.Value.ToString();
            }
            string orderNo = "";
            if (ChcOrderNo1.Checked)
            {
                orderNo = TxtOrderNo1.Text.Trim();
            }
            string status = "";
            if (ChcBillStatus.Checked)
            {
                status = ComBillStratus.Value.ToString().Trim();
            }
            string billNo = "";
            if (ChcBillNo1.Checked)
            {
                billNo = TxtBillNo1.Text.Trim();
            }
            string planNo = "";
            if (ChcPlanNo1.Checked)
            {
                planNo = TxtPlanNo1.Text.Trim();
            }
            string customer = "";
            if (ChcCustomer1.Checked)
            {
                customer = ComCustomer1.Text.Trim();
            }
            string reriver = "";
            if (ChcReceiv1.Checked)
            {
                reriver = ComReceiv1.Text.Trim();
            }
            string strout = "";
            if (OutKU.Checked)
            {
                strout =OutTxt.Value.ToString();
            }
            if (Acasing.Checked)
            {
                prdcls = "405005";
            }

            ArrayList param = new ArrayList();
            param.Add(beginTime);
            param.Add(endTime);
            param.Add(orderNo);
            param.Add(status);
            param.Add(billNo);
            param.Add(planNo);
            param.Add(customer);
            param.Add(reriver);
            param.Add(strout);
            DataSourceList<YdmZcBillMEntity> listBillM = EntityHelper.GetData<YdmZcBillMEntity>("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryBillM", new object[] { param, this.ValidDataPurviewIds, prdcls , supplyUnit,this.CustomInfo.ToString2() }, this.ob);
            ydmZcBillMEntityBindingSource.DataSource = listBillM;
            if (listBillM == null || listBillM.Count == 0)
            {
                DoQueryBillC("");
            }

        }

        /// <summary>
        /// 撤销提单
        /// </summary>
        private void DoDelete()
        {
            ultraGridBillM.UpdateData();
            IQueryable<UltraGridRow> checkRows = ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要撤销的提单!");
                return;
            }
            ArrayList list = new ArrayList();
            foreach (UltraGridRow ugr in checkRows)
            {
                // 天淮关联交易
                if (!string.IsNullOrWhiteSpace(ugr.Cells["OrderNoSeqGljy"].Value.ToString()) && !ugr.Cells["LetDeliveryFlag"].Value.ToString().Equals("未确认") && this.CustomInfo.ToString().StartsWith("2_120504"))
                {
                    //MessageUtil.ShowTips("提货单号:" + ugr.Cells["BillNo"].Value.ToString() + "关联交易状态不是未确认，不允许撤销提单!");
                    //return;
                }
                list.Add(ugr.Cells["BillNo"].Text.Trim());
                _orderNo = ugr.Cells["BillNo"].Text;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销提单?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();

            //if (Acasing.Checked)
            //{
            //    ccp.ServerName = "com.steering.pss.ydm.acasleavefactory.CoreCasCarBill";
            //    ccp.MethodName = "updateBill";
            //}
            //else
            //{
                ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
                ccp.MethodName = "updateBill";
            //}
            ccp.ServerParams = new object[] { list, UserInfo.GetUserName(), UserInfo.GetDeptid(), UserInfo.GetDepartment() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("提单撤销成功!"))
                {
                    DoQueryBillNo();
                    BaseHelper.UltraGridLocation(ultraGridBillM, new string[] { "BillNo" }, new string[] { _orderNo });
                    _orderNo = "";
                }


            }

        }

        /// <summary>
        /// 下发
        /// </summary>
        private void DoDown()
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null) return;
            IQueryable<UltraGridRow> ugrs = ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'");
            if (ugrs.Count() == 0)
            {
                MessageUtil.ShowTips("请选择您要操作的数据！");
                return;
            }
            ArrayList param = new ArrayList();
            List<string> billNos = new List<string>();
            foreach (UltraGridRow row in ugrs)
            {
                string[] str = new string[2];
                str[0] = row.Cells["BillNo"].Value.ToString();
                str[1] = row.Cells["SendPlanNo"].Value.ToString();
                param.Add(str);
                if ("实际".Equals(row.Cells["LoadvehicleType"].Value.ToString()))
                {
                    billNos.Add(row.Cells["BillNo"].Value.ToString());
                }

                // 天淮关联交易
                if (!string.IsNullOrWhiteSpace(row.Cells["OrderNoSeqGljy"].Value.ToString()) && !row.Cells["LetDeliveryFlag"].Value.ToString().Equals("二次确认") && this.CustomInfo.ToString().StartsWith("2_120504"))
                {
                    //MessageUtil.ShowTips("提货单号:" + row.Cells["BillNo"].Value.ToString() + "关联交易状态不是二次确认，不允许下发!");
                    //return;
                }
                // 查询提单合同金额
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.getBillOrder", new object[] { row.Cells["BillNo"].Value.ToString() }, ob);
                double price = 0.0;
                string askDesc = "";
                bool next_flag = false;
                for (int i = 0; i < dt.Rows.Count; i++)
                {

                    if (!dt.Rows[i]["FST_DRAWEE_UNIT"].ToString2().Equals("120604")) // 天津钢管钢铁贸易有限公司
                    {
                        next_flag = true;
                        continue;
                    }
                    if (!string.IsNullOrWhiteSpace(dt.Rows[i]["MNY_ASK_DESC"].ToString2())
                        && !dt.Rows[i]["MNY_ASK_DESC"].ToString2().Contains("全额排产")
                        && !dt.Rows[i]["MNY_ASK_DESC"].ToString2().Contains("付讫发货")
                        && !dt.Rows[i]["MNY_ASK_DESC"].ToString2().Contains("全款提货")
                         && !dt.Rows[i]["MNY_ASK_DESC"].ToString2().Contains("全款预付")
                         && !dt.Rows[i]["MNY_ASK_DESC"].ToString2().Contains("付讫后发货")
                         && !dt.Rows[i]["MNY_ASK_DESC"].ToString2().Contains("全额付款提货")
                         && !dt.Rows[i]["MNY_ASK_DESC"].ToString2().Contains("发货前支付100%货款"))
                    {
                        if (MessageBox.Show(dt.Rows[i]["ORDER_NO"].ToString() + "此合同付款要求是：" + dt.Rows[i]["MNY_ASK_DESC"].ToString2() + "是否继续下发？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                        {
                            return;
                        }
                        next_flag = true;
                        continue;
                    }
                    if (string.IsNullOrWhiteSpace(dt.Rows[i]["BALNCE_PRICE"].ToString2()))
                    {
                        MessageUtil.ShowTips(dt.Rows[i]["ORDER_NO"].ToString() + "/" + dt.Rows[i]["ORDER_SEQ"].ToString() + "，没有合同价格，请维护合同价格！");
                        return;
                    }
                    price += double.Parse(dt.Rows[0]["MONEY"].ToString3());
                    askDesc = dt.Rows[i]["MNY_ASK_DESC"].ToString2();
                }
                if (next_flag)
                {
                    continue;
                }

                // 查询账本可发金额
                DataTable dt1 = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.getMoneyByBuyercode", new object[] { row.Cells["StlmtUnitNo"].Value.ToString() }, ob);

                if (dt1.Rows.Count <= 0 || string.IsNullOrWhiteSpace(dt1.Rows[0]["MONEY"].ToString2()))
                {
                    MessageUtil.ShowTips(row.Cells["StlmtUnitNM"].Value.ToString() + "，没有可发金额，请维护可发金额！");
                    return;
                }
                ArrayList param1 = new ArrayList();
                ArrayList list1 = new ArrayList();
                list1.Add(row.Cells["BillNo"].Value.ToString());
                list1.Add(row.Cells["StlmtUnitNO"].Value.ToString());
                list1.Add(row.Cells["StlmtUnitNM"].Value.ToString());
                list1.Add(dt1.Rows[0]["MONEY"].ToString3());
                list1.Add(price);
                list1.Add(this.UserInfo.GetUserName());
                param1.Add(list1);

                if (double.Parse(dt1.Rows[0]["MONEY"].ToString3()) <= 0)
                {
                    if (MessageBox.Show(row.Cells["StlmtUnitNM"].Value.ToString() + "，可发金额（" + dt1.Rows[0]["MONEY"].ToString2() + "）小于等于0！是否确认下发提货单？\n此合同付款要求是：" + askDesc, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    {
                        return;
                    }
                }
                if (double.Parse(dt1.Rows[0]["MONEY"].ToString3()) < price)
                {
                    if (MessageBox.Show(row.Cells["StlmtUnitNM"].Value.ToString() + "，可发金额（" + dt1.Rows[0]["MONEY"].ToString2() + "）小于结算金额（" + price + "）！是否确认下发提货单？\n此合同付款要求是：" + askDesc, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    {
                        return;
                    }
                }
                if (double.Parse(dt1.Rows[0]["MONEY"].ToString3()) <= 0 || double.Parse(dt1.Rows[0]["MONEY"].ToString3()) < price)
                {
                    CoreClientParam ccp1 = new CoreClientParam();
                    ccp1.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
                    ccp1.MethodName = "DoDownLog";
                    ccp1.ServerParams = new object[] { param1 };
                    ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal);
                }
            }


            if (MessageBox.Show("是否确认下发提货单？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "DoDown";
            ccp.ServerParams = new object[] { param, UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("下发成功!"))
                {
                    DoQueryBillNo();
                    BaseHelper.UltraGridLocation(ultraGridBillM, new string[] { "BillNo" }, new string[] { _orderNo });
                    _orderNo = "";
                    if (billNos == null || billNos.Count <= 0)
                    {
                        return;
                    }
                    if (this.CustomInfo.ToString().Equals("1_120504"))
                    {
                        return;
                    }
                    List<PreTrackNoticeEntity> list = queryLimsData(billNos.ToArray());
                    if (list == null || list.Count <= 0)
                    {
                        return;
                    }
                    ArrayList arrays = new ArrayList();
                    foreach (PreTrackNoticeEntity entity in list)
                    {
                        entity.CreateManNo = "cx";
                        entity.CreateManName = UserInfo.GetUserName();
                        entity.MeterTypeNo = "001006002";
                        entity.MeterTypeName = "销售出厂";
                        entity.TransportTypeName = "汽车检斤";
                        arrays.Add(JSONFormat.Format(entity));
                    }
                    ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.PreTrackNoticeService";
                    ccp.MethodName = "insert";
                    ccp.ServerParams = new object[] { arrays };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowTips("预报下发失败！");
                    }
                }

            }
        }

        private List<PreTrackNoticeEntity> queryLimsData(string[] billNos)
        {
            return EntityHelper.GetData<PreTrackNoticeEntity>("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryLimsData", new object[] { billNos }, this.ob);
            ;
        }

        /// <summary>
        /// 触发ultraGrid1选中事件()
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            string billNo = ugr.Cells["BillNo"].Text.Trim();
            DoQueryBillC(billNo);
        }

        private DataSourceList<YdmZcBillCEntity> listBillC;
        private void DoQueryBillC(string billNo)
        {
            listBillC = EntityHelper.GetData<YdmZcBillCEntity>("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryBillC", new object[] { billNo,this.CustomInfo }, this.ob);
            ydmZcBillCEntityBindingSource.DataSource = listBillC;
            listBillC.AcceptChanges();
            foreach (UltraGridRow ugr in ultraGridBillC.Rows)
            {
                ugr.Cells["CANCELDOWN"].Value = "撤销";
            }
        }



        private void frmPipeStow_Shown(object sender, EventArgs e)
        {
            if (customInfoIndex.Equals("1"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("CancelDown")) { toolMenu.Toolbars[0].Tools["CancelDown"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("BillDrawOff")) { toolMenu.Toolbars[0].Tools["BillDrawOff"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelBillDrawOff")) { toolMenu.Toolbars[0].Tools["CancelBillDrawOff"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Down")) { toolMenu.Toolbars[0].Tools["Down"].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("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("BillOut")) { toolMenu.Toolbars[0].Tools["BillOut"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdatePrt")) { toolMenu.Toolbars[0].Tools["UpdatePrt"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateStoage")) { toolMenu.Toolbars[0].Tools["UpdateStoage"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("DeleteBillOut")) { toolMenu.Toolbars[0].Tools["DeleteBillOut"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateReceivNo")) { toolMenu.Toolbars[0].Tools["UpdateReceivNo"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateDelvryWhereabouts")) { toolMenu.Toolbars[0].Tools["UpdateDelvryWhereabouts"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateRealinvoiceno1")) { toolMenu.Toolbars[0].Tools["UpdateRealinvoiceno1"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNotice")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNotice"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNoticeWG")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNoticeWG"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
            if (customInfoIndex.Equals("2"))
            {
                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.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNotice")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNotice"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNoticeWG")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNoticeWG"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
        }
        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (customInfoIndex.Equals("1"))
            {
                if (e.Tab.TabControl.SelectedTab.Key.Equals("0"))
                {
                    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("UpdateReceivNo")) { toolMenu.Toolbars[0].Tools["UpdateReceivNo"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("UpdateDelvryWhereabouts")) { toolMenu.Toolbars[0].Tools["UpdateDelvryWhereabouts"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("UpdateRealinvoiceno1")) { toolMenu.Toolbars[0].Tools["UpdateRealinvoiceno1"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNotice")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNotice"].InstanceProps.Visible = DefaultableBoolean.False; }
                    if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNoticeWG")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNoticeWG"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                else
                {
                    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("UpdateReceivNo")) { toolMenu.Toolbars[0].Tools["UpdateReceivNo"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("UpdateDelvryWhereabouts")) { toolMenu.Toolbars[0].Tools["UpdateDelvryWhereabouts"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("UpdateRealinvoiceno1")) { toolMenu.Toolbars[0].Tools["UpdateRealinvoiceno1"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNotice")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNotice"].InstanceProps.Visible = DefaultableBoolean.True; }
                    if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNoticeWG")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNoticeWG"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
            }
            if (customInfoIndex.Equals("2"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Down")) { toolMenu.Toolbars[0].Tools["Down"].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("CancelDown")) { toolMenu.Toolbars[0].Tools["CancelDown"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("BillDrawOff")) { toolMenu.Toolbars[0].Tools["BillDrawOff"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelBillDrawOff")) { toolMenu.Toolbars[0].Tools["CancelBillDrawOff"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateStoage")) { toolMenu.Toolbars[0].Tools["UpdateStoage"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdatePrt")) { toolMenu.Toolbars[0].Tools["UpdatePrt"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("BillOut")) { toolMenu.Toolbars[0].Tools["BillOut"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("DeleteBillOut")) { toolMenu.Toolbars[0].Tools["DeleteBillOut"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateReceivNo")) { toolMenu.Toolbars[0].Tools["UpdateReceivNo"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateDelvryWhereabouts")) { toolMenu.Toolbars[0].Tools["UpdateDelvryWhereabouts"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateRealinvoiceno1")) { toolMenu.Toolbars[0].Tools["UpdateRealinvoiceno1"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNotice")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNotice"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNoticeWG")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNoticeWG"].InstanceProps.Visible = DefaultableBoolean.True; }
            }
            if (ultraTabControl1.SelectedTab.Key.Equals("2"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("CancelDown")) { toolMenu.Toolbars[0].Tools["CancelDown"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("BillDrawOff")) { toolMenu.Toolbars[0].Tools["BillDrawOff"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelBillDrawOff")) { toolMenu.Toolbars[0].Tools["CancelBillDrawOff"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Down")) { toolMenu.Toolbars[0].Tools["Down"].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("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("BillOut")) { toolMenu.Toolbars[0].Tools["BillOut"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdatePrt")) { toolMenu.Toolbars[0].Tools["UpdatePrt"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateStoage")) { toolMenu.Toolbars[0].Tools["UpdateStoage"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("DeleteBillOut")) { toolMenu.Toolbars[0].Tools["DeleteBillOut"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateReceivNo")) { toolMenu.Toolbars[0].Tools["UpdateReceivNo"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Refresh")) { toolMenu.Toolbars[0].Tools["Refresh"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateDelvryWhereabouts")) { toolMenu.Toolbars[0].Tools["UpdateDelvryWhereabouts"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateRealinvoiceno1")) { toolMenu.Toolbars[0].Tools["UpdateRealinvoiceno1"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNotice")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNotice"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("WarehouseTransferNoticeWG")) { toolMenu.Toolbars[0].Tools["WarehouseTransferNoticeWG"].InstanceProps.Visible = DefaultableBoolean.False; }
            }

        }

        private void DoAdd()
        {
            ultraGridSourse.UpdateData();
            UltraGridRow ugrSendPlan = ultraGridSendPlan.ActiveRow;
            UltraGridRow ugrOrder = ultraGridOrderInfo.ActiveRow;          
            IQueryable<UltraGridRow> ugrMatNo = ultraGridPipeMat.Rows.AsQueryable().Where(" CHK = 'True'");
            IQueryable<UltraGridRow> ugrSourses = ultraGridSourse.Rows.AsQueryable().Where(" CHK = 'True'");
            //if (ugrOrder.Cells["PRD_CLS"].Text.Trim().Equals("405005"))//判断是否坯子
            //{
            //    if (ugrSendPlan == null || ugrOrder == null || ugrMatNo.Count() == 0)
            //    {
            //        MessageUtil.ShowTips("请选择生成提货单的资源信息!");
            //        return;
            //    }
            //}
            //else
            //{
                if (ugrSendPlan == null || ugrOrder == null || ugrSourses.Count() == 0)
                {
                    MessageUtil.ShowTips("请选择生成提货单的资源信息!");
                    return;
                }
            //}
                string producName = ugrOrder.Cells["PRODUCNAME"].Text;
                string specName = ugrOrder.Cells["SPEC_NAME"].Text;
                string stdName = ugrOrder.Cells["STD_NAME"].Text;
                string steeName = ugrOrder.Cells["STEELNAME"].Text;
                string modelNmae = ugrOrder.Cells["MODEL_DESC"].Text;
                string stdSty = ugrOrder.Cells["STD_STYLE_DESC"].Text;

                string changpx = producName + stdSty + steeName + specName + modelNmae;
                string pipe = producName + specName + stdName;//坯
            string billNo = ComBillNo.Text.Trim();
            string virtualFlag = "1";
            if (ChcVirtual.Checked)
            {
                virtualFlag = "2";
            }
            string strPraFlag = "0";
            if (PraFlag.Checked) 
            {
                strPraFlag = "1";
            }
            string strOverstock = "0";
            if (ChkOverstock.Checked)
            {
                strOverstock = "1";
            }
            string beDelvryAddr = "";
            if (ugrOrder.Cells["ORDER_NO"].Text.Trim().Equals(""))
            {
                MessageUtil.ShowTips("合同号不能为空");
                return;
            }
            string sendPlanNo = ugrSendPlan.Cells["SEND_PLAN_NO"].Text;
            string ordPk = ugrOrder.Cells["ORD_PK"].Text;
            string ordLnPk = ugrOrder.Cells["ORD_LN_PK"].Text;
            string ordLnDlyPk = ugrOrder.Cells["ORD_LN_DLY_PK"].Text;

            DataTable dtOrdLnDlyPk = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryOrdLnDlyPkWT", new object[] { ordLnDlyPk }, this.ob);
            double ordWt = 0;//交货行量
            double delMat = 0;
            string ordDelvryAddr = "";
            if (dtOrdLnDlyPk.Rows.Count > 0)
            {
                ordWt = double.Parse(dtOrdLnDlyPk.Rows[0]["WGT_ESTMT"].ToString());
                delMat = double.Parse(dtOrdLnDlyPk.Rows[0]["DELVRY_RANGE_MAX"].ToString());
                ordDelvryAddr = dtOrdLnDlyPk.Rows[0]["DELVRY_ADDR"].ToString();
            }
            string plineName = "";
            if (!billNo.Equals(""))
            {
                DataTable dt = (DataTable)ComBillNo.DataSource;
                DataRow[] drs = dt.Select("BILL_NO=" + "'" + billNo + "'");
                if (drs == null || drs.Count() == 0)
                {
                    MessageUtil.ShowTips("提货单号:" + billNo + "异常,请重新选择提货单号!");
                    return;
                }
                string beVirtualFlag = drs[0]["LOADVEHICLE_TYPE"].ToString();
                beDelvryAddr = drs[0]["DELVRY_ADDR"].ToString();//提单交货地点
                plineName=drs[0]["LOADVEHICLE_TYPE"].ToString();
                if (beVirtualFlag.Equals("1") && !beVirtualFlag.Equals(virtualFlag))
                {
                    MessageUtil.ShowTips("提货单号:" + billNo + "为实际提单类型,不能追加虚拟提单信息!");
                    return;
                }
                if (beVirtualFlag.Equals("2") && !beVirtualFlag.Equals(virtualFlag))
                {
                    MessageUtil.ShowTips("提货单号:" + billNo + "为虚拟提单类型,不能追加实际提单信息!");
                    return;
                }
                if (beDelvryAddr != ordDelvryAddr)
                {
                    MessageUtil.ShowTips("交货地点不一致不能追加提单信息！");
                    return;
                }
            }
            DataTable dtBillC = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryBillWeight", new object[] { ordLnDlyPk }, this.ob);
            double billWeight = double.Parse(dtBillC.Rows[0]["ACT_WEIGHT"].ToString());
            
            ArrayList paramA = new ArrayList();
            double wegiht = 0;
            DateTime d1 = DateTime.Now;//当前时间
            DateTime dt1 = Convert.ToDateTime(d1);
            //if (ugrOrder.Cells["PRD_CLS"].Text.Trim().Equals("405005"))
            //{
            //    foreach (UltraGridRow ugr in ugrMatNo)
            //    {
            //        PipeMatGpMEntity matInfoEntity = (PipeMatGpMEntity)ugr.ListObject;
            //        matInfoEntity.ActCount = matInfoEntity.ActCount.ToString().Trim();
            //        wegiht += double.Parse(matInfoEntity.ActWeight.ToString());
            //        if (matInfoEntity.ActCount.Equals("") || matInfoEntity.ActCount.Equals("0"))
            //        {
            //            MessageUtil.ShowTips("资源信息可编制量为0,不能生成提单!");
            //            return;
            //        }
            //        if (matInfoEntity.StorageName.Equals("") || matInfoEntity.StorageName.Equals("/"))
            //        {
            //            MessageUtil.ShowTips("请确认资源信息出库地点！");
            //            return;
            //        }
            //        if (pipe != matInfoEntity.Producname + matInfoEntity.SpecName + matInfoEntity.JudgeStdName)
            //        {
            //            if (MessageUtil.ShowYesNoAndQuestion("合同产品信息与炉号产品信息不一致,是否继续！") == DialogResult.No) return;
            //        }
            //        if (ugr.Cells["SendNum"].Text.Trim().Equals("0.000"))
            //        {
            //            MessageUtil.ShowTips("请输入实发数！");
            //            return;
            //        }
            //        DateTime dt2 = Convert.ToDateTime(matInfoEntity.InstockTime);
            //        int months = (dt1.Year - dt2.Year) * 12 + (dt1.Month - dt2.Month);
            //        if (months > 6)
            //        {
            //            if (MessageUtil.ShowYesNoAndQuestion("您所选择的炉号信息入库日期与当前日期相隔6个月,是否继续！") == DialogResult.No) return;
            //        }
            //        paramA.Add(matInfoEntity);
            //    }

            //}
            //else
            //{
            string plineCode = "";
                foreach (UltraGridRow ugr in ugrSourses)
                {
                    MatInfoEntity matInfoEntity = (MatInfoEntity)ugr.ListObject;
                    matInfoEntity.ActCount = matInfoEntity.ActCount.ToString();
                    wegiht += double.Parse(matInfoEntity.ActWeight.ToString());
                    if (matInfoEntity.ActCount.Equals("") || matInfoEntity.ActCount.Equals("0"))
                    {
                        MessageUtil.ShowTips("资源信息可编制量为0,不能生成提单!");
                        return;
                    }
                    if (!matInfoEntity.OrdLnPk.Equals(ordLnPk) || !matInfoEntity.OrdLnDlyPk.Equals(ordLnDlyPk))
                    {
                        MessageUtil.ShowTips("资源信息与合同信息不一致,不能生成提单!");
                        return;
                    }
                    if (matInfoEntity.StorageName.Equals("") || matInfoEntity.StorageName.Equals("/"))
                    {
                        MessageUtil.ShowTips("请确认资源信息出库地点！");
                        return;
                    }
                    if (changpx != matInfoEntity.Producname + matInfoEntity.StdStyleDesc + matInfoEntity.Steelname + matInfoEntity.SpecName + matInfoEntity.ModelDesc)
                    {
                        if (MessageUtil.ShowYesNoAndQuestion("合同产品信息与炉号产品信息不一致,是否继续！") == DialogResult.No) return;
                    }
                    if (ugr.Cells["SendNum"].Text.Trim().Equals("0.000"))
                    {
                        MessageUtil.ShowTips("请输入实发数！");
                        return;
                    }
                    if (_salgPermissions.Length == 1)
                    {
                        if (!_salgPermissions[0].Equals("100102"))
                        {
                            string plineDepart = "";
                            //根据产线产线管理部门
                            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryPlineDepart", new object[] { ugr.Cells["plineCode"].Text.Trim() }, this.ob);
                            if (dt.Rows.Count > 0)
                            {
                                plineDepart = dt.Rows[0]["PROCESS_CODE"].ToString();
                            }
                            if (plineCode.Equals(""))
                            {
                                plineCode = plineDepart;
                            }
                            else
                            {
                                plineCode = plineCode + "," + plineDepart;
                            }
                        }
                    }
                    else
                    {
                        string plineDepart = "";
                        //根据产线产线管理部门
                        DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryPlineDepart", new object[] { ugr.Cells["plineCode"].Text.Trim() }, this.ob);
                        if (dt.Rows.Count > 0)
                        {
                            plineDepart = dt.Rows[0]["PROCESS_CODE"].ToString();
                        }
                        if (plineCode.Equals(""))
                        {
                            plineCode = plineDepart;
                        }
                        else
                        {
                            plineCode = plineCode + "," + plineDepart;
                        }
                    }
                    DateTime dt2 = Convert.ToDateTime(matInfoEntity.JudgeResultTime);
                    int months = (dt1.Year - dt2.Year) * 12 + (dt1.Month - dt2.Month);
                    if (months > 6)
                    {
                        if (MessageUtil.ShowYesNoAndQuestion("您所选择的炉号信息入库日期与当前日期相隔6个月,是否继续！") == DialogResult.No) return;
                    }
                    paramA.Add(matInfoEntity);
                }
                if (_salgPermissions.Length == 1)
                {
                    if (!_salgPermissions[0].Equals("100102"))
                    {
                        if (plineCode.Contains("G") && plineCode.Contains("D"))
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("选择炉号存在加工和轧管产线,是否继续生成一个提单！") == DialogResult.No) return;
                        }
                        //if (!billNo.Equals(""))
                        //{
                        //    if (!plineName.Equals(ugr.Cells["plineName"].Text.Trim()))
                        //    {
                        //        if (MessageUtil.ShowYesNoAndQuestion("选择炉号产线不一致,是否继续！") == DialogResult.No) return;
                        //    }
                        //}
                    }

                }
                else
                {
                    //if (!billNo.Equals(""))
                    //{
                    //    if (!plineName.Equals(ugr.Cells["plineName"].Text.Trim()))
                    //    {
                    //        if (MessageUtil.ShowYesNoAndQuestion("选择炉号产线不一致,是否继续！") == DialogResult.No) return;
                    //    }
                    //}
                    if (plineCode.Contains("G") && plineCode.Contains("D"))
                    {
                        if (MessageUtil.ShowYesNoAndQuestion("选择炉号存在加工和轧管产线,是否继续生成一个提单！") == DialogResult.No) return;
                    }
                }
            //}
            double ordb = ordWt+ordWt * (delMat / 100);//交货行上限值
            double billW=billWeight + wegiht;
            if (ordb < billW)
            {
                if (MessageUtil.ShowYesNoAndQuestion("生成提单量不能大于交货量上限，交货量为：" + ordWt + "t,交货量上限值为：" + ordb + "t,已生成提单量为：" + billWeight + "t,要生成提单的量为：" + wegiht + "t") == DialogResult.No)
                {
                    return;
                }
            }

            if (BillStime.Value == null || BillEtime.Value == null || BillStime.Value > BillEtime.Value)
            {
                MessageUtil.ShowTips("请选择正确的提单开始/结束时间");
                return;
            }
            string beginTime = BillStime.Value.ToString("yyyy-MM-dd");
            string endTime = BillEtime.Value.ToString("yyyy-MM-dd");
            if (MessageUtil.ShowYesNoAndQuestion(billNo.Length == 0 ? "是否新增提单?" : "是否在原有提单号" + billNo + "追加提单信息?") == 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();
                ArrayList paramB = new ArrayList();

                string pordNo = "";
                if (cmbPord.Text.Trim() != "")
                {
                    pordNo = cmbPord.Value.ToString();
                }
                string licNo = "";
                //查询默认许可证号
                DataTable dtLicNo = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.queryLicenseNo", new object[] { "4102" }, this.ob);
                if (dtLicNo.Rows.Count > 0)
                {
                    licNo = dtLicNo.Rows[0]["BASECODE"].ToString();
                }
                paramB.Add(billNo);
                paramB.Add(sendPlanNo);
                paramB.Add(ordPk);
                paramB.Add(ordLnPk);
                paramB.Add(ordLnDlyPk);
                paramB.Add(virtualFlag);
                paramB.Add(UserInfo.GetUserName());
                paramB.Add(UserInfo.GetDepartment());
                paramB.Add(UserInfo.GetDeptid());
                paramB.Add(beginTime);
                paramB.Add(endTime);
                paramB.Add(txtCredNo.Text.Trim());
                paramB.Add(pordNo);
                paramB.Add(cmbPord.Text.Trim());
                //paramB.Add(strPraFlag);
                paramB.Add(ultraTextEditor1.Text.Trim());
                paramB.Add(ultraTextEditor2.Text.Trim());
                paramB.Add(licNo);
                if (checkBox1.Checked)
                {
                    paramB.Add("");
                }
                else
                {
                    paramB.Add("1");
                }
                paramB.Add(strOverstock);
                _sendPlanNo = sendPlanNo;
                _ordLnDlyPk = ordLnDlyPk;
                //if (ugrOrder.Cells["PRD_CLS"].Text.Trim().Equals("405005"))
                //{
                //    ccp.ServerName = "com.steering.pss.ydm.acasleavefactory.CoreCasCarBill";
                //    ccp.MethodName = "DoAdd";
                //}
                //else
                //{
                ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
                ccp.MethodName = "DoAdd";
                //}
                ccp.ServerParams = new object[] { paramB, paramA, strPraFlag, ugrOrder.Cells["ORDER_NO"].Text, ugrOrder.Cells["ORDER_SEQ"].Text, ugrOrder.Cells["DELIVERY_NO"].Text, ugrSendPlan.Cells["SUPPLY_UNIT"].Text, ugrSendPlan.Cells["SUPPLY_UNIT_DESC"].Text, utMemo.Text.Trim(),this.CustomInfo };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception e)
            {
                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("新增提单成功!") || ccp.ReturnInfo.Equals("修改提单成功!"))
                {
                    DoQuery();
                    BaseHelper.UltraGridLocation(ultraGridSendPlan, new string[] { "SEND_PLAN_NO" }, new string[] { _sendPlanNo });
                    _sendPlanNo = "";
                }
            }
        
        }

        private void ultraGridSourse_CellChange(object sender, CellEventArgs e)
        {
            UltraGridRow urg = ultraGridOrderInfo.ActiveRow;
            if (e.Cell.Column.Key.Equals("ActCount"))
            {
                if (e.Cell.Row.Cells["ActCount"].Value == null)
                {
                    e.Cell.Row.Cells["ActCount"].Value = "0";
                    e.Cell.Row.Cells["ActWeight"].Value = "0";
                    e.Cell.Row.Cells["ActLen"].Value = "0";
                    if (urg.Cells["ORDER_UNIT"].Text.Equals("吨") || urg.Cells["ORDER_UNIT"].Text.Equals("支"))
                    {
                        e.Cell.Row.Cells["SendNum"].Value = 0;
                    }
                }
                else
                {
                    ultraGridSourse.UpdateData();
                    string actCount = e.Cell.Row.Cells["ActCount"].Value.ToString();
                    if (!StringUtil.IsInt(actCount) || actCount == "0")//actCount == "" || int.Parse(actCount)==0
                    {
                        e.Cell.Row.Cells["ActCount"].Value = "0";
                        e.Cell.Row.Cells["ActWeight"].Value = "0";
                        e.Cell.Row.Cells["ActLen"].Value = "0";
                        if (urg.Cells["ORDER_UNIT"].Text.Equals("吨") || urg.Cells["ORDER_UNIT"].Text.Equals("支"))
                        {
                            e.Cell.Row.Cells["SendNum"].Value =0;
                        }
                    }
                    else
                    {

                        MatInfoEntity matInfoEntity = (MatInfoEntity)ultraGridSourse.ActiveRow.ListObject;
                        DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.checkMatWeight", new object[] { matInfoEntity }, this.ob);
                        if (dt != null && dt.Rows.Count > 0)
                        {
                            e.Cell.Row.Cells["ActWeight"].Value = dt.Rows[0][0].ToString();
                            e.Cell.Row.Cells["ActCount"].Value = dt.Rows[0][1].ToString();
                            e.Cell.Row.Cells["ActLen"].Value = dt.Rows[0][2].ToString();
                            if (urg.Cells["ORDER_UNIT"].Text.Equals("吨") || urg.Cells["ORDER_UNIT"].Text.Equals("支"))
                            {
                                e.Cell.Row.Cells["SendNum"].Value = dt.Rows[0][0].ToString();
                            }
                        }
                        else
                        {
                            e.Cell.Row.Cells["ActCount"].Value = "0";
                            e.Cell.Row.Cells["ActWeight"].Value = "0";
                            e.Cell.Row.Cells["ActLen"].Value = "0";
                            if (urg.Cells["ORDER_UNIT"].Text.Equals("吨") || urg.Cells["ORDER_UNIT"].Text.Equals("支"))
                            {
                                e.Cell.Row.Cells["SendNum"].Value = 0;
                            }
                        }
                    }
                }
            }
           
            if (e.Cell.Column.Key.Equals("SendNum"))
            {
                if (e.Cell.Row.Cells["SendNum"].Value == null)
                {
                    e.Cell.Row.Cells["SendNum"].Value = "0";
                }
                else
                {
                    ultraGridSourse.UpdateData();
                    string actLen = e.Cell.Row.Cells["SendNum"].Value.ToString();
                    if (!StringUtil.IsFloat(actLen) || actLen == "0")//actCount == "" || int.Parse(actCount)==0
                    {
                        e.Cell.Row.Cells["SendNum"].Value = "0";
                    }    
                }
            }
            string storage = "";
            foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
            {
                if (Convert.ToBoolean(ugr1.Cells["CHK"].Text) == true)
                {
                    storage = ugr1.Cells["StorageNo"].Value.ToString();

                }
            }

            double count = 0;
            double weght = 0;
            double len = 0;
            double send = 0;
            ultraGroupBox3.Text = "资源信息区";
            int i = 0;
            
            foreach (UltraGridRow ugr in ultraGridSourse.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    if (storage != ugr.Cells["StorageNo"].Value.ToString())
                    {
                        i++;                                       
                    }
                    ugr.Cells["VstelDesc"].Value = ugr.Cells["Vstel"].Text;
                    count += double.Parse(ugr.Cells["ActCount"].Value.ToString());
                    weght += double.Parse(ugr.Cells["ActWeight"].Value.ToString());
                    len += double.Parse(ugr.Cells["ActLen"].Value.ToString());
                    send += double.Parse(ugr.Cells["SendNum"].Value.ToString());

                }
            }
            //if (i > 0)
            //{
            //      MessageUtil.ShowTips("您所选择的炉出库地点不一致,不能进行此操作？");
            //      e.Cell.Row.Cells["CHK"].Value = false;
            //      return; 
            //}
            ultraGroupBox3.Text = ultraGroupBox3.Text + "      支：" + count + "   吨：" + weght.ToString("f3") + "   长度：" + len.ToString("f3") + "        实发数："+send.ToString("f3");
        }

        /// <summary>
        /// 撤销下发
        /// </summary>
        private void CancelDown()
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null) return;
            IQueryable<UltraGridRow> ugrs = ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'");
            if (ugrs.Count() == 0)
            {
                MessageUtil.ShowTips("请选择您要撤销下发的提单！");
                return;
            }
            ArrayList param = new ArrayList();
            List<string> billNos = new List<string>();
            foreach (UltraGridRow row in ugrs)
            {
                string[] str = new string[2];
                str[0] = row.Cells["BillNo"].Value.ToString();
                str[1] = row.Cells["SendPlanNo"].Value.ToString();
                param.Add(str);
                if ("实际".Equals(row.Cells["LoadvehicleType"].Value.ToString()))
                {
                    billNos.Add(row.Cells["BillNo"].Value.ToString());
                }
            }
            if (MessageBox.Show("是否确认撤销下发的提货单？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "cancelDown";
            ccp.ServerParams = new object[] { param, UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销下发成功!"))
                {
                    DoQueryBillNo();
                    BaseHelper.UltraGridLocation(ultraGridBillM, new string[] { "BillNo" }, new string[] { _orderNo });
                    _orderNo = "";
                    if (billNos == null || billNos.Count <= 0)
                    {
                        return;
                    }
                    if (this.CustomInfo.ToString().Equals("1_120504"))
                    {
                        return;
                    }
                    List<PreTrackNoticeEntity> list = queryLimsData(billNos.ToArray());
                    if (list == null || list.Count <= 0)
                    {
                        return;
                    }
                    ArrayList arrays = new ArrayList();
                    foreach (PreTrackNoticeEntity entity in list)
                    {
                        entity.UpdateManNo = "cx";
                        entity.UpdateManName = UserInfo.GetUserName();
                        arrays.Add(JSONFormat.Format(entity));
                    }
                    ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.PreTrackNoticeService";
                    ccp.MethodName = "delete";
                    ccp.ServerParams = new object[] { arrays };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowTips("预报取消下发失败！");
                    }
                }

            }
        }

        /// <summary>
        /// 提单划断
        /// </summary>
        private void BillDrawOff()
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null) return;
            IQueryable<UltraGridRow> ugrs = ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'");
            if (ugrs.Count() == 0)
            {
                MessageUtil.ShowTips("请选择您要一次关闭的提单！");
                return;
            }
            ArrayList param = new ArrayList();
            foreach (UltraGridRow row in ugrs)
            {
                if (row.Cells["LoadvehicleType"].Value.ToString().Equals("实际"))
                {
                    MessageUtil.ShowTips("只有虚拟的提单才能一次关闭!");
                    return;
                }
                string billNo = row.Cells["BillNo"].Value.ToString();
                param.Add(billNo);
            }
            if (MessageBox.Show("是否提单一次关闭？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "billDrawOff";
            ccp.ServerParams = new object[] { param, UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("提单一次关闭成功!"))
                {
                    DoQueryBillNo();
                    BaseHelper.UltraGridLocation(ultraGridBillM, new string[] { "BillNo" }, new string[] { _orderNo });
                    _orderNo = "";
                }


            }
        }

        /// <summary>
        /// 取消划断
        /// </summary>
        private void CancelBillDrawOff()
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null) return;
            IQueryable<UltraGridRow> ugrs = ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'");
            if (ugrs.Count() == 0)
            {
                MessageUtil.ShowTips("请选择您要撤销一次关闭的提单!");
                return;
            }
            ArrayList param = new ArrayList();
            foreach (UltraGridRow row in ugrs)
            {
                if (row.Cells["LoadvehicleType"].Value.ToString().Equals("实际"))
                {
                    MessageUtil.ShowTips("只有虚拟的提单才能撤销关闭!");
                    return;
                }
                ArrayList parm = new ArrayList();
                parm.Add(row.Cells["BillNo"].Text.Trim());
                DataTable dg = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmOutAutomatic.selectYearMoth", new object[] { parm }, ob);
                if (int.Parse(dg.Rows[0]["ACOUNT"].ToString()) > 0)
                {
                    MessageUtil.ShowTips("该提货单【" + row.Cells["BillNo"].Text.Trim() + "】对应的炉批信息已进行结转,不允许撤销!");
                    return;
                }
                string billNo = row.Cells["BillNo"].Value.ToString();
                param.Add(billNo);
            }
            if (MessageBox.Show("是否撤销一次关闭?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "cancelBillDrawOff";
            ccp.ServerParams = new object[] { param, UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销一次关闭成功!"))
                {
                    DoQueryBillNo();
                    BaseHelper.UltraGridLocation(ultraGridBillM, new string[] { "BillNo" }, new string[] { _orderNo });
                    _orderNo = "";
                }

            }
        }

        /// <summary>
        /// 提单打印
        /// </summary>
        private void Print()
        {
            string billNo = "";
            UltraGridRow ugr = this.ultraGridBillM.ActiveRow;
            if (ugr == null) { MessageUtil.ShowTips("无数据，请确认！"); return; }
            int count = 0;
            foreach (UltraGridRow row in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    billNo = ugr.Cells["BillNo"].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[] { ugr.Cells["BillNo"].Text.Trim() }, 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;
            if (supplyUnit == "120504")
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepYdmBillCarTH.cpt&op=view" + "&billno=" + billNo;
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

            ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.updatePintFlag", new object[] { time, billNo }, 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();
            DoQueryBillNo();

        }

        private void ultraGridSourse_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            //try
            //{
            //    ultraGridSourse.UpdateData();
            //    foreach (UltraGridRow row in ultraGridSourse.Rows)
            //    {
            //        row.Cells["CHK"].Value =row.Selected;
            //    }
            //}
            //catch { }
            foreach (UltraGridRow uRow in ultraGridSourse.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }

            string storage = "";
            foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
            {
                if (Convert.ToBoolean(ugr1.Cells["CHK"].Text) == true)
                {
                    storage = ugr1.Cells["StorageNo"].Value.ToString();

                }
            }

            double count = 0;
            double weght = 0;
            double len = 0;
            double send = 0;
            ultraGroupBox3.Text = "资源信息区";
            int i = 0;
            UltraGridRow row = ultraGridSourse.ActiveRow;
            foreach (UltraGridRow ugr in ultraGridSourse.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    if (storage != ugr.Cells["StorageNo"].Value.ToString())
                    {
                        i++;
                    }
                    ugr.Cells["VstelDesc"].Value = ugr.Cells["Vstel"].Text;
                    count += double.Parse(ugr.Cells["ActCount"].Value.ToString());
                    weght += double.Parse(ugr.Cells["ActWeight"].Value.ToString());
                    len += double.Parse(ugr.Cells["ActLen"].Value.ToString());
                    send += double.Parse(ugr.Cells["SendNum"].Value.ToString());
                }
            }
            //if (i > 0)
            //{
            //    MessageUtil.ShowTips("您所选择的炉出库地点不一致,不能进行此操作？");
            //    row.Cells["CHK"].Value = false;
            //    return;         
            //}
            ultraGroupBox3.Text = ultraGroupBox3.Text + "      支：" + count + "   吨：" + weght.ToString("f3") + "    长度：" + len.ToString("f3") + "        实发数：" + send.ToString("f3");
        }

        private void ultraGridBillM_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            //try
            //{
            //    ultraGridBillM.UpdateData();
            //    foreach (UltraGridRow row in ultraGridBillM.Rows)
            //    {
            //        row.Cells["CHK"].Value = row.Selected;
            //    }
            //}
            //catch { }
            foreach (UltraGridRow uRow in ultraGridBillM.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
        }

        /// <summary>
        /// 撤销合同
        /// </summary>
        private void CancelDownOrderNo()
        {
            UltraGridRow ugrM = ultraGridBillM.ActiveRow;
            if (ugrM == null)
            {
                return;
            }
            // 天淮关联交易
            if (!string.IsNullOrWhiteSpace(ugrM.Cells["OrderNoSeqGljy"].Value.ToString()) && !ugrM.Cells["LetDeliveryFlag"].Value.ToString().Equals("未确认") && this.CustomInfo.ToString().StartsWith("2_120504"))
            {
                //MessageUtil.ShowTips("提货单号:" + ugrM.Cells["BillNo"].Value.ToString() + "关联交易状态不是未确认，不允许撤销提单!");
                //return;
            }
            if (!ugrM.Cells["BillStatus"].Text.Equals("提单编制"))
            {
                MessageUtil.ShowTips("提货单号:" + ugrM.Cells["BillNo"].Text + "不是提单编制状态,不能撤销提货单下的合同!");
                return;
            }
            UltraGridRow ugr = ultraGridBillC.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            ArrayList param = new ArrayList();
            param.Add(ugr.Cells["BillNo"].Text);
            param.Add(ugr.Cells["OrdPk"].Text);
            param.Add(ugr.Cells["OrdLnPk"].Text);
            param.Add(ugr.Cells["OrdLnDlyPk"].Text);
            param.Add(ugr.Cells["JudgeStoveNo"].Text);
            param.Add(ugr.Cells["BatchNo"].Text);
            param.Add(UserInfo.GetUserName());
            param.Add(ugr.Cells["GroupNo"].Text);
            param.Add(ugr.Cells["LocationNo"].Text);
            string billNo = ugr.Cells["BillNo"].Text;
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销提货单:" + ugr.Cells["BillNo"].Text + "下合同:"
                + ugr.Cells["OrderNo"].Text + "/" + ugr.Cells["OrderSeq"].Text + "/" + ugr.Cells["DeliveryNo"].Text
                + "的炉批号:" + ugr.Cells["JudgeStoveNo"].Text + "/" + ugr.Cells["BatchNo"].Text + "/" + ugr.Cells["GroupNo"].Text) == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            //if (Acasing.Checked)
            //{
            //    ccp.ServerName = "com.steering.pss.ydm.acasleavefactory.CoreCasCarBill";
            //    ccp.MethodName = "cancelDownOrderNo";
            //}
            //else
            //{
                ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
                ccp.MethodName = "cancelDownOrderNo";
            //}
            ccp.ServerParams = new object[] { param };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {
                    DoQueryBillNo();
                    foreach (UltraGridRow ugrc in ultraGridBillM.Rows)
                    {
                        if (ugrc.Cells["BillNo"].Text.Equals(billNo))
                        {
                            ugr.Activate();
                            return;
                        }
                    }
                }
            }
        }

        private void ultraGridBillC_ClickCellButton(object sender, CellEventArgs e)
        {
            if (e.Cell.Text.Equals("撤销"))
            {
                CancelDownOrderNo();

            }
        }

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

        /// <summary>
        /// 查询时验证必填项
        /// </summary>
        /// <returns></returns>
        private bool ValidQuery()
        {
         
            if (ChcOrderNo.Checked && string.IsNullOrEmpty(TxtOrderNo.Text.Trim()))
            {
                MessageBox.Show("请输入合同号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (ChcBillNo.Checked && string.IsNullOrEmpty(TxtBillNo.Text.Trim()))
            {
                MessageBox.Show("请输入提货单号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (ChcPlanNo.Checked && string.IsNullOrEmpty(TxtPlanNo.Text.Trim()))
            {
                MessageBox.Show("请输入出厂计划号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (ChcCustomer.Checked && string.IsNullOrEmpty(ComCustomer.Text.Trim()))
            {
                MessageBox.Show("请选择订货单位！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (ChcReceiv.Checked && string.IsNullOrEmpty(ComReceiv.Text.Trim()))
            {
                MessageBox.Show("请选择收货单位！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            return true;
        }

        /// <summary>
        /// 查询时验证必填项
        /// </summary>
        /// <returns></returns>
        private bool ValidQuery1()
        {
            if (ChcBillTime.Checked)
            {
                if (DataTimeUtil.JudgeTime(DateTime.Parse(PlanStartTime.Value.ToString()), DateTime.Parse(PlanEndTime.Value.ToString())) == 0)
                {
                    MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                    return false;
                }
            }
            if (ChcOrderNo1.Checked && string.IsNullOrEmpty(TxtOrderNo1.Text.Trim()))
            {
                MessageBox.Show("请输入合同号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (ChcBillNo1.Checked && string.IsNullOrEmpty(TxtBillNo1.Text.Trim()))
            {
                MessageBox.Show("请输入提货单号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (ChcPlanNo1.Checked && string.IsNullOrEmpty(TxtPlanNo1.Text.Trim()))
            {
                MessageBox.Show("请输入出厂计划号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (ChcCustomer1.Checked && string.IsNullOrEmpty(ComCustomer1.Text.Trim()))
            {
                MessageBox.Show("请选择订货单位！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (ChcReceiv1.Checked && string.IsNullOrEmpty(ComReceiv1.Text.Trim()))
            {
                MessageBox.Show("请选择收货单位！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            return true;
        }

        /// <summary>
        /// 直接出库
        /// </summary>
        private void doBillOut()
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null) return;
            IQueryable<UltraGridRow> ugrs = ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'");
            if (ugrs.Count() == 0)
            {
                MessageUtil.ShowTips("请选择您要操作的数据！");
                return;
            }
            ArrayList param = new ArrayList();
            foreach (UltraGridRow row in ugrs)
            {
                string delvaddr = row.Cells["DelvryAddr"].Text;
                if (delvaddr.Equals("客户库-腾飞") || delvaddr.Equals("客户库-宝仓") || delvaddr.Equals("客户库-安利") || delvaddr.Equals("客户库-润德")
                    || delvaddr.Equals("客户库-思创") || delvaddr.Equals("客户库-滨城") || delvaddr.Equals("客户库-海泰") || delvaddr.Equals("客户库-江浩库"))
                {
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmOutAutomatic.queryBillC", new object[] { row.Cells["BillNo"].Value.ToString() }, ob);
                    if (dt.Rows.Count > 0)
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            string storage=dt.Rows[i]["STORAGE_NO"].ToString();
                            if (!storage.Equals("LAL1") && !storage.Equals("LAL2") && !storage.Equals("LAL3") && !storage.Equals("LBC1") &&
                                !storage.Equals("LBC2") && !storage.Equals("LTF1") && !storage.Equals("LZD1") && !storage.Equals("LZT1") &&
                                !storage.Equals("LSC1") && !storage.Equals("LSC2") && !storage.Equals("LBK1") && !storage.Equals("LHT1") &&
                                !storage.Equals("LJH1"))
                            {
                                //MessageBox.Show("出库地点与交货地点不一致是否直接出库？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                                MessageBox.Show("出库地点与交货地点不一致无法直接出库！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                                return;
                            }
                        }
                    }
                }
                string typeTran = "";
                if (row.Cells["PlanTransType"].Value.ToString().Equals("汽运"))
                {
                    typeTran = "110501";
                }
                else
                {
                    typeTran = "110502";

                }
                string[] str = new string[19];
                str[0] = row.Cells["BillNo"].Value.ToString();
                str[1] = row.Cells["SendPlanNo"].Value.ToString();
                str[2] = management_no;
                str[3] = management_name;
                str[4] = departid;
                str[5] = departname;
                str[6] = row.Cells["SaleOrg"].Value.ToString();
                str[7] = row.Cells["SaleOrgDesc"].Value.ToString();
                str[8] = typeTran;
                str[9] = row.Cells["ReceivNo"].Value.ToString();
                str[10] = row.Cells["ReceivNm"].Value.ToString();
                str[11] = row.Cells["StlmtUnitNo"].Value.ToString();
                str[12] = row.Cells["StlmtUnitNm"].Value.ToString();
                str[13] = row.Cells["StationNo"].Value.ToString();
                str[14] = row.Cells["StationNm"].Value.ToString();
                str[15] = row.Cells["SpclLnNo"].Value.ToString();
                str[16] = row.Cells["SpclLnNm"].Value.ToString();
                str[17] = this.UserInfo.GetUserGroup();//班组
                str[18] = this.UserInfo.GetUserOrder();//班次
                param.Add(str);
            }
            if (MessageBox.Show("是否确认出库？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == 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();
                //if (Acasing.Checked)
                //{
                //    ccp.ServerName = "com.steering.pss.ydm.acasleavefactory.FrmCasOutAutomatic";
                //    ccp.MethodName = "addTallyInfo";
                //}
                //else
                //{
                    ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.FrmOutAutomatic";
                    ccp.MethodName = "addTallyInfo";
                //}
                ccp.ServerParams = new object[] { param, this.UserInfo.GetUserName() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;


                if (ccp.ReturnCode == -1) return;
            
            }
            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("出库成功!"))
                {
                    DoQueryBillNo();
                    BaseHelper.UltraGridLocation(ultraGridBillM, new string[] { "BillNo" }, new string[] { _orderNo });
                    _orderNo = "";
                }

            }
        
        }

        /// <summary>
        /// 过磅修改
        /// </summary>
        private void doUpdatePrt() 
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null) return;
            int count = 0;
            int prt = 0;
            string prtFlag = "";
            ArrayList list1 = new ArrayList();

            foreach (UltraGridRow row in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    prt += 1;
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeBillOfLadingClose.getBillStatus", new Object[] { row.Cells["BillNo"].Text.Trim() }, this.ob);
                    if (dt.Rows.Count == 0) return;

                    if (!dt.Rows[0]["BILL_STATUS"].ToString().Equals("0"))
                    {
                        MessageUtil.ShowTips("提单不是编制状态，不能修改过磅！");
                        return;
                    }
                }
            }
            if (count == 0) 
            {
                MessageUtil.ShowTips("请选择要修改过磅的提货单号！");
                return;
            }
            if (prt != 0)
            {
                DialogResult strpr = MessageUtil.ShowYesNoCancelAndQuestion("是否需要过磅");
                if (strpr == DialogResult.Cancel) return;
                if (strpr == DialogResult.Yes)
                {
                    prtFlag = "1";
                }
                else if (strpr == DialogResult.No)
                {
                    prtFlag = "0";
                }
            }
            foreach (UltraGridRow row1 in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row1.Cells["CHK"].Text) == true)
                {
                    ArrayList list = new ArrayList();
                    list.Add(prtFlag);
                    list.Add(row1.Cells["BillNo"].Text.Trim());
                    list1.Add(list);
                }
            }
            //if (MessageUtil.ShowYesNoAndQuestion("是否修改过磅") == DialogResult.No) return;
            int update = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.updatePrtFalg", new object[] { list1 }, ob);

            if (update >0) 
            {
                MessageUtil.ShowTips("过磅修改成功！");

                DoQueryBillC(ugr.Cells["BillNo"].Value.ToString());
            }

        }

        /// <summary>
        /// 出库地点修改
        /// </summary>
        private void doUpdateStoage() 
        {
            ultraGridBillC.UpdateData();
            UltraGridRow ugr = ultraGridBillC.ActiveRow;
            UltraGridRow ugr1 = ultraGridBillM.ActiveRow;
            if (ugr == null) return;
            int count = 0;
            ArrayList list1 = new ArrayList();

            foreach (UltraGridRow row in ultraGridBillC.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeBillOfLadingClose.getBillStatus", new Object[] { row.Cells["BillNo"].Text.Trim() }, this.ob);
                    if (dt.Rows.Count == 0) return;

                    //if (dt.Rows[0]["LOADVEHICLE_TYPE"].ToString().Equals("1"))
                    //{
                    //    if (!dt.Rows[0]["BILL_STATUS"].ToString().Equals("0"))
                    //    {
                    //        MessageUtil.ShowTips("提货单不是编制状态不能修改出库地点！");
                    //        return;
                    //    }
                    //}
                    //else 
                    //{
                        //if (dt.Rows[0]["ISPRECLOSE"].ToString().Equals("2"))
                        //{
                        //    MessageUtil.ShowTips("虚单已对齐，不能进行此操作！");
                        //    return;
                        //}
                    string endStatr = "0";
                    if (row.Cells["EditFlag"].Text.Trim().Equals("已理货")) { endStatr = "1"; }
                        DataTable dt1 = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.getBillCedit", new Object[] { row.Cells["BillNo"].Text.Trim(), row.Cells["JudgeStoveNo"].Text, row.Cells["BatchNo"].Text, row.Cells["GroupNo"].Text,endStatr }, this.ob);
                        if (dt1.Rows[0]["EDIT_FLAG"].ToString().Equals("1")) 
                        {
                            MessageUtil.ShowTips("您选择的这炉已理货，不能进行此操作！");
                            return;
                            //if (MessageUtil.ShowYesNoAndQuestion("您选择的这炉已理货，是否继续修改出库地点！") == DialogResult.No) return;
                        }                  
                    //}
                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["BillNo"].Value.ToString());
                    list.Add(row.Cells["JudgeStoveNo"].Value.ToString());
                    list.Add(row.Cells["BatchNo"].Value.ToString());
                    list.Add(row.Cells["GroupNo"].Value.ToString());
                    list.Add(row.Cells["StorageNo"].Value.ToString());
                    list.Add(row.Cells["StorageNo"].Text);
                    list1.Add(list);

                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要修改出库地点对应炉号！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改出库地点") == DialogResult.No) return;
            int update = 0;
            //if (Acasing.Checked)
            //{
            //    update = ServerHelper.SetData("com.steering.pss.ydm.acasleavefactory.CoreCasCarBill.updateStoager", new object[] { list1, ugr1.Cells["PlanTransType"].Text }, ob);
            //}
            //else
            //{
                update = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.updateStoager", new object[] { list1 }, ob);
            //}
            if (update >0)
            {
                MessageUtil.ShowTips("出库地点修改成功！");

            }
            DoQueryBillC(ugr1.Cells["BillNo"].Value.ToString());
        }
        /// <summary>
        /// 修改收货单位
        /// </summary>
        private void UpdateReceivNo() 
        {
            ultraGridBillC.UpdateData();
            UltraGridRow ugr1 = ultraGridBillM.ActiveRow;
            if (ugr1 == null) return;
            int count = 0;
            ArrayList list1 = new ArrayList();

            foreach (UltraGridRow row in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    count += 1;

                    //if (!row.Cells["BillStatus"].Text.ToString().Equals("提单编制"))
                    //{
                    //    MessageUtil.ShowTips("你选择的这个提单不是提单编制状态,不能修改收货单位！");
                    //    return;
                    //}

                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["BillNo"].Value.ToString());
                    list.Add(row.Cells["ReceivNo"].Value.ToString());
                    list.Add(row.Cells["ReceivNo"].Text);
                    list1.Add(list);

                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要修改提单信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改收货单位") == DialogResult.No) return;
            int update = 0;
            //if (Acasing.Checked)
            //{
            //    update = ServerHelper.SetData("com.steering.pss.ydm.acasleavefactory.CoreCasCarBill.updateStoager", new object[] { list1, ugr1.Cells["PlanTransType"].Text }, ob);
            //}
            //else
            //{
            
            //update = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill.updateReceivNo", new object[] { list1 }, ob);
            //}

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "updateReceivNo";
            ccp.ServerParams = new object[] { list1};
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == -1) return;
            //MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                DoQueryBillNo();
            }
        }

        /// <summary>
        /// 修改发货去向
        /// </summary>
        private void UpdateDelvryWhereabouts()
        {
            ultraGridBillC.UpdateData();
            ultraGridBillM.UpdateData();
            UltraGridRow ugr1 = ultraGridBillM.ActiveRow;
            if (ugr1 == null) return;
            int count = 0;
            ArrayList list1 = new ArrayList();

            foreach (UltraGridRow row in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["BillNo"].Value.ToString());
                    list.Add(row.Cells["DelvryWhereabouts"].Text);
                    list1.Add(list);

                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要修改提单信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改发货去向") == DialogResult.No) return;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "UpdateDelvryWhereabouts";
            ccp.ServerParams = new object[] { list1 };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == -1) return;
            if (ccp.ReturnInfo.Equals("修改成功！"))
            {
                DoQueryBillNo();
            }
        }

        private void UpdateRealinvoiceno1()
        {
            ultraGridBillC.UpdateData();
            ultraGridBillM.UpdateData();
            UltraGridRow ugr1 = ultraGridBillM.ActiveRow;
            if (ugr1 == null) return;
            int count = 0;
            ArrayList list1 = new ArrayList();

            foreach (UltraGridRow row in ultraGridBillM.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    if (row.Cells["saleOrg"].Text != "100102")
                    {
                        MessageUtil.ShowTips("请选择要国际贸易部的提单！");
                        return;
                    }
                    count += 1;
                    ArrayList list = new ArrayList();
                    list.Add(row.Cells["BillNo"].Value.ToString());
                    list.Add(row.Cells["Realinvoiceno1"].Text);
                    list1.Add(list);

                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要修改提单信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改结算状态") == DialogResult.No) return;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "UpdateRealinvoiceno1";
            ccp.ServerParams = new object[] { list1 };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == -1) return;
            if (ccp.ReturnInfo.Equals("修改成功！"))
            {
                DoQueryBillNo();
            }
        }

        private void ultraGridBillC_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGridBillC.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
        }

        private void ultraGridBillM_BeforeRowDeactivate(object sender, CancelEventArgs e)
        {
            if (listBillC.IsChanged)
            {
                if (MessageUtil.ShowYesNoAndQuestion("是否放弃当前编辑？") == DialogResult.No)
                {
                    e.Cancel = true;
                }
            }
        }

        private void ultraGridBillM_CellDataError(object sender, CellDataErrorEventArgs e)
        {
            e.RaiseErrorEvent = false;
        }

        private void ultraGridBillC_CellChange(object sender, CellEventArgs e)
        {
            ultraGridBillC.UpdateData();
            listBillC.Change((YdmZcBillCEntity)e.Cell.Row.ListObject);
        }

        /// <summary>
        /// 撤销出库
        /// </summary>
        private void doDeleteBillOut() 
        {
            ultraGridBillM.UpdateData();
            UltraGridRow ugr = ultraGridBillM.ActiveRow;
            if (ugr == null) return;
            IQueryable<UltraGridRow> ugrs = ultraGridBillM.Rows.AsQueryable().Where(" CHK = 'True'");
            if (ugrs.Count() == 0)
            {
                MessageUtil.ShowTips("请选择您要操作的数据！");
                return;
            }
            ArrayList param = new ArrayList();
            foreach (UltraGridRow row in ugrs)
            {
                ArrayList parm = new ArrayList();
                parm.Add(row.Cells["BillNo"].Text.Trim());
                DataTable dg = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmOutAutomatic.selectYearMoth", new object[] { parm }, ob);
                if (int.Parse(dg.Rows[0]["ACOUNT"].ToString()) > 0)
                {
                    MessageUtil.ShowTips("该提货单【" + row.Cells["BillNo"].Text.Trim() + "】对应的炉批信息已进行结转,不允许撤销!");
                    return;
                }
                string[] str = new string[6];
                str[0] = row.Cells["BillNo"].Value.ToString();
                str[1] = row.Cells["SendPlanNo"].Value.ToString();
                str[2] = management_no;
                str[3] = management_name;
                str[4] = departid;
                str[5] = departname;
                param.Add(str);
            }
            if (MessageBox.Show("是否确认撤销出库？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == 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();
                //if (Acasing.Checked)
                //{
                //    ccp.ServerName = "com.steering.pss.ydm.acasleavefactory.FrmCasOutAutomatic";
                //    ccp.MethodName = "deleteTallyInfo";
                //}
                //else
                //{
                    ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.FrmOutAutomatic";
                    ccp.MethodName = "deleteTallyInfo";
                //}
                ccp.ServerParams = new object[] { param, this.UserInfo.GetUserName() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;


                if (ccp.ReturnCode == -1) return;

            }
            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("撤销出库成功!"))
                {
                    DoQueryBillNo();
                    BaseHelper.UltraGridLocation(ultraGridBillM, new string[] { "BillNo" }, new string[] { _orderNo });
                    _orderNo = "";
                }

            }
        }

        private void txtCredNo_KeyPress(object sender, KeyPressEventArgs e)
        {
            txtCredNo.Update();
            string pat = @"[\u4e00-\u9fa5]";
            Regex rg = new Regex(pat);
            Match mh = rg.Match(txtCredNo.Text);
            if (!mh.Success)
                return;
            MessageBox.Show("不许输入中文!");
            txtCredNo.Undo();
            //if (!char.IsDigit(e.KeyChar))
            //    if (!char.IsLetter(e.KeyChar))
            //    {
            //        MessageBox.Show("只能输入数字或英文字母", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            //        e.Handled = true;
            //    }
        }

        /// <summary>
        /// 管坯支数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridPipeMat_CellChange(object sender, CellEventArgs e)
        {
            UltraGridRow urg = ultraGridOrderInfo.ActiveRow;
            if (e.Cell.Row.Cells["ActCount"].Value == null)
            {
                e.Cell.Row.Cells["ActCount"].Value = "0";
                e.Cell.Row.Cells["ActWeight"].Value = "0";
                e.Cell.Row.Cells["ActLen"].Value = "0";
                if (urg.Cells["ORDER_UNIT"].Text.Equals("吨") || urg.Cells["ORDER_UNIT"].Text.Equals("支"))
                {
                    e.Cell.Row.Cells["SendNum"].Value = 0;
                }
            }
            else
            {
                ultraGridPipeMat.UpdateData();
                string actCount = e.Cell.Row.Cells["ActCount"].Value.ToString();
                if (!StringUtil.IsInt(actCount) || actCount == "0")
                {
                    e.Cell.Row.Cells["ActCount"].Value = "0";
                    e.Cell.Row.Cells["ActWeight"].Value = "0";
                    e.Cell.Row.Cells["ActLen"].Value = "0";
                    if (urg.Cells["ORDER_UNIT"].Text.Equals("吨") || urg.Cells["ORDER_UNIT"].Text.Equals("支"))
                    {
                        e.Cell.Row.Cells["SendNum"].Value = 0;
                    }
                }
                else
                {

                    PipeMatGpMEntity matpipeEntity = (PipeMatGpMEntity)ultraGridPipeMat.ActiveRow.ListObject;
                    DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.acasleavefactory.CoreCasCarBill.checkMatWeight", new object[] { JSONFormat.Format(matpipeEntity) }, this.ob);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        e.Cell.Row.Cells["ActWeight"].Value = dt.Rows[0][0].ToString();
                        e.Cell.Row.Cells["ActCount"].Value = dt.Rows[0][1].ToString();
                        e.Cell.Row.Cells["ActLen"].Value = dt.Rows[0][2].ToString();
                        if (urg.Cells["ORDER_UNIT"].Text.Equals("吨") || urg.Cells["ORDER_UNIT"].Text.Equals("支"))
                        {
                            e.Cell.Row.Cells["SendNum"].Value = dt.Rows[0][0].ToString();
                        }
                    }
                    else
                    {
                        e.Cell.Row.Cells["ActCount"].Value = "0";
                        e.Cell.Row.Cells["ActWeight"].Value = "0";
                        e.Cell.Row.Cells["ActLen"].Value = "0";
                        if (urg.Cells["ORDER_UNIT"].Text.Equals("吨") || urg.Cells["ORDER_UNIT"].Text.Equals("支"))
                        {
                            e.Cell.Row.Cells["SendNum"].Value = 0;
                        }
                    }
                }
            }
            if (e.Cell.Column.Key.Equals("SendNum"))
            {
                if (e.Cell.Row.Cells["SendNum"].Value == null)
                {
                    e.Cell.Row.Cells["SendNum"].Value = "0";
                }
                else
                {
                    ultraGridPipeMat.UpdateData();
                    string actLen = e.Cell.Row.Cells["SendNum"].Value.ToString();
                    if (!StringUtil.IsFloat(actLen) || actLen == "0")//actCount == "" || int.Parse(actCount)==0
                    {
                        e.Cell.Row.Cells["SendNum"].Value = "0";
                    }
                }
            }
            string storage = "";
            foreach (UltraGridRow ugr1 in ultraGridPipeMat.Rows)
            {
                if (Convert.ToBoolean(ugr1.Cells["CHK"].Text) == true)
                {
                    storage = ugr1.Cells["StorageNo"].Value.ToString();

                }
            }

            double count = 0;
            double weght = 0;
            double len = 0;
            ultraGroupBox3.Text = "资源信息区";
            int i = 0;
            foreach (UltraGridRow ugr in ultraGridPipeMat.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    if (storage != ugr.Cells["StorageNo"].Value.ToString())
                    {
                        i++;
                    }
                    ugr.Cells["VstelDesc"].Value = ugr.Cells["Vstel"].Text;
                    count += double.Parse(ugr.Cells["ActCount"].Value.ToString());
                    weght += double.Parse(ugr.Cells["ActWeight"].Value.ToString());
                    len += double.Parse(ugr.Cells["ActLen"].Value.ToString());
                }
            }
            ultraGroupBox3.Text = ultraGroupBox3.Text + "      支：" + count + "   吨：" + weght.ToString("f3") + "   长度：" + len.ToString("f3");
        }

        /// <summary>
        /// 管坯托选
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridPipeMat_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGridPipeMat.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
            string storage = "";
            foreach (UltraGridRow ugr1 in ultraGridPipeMat.Rows)
            {
                if (Convert.ToBoolean(ugr1.Cells["CHK"].Text) == true)
                {
                    storage = ugr1.Cells["StorageNo"].Value.ToString();

                }
            }

            double count = 0;
            double weght = 0;
            double len = 0;
            ultraGroupBox3.Text = "资源信息区";
            int i = 0;
            UltraGridRow row = ultraGridPipeMat.ActiveRow;
            foreach (UltraGridRow ugr in ultraGridPipeMat.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    if (storage != ugr.Cells["StorageNo"].Value.ToString())
                    {
                        i++;
                    }
                    ugr.Cells["VstelDesc"].Value = ugr.Cells["Vstel"].Text;
                    count += double.Parse(ugr.Cells["ActCount"].Value.ToString());
                    weght += double.Parse(ugr.Cells["ActWeight"].Value.ToString());
                    len += double.Parse(ugr.Cells["ActLen"].Value.ToString());
                }
            }
            ultraGroupBox3.Text = ultraGroupBox3.Text + "      支：" + count + "   吨：" + weght.ToString("f3") + "   长度：" + len.ToString("f3");
        }

        private void chkAll_CheckedChanged(object sender, EventArgs e)
        {
            if (chkAll.Checked)
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGridSourse.Rows)
                {  
                        uRow.Cells["CHK"].Value = true;  
                }
            }
            else
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGridSourse.Rows)
                {
                    uRow.Cells["CHK"].Value = false;
                }
            }
            double count = 0;
            double weght = 0;
            double len = 0;
            double send = 0;
            ultraGroupBox3.Text = "资源信息区";
            UltraGridRow row = ultraGridSourse.ActiveRow;
            foreach (UltraGridRow ugr in ultraGridSourse.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    ugr.Cells["VstelDesc"].Value = ugr.Cells["Vstel"].Text;
                    count += double.Parse(ugr.Cells["ActCount"].Value.ToString());
                    weght += double.Parse(ugr.Cells["ActWeight"].Value.ToString());
                    len += double.Parse(ugr.Cells["ActLen"].Value.ToString());
                    send += double.Parse(ugr.Cells["SendNum"].Value.ToString());
                }
            }
            ultraGroupBox3.Text = ultraGroupBox3.Text + "      支：" + count + "   吨：" + weght.ToString("f3") + "    长度：" + len.ToString("f3") + "      实发数：" + send.ToString("f3");
        }

        private void ChcVirtual_CheckedChanged(object sender, EventArgs e)
        {
            if (PraFlag.Checked && ChcVirtual.Checked)
            {
                MessageUtil.ShowTips("虚拟发货与过磅不允许同时勾选");
                ChcVirtual.Checked = false;
                return;
            }
            UltraGridRow row = ultraGridOrderInfo.ActiveRow;
            if (row == null)
            {
                return;
            }
            if (ChcVirtual.Checked)
            {
                if (row.Cells["ORDER_UNIT"].Text.Trim().Equals("米") || row.Cells["ORDER_UNIT"].Text.Trim().Equals("英尺"))
                {
                    foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                    {
                        ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                        ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                        ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    }

                }
                else if (row.Cells["ORDER_UNIT"].Text.Equals("支") || row.Cells["ORDER_UNIT"].Text.Equals("个"))
                {
                    foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                    {
                        ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                        ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                        ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    }
                }
                else
                {
                    foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                    {
                        ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                        ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                        ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    }
                }
            }
            else
            {
                if (row.Cells["ORDER_UNIT"].Text.Trim().Equals("米") || row.Cells["ORDER_UNIT"].Text.Trim().Equals("英尺"))
                {
                    foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                    {
                   
                        ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                        ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                        ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    }

                }
                else if (row.Cells["ORDER_UNIT"].Text.Equals("支") || row.Cells["ORDER_UNIT"].Text.Equals("个"))
                {
                    foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                    {
                    
                        ugr1.Cells["SendNum"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                        ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                        ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    }
                }
                else
                {
                    foreach (UltraGridRow ugr1 in ultraGridSourse.Rows)
                    {                 
                        ugr1.Cells["SendNum"].Appearance.BackColor = Color.Transparent;
                        ugr1.Cells["SendNum"].Appearance.BackHatchStyle = BackHatchStyle.None;
                        ugr1.Cells["SendNum"].Activation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                    }
                }
            }
        }

        private void cmbAcount_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            this.ultraGridSourse.UpdateData();
            UltraGridRow row = this.ultraGridSourse.ActiveRow;
            UltraGridRow ugr = ultraGridOrderInfo.ActiveRow;
            if (row == null)
            {
                return;
            }
            FrmMatNo frm = new FrmMatNo(row, ob);
            frm.ShowDialog();
            if (frm.flag.Equals("1"))
            {
                row.Cells["MatNo"].Value = frm.matNo.TrimEnd(new char[] { ',' }).ToString();
                row.Cells["ActCount"].Value = frm.acount.ToString();
                row.Cells["MeasuringSeq"].Value = frm.mesNo.TrimEnd(new char[] { ',' }).ToString();
                row.Cells["ActWeight"].Value = frm.wgt;

                if (ugr.Cells["ORDER_UNIT"].Text.Trim().Equals("米") || ugr.Cells["ORDER_UNIT"].Text.Trim().Equals("英尺"))
                {
                    row.Cells["SendNum"].Value = frm.sumlength;

                }
                else if (ugr.Cells["ORDER_UNIT"].Text.Equals("支") || ugr.Cells["ORDER_UNIT"].Text.Equals("个"))
                {
                    row.Cells["SendNum"].Value = frm.acount;

                }
                else
                {
                    row.Cells["SendNum"].Value = frm.wgt;
                }
            }
            else
            {
                return;
            }
        }

        private void PraFlag_CheckedChanged(object sender, EventArgs e)
        {
            /*if(PraFlag.Checked&&ChcVirtual.Checked)
            {
                MessageUtil.ShowTips("虚拟发货与过磅不允许同时勾选");
                PraFlag.Checked = false;
                return;
            }*/
        }

        private void ultraGridBillM_ClickCellButton(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key.Equals("CarNo"))
            {
                FrmCarManage car = new FrmCarManage();
                car.billNo = e.Cell.Row.Cells["BillNo"].Value.ToString();
                car.ob = this.ob;
                car.ShowDialog();
            }
        }

        private void UpdateItemNo()
        {
            UltraGridRow row = ultraGridBillM.ActiveRow;
            
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.CorePipeCarBill";
            ccp.MethodName = "UpdateItemNo";
            ccp.ServerParams = new object[] { row.Cells["BillNo"].Value.ToString2(), singleNoTxt.Text.ToString2(), itemNoTxt.Text.ToString2() };
            ccp.IfShowErrMsg = false;
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("修改成功！");
                singleNoTxt.Clear();
                itemNoTxt.Clear();
            }
        }
    }
}