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 CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.SaleOrder.Dialog;
using com.steering.pss.sale.orderchange.entity;
using Core.Mes.Client.Comm.Format;
using Core.StlMes.Client.SaleOrder.OrderForm;
using Core.Mes.Client.Comm;
using System.Management;
using Infragistics.Win;

namespace Core.StlMes.Client.SaleOrder
{
    public partial class frmOrderQualityManager : FrmBase
    {
        //  120504 为天淮界面
        //  -----------------------------------  CustomInfo ==2  时  来自于 合同行变更的请求。---------------------------------------------
        //   删除 ChgeDelete   变更确认  ChgeConfirm  新增  ChgeAdd   查询  ChgeQuery  修改 ChgeUpdate
        //   合同行新增逻辑“冻结变更” 提报完毕之后 还可以修改附加要求

        //---------------------------------    CustomInfo ==3  时  来自于 合同头变更的请求。---------------------------------------------'''
        // 查询 ChgeHeadQuery  修改 ChgeHeadUpdate  查看修改 ChgeHeadWatch 

        //合同行是否新增指令参数
        private string orderSeq = null;
        public string OrderSeq
        {
            get { return orderSeq; }
            set { orderSeq = value; }
        }
        private string specName = null;
        private int pstrueFla = 0;
        private bool stas = false;
        private string departNames = "";

        string orderpsc = "";
        string spec = "";
        string model = "";
        string len = "";
        string user = "";
        string mps = "";
        string addtional = "";                //附加要求
        string special = "";                  //特殊要求

        string dlyaddress = "";  //现货合同 交货地点

        /// <summary>
        /// 销售组织
        /// </summary>
        string _saleOrg = "";

        /// <summary>
        /// 采购期货初始化标识
        /// </summary>
        bool purchaseNoFlag = false;
        bool purchaseNoFlag1 = false;

        /// <summary>
        /// 合同行初始化标识
        /// </summary>
        bool lineFlag = false;

        /// <summary>
        /// 合同行控件 CtrlOrderLine  的编号
        /// </summary>
        int lineNum = 1;

        public string SpecName
        {
            get { return specName; }
            set
            {
                specName = value;
            }
        }

        /// <summary>
        /// CustomInfo=2时 合同变更标识  是否冻结变更
        /// </summary>
        bool freezeFlag = false;


        public frmOrderQualityManager()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
        }

        Color color = new Color();
        private void frmOrderManager_Load(object sender, EventArgs e)
        {
            departNames = UserInfo.GetDepartment();
            string deptId = UserInfo.GetDeptid().Trim();
            UserInfo.SaleOrg = ClsBaseInfo.GetSaleOrg(deptId);
            _saleOrg = UserInfo.SaleOrg;

            //默认查询当前日期-1月——当前日期数据。
            udtStart.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString());
            udtEnd.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());

            color = ultraGrid2.DisplayLayout.Override.RowSelectorAppearance.BackColor;
            if (ClsBaseInfo.GetSaleOrg(UserInfo.GetDeptid()) != "100102")
            {
                ultraGrid1.DisplayLayout.Bands[0].Columns["BUSINESS_TYPE"].Hidden = true;
            }
            purchaseNoFlag = false;

            splitContainer1.SplitterDistance = 80;
            splitContainer2.SplitterDistance = 80;

            ValueList sharedValueList = CreateSharedValueList();
            ultraGrid5.DisplayLayout.Bands[0].Columns["SPECL_FL"].ValueList = sharedValueList;
            ValueList sharedValueList1 = CreateSharedValueList();
            ValueList sharedValueList2 = CreateSharedValueList();
            ValueList sharedValueList3 = CreateSharedValueList();
            ValueList sharedValueList4 = CreateSharedValueList();
            ValueList sharedValueList5 = CreateSharedValueList();
            ultraGrid6.DisplayLayout.Bands[0].Columns["SPECL_FL"].ValueList = sharedValueList1;
            ultraGrid7.DisplayLayout.Bands[0].Columns["SPECL_FL"].ValueList = sharedValueList2;
            ultraGrid8.DisplayLayout.Bands[0].Columns["SPECL_FL"].ValueList = sharedValueList3;
            ultraGrid9.DisplayLayout.Bands[0].Columns["SPECL_FL"].ValueList = sharedValueList4;
            ultraGrid10.DisplayLayout.Bands[0].Columns["SPECL_FL"].ValueList = sharedValueList5;
        }
        // 创建共享 ValueList 的方法
        private ValueList CreateSharedValueList()
        {
            ValueList vlist = new ValueList();
            vlist.ValueListItems.Insert(0, "0", "交付");
            vlist.ValueListItems.Insert(1, "1", "特殊");
            vlist.ValueListItems.Insert(2, "2", "内控");
            return vlist;
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "doQuery":
                    doQuery();
                    break;
                case "doApproval":
                    this.doApproval();    //合同确认
                    break;

                case "doClose":
                    this.Close();
                    break;
            }
        }


        /// <summary>
        /// 确认
        /// </summary>
        private void doApproval()
        {
            UltraGridRow row = ultraGrid2.ActiveRow;
            if (row ==null)
            {
                MessageUtil.ShowTips("请选择需要确认的合同行!!!");
                return;
            }
            else {
                
                if (row.Cells["IS_CONFIRMED"].Value.Equals("已确认")) {
                    MessageUtil.ShowTips("该合同行当前状态为已确认，不需要重复确认");
                    return;
                }
                string orderLnPk = row.Cells["ORD_LN_PK"].Value.ToString();

                string orderPK = row.Cells["ORD_PK"].Value.ToString();
                string orderNo = row.Cells["ORDER_NO"].Value.ToString();
                if (MessageUtil.ShowYesNoAndQuestion("是否确认合同行【" + orderNo + "】?") == DialogResult.No) return;
                 
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.sale.order.CoreOrderManager";
                ccp.MethodName = "confirmOrderLine";
                ccp.ServerParams = new object[] { orderLnPk, this.UserInfo.GetUserName() };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                MessageUtil.ShowTips(ccp.ReturnCode ==-1?ccp.ReturnInfo:"操作成功");
                //展示合同行数据
                GetOrderLineDt(orderPK, "1");

            }
        }


        /// <summary>
        /// 查询功能
        /// </summary>
        private void doQuery()
        {
            //清理底部的查询信息
            this.clearQualityResult();
            string orderNo = "";      //合同号
            string orderStart = "";
            string orderEnd = "";

            if (uchkOrderNo.Checked)
            {
                orderNo = utxtOrderNo.Text.Trim();
            }

            string valid = "";
            if (chkValid.Checked)
            {
                valid = "0";
            }
            else
            {
                valid = "1";
            }

            if (uchkDate.Checked)
            {
                orderStart = udtStart.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
                orderEnd = udtEnd.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
            }
            else
            {
                orderStart = "1000-01-01 00:00:01";
                orderEnd = "9999-12-31 23:59:59";
            }
            string isJs = "";
            if (ultraCheckEditor2.Checked)
            {
                isJs = "0";
            }
            string isQr = "";
            if (ultraCheckEditor1.Checked) 
            {
                isQr = "0";
            }
            string supp = this.CustomInfo.Contains("120504") ? this.CustomInfo : "";
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.doQueryHead", new Object[] { orderNo, orderStart, orderEnd, valid, ClsBaseInfo.GetArrByValid(this.ValidDataPurviewIds), this.ValidDataPurviewIds, isJs, isQr }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.orderHeadDt, true);

            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if ("1".Equals(row.Cells["CUSTOMER_MODEL_FL"].Value))
                {
                    row.Cells["CUSTOMER_MODEL_FL"].Value = true;
                }
                else
                {
                    row.Cells["CUSTOMER_MODEL_FL"].Value = false;
                }

                if ("1".Equals(row.Cells["VALIDFLAG"].Value))
                {
                    row.Cells["VALIDFLAG"].Value = true;
                    row.Appearance.ForeColor = Color.Black;
                }
                else
                {

                    row.Cells["VALIDFLAG"].Value = false;
                    row.Appearance.ForeColor = Color.Red;
                }
            }

            if (ultraGrid1.ActiveRow == null)
            {
                this.orderLineDt.Clear();
            }

        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {

            this.clearQualityResult();
            UltraGridRow row = ultraGrid1.ActiveRow;

            ultraGrid2.DisplayLayout.Bands[0].Columns["ORDER_COUNT"].Hidden = true;

            string managNo = row.Cells["ORD_PK"].Value.ToString();

            string orderNo = row.Cells["ORDER_NO"].Value.ToString();
            string orderModelNo = ultraGrid1.ActiveRow.Cells["ORDER_MODEL_NO"].Value.ToString();
            string orderpk = ultraGrid1.ActiveRow.Cells["ORD_PK"].Value.ToString();
            //主合同头信息
            DataView orderHeadDv = new DataView(orderHeadDt);

            orderHeadDv.RowFilter = " ORDER_NO='" + orderNo + "'";

            DataTable orderHeadr = orderHeadDv.ToTable();
            orderHeadr.TableName = "SLM_ORDER_HEAD";

            if (Convert.ToBoolean(orderHeadr.Rows[0]["CUSTOMER_MODEL_FL"]))
            {
                orderHeadr.Rows[0]["CUSTOMER_MODEL_FL"] = "1";
            }
            else
            {
                orderHeadr.Rows[0]["CUSTOMER_MODEL_FL"] = "0";
            }

            //列自适应
            //GridHelper.RefreshAndAutoSizeExceptRows(ultraGrid3, new UltraGridColumn[] {
            //});

            //获取付款要求
            DataTable blanceMnyDt = GetBlanceMny(orderpk);
            blanceMnyDt.TableName = "SLM_ORDER_BALNCE_MNY";

            orderManagerHeadr.Tables.Clear();

            orderManagerHeadr.Tables.Add(orderHeadr);
            orderManagerHeadr.Tables.Add(blanceMnyDt);
            //展示合同行数据
            GetOrderLineDt(managNo, "1");
            //ctrlOrderLineChildGer.loadOrderLineChild(this.ob, null, null);

            ultraGrid2.ActiveRow = null;

        }

        /// <summary>
        /// 绑定合同行数据源
        /// </summary>
        private void GetOrderLineDt(string manageNo, string valid)
        {
            string isQr = "";
            if (ultraCheckEditor1.Checked)
            {
                isQr = "0";
            }
            string isJs = "";
            if (ultraCheckEditor2.Checked)
            {
                isJs = "0";
            }
            string form = this.CustomInfo.Equals("2-120504") ? "2" : this.CustomInfo;
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.GetOrderLineDtLine", new Object[] { manageNo, valid, form, freezeFlag,isQr, isJs }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.orderLineDt, true);

            //不同颜色区分是否有效数据
            Infragistics.Win.UltraWinGrid.UltraGridRow row = null;
            for (int i = 0; i < ultraGrid2.Rows.Count; i++)
            {
                row = ultraGrid2.Rows[i];
                if (!row.Cells["VALIDFLAG"].Value.ToString().Equals("1"))
                {
                    row.Cells["VALIDFLAG"].Value = false;
                    row.Appearance.ForeColor = Color.Red;
                }
                else
                {
                    row.Cells["VALIDFLAG"].Value = true;
                    row.Appearance.ForeColor = Color.Black;
                }

                if ("1".Equals(row.Cells["MPS_FL"].Value))
                {
                    row.Cells["MPS_FL"].Value = true;
                }
                else
                {
                    row.Cells["MPS_FL"].Value = false;
                }


                //监制
                if ("1".Equals(row.Cells["PRODUCER_FL"].Value.ToString()))
                {
                    row.Cells["PRODUCER_FL"].Value = true;
                }
                else
                {
                    row.Cells["PRODUCER_FL"].Value = false;
                }

                //ASSEL
                if ("1".Equals(row.Cells["ASSEL_FL"].Value.ToString()))
                {
                    row.Cells["ASSEL_FL"].Value = true;
                }
                else
                {
                    row.Cells["ASSEL_FL"].Value = false;
                }

                if (row.Cells["ISLOCK"].Value.ToString() == "1")
                {
                    row.RowSelectorAppearance.BackColor = Color.Red;
                }
                else
                {
                    row.RowSelectorAppearance.BackColor = color;
                }

            }
        }

        /// <summary>
        /// 获取付款要求
        /// </summary>
        /// <param name="manageNo"></param>
        /// <param name="orderNo"></param>
        /// <returns></returns>
        private DataTable GetBlanceMny(string ord_pk)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.GetBlanceMny", new Object[] { ord_pk }, this.ob);
            return dt;
        }

        /// <summary>
        /// 合同头相关信息
        /// </summary>
        DataSet orderManagerHeadr = new DataSet();


        UltraGridRow oldRow = null;

        private string designKey = null;
        private string ordLnPk = null;
        private string ordPk = null;
        private string ordSeq = null;

        /// <summary>
        /// 合同行选中事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            if (ultraGrid1.ActiveRow == null)
                return;
            this.clearQualityResult();
            ultraGrid2.UpdateData();
            this.Cursor = Cursors.WaitCursor;
            string managNo = ultraGrid2.ActiveRow.Cells["ORD_PK"].Value.ToString();
            string orderNo = ultraGrid2.ActiveRow.Cells["ORD_LN_PK"].Value.ToString();
            string orderSeq = ultraGrid2.ActiveRow.Cells["ORDER_SEQ"].Value.ToString();
            this.ordLnPk = orderNo;
            this.ordPk = managNo;
            this.ordSeq = orderSeq;
            // 获取质量相关的信息
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.queryOrderDesignMsc", new Object[] { managNo, orderNo, orderSeq }, this.ob);

            GridHelper.CopyDataToDatatable(ref dt, ref this.CRAFT_ORD_DESIGN_MSCDT, true);

            if (dt.Rows.Count > 0)
            {
                designKey = dt.Rows[0]["DESGIN_KEY"].ToString();

                string tabName = this.ultraTabControl1.ActiveTab.Key;
                if (!string.IsNullOrEmpty(tabName)) 
                {
                    this.loadQualityTabData(tabName);//加载质量激活标签的数据
                }
                
            }
            else
            {
                designKey = null;
                this.clearQualityResult();
            }

            this.Cursor = Cursors.Default;
        }

        /// <summary>
        /// 根据desiginKey查询表
        /// </summary>
        /// <param name="tableName"></param>
        /// <param name="designKey"></param>
        /// <returns></returns>
        private DataTable queryTableByDesignKey(string tableName, string designKey)
        {
            return ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.queryOrderQuality", new Object[] { tableName, designKey }, this.ob);
        }

        private DataTable executeSqlQuery(string sql, ArrayList paramList)
        {
            return ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.queryOrderQualityWithSql", new Object[] { sql, paramList }, this.ob);
        }

        /// <summary>
        /// 查询区合同号
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void uchkOrderNo_CheckedChanged(object sender, EventArgs e)
        {
            if (uchkOrderNo.Checked)
            {
                utxtOrderNo.ReadOnly = false;
            }
            else
            {
                utxtOrderNo.Text = "";
                utxtOrderNo.ReadOnly = true;
            }
        }



        /// <summary>
        /// 查询区签订日期
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void uchkDate_CheckedChanged(object sender, EventArgs e)
        {
            if (uchkDate.Checked)
            {
                udtStart.ReadOnly = false;
                udtEnd.ReadOnly = false;
            }
            else
            {
                udtStart.ReadOnly = true;
                udtEnd.ReadOnly = true;
            }
        }


        private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
        {
            this.clearQualityResult();
            UltraGridRow row = ultraGrid1.ActiveRow;

            string managNo = row.Cells["ORD_PK"].Value.ToString();
            if (this.CustomInfo == "2" || this.CustomInfo == "2-120504")
            {
                GetOrderLineDt(managNo, "0");
                return;
            }

            string orderNo = row.Cells["ORDER_NO"].Value.ToString();

            string orderModelNo = ultraGrid1.ActiveRow.Cells["ORDER_MODEL_NO"].Value.ToString();

            string orderpk = ultraGrid1.ActiveRow.Cells["ORD_PK"].Value.ToString();
            //主合同头信息
            DataView orderHeadDv = new DataView(orderHeadDt);

            orderHeadDv.RowFilter = " ORDER_NO='" + orderNo + "'";

            DataTable orderHeadr = orderHeadDv.ToTable();
            orderHeadr.TableName = "SLM_ORDER_HEAD";

            if (Convert.ToBoolean(orderHeadr.Rows[0]["CUSTOMER_MODEL_FL"]))
            {
                orderHeadr.Rows[0]["CUSTOMER_MODEL_FL"] = "1";
            }
            else
            {
                orderHeadr.Rows[0]["CUSTOMER_MODEL_FL"] = "0";
            }

            //列自适应
            //GridHelper.RefreshAndAutoSizeExceptRows(ultraGrid3, new UltraGridColumn[] {
            //});

            //获取付款要求
            DataTable blanceMnyDt = GetBlanceMny(orderpk);
            blanceMnyDt.TableName = "SLM_ORDER_BALNCE_MNY";

            orderManagerHeadr.Tables.Clear();

            orderManagerHeadr.Tables.Add(orderHeadr);
            orderManagerHeadr.Tables.Add(blanceMnyDt);

            string valid = "";
            if (chkValid.Checked)
            {
                valid = "0";
            }
            else
            {
                valid = "1";
            }
            if (this.CustomInfo == "3" || this.CustomInfo == "3-120504")
                return;
            //展示合同行数据
            GetOrderLineDt(managNo, valid);
            //ctrlOrderLineChildGer.loadOrderLineChild(this.ob, null, null);
            ultraGrid2.ActiveRow = null;
        }

        private void utxtOrderNo_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                if (this.CustomInfo == "2" || this.CustomInfo == "2-120504")
                {
                    this.ChgeQuery();
                }
                else if (this.CustomInfo == "3" || this.CustomInfo == "3-120504")
                {
                    this.ChgeHeadQuery();
                }
                else
                {
                    doQuery();
                }
            }
        }

        string locaPk = "";               //主键定位
        /// <summary>
        /// 合同行变更  合同头查询
        /// </summary>
        private void ChgeQuery()
        {
            UltraGridRow ugr = ultraGrid1.ActiveRow;
            if (ugr != null)
                locaPk = ugr.Cells["ORD_PK"].Value.ToString();
            string orderNo = utxtOrderNo.Text.Trim();

            string orderStart = "1000-01-01 00:00:01";
            string orderEnd = "9999-12-31 23:59:59";

            string valid = "";
            if (chkValid.Checked)
            {
                valid = "0";
            }
            else
            {
                valid = "1";
            }

            if (uchkDate.Checked)
            {
                orderStart = udtStart.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
                orderEnd = udtEnd.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
            }

            ArrayList list = new ArrayList();
            list.Add(orderNo);
            list.Add(orderStart);
            list.Add(orderEnd);
            list.Add(valid);
            list.Add(UserInfo.SaleOrg);
            list.Add(UserInfo.GetDeptid());

            string supp = this.CustomInfo.Equals("2-120504") ? "120504" : "";
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.orderchange.CoreOrderChangeManage.chgeOrderHeadQuery", new Object[] { list, freezeFlag, supp }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.orderHeadDt, true);

            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if ("1".Equals(row.Cells["CUSTOMER_MODEL_FL"].Value))
                {
                    row.Cells["CUSTOMER_MODEL_FL"].Value = true;
                }
                else
                {
                    row.Cells["CUSTOMER_MODEL_FL"].Value = false;
                }
                if (locaPk != "")
                {
                    if (row.Cells["ORD_PK"].Value.ToString() == locaPk)
                        row.Activate();
                }
            }

            if (dt.Rows.Count <= 0)
            {
                this.orderLineDt.Rows.Clear();
            }
        }

        /// <summary>
        /// 合同头变更-合同头的查询
        /// </summary>
        private void ChgeHeadQuery()
        {
            string orderNo = utxtOrderNo.Text.Trim();

            string orderStart = "1000-01-01 00:00:01";
            string orderEnd = "9999-12-31 23:59:59";

            string valid = "0";

            if (uchkDate.Checked)
            {
                orderStart = udtStart.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
                orderEnd = udtEnd.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
            }

            ArrayList list = new ArrayList();
            list.Add(orderNo);
            list.Add(orderStart);
            list.Add(orderEnd);
            list.Add(valid);
            list.Add(UserInfo.SaleOrg);
            list.Add(UserInfo.GetDeptid());

            string supp = this.CustomInfo.Contains("120504") ? "120504" : "";
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.orderchange.CoreOrderChangeManage.orderChangeHeadDetail", new Object[] { list, supp }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.orderHeadDt, true);

            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if ("1".Equals(row.Cells["CUSTOMER_MODEL_FL"].Value))
                {
                    row.Cells["CUSTOMER_MODEL_FL"].Value = true;
                }
                else
                {
                    row.Cells["CUSTOMER_MODEL_FL"].Value = false;
                }

                if (row.Cells["VALIDFLAG"].Value.ToString().ToUpper() == "TRUE")
                {
                    row.Appearance.ForeColor = Color.Black;
                }
                else
                {
                    row.Appearance.ForeColor = Color.Red;
                }
            }

            if (dt.Rows.Count <= 0)
            {
                this.orderLineDt.Rows.Clear();
            }

        }

        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            if (this.CustomInfo == "3" || this.CustomInfo == "3-120504")
            {
                if (e.Row.Cells["ISLOCK"].Value.ToString() == "1")
                {
                    e.Row.RowSelectorAppearance.BackColor = Color.Red;
                }
                else
                {
                    e.Row.RowSelectorAppearance.BackColor = color;
                }
            }
        }

        public string GetComputerInfo()
        {
            return "计算机名:" + Environment.GetEnvironmentVariable("COMPUTERNAME") + " IP：" +
                   System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList[0].ToString2() +
                   " Mac地址：" + GetLocalMac();

        }

        /// <summary>  
        /// 获取本机的MAC地址  
        /// </summary>  
        /// <returns></returns>  
        public static string GetLocalMac()
        {
            try
            {
                string mac = null;
                ManagementObjectSearcher query = new ManagementObjectSearcher("SELECT * FROM Win32_NetworkAdapterConfiguration");
                ManagementObjectCollection queryCollection = query.Get();
                foreach (ManagementObject mo in queryCollection)
                {
                    if (mo["IPEnabled"].ToString() == "True")
                        mac = mo["MacAddress"].ToString();
                }
                return (mac);
            }
            catch (Exception)
            {
                return "";
            }
        }

        /// <summary>
        /// 下面质量TAB页切换的点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            string tabName = e.Tab.Key;
            loadQualityTabData(tabName);
        }

        /// <summary>
        /// 查询最下面的那一堆TAB页的数据
        /// </summary>
        /// <param name="tabName"></param>
        private void loadQualityTabData(string tabName)
        {
            DataTable gridTab = null;
            switch (tabName)
            {
                case "CRAFT_ORD_DESIGN"://工艺评审
                    gridTab = this.CRAFT_ORD_DESIGN_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STD_CIC"://成分标准
                    gridTab = this.CRAFT_ORD_DESIGN_STD_CIC_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STD_WIC"://水压
                    gridTab = this.CRAFT_ORD_DESIGN_STD_WIC_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STD_DIC"://探伤
                    gridTab = this.CRAFT_ORD_DESIGN_STD_DIC_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STD_SIC"://公差
                    gridTab = this.CRAFT_ORD_DESIGN_STD_SIC_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STD_GIC"://加工标注
                    gridTab = this.CRAFT_ORD_DESIGN_STD_GIC_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STD_PIC"://理化标准
                    gridTab = this.CRAFT_ORD_DESIGN_STD_PIC_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STS_TKLG"://设计状态主表
                    gridTab = this.CRAFT_ORD_DESIGN_STS_TKLG_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STS_TKLG_LST"://设计状态从表
                    gridTab = this.CRAFT_ORD_DESIGN_STS_TKLG_LST_DT;
                    break;
                case "CRAFT_ORD_DESIGN_MSC_PL"://制程
                    gridTab = this.CRAFT_ORD_DESIGN_MSC_PL_DT;
                    break;
                case "CRAFT_ORD_DESIGN_MSC_PL_GZ"://制程钢种
                    gridTab = this.CRAFT_ORD_DESIGN_MSC_PL_GZ_DT;
                    break;
                case "CRAFT_ORD_DESIGN_ADD_ASK"://附加要求
                    gridTab = this.CRAFT_ORD_DESIGN_ADD_ASK_DT;
                    break;
                case "CRAFT_ORD_DESIGN_MSC_PL_PRC"://钢种及物料内控
                    gridTab = this.CRAFT_ORD_DESIGN_MSC_PL_PRC_DT;
                    break;
                case "CRAFT_ORD_DESIGN_MSC_PL_STI"://全制程工序点
                    gridTab = this.CRAFT_ORD_DESIGN_MSC_PL_STI_DT;
                    break;
                case "CRAFT_ORD_DESIGN_STD_PIC_SMP"://取样要求 
                    gridTab = this.CRAFT_ORD_DESIGN_STD_PIC_SMP_DT;
                    break;
                case "CRAFT_ORD_DESIGN_MSC_PL_GX_PRL"://工序适用产线 
                    gridTab = this.CRAFT_ORD_DESIGN_MSC_PL_GX_PRL_DT;
                    break;
                case "SLM_ORD_DESIGN_BOM"://BOM清单
                    gridTab = null;
                    if (this.designKey != null)
                    {
                        string sql = "SELECT * FROM SLM_ORD_DESIGN_BOM sodb  WHERE EXISTS (SELECT 1 FROM CRAFT_ORD_LINE_BOM colb  WHERE sodb.BOM  = colb.BOM AND colb.DESGIN_KEY =? )";
                        ArrayList list = new ArrayList();
                        list.Add(designKey);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref this.SLM_ORD_DESIGN_BOM_DT, true);
                    }
                    break;
                case "SLM_BASE_MATERIAL"://物料清单
                    gridTab = null;
                    if (designKey != null)
                    {
                        string sql = "SELECT m.* FROM SLM_BASE_MATERIAL m WHERE EXISTS( SELECT 1 FROM SLM_ORD_DESIGN_BOM b WHERE b.MATERIAL_NO = m.MATERIAL_NO "
                                     + " AND EXISTS( SELECT 1 FROM CRAFT_ORD_LINE_BOM c  WHERE c.BOM = b.BOM  AND c.DESGIN_KEY = ? ))";
                        ArrayList list = new ArrayList();
                        list.Add(designKey);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref this.SLM_BASE_MATERIAL_DT, true);
                    }
                    break;
                case "CRAFT_ORD_FD_CIC"://首日检成分标准
                    if (ordLnPk != null)
                    {
                        string sql = "select * from CRAFT_ORD_FD_CIC where ord_ln_pk=?";
                        ArrayList list = new ArrayList();
                        list.Add(ordLnPk);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref this.CRAFT_ORD_FD_CIC_DT, true);
                    }
                    break;
                case "CRAFT_ORD_FD_CIC_COUNT"://成分首日检套数
                    if (ordLnPk != null)
                    {
                        string sql = "select * from CRAFT_ORD_FD_CIC_COUNT where ord_ln_pk=?";
                        ArrayList list = new ArrayList();
                        list.Add(ordLnPk);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref this.CRAFT_ORD_FD_CIC_COUNT_DT, true);
                    }
                    break;
                case "CRAFT_ORD_FD_PIC"://工艺理化评审首日检基础表
                    if (ordLnPk != null)
                    {
                        string sql = "select * from CRAFT_ORD_FD_PIC where ord_ln_pk=?";
                        ArrayList list = new ArrayList();
                        list.Add(ordLnPk);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref this.CRAFT_ORD_FD_PIC_DT, true);
                    }
                    break;
                case "CRAFT_ORD_FD_PIC_SMP"://首日检取样
                    if (ordLnPk != null)
                    {
                        string sql = "select * from CRAFT_ORD_FD_PIC_SMP where ord_ln_pk=?";
                        ArrayList list = new ArrayList();
                        list.Add(ordLnPk);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref this.CRAFT_ORD_FD_PIC_SMP_DT, true);
                    }
                    break;
                case "CRAFT_ORD_FD_WIC"://水压首日检
                    if (ordLnPk != null)
                    {
                        string sql = "select * from CRAFT_ORD_FD_WIC where ord_ln_pk=?";
                        ArrayList list = new ArrayList();
                        list.Add(ordLnPk);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref this.CRAFT_ORD_FD_WIC_DT, true);
                    }
                    break;
                case "PLN_SALEORD"://销售合同
                    if (ordPk != null && ordLnPk != null)
                    {
                        string sql = "select * from PLN_SALEORD where ord_pk=? and ord_ln_pk=?";
                        ArrayList list = new ArrayList();
                        list.Add(this.ordPk);
                        list.Add(this.ordLnPk);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref PLN_SALEORD_DT, true);
                    }
                    break;

                case "PROCESS_ORDER_M"://合同进程主表
                    if (ordPk != null && ordLnPk != null)
                    {
                        string sql = "select * from PROCESS_ORDER_M where ord_pk=? and ord_ln_pk=?";
                        ArrayList list = new ArrayList();
                        list.Add(this.ordPk);
                        list.Add(this.ordLnPk);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref PLN_SALEORD_DT, true);
                    }
                    break;

                case "SLM_ORDER_LINE_DELIVERY"://合同信息_合同行交货信息
                    if (ordPk != null && ordLnPk != null)
                    {
                        string sql = "select * from SLM_ORDER_LINE_DELIVERY where ord_pk=? and ord_ln_pk=?";
                        ArrayList list = new ArrayList();
                        list.Add(this.ordPk);
                        list.Add(this.ordLnPk);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref SLM_ORDER_LINE_DELIVERY_DT, true);
                    }
                    break;
                case "CRM_SLM_ORDER"://CRM接口合同信息表
                    if (ordPk != null && ordLnPk != null)
                    {
                        string sql = "select * from CRM_SLM_ORDER where ord_pk=? and ord_ln_pk=? and order_seq=?";
                        ArrayList list = new ArrayList();
                        list.Add(this.ordPk);
                        list.Add(this.ordLnPk);
                        list.Add(this.ordSeq);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        if (dt.Rows.Count > 0) GridHelper.CopyDataToDatatable(ref dt, ref CRM_SLM_ORDER_DT, true);
                    }
                    break;
                case "CRM_ORDER_PRODUCE"://CRM接口排产计划信息表
                    if (ordPk != null && ordLnPk != null)
                    {
                        string sql = "select * from CRM_ORDER_PRODUCE where ord_pk=? and ord_ln_pk=? and order_seq=?";
                        ArrayList list = new ArrayList();
                        list.Add(this.ordPk);
                        list.Add(this.ordLnPk);
                        list.Add(this.ordSeq);
                        DataTable dt = this.executeSqlQuery(sql, list);
                        GridHelper.CopyDataToDatatable(ref dt, ref CRM_ORDER_PRODUCE_DT, true);
                    }
                    break;
                default:
                    gridTab = null;
                    break;
            }

            if (this.designKey != null && gridTab != null)
            {
                DataTable dt = this.queryTableByDesignKey(tabName, this.designKey);
                GridHelper.CopyDataToDatatable(ref dt, ref gridTab, true);
            }
        }

        private void clearQualityResult()
        {
            this.designKey = null;
            this.ordPk = null;
            this.ordLnPk = null;

            foreach (DataTable table in this.dataSet1.Tables)
            {
                if (table.TableName.Contains("_"))
                {
                    table.Clear();
                }
            }
        }
    }
}