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

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win.UltraWinGrid;
using Pur.Balance;
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 FrmBalanceOutInBill : FrmPmsBase
    {
        public FrmBalanceOutInBill()
        {
            InitializeComponent();
        }

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

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

            ChangeStyle();

            SetSumCount();

            InitBindBox();
        }

        private void InitColumns()
        {
            PublicPur.setOtherColumnReadOnly(ultraGrid1_1, new string[] { "CHK" });
            PublicPur.setOtherColumnReadOnly(ultraGrid2_1, new string[] { "CHK" });

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

            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable2_2, ultraGrid2_2, new string[] { "CHK", "IN_BALANCE_NO", "ORDER_ID", "SUPP_CODE", "ITEM_CLASS_CODE" }, false, null);
            PublicPur.InitColumns(arrColumnsDetail, arrColumnsCaptionDetail, dataTable2_3, ultraGrid2_3, new string[] { "CHK", "IN_BALANCE_NO", "ORDER_ID", "SUPP_CODE", "ITEM_CLASS_CODE" }, false, null);
            dataTable2_3.Columns["IN_STOCK_NO"].Caption = "出库单号";
            dataTable2_3.Columns["INV_QTY"].Caption = "出库数量";
        }

        //调整格式
        private void ChangeStyle()
        {
            PublicPur.InitCellPositionRight(new UltraGrid[] { ultraGrid1_1, ultraGrid2_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_1, ultraGrid2_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_1, ultraGrid2_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, ultraGrid2_2, ultraGrid2_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, ultraGrid2_2, ultraGrid2_3 }, 0, new string[] { "BUY_QTY", "INV_QTY", }, 4, false);
            PublicPur.InitColumnShowLength(new UltraGrid[] { ultraGrid1_2, ultraGrid1_3, ultraGrid2_2, ultraGrid2_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" }, 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.ultraGrid2_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.ultraGrid2_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_ConfirmClass(dataTable1_1, ultraGrid1_1, "3");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCkOutInCarryRecord_ConfirmClass(dataTable2_1, ultraGrid2_1, "4");
                    }
                    break;
                case "Confirm"://确认结转
                    ConfirmBalanceInBill();
                    break;
                case "Cancel"://取消操作
                    CancelBalanceInBill();
                    break;
                case "Export"://导出
                    ExportCkOutInCarryRecord();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void ExportCkOutInCarryRecord()
        {
            ArrayList alUltraGrid = new ArrayList();//需要导出的GRID
            ArrayList alSheeft = new ArrayList();//Sheeft名称
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                alUltraGrid.Add(ultraGrid1_1);
                alUltraGrid.Add(ultraGrid1_2);
                alUltraGrid.Add(ultraGrid1_3);
                alSheeft.Add("内部结算信息");
                alSheeft.Add("入库记录");
                alSheeft.Add("出库记录");
                if (ultraGrid1_1.Rows.Count == 0)
                {
                    return;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                alUltraGrid.Add(ultraGrid2_1);
                alUltraGrid.Add(ultraGrid2_2);
                alUltraGrid.Add(ultraGrid2_3);
                alSheeft.Add("内部结算信息");
                alSheeft.Add("入库记录");
                alSheeft.Add("出库记录");
                if (ultraGrid2_1.Rows.Count == 0)
                {
                    return;
                }
            }
            GridHelper.ulGridToExcel(alUltraGrid, alSheeft, dateBegin.DateTime.ToString("yyyyMM") + "出入库记录");//导出excel

        }

        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 chkIN_BALANCE_NO_CheckedChanged(object sender, EventArgs e)
        {
            txtQueryIN_BALANCE_NO.Enabled = chkIN_BALANCE_NO.Checked;
        }

        private void QueryCkOutInCarryRecord_ConfirmClass(DataTable dts, UltraGrid ug, string flag)
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add(flag);
                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 && dateEnd.Value != null)
                {
                    arrayList.Add(dateBegin.DateTime.ToString("yyyyMM"));
                    arrayList.Add(dateEnd.DateTime.ToString("yyyyMM"));
                }
                else
                {
                    arrayList.Add(DateTime.Now.ToString("yyyyMM"));
                    arrayList.Add(DateTime.Now.ToString("yyyyMM"));
                }
                if (chkIN_BALANCE_NO.Checked)
                {
                    arrayList.Add(txtQueryIN_BALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryIN_BALANCE_NO.Text.Trim());
                    arrayList.Add(txtQueryIN_BALANCE_NO.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

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

                if (dt == null || dt.Rows.Count == 0)
                {
                    if (dts == dataTable1_1)
                    {
                        dataTable1_1.Rows.Clear();
                        dataTable1_2.Rows.Clear();
                        dataTable1_3.Rows.Clear();
                    }
                    else
                    {
                        dataTable2_1.Rows.Clear();
                        dataTable2_2.Rows.Clear();
                        dataTable2_3.Rows.Clear();
                    }
                    return;
                }

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

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

        private void ultraGrid1_1_AfterRowActivate(object sender, EventArgs e)
        {
            string strIN_BALANCE_NO = ultraGrid1_1.ActiveRow.Cells["IN_BALANCE_NO"].Text.Trim();
            QueryCkInBillDetail(dataTable1_2, ultraGrid1_2, strIN_BALANCE_NO);
            QueryCkOutBillDetail(dataTable1_3, ultraGrid1_3, strIN_BALANCE_NO);
        }

        private void QueryCkInBillDetail(DataTable dts, UltraGrid ug, string strIN_BALANCE_NO)
        {
            try
            {
                ArrayList arrayList = new ArrayList();

                arrayList.Add(strIN_BALANCE_NO);
                arrayList.Add(strIN_BALANCE_NO);
                arrayList.Add(strIN_BALANCE_NO);

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

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

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

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

        private void QueryCkOutBillDetail(DataTable dts, UltraGrid ug, string strIN_BALANCE_NO)
        {
            try
            {
                ArrayList arrayList = new ArrayList();

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

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

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

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

        private void ConfirmBalanceInBill()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了未审批数据页才能进行审批操作！");
                    return;
                }
                if (dataTable1_1.Rows.Count == 0)
                {
                    return;
                }
                ultraGrid1_1.UpdateData();
                DataRow[] arrBase = dataTable1_1.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要审批的信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认审批？") == DialogResult.Yes)
                {
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();

                    ArrayList all = new ArrayList();

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

                    ArrayList alUpdateOutInBill = new ArrayList();
                    ArrayList alUpdateOutInBillParams = new ArrayList();

                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("4");
                        alBaseParams.Add(user);//审批人
                        alBaseParams.Add(strDate);//审批时间
                        alBaseParams.Add("3");
                        alBaseParams.Add(row["IN_BALANCE_NO"].ToString());
                        alBase.Add(alBaseParams);

                        alUpdateOutInBillParams = new ArrayList();
                        alUpdateOutInBillParams.Add("4");
                        alUpdateOutInBillParams.Add("3");
                        alUpdateOutInBillParams.Add(row["IN_BALANCE_NO"].ToString());
                        alUpdateOutInBill.Add(alUpdateOutInBillParams);
                    }
                    all.Add(alBase);
                    all.Add(alUpdateOutInBill);
                    PublicServer.SetData("com.hnshituo.pur.balance.service.impl.FrmBalanceOutInBill.ConfirmBalanceInBill",
        new Object[] { all }, ob);

                    QueryCkOutInCarryRecord_ConfirmClass(dataTable1_1, ultraGrid1_1, "3");

                    MessageUtil.ShowTips("审批成功！");
                }

            }
            catch (Exception e)
            {
                QueryCkOutInCarryRecord_ConfirmClass(dataTable1_1, ultraGrid1_1, "3");
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void CancelBalanceInBill()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已审批数据页才能进行取消审批操作！");
                    return;
                }
                if (dataTable2_1.Rows.Count == 0)
                {
                    return;
                }
                ultraGrid2_1.UpdateData();
                DataRow[] arrBase = dataTable2_1.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要取消审批的信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认取消审批？") == DialogResult.Yes)
                {

                    ArrayList all = new ArrayList();

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

                    ArrayList alUpdateOutInBill = new ArrayList();
                    ArrayList alUpdateOutInBillParams = new ArrayList();

                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("3");
                        alBaseParams.Add("");//审批人
                        alBaseParams.Add("");//审批时间
                        alBaseParams.Add("4");
                        alBaseParams.Add(row["IN_BALANCE_NO"].ToString());
                        alBase.Add(alBaseParams);

                        alUpdateOutInBillParams = new ArrayList();
                        alUpdateOutInBillParams.Add("3");
                        alUpdateOutInBillParams.Add("4");
                        alUpdateOutInBillParams.Add(row["IN_BALANCE_NO"].ToString());
                        alUpdateOutInBill.Add(alUpdateOutInBillParams);
                    }

                    all.Add(alBase);
                    all.Add(alUpdateOutInBill);

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

                    QueryCkOutInCarryRecord_ConfirmClass(dataTable2_1, ultraGrid2_1, "4");

                    MessageUtil.ShowTips("取消审批成功！");
                }
            }
            catch (Exception e)
            {
                QueryCkOutInCarryRecord_ConfirmClass(dataTable2_1, ultraGrid2_1, "4");
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ultraGrid2_1_AfterRowActivate(object sender, EventArgs e)
        {
            string strIN_BALANCE_NO = ultraGrid2_1.ActiveRow.Cells["IN_BALANCE_NO"].Text.Trim();
            QueryCkInBillDetail(dataTable2_2, ultraGrid2_2, strIN_BALANCE_NO);
            QueryCkOutBillDetail(dataTable2_3, ultraGrid2_3, strIN_BALANCE_NO);
        }
    }
}