MES_Client/TGMES/Core.StlMes.Client.Pms/ck/FrmCkOutInCarryRecord.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using Pur.Entity;
using Pur.Entity.configureEntity;
using Pur.PublicTools;
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 Pur.ck
{
    //采购量
    //STATUS1默认 2已结转 3已生成结算单 4财务已内部结算
    public partial class FrmCkOutInCarryRecord : FrmPmsBase
    {
        public FrmCkOutInCarryRecord()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            //ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

        private void FrmCkOutInCarryRecord_Load(object sender, EventArgs e)
        {
            InitColumns();

            ChangeStyle();

            SetSumCount();

            InitBindBox();
        }

        private void InitColumns()
        {
            PublicPur.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" });
            PublicPur.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" });
            PublicPur.setOtherColumnReadOnly(ultraGrid3_1, new string[] { "CHK" });

            string[] arrColumnsDetail = new string[] { "CHK", "PRINT_CODE", "IN_STOCK_NO", "SUPP_CODE", "SUPP_NAME", "ORDER_ID", "ORDER_LINE_SQE", "BATCH_NO", "ITEM_CLASS_CODE", "ITEM_CODE", "ITEM_NAME", "BUY_PRICE", "BUY_QTY", "INV_PRICE", "INV_QTY", "INV_AMT", "BUG_PRICE", "INV_AMT_BUG", "IN_BALANCE_NO" };
            string[] arrColumnsCaptionDetail = new string[] { "选择", "打印单号", "入库单号", "供应商", "供应商", "合同号", "合同行号", "批次号", "物料大类", "物料编码", "物料名称", "采购单价", "采购数量", "库存单价", "入库数量", "总价", "计划价", "计划金额", "结算单号" };
            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable1_2, ultraGrid1_2, new string[] { "ORDER_ID", "SUPP_CODE", "BATCH_NO", "ITEM_CLASS_CODE" }, false, new string[] { "CHK" });
            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable3_2, ultraGrid3_2, new string[] { "ORDER_ID", "SUPP_CODE", "BATCH_NO", "ITEM_CLASS_CODE" }, false, new string[] { "CHK" });

            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable1_3, ultraGrid1_3, new string[] { "ORDER_ID", "SUPP_CODE", "ORDER_ID", "ORDER_LINE_SQE", "SUPP_CODE", "SUPP_NAME", "ITEM_CLASS_CODE", "BUY_PRICE", "BUY_QTY" }, false, new string[] { "CHK" });
            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable3_3, ultraGrid3_3, new string[] { "ORDER_ID", "SUPP_CODE", "ORDER_ID", "ORDER_LINE_SQE", "SUPP_CODE", "SUPP_NAME", "ITEM_CLASS_CODE", "BUY_PRICE", "BUY_QTY" }, false, new string[] { "CHK" });

            dataTable1_3.Columns["IN_STOCK_NO"].Caption = "出库单号";
            dataTable1_3.Columns["INV_QTY"].Caption = "出库数量";
            dataTable3_3.Columns["IN_STOCK_NO"].Caption = "出库单号";
            dataTable3_3.Columns["INV_QTY"].Caption = "出库数量";
        }

        //调整格式
        private void ChangeStyle()
        {
            PublicPur.InitCellPositionRight(new UltraGrid[] { ultraGrid1, ultraGrid2, ultraGrid3_1 }, new string[] { "BUG_PRICE", "INV_PREVIOUS_BALANCE_QTY", "INV_PREVIOUS_BALANCE_AMT", "INV_PREVIOUS_BALANCE_AMT_BUG", "INV_IN_QTY", "INV_IN_AMT", "INV_IN_AMT_BUG", "INV_OUT_QTY", "INV_OUT_AMT", "INV_OUT_AMT_BUG", "INV_ENDING_BALANCE_QTY", "INV_ENDING_BALANCE_AMT", "INV_ENDING_BALANCE_AMT_BUG", "INV_QTY", "INV_AMT", "INV_AMT_BUG" });
            PublicPur.InitColumnShowLength(new UltraGrid[] { ultraGrid1, ultraGrid2, ultraGrid3_1 }, 0, new string[] { "INV_PREVIOUS_BALANCE_QTY", "INV_IN_QTY", "INV_OUT_QTY", "INV_ENDING_BALANCE_QTY", "INV_QTY" }, 4, false);//入库量保留4位
            PublicPur.InitColumnShowLength(new UltraGrid[] { ultraGrid1, ultraGrid2, ultraGrid3_1 }, 0, new string[] { "BUG_PRICE", "INV_PREVIOUS_BALANCE_AMT", "INV_PREVIOUS_BALANCE_AMT_BUG", "INV_IN_AMT", "INV_IN_AMT_BUG", "INV_OUT_AMT", "INV_OUT_AMT_BUG", "INV_ENDING_BALANCE_AMT", "INV_ENDING_BALANCE_AMT_BUG", "INV_AMT", "INV_AMT_BUG" }, 2, false);//金额保留两位

            //PublicPur.InitCellPositionRight(ultraGrid2, new string[] { "BUG_PRICE", "INV_PREVIOUS_BALANCE_QTY", "INV_PREVIOUS_BALANCE_AMT", "INV_IN_QTY", "INV_IN_AMT", "INV_OUT_QTY", "INV_OUT_AMT", "INV_ENDING_BALANCE_QTY", "INV_ENDING_BALANCE_AMT", "INV_QTY", "INV_AMT" });
            //PublicPur.InitColumnShowLength(ultraGrid2, 0, new string[] { "INV_PREVIOUS_BALANCE_QTY", "INV_IN_QTY", "INV_OUT_QTY", "INV_ENDING_BALANCE_QTY", "INV_QTY" }, 4, false);//入库量保留4位
            //PublicPur.InitColumnShowLength(ultraGrid2, 0, new string[] { "BUG_PRICE", "INV_PREVIOUS_BALANCE_AMT", "INV_PREVIOUS_BALANCE_AMT_BUG", "INV_IN_AMT", "INV_IN_AMT_BUG", "INV_OUT_AMT", "INV_OUT_AMT_BUG", "INV_ENDING_BALANCE_AMT", "INV_ENDING_BALANCE_AMT_BUG", "INV_AMT", "INV_AMT_BUG" }, 2, false);//金额保留两位

            //PublicPur.InitCellPositionRight(ultraGrid3_1, new string[] { "BUG_PRICE", "INV_PREVIOUS_BALANCE_QTY", "INV_PREVIOUS_BALANCE_AMT", "INV_PREVIOUS_BALANCE_AMT_BUG", "INV_IN_QTY", "INV_IN_AMT", "INV_IN_AMT_BUG", "INV_OUT_QTY", "INV_OUT_AMT", "INV_OUT_AMT_BUG", "INV_ENDING_BALANCE_QTY", "INV_ENDING_BALANCE_AMT", "INV_ENDING_BALANCE_AMT_BUG", "INV_QTY", "INV_AMT", "INV_AMT_BUG" });
            //PublicPur.InitColumnShowLength(ultraGrid3_1, 0, new string[] { "INV_PREVIOUS_BALANCE_QTY", "INV_IN_QTY", "INV_OUT_QTY", "INV_ENDING_BALANCE_QTY", "INV_QTY" }, 4, false);//入库量保留4位
            //PublicPur.InitColumnShowLength(ultraGrid3_1, 0, new string[] { "BUG_PRICE", "INV_PREVIOUS_BALANCE_AMT", "INV_PREVIOUS_BALANCE_AMT_BUG", "INV_IN_AMT", "INV_IN_AMT_BUG", "INV_OUT_AMT", "INV_OUT_AMT_BUG", "INV_ENDING_BALANCE_AMT", "INV_ENDING_BALANCE_AMT_BUG", "INV_AMT", "INV_AMT_BUG" }, 2, false);//金额保留两位

            PublicPur.InitCellPositionRight(new UltraGrid[] { ultraGrid1_2, ultraGrid1_3, ultraGrid3_2, ultraGrid3_3 }, new string[] { "BUY_PRICE", "BUY_QTY", "INV_PRICE", "INV_QTY", "INV_AMT", "BUG_PRICE", "INV_AMT_BUG" });
            PublicPur.InitColumnShowLength(new UltraGrid[] { ultraGrid1_2, ultraGrid1_3, ultraGrid3_2, ultraGrid3_3 }, 0, new string[] { "BUY_QTY", "INV_QTY", }, 4, false);//入库量保留4位
            PublicPur.InitColumnShowLength(new UltraGrid[] { ultraGrid1_2, ultraGrid1_3, ultraGrid3_2, ultraGrid3_3 }, 0, new string[] { "BUY_PRICE", "INV_PRICE", "INV_AMT", "BUG_PRICE", "INV_AMT_BUG" }, 2, false);//金额保留两位

            //PublicPur.InitCellPositionRight(ultraGrid3_2, new string[] { "BUY_PRICE", "BUY_QTY", "INV_PRICE", "INV_QTY", "INV_AMT", "BUG_PRICE", "INV_AMT_BUG" });
            //PublicPur.InitColumnShowLength(ultraGrid3_2, 0, new string[] { "BUY_QTY", "INV_QTY", }, 4, false);//入库量保留4位
            //PublicPur.InitColumnShowLength(ultraGrid3_2, 0, new string[] { "BUY_PRICE", "INV_PRICE", "INV_AMT", "BUG_PRICE", "INV_AMT_BUG" }, 2, false);//金额保留两位

            //PublicPur.InitCellPositionRight(ultraGrid3_3, new string[] { "BUY_PRICE", "BUY_QTY", "INV_PRICE", "INV_QTY", "INV_AMT", "BUG_PRICE", "INV_AMT_BUG" });
            //PublicPur.InitColumnShowLength(ultraGrid3_3, 0, new string[] { "BUY_QTY", "INV_QTY", }, 4, false);//入库量保留4位
            //PublicPur.InitColumnShowLength(ultraGrid3_3, 0, new string[] { "BUY_PRICE", "INV_PRICE", "INV_AMT", "BUG_PRICE", "INV_AMT_BUG" }, 2, false);//金额保留两位
        }

        //设置统计风格
        private void SetSumCount()
        {
            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0:F4}", "{0:F4}", "{0:F2}", "{0:F2}" }, new string[] { "IN_STOCK_NO", "BUY_QTY", "INV_QTY", "INV_AMT", "INV_AMT_BUG" }, this.ultraGrid1_2.DisplayLayout.Bands[0], SummaryDisplayAreas.BottomFixed);
            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0:F4}", "{0:F4}", "{0:F2}", "{0:F2}" }, new string[] { "IN_STOCK_NO", "BUY_QTY", "INV_QTY", "INV_AMT", "INV_AMT_BUG" }, this.ultraGrid1_3.DisplayLayout.Bands[0], SummaryDisplayAreas.BottomFixed);

            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0:F4}", "{0:F2}", "{0:F2}", "{0:F4}", "{0:F2}", "{0:F2}", "{0:F4}", "{0:F2}", "{0:F2}", "{0:F4}", "{0:F2}", "{0:F2}" }, new string[] { "ITEM_NAME", "INV_PREVIOUS_BALANCE_QTY", "INV_PREVIOUS_BALANCE_AMT", "INV_PREVIOUS_BALANCE_AMT_BUG", "INV_IN_QTY", "INV_IN_AMT", "INV_IN_AMT_BUG", "INV_OUT_QTY", "INV_OUT_AMT", "INV_OUT_AMT_BUG", "INV_ENDING_BALANCE_QTY", "INV_ENDING_BALANCE_AMT", "INV_ENDING_BALANCE_AMT_BUG" }, this.ultraGrid2.DisplayLayout.Bands[0], SummaryDisplayAreas.TopFixed);

            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0:F4}", "{0:F4}", "{0:F2}", "{0:F2}" }, new string[] { "IN_STOCK_NO", "BUY_QTY", "INV_QTY", "INV_AMT", "INV_AMT_BUG" }, this.ultraGrid3_2.DisplayLayout.Bands[0], SummaryDisplayAreas.BottomFixed);
            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0:F4}", "{0:F4}", "{0:F2}", "{0:F2}" }, new string[] { "IN_STOCK_NO", "BUY_QTY", "INV_QTY", "INV_AMT", "INV_AMT_BUG" }, this.ultraGrid3_3.DisplayLayout.Bands[0], SummaryDisplayAreas.BottomFixed);
        }

        private void InitBindBox()
        {
            PurmatclassEntity mat = new PurmatclassEntity();
            mat.Validflag = "1";
            DataTable dt = this.execute<DataTable>("com.hnshituo.pur.configure.service.MatClassService", "getMatClass", new object[] { mat });

            publicPms.FilComboboxAdd(ultraQueryBASENAME, dt, "BASECODE", "BASENAME", "", true, "/", "");//绑定物料中类
        }

        //菜单按钮事件
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        QueryCkOutInCarryRecord();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCkOutInCarryRecord_Confirm();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        QueryCkOutInCarryRecord_ConfirmClass();
                    }
                    break;
                case "Carry"://确认结转
                    CarryCkOutInCarryRecord();
                    break;
                case "Change"://调整结转年月
                    ChangeCkOutInCarryRecord();
                    break;
                case "Cancel"://取消操作
                    CancelCarryCkOutInCarryRecord();
                    break;
                case "Confirm"://编制内部结算单
                    ConfirmCkOutInCarryRecord();
                    break;
                case "CancelConfirm"://取消编制内部结算单
                    CancelConfirmCkOutInCarryRecord();
                    break;
                case "Print"://打印
                    PrintCkOutInCarryRecord();
                    break;
                case "Export"://导出
                    ExportCkOutInCarryRecord();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void ChangeCkOutInCarryRecord()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了出入库信息页才能进行调整结转年月操作！");
                    return;
                }
                if (ultraGrid1.ActiveRow == null || dataTable1.Rows.Count == 0)
                {
                    return;
                }
                if (dateGoTo.DateTime <= DateTime.Now)
                {
                    MessageUtil.ShowTips("调整年月不能小于等于当前年月！");
                    return;
                }
                ultraGrid1_2.UpdateData();
                DataRow[] arrInDr = dataTable1_2.Select("CHK = 'TRUE'");

                ultraGrid1_3.UpdateData();
                DataRow[] arrOutDr = dataTable1_3.Select("CHK = 'TRUE'");
                if ((arrInDr == null || arrInDr.Length == 0) && (arrOutDr == null || arrOutDr.Length == 0))
                {
                    MessageUtil.ShowTips("请至少选择一条需要调整结转年月的入库或者出库信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认调整结转年月？") == DialogResult.Yes)
                {
                    string strACCOUNT_PERIOD = dateGoTo.DateTime.ToString("yyyyMM");
                    string strITEM_CODE = ultraGrid1.ActiveRow.Cells["ITEM_CODE"].Text.ToString();

                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();
                    ArrayList alBaseParams = new ArrayList();

                    ArrayList alUpdateInBill = new ArrayList();
                    ArrayList alUpdateInBillParams = new ArrayList();

                    ArrayList alUpdateOutBill = new ArrayList();
                    ArrayList alUpdateOutBillParams = new ArrayList();

                    foreach (DataRow dr in arrInDr)
                    {
                        alUpdateInBillParams = new ArrayList();
                        alUpdateInBillParams.Add(strACCOUNT_PERIOD);
                        alUpdateInBillParams.Add(dr["IN_STOCK_NO"].ToString().Trim());
                        alUpdateInBill.Add(alUpdateInBillParams);
                    }

                    foreach (DataRow dr in arrOutDr)
                    {
                        alUpdateOutBillParams = new ArrayList();
                        alUpdateOutBillParams.Add(strACCOUNT_PERIOD);
                        alUpdateOutBillParams.Add(dr["IN_STOCK_NO"].ToString().Trim());
                        alUpdateOutBill.Add(alUpdateOutBillParams);
                    }

                    //all.Add(alBase);
                    all.Add(alUpdateInBill);
                    all.Add(alUpdateOutBill);

                    PublicServer.SetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.ChangeCkOutInCarryRecord",
        new Object[] { all }, ob);

                    QueryCkOutInCarryRecord();
                    PublicPur.ActiveOperateRow(ultraGrid1, "ITEM_CODE", strITEM_CODE);

                    MessageUtil.ShowTips("调整结转年月成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void PrintCkOutInCarryRecord()
        {
            if (ultraTabControl1.SelectedTab.Index != 2)
            {
                return;
            }
            this.Cursor = Cursors.WaitCursor;
            UltraGridRow ugr = ultraGrid3_1.ActiveRow;
            if (ugr == null)
            {
                MessageUtil.ShowWarning("请选择您要打印的结算单！");
                return;
            }
            string strBALANCE_NO = ugr.Cells["IN_BALANCE_NO"].Value.ToString();
            string strITEM_CLASS_CODE = ugr.Cells["ITEM_CLASS_CODE"].Value.ToString();
            if (strBALANCE_NO == "")
            {
                return;
            }
            string strurl = "";
            //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
            //{
            //    strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=rpt_InBalanceBill_Print.cpt&bypagesize=false&BALANCE_NO = " + strBALANCE_NO;
            //}
            //else
            //{
            strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=rpt_InBalanceBill_Print.cpt&bypagesize=false&BALANCE_NO= " + strBALANCE_NO;
            //}
            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.Show();
            QueryCkOutInCarryRecord_ConfirmClass();
            PublicPur.ActiveOperateRow(ultraGrid3_1, "ITEM_CLASS_CODE", strITEM_CLASS_CODE);
        }

        private void ConfirmCkOutInCarryRecord()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 2)
                {
                    MessageUtil.ShowTips("只有选择了结算单编制页才能进行编制操作！");
                    return;
                }
                if (dataTable3_1.Rows.Count == 0 || (dataTable3_2.Rows.Count == 0 && dataTable3_3.Rows.Count == 0))
                {
                    return;
                }
                ultraGrid3_1.UpdateData();
                DataRow[] arrDr = dataTable3_1.Select("CHK = 'TRUE' AND IN_BALANCE_NO IS NULL");
                if (arrDr == null || arrDr.Length == 0 || arrDr.Length > 1)
                {
                    MessageUtil.ShowTips("请选择一条需要编制且结算编号为空的信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认编制？") == DialogResult.Yes)
                {
                    string strACCOUNT_PERIOD = dateBegin.DateTime.ToString("yyyyMM");

                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();
                    ArrayList alBaseParams = new ArrayList();

                    ArrayList alUpdateInBill = new ArrayList();
                    ArrayList alUpdateInBillParams = new ArrayList();

                    ArrayList alUpdateOutBill = new ArrayList();
                    ArrayList alUpdateOutBillParams = new ArrayList();

                    foreach (DataRow dr in arrDr)
                    {
                        alBaseParams = new ArrayList();
                        alBaseParams.Add("3");
                        alBaseParams.Add("2");
                        alBaseParams.Add(dr["ITEM_CLASS_CODE"].ToString().Trim());
                        alBaseParams.Add(strACCOUNT_PERIOD);
                        alBaseParams.Add(strACCOUNT_PERIOD);
                        alBase.Add(alBaseParams);
                    }

                    foreach (DataRow dr in dataTable3_2.Rows)
                    {
                        alUpdateInBillParams = new ArrayList();
                        alUpdateInBillParams.Add("3");
                        alUpdateInBillParams.Add("2");
                        alUpdateInBillParams.Add(dr["IN_STOCK_NO"].ToString().Trim());
                        alUpdateInBill.Add(alUpdateInBillParams);
                    }

                    foreach (DataRow dr in dataTable3_3.Rows)
                    {
                        alUpdateOutBillParams = new ArrayList();
                        alUpdateOutBillParams.Add("3");
                        alUpdateOutBillParams.Add("2");
                        alUpdateOutBillParams.Add(dr["IN_STOCK_NO"].ToString().Trim());
                        alUpdateOutBill.Add(alUpdateOutBillParams);
                    }

                    all.Add(alBase);
                    all.Add(alUpdateInBill);
                    all.Add(alUpdateOutBill);
                    PublicServer.SetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.ConfirmCkOutInCarryRecord",
        new Object[] { all, dateBegin.DateTime.ToString("yyMM") }, ob);

                    QueryCkOutInCarryRecord_ConfirmClass();

                    MessageUtil.ShowTips("编制内部结算单成功！");
                }
            }
            catch (Exception e)
            {
                QueryCkOutInCarryRecord_ConfirmClass();
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void CancelConfirmCkOutInCarryRecord()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 2)
                {
                    MessageUtil.ShowTips("只有选择了结算单编制页才能进行取消操作！");
                    return;
                }
                if (dataTable3_1.Rows.Count == 0)
                {
                    return;
                }
                ultraGrid3_1.UpdateData();
                DataRow[] arr = dataTable3_1.Select("CHK = 'True' AND IN_BALANCE_NO IS NOT NULL");
                if (arr == null || arr.Length != 1)
                {
                    MessageUtil.ShowTips("请只选择一条需要取消编制且结算单号不为空的信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认取消编制？") == DialogResult.Yes)
                {

                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();
                    ArrayList alBaseParams = new ArrayList();

                    ArrayList alUpdate = new ArrayList();
                    ArrayList alUpdateParams = new ArrayList();

                    foreach (DataRow dr in arr)
                    {
                        alBaseParams = new ArrayList();
                        alBaseParams.Add(dr["IN_BALANCE_NO"].ToString());
                        alBase.Add(alBaseParams);
                    }

                    all.Add(alBase);
                    //all.Add(alUpdate);

                    PublicServer.SetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.CancelConfirmCkOutInCarryRecord",
        new Object[] { all, arr[0]["IN_BALANCE_NO"].ToString() }, ob);

                    QueryCkOutInCarryRecord_ConfirmClass();

                    MessageUtil.ShowTips("取消结算单成功！");
                }
            }
            catch (Exception e)
            {
                QueryCkOutInCarryRecord_ConfirmClass();
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ExportCkOutInCarryRecord()
        {
            ArrayList alUltraGrid = new ArrayList();//需要导出的GRID
            ArrayList alSheeft = new ArrayList();//Sheeft名称
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                alUltraGrid.Add(ultraGrid1);

                alSheeft.Add("出入库信息");
                if (ultraGrid1.Rows.Count == 0)
                {
                    return;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                alUltraGrid.Add(ultraGrid2);

                alSheeft.Add("结转信息");
                if (ultraGrid2.Rows.Count == 0)
                {
                    return;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                alUltraGrid.Add(ultraGrid3_1);
                alUltraGrid.Add(ultraGrid3_2);
                alUltraGrid.Add(ultraGrid3_3);
                alSheeft.Add("内部结算信息");
                alSheeft.Add("入库记录");
                alSheeft.Add("出库记录");
                if (ultraGrid3_1.Rows.Count == 0)
                {
                    return;
                }
            }
            GridHelper.ulGridToExcel(alUltraGrid, alSheeft, dateBegin.DateTime.ToString("yyyyMM") + "出入库记录");//导出excel

        }

        private void QueryCkOutInCarryRecord()
        {
            try
            {
                dataTable1.Rows.Clear();
                ArrayList arrayList = new ArrayList();

                //arrayList.Add(UserInfo.GetUserID());
                if (chkDate.Checked && dateBegin.Value != null)
                {
                    arrayList.Add(dateBegin.DateTime.AddMonths(-1).ToString("yyyyMM"));
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                if (chkITEM_NAME.Checked)
                {
                    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                if (chkBASENAME.Checked && ultraQueryBASENAME.Value != null)//物料中类
                {
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.QueryCkOutInCarryRecord",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable1.Rows.Clear();
                    dataTable1_2.Rows.Clear();
                    dataTable1_3.Rows.Clear();
                    return;
                }

                if (chkNoNum.Checked)
                {
                    GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1
                }
                else
                {
                    GridHelper.CopyDataToDatatable(PublicPur.GetSelectDt(dt, "INV_PREVIOUS_BALANCE_QTY <> '0' OR INV_IN_QTY <> '0'  OR INV_OUT_QTY <> '0'  OR INV_QTY <> '0'"), dataTable1, true);
                }
                GridHelper.RefreshAndAutoSize(ultraGrid1);
                //月期末库存和实时库存不一致则信息变红
                foreach (UltraGridRow ur in ultraGrid1.Rows)
                {
                    if (ur.Cells["INV_ENDING_BALANCE_QTY"].Text.Trim() != ur.Cells["INV_QTY"].Text.Trim())
                    {
                        ur.Appearance.ForeColor = Color.Red;
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void CarryCkOutInCarryRecord()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了出入库信息页才能进行结转操作！");
                    return;
                }
                if (dataTable1.Rows.Count == 0)
                {
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认结转？") == DialogResult.Yes)
                {
                    ultraGrid1.UpdateData();

                    string userId = UserInfo.GetUserID();
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();

                    string strACCOUNT_PERIOD = dateBegin.DateTime.ToString("yyyyMM");

                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();
                    ArrayList alBaseParams = new ArrayList();

                    ArrayList alUpdate = new ArrayList();
                    ArrayList alUpdateParams = new ArrayList();

                    foreach (DataRow dr in dataTable1.Rows)
                    {
                        if (dr["CHK"].ToString().ToUpper() == "TRUE")
                        {
                            alBaseParams = new ArrayList();
                            alBaseParams.Add(strACCOUNT_PERIOD);
                            alBaseParams.Add(dr["ITEM_UNIQUE"].ToString());
                            alBaseParams.Add(dr["ITEM_CODE"].ToString());
                            alBaseParams.Add(dr["ITEM_DESC"].ToString());
                            alBaseParams.Add(dr["ITEM_NAME"].ToString());
                            alBaseParams.Add(dr["ITEM_DESC_E"].ToString());
                            alBaseParams.Add(dr["ITEM_SPEC"].ToString());//型号规格
                            alBaseParams.Add(dr["ITEM_ATTR_ID"].ToString());
                            alBaseParams.Add(dr["ITEM_ATTR"].ToString());
                            alBaseParams.Add(dr["ITEM_STANDARDS_ID"].ToString());
                            alBaseParams.Add(dr["ITEM_STANDARDS_CODE"].ToString());
                            alBaseParams.Add(dr["ITEM_UOM_ID"].ToString());

                            alBaseParams.Add(dr["ITEM_UOM"].ToString());
                            alBaseParams.Add(dr["WEIGHT_UNIT"].ToString());
                            alBaseParams.Add(dr["BUG_PRICE"].ToString());
                            alBaseParams.Add(dr["INV_PREVIOUS_BALANCE_QTY"].ToString());//期初
                            alBaseParams.Add(dr["INV_PREVIOUS_BALANCE_AMT"].ToString());
                            alBaseParams.Add(dr["INV_IN_QTY"].ToString());//入库金额
                            alBaseParams.Add(dr["INV_IN_AMT"].ToString());
                            alBaseParams.Add(dr["INV_OUT_QTY"].ToString());//出库
                            alBaseParams.Add(dr["INV_OUT_AMT"].ToString());
                            alBaseParams.Add(dr["INV_QTY"].ToString());//改为库存量INV_ENDING_BALANCE_QTY
                            alBaseParams.Add(dr["INV_AMT"].ToString());//INV_ENDING_BALANCE_AMT

                            alBaseParams.Add(dr["INV_QTY"].ToString());//INV_BALANCE_QTY 结算量
                            alBaseParams.Add(dr["INV_AMT_BUG"].ToString());//INV_BALANCE_AMT 结算钱 

                            alBaseParams.Add("");//备注
                            alBaseParams.Add(userId);
                            alBaseParams.Add(user);//创建人
                            alBase.Add(alBaseParams);

                            alUpdateParams = new ArrayList();
                            alUpdateParams.Add("2");
                            alUpdateParams.Add("1");
                            alUpdateParams.Add(strACCOUNT_PERIOD);
                            alUpdateParams.Add(dr["ITEM_CODE"].ToString());
                            alUpdate.Add(alUpdateParams);
                        }
                    }

                    if (alBase.Count == 0)
                    {
                        MessageUtil.ShowTips("请选择至少一条需要结转的信息！");
                        return;
                    }

                    all.Add(alBase);
                    all.Add(alUpdate);
                    PublicServer.SetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.CarryCkOutInCarryRecord",
        new Object[] { all }, ob);

                    QueryCkOutInCarryRecord();

                    MessageUtil.ShowTips("结转成功！");
                }
            }
            catch (Exception e)
            {
                QueryCkOutInCarryRecord();
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void QueryCkOutInCarryRecord_Confirm()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                if (chkITEM_NAME.Checked)
                {
                    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                if (chkBASENAME.Checked && ultraQueryBASENAME.Value != null)
                {
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                if (chkDate.Checked && dateBegin.Value != null)
                {
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                    //arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                    //arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                }
                else
                {
                    arrayList.Add("");
                    //arrayList.Add("");
                    //arrayList.Add("");
                }
                //arrayList.Add(UserInfo.GetUserID());
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.QueryCkOutInCarryRecord_Confirm",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void CancelCarryCkOutInCarryRecord()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了结转信息页才能进行取消操作！");
                    return;
                }
                if (dataTable2.Rows.Count == 0)
                {
                    return;
                }
                ultraGrid2.UpdateData();
                DataRow[] arr = dataTable2.Select("CHK = 'True'");
                if (arr.Length != 1)
                {
                    MessageUtil.ShowTips("请只选择一条需要取消结转的信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认取消？") == DialogResult.Yes)
                {
                    //string user = UserInfo.GetUserName();
                    //string strDate = DateTime.Now.ToString();

                    string strACCOUNT_PERIOD = dateBegin.DateTime.ToString("yyyyMM");

                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();
                    ArrayList alBaseParams = new ArrayList();

                    ArrayList alUpdate = new ArrayList();
                    ArrayList alUpdateParams = new ArrayList();

                    string strId = arr[0]["ID"].ToString();
                    foreach (DataRow dr in arr)
                    {
                        alBaseParams = new ArrayList();
                        alBaseParams.Add(strACCOUNT_PERIOD);
                        alBaseParams.Add(dr["ITEM_CODE"].ToString());
                        alBaseParams.Add(strId);
                        alBase.Add(alBaseParams);

                        alUpdateParams = new ArrayList();
                        alUpdateParams.Add("1");
                        alUpdateParams.Add("2");
                        alUpdateParams.Add(strACCOUNT_PERIOD);
                        alUpdateParams.Add(dr["ITEM_CODE"].ToString());
                        alUpdate.Add(alUpdateParams);
                    }

                    all.Add(alBase);
                    all.Add(alUpdate);

                    PublicServer.SetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.CancelCarryCkOutInCarryRecord",
        new Object[] { all, strId }, ob);

                    QueryCkOutInCarryRecord_Confirm();

                    MessageUtil.ShowTips("取消结转成功！");
                }
            }
            catch (Exception e)
            {
                QueryCkOutInCarryRecord_Confirm();
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void chkDate_CheckedChanged(object sender, EventArgs e)
        {
            dateBegin.Enabled = chkDate.Checked;
        }

        private void chkBASENAME_CheckedChanged(object sender, EventArgs e)
        {
            ultraQueryBASENAME.Enabled = chkBASENAME.Checked;
        }

        private void chkITEM_NAME_CheckedChanged(object sender, EventArgs e)
        {
            ultraQueryITEM_NAME.Enabled = chkITEM_NAME.Checked;
        }

        private void QueryCkOutInCarryRecord_ConfirmClass()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                //if (chkITEM_NAME.Checked)
                //{
                //    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                //    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                //    arrayList.Add(ultraQueryITEM_NAME.Text.Trim());
                //}
                //else
                //{
                //    arrayList.Add("");
                //    arrayList.Add("");
                //    arrayList.Add("");
                //}

                if (chkBASENAME.Checked && ultraQueryBASENAME.Value != null)
                {
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                    arrayList.Add(ultraQueryBASENAME.Value.ToString());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                if (chkDate.Checked && dateBegin.Value != null)
                {
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                }
                else
                {
                    arrayList.Add("");
                }
                //arrayList.Add(UserInfo.GetUserID());
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.QueryCkOutInCarryRecord_ConfirmClass",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable3_1.Rows.Clear();
                    dataTable3_2.Rows.Clear();
                    dataTable3_3.Rows.Clear();
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable3_1, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid3_1);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ultraGrid3_1_AfterRowActivate(object sender, EventArgs e)
        {
            QueryCkInBillDetail();
            QueryCkOutBillDetail();
        }

        private void QueryCkInBillDetail()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add("2345");
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["ITEM_CLASS_CODE"].Text.Trim());
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["ITEM_CLASS_CODE"].Text.Trim());
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["ITEM_CLASS_CODE"].Text.Trim());
                arrayList.Add("");//物料名称
                arrayList.Add("");
                arrayList.Add("");
                if (chkDate.Checked && dateBegin.Value != null)
                {
                    //arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                }
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["IN_BALANCE_NO"].Text.Trim());
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["IN_BALANCE_NO"].Text.Trim());
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["IN_BALANCE_NO"].Text.Trim());
                //arrayList.Add(UserInfo.GetUserID());
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.QueryCkInBillDetail",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable3_2.Rows.Clear();
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable3_2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid3_2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void QueryCkOutBillDetail()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add("2345");
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["ITEM_CLASS_CODE"].Text.Trim());
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["ITEM_CLASS_CODE"].Text.Trim());
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["ITEM_CLASS_CODE"].Text.Trim());
                arrayList.Add("");//物料名称
                arrayList.Add("");
                arrayList.Add("");
                if (chkDate.Checked && dateBegin.Value != null)
                {
                    //arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                }
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["IN_BALANCE_NO"].Text.Trim());
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["IN_BALANCE_NO"].Text.Trim());
                arrayList.Add(ultraGrid3_1.ActiveRow.Cells["IN_BALANCE_NO"].Text.Trim());
                //arrayList.Add(UserInfo.GetUserID());
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.QueryCkOutBillDetail",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable3_3.Rows.Clear();
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable3_3, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid3_3);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void FrmCkOutInCarryRecord_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Carry"))
                {
                    this.toolMenu.Toolbars[0].Tools["Carry"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Change"))
                {
                    this.toolMenu.Toolbars[0].Tools["Change"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelConfirm"))
                {
                    toolMenu.Toolbars[0].Tools["CancelConfirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Carry"))
                {
                    this.toolMenu.Toolbars[0].Tools["Carry"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Change"))
                {
                    this.toolMenu.Toolbars[0].Tools["Change"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelConfirm"))
                {
                    toolMenu.Toolbars[0].Tools["CancelConfirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Carry"))
                {
                    this.toolMenu.Toolbars[0].Tools["Carry"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Change"))
                {
                    this.toolMenu.Toolbars[0].Tools["Change"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelConfirm"))
                {
                    toolMenu.Toolbars[0].Tools["CancelConfirm"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Carry"))
                {
                    this.toolMenu.Toolbars[0].Tools["Carry"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Change"))
                {
                    this.toolMenu.Toolbars[0].Tools["Change"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelConfirm"))
                {
                    toolMenu.Toolbars[0].Tools["CancelConfirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                chkITEM_NAME.Enabled = true;
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Carry"))
                {
                    this.toolMenu.Toolbars[0].Tools["Carry"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Change"))
                {
                    this.toolMenu.Toolbars[0].Tools["Change"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelConfirm"))
                {
                    toolMenu.Toolbars[0].Tools["CancelConfirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                chkITEM_NAME.Enabled = true;
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Carry"))
                {
                    this.toolMenu.Toolbars[0].Tools["Carry"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Change"))
                {
                    this.toolMenu.Toolbars[0].Tools["Change"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelConfirm"))
                {
                    toolMenu.Toolbars[0].Tools["CancelConfirm"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                chkITEM_NAME.Checked = false;
                chkITEM_NAME.Enabled = false;
                ultraQueryITEM_NAME.Enabled = false;
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            QueryCkInBillDetail_();
            QueryCkOutBillDetail_();
        }

        private void QueryCkInBillDetail_()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add("1");
                arrayList.Add("");//物料大类
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add(ultraGrid1.ActiveRow.Cells["ITEM_CODE"].Text.Trim());
                arrayList.Add(ultraGrid1.ActiveRow.Cells["ITEM_CODE"].Text.Trim());
                arrayList.Add(ultraGrid1.ActiveRow.Cells["ITEM_CODE"].Text.Trim());//物料编码
                if (chkDate.Checked && dateBegin.Value != null)
                {
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                    //arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                }
                arrayList.Add("");//结算单号
                arrayList.Add("");
                arrayList.Add("");
                //arrayList.Add(UserInfo.GetUserID());
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.QueryCkInBillDetail",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable1_2.Rows.Clear();
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable1_2, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid1_2);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void QueryCkOutBillDetail_()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add("1");
                arrayList.Add("");//物料大类
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add(ultraGrid1.ActiveRow.Cells["ITEM_CODE"].Text.Trim());
                arrayList.Add(ultraGrid1.ActiveRow.Cells["ITEM_CODE"].Text.Trim());
                arrayList.Add(ultraGrid1.ActiveRow.Cells["ITEM_CODE"].Text.Trim());//物料编码
                if (chkDate.Checked && dateBegin.Value != null)
                {
                    //arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                }
                arrayList.Add("");//结算单号
                arrayList.Add("");
                arrayList.Add("");
                //arrayList.Add(UserInfo.GetUserID());
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.ck.service.impl.FrmCkOutInCarryRecord.QueryCkOutBillDetail",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable1_3.Rows.Clear();
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable1_3, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid1_3);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void btnRefresh_Click(object sender, EventArgs e)
        {
            ChangeCkOutInCarryRecord();
        }
    }
}