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

namespace Core.StlMes.Client.YdmPipeReport
{
    public partial class FrmOrderNoReport : FrmBase
    {
        int i = 0;//点击
        int j = 0;//点击
        int z = 0;//点击
        private string[] _salgPermissions;
        private ArrayList forceList = new ArrayList(); // 强制结齐合同行集合
        public FrmOrderNoReport()
        {
            InitializeComponent();
        }

        private void FrmOrderNoReport_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<SlmOrderLineEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<SlmOrderLineEntity>(ultraGrid4.DisplayLayout.Bands[0]);
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            _salgPermissions = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryOrderStrats", new object[] { "12020", "12020602","1" }, this.ob);
            Txtorderstatus.DataSource = dt;
            Txtorderstatus.DisplayMember = "BASENAME";
            Txtorderstatus.ValueMember = "BASECODE";

            DataTable dt3 = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryOrderStrats", new object[] { "12020", "12020301","0" }, this.ob);
            Txtorderstatus1.DataSource = dt3;
            Txtorderstatus1.DisplayMember = "BASENAME";
            Txtorderstatus1.ValueMember = "BASECODE";

            BaseHelper.GridColumnSum(ultraGridOrderNo, new string[] { "PSS_NUM", "PAY_NUM", "INSTORAGE_NUM", "OUT_NUM", "SENDBILL_NUM", "ACCOUNT_NUM", "ELIM_NUM", "CHARGE_NUM" });
            BaseHelper.GridColumnWeghit(ultraGridOrderNo, new string[] { "ORDER_QTY", "APP_NUM", "PSS_WGT", "PAY_WGT", "PAY_LEN", "INSTORAGE_WGT", "INSTORAGE_LEN", "OUT_WGT", "OUT_LEN", "SENDBILL_WGT", "SENDBILL_LEN", "ACCOUNT_WGT", "ACCOUNT_LEN", "ELIM_WGT", "ELIM_LEN", "CHARGE_WGT", "CHARGE_LEN", "ORDER_YUL" });
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    DoQuery();
                    chkAll.Checked = false;
                    break;
                case "QueryRev":
                    DoQueryRev();
                    break;
                case "Update":
                    DoUpdate();
                    chkAll.Checked = false;
                    break;
                case "ForceUpdate":
                    ForceUpdate();
                    chkAll.Checked = false;
                    break;
                case "Add":
                    DoAdd();
                    chkAll.Checked = false;
                    break;
                case "Delete":
                    DoDelete();
                    chkAll.Checked = false;
                    break;
                case "Print":
                    DoPrint();
                    chkAll.Checked = false;
                    break;
                case "OrderPrint":
                    DoOrderPrint();
                    chkAll.Checked = false;
                    break;
                case "OrderClose":
                    DoOrderClose();
                    break;
                case "UnOrderClose":
                    DoUnOrderClose();
                    break;
                case "AddOrderZx":
                    DoAddOrderZx();
                    break;
                case "DeleteOrderZx":
                    DoDeleteOrderZx();
                    break;
                case "Analysis":
                    DoAnalysis();
                    break;
                case "DoApplyReview":
                    DoApplyReview();
                    break;
                case "UnApplyReview":
                    UnApplyReview();
                    break;
                case "Dosubmission":
                    Dosubmission();
                    break;
                case "Unosubmission":
                    Unsubmission();
                    break;               
                case "Export"://导出
                    DoExport();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 查询注销单
        /// </summary>
        private void DoQueryRev()
        {
            List<string> listS = new List<string>();
            if (ChkL.Checked)
            {
                listS.Add("L");
            }
            if (ChkF.Checked)
            {
                listS.Add("F");
            }
            if (ChkW.Checked)
            {
                listS.Add("W");
            }
            if (ChkS.Checked)
            {
                listS.Add("S");
            }
            string[] strat = listS.ToArray();
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getDoQueryRev", new object[] { strat }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true);
        }
        /// <summary>
        /// 申请审批
        /// </summary>
        private void DoApplyReview()
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            ultraGrid4.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    if (ugr.Cells["Validflag"].Text.ToString().Equals("0"))
                    {
                        MessageUtil.ShowTips("您选择的不是有效合同，不能注销单！");
                        return;
                    }
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["OrdPk"].Value.ToString());
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(ugr.Cells["OrdLnPk"].Value.ToString());
                    list1.Add(txtContent.Text.Trim());
                    list1.Add(txtMemo.Text.Trim());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同行信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否生成评审单?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "doApplyReview";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("新增评审单成功!"))
                {
                    DoQuery();
                    DoQueryRev();
                }
            }

        }
        /// <summary>
        /// 撤销注销单
        /// </summary>
        private void UnApplyReview()
        {
            UltraGridRow row = ultraGrid2.ActiveRow;
            if (row == null) return;
            ultraGrid2.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            foreach (UltraGridRow ugr in ultraGrid2.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["REVIEW_NO"].Value.ToString());
                    list1.Add("X");
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择评审单信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销评审单?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "unApplyReview";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销评审单成功!"))
                {
                    DoQuery();
                    DoQueryRev();
                }
            }

        }
        /// <summary>
        /// 注销单提报
        /// </summary>
        private void Dosubmission()
        {
            UltraGridRow row = ultraGrid2.ActiveRow;
            if (row == null) return;
            ultraGrid2.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGrid2.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["REVIEW_NO"].Value.ToString());
                    list1.Add("X");
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择评审单信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否提报?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "dosubmission";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("提报成功!"))
                {
                    DoQueryRev();
                }
            }

        }
        /// <summary>
        ///撤销提报
        /// </summary>
        private void Unsubmission()
        {
            UltraGridRow row = ultraGrid2.ActiveRow;
            if (row == null) return;
            ultraGrid2.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGrid2.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["REVIEW_NO"].Value.ToString());
                    list1.Add("X");
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择评审单信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销提报?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "unsubmission";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销提报成功!"))
                {
                    DoQueryRev();
                }
            }

        }
        private void DoExport()
        {
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                if (i == 1)
                {
                    GridHelper.ulGridToExcel(ultraGridOrderNo,"余量合同信息");
                }
                else if (i == 2)
                {
                    GridHelper.ulGridToExcel(ultraGridLogout, "余量注销信息");
                }
                else
                {
                    MessageUtil.ShowTips("请点击你要导出的Grid");
                    return;
                }
            }
            else  if (ultraTabControl1.SelectedTab.Key.Equals("1"))
            {
               GridHelper.ulGridToExcel(ultraGrid1, "关闭合同行信息");
            }
            else
            {
                if (z == 1)
                {
                    GridHelper.ulGridToExcel(ultraGrid4, "注销合同行信息");
                }
                else if (z == 2)
                {
                    GridHelper.ulGridToExcel(ultraGrid2, "评审单信息");
                }
                else
                {
                    MessageUtil.ShowTips("请点击你要导出的Grid");
                    return;
                }
            }
        }
        ///查询时验证必填项      
        private bool CheckQuery()
        {
            if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0)
            {
                MessageUtil.ShowTips("开始时间不能大于结束时间！");
                return false;
            }
            if (chkOrder.Checked && string.IsNullOrEmpty(cmbOrder.Text.Trim()))
            {
                MessageBox.Show("请输入合同号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkOrderstatus.Checked && string.IsNullOrEmpty(Txtorderstatus.Text.Trim()))
            {
                MessageBox.Show("请选择合同状态！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            return true;
        }

        private void DoQuery()
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                if (ultraTabControl1.SelectedTab.Key.Equals("0"))
                {
                    DoQueryOrderYl();
                }
                else if (ultraTabControl1.SelectedTab.Key.Equals("1"))
                {
                    DoQueryOrderClose();
                }
                else
                {
                    DoQueryOrderZx();
                }

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

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

        }
        /// <summary>
        /// 查询合同余量
        /// </summary>
        private void DoQueryOrderYl()
        {
            if (!CheckQuery()) return;
            string stratTime = "1999-01-01 00:00:00"; 
            string endTime = "2999-12-31 23:59:59";
            string orderNo = "";
            string orderStrats = "";
            if (chkDate.Checked)
            {
                stratTime = StartTime.Value.ToString();
                endTime = EndTime.Value.ToString();
            }
            if (chkOrder.Checked)
            {
                orderNo = cmbOrder.Text.Trim();
            }
            if (chkOrderstatus.Checked)
            {
                orderStrats = Txtorderstatus.Value.ToString();
            }
            if (!chkDate.Checked && !chkOrderstatus.Checked && !chkOrder.Checked)
            {
                MessageUtil.ShowTips("请至少选择一个条件！");
                return;
            }
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryOrderNoMount", new object[] { stratTime, endTime, orderNo, orderStrats, _salgPermissions }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
            foreach (UltraGridRow row in ultraGridOrderNo.Rows)
            {
                //string fhCount = "";
                if (row.Cells["ORDER_UNIT"].Value.ToString().Equals("吨"))
                {
                    row.Cells["ORDER_YUL"].Value = (double.Parse(row.Cells["OUT_WGT"].Value.ToString()) - double.Parse(row.Cells["ORDER_QTY"].Value.ToString())).ToString("f3");
                    //fhCount = row.Cells["OUT_WGT"].Value.ToString();
                }
                else if (row.Cells["ORDER_UNIT"].Value.ToString().Equals("支") || row.Cells["ORDER_UNIT"].Value.ToString().Equals("个"))
                {
                    row.Cells["ORDER_YUL"].Value = double.Parse(row.Cells["OUT_NUM"].Value.ToString()) - double.Parse(row.Cells["ORDER_QTY"].Value.ToString());
                    //fhCount = row.Cells["OUT_NUM"].Value.ToString();
                }
                else
                {
                    row.Cells["ORDER_YUL"].Value = (double.Parse(row.Cells["OUT_LEN"].Value.ToString()) - double.Parse(row.Cells["ORDER_QTY"].Value.ToString())).ToString("f3");
                    //fhCount = row.Cells["OUT_LEN"].Value.ToString();
                }
                // 强制结齐修改结齐状态
                if (forceList.Contains(row.Cells["ORD_LN_PK"].Value.ToString()))
                {
                    row.Cells["IS_SEND"].Value = "OK";
                    row.Cells["IS_SEND"].Appearance.BackColor = Color.Pink;
                    row.Cells["IS_SEND"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    row.Cells["IS_KNOT"].Value = "OK";
                    row.Cells["IS_KNOT"].Appearance.BackColor = Color.Transparent;
                    row.Cells["IS_KNOT"].Appearance.BackHatchStyle = BackHatchStyle.None;
                }
                ////是否发齐
                //if (int.Parse(row.Cells["ORDER_LN_STATUS"].Value.ToString()) >= 12020602 && double.Parse(fhCount) >= double.Parse(row.Cells["DELVRY_MIN"].Value.ToString()) && int.Parse(row.Cells["INSTORAGE_NUM"].Value.ToString()) == 0)
                //{
                //    row.Cells["IS_SEND"].Value = "OK";
                //}
                //else
                //{
                //    row.Cells["IS_SEND"].Value = "NO";
                //}

                ////是否结齐
                //string NoOut = (double.Parse(row.Cells["OUT_WGT"].Value.ToString()) - double.Parse(row.Cells["ACCOUNT_WGT"].Value.ToString())).ToString("f3");
                //DataTable dt1 = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryBillJs", new object[] { row.Cells["ORD_LN_PK"].Value.ToString() }, this.ob);
                //if (dt1.Rows.Count == 1)
                //{
                //    if (int.Parse(dt1.Rows[0]["BILL_TICKET_STATUS"].ToString()) >= 222 && row.Cells["IS_SEND"].Value.ToString() == "OK" && NoOut == "0.000")
                //    {
                //        row.Cells["IS_KNOT"].Value = "OK";
                //    }
                //    else
                //    {
                //        row.Cells["IS_KNOT"].Value = "NO";
                //    }
                //}
                //else
                //{
                //    row.Cells["IS_KNOT"].Value = "NO";
                //}

            }

        }
       
        /// <summary>
        /// 查询可关闭合同信息
        /// </summary>
        private void DoQueryOrderClose()
        {
            if (!CheckQuery()) return;
            string stratTime = ""; string endTime = "";
            string orderNo = ""; string orderStrats = "";
            if (chkDate.Checked)
            {
                stratTime = StartTime.Value.ToString();
                endTime = EndTime.Value.ToString();
            }
            if (chkOrder.Checked)
            {
                orderNo = cmbOrder.Text.Trim();
            }
            if (chkOrderstatus.Checked)
            {
                orderStrats = Txtorderstatus.Value.ToString();
            }
            List<SlmOrderLineEntity> listSource = EntityHelper.GetData<SlmOrderLineEntity>
               ("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryOrderSeqNo", new object[] { stratTime, endTime, orderNo, orderStrats, _salgPermissions,  "2" ,"1"}, this.ob);
            SlmOrderLineEntitySource.DataSource = listSource;
        }
        /// <summary>
        /// 合同注销
        /// </summary>
        private void DoQueryOrderZx()
        {
            if (!CheckQuery()) return;
            string stratTime = ""; string endTime = "";
            string orderNo = ""; string orderStrats = "";
            if (chkDate.Checked)
            {
                stratTime = StartTime.Value.ToString();
                endTime = EndTime.Value.ToString();
            }
            if (chkOrder.Checked)
            {
                orderNo = cmbOrder.Text.Trim();
            }
            if (chkOrderstatusZx.Checked)
            {
                orderStrats = TxtorderstatusZx.Value.ToString();
            }
            string Validflag = "1";
            if (chkValues.Checked) {
                Validflag = "0";
            }
            List<SlmOrderLineEntity> listSource = EntityHelper.GetData<SlmOrderLineEntity>
               ("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryOrderSeqNo", new object[] { stratTime, endTime, orderNo, orderStrats, _salgPermissions, "1", Validflag }, this.ob);
            SlmOrderLineEntitySource1.DataSource = listSource;
            foreach (UltraGridRow row in ultraGrid4.Rows)
            {
                if (row.Cells["Validflag"].Text.ToString().Equals("0"))
                {
                    row.Appearance.BackColor = Color.Red;
                    row.Appearance.BackHatchStyle = BackHatchStyle.None;
                }
            }

        }

        /// <summary>
        /// 合同状态确认
        /// </summary>
        private void DoUpdate()
        {
            UltraGridRow row = ultraGridOrderNo.ActiveRow;
            if (row == null) return;
            ultraGridOrderNo.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGridOrderNo.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    if (ugr.Cells["IS_SEND"].Text.ToString() == "" || ugr.Cells["IS_KNOT"].Text.ToString() == "")
                    {
                        MessageUtil.ShowTips("请先分析！");
                        return;
                    }
                    if (ugr.Cells["IS_SEND"].Text.ToString() != "OK")
                    {
                        MessageUtil.ShowTips("该合同未发齐！");
                        return;
                    }
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["ORD_PK"].Value.ToString());
                    list1.Add(ugr.Cells["ORD_LN_PK"].Value.ToString());
                    list1.Add(ugr.Cells["IS_SEND"].Value.ToString());
                    list1.Add(ugr.Cells["IS_KNOT"].Value.ToString());
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(ugr.Cells["ORDER_LN_STATUS"].Value.ToString());
                    list1.Add(ugr.Cells["ORDER_TYP"].Value.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

               
                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "updateOrderStrats";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
               
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    DoQuery();
                }
            }
        }

        /// <summary>
        /// 合同状态确认
        /// </summary>
        private void ForceUpdate()
        {
            UltraGridRow row = ultraGridOrderNo.ActiveRow;
            if (row == null) return;
            forceList.Clear();
            ultraGridOrderNo.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            if (MessageUtil.ShowYesNoAndQuestion("是否确认强制结齐?") == DialogResult.No)
            {
                return;
            }
            foreach (UltraGridRow ugr in ultraGridOrderNo.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    forceList.Add(ugr.Cells["ORD_LN_PK"].Value.ToString());

                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["ORD_PK"].Value.ToString());
                    list1.Add(ugr.Cells["ORD_LN_PK"].Value.ToString());
                    list1.Add(ugr.Cells["IS_SEND"].Value.ToString());
                    list1.Add(ugr.Cells["IS_KNOT"].Value.ToString());
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(ugr.Cells["ORDER_LN_STATUS"].Value.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同信息！");
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();


                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "forceUpdateStrats";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

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

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 合同余量注销
        /// </summary>
        private void DoAdd()
        {
            UltraGridRow row = ultraGridOrderNo.ActiveRow;
            if (row == null) return;
            ultraGridOrderNo.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            string yearMatch = DateTime.Now.ToString("yyyyMM");
            foreach (UltraGridRow ugr in ultraGridOrderNo.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["ORD_PK"].Value.ToString());
                    list1.Add(ugr.Cells["ORD_LN_PK"].Value.ToString());
                    list1.Add(ugr.Cells["ORDER_YUL"].Value.ToString());
                    list1.Add(ugr.Cells["ORDER_UNIT"].Value.ToString());
                    list1.Add(ugr.Cells["ORDER_NO"].Value.ToString());
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(yearMatch);
                    list.Add(list1);
                    if (forceList.Contains(ugr.Cells["ORD_LN_PK"].Value.ToString()))
                    {
                        continue;
                    }
                    if (ugr.Cells["IS_SEND"].Text.ToString() == "" || ugr.Cells["IS_KNOT"].Text.ToString() == "")
                    {
                        MessageUtil.ShowTips("请先分析！");
                        return;
                    }
                    if (ugr.Cells["IS_SEND"].Text.ToString() != "OK")
                    {
                        MessageUtil.ShowTips("该合同未发齐！");
                        return;
                    }
                    if (double.Parse(row.Cells["ACCOUNT_WGT"].Value.ToString()) < double.Parse(row.Cells["DELVRY_MIN"].Value.ToString())
                        && double.Parse(row.Cells["OUT_NUM"].Value.ToString()) != double.Parse(row.Cells["ACCOUNT_NUM"].Value.ToString()))
                    {
                        MessageUtil.ShowTips("交货量小于交货量差下线，不能新增！");
                        return;
                    }
                    //if (double.Parse(ugr.Cells["ORDER_YUL"].Value.ToString()) <=0)
                    //{
                    //    MessageUtil.ShowTips("合同余量小于或等于零，不能新增！");
                    //    return;
                    //}
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否注销余量?") == DialogResult.No)
            {
                return;
            }
             CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

            ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
            ccp.MethodName = "addOrderLogout";
            ccp.ServerParams = new object[] { list };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

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

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("合同余量注销成功!"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 撤销
        /// </summary>
        private void DoDelete()
        {
            UltraGridRow row = ultraGridLogout.ActiveRow;
            if (row == null) return;
            ultraGridLogout.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGridLogout.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["ORD_PK"].Value.ToString());
                    list1.Add(ugr.Cells["ORD_LN_PK"].Value.ToString());
                    list1.Add(ugr.Cells["LOGOUT_NO"].Value.ToString());
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(ultraGridOrderNo.ActiveRow.Cells["ORDER_TYP"].Value.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同余量注销信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销注销余量?") == DialogResult.No)
            {
                return;
            }
           CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

            ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
            ccp.MethodName = "deleteOrderLogout";
            ccp.ServerParams = new object[] { list };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销注销成功!"))
                {
                    DoQuery();
                }
            }
        }

        /// <summary>
        /// 撤销合同关闭
        /// </summary>
        private void DoUnOrderClose()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            ultraGrid1.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["OrdPk"].Value.ToString());
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(ugr.Cells["OrdLnPk"].Value.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同行信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销关闭合同?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "unOrderClose";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销关闭成功!"))
                {
                    DoQuery();
                }
            }

        }

        /// <summary>
        /// 合同关闭
        /// </summary>
        private void DoOrderClose()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            ultraGrid1.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["OrdPk"].Value.ToString());              
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(ugr.Cells["OrdLnPk"].Value.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同行信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否关闭合同?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "updateOrderClose";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("关闭成功!"))
                {
                    DoQuery();
                }
            }

        }
        /// <summary>
        /// 按合同打印
        /// </summary>
        private void DoOrderPrint()
        {
            string orderNo = "";
            UltraGridRow ugr = this.ultraGridLogout.ActiveRow;
            if (ugr == null) { MessageUtil.ShowTips("无数据，请确认！"); return; }
            int count = 0;
            foreach (UltraGridRow row in ultraGridLogout.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    count++;
                    orderNo = ugr.Cells["ORDER_NO"].Text.ToString().Split('/')[0];
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要打印的注销单号！");
                return;
            }

            string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOrderLogoutNoAll.cpt&op=view" + "&ORDER_NO=" + orderNo;


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

            ServerHelper.SetData("com.steering.pss.ydm.Report.FrmOrderNoReport.updateLogoutState", new object[] { time, orderNo }, ob);


            FrmRepExcel fBug = new FrmRepExcel(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();
            DoQueryOrderYl();
        }
        /// <summary>
        /// 打印
        /// </summary>
        private void DoPrint() 
        {
            string LogOutNo = "";
            UltraGridRow ugr = this.ultraGridLogout.ActiveRow;
            if (ugr == null) { MessageUtil.ShowTips("无数据，请确认！"); return; }
            int count = 0;
            foreach (UltraGridRow row in ultraGridLogout.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    LogOutNo = ugr.Cells["LOGOUT_NO"].Text.Trim();
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要打印的注销单号！");
                return;
            }
            if (count > 1)
            {
                MessageUtil.ShowTips("请勾选一个注销单号打印！");
                return;
            }

            string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOrderLogoutNo.cpt&op=view" + "&LOGOUTNO=" + LogOutNo;


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

            ServerHelper.SetData("com.steering.pss.ydm.Report.FrmOrderNoReport.queryLogOutNo", new object[] { time, LogOutNo }, ob);


            FrmRepExcel fBug = new FrmRepExcel(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();
            DoQueryOrderYl();
        }
        /// <summary>
        /// 分析
        /// </summary>
        private void DoAnalysis()
        {
            UltraGridRow urg = ultraGridOrderNo.ActiveRow;
            if (urg == null) return;
            int count = 0;
            foreach (UltraGridRow row in ultraGridOrderNo.Rows)
            {
                string fhCount = "";//发货量
                if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    if (row.Cells["ORDER_UNIT"].Value.ToString().Equals("吨"))
                    {
                        fhCount = row.Cells["OUT_WGT"].Value.ToString();
                    }
                    else if (row.Cells["ORDER_UNIT"].Value.ToString().Equals("支") || row.Cells["ORDER_UNIT"].Value.ToString().Equals("个"))
                    {
                        fhCount = row.Cells["OUT_NUM"].Value.ToString();
                    }
                    else
                    {
                        fhCount = row.Cells["OUT_LEN"].Value.ToString();
                    }
                    //是否发齐 发货量大于交货量下限，在库量为0
                    if ((int.Parse(row.Cells["ORDER_LN_STATUS"].Value.ToString()) >= 12020602 || (row.Cells["ORDER_TYP"].Value.ToString().Equals("120102") && int.Parse(row.Cells["ORDER_LN_STATUS"].Value.ToString()) >= 12020301)) 
                        && double.Parse(fhCount) >= double.Parse(row.Cells["DELVRY_MIN"].Value.ToString()) 
                        && int.Parse(row.Cells["INSTORAGE_NUM"].Value.ToString()) == 0)
                    {
                        row.Cells["IS_SEND"].Value = "OK";
                        row.Cells["IS_SEND"].Appearance.BackColor = Color.Pink;
                        row.Cells["IS_SEND"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    }
                    //是否发齐 在库量为0 , 发货量 = 结算量
                    else if ((int.Parse(row.Cells["ORDER_LN_STATUS"].Value.ToString()) >= 12020602 || (row.Cells["ORDER_TYP"].Value.ToString().Equals("120102") && int.Parse(row.Cells["ORDER_LN_STATUS"].Value.ToString()) >= 12020301)) 
                        && int.Parse(row.Cells["INSTORAGE_NUM"].Value.ToString()) == 0
                        && double.Parse(row.Cells["OUT_NUM"].Value.ToString()) == double.Parse(row.Cells["ACCOUNT_NUM"].Value.ToString()))
                    {
                        row.Cells["IS_SEND"].Value = "OK";
                        row.Cells["IS_SEND"].Appearance.BackColor = Color.Pink;
                        row.Cells["IS_SEND"].Appearance.BackHatchStyle = BackHatchStyle.None;
                    }
                    else
                    {
                        row.Cells["IS_SEND"].Value = "NO";
                        row.Cells["IS_SEND"].Appearance.BackColor = Color.Transparent;
                        row.Cells["IS_SEND"].Appearance.BackHatchStyle = BackHatchStyle.Default;
                    }

                    //是否结齐 发货量等于结算量
                    string NoOut = (double.Parse(row.Cells["OUT_WGT"].Value.ToString()) - double.Parse(row.Cells["ACCOUNT_WGT"].Value.ToString())).ToString("f3");
                    DataTable dt1 = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryBillJs", new object[] { row.Cells["ORD_LN_PK"].Value.ToString() }, this.ob);
                    if (dt1.Rows.Count == 1)
                    {
                        if (int.Parse(dt1.Rows[0]["BILL_TICKET_STATUS"].ToString()) >= 222 
                            && row.Cells["IS_SEND"].Value.ToString() == "OK"
                            && (double.Parse(row.Cells["ACCOUNT_WGT"].Value.ToString()) >= double.Parse(row.Cells["DELVRY_MIN"].Value.ToString())))
                        {
                            row.Cells["IS_KNOT"].Value = "OK";
                            row.Cells["IS_KNOT"].Appearance.BackColor = Color.Transparent;
                            row.Cells["IS_KNOT"].Appearance.BackHatchStyle = BackHatchStyle.None;
                        }
                        else if (int.Parse(dt1.Rows[0]["BILL_TICKET_STATUS"].ToString()) >= 222 && row.Cells["IS_SEND"].Value.ToString() == "OK"
                         && double.Parse(row.Cells["OUT_NUM"].Value.ToString()) == double.Parse(row.Cells["ACCOUNT_NUM"].Value.ToString()))
                        {
                            row.Cells["IS_KNOT"].Value = "OK";
                            row.Cells["IS_KNOT"].Appearance.BackColor = Color.Transparent;
                            row.Cells["IS_KNOT"].Appearance.BackHatchStyle = BackHatchStyle.None;
                        }
                        else
                        {
                            row.Cells["IS_KNOT"].Value = "NO";
                            row.Cells["IS_KNOT"].Appearance.BackColor = Color.Transparent;
                            row.Cells["IS_KNOT"].Appearance.BackHatchStyle = BackHatchStyle.Default;
                        }
                    }
                    else
                    {
                        row.Cells["IS_KNOT"].Value = "NO";
                        row.Cells["IS_KNOT"].Appearance.BackColor = Color.Transparent;
                        row.Cells["IS_KNOT"].Appearance.BackHatchStyle = BackHatchStyle.Default;
                    }

                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择要分析的数据！");
                return;
            }
        }

        /// <summary>
        /// 合同注销
        /// </summary>
        private void DoAddOrderZx()
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            ultraGrid4.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    if (ugr.Cells["Validflag"].Text.ToString().Equals("0"))
                    {
                        MessageUtil.ShowTips("您选择的不是有效合同，不能注销！");
                        return;
                    }
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["OrdPk"].Value.ToString());
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(ugr.Cells["OrdLnPk"].Value.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同行信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否注销合同?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "updateOrderZx";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("合同注销成功!"))
                {
                    DoQuery();
                }
            }

        }
        /// <summary>
        /// 撤销注销合同
        /// </summary>
        private void DoDeleteOrderZx()
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            ultraGrid4.UpdateData();
            int count = 0;
            ArrayList list = new ArrayList();
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            foreach (UltraGridRow ugr in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    if (ugr.Cells["Validflag"].Text.ToString().Equals("1"))
                    {
                        MessageUtil.ShowTips("您选择的是有效合同行，不能撤销！");
                        return;
                    }
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["OrdPk"].Value.ToString());
                    list1.Add(this.UserInfo.GetUserName());
                    list1.Add(time);
                    list1.Add(ugr.Cells["OrdLnPk"].Value.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请选择合同行信息！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销注销合同?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.pss.ydm.Report.FrmOrderNoReport";
                ccp.MethodName = "deleteOrderZx";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销注销合同成功!"))
                {
                    DoQuery();
                }
            }

        }
        private void chkDate_CheckedChanged(object sender, EventArgs e)
        {
            if (chkDate.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; }
            if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; }
            if (chkOrderstatus.Checked) { Txtorderstatus.Enabled = true; } else { Txtorderstatus.Enabled = false; }
            if (chkOrderstatusZx.Checked) { TxtorderstatusZx.Enabled = true; } else { TxtorderstatusZx.Enabled = false; }
        }

        private void ultraGridOrderNo_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGridOrderNo.ActiveRow;
            if (row == null) return;
            string ordLnPk = row.Cells["ORD_LN_PK"].Value.ToString();
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryLogoutNo", new object[] { ordLnPk }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
        }

        private void FrmOrderNoReport_Shown(object sender, EventArgs e)
        {
            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.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("OrderPrint")) { toolMenu.Toolbars[0].Tools["OrderPrint"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("Analysis")) { toolMenu.Toolbars[0].Tools["Analysis"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("ForceUpdate")) { toolMenu.Toolbars[0].Tools["ForceUpdate"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("OrderClose")) { toolMenu.Toolbars[0].Tools["OrderClose"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("UnOrderClose")) { toolMenu.Toolbars[0].Tools["UnOrderClose"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("AddOrderZx")) { toolMenu.Toolbars[0].Tools["AddOrderZx"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("DeleteOrderZx")) { toolMenu.Toolbars[0].Tools["DeleteOrderZx"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("QueryRev")) { toolMenu.Toolbars[0].Tools["QueryRev"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("DoApplyReview")) { toolMenu.Toolbars[0].Tools["DoApplyReview"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("UnApplyReview")) { toolMenu.Toolbars[0].Tools["UnApplyReview"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("Dosubmission")) { toolMenu.Toolbars[0].Tools["Dosubmission"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("Unosubmission")) { toolMenu.Toolbars[0].Tools["Unosubmission"].InstanceProps.Visible = DefaultableBoolean.False; }

            
        }
        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (e.Tab.TabControl.SelectedTab.Key.Equals("0"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("ForceUpdate")) { toolMenu.Toolbars[0].Tools["ForceUpdate"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("OrderPrint")) { toolMenu.Toolbars[0].Tools["OrderPrint"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Analysis")) { toolMenu.Toolbars[0].Tools["Analysis"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("OrderClose")) { toolMenu.Toolbars[0].Tools["OrderClose"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UnOrderClose")) { toolMenu.Toolbars[0].Tools["UnOrderClose"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("AddOrderZx")) { toolMenu.Toolbars[0].Tools["AddOrderZx"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("DeleteOrderZx")) { toolMenu.Toolbars[0].Tools["DeleteOrderZx"].InstanceProps.Visible = DefaultableBoolean.False; }

                if (toolMenu.Toolbars[0].Tools.Exists("QueryRev")) { toolMenu.Toolbars[0].Tools["QueryRev"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("DoApplyReview")) { toolMenu.Toolbars[0].Tools["DoApplyReview"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UnApplyReview")) { toolMenu.Toolbars[0].Tools["UnApplyReview"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Dosubmission")) { toolMenu.Toolbars[0].Tools["Dosubmission"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Unosubmission")) { toolMenu.Toolbars[0].Tools["Unosubmission"].InstanceProps.Visible = DefaultableBoolean.False; }

                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryOrderStrats", new object[] { "12020", "12020602","1" }, this.ob);
                Txtorderstatus.DataSource = dt;
                Txtorderstatus.DisplayMember = "BASENAME";
                Txtorderstatus.ValueMember = "BASECODE";

                chkOrderstatusZx.Visible = false;
                chkOrderstatus.Visible = true;
                Txtorderstatus.Visible = true;
                TxtorderstatusZx.Visible = false;
                chkValues.Visible = false;
                chkOrderstatus.Checked = false;
                chkOrderstatusZx.Checked = false;

            }
            else if (e.Tab.TabControl.SelectedTab.Key.Equals("1"))
            {

                if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("ForceUpdate")) { toolMenu.Toolbars[0].Tools["ForceUpdate"].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("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].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("OrderPrint")) { toolMenu.Toolbars[0].Tools["OrderPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Analysis")) { toolMenu.Toolbars[0].Tools["Analysis"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("OrderClose")) { toolMenu.Toolbars[0].Tools["OrderClose"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("UnOrderClose")) { toolMenu.Toolbars[0].Tools["UnOrderClose"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("AddOrderZx")) { toolMenu.Toolbars[0].Tools["AddOrderZx"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("DeleteOrderZx")) { toolMenu.Toolbars[0].Tools["DeleteOrderZx"].InstanceProps.Visible = DefaultableBoolean.False; }


                if (toolMenu.Toolbars[0].Tools.Exists("QueryRev")) { toolMenu.Toolbars[0].Tools["QueryRev"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("DoApplyReview")) { toolMenu.Toolbars[0].Tools["DoApplyReview"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UnApplyReview")) { toolMenu.Toolbars[0].Tools["UnApplyReview"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Dosubmission")) { toolMenu.Toolbars[0].Tools["Dosubmission"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Unosubmission")) { toolMenu.Toolbars[0].Tools["Unosubmission"].InstanceProps.Visible = DefaultableBoolean.False; }
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryOrderStrats", new object[] { "12020", "12020802","0" }, this.ob);
                Txtorderstatus.DataSource = dt;
                Txtorderstatus.DisplayMember = "BASENAME";
                Txtorderstatus.ValueMember = "BASECODE";

                chkOrderstatusZx.Visible = false;
                chkOrderstatus.Visible = true;
                Txtorderstatus.Visible = true;
                TxtorderstatusZx.Visible = false;
                chkValues.Visible = false;
                chkOrderstatus.Checked = false;
                chkOrderstatusZx.Checked = false;
            }
            else
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("ForceUpdate")) { toolMenu.Toolbars[0].Tools["ForceUpdate"].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("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].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("OrderPrint")) { toolMenu.Toolbars[0].Tools["OrderPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Analysis")) { toolMenu.Toolbars[0].Tools["Analysis"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("OrderClose")) { toolMenu.Toolbars[0].Tools["OrderClose"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("UnOrderClose")) { toolMenu.Toolbars[0].Tools["UnOrderClose"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("AddOrderZx")) { toolMenu.Toolbars[0].Tools["AddOrderZx"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("DeleteOrderZx")) { toolMenu.Toolbars[0].Tools["DeleteOrderZx"].InstanceProps.Visible = DefaultableBoolean.True; }

                if (toolMenu.Toolbars[0].Tools.Exists("QueryRev")) { toolMenu.Toolbars[0].Tools["QueryRev"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("DoApplyReview")) { toolMenu.Toolbars[0].Tools["DoApplyReview"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("UnApplyReview")) { toolMenu.Toolbars[0].Tools["UnApplyReview"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Dosubmission")) { toolMenu.Toolbars[0].Tools["Dosubmission"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Unosubmission")) { toolMenu.Toolbars[0].Tools["Unosubmission"].InstanceProps.Visible = DefaultableBoolean.True; }
                //DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOrderNoReport.getQueryOrderStrats", new object[] { "12020", "12020101","0" }, this.ob);
                //Txtorderstatus.DataSource = dt;
                //Txtorderstatus.DisplayMember = "BASENAME";
                //Txtorderstatus.ValueMember = "BASECODE";
                chkOrderstatusZx.Visible = true;
                chkOrderstatus.Visible = false;
                Txtorderstatus.Visible = false;
                TxtorderstatusZx.Visible = true;
                chkValues.Visible = false; 
                chkOrderstatus.Checked = false;
                chkOrderstatusZx.Checked = false;
            }
        }
        private void ultraGridOrderNo_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGridOrderNo.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
        }

        private void ultraGridLogout_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGridLogout.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
        }
 
        private void StartTime_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                DoQuery();
            }
        }

        private void chkAll_CheckedChanged(object sender, EventArgs e)
        {
            int chkint = 0;
            if (chkAll.Checked)
            {
                List<UltraGridRow> rows = this.ultraGridOrderNo.Rows.Where(p => p.IsFilteredOut == false).ToList();
                foreach (UltraGridRow uRow in rows)
                {
                    //if (uRow.Cells["CXSTUPP"].Value.ToString().Equals(""))
                    //{
                    //    chkint += 1;
                    //    if (chkint > 50) return;
                    uRow.Cells["CHK"].Value = true;
                    //}
                }
            }
            else
            {
                List<UltraGridRow> rows = this.ultraGridOrderNo.Rows.Where(p => p.IsFilteredOut == false).ToList();
                foreach (UltraGridRow uRow in rows)
                {
                    uRow.Cells["CHK"].Value = false;
                }
            }
        }

        private void ultraGridOrderNo_Click(object sender, EventArgs e)
        {
            i = 1;
        }

        private void ultraGridLogout_Click(object sender, EventArgs e)
        {
            i = 2;
        }


        private void ultraGrid1_Click(object sender, EventArgs e)
        {
            j = 2;
        }

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

        private void ultraGrid4_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGrid4.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
            string orderNo = "";
            string Content = "";
            foreach (UltraGridRow urg in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(urg.Cells["CHK"].Value) == true)
                {
                    orderNo = urg.Cells["OrderSeq"].Value.ToString().Split('/')[0];//得到合同号                   
                    Content += urg.Cells["OrderSeq"].Value.ToString().Split('/')[0];
                    break;
                }

            }
            string orderNo1 = "";
            foreach (UltraGridRow urg1 in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(urg1.Cells["CHK"].Value) == true)
                {
                    orderNo1 = urg1.Cells["OrderSeq"].Value.ToString().Split('/')[0];//得到合同                
                    Content += "/" + urg1.Cells["OrderSeq"].Value.ToString().Split('/')[1];
                    if (orderNo != orderNo1)
                    {
                        MessageUtil.ShowTips("请选择相同合同号！");
                        urg1.Cells["CHK"].Value = false;
                        return;
                    }
                }

            }
            txtContent.Text = Content + "：合同注销";
        }

        private void ultraGrid4_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid4.UpdateData();
            if (e.Cell.Column.Key.Equals("CHK"))
            {
                string orderNo = "";
                string Content = "";
                foreach (UltraGridRow urg in ultraGrid4.Rows)
                {
                    if (Convert.ToBoolean(urg.Cells["CHK"].Value) == true)
                    {
                        orderNo = urg.Cells["OrderSeq"].Value.ToString().Split('/')[0];//得到合同号                   
                        Content += urg.Cells["OrderSeq"].Value.ToString().Split('/')[0];
                        break;
                    }

                }
                string orderNo1 = "";
                foreach (UltraGridRow urg1 in ultraGrid4.Rows)
                {
                    if (Convert.ToBoolean(urg1.Cells["CHK"].Value) == true)
                    {
                        orderNo1 = urg1.Cells["OrderSeq"].Value.ToString().Split('/')[0];//得到合同                
                        Content += "/" + urg1.Cells["OrderSeq"].Value.ToString().Split('/')[1];
                        if (orderNo != orderNo1)
                        {
                            MessageUtil.ShowTips("请选择相同合同号！");
                            urg1.Cells["CHK"].Value = false;
                            return;
                        }
                    }
                  
                }
                txtContent.Text = Content+"：合同注销";
            }
        }

        private void ultraGrid4_Click(object sender, EventArgs e)
        {
            z = 1;
        }

        private void ultraGrid2_Click(object sender, EventArgs e)
        {
            z = 2;
        }

        /// <summary>
        /// 合同关闭全选
        /// </summary>
        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBox1.Checked)
            {
                List<UltraGridRow> rows = this.ultraGrid1.Rows.Where(p => p.IsFilteredOut == false).ToList();
                foreach (UltraGridRow uRow in rows)
                {
                    uRow.Cells["CHK"].Value = true;
                }
            }
            else
            {
                List<UltraGridRow> rows = this.ultraGrid1.Rows.Where(p => p.IsFilteredOut == false).ToList();
                foreach (UltraGridRow uRow in rows)
                {
                    uRow.Cells["CHK"].Value = false;
                }
            }
        }

    }
}