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

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
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_Price : FrmPmsBase
    {
        //加入备注填写功能
        public FrmBalanceBillManage_Price()
        {
            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_Price_Load(object sender, EventArgs e)
        {
            dateBegin.Value = dateEnd.DateTime.AddDays(-7);
            InitColumns();

            SetSumCount();

            InitBindBox();
            getsuppname();         
           
        }

        private void getsuppname()
        {
            //供应商
            ArrayList list = new ArrayList();
            DataTable dt = ServerHelper.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPP_NAME1", new object[] { list }, this.ob);//如果是“”里面添加的是条件
            ultraQuerySUPP_NAME.DataSource = dt;
            ultraQuerySUPP_NAME.DisplayMember = "SUPP_NAME";
            ultraQuerySUPP_NAME.ValueMember = "SUPP_CODE";
            YdmBaseClass.SetComboItemHeight(ultraQuerySUPP_NAME);
        }
        private void getsuppcode()
        {
            DataTable dt = ServerHelper.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPP_NAME2", new object[] { ultraQuerySUPP_NAME.Text.ToString() }, this.ob);
            if (ultraQuerySUPP_NAME.Value != null || !ultraQuerySUPP_NAME.Text.Equals(""))
            {
                txtQueryITEM_CODE.DataSource = dt;
                txtQueryITEM_CODE.DisplayMember = "ITEM_CODE";
                txtQueryITEM_CODE.ValueMember = "ITEM_CODE";
                YdmBaseClass.SetComboItemHeight(txtQueryITEM_CODE);
                if (txtQueryITEM_CODE.Value==null)
                {
                    txtQueryITEM_CODE.Value = dt.Rows[0]["ITEM_CODE"].ToString();
                }
                
                //ultraQuerySUPP_NAME.Value = dt.Rows[0]["SUPP_NAME"].ToString();
            }
        }
        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", "SUTTLETIME", "CAR_NUM", "ATTR_CODE", "ATTR_NAME", "GROSS_QTY", "TARE_QTY", "KZ_QTY", "NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY", "REMARK", "IN_STOCK_NO", "BALANCE_NO", "BALANCE_NO_SEQ", "SUPP_CODE", "SUPP_NAME", "ITEM_CODE", "ITEM_NAME", "KZ_NET_QTY", "BUY_PRICE", "BUY_PRICE_TAX", "BUY_AMT", "BUY_AMT_TAX", "TAX_RATE_NAME", "HONOUR_PRICE", "VOLUME_PRICE", "CHECK_PRICE" };
            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", "TAX_RATE_NAME" }, 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", "TAX_RATE_NAME" }, 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" }, 4, 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" }, 4, 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 (txtQueryITEM_CODE.Value == null || txtQueryITEM_CODE.Value=="")
                    {
                        getsuppcode();
                    }
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        txtADD_PRICE.Text = "0";
                        if (txtQueryITEM_CODE.Value == "")
                        {
                            MessageUtil.ShowTips("请输入物料编码！");
                            return; ;
                        }
                        if (ultraQuerySUPP_NAME.Value == null || ultraQuerySUPP_NAME.Text == "")
                        {
                            MessageUtil.ShowTips("请选择供应商！");
                            return; ;
                        }
                        if (ultraBASE_PRICE_NAME.Value == null || ultraBASE_PRICE_NAME.Text.Trim() == "")
                        {
                            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"://打印
                    PrintBalanceBillManage();
                    break;
                case "Export"://导出
                    ExportBalanceInBill();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void PrintBalanceBillManage()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    return;
                }

                this.Cursor = Cursors.WaitCursor;
                UltraGridRow ugr = ultraGrid3.ActiveRow;
                if (ugr == null)
                {
                    MessageUtil.ShowWarning("请选择您要打印的结算单！");
                    return;
                }

                string strBALANCE_NO = ugr.Cells["BALANCE_NO"].Value.ToString();

                string strurl = "";
                //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
                //{
                //    strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPmsBalanceBillManage.cpt&bypagesize=false&BALANCE_NO=" + strCHECK_NO;
                //}
                //else
                //{
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPmsBalanceBillManage.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();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        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 (chkSUTTLETIME.Checked)
                {
                    arrayList.Add("1");
                    arrayList.Add("1");
                    arrayList.Add(dateBegin_S.DateTime.ToShortDateString() + " 00:00:00");
                    arrayList.Add(dateEnd_S.DateTime.ToShortDateString() + " 23:59:59");
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("0001/01/01 00:00:00");
                    arrayList.Add("9999/12/31 23:59:59");
                }
                if (chkITEM_CODE.Checked)
                {
                    arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                    arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                    arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                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
            {
                ultraQuerySUPP_NAME.Items.Clear();
                ArrayList arrayList = new ArrayList();
                arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QuerySUPP_NAME",
    new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    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
            {
                ultraBASE_PRICE_NAME.Items.Clear();
    //            ArrayList arrayList = new ArrayList();
    //            arrayList.Add(txtQueryITEM_CODE.Text.Trim());
    //            DataTable dt = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryBASE_PRICE_NAME",
    //new Object[] { arrayList }, ob);
                DataTable dt = this.execute<DataTable>("com.hnshituo.pur.balance.service.BalanceBasepriceMService", "doQureyBasePriceM", new object[] { null });

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable1.Rows.Clear();
                    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
            {
                ultraATTR_NAME.Items.Clear();
                ArrayList arrayList = new ArrayList();
                arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                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);

                //绑定物料属性
                ultraATTR_NAME.Items.Clear();
                ultraATTR_NAME.DataSource = dt.DefaultView.ToTable(true, "ATTR_CODE", "ATTR_NAME");
                ultraATTR_NAME.DisplayMember = "ATTR_NAME";
                ultraATTR_NAME.ValueMember = "ATTR_CODE";
            }
            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";
            }
            if(!StringUtil.Is_Below_zero(txt_honour.Text.Trim()))
            {
                txt_honour.Text = "0";
            }
            if(!StringUtil.Is_Below_zero(txt_volume.Text.Trim()))
            {
                txt_volume.Text = "0";
            }
            if(!StringUtil.Is_Below_zero(txt_check.Text.Trim()))
            {
                txt_check.Text = "0";
            }
            if (!StringUtil.Is_Below_zero(txtLEN_DEDUCT_PRICE.Text.Trim()))
            {
                txtLEN_DEDUCT_PRICE.Text = "0";
            }
            //double addNum = Convert.ToDouble(txtADD_PRICE.Text.Trim());
            double addNum = Convert.ToDouble(txt_honour.Text.Trim()) + Convert.ToDouble(txt_volume.Text.Trim()) - Convert.ToDouble(txt_check.Text.Trim()) - Convert.ToDouble(txtLEN_DEDUCT_PRICE.Text.Trim());
            txtADD_PRICE.Text = addNum.ToString();
            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);//供应商编码
                    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(txtREMARK.Text.Trim());//备注
                    alBaseParams.Add(userId);//创建人
                    alBaseParams.Add(user);//创建人
                    alBaseParams.Add(txt_honour.Value);//承兑加价
                    alBaseParams.Add(txt_volume.Value);//保量加价
                    alBaseParams.Add(txt_check.Value);//考核
                    alBase.Add(alBaseParams);

                    //从表
                    DataRow[] arrPrice;
                    foreach (DataRow dr in arr)
                    {
                        alCkParams = new ArrayList();
                        alCkUpdateParams = 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());
                            double rate = StringUtil.Is_Below_zero(dr["TAX_RATE_NAME"].ToString().TrimEnd('%')) ? (1 + Convert.ToDouble(dr["TAX_RATE_NAME"].ToString().TrimEnd('%')) / 100) : 1.13;//求税率，没有得到则默认1.13
                            alCkParams.Add(Math.Round(price / rate, 4));//不含税单价，税率需根据合同找，废钢默认为1.13
                            alCkParams.Add(price);//含税单价 BUY_PRICE_TAX

                            alCkUpdateParams.Add(Math.Round(price / rate, 4));
                        }
                        else
                        {
                            alCkParams.Add("");//不含税单价
                            alCkParams.Add("");//含税单价 BUY_PRICE_TAX

                            alCkUpdateParams.Add("");
                        }
                        alCkParams.Add("1");
                        alCkParams.Add("");//备注
                        alCkParams.Add(userId);//创建人
                        alCkParams.Add(user);//创建人
                        alCk.Add(alCkParams);

                        //alCkUpdateParams = new ArrayList();
                        alCkUpdateParams.Add(ultraBASE_PRICE_NAME.Value != null ? ultraBASE_PRICE_NAME.Value.ToString() : "");
                        alCkUpdateParams.Add(ultraBASE_PRICE_NAME.Text.Trim());
                        alCkUpdateParams.Add("1");
                        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 (chkITEM_CODE.Checked)
                {
                    arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                    arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                    arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                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["BUY_PRICE_TAX"].ToString());
                        alCkUpdateParams.Add("");
                        alCkUpdateParams.Add(ultraBASE_PRICE_NAME.Text.ToString());
                        alCkUpdateParams.Add("0");
                        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_FG",
        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();
            }
        }

        //输入物料 查询出此物料对应的供应商
        private void txtQueryITEM_CODE_TextChanged(object sender, EventArgs e)
        {
            if (txtQueryITEM_CODE.Text == "Y01010001")
            {
                PublicPur.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "IN_STOCK_NO", "CAR_NUM", "ITEM_NAME", "ATTR_CODE", "GROSS_QTY", "TARE_QTY", "NET_QTY", "KZ_QTY", "KZ_NET_QTY", "KJT_QTY", "KCC_QTY", "KQB_QTY", "INV_QTY", "SUTTLETIME", "REMARK", "HONOUR_PRICE", "VOLUME_PRICE", "CHECK_PRICE" }, true);
                dataTable2.Columns["INV_QTY"].Caption = "料型净重";
            }
            else
            {
                PublicPur.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "IN_STOCK_NO", "ITEM_NAME", "ATTR_CODE", "INV_QTY", "REMARK" }, true);
                dataTable2.Columns["INV_QTY"].Caption = "入库量";
            }
            if (ultraQuerySUPP_NAME.Value == null || ultraQuerySUPP_NAME.Text == "")
            {
                QuerySUPP_NAME();
            }
            QueryBASE_PRICE_NAME();
            ultraATTR_NAME.Items.Clear();
            //QueryATTR_NAME();
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                chkITEM_CODE.Enabled = false;
                chkITEM_CODE.Checked = true;
                chkSUPP_NAME.Enabled = false;
                chkSUPP_NAME.Checked = true;

                chkDate.Text = "入库时间";

                chkSUTTLETIME.Visible = true;
                dateBegin_S.Visible = true;
                labelTo.Visible = true;
                dateEnd_S.Visible = true;

                chkBALANCE_NO.Visible = false;
                txtQueryBALANCE_NO.Visible = false;
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                chkITEM_CODE.Enabled = true;
                chkSUPP_NAME.Enabled = true;

                chkDate.Text = "结算时间";

                chkSUTTLETIME.Visible = false;
                dateBegin_S.Visible = false;
                labelTo.Visible = false;
                dateEnd_S.Visible = false;

                chkBALANCE_NO.Location = new Point(761, 12);
                chkBALANCE_NO.Visible = true;
                txtQueryBALANCE_NO.Location = new Point(835, 11);
                txtQueryBALANCE_NO.Visible = true;
            }
        }

        private void ultraTextEditor1_TextChanged(object sender, EventArgs e)
        {
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                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 (chkSUTTLETIME.Checked)
                    {
                        arrayList.Add("1");
                        arrayList.Add("1");
                        arrayList.Add(dateBegin_S.DateTime.ToShortDateString() + " 00:00:00");
                        arrayList.Add(dateEnd_S.DateTime.ToShortDateString() + " 23:59:59");
                    }
                    else
                    {
                        arrayList.Add("");
                        arrayList.Add("");
                        arrayList.Add("0001/01/01 00:00:00");
                        arrayList.Add("9999/12/31 23:59:59");
                    }
                    if (chkITEM_CODE.Checked)
                    {
                        arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                        arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                        arrayList.Add(txtQueryITEM_CODE.Text.Trim());
                    }
                    else
                    {
                        arrayList.Add("");
                        arrayList.Add("");
                        arrayList.Add("");
                    }

                    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;
                    }
                    else
                    {
                        string remark = ultraTextEditor1.Text.ToString();
                        DataTable dt1 = PublicServer.GetData("com.hnshituo.pur.balance.service.impl.FrmBalanceBillManage.QueryCkInBillRecord_FG1",
        new Object[] { arrayList,remark }, ob);
                        if(dt1 == null || dt1.Rows.Count == 0)
                        {
                            GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1
                        }
                        else
                        {
                            GridHelper.CopyDataToDatatable(dt1, dataTable2, true);//把dt复制给dataTable1
                        }
                    }

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

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

                    //GridHelper.RefreshAndAutoSize(ultraGrid2);
                }
                catch (Exception e1)
                {
                    MessageUtil.ShowWarning(e1.Message);
                    return;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                QueryBalanceInBillRecord();
            }
           
        }
    }
}