XinYu_LZMES_Client/.svn/pristine/23/23ee5103843a4a638dee44f7dae42cb017ed5011.svn-base

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 System.Collections;
using System.Text.RegularExpressions;//正则表达式所在空间
using Infragistics.Win.UltraWinGrid;
using Microsoft.Office.Interop.Excel;

namespace Core.LZMes.Client.UIB
{
    public partial class UIB100203 : FrmBase
    {
        public UIB100203()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Send":
                    this.DoSend();
                    break;
                case "Export":
                    this.DoExport();
                    break;
                case "OnFile":
                    this.DoOnFile();
                    break;
            }
        }

        string strLine = null;//产线
        string strArr = null;//地点
        string strWtbh = null;//委托编号
        string strQltyCD = null;//材质代码
        string strQltyCD2 = null;//二级编码，如拉力，冲击等
        string strQltyCD3 = null;//三级编码，如伸长率，屈服强度，抗拉强度等
        string strSendTP = null;//是否已发送

        int grid3ActiveRow = 0;//保存grid3（a,b,So等横向现实的grid）的当前活动行

        string strSmpNo = null;
        string strSmpCutLoc = null;
        string strSmpNoType = null;

        
        public void DoQuery()
        {
            try
            {
                
                if (this.comboBox1.Text.Trim() == "" || this.comboBox4.Text.Trim() == "")
                {
                    MessageBox.Show("请选择产线和实验地点","提示");
                    return;
                }
               
                OperateConditionRecode.WriteCondition("UIB100203_1", this.comboBox1.Text);
                OperateConditionRecode.WriteCondition("UIB100203_2", this.comboBox2.Text);
                OperateConditionRecode.WriteCondition("UIB100203_4", this.comboBox4.Text);
                this.dataSet1.Clear();
                ArrayList al = new ArrayList();
                //产线
                if (this.comboBox1.Text == "热轧")
                {
                    al.Add("UIB100203_HOST_01.SELECT");
                    strLine = "R";
                }
                else if (this.comboBox1.Text == "中厚板")
                {
                    al.Add("UIB100203_HOST_01.SELECT");
                    strLine = "Z";
                }
                else if (this.comboBox1.Text == "优特钢")
                {
                    al.Add("UIB100203_HOST_01.SELECT");
                    strLine = "Y";
                }
                else
                {
                    al.Add("UIB100203_LIAN_01.SELECT");
                    strLine = "L";
                }/*else if (this.comboBox1.Text == "连退")
                {
                    al.Add("UIB100203_LIAN_01.SELECT");
                    strLine = "L";
                }  */
                al.Add(strLine);
                //地点
                if (this.comboBox4.Text.Trim() == "力学")
                {
                    strArr = "LX";
                }
                else if (this.comboBox4.Text.Trim() == "金相")
                {
                    strArr = "JX";
                }
                else
                {
                    MessageBox.Show("请区分力学与金相" , "提示");
                    return;
                }
                al.Add(strArr);

                
                //是否已发送
                if (this.comboBox2.Text == "未发送")
                {
                    strSendTP = "0";
                    al.Add(strArr);
                    al.Add(strSendTP);
                }
                else if (this.comboBox2.Text == "已发送")
                {
                    strSendTP = "1";
                    al.Add(strArr);
                    al.Add(strSendTP);
                }
                else if (this.comboBox2.Text == "全部")
                {
                    al.Add("");
                    al.Add("");
                }
                else
                {
                    MessageBox.Show("请选择发送状态", "提示");
                    return;
                }
                

                //入库时间
                if (this.checkBox5.Checked)
                {
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") + "000000");
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") + "999999");
                }
                else
                {
                    al.Add("");
                    al.Add("");
                }
                //委托时间
                if (this.checkBox2.Checked)
                {
                    al.Add(this.ultraDateTimeEditor3.DateTime.ToString("yyyyMMdd") + "000000");
                    al.Add(this.ultraDateTimeEditor4.DateTime.ToString("yyyyMMdd") + "999999");
                }
                else
                {
                    al.Add("");
                    al.Add("");
                }

                //钢卷号
                if (this.checkBox1.Checked)
                {
                    al.Add(this.textBox1.Text.Trim());
                    al.Add(this.textBox2.Text.Trim() == "" ? this.textBox1.Text.Trim() : this.textBox2.Text.Trim());
                }
                else
                {
                    al.Add("");
                    al.Add("");
                }

                this.dataSet1.Tables[0].Clear();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { al };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                //发送、完成状态颜色显示，发送状态优先
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["SEND_STAT"].Text.Substring(0, 1) == "0")//是否已发送，未发送则蓝色
                    {
                        //ugr.RowSelectorAppearance.BackColor = Color.Blue;
                        ugr.Cells["SEND_STAT"].Appearance.BackColor = Color.Blue;
                    }
                    
                    if (ugr.Cells["WORK_STATS"].Text == "XX")//是否已完成，未完成则显示黄色
                    {
                        ugr.RowSelectorAppearance.BackColor = Color.Yellow;
                    }
                }
            }
            catch (Exception ex)
            {
            }
        }

        //发送数据到三期或冷轧
        public void DoSend()
        {
            try
            {
                

                string strSMPNO = null;
                string strSMPCUTLOC = null;
                string strSMPTNOTYPE = null;
                string strCoilNo = null;
                int SPLITNUM = 3;
                string splitStr = null;
                int coilNum = 0;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text == "True")
                    {
                        strSMPNO = strSMPNO + ugr.Cells["SMP_NO"].Text;
                        strSMPCUTLOC = strSMPCUTLOC + ugr.Cells["SMP_CUT_LOC"].Text;
                        strSMPTNOTYPE = strSMPTNOTYPE + ugr.Cells["SMP_NO_TYPE"].Text;

                        if (strCoilNo != null)
                        {
                            coilNum++;
                            if (coilNum % SPLITNUM == 0)
                            {
                                splitStr = "\n";
                            }
                            else
                            {
                                splitStr = ",";
                            }
                        }
                        strCoilNo = strCoilNo + splitStr + ugr.Cells["COIL_NO"].Text;
                    }
                   
                    //  this.ultraGrid5.Rows[colNum].Cells["QLTY_VAL"].Value = al[0].ToString();
                }
                if (strSMPNO == null) return;

                if (MessageBox.Show("确定发送以下钢卷：\n" + strCoilNo, "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;

                Hashtable ht = new Hashtable();
                ht.Add("i1" , strSMPNO);
                ht.Add("i2" , strSMPCUTLOC);
                ht.Add("i3" , strSMPTNOTYPE);
                ht.Add("i4" , strArr);
                ht.Add("i5" , this.UserInfo.GetUserName());
                ht.Add("o6" , "");
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHyComCallProc";
                ccp.MethodName = "doSimpleProc";
                ccp.ServerParams = new object[] { "UIB100203_COMM_02.CALL", ht };
                CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                //计算结果返回
                ArrayList al = rccp.ReturnObject as ArrayList;
                if (al[0] == null) { MessageBox.Show("发送异常!"); return; }
                if (al[0].ToString() == "YY")
                {
                    MessageBox.Show("发送成功!", "提示");
                }
                else if (al[0].ToString() == "XX")
                {
                    MessageBox.Show("部分钢卷发送失败!", "提示");
                }
                else
                {
                    MessageBox.Show("部分钢卷发送失败：" + al[0].ToString(), "提示");
                }
                this.DoQuery();
            }
            catch (Exception ex)
            {
            }
        }

        //归档
        public void DoOnFile()
        {
            try
            {
                if (MessageBox.Show("确定对【" + this.comboBox1.Text.ToString(), "】数据进行归档？", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;

                Hashtable ht = new Hashtable();
                ht.Add("i1", this.comboBox1.Text.ToString());
                ht.Add("i2", this.UserInfo.GetUserName());
                ht.Add("o3", "");

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHyComCallProc";
                ccp.MethodName = "doSimpleProc";
                ccp.ServerParams = new object[] { "UIB100203_COMM_05.CALL", ht };
                CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                ArrayList al = rccp.ReturnObject as ArrayList;
                if (al[0] == null) return;
                if (al[0].ToString() == "XX")
                {
                    MessageBox.Show("数据归档失败！" , "提示");
                    return;
                }
                MessageBox.Show("数据归档成功！" , "提示");

            }
            catch (Exception ex)
            {

            }
        }

        //导出
        public void DoExport()
        {
            if (this.comboBox3.Text == "")
            {
                MessageBox.Show("请选择导出类别" , "提示");
                return;
            }
            if (this.textBox5.Text.Trim() == "")
            {
                MessageBox.Show("请选择导出路径" , "提示");
                return;
            }

            string strCoil = null;
            string strWtbh = null;
            foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                if (ugr.Cells["CHK"].Text == "True")
                {
                    strCoil = strCoil + ugr.Cells["COIL_NO"].Text;
                    strWtbh = strWtbh + ugr.Cells["WEITO_NO"].Text;
                }
                //ugr.Update();
            }
            if (strCoil == null)
            {
                MessageBox.Show("没有选择需要导出的钢卷", "提示");
                return;
            }

            ApplicationClass ExcelApp = null;
            Microsoft.Office.Interop.Excel.Application excel = null;
            Microsoft.Office.Interop.Excel.Workbooks workbooks = null;
            Microsoft.Office.Interop.Excel._Workbook workbook = null;
            Microsoft.Office.Interop.Excel.Sheets sheets = null;
            Microsoft.Office.Interop.Excel.Worksheet sheet = null;

            try
            {
                ArrayList al = new ArrayList();
                string filename = null;
                if (this.comboBox3.Text == "拉力原始记录")
                {
                    
                    //查询出所需要导出卷的信息
                    this.dataSet3.Tables["lldc"].Clear();
                    al.Add("UIB100203_COMM_08.SELECT");
                    al.Add(strCoil);
                    al.Add(strWtbh);
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.JHY.JHYComQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet3.Tables["lldc"];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                    //导出
                    string strfile = System.Windows.Forms.Application.StartupPath + "\\HostLaLi.xls";//模板路径
                    ExcelApp = new ApplicationClass();
                    excel = new Microsoft.Office.Interop.Excel.Application();
                    workbooks = excel.Workbooks;
                    workbook = workbooks.Add(strfile);
                    sheets = workbook.Sheets;
                    sheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets[1];

                  

                    int startRow = 5;//模板数据填充从第五行开始
                    Range range = null;
                    int i = 0;
                    int j = 1;
                    for (i = 0; i < this.dataSet3.Tables["lldc"].Rows.Count; i++)
                    {
                        j = 1;
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["COIL_STEEL_NO"].ToString();//钢印号
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["SPEC_STL_GRD"].ToString();//牌号
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["COIL_NO"].ToString();//钢卷
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["COIL_THK"].ToString();//规格
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["LA"].ToString();//a
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["LB"].ToString();//b
                        j++;
                        j++;
                        j++;
                        j++;
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["FE"].ToString();//Fe
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["FM"].ToString();//Fm
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["LO"].ToString();//Lo
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["LU"].ToString();//Lu
                       // sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["ZJ"].ToString();//直径
                       // sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["CB"].ToString();//冷弯
                    }

                    //Range ra = sheet.get_Range(sheet.Cells[5, 1], sheet.Cells[5, 1]);
                    //ra.Select();

                    range = sheet.get_Range(sheet.Cells[startRow, 1], sheet.Cells[startRow+(i-1), j-1+3]);//(Range)sheet.Rows[6, 1];
                    range.Borders.LineStyle = 1;
                    range.NumberFormatLocal = "@";//设置单元格格式为文本    
                    range.RowHeight = 22.5;
                    //range.HorizontalAlignment = XlHAlign.xlHAlignLeft;//字体左靠

                  //  range.RowHeight = 24;
                    
                   // System.DateTime dt = System.DateTime.Now;
                   // string TimeNow = string.Format("{0:yyyyMMddHHmmssffff}", dt);
                    
                    workbook.Saved = true;
                    workbook.SaveCopyAs(this.textBox5.Text + "\\热轧拉力试验原始记录表"  + ".xls");
                    excel.DisplayAlerts = false;
                    excel.AlertBeforeOverwriting = false;
                   
                    workbooks.Close();
                    workbook = null;
                    excel.Quit();
                    excel = null;
                    ExcelApp.Quit();
                    ExcelApp = null;
                }
                else if (this.comboBox3.Text == "冲击原始记录")
                {
                    //查询出所需要导出卷的信息
                    this.dataSet3.Tables["cjdc"].Clear();
                    //产线
                    if (this.comboBox1.Text == "热轧")
                    {
                        al.Add("UIB100203_COMM_091.SELECT");
                    }
                    else
                    {
                        al.Add("UIB100203_COMM_092.SELECT");
                    }

                   // al.Add("UIB100203_COMM_091.SELECT");
                    al.Add(strCoil);
                    al.Add(strWtbh);
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.JHY.JHYComQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet3.Tables["cjdc"];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                    //导出
                    string strfile = System.Windows.Forms.Application.StartupPath + "\\HostChongJi.xls";//模板路径
                    ExcelApp = new ApplicationClass();
                    excel = new Microsoft.Office.Interop.Excel.Application();
                    workbooks = excel.Workbooks;
                    workbook = workbooks.Add(strfile);
                    sheets = workbook.Sheets;
                    sheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets[1];

                    int startRow = 5;//模板数据填充从第五行开始
                    Range range = null;
                    int i = 0;
                    int j = 1;
                    for (i = 0; i < this.dataSet3.Tables["cjdc"].Rows.Count; i++)
                    {
                        j = 1;
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["COIL_STEEL_NO"].ToString();//钢印号
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["SPEC_STL_GRD"].ToString();//牌号
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["COIL_NO"].ToString();//钢卷
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["COIL_THK"].ToString();//规格
                        //j++;//试样宽度
                        //j++;//试样方向
                        //j++;//温度
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["QLTY_SIZ"].ToString();//A1
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["QLTY_DIR"].ToString();//A2
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["QLTY_TEM"].ToString();//A3

                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["A1"].ToString();//A1
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["A2"].ToString();//A2
                        sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["cjdc"].Rows[i]["A3"].ToString();//A3
                        //sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["FM"].ToString();//Fm
                        //sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["LO"].ToString();//Lo
                        //sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["LU"].ToString();//Lu
                        //sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["ZJ"].ToString();//直径
                        //sheet.Cells[startRow + i, j++] = this.dataSet3.Tables["lldc"].Rows[i]["CB"].ToString();//冷弯
                    }

                    //设置样式
                    range = sheet.get_Range(sheet.Cells[startRow, 1], sheet.Cells[startRow + (i - 1), j - 1 + 1]);//(Range)sheet.Rows[6, 1];
                    range.Borders.LineStyle = 1;
                    range.NumberFormatLocal = "@";//设置单元格格式为文本    
                    range.RowHeight = 22.5;

                    workbook.Saved = true;
                    workbook.SaveCopyAs(this.textBox5.Text + "\\热轧冲击试验原始记录表" + ".xls");
                    excel.DisplayAlerts = false;
                    excel.AlertBeforeOverwriting = false;
                    workbooks.Close();
                    workbook = null;
                    excel.Quit();
                    excel = null;
                    ExcelApp.Quit();
                    ExcelApp = null;
                }
                else
                    return;
                MessageBox.Show("导出成功！" , "提示");
            }
            catch (Exception ex)
            {
                MessageBox.Show("导出失败！"+ex.ToString() , "提示");
            }
            finally
            {
                try
                {
                    if (workbooks != null)
                        workbooks.Close();
                    if (excel != null)
                        excel.Quit();
                    if (ExcelApp != null)
                        ExcelApp.Quit();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("error");
                }
                GC.Collect();
            }
        }

        //设置颜色
        //若为A，判断值是否合格
        public void SetColor(string flag , Infragistics.Win.UltraWinGrid.UltraGrid grid)
        {
            try
            {
                if (flag == "A")
                {
                    Decimal minValue = 0;
                    Decimal maxValue = 0;
                    Decimal qltyValue = 0;
                    foreach (UltraGridRow ugr in grid.Rows)
                    {
                        if (ugr.Cells["QLTY_VAL"].Text.Trim() == "")
                        {
                            ugr.RowSelectorAppearance.BackColor = Color.Yellow;
                            continue;
                        }
                        else if (ugr.Cells["QLTY_VAL"].Text.Trim() == "不合格")
                        {
                            ugr.RowSelectorAppearance.BackColor = Color.Red;
                            continue;
                        }
                        else if (ugr.Cells["QLTY_VAL"].Text.Trim() == "合格")
                        {
                            continue;
                        }
                        minValue = Convert.ToDecimal(ugr.Cells["QLTY_MIN"].Text == "" ? 0 : Convert.ToDecimal(ugr.Cells["QLTY_MIN"].Text));
                        maxValue = Convert.ToDecimal(ugr.Cells["QLTY_MAX"].Text == "" ? 9999 : Convert.ToDecimal(ugr.Cells["QLTY_MAX"].Text));
                        qltyValue = Convert.ToDecimal(ugr.Cells["QLTY_VAL"].Text.Trim());
                        if (qltyValue < minValue || qltyValue > maxValue)
                        {
                            ugr.RowSelectorAppearance.BackColor = Color.Red;                            
                        }

                    }
                }
            }
            catch (Exception ex)
            {
            }
        }

        //无计算公式，直接输入数据
        public void DoUpdate(string flag)
        {
            try
            {
                if (this.ultraGrid5.ActiveCell == null) return;

                
                if (this.ultraGrid5.ActiveCell.DataChanged == true)
                {
                    //同步更新到dataset3的对应的单元中
                    for (int i = 0; i < this.dataSet3.Tables["yincang"].Rows.Count; i++)
                    {
                        if (this.ultraGrid5.ActiveRow.Cells["QLTY_OPE_CD"].Text == this.dataSet3.Tables["yincang"].Rows[i]["QLTY_OPE_CD"].ToString())
                        {
                            this.dataSet3.Tables["yincang"].Rows[i]["QLTY_VAL"] = this.ultraGrid5.ActiveRow.Cells["QLTY_VAL"].Text;
//                            this.dataSet3.Tables["yincang"].
                           // MessageBox.Show(this.dataSet3.Tables["yincang"].Rows[i]["QLTY_VAL"].ToString());
                            this.dataSet3.Tables["yincang"].AcceptChanges();
                           // this.dataSet3.AcceptChanges();
                            break;
                        }
                    }
                    Hashtable ht = null;
                    CoreClientParam ccp = null;

                    ht = new Hashtable();
                    ht.Add("i1", this.ultraGrid3.ActiveRow.Cells["SMP_NO"].Text);
                    ht.Add("i2", this.ultraGrid3.ActiveRow.Cells["SMP_CUT_LOC"].Text);
                    ht.Add("i3", this.ultraGrid3.ActiveRow.Cells["SMP_NO_TYPE"].Text);
                    ht.Add("i4", this.strQltyCD2);
                    ht.Add("i5", this.ultraGrid5.ActiveRow.Cells["QLTY_OPE_CD"].Text);
                    ht.Add("i6", "");//计算公式
                    ht.Add("i7", this.ultraGrid5.ActiveRow.Cells["QLTY_DIS_LEN"].Text);//保留位数
                    ht.Add("i8", this.ultraGrid5.ActiveRow.Cells["CRCT_REG"].Text.ToUpper());//修约规则
                    ht.Add("i9", flag);//处理数据规则
                    ht.Add("i10", this.ultraGrid5.ActiveRow.Cells["QLTY_VAL"].Text);
                    ht.Add("i11", this.UserInfo.GetUserName());
                    ht.Add("o12","");

                    ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.JHY.JHyComCallProc";
                    ccp.MethodName = "doSimpleProc";
                    ccp.ServerParams = new object[] { "UIB100203_COMM_01.CALL", ht };
                    this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                    
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("系统异常，请与技术中心联系" , "提示");
            }
        }

        //按公式进行计算
        //colNum为需要计算的行
        public void DoCompVal(int colNum)
        {
            try
            {
                //判断该行是否存在，不存在则返回
                if (colNum >= this.ultraGrid5.Rows.Count) return;
                string strCompVal = this.ultraGrid5.Rows[colNum].Cells["COMP_CAL"].Text;//计算公式

                if (strCompVal == "") return;
                //若伸长率定标，则禁止计算
                if (this.ultraGrid5.Rows[colNum].Cells["QLTY_OPE_CD"].Text == "Lo" && this.ultraGrid5.Rows[colNum].Cells["EDIT_TP"].Text == "X")
                {
                    return;
                }

                for (int i = 0; i < this.dataSet3.Tables["yincang"].Rows.Count; i++)
                {
                    strCompVal = strCompVal.Replace(this.dataSet3.Tables["yincang"].Rows[i]["QLTY_OPE_CD"].ToString()//this.ultraGrid5.Rows[i].Cells["QLTY_OPE_CD"].Text
                                                    , this.dataSet3.Tables["yincang"].Rows[i]["QLTY_VAL"].ToString());//this.ultraGrid5.Rows[i].Cells["QLTY_VAL"].Text);
                }

                Regex r = new Regex(@"[A-Z,a-z]");
                Match m = r.Match(strCompVal);
                //判断公式的字符串是否已经替换完成，未替换完成，则不进行任何操作，直接返回
                if(m.Success)return;

                strCompVal = strCompVal.Replace("√", "SQRT").Replace("=","");//开根号处理
                Hashtable ht = new Hashtable();
                ht.Add("i1", this.ultraGrid3.ActiveRow.Cells["SMP_NO"].Text);
                ht.Add("i2", this.ultraGrid3.ActiveRow.Cells["SMP_CUT_LOC"].Text);
                ht.Add("i3", this.ultraGrid3.ActiveRow.Cells["SMP_NO_TYPE"].Text);
                ht.Add("i4", this.strQltyCD2);
                ht.Add("i5", this.ultraGrid5.Rows[colNum].Cells["QLTY_OPE_CD"].Text);
                ht.Add("i6", strCompVal);//计算公式
                ht.Add("i7", this.ultraGrid5.Rows[colNum].Cells["QLTY_DIS_LEN"].Text);//保留位数
                ht.Add("i8", this.ultraGrid5.Rows[colNum].Cells["CRCT_REG"].Text.ToUpper());//修约规则
                ht.Add("i9", "");//处理数据规则
                ht.Add("i10", "");
                ht.Add("i11",this.UserInfo.GetUserName());
                ht.Add("o12", "");

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHyComCallProc";
                ccp.MethodName = "doSimpleProc";
                ccp.ServerParams = new object[] { "UIB100203_COMM_01.CALL", ht };
                CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                //计算结果返回
                ArrayList al = rccp.ReturnObject as ArrayList;
                if (al[0] == null) return;
                if (al[0].ToString() == "XX") return;
                this.ultraGrid5.Rows[colNum].Cells["QLTY_VAL"].Value = al[0].ToString();
              //  this.ultraGrid3.ActiveRow.Cells[this.ultraGrid5.ActiveRow.Cells["QLTY_OPE_CD"].Text].Value = al[0].ToString();
                this.ultraGrid5.UpdateData();
                this.ultraGrid3.UpdateData();

                //同步更新到dataset3的对应的单元中
                for (int i = 0; i < this.dataSet3.Tables["yincang"].Rows.Count; i++)
                {
                  //  if (this.ultraGrid5.ActiveRow.Cells["QLTY_OPE_CD"].Text == this.dataSet3.Tables["yincang"].Rows[i]["QLTY_OPE_CD"].ToString())
                    if (this.ultraGrid5.Rows[colNum].Cells["QLTY_OPE_CD"].Text == this.dataSet3.Tables["yincang"].Rows[i]["QLTY_OPE_CD"].ToString())
                        //DefaultView
                    {
                        this.dataSet3.Tables["yincang"].Rows[i]["QLTY_VAL"] = this.ultraGrid5.Rows[colNum].Cells["QLTY_VAL"].Text;//this.ultraGrid5.ActiveRow.Cells["QLTY_VAL"].Text;
                       // MessageBox.Show(this.dataSet3.Tables["yincang"].Rows[i]["QLTY_VAL"].ToString());
                        this.dataSet3.Tables["yincang"].AcceptChanges();
                        break;
                    }
                }
            
            }
            catch (Exception ex)
            {
                MessageBox.Show("计算异常");
            }
        }

        private void UIB100203_Load(object sender, EventArgs e)
        {
            try
            {
                this.comboBox1.Text = OperateConditionRecode.ReadCondition("UIB100203_1");
                this.comboBox2.Text = OperateConditionRecode.ReadCondition("UIB100203_2");
                this.comboBox4.Text = OperateConditionRecode.ReadCondition("UIB100203_4");
                this.textBox5.Text = OperateConditionRecode.ReadCondition("UIB100203_PATH");

                this.comboBox3.SelectedIndex = 0;//导出

                //this.comboBox2.SelectedIndex = 2;
                ArrayList list = new ArrayList();
                //列名排序查询
             //   this.dataSet2.Tables[2].Clear();
                ArrayList al = new ArrayList();
                al.Add("UIB100203_01.INITSELECT");//页面初始化调用，用于编码的排序
                list.Add(al);
                al = new ArrayList();
                al.Add("UIB100203_02.INITSELECT");//材质代码与材质名称
                list.Add(al);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComQuery";
                ccp.MethodName = "doContQluery";
                ccp.ServerParams = new object[] { list };
                CoreClientParam ccpList = this.ExecuteQuery(ccp, CoreInvokeType.Internal);

                if (ccpList.ReturnInfo.Length == 0)
                {
                    ArrayList aList = ccpList.ReturnObject as ArrayList;
                    if (aList[0] != null)
                    {
                        this.dataSet2.Tables["paixu"].Clear();
                        System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[0] as System.Collections.ArrayList, this.dataSet2.Tables["paixu"]);
                        tab0.TableName = "paixu";
                        this.dataSet2.Tables["paixu"].Merge(tab0);
                    }

                    if (aList[1] != null)
                    {
                        this.dataSet2.Tables["qltycd"].Clear();
                        System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[1] as System.Collections.ArrayList, this.dataSet2.Tables["qltycd"]);
                        tab0.TableName = "qltycd";
                        this.dataSet2.Tables["qltycd"].Merge(tab0);
                    }
                }


                //CoreClientParam ccp1 = new CoreClientParam();
                //ccp1.ServerName = "UIB.JHY.JHYComQuery";
                //ccp1.MethodName = "doSimpleQuery";
                //ccp1.ServerParams = new object[] { al };
                //ccp1.SourceDataTable = this.dataSet2.Tables[2];
                //this.ExecuteQueryToDataTable(ccp1, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
            }
        }

        int grid1CurNum = 0;
        //点击上面的grid
        private void ultraGrid1_MouseDown(object sender, MouseEventArgs e)
        {
            try
            {
                if(this.ultraGrid1.ActiveRow == null)
                    return;
             //   if (this.ultraGrid1.ActiveCell.Column.Key == "CHK")
             //       return;
                grid1CurNum = this.ultraGrid1.ActiveRow.Index;
                strWtbh = this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text;

                string smpno = this.ultraGrid1.ActiveRow.Cells["SMP_NO"].Text;

                ArrayList al = new ArrayList();

                if (this.ultraTabControl1.Tabs[0].Selected)//检验结果查询
                {
                    if (this.ultraGrid1.ActiveCell.Column.Key == "COIL_NO"
                        || this.ultraGrid1.ActiveCell.Column.Key == "CHK")
                    {
                        al.Add("UIB100203_COMM_01_1.SELECT");
                        al.Add(this.strArr);//检测中心和理化楼区分
                        al.Add(this.ultraGrid1.ActiveRow.Cells["COIL_NO"].Text);
                        //al.Add(this.strArr);//力学或者金相
                        //al.Add(this.strSendTP);//是否已发送
                        al.Add(this.ultraGrid1.ActiveRow.Cells["SMP_NO"].Text);
                    }
                    else
                    {
                        if (smpno.Substring(0, 1) == "X" || smpno.Substring(0, 1) == "Y")
                        {
                            al.Add("UIB100203_COMMZHB_01.SELECT");
                        }
                        else 
                        {
                            al.Add("UIB100203_COMM_01.SELECT");
                        }
                        al.Add(this.strArr);//检测中心和理化楼区分
                        al.Add(this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text);
                       // al.Add(this.strArr);//力学或者金相
                       // al.Add(this.strSendTP);//是否已发送
                    }
                    this.dataSet1.Tables[1].Clear();
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.JHY.JHYComQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables[1];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                    SetColor("A" , this.ultraGrid2);//不合格颜色为红色
                }
                else if (this.ultraTabControl1.Tabs[1].Selected)//检验项目原始记录
                {


                    if (smpno.Substring(0, 1) == "X" || smpno.Substring(0, 1) == "Y")
                    {
                        al.Add("UIB100203_COMMZHB_02.SELECT");
                    }
                    else
                    {
                        al.Add("UIB100203_COMM_02.SELECT");
                    }
                    al.Add(this.strArr);//检测中心和理化楼区分
                    al.Add(this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text);
                    //al.Add(this.strArr);//力学或者金相
                    //al.Add(this.strSendTP);//是否已发送
                    this.dataSet2.Tables[0].Clear();
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.JHY.JHYComQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet2.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                    if (this.ultraGrid4.Rows.Count> 0 && this.ultraGrid3.Rows.Count == 0)
                    {
                        this.ultraGrid4.Rows[0].Activate();
                        ultraGrid4_MouseDown(null, null);
                    }
                }
                else if (this.ultraTabControl1.Tabs[2].Selected)//异常处理
                {
                    this.strSmpNo = this.ultraGrid1.ActiveRow.Cells["SMP_NO"].Text;
                    this.strSmpCutLoc = this.ultraGrid1.ActiveRow.Cells["SMP_CUT_LOC"].Text;
                    this.strSmpNoType = this.ultraGrid1.ActiveRow.Cells["SMP_NO_TYPE"].Text;
                    
                    //清除项目值
                    al.Add("UIB100203_COMM_10.SELECT");
                    al.Add(this.ultraGrid1.ActiveRow.Cells["SMP_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["SMP_CUT_LOC"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["SMP_NO_TYPE"].Text);
                    al.Add(this.strArr);
                    this.dataSet3.Tables["Table1"].Clear();
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.JHY.JHYComQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet3.Tables["Table1"];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }

            }
            catch (Exception ex)
            {
            }
        }

        //鼠标点击检验项目名称触发事件
        private void ultraGrid4_MouseDown(object sender, MouseEventArgs e)
        {
            try
            {
                if (this.ultraGrid4.ActiveRow == null)
                    return;
                this.dataSet2.Tables[1].Clear();
                this.dataSet2.Tables["yuanshi"].Clear();

                int GRID3COLS = 15;//固定的有15列，包括隐藏列

                //strQltyCD  = this.ultraGrid4.ActiveRow.Cells["QLTY_CD"].Text;//三期编码
                strQltyCD2 = this.ultraGrid4.ActiveRow.Cells["QLTY_CD_2"].Text;//二级编码，如拉力，冲击
                strQltyCD3 = this.ultraGrid4.ActiveRow.Cells["QLTY_CD_3"].Text;//三级编码，如屈服强度，伸长率

                //清除datatable中查询时增加的列，即显示钢卷号等信息的grid的动态列
                if (this.dataSet2.Tables[1].Columns.Count > GRID3COLS)
                {
                    for (int i = this.dataSet2.Tables[1].Columns.Count; i > GRID3COLS; i--)
                        this.dataSet2.Tables[1].Columns.Remove(this.dataSet2.Tables[1].Columns[i - 1]);
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.UIB100203";
                ccp.MethodName = "doQltyCdQuery";
                ccp.ServerParams = new object[] { strQltyCD2, strQltyCD3, strWtbh ,this.strArr , this.strSendTP==null?"":this.strSendTP };
                ccp.SourceDataTable = this.dataSet2.Tables["jilu"];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                //this.ultraGrid3.DisplayLayout.Bands[0].co
                //int ix = 0;
                //foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn col in this.ultraGrid3.DisplayLayout.Bands[0].Columns)
                //{
                //    col.RowLayoutColumnInfo.OriginX = ix * 2;
                //    col.RowLayoutColumnInfo.OriginY = 0;
                //    ix++;
                //}

               
                //列排序
                int index = GRID3COLS + 1;
                for (int i = 0; i < this.dataSet2.Tables[2].Rows.Count; i++)
                {
                    string strColName = this.dataSet2.Tables[2].Rows[i]["QLTY_OPE_CFNM"].ToString();//a , b, So等
                    string strColSeq = this.dataSet2.Tables[2].Rows[i]["QLTY_DIS_SEQ"].ToString();//1,2,3等
                    string strColCD2 = this.dataSet2.Tables[2].Rows[i]["QLTY_CD_2"].ToString();//如拉力，冲击等二级编码

                    if (strColSeq == "" || strColCD2 != this.strQltyCD2)//若无序号或者无在检验项目中所需要的检验编码（QLTY_OPE_CD），则不进行下面的循环，无意义
                    {
                        continue;
                    }

                    for (int nextCol = GRID3COLS; nextCol < this.ultraGrid3.DisplayLayout.Bands[0].Columns.Count; nextCol++)//固定的有15列，包括隐藏的两列，从第12列开始排序
                    {
                        if (this.ultraGrid3.DisplayLayout.Bands[0].Columns[nextCol].Header.Caption == strColName)
                        {
                            this.ultraGrid3.DisplayLayout.Bands[0].Columns[strColName].Header.VisiblePosition = index; //列排序
                            this.ultraGrid3.DisplayLayout.Bands[0].Columns[strColName].Width = 40;//设置列宽
                            this.ultraGrid3.DisplayLayout.Bands[0].Columns[strColName].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;//不可编辑
                            index++;
                            break;
                        }
                    }
                }

                SetColor("A" , this.ultraGrid3);//设置颜色
            }
            catch (Exception ex)
            {
               MessageBox.Show("系统异常，请联系技术中心","警告");
            }
        }

        //横行记录a,b,So的grid，在进行鼠标点击时的操作
        //******************************注意********************************* 
        //grid3若新增字段，可能出现查询后字段显示异常的情况。。。。。。。。。。。。。。。注意处理
        //若grid3增加了字段，并要移动字段位置，请通过Band and Column Settings -- >Column Arrangement Overview Use Groups and Levels中的字段移动来改变，否则可能出现某些字段无法显示的异常情况。
        private void ultraGrid3_MouseDown(object sender, MouseEventArgs e)
        {
            try
            {
                if (this.ultraGrid3.ActiveRow == null)
                    return;

                if (sender != null) grid3ActiveRow = this.ultraGrid3.ActiveRow.Index;
                this.strQltyCD = this.ultraGrid3.ActiveRow.Cells["QLTY_CD"].Text;
                this.strQltyCD2 = this.ultraGrid3.ActiveRow.Cells["QLTY_CD_2"].Text;
                
                this.dataSet2.Tables["yuanshi"].Clear();
                this.dataSet2.Tables["shebei"].Clear();
                ArrayList list = new ArrayList();

                //a,b等值查询
                ArrayList al = new ArrayList();
                list.Add(al);
                al.Add("UIB100203_COMM_05.SELECT");
                al.Add(this.strLine);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_CUT_LOC"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO_TYPE"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["QLTY_CD_3"].Text);
                al.Add(this.strQltyCD2);

                //设备号、备注等查询
                al = new ArrayList();
                list.Add(al);
                al.Add("UIB100203_COMM_06.SELECT");
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_CUT_LOC"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO_TYPE"].Text);
                al.Add(strQltyCD);

                //隐藏的值和编码
                al = new ArrayList();
                list.Add(al);
                al.Add("UIB100203_COMM_07.SELECT");
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_CUT_LOC"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO_TYPE"].Text);
                al.Add(this.strQltyCD2);

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComQuery";
                ccp.MethodName = "doContQluery";
                ccp.ServerParams = new object[] { list };
                CoreClientParam ccpList = this.ExecuteQuery(ccp, CoreInvokeType.Internal);
                if (ccpList.ReturnInfo.Length == 0)
                {
                    ArrayList aList = ccpList.ReturnObject as ArrayList;
                    if (aList[0] != null)
                    {
                        this.dataSet2.Tables["yuanshi"].Clear();
                        System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[0] as System.Collections.ArrayList, this.dataSet2.Tables["yuanshi"]);
                        tab0.TableName = "yuanshi";
                        this.dataSet2.Tables["yuanshi"].Merge(tab0);
                    }

                    if (aList[1] != null)
                    {
                        this.dataSet2.Tables["shebei"].Clear();
                        System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[1] as System.Collections.ArrayList, this.dataSet2.Tables["shebei"]);
                        tab0.TableName = "shebei";
                        this.dataSet2.Tables["shebei"].Merge(tab0);
                    }

                    if (aList[2] != null)
                    {
                        this.dataSet3.Tables["yincang"].Clear();
                        System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[2] as System.Collections.ArrayList, this.dataSet3.Tables["yincang"]);
                        tab0.TableName = "yincang";
                        this.dataSet3.Tables["yincang"].Merge(tab0);
                    }
                }

                this.textBoxEqumtID.Text = this.dataSet2.Tables["shebei"].Rows[0]["EQUMT_ID"].ToString();//设备号
                this.textBoxSmpRmk.Text = this.dataSet2.Tables["shebei"].Rows[0]["SMP_RMK"].ToString();//名称

                //记录上一次的CHK，以及下拉绑定
                for (int i = 0; i < this.ultraGrid5.Rows.Count; i++)
                {
                    //if (this.ultraGrid5.Rows[i].Cells["QLTY_OPE_CD"].Text == "Lo")
                    //{
                    //    string strChk = OperateConditionRecode.ReadCondition("UIB100203_CHKLO");
                    //    if(strChk == "False")
                    //    {
                    //        this.ultraGrid5.Rows[i].Cells["CHK"].Value = "True";
                            
                    //    }
                    //    else
                    //    {
                    //        this.ultraGrid5.Rows[i].Cells["CHK"].Value = "False";
                    //    }
                    //    //break;
                    //}
                    if (this.ultraGrid5.Rows[i].Cells["QLTY_OPE_CD"].Text == "FX")//与试样方向绑定
                    {
                        this.ultraGrid5.Rows[i].Cells["QLTY_VAL"].EditorComponent = this.ultraComboEditor1;
                    }
                    else if (this.ultraGrid5.Rows[i].Cells["QLTY_OPE_CD"].Text == "MJGG")//与剪切面积绑定
                    {
                        this.ultraGrid5.Rows[i].Cells["QLTY_VAL"].EditorComponent = this.ultraComboEditor2;
                    }
                    else if (this.ultraGrid5.Rows[i].Cells["QLTY_OPE_CD"].Text == "CB")//与冷弯绑定
                    {
                        this.ultraGrid5.Rows[i].Cells["QLTY_VAL"].EditorComponent = this.ultraComboEditor3;
                    }
                }
            }
            catch (Exception ex)
            {

            }
            
        }

       // int activteRowIndex = 0;//活动行
        private void ultraGrid5_KeyDown(object sender, KeyEventArgs e)
        {
            try
            {
                if (e.KeyCode != Keys.Enter) return;//回车时，才保存数据
                if (this.ultraGrid5.ActiveCell == null) return;

                if (this.ultraGrid5.ActiveCell.DataChanged == true)//数据被修改时
                {
                    if ((this.ultraGrid5.ActiveRow.Cells["EDIT_TP"].Text == "N"
                        || this.ultraGrid5.ActiveRow.Cells["EDIT_TP"].Text == "X" )
                        && this.ultraGrid5.ActiveRow.Cells["CHK"].Text != "True"
                        )//若无计算公式，或者没有被选中的，禁止编辑
                    {
                        MessageBox.Show("非可修改数据项，数据修改无效！", "提示");
                        return;
                    }
                    else
                    {
                        //********************************************************
                        if (this.ultraGrid5.ActiveRow.Cells["QLTY_OPE_CD"].Text == "Lo" && this.ultraGrid5.ActiveRow.Cells["EDIT_TP"].Text == "Y")
                        {
                            this.DoUpdate("Lo");
                            //同步更新到dataset3的对应的单元中
                            for (int i = 0; i < this.dataSet3.Tables["yincang"].Rows.Count; i++)
                            {
                                if ("Lo" == this.dataSet3.Tables["yincang"].Rows[i]["QLTY_OPE_CD"].ToString())
                                {
                                    this.dataSet3.Tables["yincang"].Rows[i]["QLTY_VAL"] = this.ultraGrid5.ActiveRow.Cells["QLTY_VAL"].Text;
                                    break;
                                }
                            }
                        }
                        else
                        {
                            this.DoUpdate("");//保存试验数据
                        }
                        //从当前行的下一行开始，计算所有具有计算公式的行
                        int numCol = this.ultraGrid5.ActiveRow.Index;
                        for (int i = numCol+1; i < this.ultraGrid5.Rows.Count; i++)
                        {
                            this.DoCompVal(i);//按公式计算，当前行的下面第一行
                        }
                    }
                }

                //换行，并编辑
                int curRow = this.ultraGrid5.ActiveRow.Index;//当前行的行序号
                for (int i = curRow; i <= (this.ultraGrid5.Rows.Count-1) ; i++)
                {
                    ////==========================未到行末==========================
                    if (i<(this.ultraGrid5.Rows.Count-1))
                    {
                        if ((this.ultraGrid5.Rows[i + 1].Cells["EDIT_TP"].Text != "N" && this.ultraGrid5.Rows[i + 1].Cells["EDIT_TP"].Text != "X")//若下一行允许编辑
                           || (/*curRow < (this.ultraGrid5.Rows.Count - 1) && */this.ultraGrid5.Rows[i + 1].Cells["CHK"].Text == "True")//允许编辑
                          )
                        {
                            this.ultraGrid5.Rows[i+1].Activate();
                            this.ultraGrid5.ActiveRow.Cells["QLTY_VAL"].Activated = true;
                            this.ultraGrid5.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode);
                            //this.ultraGrid5.DisplayLayout.Bands[0].Columns["QLTY_VAL"].CellActivation = Activation.AllowEdit;
                            //this.ultraGrid5.ActiveRow.Cells["QLTY_VAL"].Column.CellActivation = Activation.AllowEdit;
                            break;
                        }
                    }
                    ////==========================到达行末==========================
                    else if (  (i == this.ultraGrid5.Rows.Count - 1)
                               || (this.ultraGrid5.Rows[i].Cells["EDIT_TP"].Text == "N" && this.ultraGrid5.Rows[i].Cells["CHK"].Text != "True")//不允许编辑，有计算公式
                             )
                    {

                        //*****************************************
                        //////this.DoUpdate();//保存试验数据
                        
                        //判断数据格式是否合格，为double类型
                        if (JhyOpe.DcsDouble(this.ultraGrid3.Rows[grid3ActiveRow].Cells["QLTY_VAL"].Text))
                        {
                            //数据录入不合格提示
                            Decimal minValue = this.ultraGrid3.Rows[grid3ActiveRow].Cells["QLTY_MIN"].Text == "" ? 0 : Convert.ToDecimal(this.ultraGrid3.Rows[grid3ActiveRow].Cells["QLTY_MIN"].Text);
                            Decimal maxValue = this.ultraGrid3.Rows[grid3ActiveRow].Cells["QLTY_MAX"].Text == "" ? 999 : Convert.ToDecimal(this.ultraGrid3.Rows[grid3ActiveRow].Cells["QLTY_MAX"].Text); ;
                            Decimal qltyValue = this.ultraGrid3.Rows[grid3ActiveRow].Cells["QLTY_VAL"].Text == "" ? minValue : Convert.ToDecimal(this.ultraGrid3.Rows[grid3ActiveRow].Cells["QLTY_VAL"].Text);

                            if (qltyValue < minValue || qltyValue > maxValue)
                            {
                                this.ultraGrid3.Rows[grid3ActiveRow].RowSelectorAppearance.BackColor = Color.Red;
                                this.ultraGrid3.Rows[grid3ActiveRow].Appearance.ForeColor = Color.Red;// add by mgp 2014/3/3  
                                MessageBox.Show("第" + (grid3ActiveRow+1) + "行不合格！", "提示");
                            }
                        }
                        
                        //add by mgp 2014/3/3  注销下行代码
                        ultraGrid4_MouseDown(null , null);//鼠标点击项目名称触发的事件

                        grid3ActiveRow = grid3ActiveRow + 1;
                        if (grid3ActiveRow < this.ultraGrid3.Rows.Count)
                        {
                            this.ultraGrid3.Rows[grid3ActiveRow].Activate();
                            ultraGrid3_MouseDown(null, null);//重新触发事件，调用查询方法
                        }
                        else
                        {
                            grid3ActiveRow = 0;//到行末后，重新归0
                            MessageBox.Show("数据输入已完成" , "提示");
                        }

                        //this.ultraGrid5.Rows[0].Activate();
                        //this.ultraGrid5.ActiveRow.Cells["QLTY_VAL"].Activate();
                        //this.ultraGrid5.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode);
                        //break;
                        //this.ultraGrid5.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.FirstRowInBand);
                        if (this.ultraGrid5.Rows.Count != 0)//grid3跳转到下一行循环时，可能存在查出无数据的情况
                        {
                            this.ultraGrid5.Rows[0].Activate();
                            this.ultraGrid5.ActiveRow.Cells["QLTY_VAL"].Activate();
                            this.ultraGrid5.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode);
                            //this.ultraGrid5.DisplayLayout.Bands[0].Columns["QLTY_VAL"].CellActivation = Activation.AllowEdit;
                            break;
                        }
                        else
                        {
                            //MessageBox.Show("XXX");
                        }
                    }

                }
                
            }
            catch (Exception ex)
            {
                MessageBox.Show("数据录入异常，可能存在数据格式错误，请检查！" , "提示");
            }
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                if (this.checkBox1.Checked)
                {
                    this.textBox1.Enabled = true;
                    this.textBox2.Enabled = true;
                }
                else
                {
                    this.textBox1.Enabled = false;
                    this.textBox2.Enabled = false;
                }
            }
            catch (Exception ex)
            {
            }
        }

        private void checkBox2_CheckedChanged(object sender, EventArgs e)
        {
            if (this.checkBox2.Checked)
            {
                this.ultraDateTimeEditor3.Enabled = true;
                this.ultraDateTimeEditor4.Enabled = true;       
            }
            else
            {
                this.ultraDateTimeEditor3.Enabled = false;
                this.ultraDateTimeEditor4.Enabled = false;
            }
        }

        private void textBoxEqumtID_KeyDown(object sender, KeyEventArgs e)
        {
            try
            {
                if (e.KeyCode != Keys.Enter) return;

                if (this.ultraGrid3.ActiveRow == null) return;

                ArrayList al = new ArrayList();
                al.Add("UIB100203_COMM_01.UPDATE");
                al.Add(this.textBoxEqumtID.Text.Trim());
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_CUT_LOC"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO_TYPE"].Text);
                al.Add(this.strQltyCD2);
                al.Add(this.strQltyCD);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComSave";
                ccp.ServerParams = new object[] { al };
                ccp.MethodName = "doSimpleSave";
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

               // this.textBoxSmpRmk.Focus();
                this.ultraGrid3.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.NextRow);
            }
            catch (Exception ex)
            {
            }
        }

        private void textBoxSmpRmk_KeyDown(object sender, KeyEventArgs e)
        {
            try
            {
                if (e.KeyCode != Keys.Enter) return;

                if (this.ultraGrid3.ActiveRow == null) return;

                ArrayList al = new ArrayList();
                al.Add("UIB100203_COMM_02.UPDATE");
                al.Add(this.textBoxSmpRmk.Text.Trim());
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_CUT_LOC"].Text);
                al.Add(this.ultraGrid3.ActiveRow.Cells["SMP_NO_TYPE"].Text);
                al.Add(this.strQltyCD2);
                al.Add(this.strQltyCD);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComSave";
                ccp.ServerParams = new object[] { al };
                ccp.MethodName = "doSimpleSave";
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                //this.textBoxEqumtID.Focus();
                this.ultraGrid3.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.NextRow);
            }
            catch (Exception ex)
            {
            }
        }

        private void ultraGrid5_MouseDown(object sender, MouseEventArgs e)
        {
            //try
            //{
            //    if (this.ultraGrid5.ActiveRow == null) return;

            //    //只有Lo允许被选中，进行编辑
            //    if (this.ultraGrid5.ActiveCell.Column.Key == "CHK" )
            //    {

            //        if (this.ultraGrid5.ActiveRow.Cells["EDIT_TP"].Text == "N")
            //        {
            //            this.ultraGrid5.ActiveRow.Cells["CHK"].Value = "True";
            //            this.ultraGrid5.UpdateData();
            //        }
            //        else if(this.ultraGrid5.ActiveRow.Cells["QLTY_OPE_CD"].Text =="Lo" )
            //        {
            //            OperateConditionRecode.WriteCondition("UIB100203_CHKLO", this.ultraGrid5.ActiveRow.Cells["CHK"].Text);
            //        }
            //    }
                
            //}
            //catch (Exception ex)
            //{
            //}
        }


        private void checkBox4_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    ugr.Cells["CHK"].Value = this.checkBox4.Checked;
                    //ugr.Update();
                }
                this.ultraGrid1.UpdateData();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }


        private void checkBox3_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                foreach (UltraGridRow ugr in this.ultraGrid3.Rows)
                {
                    ugr.Cells["CHK"].Value = this.checkBox3.Checked;
                    ugr.Update();
                }
                this.ultraGrid1.UpdateData();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        //Rt0.2,ReL变更
        private void comboBox5_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
              
               // if (this.ultraGrid3.ActiveRow == null) return;

                if (MessageBox.Show("确定进行变更？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;

                foreach (UltraGridRow ugr in this.ultraGrid3.Rows)
                {
                    if (ugr.Cells["CHK"].Text == "True")
                    {
                        Hashtable ht = new Hashtable();
                        ht.Add("i1", ugr.Cells["SMP_NO"].Text);
                        ht.Add("i2", ugr.Cells["SMP_CUT_LOC"].Text);
                        ht.Add("i3", ugr.Cells["SMP_NO_TYPE"].Text);
                        ht.Add("i4", ugr.Cells["QLTY_CD"].Text);
                        ht.Add("i5", this.comboBox5.Text.Trim());
                        ht.Add("i6", this.UserInfo.GetUserName());
                        ht.Add("o7", "");

                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "UIB.JHY.JHyComCallProc";
                        ccp.MethodName = "doSimpleProc";
                        ccp.ServerParams = new object[] { "UIB100203_COMM_03.CALL", ht };
                        CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                        ArrayList al = rccp.ReturnObject as ArrayList;
                        if (al[0] == null) return;
                        if (al[0].ToString() == "XX") return;
                        ugr.Cells["QLTY_CD_CFNM"].Value = al[0].ToString();
                    }
                }
                
             //   if (al[0] == null) { MessageBox.Show("操作失败，请检查数据格式！", "提示"); } return;
             //   if (al[0].ToString() == "XX") { MessageBox.Show("操作失败，请检查数据格式！", "提示"); } return;
             //   this.ultraGrid5.ActiveRow.Cells["QLTY_CD_CFNM"].Value = al[0].ToString();

             //   this.ultraGrid3.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.NextRow);
                //  this.ultraGrid2.ActiveRow.Cells["QLTY_VAL_WK"].Activate();
                //   this.ultraGrid3.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode);
            }
            catch (Exception ex)
            {
            }
        }

        private void checkBox5_CheckedChanged(object sender, EventArgs e)
        {
            if (this.checkBox5.Checked)
            {
                this.ultraDateTimeEditor1.Enabled = true;
                this.ultraDateTimeEditor2.Enabled = true;
            }
            else
            {
                this.ultraDateTimeEditor1.Enabled = false;
                this.ultraDateTimeEditor2.Enabled = false;
            }
        }

        private void textBox6_KeyDown(object sender, KeyEventArgs e)
        {
            try
            {
                if (e.KeyCode != Keys.Enter) return;//回车时，才保存数据

                if (this.textBox6.Text.ToString().Substring(0, 1) != "L" & this.textBox6.Text.ToString().Substring(0, 1) != "R"
                    & this.textBox6.Text.ToString().Length != 12)
                {
                    MessageBox.Show("非法委托编号，请修改。（热轧-R，连退-L）" , "提示");
                    return;
                }

              //  if (this.textBox3.Text.ToString().Substring(0, 1) != this.textBox6.Text.ToString().Substring(0, 1))
                if (this.ultraGrid1.Rows[grid1CurNum].Cells["WEITO_NO"].Text.ToString().Substring(0, 1) != this.textBox6.Text.ToString().Substring(0, 1))
                {
                    MessageBox.Show("非法修改，请检查！", "提示");
                    return;
                }

                ArrayList al = new ArrayList();
                al.Add("UIB100203_COMM_03.UPDATE");
                al.Add(this.textBox6.Text.ToString());
                al.Add(this.ultraGrid1.Rows[grid1CurNum].Cells["WEITO_NO"].Text);

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComSave";
                ccp.ServerParams = new object[] { al };
                ccp.MethodName = "doSimpleSave";
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string path = null;
                if (this.folderBrowserDialog1.ShowDialog() == DialogResult.OK)
                {
                    path = this.folderBrowserDialog1.SelectedPath;
                    this.textBox5.Text = path;
                    OperateConditionRecode.WriteCondition("UIB100203_PATH", this.textBox5.Text);
                }

            }
            catch (Exception ex)
            {
            }
        }

        //钢印号修改
        private void textBox4_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode != Keys.Enter) return;//回车时，才保存数据
            try
            {
                Hashtable ht = new Hashtable();
                ht.Add("i1", this.ultraGrid1.Rows[grid1CurNum].Cells["COIL_NO"].Text);
                ht.Add("i2", this.ultraGrid1.Rows[grid1CurNum].Cells["SMP_NO"].Text);
                ht.Add("i3", this.ultraGrid1.Rows[grid1CurNum].Cells["SMP_CUT_LOC"].Text);
                ht.Add("i4", this.ultraGrid1.Rows[grid1CurNum].Cells["SMP_NO_TYPE"].Text);
                ht.Add("i5", this.textBox4.Text.Trim());
                ht.Add("o6" ,"" );
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHyComCallProc";
                ccp.MethodName = "doSimpleProc";
                ccp.ServerParams = new object[] { "UIB100203_COMM_04.CALL", ht };
                CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                //计算结果返回
                ArrayList al = rccp.ReturnObject as ArrayList;
                if (al[0] == null) return;
                //if (al[0].ToString() == "XX") return;
                MessageBox.Show(al[0].ToString() , "提示");

            }
            catch (Exception ex)
            {
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("确定清除？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;

                ArrayList al = new ArrayList();
                al.Add("UIB100203_COMM_04.UPDATE");
                al.Add(this.strSmpNo);
                al.Add(this.strSmpCutLoc);
                al.Add(this.strSmpNoType);
                al.Add(this.ultraComboEditor4.Value.ToString());
                al.Add(this.ultraComboEditor4.Value.ToString());

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComSave";
                ccp.ServerParams = new object[] { al };
                ccp.MethodName = "doSimpleSave";
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
            }
        }

    }
}