MES_Client/TGMES/Core.StlMes.Client.Pms/balance/FrmBalanceBillManage_FG.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
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.balance
{
    public partial class FrmBalanceBillManage_FG : FrmPmsBase
    {
        public FrmBalanceBillManage_FG()
        {
            InitializeComponent();
        }

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

        private void FrmBalanceBillManage_FG_Load(object sender, EventArgs e)
        {
            dateBegin.Value = dateEnd.DateTime.AddDays(-7);
            InitColumns();

            SetSumCount();

            InitBindBox();
        }

        private void InitColumns()
        {
            string[] arrColumns = new string[] { "ATTR_CODE", "ATTR_NAME", "PRICE_VAL", "REAL_PRICE_VAL" };//"GRADE_VALUE", "GRADE_LEVEL"
            string[] arrColumnsCaption = new string[] { "料型", "料型", "政策价格", "实际价格" };
            PublicPur.InitColumns(arrColumns, arrColumnsCaption, dataTable1, ultraGrid1, new string[] { "ATTR_CODE" }, false, null);

            PublicPur.InitCellPositionRight(ultraGrid1, new string[] { "PRICE_VAL", "REAL_PRICE_VAL" });
            PublicPur.InitColumnShowLength(ultraGrid1, 0, new string[] { "PRICE_VAL", "REAL_PRICE_VAL" }, 2, false);

            string[] arrColumnsDetail = new string[] { "CHK", "IN_STOCK_NO", "BALANCE_NO", "BALANCE_NO_SEQ", "SUPP_CODE", "SUPP_NAME", "CAR_NUM", "ITEM_CODE", "ITEM_NAME", "ATTR_CODE", "ATTR_NAME", "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY", "SUTTLETIME", "BUY_PRICE", "BUY_PRICE_TAX", "BUY_AMT", "BUY_AMT_TAX", "REMARK" };
            string[] arrColumnsCaptionDetail = new string[] { "选择", "入库单号", "结算单号", "结算单行号", "供应商", "供应商", "车号", "物料编码", "物料名称", "料型(规格)", "料型(规格)", "毛重", "皮重", "净重", "扣杂", "扣杂净重", "扣机铁", "扣超长", "扣轻薄", "料型净重", "净重时间", "不含税单价", "含税单价", "不含税总价", "含税总价", "备注" };
            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable2, ultraGrid2, new string[] { "BALANCE_NO", "BALANCE_NO_SEQ", "SUPP_CODE", "SUPP_NAME", "ITEM_CODE", "ATTR_NAME", "BUY_PRICE", "BUY_PRICE_TAX", "BUY_AMT", "BUY_AMT_TAX" }, false, new string[] { "CHK", "ATTR_CODE" });
            ultraGrid2.DisplayLayout.Bands[0].Columns["ATTR_CODE"].EditorComponent = ultraATTR_NAME;

            PublicPur.InitCellPositionRight(ultraGrid2, new string[] { "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY" });
            PublicPur.InitColumnShowLength(ultraGrid2, 0, new string[] { "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY" }, 4, false);

            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable3, ultraGrid3, new string[] { "IN_STOCK_NO", "BALANCE_NO_SEQ", "SUPP_CODE", "CAR_NUM", "ITEM_CODE", "ITEM_NAME", "ATTR_CODE", "ATTR_NAME", "SUTTLETIME", "BUY_PRICE", "BUY_PRICE_TAX" }, false, new string[] { "CHK" });
            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable4, ultraGrid4, new string[] { "CHK", "BALANCE_NO", "SUPP_CODE", "SUPP_NAME", "ITEM_CODE", "ATTR_CODE", "SUTTLETIME", "BUY_AMT", "BUY_AMT_TAX" }, false, null);

            PublicPur.InitCellPositionRight(ultraGrid3, new string[] { "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY", "BUY_AMT", "BUY_AMT_TAX" });
            PublicPur.InitColumnShowLength(ultraGrid3, 0, new string[] { "BUY_AMT", "BUY_AMT_TAX" }, 2, false);
            PublicPur.InitColumnShowLength(ultraGrid3, 0, new string[] { "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY" }, 4, false);

            PublicPur.InitCellPositionRight(ultraGrid4, new string[] { "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY", "BUY_PRICE", "BUY_PRICE_TAX" });
            PublicPur.InitColumnShowLength(ultraGrid4, 0, new string[] { "BUY_PRICE", "BUY_PRICE_TAX" }, 2, false);
            PublicPur.InitColumnShowLength(ultraGrid4, 0, new string[] { "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY" }, 4, false);
        }

        //设置统计风格
        private void SetSumCount()
        {
            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}" }, new string[] { "IN_STOCK_NO", "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY", "BUY_AMT", "BUY_AMT_TAX" }, this.ultraGrid2.DisplayLayout.Bands[0], SummaryDisplayAreas.BottomFixed);
            PublicPur.SetupSummaryHeade(new String[] { "Count", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum", "Sum" }, new String[] { "共{0}条", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}", "{0}" }, new string[] { "IN_STOCK_NO", "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY", "BUY_AMT", "BUY_AMT_TAX" }, this.ultraGrid4.DisplayLayout.Bands[0], SummaryDisplayAreas.TopFixed);
        }

        private void InitBindBox()
        {
            QuerySUPP_NAME();
            QueryBASE_PRICE_NAME();
            QueryATTR_NAME();
        }

        //菜单按钮事件
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        txtADD_PRICE.Text = "0";
                        if (ultraQuerySUPP_NAME.Value == null || ultraQuerySUPP_NAME.Text == "")
                        {
                            MessageUtil.ShowTips("请选择供应商！");
                            return; ;
                        }
                        QueryCkInBillRecord_FG();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryBalanceInBillRecord();
                    }
                    break;
                case "Confirm"://确认编制结算单
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        ConfirmBalanceInBill();
                    }
                    break;
                case "Cancel"://取消编制结算单
                    CancelBalanceInBill();
                    break;
                case "Print"://打印
                    break;
                case "Export"://导出
                    ExportBalanceInBill();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

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

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

                alSheeft.Add("废钢入库信息");
                if (ultraGrid4.Rows.Count == 0)
                {
                    return;
                }
            }
            GridHelper.ulGridToExcel(alUltraGrid, alSheeft, dateBegin.DateTime.ToString("yyyyMM") + "废钢入库信息");//导出excel

        }

        private void QueryCkInBillRecord_FG()
        {
            try
            {
                dataTable2.Rows.Clear();
                ArrayList arrayList = new ArrayList();
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }

                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

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

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

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

                PublicPur.RefreshAndAutoSizeColumns(ultraGrid2, new string[] { "ATTR_CODE" }, false);//刷新Grid

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

        //查询供应商
        private void QuerySUPP_NAME()
        {
            try
            {

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPP_NAME",
    new Object[] { }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                DataRow dr = dt.NewRow();
                dr[0] = "";
                dt.Rows.InsertAt(dr, 0);
                ultraQuerySUPP_NAME.DataSource = dt;
                ultraQuerySUPP_NAME.DisplayMember = "SUPP_NAME";
                ultraQuerySUPP_NAME.ValueMember = "SUPP_CODE";
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询价格政策
        private void QueryBASE_PRICE_NAME()
        {
            try
            {

                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryBASE_PRICE_NAME",
    new Object[] { }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                DataRow dr = dt.NewRow();
                dr[0] = "";
                dt.Rows.InsertAt(dr, 0);
                ultraBASE_PRICE_NAME.DataSource = dt;
                ultraBASE_PRICE_NAME.DisplayMember = "NAME";
                ultraBASE_PRICE_NAME.ValueMember = "ID";
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询物料对应的料型
        private void QueryATTR_NAME()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add("Y01010001");
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryATTR_NAME",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                DataRow dr = dt.NewRow();
                dr[0] = "";
                dt.Rows.InsertAt(dr, 0);
                ultraATTR_NAME.DataSource = dt;
                ultraATTR_NAME.DisplayMember = "ATTR_NAME";
                ultraATTR_NAME.ValueMember = "ATTR_CODE";
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ultraBASE_PRICE_NAME_TextChanged(object sender, EventArgs e)
        {
            if (ultraQuerySUPP_NAME.Value == null || ultraBASE_PRICE_NAME.Value == null)
            {
                return; ;
            }
            QueryBASE_PRICE_NAMEDetail();
        }

        //查询价格政策明细
        private void QueryBASE_PRICE_NAMEDetail()
        {
            try
            {
                if (ultraQuerySUPP_NAME.Value == null || ultraBASE_PRICE_NAME.Value == null)
                {
                    return; ;
                }
                dataTable1.Rows.Clear();
                ArrayList arrayList = new ArrayList();
                if (ultraQuerySUPP_NAME.Value.ToString() == "C05ZJNBDFJ" || ultraQuerySUPP_NAME.Value.ToString() == "C01SDLHWZ0")
                {
                    arrayList.Add("1");
                    arrayList.Add("1");
                }
                else
                {
                    arrayList.Add("0");
                    arrayList.Add("0");
                }
                arrayList.Add(ultraBASE_PRICE_NAME.Value.ToString().Trim());
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryBASE_PRICE_NAMEDetail",
    new Object[] { arrayList }, ob);

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

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

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

        private void txtADD_PRICE_TextChanged(object sender, EventArgs e)
        {

        }

        private void btnRefresh_Click(object sender, EventArgs e)
        {
            if (!StringUtil.Is_Below_zero(txtADD_PRICE.Text.Trim()))
            {
                txtADD_PRICE.Text = "0";
            }

            double addNum = Convert.ToDouble(txtADD_PRICE.Text.Trim());
            foreach (DataRow dr in dataTable1.Rows)
            {
                dr["REAL_PRICE_VAL"] = Convert.ToDouble(dr["PRICE_VAL"].ToString()) + addNum;
            }
        }

        private void ConfirmBalanceInBill()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了入库记录页才能进行编制结算单操作！");
                    return;
                }

                if (dataTable1.Rows.Count == 0)
                {
                    MessageUtil.ShowTips("请选择价格体系！");
                    return;
                }

                if (dataTable2.Rows.Count == 0)
                {
                    MessageUtil.ShowTips("没有入库记录不能编制结算单！");
                    return;
                }

                ultraGrid2.UpdateData();
                DataRow[] arr = dataTable2.Select("CHK = 'True'");
                if (arr.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条入库记录进行编制结算单操作！");
                    return;
                }
                foreach (DataRow dr in arr)
                {
                    if (dr["ATTR_NAME"].ToString() == "")
                    {
                        MessageUtil.ShowTips("入库单号" + dr["IN_STOCK_NO"].ToString() + "废钢料型不能为空！");
                        return;
                    }
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认对此记录编制结算单？") == DialogResult.Yes)
                {
                    string userId = UserInfo.GetUserID();
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();

                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();//盘盈盘亏记录表
                    ArrayList alBaseParams = new ArrayList();

                    ArrayList alCk = new ArrayList();//库存记录表
                    ArrayList alCkParams = new ArrayList();

                    ArrayList alCkUpdate = new ArrayList();//库存记录表
                    ArrayList alCkUpdateParams = new ArrayList();

                    //主表
                    alBaseParams.Add("");//发票编号
                    alBaseParams.Add(ultraQuerySUPP_NAME.Value.ToString());//供应商
                    alBaseParams.Add(ultraQuerySUPP_NAME.Text.Trim());//供应商
                    alBaseParams.Add("1");//是否废钢
                    alBaseParams.Add(ultraBASE_PRICE_NAME.Value.ToString());//价格政策编码
                    alBaseParams.Add(ultraBASE_PRICE_NAME.Text.Trim());
                    alBaseParams.Add(txtADD_PRICE.Text.Trim());//加价金额
                    alBaseParams.Add(txtLEN_DEDUCT_PRICE.Text.Trim());
                    alBaseParams.Add("1");//有效标志位
                    alBaseParams.Add("");//备注
                    alBaseParams.Add(userId);//创建人
                    alBaseParams.Add(user);//创建人
                    alBase.Add(alBaseParams);

                    //从表
                    DataRow[] arrPrice;
                    foreach (DataRow dr in arr)
                    {
                        alCkParams = new ArrayList();
                        alCkParams.Add(dr["IN_STOCK_NO"].ToString());//入库单号
                        alCkParams.Add(dr["ITEM_CODE"].ToString());
                        alCkParams.Add(dr["ITEM_NAME"].ToString());
                        alCkParams.Add(dr["CAR_NUM"].ToString());//送货单行号
                        alCkParams.Add(dr["ATTR_CODE"].ToString());//入库日期
                        alCkParams.Add(dr["ATTR_NAME"].ToString());//合同号
                        alCkParams.Add(dr["GROSS_QTY"].ToString());
                        alCkParams.Add(dr["TARE_QTY"].ToString());//供应商
                        alCkParams.Add(dr["NET_QTY"].ToString());
                        alCkParams.Add(dr["KZ_QTY"].ToString());
                        alCkParams.Add(dr["KZ_NET_QTY"].ToString());//库位
                        alCkParams.Add(dr["KJT_QTY"].ToString());

                        alCkParams.Add(dr["KCC_QTY"].ToString());//采购单位
                        alCkParams.Add(dr["KQB_QTY"].ToString());
                        alCkParams.Add(dr["INV_QTY"].ToString());
                        alCkParams.Add(dr["SUTTLETIME"].ToString());

                        arrPrice = dataTable1.Select("ATTR_CODE = '" + dr["ATTR_CODE"].ToString() + "'");
                        if (arrPrice != null && arrPrice.Length > 0)
                        {
                            double price = Convert.ToDouble(arrPrice[0]["REAL_PRICE_VAL"].ToString() == "" ? "0" : arrPrice[0]["REAL_PRICE_VAL"].ToString());
                            alCkParams.Add(Math.Round(price / 1.13, 4));//不含税单价
                            alCkParams.Add(price);//含税单价 BUY_PRICE_TAX
                        }
                        else
                        {
                            alCkParams.Add("");//不含税单价
                            alCkParams.Add("");//含税单价 BUY_PRICE_TAX
                        }
                        alCkParams.Add("1");
                        alCkParams.Add("");//备注
                        alCkParams.Add(userId);//创建人
                        alCkParams.Add(user);//创建人
                        alCk.Add(alCkParams);

                        alCkUpdateParams = new ArrayList();
                        alCkUpdateParams.Add(dr["IN_STOCK_NO"].ToString());
                        alCkUpdate.Add(alCkUpdateParams);
                    }

                    all.Add(alBase);
                    all.Add(alCk);
                    all.Add(alCkUpdate);

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.ConfirmBalanceInBill_FG",
        new Object[] { all }, ob);

                    QueryCkInBillRecord_FG();

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

        private void QueryBalanceInBillRecord()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                if (chkDate.Checked)
                {
                    arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkSUPP_NAME.Checked)
                {
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                    arrayList.Add(ultraQuerySUPP_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkBALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryBALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

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

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

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

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

        private void CancelBalanceInBill()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了结算单信息页才能进行取消操作！");
                    return;
                }

                if (ultraGrid3.ActiveRow == null || dataTable3.Rows.Count == 0)
                {
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认对此记录取消编制？") == DialogResult.Yes)
                {
                    string userId = UserInfo.GetUserID();
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();

                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();//盘盈盘亏记录表
                    ArrayList alBaseParams = new ArrayList();

                    ArrayList alCk = new ArrayList();//库存记录表
                    ArrayList alCkParams = new ArrayList();

                    ArrayList alCkUpdate = new ArrayList();//库存记录表
                    ArrayList alCkUpdateParams = new ArrayList();

                    string strBALANCE_NO = ultraGrid3.ActiveRow.Cells["BALANCE_NO"].Text.Trim();
                    //主表                   
                    alBaseParams.Add("撤销结算单");//备注
                    alBaseParams.Add(userId);//取消人
                    alBaseParams.Add(user);//取消人
                    alBaseParams.Add(strBALANCE_NO);
                    alBase.Add(alBaseParams);

                    //从表
                    alCkParams.Add("撤销结算单");//备注
                    alCkParams.Add(userId);//取消人
                    alCkParams.Add(user);//取消人
                    alCkParams.Add(strBALANCE_NO);
                    alCk.Add(alCkParams);

                    foreach (DataRow dr in dataTable4.Rows)
                    {
                        alCkUpdateParams = new ArrayList();
                        alCkUpdateParams.Add("");
                        alCkUpdateParams.Add(dr["IN_STOCK_NO"].ToString());
                        alCkUpdate.Add(alCkUpdateParams);
                    }

                    all.Add(alBase);
                    all.Add(alCk);
                    all.Add(alCkUpdate);

                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.CancelBalanceInBill",
        new Object[] { all, strBALANCE_NO }, ob);

                    QueryBalanceInBillRecord();

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

        private void ultraGrid3_AfterRowActivate(object sender, EventArgs e)
        {
            QueryCkInBillRecordDetail();
        }

        private void QueryCkInBillRecordDetail()
        {
            try
            {
                dataTable4.Rows.Clear();

                ArrayList arrayList = new ArrayList();
                arrayList.Add(ultraGrid3.ActiveRow.Cells["BALANCE_NO"].Text.Trim());
                arrayList.Add(ultraGrid3.ActiveRow.Cells["BALANCE_NO"].Text.Trim());
                arrayList.Add(ultraGrid3.ActiveRow.Cells["BALANCE_NO"].Text.Trim());

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

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

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

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

        private void chkBALANCE_NO_CheckedChanged(object sender, EventArgs e)
        {
            txtQueryBALANCE_NO.Enabled = chkBALANCE_NO.Checked;
        }

        private void ultraGrid2_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "ATTR_CODE")
            {
                e.Cell.Row.Cells["ATTR_NAME"].Value = e.Cell.Text.Trim();
            }
        }
    }
}