XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgIntegrationQuery/基础信息维护/frmOperateRule.cs

using System;
using System.Collections.Generic;    
using System.ComponentModel;
using System.IO;
using System.Diagnostics;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using System.Collections;
using Core.Mes.Client.Common;

namespace Core.LgMes.Client.LgIntegrationQuery
{
    public partial class frmOperateRule : Core.Mes.Client.Common.frmStyleBase
    {
        OpenFileDialog Ofd = new OpenFileDialog();

        string type = "";

        public frmOperateRule()
        {
            InitializeComponent();
        }
        private string directoryPath = "C:\\";//质保书临时存放
        string strErr = "";
        private void frmOperateRule_Load(object sender, EventArgs e)
        {
            type = this.CustomInfo.ToString();
            ultraComboEditor1.Visible = true;
            label7.Visible = true;
            if (type.Equals("MESSAGE")) 
            {
                ultraComboEditor1.Visible = false;
                label7.Visible = false;
                this.ulGridMain.DisplayLayout.Bands[0].Columns["DOCTYPE"].Hidden = true;
            }
            this.ckbGX.Checked = true;
            Init();
            doQuery();
            SteelBind();
            
            /*try
            {
                InitCombox();
            }
            catch
            { }*/
        }

        void Init()
        {

            ArrayList arry = new ArrayList();
            arry.Add("GetProcessInfo1.Query");

            CommonClientToServer cctos = new CommonClientToServer();
            cctos.ob = this.ob;
            DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                        "doSimpleQuery", arry, out strErr);

            if (strErr == "" && ds.Tables[0].Rows.Count > 0)
            {
                urlCb_devNo.Items.Clear();
                Core.Mes.Client.Common.Globals.FillUltraComboItems(urlCb_devNo, ds);
                this.FillUltraComboItems(urlCb_BM,ds);
            }
            else
                MessageBox.Show("初使化失败!原因:" + strErr, "提示");


            ArrayList arry1 = new ArrayList();
            arry1.Add("GetProcessInfo2.Query");

            CommonClientToServer cctos1 = new CommonClientToServer();
            cctos1.ob = this.ob;
            DataSet ds1 = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                        "doSimpleQuery", arry1, out strErr);

            if (strErr == "" && ds.Tables[0].Rows.Count > 0)
            {
                ultraComboEditor1.Items.Clear();
                Core.Mes.Client.Common.Globals.FillUltraComboItems(ultraComboEditor1, ds1);
            }
            else
                MessageBox.Show("初使化失败!原因:" + strErr, "提示");

            try
            {
                Core.Mes.Client.Common.UltraGridMgt.SetGridRowFilter(ref this.ulGridMain, true);
            }
            catch
            { }
        }

        void SteelBind()
        {
            string strErr = "";
            //全部牌号
            ArrayList arrySteel = new ArrayList();
            arrySteel.Add("GetZLSteel.Query");

            CommonClientToServer cctos = new CommonClientToServer();
            cctos.ob = this.ob;
            DataSet dsSteel = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                        "doSimpleQuery", arrySteel, out strErr);
            //DataSet dsSteel = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("LGZL", "Core.XgMes.Server.Zlgl.Lg.CraftStandard", "getSteel", new object[] { }, out err);
            if (strErr == "")
            {
                Core.Mes.Client.Common.Globals.FillUltraComboItems(ulteSteel, dsSteel);

            }
        }

        void doRefresh()
        {
            try
            {
                this.txt_DocNo.Clear();
                this.txt_RuName.Clear();
                this.txt_RuNo.Clear();
                this.txt_RuScript.Clear();
                ulteSteel.Text = ulteSteelCode.Text = "";
                this.urlCb_devNo.Text = "";

                ArrayList arry = new ArrayList();
                arry.Add("RefreshData.Query");

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);

                dataSet1.Clear();

                try
                {
                    SetScmOperateRuleDs();
                }
                catch
                { }

                if (strErr == "" && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow Dr in ds.Tables[0].Rows)
                    {
                        DataRow dr1 = dataSet1.Tables[0].NewRow();
                        dr1["RULEID"] = Dr["RULEID"].ToString();
                        dr1["RULENAME"] = Dr["RULENAME"].ToString();
                        dr1["DESCRIPTION"] = Dr["DESCRIPTION"].ToString();
                        dr1["DEVICENO"] = Dr["DEVICENO"].ToString();
                        dr1["STEELCODE"] = Dr["STEELCODE"].ToString();
                        dr1["INPUTTIME"] = Dr["INPUTTIME"].ToString();
                        dr1["POSITTION"] = Dr["POSITTION"].ToString();
                        dr1["RECORDER"] = Dr["RECORDER"].ToString();
                        dr1["DESCRIPTIONNAME"] = Dr["DESCRIPTIONNAME"].ToString();
                        if (!this.isCorrectRuleId(Dr["RULEID"].ToString()))
                            continue;
                        dataSet1.Tables[0].Rows.Add(dr1);
                    }
                }
                //if (strErr == "")
                //    ulGridMain.DataSource = ds;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private byte[] FileConvertByte(string filePath)
        {
            byte[] bytContent = null;
            System.IO.FileStream fs = null;
            System.IO.BinaryReader br = null;
            try
            {
                fs = new FileStream(filePath, System.IO.FileMode.Open);
                br = new BinaryReader(fs);
                bytContent = br.ReadBytes((Int32)fs.Length);
            }
            catch
            {
                fs.Close();
                fs.Dispose();

            }
            return bytContent;
        }

        private void ByteConvertFile(string filePath, byte[] data)
        {
            FileStream fs;
            if (System.IO.File.Exists(filePath))
            {
                fs = new FileStream(filePath, FileMode.Truncate);
            }
            else
            {
                fs = new FileStream(filePath, FileMode.CreateNew);
            }
            BinaryWriter br = new BinaryWriter(fs);
            br.Write(data, 0, data.Length);
            br.Close();
            fs.Close();
        }


        void doAdd()
        {
            try
            {
                string filePathName = this.txt_DocNo.Text.ToString();
                if (!File.Exists(filePathName))
                {
                    MessageBox.Show("文件不存在");
                    return;
                }
                if (string.IsNullOrEmpty(txt_RuNo.Text.Trim())) 
                {
                    MessageBox.Show("请输入文件编号");
                    return;
                }
                //if (ulteSteelCode.Text == "")
                //{
                //    MessageBox.Show(this, "请选择牌号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                //    ulteSteel.Focus();
                //    return;
                //}

                //if (urlCb_devNo.SelectedIndex == -1)
                //{
                //    MessageBox.Show(this, "工序输入错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                //    urlCb_devNo.Focus();
                //    return;
                //}

                byte[] sByte;

                string strSqlID = "OperaterRule.add";
                object[] sArgs = new object[10];


                sArgs[0] = txt_RuNo.Text.ToString();

                sArgs[1] = txt_RuName.Text.ToString();
                sArgs[2] = txt_RuScript.Text.ToString();
                try
                {
                    sArgs[3] = (urlCb_devNo.Text.Trim() != null) ? urlCb_devNo.Text.ToString() : "";
                }
                catch { }

                sArgs[4] = ulteSteel.Text;
                sArgs[5] = this.UserInfo.GetUserName();

                //byte[] bytes = File.ReadAllBytes(txt_DocNo.Text.ToString());
                //File.WriteAllBytes("c:\\123.txt", bytes);
                //StreamReader reader = new StreamReader(txt_DocNo.Text.ToString(), true);

                //string filePath = this.txt_DocNo.Text.ToString();
                //byte[] sByte = FileConvertByte(filePath);
                //ByteConvertFile("c:\\" + txt_RuScript.Text + ".doc", sByte);

                using (FileStream fsTream = new FileStream(txt_DocNo.Text.ToString(), FileMode.Open, FileAccess.Read))
                {
                    if (fsTream.Length > 0)
                    {
                        sByte = new byte[fsTream.Length];
                        fsTream.Read(sByte, 0, sByte.Length);
                        fsTream.Close();
                    }
                    else
                    {
                        sByte = new byte[1];
                        sByte[0] = 32;
                    }
                }
                sArgs[6] = sByte;
                //sArgs[7] = Ofd.SafeFileName;
                sArgs[7] = Ofd.FileName.Substring(Ofd.FileName.LastIndexOf(@"\") + 1);
                sArgs[8] = ultraComboEditor1.Value == null ? "" : ultraComboEditor1.SelectedItem.ToString();
                sArgs[9] = type;
                Hashtable hashtb = new Hashtable();
                hashtb.Add("I1", sArgs[0]);
                hashtb.Add("I2", sArgs[1]);
                hashtb.Add("I3", sArgs[2]);
                hashtb.Add("I4", sArgs[3]);
                hashtb.Add("I5", sArgs[4]);
                hashtb.Add("I6", sArgs[5]);
                hashtb.Add("I7", sArgs[7]);
                //hashtb.Add("I7", sArgs[6]);
                hashtb.Add("I8",sArgs[8]);
                hashtb.Add("I9", sArgs[9]);

                hashtb.Add("O1", "");
                hashtb.Add("O2", "");


                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;
                string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.lgIntegrationQuery.PerformanceLog",
                                                    "BaseDataManage", strSqlID, hashtb, out strErr);



                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.lgIntegrationQuery.PerformanceLog";
                ccp.MethodName = "UpdateBolob";
                ccp.ServerParams = new object[] { sByte, txt_RuNo.Text };
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                //ArrayList all = new ArrayList();
                //all.Add(sByte);
                //all.Add(txt_RuNo.Text);

                //ccTs.NoQueryFunctions("Core.LgMes.Server.lgIntegrationQuery.PerformanceLog", "UpdateBolob", all, out strErr);
                if (strErr == "")
                {
                    //UpdateContextType();
                    doQuery();
                    activeRow(sArgs[0].ToString());

                   
                }
                else
                {
                    MessageBox.Show(strErr);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        void doEdit()
        {
            try
            {
                string filePathName = this.txt_DocNo.Text.ToString();
                string rr = System.AppDomain.CurrentDomain.BaseDirectory;
                if (!File.Exists(filePathName))
                {
                    MessageBox.Show("文件不存在");
                    return;
                }

                if (ulteSteelCode.Text == "")
                {
                    MessageBox.Show(this, "请选择牌号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ulteSteel.Focus();
                    return;
                }

                if (urlCb_devNo.SelectedIndex == -1)
                {
                    MessageBox.Show(this, "工序输入错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    urlCb_devNo.Focus();
                    return;
                }

                byte[] sByte;

                string strSqlID = "OperaterRule.Edit";
                object[] sArgs = new object[8];
                sArgs[0] = txt_RuNo.Text.ToString();
                sArgs[1] = txt_RuName.Text.ToString();
                sArgs[2] = txt_RuScript.Text.ToString();
                //sArgs[3] = "";

                sArgs[3] = (urlCb_devNo.Text.Trim() != null) ? urlCb_devNo.Text.ToString() : "";
                sArgs[4] = ulteSteelCode.Text;
                sArgs[5] = this.UserInfo.GetUserName();
                using (FileStream fsTream = new FileStream(txt_DocNo.Text.ToString(), FileMode.Open, FileAccess.Read))
                {
                    if (fsTream.Length > 0)
                    {
                        sByte = new byte[fsTream.Length];
                        fsTream.Read(sByte, 0, sByte.Length);
                        fsTream.Close();
                    }
                    else
                    {
                        sByte = new byte[1];
                        sByte[0] = 32;
                    }
                }
                sArgs[6] = sByte;
                sArgs[7] = txt_DocNo.Text;

                string msg = "";

                Hashtable hashtb = new Hashtable();
                hashtb.Add("I1", sArgs[0]);
                hashtb.Add("I2", sArgs[1]);
                hashtb.Add("I3", sArgs[2]);
                hashtb.Add("I4", sArgs[3]);
                hashtb.Add("I5", sArgs[4]);
                hashtb.Add("I6", sArgs[5]);
                hashtb.Add("I7", sArgs[7]);

                hashtb.Add("O1", "");
                hashtb.Add("O2", "");

                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;
                string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.lgblobIntegrationQuery.PerformanceLog",
                                                    "BaseDataManage", strSqlID, hashtb, out strErr);



                if (strErr == "")
                {
                    doQuery();
                    activeRow(sArgs[0].ToString());
                    UpdateContextType();
                }
                else
                    MessageBox.Show(strErr);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        void doDelete()
        {
            try
            {
                if (ulGridMain.ActiveRow == null)
                    return;

                if (MessageBox.Show(this, "是否删除本记录？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
                    return;


                string strSqlID = "OperaterRule.Del";
                string[] sArgs = new string[1];
                string rr = "";
                sArgs[0] = this.ulGridMain.ActiveRow.Cells["RULEID"].Value.ToString();

                Hashtable hashtb = new Hashtable();
                hashtb.Add("I1", sArgs[0]);

                hashtb.Add("O1", "");
                hashtb.Add("O2", "");

                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;
                string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.lgIntegrationQuery.PerformanceLog",
                                                    "BaseDataManage", strSqlID, hashtb, out strErr);
                if (strErr == "")
                {
                    doQuery();
                }
                else
                    MessageBox.Show(strErr);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //打开文件
        private void ulGridMain_DoubleClickCell(object sender, Infragistics.Win.UltraWinGrid.DoubleClickCellEventArgs e)
        {
            doDownLoad();
        }

        void doDownLoad()
        {
            try
            {
                if (ulGridMain.ActiveRow == null)
                    return;

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.lgIntegrationQuery.PerformanceLog";
                ccp.MethodName = "downLoadFile";
                ccp.ServerParams = new object[] { ulGridMain.ActiveRow.Cells["RULEID"].Text };
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                byte[] sBytes = (byte[])ccp.ReturnObject;

                if (strErr == "")
                {
                        SaveFileDialog sFile = new SaveFileDialog();
                        sFile.Title = "操作规程文件保存";
                        sFile.AddExtension = true;
                        sFile.CheckPathExists = true;
                        sFile.CreatePrompt = true;
                        sFile.FileName = ulGridMain.ActiveRow.Cells["DESCRIPTIONNAME"].Text;
                        //sFile.FileName = ds.Tables[0].Rows[0]["DESCRIPTIONNAME"].ToString();
                        sFile.Filter = "Word文件(*.doc)|*.doc";
                        sFile.DefaultExt = ".doc";

                        System.DateTime dt = System.DateTime.Now;
                        string TimeNow = string.Format("{0:yyyyMMddHHmmssffff}", dt);

                        string sFile1 = "", strTemplateName="";
                        //strTemplateName= Application.StartupPath + "\\Report\\" + strTemplateName + ".xls";

                        if (ulGridMain.ActiveRow.Cells["DESCRIPTIONNAME"].Text.Contains(".xls"))
                        {
                            sFile1 = Application.StartupPath + "\\Report\\" + ulGridMain.ActiveRow.Cells["DESCRIPTION"].Text + ".xls"; 
                        }
                        else if (ulGridMain.ActiveRow.Cells["DESCRIPTIONNAME"].Text.Contains(".pdf"))
                        {
                            sFile1 = Application.StartupPath + "\\Report\\" + ulGridMain.ActiveRow.Cells["DESCRIPTION"].Text + ".pdf";
                        }
                        else if (ulGridMain.ActiveRow.Cells["DESCRIPTIONNAME"].Text.Contains(".et"))
                        {
                            sFile1 = Application.StartupPath + "\\Report\\" + ulGridMain.ActiveRow.Cells["DESCRIPTION"].Text + ".et";
                        }
                        else if (ulGridMain.ActiveRow.Cells["DESCRIPTIONNAME"].Text.Contains(".wps"))
                        {
                            sFile1 = Application.StartupPath + "\\Report\\" + ulGridMain.ActiveRow.Cells["DESCRIPTION"].Text + ".wps";
                        }
                        else
                            sFile1 = Application.StartupPath + "\\Report\\" + ulGridMain.ActiveRow.Cells["DESCRIPTION"].Text + ".doc";

                        if (!File.Exists(strTemplateName))
                        {
                            System.IO.Directory.CreateDirectory(Application.StartupPath + "\\Report\\");
                        }
                        FileStream fs = new FileStream(sFile1, FileMode.OpenOrCreate, FileAccess.Write);
                            fs.Write(sBytes, 0, sBytes.Length);
                            fs.Close();
                            ProcessStartInfo p = new ProcessStartInfo(sFile1);
                            p.WorkingDirectory = Path.GetDirectoryName(sFile1);
                            Process.Start(p);
                }
                else
                    MessageBox.Show(strErr, "提示");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        void activeRow(string strRuID)
        {
            try
            {
                for (int i = 0; i < ulGridMain.Rows.Count; i++)
                {
                    if (ulGridMain.Rows[i].Cells["RULEID"].Text == strRuID)
                    {
                        ulGridMain.Rows[i].Activated = true;
                        ulGridMain.Rows[i].Selected = true;
                        break;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <summary>根据条件查询信息
        /// 根据条件查询信息
        /// </summary>
        private void doQuery()
        {
       
            string strPostion = "";
            string description = "";
            this.txt_DocNo.Clear();
            this.txt_RuName.Clear();
            this.txt_RuNo.Clear();
            this.txt_RuScript.Clear();
            ulteSteel.Text = ulteSteelCode.Text = "";
            this.urlCb_devNo.Text = "";

            if (ckbGX.Checked )
            {
                strPostion = Convert.ToString(urlCb_BM.Text.Trim());
            }
            if (ckbGCMS.Checked)
            {
                description = Convert.ToString(textBox1.Text.Trim());
            }
            /*if (strPostion == "" && description == "")
            {
               this.doQuery();
               return;
            }*/
            DataSet ds = new DataSet();
            ArrayList arry = new ArrayList();
            if (strPostion != "" && description == "")
            {
                arry.Add("GetGywjByPosittion.Query");
                arry.Add("%" + strPostion + "%");
                arry.Add(type);
                //arry.Add(strPostion);

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);
            }
            if (strPostion == "" && description != "")
            {
                arry.Add("GetGywjByPosittion2.Query");
                arry.Add("%" + description + "%");
                arry.Add(type);
                //arry.Add(strPostion);

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);
            }
            if (strPostion != "" && description != "")
            {
                arry.Add("GetGywjByPosittion3.Query");
                arry.Add("%" + strPostion + "%");
                arry.Add("%" + description + "%");
                arry.Add(type);
                //arry.Add(strPostion);

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);
            }

            if (strPostion == "" && description == "")
            {
                arry.Add("GetGywjByPosittion4.Query");
                arry.Add(type);
                //arry.Add(strPostion);

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);
            }
            
            dataSet1.Clear();

            if (strErr == "" && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow Dr in ds.Tables[0].Rows)
                {
                    DataRow dr1 = dataSet1.Tables[0].NewRow();
                    dr1["RULEID"] = Dr["RULEID"].ToString();
                    dr1["RULENAME"] = Dr["RULENAME"].ToString();
                    dr1["DESCRIPTION"] = Dr["DESCRIPTION"].ToString();
                    dr1["DEVICENO"] = Dr["DEVICENO"].ToString();
                    dr1["STEELCODE"] = Dr["STEELCODE"].ToString();
                    dr1["INPUTTIME"] = Dr["INPUTTIME"].ToString();
                    dr1["POSITTION"] = Dr["POSITTION"].ToString();
                    dr1["RECORDER"] = Dr["RECORDER"].ToString();
                    dr1["DESCRIPTIONNAME"] = Dr["DESCRIPTIONNAME"].ToString();
                    dr1["DOCTYPE"] = Dr["DOCTYPE"].ToString();
                    dataSet1.Tables[0].Rows.Add(dr1);
                }
            }
            //if (strErr == "")
            //    ulGridMain.DataSource = ds;
        
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQuery();
                    break;
                case "Update":
                    doEdit();
                    break;
                case "Add":
                    doAdd();
                    break;
                case "Delete":
                    doDelete();
                    break;
                case "Exit":
                    Close();
                    break;
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                Ofd.Title = "打开文件";
                Ofd.Filter = "文件 (*.doc;*.xls;*.rtf;*.htm;*.txt;*.wps;*.pdf;)|*.doc;*.xls;*.rtf;*.htm;*.txt;*.wps;*.pdf;";

                if (type.Equals("MESSAGE")) 
                {
                    ArrayList arry = new ArrayList();
                    arry.Add("GetMaxRULEID.Query");

                    CommonClientToServer cctos = new CommonClientToServer();
                    cctos.ob = this.ob;
                    DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                                "doSimpleQuery", arry, out strErr);
                    this.txt_RuNo.Text = ds.Tables[0].Rows[0][0].ToString();
                }
                else
                    this.txt_RuNo.Text = "";

                if (Ofd.ShowDialog() == DialogResult.OK)
                {
                    //this.txt_DocNo.Text = Ofd.FileNames ;
                    this.txt_DocNo.Text = Ofd.FileName;

                    char Flag = '.';
                    //string[] sArgs = Ofd.SafeFileName.Split(Flag);
                    string[] sArgs = Ofd.FileName.Substring(Ofd.FileName.LastIndexOf(@"\") + 1).Split(Flag);
                    txt_RuScript.Text = sArgs[0];
                    txt_RuName.Text = sArgs[0];
                }
            }
            catch { }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            if (ulGridMain.ActiveRow != null)
            {
                this.txt_RuNo.Text = ulGridMain.ActiveRow.Cells[0].Value.ToString();
                this.txt_RuName.Text = ulGridMain.ActiveRow.Cells[1].Value.ToString();
                this.txt_RuScript.Text = ulGridMain.ActiveRow.Cells[2].Value.ToString();
                this.txt_DocNo.Text = "";
                ulteSteelCode.Text = ulGridMain.ActiveRow.Cells["STEELCODE"].Value.ToString();
                ulteSteel.Text = ulGridMain.ActiveRow.Cells["STEELCODE"].Value.ToString();
                this.urlCb_devNo.Value = ulGridMain.ActiveRow.Cells["DEVICENO"].Value.ToString();
            }
        }

        private void ulteSteel_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {

        }

        private void ckbGX_CheckedChanged(object sender, EventArgs e)
        {
            urlCb_BM.Enabled = ckbGX.Checked;
            this.checkBox1.Checked = !this.ckbGX.Checked;
            //doQuery();
        }


        private void InitCombox()
        {
            this.ultraComboEditor1.DataSource = this.GetDocType();
            this.ultraComboEditor1.DisplayMember = "name_";
            this.ultraComboEditor1.ValueMember = "id_";
            this.ultraComboEditor1.SelectedIndex = 0;
            
        }

        private DataTable GetDocType()
        {
            DataTable dt = new DataTable();
            DataColumn dcId = new DataColumn("id_",System.Type.GetType("System.String"));
            DataColumn dcName = new DataColumn("name_", System.Type.GetType("System.String"));
            dt.Columns.AddRange(new DataColumn[] { dcId, dcName });
            dt.Rows.Add(new object[] { "0", "工艺文件" });
            dt.Rows.Add(new object[] { "1", "工艺考核通报" });
            return dt;
        }


        private void UpdateContextType()
        {
            try
            {
                ClientParamWithSqlConditionAndOpenBase param = new ClientParamWithSqlConditionAndOpenBase();
                string str = this.ultraComboEditor1.Value.ToString();
                object[] obj = new object[] { str, this.txt_RuNo.Text.ToString().Trim() };
                param.ob = this.ob;
                param.param = obj;
                Core.LgMes.Client.lgBll.LgScmOpeateRuleMgt.LgScmOpeateRuleMgt.UpdateScmOperateRuleContextType(param);
            }
            catch
            { 
            }
           
        }

        private Boolean isCorrectRuleId(string ruleId)
        {
            try
            {
                DataRow[] drs = this._ds.Tables[0].Select(string.Format("RULEID = '{0}'",ruleId));
                if (drs.Length == 0)
                    return true;
                if (this.checkBox1.Checked)
                {
                    return drs[0]["DOCTYPE"].ToString() == "1";
                }

                if (this.ckbGX.Checked)
                {
                    return drs[0]["DOCTYPE"].ToString() == "0";
                }

            }
            catch
            {
                
            }
            return true;
           
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            this.ckbGX.Checked = !this.checkBox1.Checked;
            this.ckbGCMS.Checked = !this.checkBox1.Checked;
        }

        private void SetScmOperateRuleDs()
        {
           this._ds = Core.LgMes.Client.lgBll.LgScmOpeateRuleMgt.LgScmOpeateRuleMgt.GetScmOperateRuleDs(new ClientParamWithSqlConditionAndOpenBase("",this.ob));
 
        }
        public  void FillUltraComboItems(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataSet dset)
        {
            if (dset.Tables.Count > 0 && dset.Tables[0].Columns.Count > 1)
            {
                for (int i = 0; i < dset.Tables[0].Rows.Count; i++)
                    
                    if (i == 0)
                     ulcme.Items.Add(null, null); 
                       
                    else
                    ulcme.Items.Add(dset.Tables[0].Rows[i][0].ToString(), dset.Tables[0].Rows[i][1].ToString());
            }
        }

        private DataSet _ds = null;

        private void ckbGCMS_CheckedChanged(object sender, EventArgs e)
        {
            textBox1.Enabled = ckbGCMS.Checked;
            //doQuery();
        }

    }
}