MES_Client/TGMES/Core.StlMes.Client.BuyBillet/FrmBuBilletXs.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
using System.IO;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;

using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;

using System.Net;

using System.Collections;

using CoreFS.SA06;

namespace Core.StlMes.Client.BuyBillet
{
    public partial class FrmBuBilletXs : FrmBase
    {
        private DataTable dt3 = new DataTable();
        private DataTable dtResult = new DataTable();
        public FrmBuBilletXs()
        {
            InitializeComponent();
        }

        private void FrmBuBilletXs_Load(object sender, EventArgs e)
        {
            //ultraGrid1_bind();
            //ultraGrid2_bind();
            //ultraGrid3_bind();
        }
        private void FrmBuBilletXs_Shown(object sender, EventArgs e)
        {
            setToolBarAppearance(DefaultableBoolean.True, DefaultableBoolean.False);
        }
        //绑定供应商
        private void ultraGrid1_bind()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_BASE_CUSTOMER", new object[] { }, this.ob);
            DataTable _dt = new DataTable();
            _dt.Columns.Add("SUPPLIER", typeof(string));
            var _rows = dt.AsEnumerable().OrderBy(r => r.Field<string>("CUSTOMER_NO"));
            foreach (var row in _rows)
            {
                DataRow _row = _dt.NewRow();
                _row["SUPPLIER"] = row["CUSTOMER_NM"];
                _dt.Rows.Add(_row);
            }
            this.ultraGrid1.DataSource = _dt;
            RefreshAndAutoSize(ultraGrid1);

        }
        private void ultraGrid2_bind()
        {
            string deptId = this.UserInfo.GetDeptid();

            DataTable dt = new DataTable();

            //天淮deptid
            if (deptId.StartsWith("002023"))
            {
                dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_REQ_XS1TH", new object[] { }, this.ob);
            }
            else
            {
                dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_REQ_XS1", new object[] { }, this.ob);
            }

            DataTable dt2 = new DataTable();
            //克隆表结构
            dt2 = dt.Clone();
            foreach (DataColumn col in dt2.Columns)
            {
                if (col.ColumnName == "DIAMETER_GP" || col.ColumnName == "LEN_GP_SINGLE" ||
                    col.ColumnName == "BC" || col.ColumnName == "GP_WEIGHT")
                {
                    //修改列类型
                    col.DataType = typeof(decimal);
                }
                else if (col.ColumnName == "ISSUED_TIME")
                {
                    col.DataType = typeof(DateTime);
                }
            }
            foreach (DataRow row in dt.Rows)
            {
                DataRow rowNew = dt2.NewRow();
                foreach (DataColumn col in dt.Columns)
                {

                    rowNew[col.ColumnName] = row[col.ColumnName];
                }

                dt2.Rows.Add(rowNew);
            }

            this.ultraGrid2.DataSource = dt2;
            RefreshAndAutoSize(ultraGrid2);
            string[] colalign = { "DIAMETER_GP", "LEN_GP_SINGLE", "GP_WEIGHT","BC" };
            foreach (string colname in colalign)
            {
                ultraGrid2.DisplayLayout.Bands[0].Columns[colname].CellAppearance.TextHAlign = HAlign.Right;
            }
            if (!deptId.StartsWith("002023"))
            {
                ultraGrid2.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid2.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
                ultraGrid2.DisplayLayout.Bands[0].Columns["GPREQ_VERSION"].Hidden = true;
                ultraGrid6.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid6.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
                ultraGrid6.DisplayLayout.Bands[0].Columns["GPREQ_VERSION"].Hidden = true;
                ultraGrid8.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid8.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
                ultraGrid8.DisplayLayout.Bands[0].Columns["GPREQ_VERSION"].Hidden = true;
                ultraGrid10.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid10.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
                ultraGrid10.DisplayLayout.Bands[0].Columns["GPREQ_VERSION"].Hidden = true;
            }
            //ultraGrid1.Selected.Rows.Clear();
            //ultraGrid1.ActiveRow = ultraGrid1.Rows[0];
            //ultraGrid1.Rows[0].Selected = true;

        }
        private void ultraGrid3_bind()
        {
            string deptId = this.UserInfo.GetDeptid();

            DataTable dt = new DataTable();

            //天淮deptid
            if (deptId.StartsWith("002023"))
            {
                dt3 = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_ORDERTH", new object[] { }, this.ob);
            }
            else
            {
                dt3 = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_ORDER", new object[] { }, this.ob);
            }


            
            //克隆表结构
            dtResult = dt3.Clone();
            foreach (DataColumn col in dtResult.Columns)
            {
                if (col.ColumnName == "FIX_NUM" || col.ColumnName == "DIAMETER" ||col.ColumnName == "LEN_GP_SINGLE" ||
                    col.ColumnName == "LENGTH" || col.ColumnName == "WEIGHT_NUM" || col.ColumnName == "WEIGHT_TOT")
                {
                    //修改列类型
                    col.DataType = typeof(decimal);
                }
                else if (col.ColumnName == "ISSUED_TIME" || col.ColumnName == "CREATE_TIME")
                {
                    col.DataType = typeof(DateTime);
                }
            }
            foreach (DataRow row in dt3.Rows)
            {
                DataRow rowNew = dtResult.NewRow();
                foreach (DataColumn col in dtResult.Columns)
                {
    
                        rowNew[col.ColumnName] = row[col.ColumnName];
                 }

                dtResult.Rows.Add(rowNew);
            }
            //dt3 = dtResult;
            //dt3 = null;
            //dt3 = dtResult;
            //dtResult = nullultraGrid2_bind;
            //dtResult = null;
            //dtResult = dt3;
            this.ultraGrid3.DataSource = dtResult;
            dtResult.AcceptChanges();
            RefreshAndAutoSize(ultraGrid3);
        }
        private void ultraGrid4_bind()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_ORDER_FORXSEXCEL", new object[] { }, this.ob);
            ultraGrid4.DataSource = dt;

        }
        private void ultraGrid5_bind()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_BASE_CUSTOMERSJX", new object[] { }, this.ob);
            DataTable _dt = new DataTable();
            _dt.Columns.Add("SUPPLIER", typeof(string));
            var _rows = dt.AsEnumerable().OrderBy(r => r.Field<string>("CUSTOMER_NO"));
            foreach (var row in _rows)
            {
                DataRow _row = _dt.NewRow();
                _row["SUPPLIER"] = row["CUSTOMER_NM"];
                _dt.Rows.Add(_row);
            }
            this.ultraGrid5.DataSource = _dt;
            RefreshAndAutoSize(ultraGrid5);

        }
        private void ultraGrid6_bind()
        {
            string deptId = this.UserInfo.GetDeptid();

            DataTable dt = new DataTable();

            //天淮deptid
            if (deptId.StartsWith("002023"))
            {
                dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_REQ_XS1THSJX", new object[] { }, this.ob);
            }
            else
            {
                return;
            }

            DataTable dt2 = new DataTable();
            //克隆表结构
            dt2 = dt.Clone();
            foreach (DataColumn col in dt2.Columns)
            {
                if (col.ColumnName == "DIAMETER_GP" || col.ColumnName == "LEN_GP_SINGLE" ||
                    col.ColumnName == "BC" || col.ColumnName == "GP_WEIGHT")
                {
                    //修改列类型
                    col.DataType = typeof(decimal);
                }
                else if (col.ColumnName == "ISSUED_TIME")
                {
                    col.DataType = typeof(DateTime);
                }
            }
            foreach (DataRow row in dt.Rows)
            {
                DataRow rowNew = dt2.NewRow();
                foreach (DataColumn col in dt.Columns)
                {

                    rowNew[col.ColumnName] = row[col.ColumnName];
                }

                dt2.Rows.Add(rowNew);
            }

            this.ultraGrid6.DataSource = dt2;
            RefreshAndAutoSize(ultraGrid6);
            string[] colalign = { "DIAMETER_GP", "LEN_GP_SINGLE", "GP_WEIGHT", "BC" };
            foreach (string colname in colalign)
            {
                ultraGrid6.DisplayLayout.Bands[0].Columns[colname].CellAppearance.TextHAlign = HAlign.Right;
            }
            if (!deptId.StartsWith("002023"))
            {
                ultraGrid6.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid6.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
            }

        }
        private void ultraGrid7_bind()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_BASE_CUSTOMERSJX1", new object[] { }, this.ob);
            DataTable _dt = new DataTable();
            _dt.Columns.Add("SUPPLIER", typeof(string));
            var _rows = dt.AsEnumerable().OrderBy(r => r.Field<string>("CUSTOMER_NO"));
            foreach (var row in _rows)
            {
                DataRow _row = _dt.NewRow();
                _row["SUPPLIER"] = row["CUSTOMER_NM"];
                _dt.Rows.Add(_row);
            }
            this.ultraGrid7.DataSource = _dt;
            RefreshAndAutoSize(ultraGrid7);


        }
        private void ultraGrid8_bind()
        {
            string deptId = this.UserInfo.GetDeptid();

            DataTable dt = new DataTable();

            //天淮deptid
            if (deptId.StartsWith("002023"))
            {
                dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_REQ_XS1THSJX1", new object[] { }, this.ob);
            }
            else
            {
                return;
            }

            DataTable dt2 = new DataTable();
            //克隆表结构
            dt2 = dt.Clone();
            foreach (DataColumn col in dt2.Columns)
            {
                if (col.ColumnName == "DIAMETER_GP" || col.ColumnName == "LEN_GP_SINGLE" ||
                    col.ColumnName == "BC" || col.ColumnName == "GP_WEIGHT")
                {
                    //修改列类型
                    col.DataType = typeof(decimal);
                }
                else if (col.ColumnName == "ISSUED_TIME")
                {
                    col.DataType = typeof(DateTime);
                }
            }
            foreach (DataRow row in dt.Rows)
            {
                DataRow rowNew = dt2.NewRow();
                foreach (DataColumn col in dt.Columns)
                {

                    rowNew[col.ColumnName] = row[col.ColumnName];
                }

                dt2.Rows.Add(rowNew);
            }

            this.ultraGrid8.DataSource = dt2;
            RefreshAndAutoSize(ultraGrid8);
            string[] colalign = { "DIAMETER_GP", "LEN_GP_SINGLE", "GP_WEIGHT", "BC" };
            foreach (string colname in colalign)
            {
                ultraGrid8.DisplayLayout.Bands[0].Columns[colname].CellAppearance.TextHAlign = HAlign.Right;
            }
            if (!deptId.StartsWith("002023"))
            {
                ultraGrid8.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid8.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
            }

        }
        private void ultraGrid9_bind()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_BASE_CUSTOMERSJX2", new object[] { }, this.ob);
            DataTable _dt = new DataTable();
            _dt.Columns.Add("SUPPLIER", typeof(string));
            var _rows = dt.AsEnumerable().OrderBy(r => r.Field<string>("CUSTOMER_NO"));
            foreach (var row in _rows)
            {
                DataRow _row = _dt.NewRow();
                _row["SUPPLIER"] = row["CUSTOMER_NM"];
                _dt.Rows.Add(_row);
            }
            this.ultraGrid9.DataSource = _dt;
            RefreshAndAutoSize(ultraGrid9);


        }
        private void ultraGrid10_bind()
        {
            string deptId = this.UserInfo.GetDeptid();

            DataTable dt = new DataTable();

            //天淮deptid
            if (deptId.StartsWith("002023"))
            {
                dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_REQ_XS1THSJX2", new object[] { }, this.ob);
            }
            else
            {
                return;
            }

            DataTable dt2 = new DataTable();
            //克隆表结构
            dt2 = dt.Clone();
            foreach (DataColumn col in dt2.Columns)
            {
                if (col.ColumnName == "DIAMETER_GP" || col.ColumnName == "LEN_GP_SINGLE" ||
                    col.ColumnName == "BC" || col.ColumnName == "GP_WEIGHT")
                {
                    //修改列类型
                    col.DataType = typeof(decimal);
                }
                else if (col.ColumnName == "ISSUED_TIME")
                {
                    col.DataType = typeof(DateTime);
                }
            }
            foreach (DataRow row in dt.Rows)
            {
                DataRow rowNew = dt2.NewRow();
                foreach (DataColumn col in dt.Columns)
                {

                    rowNew[col.ColumnName] = row[col.ColumnName];
                }

                dt2.Rows.Add(rowNew);
            }

            this.ultraGrid10.DataSource = dt2;
            RefreshAndAutoSize(ultraGrid10);
            string[] colalign = { "DIAMETER_GP", "LEN_GP_SINGLE", "GP_WEIGHT", "BC" };
            foreach (string colname in colalign)
            {
                ultraGrid10.DisplayLayout.Bands[0].Columns[colname].CellAppearance.TextHAlign = HAlign.Right;
            }
            if (!deptId.StartsWith("002023"))
            {
                ultraGrid10.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid10.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
            }

        }

        private void ultraGrid12_bind()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_BASE_CUSTOMERSJX2", new object[] { }, this.ob);
            DataTable _dt = new DataTable();
            _dt.Columns.Add("SUPPLIER", typeof(string));
            var _rows = dt.AsEnumerable().OrderBy(r => r.Field<string>("CUSTOMER_NO"));
            foreach (var row in _rows)
            {
                DataRow _row = _dt.NewRow();
                _row["SUPPLIER"] = row["CUSTOMER_NM"];
                _dt.Rows.Add(_row);
            }
            this.ultraGrid12.DataSource = _dt;
            RefreshAndAutoSize(ultraGrid12);


        }
        private void ultraGrid13_bind()
        {
            string deptId = this.UserInfo.GetDeptid();

            DataTable dt = new DataTable();

            //天淮deptid
            if (deptId.StartsWith("002023"))
            {
                dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_REQ_XS1THSJX3", new object[] { }, this.ob);
            }
            else
            {
                return;
            }

            DataTable dt2 = new DataTable();
            //克隆表结构
            dt2 = dt.Clone();
            foreach (DataColumn col in dt2.Columns)
            {
                if (col.ColumnName == "DIAMETER_GP" || col.ColumnName == "LEN_GP_SINGLE" ||
                    col.ColumnName == "BC" || col.ColumnName == "GP_WEIGHT")
                {
                    //修改列类型
                    col.DataType = typeof(decimal);
                }
                else if (col.ColumnName == "ISSUED_TIME")
                {
                    col.DataType = typeof(DateTime);
                }
            }
            foreach (DataRow row in dt.Rows)
            {
                DataRow rowNew = dt2.NewRow();
                foreach (DataColumn col in dt.Columns)
                {

                    rowNew[col.ColumnName] = row[col.ColumnName];
                }

                dt2.Rows.Add(rowNew);
            }

            this.ultraGrid13.DataSource = dt2;
            RefreshAndAutoSize(ultraGrid13);
            string[] colalign = { "DIAMETER_GP", "LEN_GP_SINGLE", "GP_WEIGHT", "BC" };
            foreach (string colname in colalign)
            {
                ultraGrid13.DisplayLayout.Bands[0].Columns[colname].CellAppearance.TextHAlign = HAlign.Right;
            }
            if (!deptId.StartsWith("002023"))
            {
                ultraGrid13.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid13.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
            }

        }

        private void ultraGrid2_bind_supplier(string supplier)
        {
            DataTable dt = new DataTable();

            string deptId = this.UserInfo.GetDeptid();

            //天淮deptid
            if (deptId.StartsWith("002023"))
            {
                dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_SpecialSupplier1TH", new object[] { supplier }, this.ob);
            }
            else
            {
                dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryBUY_GP_SpecialSupplier1", new object[] { supplier }, this.ob);
            }

            DataTable dt2 = new DataTable();
            //克隆表结构
            dt2 = dt.Clone();
            foreach (DataRow row in dt.Rows)
            {
                DataRow rowNew = dt2.NewRow();
                foreach (DataColumn col in dt.Columns)
                {

                    rowNew[col.ColumnName] = row[col.ColumnName];
                }

                dt2.Rows.Add(rowNew);
            }
            this.ultraGrid2.DataSource = dt2;
            if (!deptId.StartsWith("002023"))
            {
                ultraGrid2.DisplayLayout.Bands[0].Columns["EXAMINE_STATUS"].Hidden = true;
                ultraGrid2.DisplayLayout.Bands[0].Columns["EXAMINE_TIME"].Hidden = true;
            }

        }
       
        /// <summary>
        /// 合同拆分后重新刷新合同页面
        /// </summary>
        private void frm_OnOrderCfFinished()
        {
            ultraGrid3_bind();
            RefreshAndAutoSize(ultraGrid3);
        }
        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (e.Tab.Index == 0)
            {
                ultraGrid1_bind();
                ultraGrid2_bind();
                setToolBarAppearance(DefaultableBoolean.True, DefaultableBoolean.False);
            }
            if (e.Tab.Index == 1)
            {
                ultraGrid5_bind();
                ultraGrid6_bind();
                setToolBarAppearance(DefaultableBoolean.True, DefaultableBoolean.False);
            }
            if (e.Tab.Index == 2)
            {
                ultraGrid7_bind();
                ultraGrid8_bind();
                setToolBarAppearance(DefaultableBoolean.True, DefaultableBoolean.False);
            }
            if (e.Tab.Index == 3)
            {
                ultraGrid9_bind();
                ultraGrid10_bind();
                setToolBarAppearance(DefaultableBoolean.True, DefaultableBoolean.False);
            }
            if (e.Tab.Index == 4)
            {
                ultraGrid3_bind();
                setToolBarAppearance(DefaultableBoolean.False, DefaultableBoolean.True);
            }
            if (e.Tab.Index == 5)
            {
                ultraGrid12_bind();
                ultraGrid13_bind();
                setToolBarAppearance(DefaultableBoolean.True, DefaultableBoolean.False);
            }
        }

        private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
        {
            string supplier = e.Cell.Text;
            if (supplier == "全部")
            {
                ultraGrid2_bind();
            }
            else
            {
                ultraGrid2_bind_supplier(supplier);
            }
        }
        #region 业务方法
        /// <summary>
        /// 生成合同
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void doOrder()
        {
            string deptId = this.UserInfo.GetDeptid();
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                //DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryTest", new object[] { }, this.ob);

                UltraGridRow supplierRow = this.ultraGrid1.ActiveRow;

                UltraGridRow requireRow = this.ultraGrid2.ActiveRow;

                string supplier = supplierRow.Cells["SUPPLIER"].Value.ToString();
                if (supplier == "全部")
                {
                    MessageBox.Show("未选择有效的供应商!");
                    return;
                }
                //string id = requireRow.Cells["GPBUYPLANID"].Value.ToString();

                StringBuilder sb = new StringBuilder();
                foreach (UltraGridRow row in ultraGrid2.Rows)
                {
                    if (row.Cells["CHK"].Text.ToString() == "True")
                    {
                        sb.Append(row.Cells["GPREQ_ID"].Value.ToString());
                        sb.Append(",");
                        if (deptId.StartsWith("002023") && row.Cells["EXAMINE_STATUS"].Value.ToString() != "副总审批")
                        {
                            MessageBox.Show("审批未通过!");
                            return;
                        }
                    }

                }
                string ids = sb.ToString();
                if (ids.EndsWith(","))
                {
                    ids = ids.Substring(0, ids.Length - 1);
                }

                if (string.IsNullOrEmpty(ids))
                {
                    MessageBox.Show("未选中有效的记录!");
                    return;
                }
                //MessageBox.Show(ids);
                //return;
                int suceed = ServerHelper.SetData("com.steering.pss.buybillet.Buybillet.InsertBUY_GP_ORDER1", new object[] { supplier, ids }, this.ob);
                if (suceed > 0)
                {
                    MessageBox.Show("保存成功!");
                }
                //ultraGrid2_bind();
                ultraGrid1_AfterSelectChange(null, null);
            }
            if (ultraTabControl1.SelectedTab.Index == 1)
            {
                //DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryTest", new object[] { }, this.ob);

                UltraGridRow supplierRow = this.ultraGrid5.ActiveRow;

                UltraGridRow requireRow = this.ultraGrid6.ActiveRow;

                string supplier = supplierRow.Cells["SUPPLIER"].Value.ToString();
                if (supplier == "全部")
                {
                    MessageBox.Show("未选择有效的供应商!");
                    return;
                }

                //string id = requireRow.Cells["GPBUYPLANID"].Value.ToString();

                StringBuilder sb = new StringBuilder();
                foreach (UltraGridRow row in ultraGrid6.Rows)
                {
                    if (row.Cells["CHK"].Text.ToString() == "True")
                    {
                        sb.Append(row.Cells["GPREQ_ID"].Value.ToString());
                        sb.Append(",");

                        if (deptId.StartsWith("002023") && row.Cells["EXAMINE_STATUS"].Value.ToString() != "副总审批")
                        {
                            MessageBox.Show("审批未通过!");
                            return;
                        }
                    }

                }
                string ids = sb.ToString();
                if (ids.EndsWith(","))
                {
                    ids = ids.Substring(0, ids.Length - 1);
                }

                if (string.IsNullOrEmpty(ids))
                {
                    MessageBox.Show("未选中有效的记录!");
                    return;
                }
                //MessageBox.Show(ids);
                //return;
                int suceed = ServerHelper.SetData("com.steering.pss.buybillet.Buybillet.InsertBUY_GP_ORDER1SJH", new object[] { supplier, ids }, this.ob);
                if (suceed > 0)
                {
                    MessageBox.Show("保存成功!");
                }
                ultraGrid6_bind();
            }
            if (ultraTabControl1.SelectedTab.Index == 2)
            {
                //DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryTest", new object[] { }, this.ob);

                UltraGridRow supplierRow = this.ultraGrid7.ActiveRow;

                UltraGridRow requireRow = this.ultraGrid8.ActiveRow;

                string supplier = supplierRow.Cells["SUPPLIER"].Value.ToString();
                if (supplier == "全部")
                {
                    MessageBox.Show("未选择有效的供应商!");
                    return;
                }

                //string id = requireRow.Cells["GPBUYPLANID"].Value.ToString();

                StringBuilder sb = new StringBuilder();
                foreach (UltraGridRow row in ultraGrid8.Rows)
                {
                    if (row.Cells["CHK"].Text.ToString() == "True")
                    {
                        sb.Append(row.Cells["GPREQ_ID"].Value.ToString());
                        sb.Append(",");

                        if (deptId.StartsWith("002023") && row.Cells["EXAMINE_STATUS"].Value.ToString() != "副总审批")
                        {
                            MessageBox.Show("审批未通过!");
                            return;
                        }
                    }

                }
                string ids = sb.ToString();
                if (ids.EndsWith(","))
                {
                    ids = ids.Substring(0, ids.Length - 1);
                }

                if (string.IsNullOrEmpty(ids))
                {
                    MessageBox.Show("未选中有效的记录!");
                    return;
                }
                //MessageBox.Show(ids);
                //return;
                int suceed = ServerHelper.SetData("com.steering.pss.buybillet.Buybillet.InsertBUY_GP_ORDER1SJH", new object[] { supplier, ids }, this.ob);
                if (suceed > 0)
                {
                    MessageBox.Show("保存成功!");
                }
                ultraGrid8_bind();
            }
            if (ultraTabControl1.SelectedTab.Index == 3)
            {
                //DataTable dt = ServerHelper.GetData("com.steering.pss.buybillet.Buybillet.queryTest", new object[] { }, this.ob);

                UltraGridRow supplierRow = this.ultraGrid9.ActiveRow;

                UltraGridRow requireRow = this.ultraGrid10.ActiveRow;

                string supplier = supplierRow.Cells["SUPPLIER"].Value.ToString();
                if (supplier == "全部")
                {
                    MessageBox.Show("未选择有效的供应商!");
                    return;
                }

                //string id = requireRow.Cells["GPBUYPLANID"].Value.ToString();

                StringBuilder sb = new StringBuilder();
                foreach (UltraGridRow row in ultraGrid10.Rows)
                {
                    if (row.Cells["CHK"].Text.ToString() == "True")
                    {
                        sb.Append(row.Cells["GPREQ_ID"].Value.ToString());
                        sb.Append(",");

                        if (deptId.StartsWith("002023") && row.Cells["EXAMINE_STATUS"].Value.ToString() != "副总审批")
                        {
                            MessageBox.Show("审批未通过!");
                            return;
                        }
                    }

                }
                string ids = sb.ToString();
                if (ids.EndsWith(","))
                {
                    ids = ids.Substring(0, ids.Length - 1);
                }

                if (string.IsNullOrEmpty(ids))
                {
                    MessageBox.Show("未选中有效的记录!");
                    return;
                }
                //MessageBox.Show(ids);
                //return;
                int suceed = ServerHelper.SetData("com.steering.pss.buybillet.Buybillet.InsertBUY_GP_ORDER1SJH", new object[] { supplier, ids }, this.ob);
                if (suceed > 0)
                {
                    MessageBox.Show("保存成功!");
                }
                ultraGrid10_bind();
            }
        }
        /// <summary>
        /// 保存合同信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void doSave()
        {
            ultraGrid3.UpdateData();
            ArrayList parm = new ArrayList();
            DataTable dtbh = dtResult.GetChanges(DataRowState.Modified);
            if (dtResult.GetChanges(DataRowState.Modified) == null)
            {
                MessageBox.Show("没有修改的数据!");
            }
            else
            {
                var rs = from rows in dtResult.AsEnumerable()
                                 where rows.RowState == DataRowState.Modified
                                 select rows;
                foreach (var row in rs)
                {
                    string str = string.Empty;
                    decimal weight;
                    int bc;
                    decimal.TryParse(row["WEIGHT_NUM"].ToString(), out weight);
                    int.TryParse(row["FIX_NUM"].ToString(), out bc);

                    str += "ordpk:";
                    str += row["ORD_NO_PK"].ToString();
                    str += ";";
                    str += "orderno:";
                    str += row["ORDER_NO"].ToString().Trim();
                    str += ";";
                    str += "weight:";
                    str += weight;
                    str += ";";
                    str += "bc:";
                    str += bc;
                    str += ";";
                    str += "jhdate:";
                    
                    //如果是空值则为默认日期
                    DateTime dt;
                    DateTime.TryParse(row["GET_ENDTIME"].ToString(), out dt);

                    str += dt.ToString("yyyy-MM-dd") == "0001-01-01" ? "2000-01-01" : dt.ToString("yyyy-MM-dd");
                    str += ";";
                    str += "memo:";
                    str += row["MEMO"].ToString();
                    str += ";";
                    str += "orderPrice:";
                    str += row["ORDER_PRICE"].ToString()==""? "0.00": row["ORDER_PRICE"].ToString();
                    parm.Add(str);
                }

                ServerHelper.SetData("com.steering.pss.buybillet.Buybillet.updateTEST1", new object[] { parm }, this.ob);

                ultraGrid3_bind();
            }
        }
        /// <summary>
        /// 拆分合同
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void doModify()
        {
            List<string> list = new List<string>();
            List<string> listsjx = new List<string>();
            foreach (UltraGridRow row in ultraGrid3.Rows)
            {

                if (row.Cells["CHK"].Text.ToString() == "True")
                {
                    list.Add(row.Cells["ORD_NO_PK"].Value.ToString());
                    listsjx.Add(row.Cells["TYPE_FLAG"].Value.ToString());
                }

            }
            if (list.Count == 0)
            {
                MessageBox.Show("未选中有效的记录!");
                return;
            }

            if (list.Count > 1)
            {
                MessageBox.Show("每次只能拆分一笔合同!");
                return;
            }
            if (listsjx[0] == "是")
            {
                MessageBox.Show("双经销合同不允许拆分!");
                return;
            }
            FrmBuyCf frm = new FrmBuyCf(this.ob);
            frm.ORD_NO_PK = list[0];
            frm.OnOrderCfFinished += new Action(frm_OnOrderCfFinished);
            frm.Show();
        }
        /// <summary>
        /// 撤销合同
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void doDelete()
        {
            StringBuilder sb = new StringBuilder();
            foreach (UltraGridRow row in ultraGrid3.Rows)
            {
                    if (row.Cells["CHK"].Text.ToString() == "True")
                    {
                        sb.Append(row.Cells["ORD_NO_PK"].Value.ToString());
                        sb.Append(",");
                    }
            }
            string ids = sb.ToString();
            if (ids.EndsWith(","))
            {
                ids = ids.Substring(0, ids.Length - 1);
            }

            if (string.IsNullOrEmpty(ids))
            {
                MessageBox.Show("未选中有效的记录!");
                return;
            }
            ServerHelper.SetData("com.steering.pss.buybillet.Buybillet.DeleteBUY_GP_ORDER1", new object[] { ids }, this.ob);

            ultraGrid3_bind();
        }
        private void doExcel()
        {
            if(ultraTabControl1.SelectedTab.Index==0)
            {
                ultraGrid2.DisplayLayout.Bands[0].Columns["CHK"].Hidden = true;
                ExportExcel(ultraGrid2, "外购坯需求");
                ultraGrid2.DisplayLayout.Bands[0].Columns["CHK"].Hidden = false;
            }
            if (ultraTabControl1.SelectedTab.Index == 4)
            {
                ultraGrid3.DisplayLayout.Bands[0].Columns["CHK"].Hidden = true;
                ExportExcel(ultraGrid3, "外购坯合同");
                ultraGrid3.DisplayLayout.Bands[0].Columns["CHK"].Hidden = false;
            }
        }
        #endregion

        private void setToolBarAppearance(DefaultableBoolean appearance0, DefaultableBoolean appearance1)
        {
            if (toolMenu == null)
            {
                return;
            }
            string toolBarItem = string.Empty;
            toolBarItem = "doOrder";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance0;
            }
            toolBarItem = "doSave";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance1;
            }
            toolBarItem = "doModify";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance1;
            }
            toolBarItem = "doDelete";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance1;
            }
            toolBarItem = "doExcelExport";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance1;
            }
            toolBarItem = "doCraftE";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance0;
            }
            toolBarItem = "doBossE";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance0;
            }
            toolBarItem = "undoCraftE";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance0;
            }
            toolBarItem = "undoBossE";
            if (toolMenu.Toolbars[0].Tools.Exists(toolBarItem))
            {
                toolMenu.Toolbars[0].Tools[toolBarItem].InstanceProps.Visible = appearance0;
            }
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Close":
                    this.Close();
                    break;
                case "doCraftE": // 工艺审批
                    doCraftE("1","0");
                    break;
                case "doBossE": // 副总审批
                    doBossE("2","1");
                    break;
                case "undoCraftE": // 工艺审批撤销
                    doCraftE("0","1");
                    break;
                case "undoBossE": // 副总审批撤销
                    doBossE("1","2");
                    break;
                case "doOrder":
                    doOrder();
                    break;
                case "doSave":
                    doSave();
                    break;
                case "doModify":
                    doModify();
                    break;
                case "doDelete":
                    doDelete();
                    break;
                case "doExcel":
                    doExcel();
                    break;
                case "doExcelExport":
                    doExcelExport();
                    break;
                case "doQuery":
                    doQuery();
                    break;
            }
        }

        /// <summary>
        /// 副总审批
        /// </summary>
        private void doBossE(string newStatus, string oldStatus)
        {
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                UpdateExamineStatusByBoss(this.ultraGrid2, newStatus, oldStatus);
                ultraGrid1_AfterSelectChange(null, null);
            }
            if (ultraTabControl1.SelectedTab.Index == 1)
            {
                UpdateExamineStatusByBoss(this.ultraGrid6, newStatus, oldStatus);
                ultraGrid6_bind();
            }
            if (ultraTabControl1.SelectedTab.Index == 2)
            {
                UpdateExamineStatusByBoss(this.ultraGrid8, newStatus, oldStatus);
                ultraGrid8_bind();
            }
            if (ultraTabControl1.SelectedTab.Index == 3)
            {
                UpdateExamineStatusByBoss(this.ultraGrid10, newStatus, oldStatus);
                ultraGrid10_bind();
            }
        }

        /// <summary>
        /// 工艺审批
        /// </summary>
        private void doCraftE(string newStatus, string oldStatus)
        {
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                UpdateExamineStatusByCraft(this.ultraGrid2, newStatus, oldStatus);
                ultraGrid1_AfterSelectChange(null,null);
            }
            if (ultraTabControl1.SelectedTab.Index == 1)
            {
                UpdateExamineStatusByCraft(this.ultraGrid6, newStatus, oldStatus);
                ultraGrid6_bind();
            }
            if (ultraTabControl1.SelectedTab.Index == 2)
            {
                UpdateExamineStatusByCraft(this.ultraGrid8, newStatus, oldStatus);
                ultraGrid8_bind();
            }
            if (ultraTabControl1.SelectedTab.Index == 3)
            {
                UpdateExamineStatusByCraft(this.ultraGrid10, newStatus, oldStatus);
                ultraGrid10_bind();
            }
            if (ultraTabControl1.SelectedTab.Index == 5)
            {
                UpdateExamineStatusByCraft(this.ultraGrid12, newStatus, oldStatus);
                ultraGrid10_bind();
            }
        }

        // 修改副总审批状态
        private void UpdateExamineStatusByBoss(UltraGrid ultraGrid, string newStatus, string oldStatus)
        {
            string deptId = this.UserInfo.GetDeptid();

            StringBuilder sb = new StringBuilder();
            foreach (UltraGridRow row in ultraGrid.Rows)
            {
                if (row.Cells["CHK"].Text.ToString() == "True")
                {
                    sb.Append(row.Cells["GPREQ_ID"].Value.ToString());
                    sb.Append(",");
                    if (deptId.StartsWith("002023") 
                        && (row.Cells["EXAMINE_STATUS"].Value.ToString() != "工艺审批" && newStatus == "2"))
                    {
                        MessageBox.Show("不是工艺审批，无法审批!");
                        return;
                    }
                     if (deptId.StartsWith("002023") 
                        && (row.Cells["EXAMINE_STATUS"].Value.ToString() != "副总审批" && newStatus == "1"))
                    {
                        MessageBox.Show("不是副总审批，无法撤销审批!");
                        return;
                    }
                }

            }
            string ids = sb.ToString();
            if (ids.EndsWith(","))
            {
                ids = ids.Substring(0, ids.Length - 1);
            }

            if (string.IsNullOrEmpty(ids))
            {
                MessageBox.Show("未选中有效的记录!");
                return;
            }
            int suceed = ServerHelper.SetData("com.steering.pss.buybillet.Buybillet.UpdateExamineStatus", new object[] { ids, newStatus, oldStatus }, this.ob);
            if (suceed > 0)
            {
                MessageBox.Show("保存成功!");
            }
        }

        // 修改工艺审批状态
        private void UpdateExamineStatusByCraft(UltraGrid ultraGrid, string newStatus, string oldStatus)
        {
            string deptId = this.UserInfo.GetDeptid();

            StringBuilder sb = new StringBuilder();
            foreach (UltraGridRow row in ultraGrid.Rows)
            {
                if (row.Cells["CHK"].Text.ToString() == "True")
                {
                    sb.Append(row.Cells["GPREQ_ID"].Value.ToString());
                    sb.Append(",");
                    if (deptId.StartsWith("002023") 
                         && (row.Cells["EXAMINE_STATUS"].Value.ToString() != "未审批" && newStatus == "1"))
                    {
                        MessageBox.Show("不是未审批，无法审批!");
                        return;
                    }
                    if (deptId.StartsWith("002023")
                         && (row.Cells["EXAMINE_STATUS"].Value.ToString() != "工艺审批" && newStatus == "0"))
                    {
                        MessageBox.Show("不是工艺审批，无法撤销审批!");
                        return;
                    }
                }

            }
            string ids = sb.ToString();
            if (ids.EndsWith(","))
            {
                ids = ids.Substring(0, ids.Length - 1);
            }

            if (string.IsNullOrEmpty(ids))
            {
                MessageBox.Show("未选中有效的记录!");
                return;
            }
            int suceed = ServerHelper.SetData("com.steering.pss.buybillet.Buybillet.UpdateExamineStatus", new object[] { ids, newStatus, oldStatus }, this.ob);
            if (suceed > 0)
            {
                MessageBox.Show("保存成功!");
            }
        }

        private void ExportExcel(UltraGrid ulGrid, string sFileName)
        {
            GridHelper.ulGridToExcel(ulGrid, sFileName);
        }
        private void doExcelExport()
        {
            ultraGrid4_bind();
            GridHelper.ulGridToExcel(ultraGrid4,"销售查询明细");
        }
        private void doQuery()
        {
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                ultraGrid1_bind();
                ultraGrid2_bind();
               
            }
            if (ultraTabControl1.SelectedTab.Index == 1)
            {
                ultraGrid3_bind();
                
            }
        }

        /// <summary>
        /// 刷新Grid数据并根据数据调整Grid列宽
        /// </summary>
        /// <param name="ultraGrid">需要处理的Grid</param>
        public static void RefreshAndAutoSize(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid)
        {
            try
            {
                ultraGrid.DataBind();

                foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                    {
                        column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                    }
                }

                ultraGrid.Refresh();
            }
            catch { }
        }

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

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

        private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {

            ultraGrid1.ActiveRow.Cells["SUPPLIER"].Value.ToString();
            string supplier = ultraGrid1.ActiveRow.Cells["SUPPLIER"].Value.ToString();

            if (supplier == "全部")
            {
                ultraGrid2_bind();
            }
            else
            {
                ultraGrid2_bind_supplier(supplier);
            };
        }
        private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGrid3.ActiveRow;
            string ord_no_pk = row.GetValue("ORD_NO_PK");  
            FrmBuyDCYB frm = new FrmBuyDCYB(this.ob);
            frm.StartPosition = FormStartPosition.CenterScreen;
            frm.OrderID = ord_no_pk;
            frm.Show();
        }
    }
}