RuiTengJb/ICSSoft.AppSln/ICSSoft.Frame.APP/Production/FormICSEQPSTPAdd.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using System.Data.SqlClient;
using ICSSoft.Frame.Data.BLL;
using ICSSoft.Base.Language.Tool;
using ICSSoft.Base.UserControl.MessageControl;
using ICSSoft.Base.Report.Filter;
using ICSSoft.Base.Config.DBHelper;
using ICSSoft.Base.UserControl.FormControl;
using ICSSoft.Base.ReferForm.AppReferForm;
using ICSSoft.Base.Lable.PrintTool;
using ICSSoft.Base.Config.AppConfig;
using ICSSoft.Base.Report.GridReport;
using ICSSoft.Frame.APP.Entity;
using ICSSoft.Frame.APP;
using ICSSoft.Frame.Data.Entity;
using System.Linq;

namespace ICSSoft.Frame.APP
{
    public partial class FormICSEQPSTPAdd : DevExpress.XtraEditors.XtraForm
    {
        FormICSEQPSTPUIModelNew EQPSTPUIModel;
        int flag = 0;
        string eqpstpid;
        bool first = true;

        public FormICSEQPSTPAdd()
        {
            InitializeComponent();
            init();
            chargeFormState("Add");
            flag = 0;
            eqpstpid = AppConfig.GetGuid();
            cboEQPSetting.SelectedIndex = 0;
            tabControl1.ItemSize = new Size(0, 1);
        }
        public FormICSEQPSTPAdd(string id)
        {
            InitializeComponent();
            init();
            chargeFormState("Edit");
            SearchTypeInfo(id);
            flag = 1;
            eqpstpid = id;
            tabControl1.ItemSize = new Size(0, 1);
        }

        private void chargeFormState(string state)
        {

            switch (state)
            {
                case "Add":
                    txtMUSERName.Text = AppConfig.UserName;
                    txtMTIME.Text = AppConfig.GetSeverDateTime("yyyy-MM-dd HH:mm:ss").ToString();
                    txtMUSERName.Properties.ReadOnly = true;
                    txtMTIME.Properties.ReadOnly = true;

                    break;
                case "Edit":
                    txtItemCode.Properties.Buttons[0].Visible = false;
                    txtItemCode.Enabled = false;

                    txtROUTECODE.Properties.Buttons[0].Visible = false;
                    txtROUTECODE.Enabled = false;

                    txtOPCODE.Properties.Buttons[0].Visible = false;
                    txtOPCODE.Enabled = false;

                    //txtEQPCODE.Properties.Buttons[0].Visible = false;
                    //txtEQPCODE.Enabled = false;

                    //txtEQPTypeCode.Properties.Buttons[0].Visible = false;
                    //txtEQPTypeCode.Enabled = false;

                    txtMUSERName.Properties.ReadOnly = true;
                    txtMTIME.Properties.ReadOnly = true;
                    break;
            }
        }

        private void SearchTypeInfo(string id)
        {
            DataTable dt = ICSEQPSTPBLL.searchInfoByID(id, AppConfig.AppConnectString);
            if (dt != null && dt.Rows.Count > 0)
            {
                eqpstpid = dt.Rows[0]["ID"].ToString();

                //txtItemCode.Text = dt.Rows[0]["ITEMCODE"].ToString();
                //cboRouteCode.Text = dt.Rows[0]["EATTRIBUTE1"].ToString();

                txtItemCode.Text = dt.Rows[0]["ITEMCODE"].ToString();
                txtItemName.Text = dt.Rows[0]["ItemName"].ToString();

                txtROUTECODE.Text = dt.Rows[0]["ROUTECODE"].ToString();
                txtRouteName.Text = dt.Rows[0]["ROUTECODE"].ToString();
                txtROUTEMEMO.Text = dt.Rows[0]["ROUTEMEMO"].ToString();

                txtOPCODE.Text = dt.Rows[0]["OPCODE"].ToString();
                txtOPDESC.Text = dt.Rows[0]["OPDESC"].ToString();

                //txtEQPTypeCode.Text = dt.Rows[0]["EQPTypeCode"].ToString();
                //txtEQPTypeName.Text = dt.Rows[0]["EQPTypeName"].ToString();
                //JiaGongTime,JianYanTime,TiaoJiTime,JiaZhuangTime
                //txtSTIME.Text = dt.Rows[0]["STIME"].ToString();
                //txtRTIME.Text = dt.Rows[0]["RTIME"].ToString();
                txtJiagongTime.Text = dt.Rows[0]["JiaGongTime"].ToString();
                txtJiazhuangTime.Text = dt.Rows[0]["JiaZhuangTime"].ToString();
                txtJianyanTime.Text = dt.Rows[0]["JianYanTime"].ToString();
                txtTiaojiTime.Text = dt.Rows[0]["TiaoJiTime"].ToString();

                lookupOPLVL.Text = dt.Rows[0]["OPLVL"].ToString();

                cboIsRef.Checked = dt.Rows[0]["ISREF"].ToString() == "是" ? true : false; ;
                txtMUSERName.Text = AppConfig.UserName;
                txtMTIME.Text = AppConfig.GetSeverDateTime("yyyy-MM-dd HH:mm:ss").ToString();

                lookupOPLVL.Text = dt.Rows[0]["OPLVL"].ToString();
                if (dt.Rows[0]["EQPTypeCode"].ToString() == "固定设备")
                {
                    cboEQPSetting.SelectedIndex = 0;
                    lookupClass.Text = dt.Rows[0]["cClass"].ToString();
                    lookupHandles.Text = dt.Rows[0]["cHandles"].ToString();
                    lookupAxis.Text = dt.Rows[0]["cAxis"].ToString();
                    lookupToolMagazine.Text = dt.Rows[0]["cToolMagazine"].ToString();
                    lookupMachinableProfiles.Text = dt.Rows[0]["cMachinableProfiles"].ToString();
                    lookupAccuracy.Text = dt.Rows[0]["cAccuracy"].ToString();
                }
                else if (dt.Rows[0]["EQPTypeCode"].ToString() == "加工中心" || dt.Rows[0]["EQPTypeCode"].ToString() == "设备类型")
                {
                    cboEQPSetting.SelectedIndex = 1;
                    txtEQPCODE.Text = dt.Rows[0]["EQPCODE"].ToString();
                }
                else if (dt.Rows[0]["EQPTypeCode"].ToString() == "车削中心") {
                    cboEQPSetting.SelectedIndex =2;
                    txtcxjd.EditValue = dt.Rows[0]["CXJD"].ToString();
                    txtcxtype.EditValue = dt.Rows[0]["CXType"].ToString();
                    if(!string.IsNullOrEmpty(dt.Rows[0]["CXBrand1"].ToString()))
                    txtpp1.EditValue = dt.Rows[0]["CXBrand1"].ToString();
                    if (!string.IsNullOrEmpty(dt.Rows[0]["CXBrand2"].ToString()))
                        txtpp2.EditValue = dt.Rows[0]["CXBrand2"].ToString();
                    if (!string.IsNullOrEmpty(dt.Rows[0]["CXBrand3"].ToString()))
                        txtpp3.EditValue = dt.Rows[0]["CXBrand3"].ToString();
                }

                //txtETTRCODE.Text = dt.Rows[0]["ETTRCOde"].ToString();
                //txtBladeModelAndBrand.Text = dt.Rows[0]["BladeModelAndBrand"].ToString();
                //txtOutsourcingProperties.Text = dt.Rows[0]["OutsourcingProperties"].ToString();
                //txtToolingNo.Text = dt.Rows[0]["ToolingNo"].ToString();

            }

        }

        private string check()
        {
            string msg = "";
            Decimal decValue = 0m;

            if (txtItemCode.Text.Trim() == "")
                msg += "存货编码不能为空！\n";
            if (txtROUTECODE.Text.Trim() == "")
            {
                msg += "工艺不能为空！\n";
            }
            if (txtOPCODE.Text.Trim() == "")
                msg += "工序代码不能为空！\n";
            //if (txtEQPTypeCode.Text.Trim() == "")
            //    msg += "设备类型不能为空！\n";

            //if (txtSTIME.Text.Trim() == "")
            //    msg += "标准工时不能为空！\n";
            //else
            //{
            //    if (!Decimal.TryParse(txtSTIME.Text.Trim(), out decValue))
            //    {
            //        msg += "标准工时格式不正确！\n";
            //    }
            //}
            //if (txtRTIME.Text.Trim() == "")
            //    msg += "准备工时不能为空！\n";
            //else
            //{
            //    if (!Decimal.TryParse(txtRTIME.Text.Trim(), out decValue))
            //    {
            //        msg += "准备工时格式不正确！\n";
            //    }
            //}
            //if (txtJianyanTime.Text == "0")
            //{
            //    msg += "请填写工时,且不可为 0 ！\n";
            //}
            //if (flag == 0)
            //{
            //    //if (!ICSEQPSTPBLL.IsIncluding(txtItemCode.Text.Trim(), txtOPCODE.Text.Trim(), txtEQPCODE.Text.Trim(), AppConfig.AppConnectString))
            //    if (!ICSEQPSTPBLL.IsIncluding(txtItemCode.Text.Trim(), txtOPCODE.Text.Trim(), txtEQPTypeCode.Text.Trim(), AppConfig.AppConnectString))
            //        msg += "该产品工序设备类型内对应的标准工时信息已存在！\n";
            //}
            //if (!cboIsRef.Checked)
            //{
            //    msg += "请选择是否为默认标准工时！\n";
            //}
            return msg;
        }

        private void btnOK_Click(object sender, EventArgs e)
        {
            string EQPTypeCode = "";
            string eqpCode = "";
            string eqpName = "";
            string cClass = "";
            string cHandles = "";
            string cAxis = "";
            string cToolMagazine = "";
            string cMachinableProfiles = "";
            string cAccuracy = "";
            decimal? WTIME = 0;
            string OPLVL = "";
            string cxpp1 = "";
            string cxpp2 = "";
            string cxpp3 = "";
            string cxtype = "";
            string cxjd = "";
            try
            {
                string msg = check();
                if (!string.IsNullOrEmpty(msg))
                {
                    ICSBaseSimpleCode.AppshowMessageBox(msg);
                    return;
                }
                if (!chkIsWW.Checked)
                {
                    if (cboEQPSetting.SelectedIndex == 0)
                    {
                        EQPTypeCode = "加工中心";
                        cClass = lookupClass.Text;
                        cHandles = lookupHandles.Text;
                        cAxis = lookupAxis.Text;
                        cToolMagazine = lookupToolMagazine.Text;
                        cMachinableProfiles = lookupMachinableProfiles.Text;
                        cAccuracy = lookupAccuracy.Text;
                        if (cClass == "")
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("类别不能为空!");
                            return;
                        }
                        if (cHandles == "")
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("刀柄不能为空!");
                            return;
                        }
                        if (cAxis == "")
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("轴数不能为空!");
                            return;
                        }
                        if (cToolMagazine == "")
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("刀库不能为空!");
                            return;
                        }
                        if (cMachinableProfiles == "")
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("可加工外形不能为空!");
                            return;
                        }
                        if (cAccuracy == "")
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("精度不能为空!");
                            return;
                        }
                    }
                    else if (cboEQPSetting.SelectedIndex == 1)
                    {
                        EQPTypeCode = "固定设备";
                        eqpCode = txtEQPCODE.Text;
                        eqpName = txtEQPNAME.Text;
                        if (eqpCode == "" || eqpName == "")
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("请选择设备");
                            return;
                        }
                    }
                    else if(cboEQPSetting.SelectedIndex ==2)
                    {
                        EQPTypeCode = "车削中心";
                        if (string.IsNullOrEmpty(txtcxtype.Text)) {
                            ICSBaseSimpleCode.AppshowMessageBox("车削类型不能为空");
                            return;
                        }
                        if (string.IsNullOrEmpty(txtcxjd.Text))
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("车削精度不能为空");
                            return;
                        }
                        List<string> pp = new List<string>();
                        if (!string.IsNullOrEmpty(txtpp1.Text))
                        {
                            pp.Add(txtpp1.Text);
                            cxpp1 = txtpp1.Text;

                        }
                        else {
                            cxpp1 = "00";
                        }
                        if (!string.IsNullOrEmpty(txtpp2.Text))
                        {
                            pp.Add(txtpp2.Text);
                            cxpp2 = txtpp2.Text;
                        }
                        else
                            cxpp2 = "00";
                        if (!string.IsNullOrEmpty(txtpp3.Text))
                        {
                            pp.Add(txtpp3.Text);
                            cxpp3 = txtpp3.Text;
                        }
                        else
                            cxpp3 = "00";
                     IEnumerable<IGrouping<string,string>> count=pp.GroupBy(a => a);
                        foreach (var B in count) {
                            if (B.Count() > 1) {
                                ICSBaseSimpleCode.AppshowMessageBox("存在重复车床品牌，请确认!");
                                return;
                            }
                        }
                        cxjd = txtcxjd.Text;
                        cxtype = txtcxtype.Text;

                    }
                    OPLVL = lookupOPLVL.Text;
                    if (OPLVL == "")
                    {
                        ICSBaseSimpleCode.AppshowMessageBox("工序等级不能为空!");
                        return;
                    }
                    WTIME = 3;
                }
                else
                {
                    EQPTypeCode = "委外";
                    string WWTIME = txtWWTIME.Text;
                    if (WWTIME == "" || WWTIME == "0")
                    {
                        throw new Exception("委外工序时,委外工时必须填写");
                    }
                    WTIME = Convert.ToDecimal(WWTIME);
                    if (WTIME <= 0)
                    {
                        throw new Exception("委外工时必须大于 0");
                    }
                    OPLVL = null;
                }
                ICSEQPSTP eqpstp = new ICSEQPSTP();
                eqpstp.ID = eqpstpid;
                eqpstp.ITEMCODE = txtItemCode.Text;
                eqpstp.OPCODE = txtOPCODE.Text;
                eqpstp.EQPCODE = eqpCode;
                eqpstp.ETTRCODE = txtETTRCODE.Text;
                eqpstp.ISREF = cboIsRef.Checked ? "是" : "否";

                eqpstp.JiaGongTime =
                    eqpstp.STIME = Convert.ToDecimal(txtJiagongTime.Text.Equals("") ? "0" : txtJiagongTime.Text);
                eqpstp.TiaoJiTime =
                    eqpstp.RTIME = Convert.ToDecimal(txtTiaojiTime.Text.Equals("") ? "0" : txtTiaojiTime.Text);
                eqpstp.JiaZhuangTime = Convert.ToDecimal(txtJiazhuangTime.Text.Equals("") ? "0" : txtJiazhuangTime.Text);
                eqpstp.JianYanTime = Convert.ToDecimal(txtJianyanTime.Text.Equals("") ? "0" : txtJianyanTime.Text);

                eqpstp.MUSER = AppConfig.UserCode;
                eqpstp.MUSERName = AppConfig.UserName;
                eqpstp.MTIME = DateTime.Now;
                eqpstp.WorkPoint = AppConfig.WorkPointCode;
                eqpstp.EQPTypeCode = EQPTypeCode;//此处不在存设备类型,设备类型是6大维度决定
                eqpstp.cClass = cClass;
                eqpstp.cHandles = cHandles;
                eqpstp.cAxis = cAxis;
                eqpstp.cToolMagazine = cToolMagazine;
                eqpstp.cMachinableProfiles = cMachinableProfiles;
                eqpstp.cAccuracy = cAccuracy;
                eqpstp.OPLVL = OPLVL;
                eqpstp.WTIME = WTIME;
                eqpstp.EATTRIBUTE1 = txtROUTECODE.Text;
                eqpstp.ToolingNo = txtROUTEMEMO.Text;
                eqpstp.CXBrand1 = cxpp1;
                eqpstp.CXBrand2 = cxpp2;
                eqpstp.CXBrand3 = cxpp3;
                eqpstp.CXJD = cxjd;
                eqpstp.CXType = cxtype;

                ////20180626新增
                //eqpstp.BladeModelAndBrand = this.txtBladeModelAndBrand.Text.Trim();
                //eqpstp.OutsourcingProperties = this.txtOutsourcingProperties.Text.Trim();
                //eqpstp.ToolingNo = this.txtToolingNo.Text.Trim();

                ICSEQPSTPBLL.Add(eqpstp, AppConfig.AppConnectString);
                //this.Close();
                //this.DialogResult = DialogResult.Yes;
                first = false;
                if (flag == 0)
                {
                    ICSBaseSimpleCode.AppshowMessageBox("增加成功");
                    txtItemCode.Properties.Buttons[0].Visible = false;
                    txtItemCode.Enabled = false;
                    txtROUTECODE.Properties.Buttons[0].Visible = false;
                    txtROUTECODE.Enabled = false;
                    eqpstpid = AppConfig.GetGuid();
                    txtROUTEMEMO.Text = "";
                    txtOPCODE.Text = "";
                    txtOPDESC.Text = "";
                    //cboEQPSetting.SelectedIndex = 0;
                    lookupClass.Text = lookupAxis.Text = lookupAccuracy.Text = lookupHandles.Text = lookupToolMagazine.Text = "";
                    txtJiagongTime.Text = txtJiazhuangTime.Text = "0";
                    if (cboEQPSetting.SelectedIndex == 1)
                    {
                        cboTiaojiPRT.SelectedIndex = cboTiaojiBaseTime.SelectedIndex = cboJianyanPRT.SelectedIndex = -1;
                        txtJiagongTime.Text = txtJiazhuangTime.Text = txtJianyanTime.Text = txtTiaojiTime.Text = "0";
                        lookupMachinableProfiles.Text = "";
                    }
                    lookupOPLVL.Text = "";
                    chkIsWW.Checked = false;
                    cboIsRef.Checked = true;

                }
                else if (flag == 1)
                {
                    ICSBaseSimpleCode.AppshowMessageBox("修改成功");
                    this.Close();
                    this.DialogResult = DialogResult.Yes;
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        #region 关闭
        private void btnCancle_Click(object sender, EventArgs e)
        {
            this.Close();
            //this.DialogResult = DialogResult.Cancel;
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
            //this.DialogResult = DialogResult.Cancel;
        }
        #endregion

        #region 存货编码按钮
        //        private void txtItemCode_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        //        {
        //            ButtonEdit btn = (ButtonEdit)sender;
        //            string sql = "select distinct guid as 产品ID,ItemCode as 存货编码,ItemName as 存货名称 from dbo.Base_Inventory with(nolock) WHERE 1=1";
        //            //object obj = AppConfig.InvokeWebservice(AppConfig.BaseServiceUri, "WebBaseService", "BaseService", "GetHuaRongErpConnectString", new object[] { });
        //            //if (obj == null)
        //            //{
        //            //    ICSBaseSimpleCode.AppshowMessageBox(1, "ERP数据库连接取得失败!");

        //            //}
        //            DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
        //            FormDataRefer reForm = new FormDataRefer();
        //            reForm.FormTitle = "产品信息";
        //            DataTable menuData = data;
        //            reForm.DataSource = menuData;
        //            reForm.MSelectFlag = false;
        //            reForm.RowIndexWidth = 35;
        //            reForm.HideCols.Add("产品ID");
        //            reForm.FormWidth = 500;
        //            reForm.FormHeight = 500;
        //            //reForm.FilterKey = btn.Text; 
        //            //grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, grvDetail.FocusedColumn).ToString().Trim();
        //            if (reForm.ShowDialog() == DialogResult.OK)
        //            {
        //                DataTable retData = reForm.ReturnData;
        //                foreach (DataRow dr in retData.Rows)
        //                {
        //                    txtItemCode.Text = dr["存货编码"].ToString();
        //                    //itemid = dr["产品ID"].ToString();
        //                    txtItemName.Text = dr["存货名称"].ToString();
        //                }
        //            }
        //        }
        #endregion

        #region 工序代码按钮
        //        private void txtOPCODE_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        //        {
        //            ButtonEdit btn = (ButtonEdit)sender;
        //            string sql = "";
        //            sql = @"select distinct a.OPID as [工序ID],
        //            a.OPCODE as [工序代码],
        //            b.OPDESC as [工序] 
        //            from ICSITEMROUTE2OP a
        //            left join ICSOP b on a.OPCODE=b.OPCODE
        //where a.ITEMCODE='" + gluItemCode.Text + "' and 1=1";
        //            //where a.ITEMCODE='" + txtItemCode.Text + "' and 1=1";
        //            DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
        //            //            if (data == null || data.Rows.Count == 0)
        //            //            {
        //            //                sql = @"select distinct a.OPID as [工序ID],
        //            //            a.OPCODE as [工序代码],
        //            //            c.OPDESC as [工序] 
        //            //            from ICSMODELROUTE2OP a
        //            //            left join Base_Inventory b on a.MODELCODE=b.ItemMainCategoryCode
        //            //            left join ICSOP c on a.OPCODE=c.OPCODE
        //            //where b.ITEMCODE='" + gluItemCode.Text + "' and 1=1";
        //            ////where b.ITEMCODE='" + txtItemCode.Text + "' and 1=1";
        //            //                //object obj = AppConfig.InvokeWebservice(AppConfig.BaseServiceUri, "WebBaseService", "BaseService", "GetHuaRongErpConnectString", new object[] { });
        //            //                //if (obj == null)
        //            //                //{
        //            //                //    ICSBaseSimpleCode.AppshowMessageBox(1, "ERP数据库连接取得失败!");

        //            //                //}
        //            //                data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
        //            //            }
        //            FormDataRefer reForm = new FormDataRefer();
        //            reForm.FormTitle = "工序信息";
        //            DataTable menuData = data;
        //            reForm.DataSource = menuData;
        //            reForm.MSelectFlag = false;
        //            reForm.RowIndexWidth = 35;
        //            reForm.HideCols.Add("工序ID");
        //            reForm.FormWidth = 500;
        //            reForm.FormHeight = 500;
        //            //reForm.FilterKey = btn.Text; 
        //            //grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, grvDetail.FocusedColumn).ToString().Trim();
        //            if (reForm.ShowDialog() == DialogResult.OK)
        //            {
        //                DataTable retData = reForm.ReturnData;
        //                foreach (DataRow dr in retData.Rows)
        //                {
        //                    txtOPCODE.Text = dr["工序代码"].ToString();
        //                    //opid = dr["工序ID"].ToString();
        //                    txtOPDESC.Text = dr["工序"].ToString();
        //                }
        //            }
        //        }
        #endregion

        #region 设备编号按钮
        //        private void txtEQPCODE_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        //        {
        //            ButtonEdit btn = (ButtonEdit)sender;
        //            string sql = @"select distinct EQPID as [设备ID], EQPCode as [设备编号],EQPName as [设备名称] from dbo.ICSEquipment 
        //            where EType='" + txtEQPTypeName.Text + "'";

        //            DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
        //            FormDataRefer reForm = new FormDataRefer();
        //            reForm.FormTitle = "设备信息";
        //            DataTable menuData = data;
        //            reForm.DataSource = menuData;
        //            reForm.MSelectFlag = false;
        //            reForm.RowIndexWidth = 35;
        //            reForm.HideCols.Add("设备ID");
        //            reForm.FormWidth = 500;
        //            reForm.FormHeight = 500;
        //            //reForm.FilterKey = btn.Text; 
        //            //grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, grvDetail.FocusedColumn).ToString().Trim();
        //            if (reForm.ShowDialog() == DialogResult.OK)
        //            {
        //                DataTable retData = reForm.ReturnData;
        //                foreach (DataRow dr in retData.Rows)
        //                {
        //                    txtEQPCODE.Text = dr["设备编号"].ToString();
        //                    //opid = dr["设备ID"].ToString();
        //                    txtEQPDESC.Text = dr["设备名称"].ToString();
        //                }
        //            }
        //        }
        #endregion

        private void gluItemCode_EditValueChanged(object sender, EventArgs e)
        {
            var o = txtItemCode.Properties.GetRowByKeyValue(txtItemCode.EditValue);
            if (o is DataRowView)
            {
                DataRowView RowView = o as DataRowView;
                txtItemName.Text = RowView.Row["存货名称"].ToString();

                #region 工艺
                string sql = @"
SELECT DISTINCT
	A.ROUTECODE 工艺代码,
	B.ROUTEDESC 工艺名称,
	C.ISREF  默认
FROM dbo.ICSITEMROUTE2OP A
LEFT JOIN dbo.ICSITEM2ROUTE C ON C.ITEMCODE=A.ITEMCODE AND C.ROUTECODE=A.ROUTECODE AND C.WorkPoint=A.WorkPoint
LEFT JOIN dbo.ICSROUTE B ON B.ROUTECODE=A.ROUTECODE AND B.WorkPoint=A.WorkPoint
WHERE A.ITEMCODE='{0}' AND A.WorkPoint='{1}' AND C.ISREF IS NOT NULL
                    ";
                sql = string.Format(sql, txtItemCode.Text, AppConfig.WorkPointCode);
                DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
                DataRow[] drs = data.Select("默认=1 ");
                txtROUTECODE.Properties.ValueMember = "工艺代码";
                txtROUTECODE.Properties.DisplayMember = "工艺代码";
                txtROUTECODE.Properties.DataSource = data;
                txtROUTECODE.Properties.NullText = "";//空时的值    
                txtROUTECODE.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
                txtROUTECODE.Properties.ValidateOnEnterKey = true;//回车确认  
                txtROUTECODE.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
                txtROUTECODE.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 
                //自适应宽度
                //txtROUTECODE.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
                #endregion
                if (drs.Length > 0)
                {
                    txtROUTECODE.Text = drs[0]["工艺代码"].ToString();
                }
            }
        }

        #region 初始化查询条件
        private void init()
        {
            #region 存货编码
            //string sql = "SELECT DISTINCT INVCODE AS [存货编码],INVNAME AS [存货名称] FROM ICSINVENTORY WHERE WorkPoint='{0}' ORDER BY INVCODE";
            string sql = @" 
SELECT DISTINCT A.ITEMCODE AS 存货编码,B.INVNAME AS 存货名称 FROM dbo.ICSITEMROUTE2OP A
LEFT JOIN ICSINVENTORY B ON A.ITEMCODE=B.INVCODE AND A.WorkPoint=B.WorkPoint
WHERE A.WorkPoint='{0}' ORDER BY A.ITEMCODE ASC";
            sql = string.Format(sql, AppConfig.WorkPointCode);
            DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
            txtItemCode.Properties.ValueMember = "存货编码";
            txtItemCode.Properties.DisplayMember = "存货编码";
            txtItemCode.Properties.DataSource = dt;
            txtItemCode.Properties.NullText = "";//空时的值    
            txtItemCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            txtItemCode.Properties.ValidateOnEnterKey = true;//回车确认  
            txtItemCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            txtItemCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 
            //自适应宽度
            txtItemCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
            #endregion

            #region 调机基础值
            DataTable dt1 = ICSOPBLL.SearchDataByEnumKey(AppConfig.AppConnectString, "20001");
            if (dt1 == null || dt1.Rows.Count == 0)
            {
                throw new Exception("自定义档案20001调机工时基础值,未维护");
            }
            foreach (DataRow item in dt1.Rows)
            {
                string val = item["EnumText"].ToString();
                decimal d;
                try
                {
                    d = Convert.ToDecimal(val);
                }
                catch (Exception)
                {
                    throw new Exception("自定义档案20001调机工时计算比率,维护了错误的值'" + val + "'");
                }
                if (d < 0)
                {
                    throw new Exception("自定义档案20001调机工时基础值,维护了错误的值'" + val + "'");
                }
                cboTiaojiBaseTime.Properties.Items.Add(d);
            }
            #endregion

            #region 调机计算比例
            DataTable dt2 = ICSOPBLL.SearchDataByEnumKey(AppConfig.AppConnectString, "20002");
            if (dt2 == null || dt2.Rows.Count == 0)
            {
                throw new Exception("自定义档案20002调机工时计算比率,未维护");
            }
            foreach (DataRow item in dt2.Rows)
            {
                string val = item["EnumText"].ToString();
                decimal d;
                try
                {
                    d = Convert.ToDecimal(val);
                }
                catch (Exception)
                {
                    throw new Exception("自定义档案20002调机工时计算比率,维护了错误的值'" + val + "'");
                }
                if (d < 0)
                {
                    throw new Exception("自定义档案20002调机工时计算比率,维护了错误的值'" + val + "'");
                }
                cboTiaojiPRT.Properties.Items.Add(d);
            }
            #endregion

            #region 检验计算比例
            DataTable dt3 = ICSOPBLL.SearchDataByEnumKey(AppConfig.AppConnectString, "20003");
            if (dt3 == null || dt3.Rows.Count == 0)
            {
                throw new Exception("自定义档案20003检验工时计算比率,未维护");
            }
            foreach (DataRow item in dt3.Rows)
            {
                string val = item["EnumText"].ToString();
                decimal d;
                try
                {
                    d = Convert.ToDecimal(val);
                }
                catch (Exception)
                {
                    throw new Exception("自定义档案20003调机工时计算比率,维护了错误的值'" + val + "'");
                }
                if (d < 0)
                {
                    throw new Exception("自定义档案20003检验工时计算比率,维护了错误的值'" + val + "'");
                }
                cboJianyanPRT.Properties.Items.Add(d);
            }
            #endregion

            #region 设备类型代码
            ////string sql1 = "select distinct EnumValue as [类型编码],EnumText as [设备类型] from dbo.Sys_EnumValues with(nolock) WHERE EnumKey='001' and 1=1";
            //string sql4 = "SELECT TypeCODE as [设备类型编码],TypeDESC as [设备类型] FROM ICSEquipmentType WHERE	WorkPoint = '" + AppConfig.WorkPointCode + "'   and 1=1 ";

            //DataTable dt4 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql4).Tables[0];
            ////txtEQPTypeCode.Properties.ValueMember = "类型编码";
            ////txtEQPTypeCode.Properties.DisplayMember = "类型编码";

            //txtEQPTypeCode.Properties.ValueMember = "设备类型编码";
            //txtEQPTypeCode.Properties.DisplayMember = "设备类型编码";

            //txtEQPTypeCode.Properties.DataSource = dt4;
            //txtEQPTypeCode.Properties.NullText = "";//空时的值    
            //txtEQPTypeCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            //txtEQPTypeCode.Properties.ValidateOnEnterKey = true;//回车确认  
            //txtEQPTypeCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            //txtEQPTypeCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 
            ////自适应宽度
            //txtEQPTypeCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
            #endregion

            #region 六大维度
            string sql3 = @"SELECT LTRIM(RTRIM(EnumText)) as 类型 FROM Sys_EnumValues WHERE EnumKey='30001' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue";
            DataTable dt30001 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql3).Tables[0];
            lookupClass.Properties.ValueMember = "类型";
            lookupClass.Properties.DisplayMember = "类型";
            lookupClass.Properties.DataSource = dt30001;
            lookupClass.Properties.NullText = "";
            lookupClass.Properties.ImmediatePopup = true;
            lookupClass.Properties.ValidateOnEnterKey = true;

            sql3 = @"SELECT LTRIM(RTRIM(EnumText)) as 刀柄 FROM Sys_EnumValues WHERE EnumKey='30002' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue";
            DataTable dt30002 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql3).Tables[0];
            lookupHandles.Properties.ValueMember = "刀柄";
            lookupHandles.Properties.DisplayMember = "刀柄";
            lookupHandles.Properties.DataSource = dt30002;
            lookupHandles.Properties.NullText = "";
            lookupHandles.Properties.ImmediatePopup = true;
            lookupHandles.Properties.ValidateOnEnterKey = true;

            sql3 = @"SELECT LTRIM(RTRIM(EnumText)) as 轴数 FROM Sys_EnumValues WHERE EnumKey='30003' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue";
            DataTable dt30003 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql3).Tables[0];
            lookupAxis.Properties.ValueMember = "轴数";
            lookupAxis.Properties.DisplayMember = "轴数";
            lookupAxis.Properties.DataSource = dt30003;
            lookupAxis.Properties.NullText = "";
            lookupAxis.Properties.ImmediatePopup = true;
            lookupAxis.Properties.ValidateOnEnterKey = true;

            //sql3 = @"SELECT LTRIM(RTRIM(EnumText)) as 刀库数量 FROM Sys_EnumValues WHERE EnumKey='30004' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue";
            //DataTable dt30004 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql3).Tables[0];
            //lookupToolMagazine.Properties.ValueMember = "刀库数量";
            //lookupToolMagazine.Properties.DisplayMember = "刀库数量";
            //lookupToolMagazine.Properties.DataSource = dt30004;
            //lookupToolMagazine.Properties.NullText = "";
            //lookupToolMagazine.Properties.ImmediatePopup = true;
            //lookupToolMagazine.Properties.ValidateOnEnterKey = true;

            //sql3 = @"SELECT LTRIM(RTRIM(EnumText)) as 可加工外形 FROM Sys_EnumValues WHERE EnumKey='30005' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue";
            //DataTable dt30005 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql3).Tables[0];
            //lookupMachinableProfiles.Properties.ValueMember = "可加工外形";
            //lookupMachinableProfiles.Properties.DisplayMember = "可加工外形";
            //lookupMachinableProfiles.Properties.DataSource = dt30005;
            //lookupMachinableProfiles.Properties.NullText = "";
            //lookupMachinableProfiles.Properties.ImmediatePopup = true;
            //lookupMachinableProfiles.Properties.ValidateOnEnterKey = true;

            sql3 = @"SELECT LTRIM(RTRIM(EnumText)) as 精度 FROM Sys_EnumValues WHERE EnumKey='30006' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue";
            DataTable dt30006 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql3).Tables[0];
            lookupAccuracy.Properties.ValueMember = "精度";
            lookupAccuracy.Properties.DisplayMember = "精度";
            lookupAccuracy.Properties.DataSource = dt30006;
            lookupAccuracy.Properties.NullText = "";
            lookupAccuracy.Properties.ImmediatePopup = true;
            lookupAccuracy.Properties.ValidateOnEnterKey = true;
            #endregion

            #region 工序等级(原产品等级)
            string sql00019 = @"SELECT LTRIM(RTRIM(EnumValue)) as 类型,EnumText 说明 FROM Sys_EnumValues WHERE EnumKey='00019' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "'  ORDER BY EnumValue";
            DataTable dt00019 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql00019).Tables[0];
            lookupOPLVL.Properties.ValueMember = "类型";
            lookupOPLVL.Properties.DisplayMember = "类型";
            lookupOPLVL.Properties.DataSource = dt00019;
            lookupOPLVL.Properties.NullText = "";
            lookupOPLVL.Properties.ImmediatePopup = true;
            lookupOPLVL.Properties.ValidateOnEnterKey = true;
            #endregion

            #region 设备
            string sqlEqp = @"SELECT EQPCODE AS 设备代码,EQPNAME AS 设备名称 FROM [dbo].[ICSEquipment] WHERE WorkPoint='" + AppConfig.WorkPointCode + "'  ORDER BY EQPCode";
            DataTable dtEqp = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sqlEqp).Tables[0];
            txtEQPCODE.Properties.ValueMember = "设备代码";
            txtEQPCODE.Properties.DisplayMember = "设备代码";
            txtEQPCODE.Properties.DataSource = dtEqp;
            txtEQPCODE.Properties.NullText = "";
            txtEQPCODE.Properties.ImmediatePopup = true;
            txtEQPCODE.Properties.ValidateOnEnterKey = true;
            txtItemCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
            //txtItemCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
            #endregion

            #region 品牌
            sql = @"select  EnumValue as 品牌代码,EnumText as 品牌名称  from Sys_EnumValues where EnumKey='30007' and  WorkPointCode='" + AppConfig.WorkPointCode + "' ";
            dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
            txtpp1.Properties.ValueMember = "品牌代码";
            txtpp1.Properties.DisplayMember = "品牌代码";
            txtpp1.Properties.DataSource = dt;
            txtpp1.Properties.NullText = "";//空时的值    
            txtpp1.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            txtpp1.Properties.ValidateOnEnterKey = true;//回车确认  
            txtpp1.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            txtpp1.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容                                                                        //自适应宽度
            txtpp1.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;

            txtpp2.Properties.ValueMember = "品牌代码";
            txtpp2.Properties.DisplayMember = "品牌代码";
            txtpp2.Properties.DataSource = dt;
            txtpp2.Properties.NullText = "";//空时的值    
            txtpp2.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            txtpp2.Properties.ValidateOnEnterKey = true;//回车确认  
            txtpp2.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            txtpp2.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容                                                                    //自适应宽度
            txtpp2.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;

            txtpp3.Properties.ValueMember = "品牌代码";
            txtpp3.Properties.DisplayMember = "品牌代码";
            txtpp3.Properties.DataSource = dt;
            txtpp3.Properties.NullText = "";//空时的值    
            txtpp3.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            txtpp3.Properties.ValidateOnEnterKey = true;//回车确认  
            txtpp3.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            txtpp3.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容                                                               //自适应宽度
            txtpp3.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;

            #endregion

            #region 车削类型
             sql = @"select EnumText as 车削类型  from  Sys_EnumValues where enumkey='300010' and WorkPointcode='" + AppConfig.WorkPointCode + "' ";
            dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
            txtcxtype.Properties.ValueMember = "车削类型";
            txtcxtype.Properties.DisplayMember = "车削类型";
            txtcxtype.Properties.DataSource = dt;
            txtcxtype.Properties.NullText = "";
            txtcxtype.Properties.ImmediatePopup = true;
            txtcxtype.Properties.ValidateOnEnterKey = true;
            #endregion

            #region 车削精度
            sql = @"select EnumText as 车削精度  from  Sys_EnumValues where enumkey='300011' and WorkPointcode='" + AppConfig.WorkPointCode + "'  order by EnumText";
            dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
            txtcxjd.Properties.ValueMember = "车削精度";
            txtcxjd.Properties.DisplayMember = "车削精度";
            txtcxjd.Properties.DataSource = dt;
            txtcxjd.Properties.NullText = "";
            txtcxjd.Properties.ImmediatePopup = true;
            txtcxjd.Properties.ValidateOnEnterKey = true;
            #endregion


        }
        #endregion

        //设备类型按钮
        private void txtEQPType_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            ButtonEdit btn = (ButtonEdit)sender;
            string sql = "select distinct EnumValue as [类型编码],EnumText as [设备类型] from dbo.Sys_EnumValues with(nolock) WHERE EnumKey='001' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue";
            //object obj = AppConfig.InvokeWebservice(AppConfig.BaseServiceUri, "WebBaseService", "BaseService", "GetHuaRongErpConnectString", new object[] { });
            //if (obj == null)
            //{
            //    ICSBaseSimpleCode.AppshowMessageBox(1, "ERP数据库连接取得失败!");

            //}
            DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
            FormDataRefer reForm = new FormDataRefer();
            reForm.FormTitle = "设备类型信息";
            DataTable menuData = data;
            reForm.DataSource = menuData;
            reForm.MSelectFlag = false;
            reForm.RowIndexWidth = 35;
            reForm.HideCols.Add("ID");
            reForm.FormWidth = 500;
            reForm.FormHeight = 500;
            //reForm.FilterKey = btn.Text; 
            //grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, grvDetail.FocusedColumn).ToString().Trim();
            if (reForm.ShowDialog() == DialogResult.OK)
            {
                DataTable retData = reForm.ReturnData;
                foreach (DataRow dr in retData.Rows)
                {
                    txtEQPTypeCode.Text = dr["类型编码"].ToString();
                    txtEQPTypeName.Text = dr["设备类型"].ToString();
                }
            }
        }

        private void txtEQPTypeCode_EditValueChanged(object sender, EventArgs e)
        {
            var o = txtEQPTypeCode.Properties.GetRowByKeyValue(txtEQPTypeCode.EditValue);
            if (o is DataRowView)
            {
                DataRowView RowView = o as DataRowView;
                //txtEQPTypeName.Text = RowView.Row["设备类型"].ToString();
                txtEQPTypeName.Text = RowView.Row["设备类型"].ToString();
                txtEQPTypeCode.Text = RowView.Row["设备类型编码"].ToString();

            }
            init2();
        }

        private void init2()
        {

            #region 设备编号
            string sql2 = @"select distinct EQPCode as [设备编号],EQPName as [设备名称] from dbo.ICSEquipment 
            where EType='" + txtEQPTypeName.Text + "' AND WorkPoint='" + AppConfig.WorkPointCode + "'";
            DataTable dt2 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql2).Tables[0];
            txtEQPCODE.Properties.ValueMember = "设备编号";
            txtEQPCODE.Properties.DisplayMember = "设备编号";

            txtEQPCODE.Properties.DataSource = dt2;
            txtEQPCODE.Properties.NullText = "";//空时的值    
            txtEQPCODE.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            txtEQPCODE.Properties.ValidateOnEnterKey = true;//回车确认  
            txtEQPCODE.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            txtEQPCODE.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 
            //自适应宽度
            txtEQPCODE.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;

            #endregion
        }

        private void txtEQPCODE_EditValueChanged(object sender, EventArgs e)
        {
            var o = txtEQPCODE.Properties.GetRowByKeyValue(txtEQPCODE.EditValue);
            if (o is DataRowView)
            {
                DataRowView RowView = o as DataRowView;
                txtEQPNAME.Text = RowView.Row["设备名称"].ToString();
            }
        }

        //计算比例不再与工序绑定
        //private void txtOPCODE_EditValueChanged(object sender, EventArgs e)
        //{
        //    var o = txtOPCODE.Properties.GetRowByKeyValue(txtOPCODE.EditValue);
        //    if (o is DataRowView)
        //    {
        //        DataRowView RowView = o as DataRowView;
        //        txtOPCODE.Text = RowView.Row["工序代码"].ToString();
        //        txtOPDESC.Text = RowView.Row["工序"].ToString();
        //        string calcType = RowView.Row["工序属性"].ToString();
        //        calcType = string.IsNullOrEmpty(calcType) ? "A" : calcType;
        //        DataTable dt = ICSOPBLL.SearchDataByEnumValue(AppConfig.AppConnectString, "00023", calcType);
        //        if (dt != null && dt.Rows.Count > 0)
        //        {
        //            txtCalc.Text = dt.Rows[0]["EnumText"].ToString();
        //            decimal D;
        //            if (Decimal.TryParse(txtCalc.Text, out D))
        //            {
        //                throw new Exception("工序:" + txtOPCODE.Text + "对应的工序属性'" + calcType + "'维护了错误的值'" + txtCalc.Text + "'");
        //            }
        //        }
        //        else
        //        {
        //            throw new Exception("工序:" + txtOPCODE.Text + "对应的工序属性'" + calcType + "'未维护");
        //        }
        //    }
        //}

        private void cboTiaojiBaseTime_SelectedIndexChanged(object sender, EventArgs e)
        {
            ComboBoxEdit cbo = sender as ComboBoxEdit;
            if (cbo.SelectedIndex == -1)
            {
                return;
            }
            try
            {
                decimal baseTime = Convert.ToDecimal(cbo.SelectedItem.ToString());
                decimal rate = 0;
                decimal stime = Convert.ToDecimal(txtJiagongTime.Text);
                if (cboTiaojiPRT.SelectedIndex == -1)
                {
                    rate = 0;
                }
                else
                {
                    rate = Convert.ToDecimal(cboTiaojiPRT.SelectedItem.ToString());
                }
                decimal res = baseTime + stime * rate;
                txtTiaojiTime.Text = res.ToString();

            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
            }
        }

        private void cboTiaojiPRT_SelectedIndexChanged(object sender, EventArgs e)
        {
            ComboBoxEdit cbo = sender as ComboBoxEdit;
            if (cbo.SelectedIndex == -1)
            {
                return;
            }
            try
            {
                decimal baseTime = 0;
                if (cboTiaojiBaseTime.SelectedIndex == -1)
                {
                    baseTime = 0;
                }
                else
                {
                    baseTime = Convert.ToDecimal(cboTiaojiBaseTime.SelectedItem.ToString());
                }
                decimal rate = rate = Convert.ToDecimal(cbo.SelectedItem.ToString());
                decimal stime = Convert.ToDecimal(txtJiagongTime.Text);

                decimal res = baseTime + stime * rate;
                txtTiaojiTime.Text = res.ToString();
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
            }
        }

        private void cboJianyanPRT_SelectedIndexChanged(object sender, EventArgs e)
        {
            ComboBoxEdit cbo = sender as ComboBoxEdit;
            if (cbo.SelectedIndex == -1)
            {
                return;
            }
            try
            {
                decimal rate = Convert.ToDecimal(cbo.SelectedItem.ToString());
                decimal stime = Convert.ToDecimal(txtJiagongTime.Text);
                decimal res = stime * rate;
                txtJianyanTime.Text = res.ToString();
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
            }
        }

        private void txtTIME_EditValueChanged(object sender, EventArgs e)
        {
            TextEdit te = sender as TextEdit;
            try
            {
                decimal d = Convert.ToDecimal(te.Text);
                if (d < 0)
                {
                    throw new Exception("值不可小于 0");
                }
                cboTiaojiBaseTime_SelectedIndexChanged(cboTiaojiBaseTime, null);
                cboTiaojiPRT_SelectedIndexChanged(cboTiaojiPRT, null);
                cboJianyanPRT_SelectedIndexChanged(cboJianyanPRT, null);
            }
            catch (Exception ex)
            {
                te.Text = "0";
                ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
            }
        }

        private void txtOPCODE_EditValueChanged(object sender, EventArgs e)
        {
            var o = txtOPCODE.Properties.GetRowByKeyValue(txtOPCODE.EditValue);
            if (o is DataRowView)
            {
                DataRowView RowView = o as DataRowView;
                txtOPDESC.Text = RowView.Row["工序"].ToString();
                chkIsWW.Checked = RowView.Row["工序属性"].ToString() == "委外";
            }
        }


        private void lookupOPLVL_EditValueChanged(object sender, EventArgs e)
        {
            var o = lookupOPLVL.Properties.GetRowByKeyValue(lookupOPLVL.EditValue);
            if (o is DataRowView)
            {
                DataRowView RowView = o as DataRowView;
                txtOPLVLDesc.Text = RowView.Row["说明"].ToString();
            }
        }

        private void cboEQPSetting_SelectedIndexChanged(object sender, EventArgs e)
        {
            tabControl1.SelectedIndex = cboEQPSetting.SelectedIndex;
            if (first)
            {
                return;
            }
            txtROUTEMEMO.Text = "";
            txtOPCODE.Text = "";
            txtOPDESC.Text = "";
            lookupClass.Text = lookupAxis.Text = lookupAccuracy.Text = lookupHandles.Text = lookupToolMagazine.Text = "";
            txtJiagongTime.Text = txtJiazhuangTime.Text = "0";
            if (cboEQPSetting.SelectedIndex == 1)
            {
                cboTiaojiPRT.SelectedIndex = cboTiaojiBaseTime.SelectedIndex = cboJianyanPRT.SelectedIndex = -1;
                txtJiagongTime.Text = txtJiazhuangTime.Text = txtJianyanTime.Text = txtTiaojiTime.Text = "0";
                lookupMachinableProfiles.Text = "";
            }
            lookupOPLVL.Text = "";
            chkIsWW.Checked = false;
            cboIsRef.Checked = true;

        }

        private void txtEQPCODE_EditValueChanged_1(object sender, EventArgs e)
        {
            if (txtEQPCODE.EditValue == null)
            {
                return;
            }
            var o = txtEQPCODE.Properties.GetRowByKeyValue(txtEQPCODE.EditValue);
            if (o is DataRowView)
            {
                DataRowView RowView = o as DataRowView;
                txtEQPNAME.Text = RowView.Row["设备名称"].ToString();
            }
        }

        private void txtROUTECODE_EditValueChanged(object sender, EventArgs e)
        {
            var o = txtROUTECODE.Properties.GetRowByKeyValue(txtROUTECODE.EditValue);
            if (o is DataRowView)
            {
                DataRowView RowView = o as DataRowView;
                txtRouteName.Text = RowView.Row["工艺名称"].ToString();

                #region 工序代码
                string sql = @"
SELECT DISTINCT [工序代码],[工序],次序,[工序属性] FROM (
	select distinct 
		a.OPCODE as [工序代码],
		b.OPDESC as [工序] ,
		a.OPSEQ AS 次序,
		A.OPAttr AS [工序属性]--CASE WHEN b.EATTRIBUTE1='1' THEN '委外' ELSE '自制' END [工序属性]
	from dbo.ICSITEMROUTE2OPLot a
	left join ICSOP b on a.OPCODE=b.OPCODE AND a.WorkPoint=b.WorkPoint
	WHERE a.ITEMCODE='{0}' and a.ROUTECODE='{1}' AND a.WorkPoint='{2}'
	UNION ALL
	select distinct 
		a.OPCODE as [工序代码],
		b.OPDESC as [工序] ,
		a.OPSEQ AS 次序,
		A.OPAttr AS [工序属性]--CASE WHEN b.EATTRIBUTE1='1' THEN '委外' ELSE '自制' END [工序属性]
	from ICSITEMROUTE2OP a
	left join ICSOP b on a.OPCODE=b.OPCODE AND a.WorkPoint=b.WorkPoint
	WHERE a.ITEMCODE='{0}' and a.ROUTECODE='{1}' AND a.WorkPoint='{2}'
)T ORDER BY T.次序 ASC
";
                sql = string.Format(sql, txtItemCode.Text, txtROUTECODE.Text, AppConfig.WorkPointCode);
                DataTable data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
                //                 if (data == null || data.Rows.Count == 0)
                //                 {
                //                     sql2 = @"select distinct 
                //            a.OPCODE as [工序代码],
                //            c.OPDESC as [工序] 
                //            from ICSITEMROUTE2OP a
                //            left join ICSINVENTORY b on a.ITEMCODE=b.INVCODE
                //            left join ICSOP c on a.OPCODE=c.OPCODE
                //where b.INVCODE='" + txtItemCode.Text + "' and 1=1";
                //                     data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql2).Tables[0];
                //                 }
                txtOPCODE.Properties.ValueMember = "工序代码";
                txtOPCODE.Properties.DisplayMember = "工序代码";

                txtOPCODE.Properties.DataSource = data;
                txtOPCODE.Properties.NullText = "";//空时的值    
                txtOPCODE.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
                txtOPCODE.Properties.ValidateOnEnterKey = true;//回车确认  
                txtOPCODE.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
                txtOPCODE.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 
                //自适应宽度
                //txtOPCODE.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
                #endregion
            }
        }

        private void chkIsWW_CheckedChanged(object sender, EventArgs e)
        {
            txtWWTIME.Visible = LBL_WWU.Visible = LBL_WWTIME.Visible = chkIsWW.Checked;
        }

        private void txtpp1_Properties_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            if (e.Button.Index == 1) {
                txtpp1.Text = "";
            }
        }

        private void txtpp2_Properties_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            if (e.Button.Index == 1)
            {
                txtpp2.Text = "";
            }
        }

        private void txtpp3_Properties_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            if (e.Button.Index == 1)
            {
                txtpp3.Text = "";
            }
        }

        private void txtcxjd_EditValueChanged(object sender, EventArgs e)
        {

        }




        //private void txtSTIME_EditValueChanged(object sender, EventArgs e)
        //{
        //    decimal calcJY = 0;
        //    string x = txtCalc.Text.TrimEnd('%');
        //    try
        //    {
        //         calcJY = Decimal.Parse(x);
        //    }
        //    catch (Exception)
        //    {
        //        throw new Exception("工序:" + txtOPCODE.Text + "对应的工序属性维护了错误的值'" + txtCalc.Text + "'");
        //    }
        //    txtJianyanTime.Text = (Convert.ToDecimal(txtSTIME.Text) * calcJY * 0.01m).ToString();
        //}








    }
}