using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using CoreFS.CA06; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.IO; using System.Linq; using System.Net; using System.Text; using System.Windows.Forms; namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec { public partial class FrmLabMecDataCJAuditMJ : FrmBase { public FrmLabMecDataCJAuditMJ() { InitializeComponent(); } private string[] arrId;//数据权限 private string[] plineCodes = { }; private void FrmLabMecDataCJAuditMJ_Load(object sender, EventArgs e) { //arrId = new string[] { "002001007009", "002023003002" };//力学项目 arrId = this.ValidDataPurviewIds;//力学项目 plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid2.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid3.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid4.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid5.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid6.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid7.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid8.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid9.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid10.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid11.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid12.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid13.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid53.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid58.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid14.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid15.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid16.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid17.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid18.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid19.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid20.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid21.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid22.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid23.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid24.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid25.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid26.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid55.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid59.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid27.DisplayLayout.Bands[0]); //EntityHelper.ShowGridCaption(ultraGrid27.DisplayLayout.Bands[1]); EntityHelper.ShowGridCaption(ultraGrid28.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid29.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid30.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid31.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid32.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid33.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid34.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid35.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid36.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid37.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid38.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid39.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid56.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid40.DisplayLayout.Bands[0]); //EntityHelper.ShowGridCaption(ultraGrid40.DisplayLayout.Bands[1]); EntityHelper.ShowGridCaption(ultraGrid41.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid60.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid42.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid43.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid44.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid45.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid46.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid47.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid48.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid49.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid50.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid51.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid52.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid54.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid57.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid61.DisplayLayout.Bands[0]); DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 this.RegStartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); this.RegEndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); //initCheckEqiupment(); string lsRecord = "";//拉伸试验记录 DataTable dt = null; if (this.UserInfo.GetDeptid().Equals("002001007009")) { dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100118" }, this.ob); } else { dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100140" }, this.ob); } if (dt != null && dt.Rows.Count > 0) { lsRecord = dt.Rows[0]["BASENAME"].ToString(); } this.ultraTabControl3.Tabs[0].Text = "拉伸试验记录(" + lsRecord + ")"; string cjRecord = "";//冲击试验记录 DataTable cjdt = null; if (this.UserInfo.GetDeptid().Equals("002001007009")) { cjdt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100119" }, this.ob); } else { cjdt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100141" }, this.ob); } if (cjdt != null && cjdt.Rows.Count > 0) { cjRecord = cjdt.Rows[0]["BASENAME"].ToString(); } this.ultraTabControl3.Tabs[1].Text = "冲击试验记录(" + cjRecord + ")"; string ydRecord = "";//硬度试验记录 DataTable yddt = null; if (this.UserInfo.GetDeptid().Equals("002001007009")) { yddt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100120" }, this.ob); } else { yddt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100142" }, this.ob); } if (yddt != null && yddt.Rows.Count > 0) { ydRecord = yddt.Rows[0]["BASENAME"].ToString(); } this.ultraTabControl3.Tabs[2].Text = "硬度试验记录(" + ydRecord + ")"; this.ultraTabControl3.Tabs[3].Text = "硬度试验记录(" + ydRecord + ")"; this.ultraTabControl3.Tabs[4].Text = "硬度试验记录(" + ydRecord + ")"; string jxRecord = "";//金相试验记录 DataTable jxdt = null; if (this.UserInfo.GetDeptid().Equals("002001007009")) { jxdt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100121" }, this.ob); } else { jxdt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100143" }, this.ob); } if (jxdt != null && jxdt.Rows.Count > 0) { jxRecord = jxdt.Rows[0]["BASENAME"].ToString(); } this.ultraTabControl3.Tabs[5].Text = "金相试验记录(" + jxRecord + ")"; this.ultraTabControl3.Tabs[6].Text = "金相试验记录(" + jxRecord + ")"; this.ultraTabControl3.Tabs[7].Text = "金相试验记录(" + jxRecord + ")"; string gyRecord = "";//工艺试验记录 DataTable gydt = null; if (this.UserInfo.GetDeptid().Equals("002001007009")) { gydt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100122" }, this.ob); } else { gydt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.queryRecord", new Object[] { "100144" }, this.ob); } if (gydt != null && gydt.Rows.Count > 0) { gyRecord = gydt.Rows[0]["BASENAME"].ToString(); } this.ultraTabControl3.Tabs[8].Text = "工艺试验记录(" + gyRecord + ")"; this.ultraTabControl3.Tabs[9].Text = "工艺试验记录(" + gyRecord + ")"; this.ultraTabControl3.Tabs[10].Text = "工艺试验记录(" + gyRecord + ")"; ClsBaseInfo.SetComboItemHeight(ultraComMethod); ClsBaseInfo.SetComboItemHeight(ultraComMethod1); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { //查询、确认、退出 switch (ToolbarKey) { case "Query": if (ultraTabControl1.SelectedTab.Index == 0) { QueryCheckConsignBaseDetail("2","0"); } else if (ultraTabControl1.SelectedTab.Index == 1) { QueryCheckConsignBaseDetail("3","0"); } else if (ultraTabControl1.SelectedTab.Index == 2) { QueryCheckConsignBaseDetailNoFrim("3"); } else if (ultraTabControl1.SelectedTab.Index == 3) { QueryCheckConsignBaseDetailYesFrim("4"); } break; case "Add": AddPhyData(); break; case "Update": UpdateCheckConsignProcessResult(); break; case "Delete": DeleteCheckConsignProcessResult(); break; case "Audit": auditCheckConsignDetail(); break; case "CancelAudit": cancelAuditCheckConsignDetail(); break; case "PrintMechanics": printMechanics(); break; case"PrintPicture": printPicture(); break; case "UpFile": UpFile(); break; case"UpPicture": upPicture(); break; case "UpRecord": upRecord(); break; case "PrintRecord": printRecord(); break; case "QueryRecord": QueryCheckConsignBaseDetail("3", "1"); break; case "Close": this.Close(); break; } } private string fileName = "";//路径 /// /// 上传图片 /// private void upPicture() { this.ultraGrid40.UpdateData(); UltraGridRow row = ultraGrid40.ActiveRow; string checkNo = row.Cells["CheckNo"].Value.ToString(); string filePath = "Lims/pipe/caili2/" + checkNo + "/"; if (checkNo.Equals("")) { MessageUtil.ShowTips("没有用户不允许上传！"); return; } FormFileDown down = new FormFileDown(this.ob, filePath); down.CtrlFileDown1.FilePath = filePath; List list = new List(); FileBean bean = new FileBean(); OpenFileDialog file = new OpenFileDialog(); file.Multiselect = false; DialogResult drStat; drStat = file.ShowDialog(); if (drStat == DialogResult.OK) { fileName = file.FileName; FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read); //long s = fs.Length; //if (s / 1024.0 > 500) //{ // MessageUtil.ShowTips("图片大于50KB,请重新上传！"); // return; //} string filena = System.IO.Path.GetFileName(fileName); bean = new FileBean(); bean.setFileName(filena); bean.setPathName(filePath); bean.setFile(FileHelper.FileToArray(fileName)); list.Add(bean); bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list); if (isSuccess) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm"; ccp.MethodName = "updatePipeReport"; ccp.ServerParams = new object[] { checkNo, "", "", "CAILI_PATH_FUJIAN", filePath }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("上传成功!")) { MessageUtil.ShowTips(ccp.ReturnInfo); SelectFile(filePath); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } else { MessageBox.Show("上传失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } //ultraGrid1.ActiveCell.Value = filena; //ultraGrid1.ActiveRow.Cells["SignaturePath"].Value = filePath + filena; } } /// /// 打印 /// private void printMechanics() { this.ultraGrid40.UpdateData(); IQueryable checkMagRows = this.ultraGrid40.Rows.AsQueryable().Where(" CHK = 'True'"); //if (checkMagRows.Count() == 0) //{ // MessageUtil.ShowTips("请选择需要打印的信息"); // return; //} //if (checkMagRows.Count() > 1) //{ // MessageUtil.ShowTips("打印时只允许选择一个检验编号进行打印"); // return; //} //if (this.cmbPrint.Text == "") //{ // MessageUtil.ShowTips("请选择打印模板!"); // return; //} string version = ""; if (this.chkPrintK.Checked) { if (this.cmbPrintK.Text == "") { MessageUtil.ShowTips("请选择报告类型!"); return; } else { version = this.cmbPrintK.Value.ToString(); } } else { version = "MPA"; } string checkNo = this.ultraGrid40.ActiveRow.Cells["CheckNo"].Text; string contractNo = this.ultraGrid40.ActiveRow.Cells["ContractNo"].Text; string strSUPPLY_UNIT = this.ultraGrid40.ActiveRow.Cells["SupplyUnit"].Text; DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { checkNo,arrId }, ob); if(int.Parse(ds.Rows[0][0].ToString()) > 0) { MessageUtil.ShowTips("还有未审核试样组,不允许打印报告!"); return; } string strurl = ""; if (strSUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLXTH.cpt&bypagesize=false" + "&CHECK_NO=" + checkNo + "&version=" + version + "&ORDER_NO=" + contractNo; } else { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLX.cpt&bypagesize=false" + "&CHECK_NO=" + checkNo + "&version=" + version + "&ORDER_NO=" + contractNo; } //if (this.cmbPrint.Value.ToString2().Equals("0")) //{ // strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeMetallographicPG.cpt&bypagesize=false" + "&CHECK_NO=" + checkNo; //} //else if (this.cmbPrint.Value.ToString2().Equals("1")) //{ // strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeMetallographicZYG.cpt&bypagesize=false" + "&CHECK_NO=" + checkNo; //} //else if (this.cmbPrint.Value.ToString2().Equals("2")) //{ // strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeHardness.cpt&bypagesize=false" + "&CHECK_NO=" + checkNo; //} FrmRepExcel fre = new FrmRepExcel(this.ob, strurl); fre.AutoSize = true; fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fre.WindowState = FormWindowState.Maximized; fre.Show(); } /// /// 打印附件 /// private void printPicture() { this.ultraGrid40.UpdateData(); string checkNo = this.ultraGrid40.ActiveRow.Cells["CheckNo"].Text; string filePath = "Lims/pipe/caili2/" + checkNo + "/"; DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { checkNo, arrId }, ob); if (int.Parse(ds.Rows[0][0].ToString()) > 0) { MessageUtil.ShowTips("还有未审核试样组,不允许打印报告!"); return; } string strurl = filePath; dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath); down.ShowDialog(); //FrmRepExcel fre = new FrmRepExcel(this.ob, strurl); //fre.AutoSize = true; //fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); //fre.WindowState = FormWindowState.Maximized; //fre.Show(); } /// /// 上传原始记录 /// private void upRecord() { this.ultraGrid40.UpdateData(); UltraGridRow row = ultraGrid40.ActiveRow; string checkNo = row.Cells["CheckNo"].Value.ToString(); string filePath = "Lims/pipe/caili3/" + checkNo + "/"; if (checkNo.Equals("")) { MessageUtil.ShowTips("没有用户不允许上传！"); return; } FormFileDown down = new FormFileDown(this.ob, filePath); down.CtrlFileDown1.FilePath = filePath; List list = new List(); FileBean bean = new FileBean(); OpenFileDialog file = new OpenFileDialog(); file.Multiselect = false; DialogResult drStat; drStat = file.ShowDialog(); if (drStat == DialogResult.OK) { fileName = file.FileName; FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read); string filena = System.IO.Path.GetFileName(fileName); bean = new FileBean(); bean.setFileName(filena); bean.setPathName(filePath); bean.setFile(FileHelper.FileToArray(fileName)); list.Add(bean); bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list); if (isSuccess) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm"; ccp.MethodName = "updatePipeReport"; ccp.ServerParams = new object[] { checkNo, "", "", "CAILI_PATH_RECORD", filePath }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("上传成功!")) { MessageUtil.ShowTips(ccp.ReturnInfo); SelectFile(filePath); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } else { MessageBox.Show("上传失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } } } /// /// 打印原始记录 /// private void printRecord() { this.ultraGrid40.UpdateData(); string checkNo = this.ultraGrid40.ActiveRow.Cells["CheckNo"].Text; string filePath = "Lims/pipe/caili3/" + checkNo + "/"; DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { checkNo, arrId }, ob); if (int.Parse(ds.Rows[0][0].ToString()) > 0) { MessageUtil.ShowTips("还有未审核试样组,不允许打印报告!"); return; } string strurl = filePath; dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath); down.ShowDialog(); } //查询上传的PDF文件 /// /// 查询上传的PDF文件 /// private void SelectFile(string filePathNew) { dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePathNew); down.DeleteButton.Visible = false; down.ShowDialog(); } //上传 /// /// 上传 /// private void UpFile() { this.ultraGrid40.UpdateData(); IQueryable checkMagRows = this.ultraGrid40.Rows.AsQueryable().Where(" CHK = 'True'"); WebClient webClient = new WebClient(); List listPdf = new List(); string date = DateTime.Now.ToString("yyyyMMdd"); string url = ""; string filePathNew = ""; //报告目录 string reportNo = ""; //报告编号 string version = ""; if (this.chkPrintK.Checked) { if (this.cmbPrintK.Text == "") { MessageUtil.ShowTips("请选择报告类型!"); return; } else { version = this.cmbPrintK.Value.ToString(); } } else { version = "MPA"; } string checkNo = this.ultraGrid40.ActiveRow.Cells["CheckNo"].Text; string contractNo = this.ultraGrid40.ActiveRow.Cells["ContractNo"].Text; string strSUPPLY_UNIT = this.ultraGrid40.ActiveRow.Cells["SupplyUnit"].Text; DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { checkNo, arrId }, ob); if (int.Parse(ds.Rows[0][0].ToString()) > 0) { MessageUtil.ShowTips("还有未审核试样组,不允许上传报告!"); return; } string strurl = ""; if (strSUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLXTH.cpt&format=pdf" + "&CHECK_NO=" + checkNo + "&version=" + version + "&ORDER_NO=" + contractNo; } else { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLX.cpt&format=pdf" + "&CHECK_NO=" + checkNo + "&version=" + version + "&ORDER_NO=" + contractNo; } reportNo = checkNo + "LX"; //if (this.cmbPrint.Value.ToString2().Equals("0")) //{ // strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeMetallographicPG.cpt&format=pdf" + "&CHECK_NO=" + checkNo; // reportNo = checkNo + "PG"; //} //else if (this.cmbPrint.Value.ToString2().Equals("1")) //{ // strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeMetallographicZYG.cpt&format=pdf" + "&CHECK_NO=" + checkNo; // reportNo = checkNo + "ZYG"; //} //else if (this.cmbPrint.Value.ToString2().Equals("2")) //{ // strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeHardness.cpt&format=pdf" + "&CHECK_NO=" + checkNo; // reportNo = checkNo + "Hardness"; //} if (strurl == "") { MessageUtil.ShowTips("请先选择上传报告的模版!"); return; } filePathNew = "Lims/pipe/caili/" + checkNo + "/"; byte[] pdf = webClient.DownloadData(strurl); FileBean fileBean = new FileBean(); fileBean.setFile(pdf); fileBean.setFileName(reportNo + ".pdf"); fileBean.setPathName(filePathNew); listPdf.Add(fileBean); webClient.Dispose(); bool a = FileHelper.Upload(listPdf); if (a) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm"; ccp.MethodName = "updatePipeReport"; ccp.ServerParams = new object[] { checkNo, "", "", "CAILI_PATH", filePathNew }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("上传成功!")) { MessageUtil.ShowTips(ccp.ReturnInfo); SelectFile(filePathNew); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } else { MessageUtil.ShowError("系统生成PDF失败，请稍后再试！"); return; } } //上传 /// /// 上传 /// private bool UpFile(string checkNo, string contractNo) { WebClient webClient = new WebClient(); List listPdf = new List(); string date = DateTime.Now.ToString("yyyyMMdd"); string filePathNew = ""; //报告目录 string reportNo = ""; //报告编号 string strurl = ""; //DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { checkNo, arrId }, ob); //if(int.Parse(ds.Rows[0][0].ToString()) >0) //{ // return false; //} strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLX.cpt&format=pdf" + "&CHECK_NO=" + checkNo + "&version=" + "MPA" + "&ORDER_NO=" + contractNo; reportNo = checkNo + "LX"; filePathNew = "Lims/pipe/caili/" + checkNo + "/"; byte[] pdf = webClient.DownloadData(strurl); FileBean fileBean = new FileBean(); fileBean.setFile(pdf); fileBean.setFileName(reportNo + ".pdf"); fileBean.setPathName(filePathNew); listPdf.Add(fileBean); webClient.Dispose(); bool a = FileHelper.Upload(listPdf); if (a) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm"; ccp.MethodName = "updatePipeReport"; ccp.ServerParams = new object[] { checkNo, "", "", "CAILI_PATH", filePathNew }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("上传成功!")) { return true; } else { MessageUtil.ShowTips(ccp.ReturnInfo); return false; } } return true; } else { MessageUtil.ShowError("系统生成PDF失败，请稍后再试！"); return false; } } /// /// 审核 /// private void auditCheckConsignDetail() { this.ultraGrid27.UpdateData(); this.ultraGrid28.UpdateData(); UltraGridRow uRow = this.ultraGrid27.ActiveRow; if (uRow == null) return; IQueryable checkMagRows = this.ultraGrid28.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True"); if (checkMagRows.Count() == 0) { return; } //if (cmbPrint.Text == "") //{ // MessageUtil.ShowTips("请先选择上传报告的模版!"); // return; //} foreach (UltraGridRow row in ultraGrid29.Rows) { if (row.Cells["SampleType"].Text.ToString().Equals("") || row.Cells["PhyDir"].Text.ToString().Equals("")) { MessageUtil.ShowTips("请先录入试验方向和试验尺寸!"); return; } } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { PipeCheckconsignDetailEntity pipeCheckDetialTity = (PipeCheckconsignDetailEntity)row.ListObject; pipeCheckDetialTity.AuditName = UserInfo.GetUserName(); pipeCheckDetialTity.Flag = "4"; string pipeDetailEntity = JSONFormat.Format(pipeCheckDetialTity); parmList.Add(pipeDetailEntity); } if (MessageUtil.ShowYesNoAndQuestion("是否确认审核？") == DialogResult.No) { return; } //if (!UpFile(uRow.Cells["CheckNo"].Text)) //{ // return; //} CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmDataCJBase"; ccp.MethodName = "auditPhyDetial"; ccp.ServerParams = new object[] { parmList,UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("审核成功!")) { if (!UpFile(uRow.Cells["CheckNo"].Text, uRow.Cells["ContractNo"].Text)) { MessageUtil.ShowTips("自动上传失败，请手动上传！"); } QueryCheckConsignBaseDetailNoFrim("3"); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 取消审核 /// private void cancelAuditCheckConsignDetail() { this.ultraGrid41.UpdateData(); IQueryable checkMagRows = this.ultraGrid41.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { PipeCheckconsignDetailEntity pipeCheckDetialTity = (PipeCheckconsignDetailEntity)row.ListObject; string pipeDetailEntity = JSONFormat.Format(pipeCheckDetialTity); parmList.Add(pipeDetailEntity); } if (MessageUtil.ShowYesNoAndQuestion("是否取消审核？") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmDataCJBase"; ccp.MethodName = "cancelAuditPhyDetial"; ccp.ServerParams = new object[] { parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("取消审核成功!")) { QueryCheckConsignBaseDetailYesFrim("4"); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 删除检验结果 /// private void DeleteCheckConsignProcessResult() { ultraGrid16.UpdateData(); ultraGrid17.UpdateData(); ultraGrid18.UpdateData(); ultraGrid19.UpdateData(); ultraGrid20.UpdateData(); ultraGrid21.UpdateData(); ultraGrid22.UpdateData(); ultraGrid23.UpdateData(); ultraGrid55.UpdateData(); ultraGrid59.UpdateData(); UltraGridRow uRow = this.ultraGrid15.ActiveRow; RowsCollection uRow1 = null; if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0001")) { uRow1 = this.ultraGrid16.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0002")) { uRow1 = this.ultraGrid17.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0003")) { uRow1 = this.ultraGrid20.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0004") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0018")) { uRow1 = this.ultraGrid18.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0005")) { uRow1 = this.ultraGrid19.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0012")) { uRow1 = this.ultraGrid21.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0013")) { uRow1 = this.ultraGrid22.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0014") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0016")) { uRow1 = this.ultraGrid23.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0009")) { uRow1 = this.ultraGrid24.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0027") || uRow.Cells["PhyCodeMax"].Value.Equals("C0038") || uRow.Cells["PhyCodeMax"].Value.Equals("C0082") || uRow.Cells["PhyCodeMax"].Value.Equals("C0083") || uRow.Cells["PhyCodeMax"].Value.Equals("C0098")) { uRow1 = this.ultraGrid25.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0026") || uRow.Cells["PhyCodeMax"].Value.Equals("C0039") || uRow.Cells["PhyCodeMax"].Value.Equals("C0040") || uRow.Cells["PhyCodeMax"].Value.Equals("C0041")) { uRow1 = this.ultraGrid26.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0050") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0060")) { uRow1 = this.ultraGrid55.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0057") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0066")) { uRow1 = this.ultraGrid59.Rows; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in uRow1) { PipeCheckconsignPhydetailEntity pipeCheckTity = (PipeCheckconsignPhydetailEntity)row.ListObject; pipeCheckTity.CheckNo = uRow.Cells["CheckNo"].Text; pipeCheckTity.SampleNo = uRow.Cells["SampleNo"].Text; pipeCheckTity.PhyCodeMin = uRow.Cells["PhyCodeMin"].Text;//试样组 pipeCheckTity.PhyNameMin = uRow.Cells["PhyNameMin"].Text; string phyEntity = JSONFormat.Format(pipeCheckTity); parmList.Add(phyEntity); } PipeCheckconsignDetailEntity pipeDetailTity = (PipeCheckconsignDetailEntity)uRow.ListObject; string pipeDetailEntity = JSONFormat.Format(pipeDetailTity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmDataCJBase"; ccp.MethodName = "deletePhyDetial"; ccp.ServerParams = new object[] { pipeDetailEntity, parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("删除成功!")) { QueryCheckConsignBaseDetail("3", "0"); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 修改检验结果 /// private void UpdateCheckConsignProcessResult() { ultraGrid16.UpdateData(); ultraGrid17.UpdateData(); ultraGrid18.UpdateData(); ultraGrid19.UpdateData(); ultraGrid20.UpdateData(); ultraGrid21.UpdateData(); ultraGrid22.UpdateData(); ultraGrid23.UpdateData(); ultraGrid55.UpdateData(); ultraGrid59.UpdateData(); UltraGridRow uRow = this.ultraGrid15.ActiveRow; RowsCollection uRow1 = null; if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0001")) { uRow1 = this.ultraGrid16.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0002")) { uRow1 = this.ultraGrid17.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0003")) { uRow1 = this.ultraGrid20.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0004") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0018")) { uRow1 = this.ultraGrid18.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0005")) { uRow1 = this.ultraGrid19.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0012")) { uRow1 = this.ultraGrid21.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0013")) { uRow1 = this.ultraGrid22.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0014") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0016")) { uRow1 = this.ultraGrid23.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0009")) { uRow1 = this.ultraGrid24.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0027") || uRow.Cells["PhyCodeMax"].Value.Equals("C0038") || uRow.Cells["PhyCodeMax"].Value.Equals("C0082") || uRow.Cells["PhyCodeMax"].Value.Equals("C0083") || uRow.Cells["PhyCodeMax"].Value.Equals("C0098")) { uRow1 = this.ultraGrid25.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0026") || uRow.Cells["PhyCodeMax"].Value.Equals("C0039") || uRow.Cells["PhyCodeMax"].Value.Equals("C0040") || uRow.Cells["PhyCodeMax"].Value.Equals("C0041")) { uRow1 = this.ultraGrid26.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0050") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0060")) { uRow1 = this.ultraGrid55.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0057") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0066")) { uRow1 = this.ultraGrid59.Rows; } PipeCheckconsignDetailEntity pipeDetailTity = new PipeCheckconsignDetailEntity(); ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in uRow1) { PipeCheckconsignPhydetailEntity pipeCheckTity = (PipeCheckconsignPhydetailEntity)row.ListObject; pipeCheckTity.Value1 = pipeCheckTity.Value1.Replace('<', '-'); pipeCheckTity.Value2 = pipeCheckTity.Value2.Replace('<', '-'); pipeCheckTity.Value3 = pipeCheckTity.Value3.Replace('<', '-'); pipeCheckTity.Value4 = pipeCheckTity.Value4.Replace('<', '-'); pipeCheckTity.AverageValue = pipeCheckTity.AverageValue.Replace('<', '-'); pipeCheckTity.CheckNo = uRow.Cells["CheckNo"].Text; pipeCheckTity.SampleNo = uRow.Cells["SampleNo"].Text; pipeCheckTity.PhyCodeMin = uRow.Cells["PhyCodeMin"].Text;//试样组 pipeCheckTity.PhyNameMin = uRow.Cells["PhyNameMin"].Text; pipeCheckTity.PhyNameDir = row.Cells["PhyCodeDir"].Text.Trim(); if (uRow.Cells["PhyCodeMax"].Value.Equals("C0009"))//压扁试验 { pipeCheckTity.Value8 = this.ultraTxtYbSpac.Text.Trim(); pipeCheckTity.IsGood = this.ultraTxtYbQualfiled.Value.ToString2(); pipeCheckTity.IsDefect = this.ultraTxtYbDefect.Value.ToString2(); pipeCheckTity.Remark = this.ultraTxtYbMemo.Text.Trim(); } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0027") || uRow.Cells["PhyCodeMax"].Value.Equals("C0038") || uRow.Cells["PhyCodeMax"].Value.Equals("C0082") || uRow.Cells["PhyCodeMax"].Value.Equals("C0083") || uRow.Cells["PhyCodeMax"].Value.Equals("C0098"))//弯曲试验 { pipeCheckTity.Value9 = this.ultraTxtWqDiameter.Text.Trim(); pipeCheckTity.Value10 = this.ultraTxtWqAngle.Text.Trim(); pipeCheckTity.IsGood = this.ultraTxtWqQualfiled.Value.ToString2(); pipeCheckTity.Remark = this.ultraTxtWqMemo.Text.Trim(); } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0026") || uRow.Cells["PhyCodeMax"].Value.Equals("C0039") || uRow.Cells["PhyCodeMax"].Value.Equals("C0040") || uRow.Cells["PhyCodeMax"].Value.Equals("C0041"))//扩口试验 { pipeCheckTity.Value11 = this.ultraTxtKkTop.Text.Trim(); pipeCheckTity.Value12 = this.ultraTxtKkFlarRate.Text.Trim(); pipeCheckTity.IsGood = this.ultraTxtKkGood.Value.ToString2(); pipeCheckTity.Remark = this.ultraTxtKkMemo.Text.Trim(); } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0073") || uRow.Cells["PhyCodeMax"].Value.Equals("C0163") || uRow.Cells["PhyCodeMax"].Value.Equals("C0166") || uRow.Cells["PhyCodeMax"].Value.Equals("C0167"))//落锤试验 { pipeCheckTity.SampleJb = this.ultraSAMPLE_JB.Text.Trim(); pipeCheckTity.NotchShape = this.ultraNOTCH_SHAPE.Text.Trim(); pipeCheckTity.NotchType = this.ultraNOTCH_TYPE.Text.Trim(); } string phyEntity = JSONFormat.Format(pipeCheckTity); parmList.Add(phyEntity); } pipeDetailTity.CheckNo = uRow.Cells["CheckNo"].Text; pipeDetailTity.SampleNo = uRow.Cells["SampleNo"].Text; pipeDetailTity.PhyCodeMin = uRow.Cells["PhyCodeMin"].Text;//检验大项 pipeDetailTity.PhyCodeMax = uRow.Cells["PhyCodeMax"].Text;//试样组 pipeDetailTity.CheckTemp = this.txtCHECK_TEMP1.Text.Trim(); pipeDetailTity.DeviceNo = this.ultraDEVICE_NAME1.Value.ToString2(); pipeDetailTity.DeviceName = this.ultraDEVICE_NAME1.Text.Trim(); pipeDetailTity.FormualNo = this.ultraComMethod1.Value.ToString2(); pipeDetailTity.FormualName = this.ultraComMethod1.Text.Trim(); pipeDetailTity.CheckName = this.UserInfo.GetUserName(); pipeDetailTity.CheckShift = this.UserInfo.GetUserOrder(); pipeDetailTity.CheckClass = this.UserInfo.GetUserGroup(); pipeDetailTity.Remark = this.txtREMARK1.Text; pipeDetailTity.HardnessType = this.ultraComFormual1.Text; pipeDetailTity.StdSteelNo = this.txtStdSteelNo1.Text.Trim(); pipeDetailTity.StdSteelType = this.cmbStdSteelType1.Text; pipeDetailTity.StdSteelValue = txtStdSteelValue1.Text.Trim(); pipeDetailTity.ActualValue = txtActualValue1.Text.Trim(); string pipeDetailEntity = JSONFormat.Format(pipeDetailTity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmDataCJBase"; ccp.MethodName = "updatePhyDetial"; ccp.ServerParams = new object[] { pipeDetailEntity,parmList,UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { QueryCheckConsignBaseDetail("3", "0"); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// ///保存理化录入值 /// private void AddPhyData() { this.ultraGrid3.UpdateData(); this.ultraGrid4.UpdateData(); this.ultraGrid5.UpdateData(); this.ultraGrid6.UpdateData(); this.ultraGrid7.UpdateData(); this.ultraGrid8.UpdateData(); this.ultraGrid9.UpdateData(); this.ultraGrid10.UpdateData(); this.ultraGrid53.UpdateData(); this.ultraGrid58.UpdateData(); UltraGridRow uRow = this.ultraGrid2.ActiveRow; RowsCollection uRow1 = null; if(uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0001")) { uRow1 = this.ultraGrid3.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0002")) { uRow1 = this.ultraGrid4.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0003")) { uRow1 = this.ultraGrid6.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0004") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0018")) { uRow1 = this.ultraGrid5.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0005")) { uRow1 = this.ultraGrid7.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0012")) { uRow1 = this.ultraGrid8.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0013")) { uRow1 = this.ultraGrid10.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0014") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0016")) { uRow1 = this.ultraGrid9.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0009")) { uRow1 = this.ultraGrid13.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0027") || uRow.Cells["PhyCodeMax"].Value.Equals("C0038") || uRow.Cells["PhyCodeMax"].Value.Equals("C0082") || uRow.Cells["PhyCodeMax"].Value.Equals("C0083") || uRow.Cells["PhyCodeMax"].Value.Equals("C0098")) { uRow1 = this.ultraGrid11.Rows; } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0026") || uRow.Cells["PhyCodeMax"].Value.Equals("C0039") || uRow.Cells["PhyCodeMax"].Value.Equals("C0040") || uRow.Cells["PhyCodeMax"].Value.Equals("C0041")) { uRow1 = this.ultraGrid12.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0050") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0060")) { uRow1 = this.ultraGrid53.Rows; } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0057") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0066")) { uRow1 = this.ultraGrid58.Rows; } if (!checkData()) { return; } ArrayList parmList = new ArrayList(); PipeCheckconsignDetailEntity pipeDetailTity = new PipeCheckconsignDetailEntity(); //ArrayList tempList = new ArrayList(); foreach (UltraGridRow row in uRow1) { PipeCheckconsignPhydetailEntity pipeCheckTity = (PipeCheckconsignPhydetailEntity)row.ListObject; pipeCheckTity.CheckNo = uRow.Cells["CheckNo"].Text; pipeCheckTity.SampleNo = uRow.Cells["SampleNo"].Text; pipeCheckTity.PhyCodeMin = uRow.Cells["PhyCodeMax"].Text;//试样组 pipeCheckTity.PhyNameMin = uRow.Cells["PhyNameMax"].Text; pipeCheckTity.PhyNameDir = row.Cells["PhyCodeDir"].Text.Trim(); if (uRow.Cells["PhyCodeMax"].Value.Equals("C0009"))//压扁试验 { pipeCheckTity.Value8 = this.TxtYbSpac.Text.Trim(); pipeCheckTity.Value7 = this.TxtYbC.Text.Trim(); pipeCheckTity.IsGood = this.TxtYbQualfiled.Value.ToString2(); pipeCheckTity.IsDefect = this.TxtYbDefect.Value.ToString2(); pipeCheckTity.CalculationFormula = this.TxtYbEuestion.Text; pipeCheckTity.Remark = this.TxtYbMemo.Text.Trim(); } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0027") || uRow.Cells["PhyCodeMax"].Value.Equals("C0038") || uRow.Cells["PhyCodeMax"].Value.Equals("C0082") || uRow.Cells["PhyCodeMax"].Value.Equals("C0083") || uRow.Cells["PhyCodeMax"].Value.Equals("C0098"))//弯曲试验 { pipeCheckTity.Value9 = this.TxtWqDiameter.Text.Trim(); pipeCheckTity.Value10 = this.TxtWqAngle.Text.Trim(); pipeCheckTity.IsGood = this.TxtWqQualfiled.Value.ToString2(); pipeCheckTity.Remark = this.TxtWqMemo.Text.Trim(); } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0026") || uRow.Cells["PhyCodeMax"].Value.Equals("C0039") || uRow.Cells["PhyCodeMax"].Value.Equals("C0040") || uRow.Cells["PhyCodeMax"].Value.Equals("C0041"))//扩口试验 { pipeCheckTity.Value11 = this.TxtKkTop.Text.Trim(); pipeCheckTity.Value12 = this.TxtKkFlarRate.Text.Trim(); pipeCheckTity.IsGood = this.TxtKkGood.Value.ToString2(); pipeCheckTity.Remark = this.TxtKkMemo.Text.Trim(); } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0073") || uRow.Cells["PhyCodeMax"].Value.Equals("C0163") || uRow.Cells["PhyCodeMax"].Value.Equals("C0166") || uRow.Cells["PhyCodeMax"].Value.Equals("C0167"))//落锤试验 { pipeCheckTity.SampleJb = this.TxtSAMPLE_JB.Text.Trim(); pipeCheckTity.NotchShape = this.TxtNOTCH_SHAPE.Text.Trim(); pipeCheckTity.NotchType = this.TxtNOTCH_TYPE.Text.Trim(); } string phyEntity = JSONFormat.Format(pipeCheckTity); parmList.Add(phyEntity); } pipeDetailTity.CheckNo = uRow.Cells["CheckNo"].Text; pipeDetailTity.SampleNo = uRow.Cells["SampleNo"].Text; pipeDetailTity.PhyCodeMin = uRow.Cells["PhyCodeMin"].Text;//检验大项 pipeDetailTity.PhyCodeMax = uRow.Cells["PhyCodeMax"].Text;//试样组 pipeDetailTity.CheckTemp = this.txtCHECK_TEMP.Text.Trim(); pipeDetailTity.DeviceNo = this.ultraDEVICE_NAME.Value.ToString2(); pipeDetailTity.DeviceName = this.ultraDEVICE_NAME.Text.Trim(); pipeDetailTity.FormualNo = this.ultraComMethod.Value.ToString2(); pipeDetailTity.FormualName = this.ultraComMethod.Text.Trim(); pipeDetailTity.CheckName = this.txtChemUser.Text.Trim(); pipeDetailTity.CheckShift = this.cmbChemOrder.Value.ToString2(); pipeDetailTity.CheckClass = this.cmbChemGroup.Value.ToString2(); pipeDetailTity.StdSteelNo = this.txtStdSteelNo.Text.Trim(); pipeDetailTity.StdSteelType = this.cmbStdSteelType.Text.Trim(); pipeDetailTity.StdSteelValue = this.txtStdSteelValue.Text.Trim(); pipeDetailTity.ActualValue = this.txtActualValue.Text.Trim(); pipeDetailTity.HardnessType = this.ultraComFormual.Text.Trim(); pipeDetailTity.CheckName = this.UserInfo.GetUserName(); pipeDetailTity.PhyDir = this.txtPHY_DIR.Text.Trim(); pipeDetailTity.SampleType = this.txtSAMPLE_TYPE.Text.Trim(); if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0001")) { pipeDetailTity.SampleStyle = this.ultraSAMPLE_STYLE.Value.ToString().Trim(); //if (this.txtPHY_DIR.Text.Trim().Equals("") || this.txtSAMPLE_TYPE.Text.Trim().Equals("") || this.ultraSAMPLE_STYLE.Text.Trim().Equals("")) //{ // MessageUtil.ShowTips("试验方向,试验尺寸和试样形状不能为空"); // return; //} } //pipeDetailTity.PHYCO = this.ultraPHY_CODE_DIR.Text.Trim(); if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0002")) { if (this.txtPHY_DIR.Text.Trim().Equals("") || this.txtSAMPLE_TYPE.Text.Trim().Equals("") ) { MessageUtil.ShowTips("试验方向,试验尺寸和试样形状不能为空"); return; } } pipeDetailTity.Flag = "3";//录入状态 string pipeDetailEntity = JSONFormat.Format(pipeDetailTity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmDataCJBase"; ccp.MethodName = "addPhyDataNew"; ccp.ServerParams = new object[] { pipeDetailEntity, parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("保存成功!")) { this.txtStdSteelNo.Text = ""; this.cmbStdSteelType.Text = ""; this.txtStdSteelValue.Text = ""; this.txtActualValue.Text = ""; QueryCheckConsignBaseDetail("2", "0"); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 数据验证 /// /// private bool checkData() { UltraGridRow uRow = this.ultraGrid2.ActiveRow; if (this.txtCHECK_TEMP.Text.Trim() == "") { MessageUtil.ShowTips("试验温度不允许为空!"); return false; } if (this.ultraDEVICE_NAME.Text.Trim() == "") { MessageUtil.ShowTips("试验设备不允许为空!"); return false; } if (this.ultraComMethod.Text.Trim() == "") { MessageUtil.ShowTips("试验方法不允许为空!"); return false; } if (this.cmbChemOrder.Text == "" || this.cmbChemGroup.Text == "") { MessageUtil.ShowTips("班次班组不允许为空!"); return false; } if (txtChemUser.Text.Trim() == "") { MessageUtil.ShowTips("试验人不允许为空!"); return false; } if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0001"))//拉伸试验 { foreach(UltraGridRow row in this.ultraGrid3.Rows) { if(row.Cells["Value1"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0002"))//夏比冲击试验 { foreach (UltraGridRow row in this.ultraGrid4.Rows) { if (row.Cells["Value1"].Text.ToString() == "" || row.Cells["Value2"].Text.ToString() == "" || row.Cells["Value3"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0004"))//洛氏硬度 { //if (ultraComFormual.Text == "") //{ // MessageUtil.ShowTips("硬度类型不能为空!"); // return false; //} if (txtStdSteelNo.Text.Trim() == "") { MessageUtil.ShowTips("标钢编号不能为空!"); return false; } if (cmbStdSteelType.Text.Trim() == "") { MessageUtil.ShowTips("标钢类型不能为空!"); return false; } if (txtStdSteelValue.Text.Trim() == "") { MessageUtil.ShowTips("标钢标准值不能为空!"); return false; } if (txtActualValue.Text.Trim() == "") { MessageUtil.ShowTips("标钢实测值不能为空!"); return false; } foreach (UltraGridRow row in this.ultraGrid5.Rows) { if (row.Cells["Value1"].Text.ToString() == "" || row.Cells["Value2"].Text.ToString() == "" || row.Cells["Value3"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0005"))//维氏硬度 { if (ultraComFormual.Text == "") { MessageUtil.ShowTips("硬度类型不能为空!"); return false; } if (txtStdSteelNo.Text.Trim() == "") { MessageUtil.ShowTips("标钢编号不能为空!"); return false; } if (cmbStdSteelType.Text.Trim() == "") { MessageUtil.ShowTips("标钢类型不能为空!"); return false; } if (txtStdSteelValue.Text.Trim() == "") { MessageUtil.ShowTips("标钢标准值不能为空!"); return false; } if (txtActualValue.Text.Trim() == "") { MessageUtil.ShowTips("标钢实测值不能为空!"); return false; } foreach (UltraGridRow row in this.ultraGrid7.Rows) { if (row.Cells["Value1"].Text.ToString() == "" || row.Cells["Value2"].Text.ToString() == "" || row.Cells["Value3"].Text.ToString() == ""||row.Cells["Value4"].Text.ToString()== "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0003"))//布氏硬度 { if (ultraComFormual.Text == "") { MessageUtil.ShowTips("硬度类型不能为空!"); return false; } if (txtStdSteelNo.Text.Trim() == "") { MessageUtil.ShowTips("标钢编号不能为空!"); return false; } if (cmbStdSteelType.Text.Trim() == "") { MessageUtil.ShowTips("标钢类型不能为空!"); return false; } if (txtStdSteelValue.Text.Trim() == "") { MessageUtil.ShowTips("标钢标准值不能为空!"); return false; } if (txtActualValue.Text.Trim() == "") { MessageUtil.ShowTips("标钢实测值不能为空!"); return false; } foreach (UltraGridRow row in this.ultraGrid6.Rows) { if (row.Cells["Value1"].Text.ToString() == "" || row.Cells["Value2"].Text.ToString() == "" || row.Cells["Value3"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0012"))//夹杂物 { foreach (UltraGridRow row in this.ultraGrid8.Rows) { if (uRow.Cells["PhyCodeMax"].Value.ToString().Equals("C0011")) { if (row.Cells["Value1"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } else if (uRow.Cells["PhyCodeMax"].Value.ToString().Equals("C0115")) { if (row.Cells["Value1"].Text.ToString() == "" || row.Cells["Value2"].Text.ToString()== "" || row.Cells["Value3"].Text.ToString() == "" ||row.Cells["Value4"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0013"))//晶粒度 { foreach (UltraGridRow row in this.ultraGrid10.Rows) { if (row.Cells["Value1"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0014"))//组织 { foreach (UltraGridRow row in this.ultraGrid9.Rows) { if (row.Cells["Value1"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0009")) { ultraGrid13.UpdateData(); if (this.ultraGrid13.ActiveRow.Cells["PhyCode"].Text.Equals("P0330")) { if (this.TxtYbSpac.Text.Trim() == "" || this.TxtYbQualfiled.Value.ToString2() == "" || this.TxtYbDefect.Value.ToString2() == "") { MessageUtil.ShowTips("压扁试验时压扁间距以及是否完好、是否缺陷不能为空!"); return false; } } else { if (this.TxtYbSpac.Text.Trim() == "" || this.TxtYbQualfiled.Value.ToString2() == "") { MessageUtil.ShowTips("压扁试验时压扁间距以及是否完好、是否缺陷不能为空!"); return false; } } } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0027") || uRow.Cells["PhyCodeMax"].Value.Equals("C0038") || uRow.Cells["PhyCodeMax"].Value.Equals("C0082") || uRow.Cells["PhyCodeMax"].Value.Equals("C0083") || uRow.Cells["PhyCodeMax"].Value.Equals("C0098")) { if (this.TxtWqDiameter.Text.Trim() == "" || this.TxtWqAngle.Value.ToString2() == "" || this.TxtWqQualfiled.Value.ToString2() == "") { MessageUtil.ShowTips("弯曲试验时弯曲直径、弯曲角度、是否完好不能为空!"); return false; } } else if (uRow.Cells["PhyCodeMax"].Value.Equals("C0026") || uRow.Cells["PhyCodeMax"].Value.Equals("C0039") || uRow.Cells["PhyCodeMax"].Value.Equals("C0040") || uRow.Cells["PhyCodeMax"].Value.Equals("C0041")) { if (this.TxtKkTop.Text.Trim() == "" || this.TxtKkFlarRate.Text.Trim() == "" || this.TxtKkGood.Value.ToString2() == "") { MessageUtil.ShowTips("扩口试验时顶芯角度、扩口率、是否完好不能为空!"); return false; } } else if (uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0050") || uRow.Cells["PhyCodeMin"].Value.ToString().Equals("R0060")) { foreach (UltraGridRow row in this.ultraGrid53.Rows) { if (row.Cells["Value1"].Text.ToString() == "" || row.Cells["Value2"].Text.ToString() == "" || row.Cells["Value3"].Text.ToString() == "") { MessageUtil.ShowTips("黄色区域有数据未录入，请核实!"); return false; } } } return true; } //查询 /// /// /// /// /// 是否查全部，1-查全部，包含审核后的数据，0-只查未审核的数据 private void QueryCheckConsignBaseDetail(string flag,string isAll) { string startTim = ""; string endTim = ""; string checkNo = ""; string judgeNo = ""; string sampleNo = ""; string steelName = ""; string specName = ""; string orderNo = ""; string checkPhy = ""; string txtGroup = ""; string ispodutor = ""; var status = new List { }; if (chkType.Checked) { status = cmbType.CheckedItems.Select(p => p.DataValue.ToString()).ToList(); if (!status.Any()) status = new List { "0", "1", "2", "3", "4", "5" }; } ArrayList parmList = new ArrayList(); if(chkRegTime.Checked) { startTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if(chkCheckNo.Checked && this.txtCheckNo.Text.Trim() != "") { checkNo = this.txtCheckNo.Text.Trim(); } if(chkJudgeNo.Checked && this.txtJudgeNo.Text != "") { judgeNo = this.txtJudgeNo.Text.Trim(); } if(chkSampleNo.Checked && this.txtSampleNo.Text.Trim() != "") { sampleNo = txtSampleNo.Text.Trim(); } if(chkOrderNo.Checked && this.txtOrderNo.Text != "") { orderNo = txtOrderNo.Text.Trim(); } if(chkSteel.Checked && this.txtSteel.Text.Trim() != "") { steelName = this.txtSteel.Text.Trim(); } if(chkSpec.Checked && this.txtSpec.Text.Trim() != "") { specName = this.txtSpec.Text.Trim(); } if(chkGroup.Checked && this.cmbGroup.Text != "") { txtGroup = this.cmbGroup.Value.ToString2(); } if (chkIsProuctor.Checked && this.cmbIsProductor.Text != "") { ispodutor = this.cmbIsProductor.Value.ToString2(); } checkPhy = ultraOptionSet1.CheckedItem.DataValue.ToString(); parmList.Add(startTim); parmList.Add(endTim); parmList.Add(checkNo); parmList.Add(judgeNo); parmList.Add(sampleNo); parmList.Add(orderNo); parmList.Add(steelName); parmList.Add(specName); parmList.Add(txtGroup); parmList.Add(ispodutor); parmList.Add(checkPhy); if (UserInfo.GetDeptid().Equals("002001007009")) { parmList.Add("1");//天管要求加入实验项目才可以做实验 } else { parmList.Add("0"); } if (flag.Equals("2")) { PipeCheckconsignDetailEntitybindingSource1.Clear(); List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetail", new object[] { parmList, arrId,plineCodes, "2", isAll, status.ToArray() ,this.CustomInfo.ToString()}, this.ob); PipeCheckconsignDetailEntitybindingSource.DataSource = listSource; } else if (flag.Equals("3")) { PipeCheckconsignDetailEntitybindingSource4.Clear(); List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetail", new object[] { parmList, arrId, plineCodes, "3", isAll, status.ToArray(), this.CustomInfo.ToString() }, this.ob); RecordedSource.DataSource = listSource; } } /// /// 查询未审核数据 /// /// private void QueryCheckConsignBaseDetailNoFrim(string flag) { string startTim = ""; string endTim = ""; string checkNo = ""; string judgeNo = ""; string sampleNo = ""; string steelName = ""; string specName = ""; string orderNo = ""; string txtGroup = ""; string ispodutor = ""; string checkPhy = ""; ArrayList parmList = new ArrayList(); var status = new List { }; if (chkType.Checked) { status = cmbType.CheckedItems.Select(p => p.DataValue.ToString()).ToList(); if (!status.Any()) status = new List { "0", "1", "2", "3", "4", "5" }; } if (chkRegTime.Checked) { startTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (chkCheckNo.Checked && this.txtCheckNo.Text.Trim() != "") { checkNo = this.txtCheckNo.Text.Trim(); } if (chkJudgeNo.Checked && this.txtJudgeNo.Text != "") { judgeNo = this.txtJudgeNo.Text.Trim(); } if (chkSampleNo.Checked && this.txtSampleNo.Text.Trim() != "") { sampleNo = txtSampleNo.Text.Trim(); } if (chkOrderNo.Checked && this.txtOrderNo.Text != "") { orderNo = txtOrderNo.Text.Trim(); } if (chkSteel.Checked && this.txtSteel.Text.Trim() != "") { steelName = this.txtSteel.Text.Trim(); } if (chkSpec.Checked && this.txtSpec.Text.Trim() != "") { specName = this.txtSpec.Text.Trim(); } if (chkGroup.Checked && this.cmbGroup.Text != "") { txtGroup = this.cmbGroup.Value.ToString2(); } if (chkIsProuctor.Checked && this.cmbIsProductor.Text != "") { ispodutor = this.cmbIsProductor.Value.ToString2(); } checkPhy = ultraOptionSet1.CheckedItem.DataValue.ToString(); parmList.Add(startTim); parmList.Add(endTim); parmList.Add(checkNo); parmList.Add(judgeNo); parmList.Add(sampleNo); parmList.Add(orderNo); parmList.Add(steelName); parmList.Add(specName); parmList.Add(txtGroup); parmList.Add(ispodutor); parmList.Add(checkPhy); PipeCheckconsignDetailEntitybindingSource2.Clear(); List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailNoFrim", new object[] { parmList, arrId,plineCodes, status.ToArray() ,this.CustomInfo.ToString()}, this.ob); pipeCheckconsignDetailEntityBindingSource5.DataSource = listSource; foreach (UltraGridRow row in ultraGrid27.Rows) { if (int.Parse(row.Cells["heatNo"].Text.ToString3()) > 0) { row.RowSelectorAppearance.BackColor = Color.Red; ; } } } /// /// 查询已审核数据 /// /// private void QueryCheckConsignBaseDetailYesFrim(string flag) { string startTim = ""; string endTim = ""; string checkNo = ""; string judgeNo = ""; string sampleNo = ""; string steelName = ""; string specName = ""; string orderNo = ""; string txtGroup = ""; string ispodutor = ""; string checkPhy = ""; ArrayList parmList = new ArrayList(); var status = new List { }; if (chkType.Checked) { status = cmbType.CheckedItems.Select(p => p.DataValue.ToString()).ToList(); if (!status.Any()) status = new List { "0", "1", "2", "3", "4", "5" }; } if (chkRegTime.Checked) { startTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (chkCheckNo.Checked && this.txtCheckNo.Text.Trim() != "") { checkNo = this.txtCheckNo.Text.Trim(); } if (chkJudgeNo.Checked && this.txtJudgeNo.Text != "") { judgeNo = this.txtJudgeNo.Text.Trim(); } if (chkSampleNo.Checked && this.txtSampleNo.Text.Trim() != "") { sampleNo = txtSampleNo.Text.Trim(); } if (chkOrderNo.Checked && this.txtOrderNo.Text != "") { orderNo = txtOrderNo.Text.Trim(); } if (chkSteel.Checked && this.txtSteel.Text.Trim() != "") { steelName = this.txtSteel.Text.Trim(); } if (chkSpec.Checked && this.txtSpec.Text.Trim() != "") { specName = this.txtSpec.Text.Trim(); } if (chkGroup.Checked && this.cmbGroup.Text != "") { txtGroup = this.cmbGroup.Value.ToString2(); } if (chkIsProuctor.Checked && this.cmbIsProductor.Text != "") { ispodutor = this.cmbIsProductor.Value.ToString2(); } checkPhy = ultraOptionSet1.CheckedItem.DataValue.ToString(); parmList.Add(startTim); parmList.Add(endTim); parmList.Add(checkNo); parmList.Add(judgeNo); parmList.Add(sampleNo); parmList.Add(orderNo); parmList.Add(steelName); parmList.Add(specName); parmList.Add(txtGroup); parmList.Add(ispodutor); parmList.Add(checkPhy); PipeCheckconsignDetailEntitybindingSource3.Clear(); List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailFrim", new object[] { parmList, arrId,plineCodes, status.ToArray() }, this.ob); pipeCheckconsignDetailEntityBindingSource6.DataSource = listSource; foreach (UltraGridRow row in ultraGrid40.Rows) { if (int.Parse(row.Cells["Remark"].Text.ToString3()) > 0) { row.RowSelectorAppearance.BackColor = Color.GreenYellow; ; } if (int.Parse(row.Cells["heatNo"].Text.ToString3()) > 0) { row.RowSelectorAppearance.BackColor = Color.Red; ; } } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraGrid1.ActiveRow; List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailPHY", new object[] { uRow.Cells["CheckNo"].Value.ToString(), uRow.Cells["SampleNo"].Value.ToString(), "2", arrId, ultraOptionSet1.CheckedItem.DataValue.ToString2()}, this.ob); PipeCheckconsignDetailEntitybindingSource1.DataSource = listSource; } /// /// 加载试验设备 /// /// private void initCheckEqiupment(string phyCodeMax) { DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.initCheckEquipment", new object[] { arrId, phyCodeMax }, ob); if (dt != null && dt.Rows.Count > 0) { if (ultraTabControl1.SelectedTab.Key == "0") { ultraDEVICE_NAME.DataSource = dt; ultraDEVICE_NAME.ValueMember = "DEVICE_NO"; } else if (ultraTabControl1.SelectedTab.Key == "1") { ultraDEVICE_NAME1.DataSource = dt; ultraDEVICE_NAME1.ValueMember = "DEVICE_NO"; } } this.cmbChemOrder.Value = UserInfo.GetUserOrder(); this.cmbChemGroup.Value = UserInfo.GetUserGroup(); this.txtChemUser.Text = UserInfo.GetUserName(); } /// /// 加载试验方法 /// /// /// 试验标准 private void initCheckMethod(string phyCode,String text) { ultraComMethod.DataSource = null; ultraComMethod1.DataSource = null; DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.initCheckMethod", new object[] { phyCode, arrId }, ob); if (dt != null && dt.Rows.Count > 0) { if (!String.IsNullOrEmpty(text)) { bool falg = false;// 试验标准是否存在 for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Select()[i].ItemArray.Contains(text)) { falg = true; } } if (!falg) { dt.Rows.Add(text); } } if (ultraTabControl1.SelectedTab.Key == "0") { ultraComMethod.DataSource = dt; ultraComMethod.ValueMember = "CHECK_METHOD_NO"; ultraComMethod.Text = text; } else if (ultraTabControl1.SelectedTab.Key == "1") { ultraComMethod1.DataSource = dt; ultraComMethod1.ValueMember = "CHECK_METHOD_NO"; ultraComMethod1.Text = text; } } } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { ultraTabControl2.Visible = true; ultraTabControl3.Visible = false; ultraTabControl4.Visible = false; ultraTabControl5.Visible = false; UltraGridRow row = this.ultraGrid2.ActiveRow; initCheckMethod(row.Cells["PhyCodeMax"].Value.ToString(), row.Cells["checkStd"].Text);//根据试样组加载试验方法 initCheckEqiupment(row.Cells["PhyCodeMax"].Value.ToString());//根据试样组加载试验设备 List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailPhyItem", new object[] { row.Cells["CheckNo"].Value.ToString(), row.Cells["SampleNo"].Value.ToString(), row.Cells["PhyCodeMax"].Value.ToString() }, this.ob); if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0001"))//拉伸 { PipeCheckconsignPhydetailEntitybindingSource.DataSource = listSource; ultraTabControl2.Tabs["0"].Selected = true; ultraTabControl2.Tabs["0"].Visible = true; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = true; ultraLabel39.Visible = true; ultraLabel40.Visible = true; this.txtPHY_DIR.Visible = true; this.txtSAMPLE_TYPE.Visible = true; this.ultraSAMPLE_STYLE.Visible = true; txtSAMPLE_TYPE.Items.Clear(); txtSAMPLE_TYPE.Items.Add("S1"); txtSAMPLE_TYPE.Items.Add("S2"); txtSAMPLE_TYPE.Items.Add("S3"); txtSAMPLE_TYPE.Items.Add("S4"); txtSAMPLE_TYPE.Items.Add("S5"); txtSAMPLE_TYPE.Items.Add("S6"); txtSAMPLE_TYPE.Items.Add("R4"); txtSAMPLE_TYPE.Items.Add("R5"); txtSAMPLE_TYPE.Items.Add("bo=19.0mm Lo=50mm"); txtSAMPLE_TYPE.Items.Add("bo=25.4mm Lo=50mm"); txtSAMPLE_TYPE.Items.Add("bo=38.1mm Lo=50mm"); txtSAMPLE_TYPE.Items.Add("do=12.7mm Lo=50mm"); txtPHY_DIR.Items.Clear(); txtPHY_DIR.Items.Add("纵向"); txtPHY_DIR.Items.Add("横向"); this.txtPHY_DIR.Text = row.Cells["PhyDir"].Value.ToString(); this.txtSAMPLE_TYPE.Text = row.Cells["SampleType"].Value.ToString(); } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0002"))//冲击 { //if (listSource.Count<3) //{ // listSource.Add(new PipeCheckconsignPhydetailEntity() { PhyName = "剪切面积百分比" }); // listSource.Add(new PipeCheckconsignPhydetailEntity() { PhyName = "ak" }); // listSource.Add(new PipeCheckconsignPhydetailEntity() { PhyName = "膨胀量" }); //} PipeCheckconsignPhydetailEntityCjbindingSource.DataSource = listSource; ultraTabControl2.Tabs["1"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = true; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; ultraLabel37.Visible = true; ultraLabel39.Visible = true; this.txtPHY_DIR.Visible = true; this.txtSAMPLE_TYPE.Visible = true; txtSAMPLE_TYPE.Items.Clear(); txtSAMPLE_TYPE.Items.Add("10mm×10mm"); txtSAMPLE_TYPE.Items.Add("10mm×7.5mm"); txtSAMPLE_TYPE.Items.Add("10mm×6.7mm"); txtSAMPLE_TYPE.Items.Add("10mm×6.67mm"); txtSAMPLE_TYPE.Items.Add("10mm×5mm"); txtSAMPLE_TYPE.Items.Add("10mm×3.3mm"); txtSAMPLE_TYPE.Items.Add("10mm×3mm"); txtSAMPLE_TYPE.Items.Add("10mm×2.5mm"); txtPHY_DIR.Items.Clear(); txtPHY_DIR.Items.Add("纵向"); txtPHY_DIR.Items.Add("横向"); this.txtPHY_DIR.Text = row.Cells["PhyDir"].Value.ToString(); this.txtSAMPLE_TYPE.Text = row.Cells["SampleType"].Value.ToString(); //ultraLabel1.Text = "试验温度"; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0003"))//布氏 { cmbStdSteelType.Items.Clear(); ultraComFormual.Items.Clear(); PipeCheckconsignPhydetailEntityBSbindingSource.DataSource = listSource; MergedCell(ultraGrid6, new string[] { "PhyName" }); ultraTabControl2.Tabs["4"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = true; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = true; this.ultraComFormual.Visible = true; this.cmbStdSteelType.Visible = true; this.txtStdSteelNo.Visible = true; this.txtStdSteelValue.Visible = true; this.txtActualValue.Visible = true; ultraLabel46.Visible = true; ultraLabel48.Visible = true; ultraLabel47.Visible = true; ultraLabel49.Visible = true; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; ultraComFormual.Items.Clear(); cmbStdSteelType.Items.Clear(); if (this.UserInfo.GetDeptid().Equals("002001007009")) { ultraComFormual.Items.Add("HBW2.5"); ultraComFormual.Items.Add("HBW5"); ultraComFormual.Items.Add("HBW10"); cmbStdSteelType.Items.Add("HBW2.5/187.5"); cmbStdSteelType.Items.Add("HBW 5/750"); cmbStdSteelType.Items.Add("HBW 10/1000"); } else { ultraComFormual.Items.Add("HBW 2.5/187.5"); ultraComFormual.Items.Add("HBW 5/750"); ultraComFormual.Items.Add("HBW 10/3000"); cmbStdSteelType.Items.Add("HBW 2.5/187.5"); cmbStdSteelType.Items.Add("HBW 5/750"); cmbStdSteelType.Items.Add("HBW 10/3000"); } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0004") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0018"))//洛氏 { cmbStdSteelType.Items.Clear(); PipeCheckconsignPhydetailEntityLSbindingSource.DataSource = listSource; MergedCell(ultraGrid5, new string[] { "PhyName" }); ultraTabControl2.Tabs["2"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = true; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = true; this.txtStdSteelNo.Visible = true; this.txtStdSteelValue.Visible = true; this.txtActualValue.Visible = true; ultraLabel46.Visible = true; ultraLabel48.Visible = true; ultraLabel47.Visible = true; ultraLabel49.Visible = true; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; cmbStdSteelType.Items.Clear(); cmbStdSteelType.Items.Add("HRA"); cmbStdSteelType.Items.Add("HRB"); cmbStdSteelType.Items.Add("HRC"); } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0005"))//维氏 { ultraComFormual.Items.Clear(); cmbStdSteelType.Items.Clear(); PipeCheckconsignPhydetailEntityWSbindingSource.DataSource = listSource; MergedCell(ultraGrid5, new string[] { "PhyName" }); ultraTabControl2.Tabs["3"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = true; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = true; this.ultraComFormual.Visible = true; this.cmbStdSteelType.Visible = true; this.txtStdSteelNo.Visible = true; this.txtStdSteelValue.Visible = true; this.txtActualValue.Visible = true; ultraLabel46.Visible = true; ultraLabel48.Visible = true; ultraLabel47.Visible = true; ultraLabel49.Visible = true; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; ultraComFormual.Items.Clear(); ultraComFormual.Items.Add("HV5"); ultraComFormual.Items.Add("HV10"); cmbStdSteelType.Items.Clear(); cmbStdSteelType.Items.Add("HV5"); cmbStdSteelType.Items.Add("HV10"); cmbStdSteelType.Items.Add("HV0.2"); } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0014") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0016") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0031"))//组织 { PipeCheckconsignPhydetailEntityZZbindingSource.DataSource = listSource; ultraTabControl2.Tabs["7"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = true; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0013"))//晶粒度 { PipeCheckconsignPhydetailEntityJLDbindingSource.DataSource = listSource; ultraTabControl2.Tabs["6"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = true; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0012"))//夹杂 { PipeCheckconsignPhydetailEntityJZWbindingSource.DataSource = listSource; ultraTabControl2.Tabs["5"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = true; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; ultraGrid8.DisplayLayout.Bands[0].Columns["Value1"].Header.Caption = "一象限"; ultraGrid8.DisplayLayout.Bands[0].Columns["Value2"].Header.Caption = "二象限"; ultraGrid8.DisplayLayout.Bands[0].Columns["Value3"].Header.Caption = "三象限"; ultraGrid8.DisplayLayout.Bands[0].Columns["Value4"].Header.Caption = "四象限"; if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0115")) { ultraGrid8.DisplayLayout.Bands[0].Columns["Value2"].Hidden = false; ultraGrid8.DisplayLayout.Bands[0].Columns["Value3"].Hidden = false; ultraGrid8.DisplayLayout.Bands[0].Columns["Value4"].Hidden = false; } else { ultraGrid8.DisplayLayout.Bands[0].Columns["Value2"].Hidden = true; ultraGrid8.DisplayLayout.Bands[0].Columns["Value3"].Hidden = true; ultraGrid8.DisplayLayout.Bands[0].Columns["Value4"].Hidden = true; } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0010"))//工艺 { if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0027") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0038") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0082") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0083") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0098"))//弯曲 { PipeCheckconsignPhydetailEntityWQbindingSource.DataSource = listSource; ultraTabControl2.Tabs["9"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = true; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; } else if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0009"))//压扁 { TxtYbEuestion.Text = ""; TxtYbD.Text = ""; TxtYbS.Text = ""; TxtYbC.Text = ""; TxtYbSpac.Text = ""; TxtYbQualfiled.Text = ""; TxtYbDefect.Text = ""; TxtYbMemo.Text = ""; PipeCheckconsignPhydetailEntityYBbindingSource.DataSource = listSource; ultraTabControl2.Tabs["8"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = true; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; int x = row.Cells["SpecName"].Text.IndexOf('x'); TxtYbD.Text = row.Cells["SpecName"].Text.Substring(0,x); TxtYbS.Text = row.Cells["SpecName"].Text.Substring(x + 1); ultraGrid13.DisplayLayout.Bands[0].Columns["IsGood"].Header.Caption = "试验结果(一次)"; ultraGrid13.DisplayLayout.Bands[0].Columns["IsDefect"].Header.Caption = "试验结果(二次)"; } else if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0026"))//扩口 { PipeCheckconsignPhydetailEntityKKbindingSource.DataSource = listSource; ultraTabControl2.Tabs["10"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = true; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = false; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0050") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0060"))//断裂力学试验,大应变试验 { pipeCheckconsignPhydetailEntityQTBindingSource.DataSource = listSource; ultraTabControl2.Tabs["11"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = true; ultraTabControl2.Tabs["12"].Visible = false; ultraGrid53.DisplayLayout.Bands[0].Columns["AverageValue"].Header.Caption = "最小值"; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = false; ultraLabel39.Visible = false; this.txtPHY_DIR.Visible = false; this.txtSAMPLE_TYPE.Visible = false; ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0057") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0066"))//落锤试验 { PipeCheckconsignDetailEntityLCbindingSource.DataSource = listSource; ultraTabControl2.Tabs["12"].Selected = true; ultraTabControl2.Tabs["0"].Visible = false; ultraTabControl2.Tabs["1"].Visible = false; ultraTabControl2.Tabs["2"].Visible = false; ultraTabControl2.Tabs["3"].Visible = false; ultraTabControl2.Tabs["4"].Visible = false; ultraTabControl2.Tabs["5"].Visible = false; ultraTabControl2.Tabs["6"].Visible = false; ultraTabControl2.Tabs["7"].Visible = false; ultraTabControl2.Tabs["8"].Visible = false; ultraTabControl2.Tabs["9"].Visible = false; ultraTabControl2.Tabs["10"].Visible = false; ultraTabControl2.Tabs["11"].Visible = false; ultraTabControl2.Tabs["12"].Visible = true; //ultraGrid53.DisplayLayout.Bands[0].Columns["AverageValue"].Header.Caption = "最小值"; this.ultraLabel36.Visible = false; this.ultraComFormual.Visible = false; this.cmbStdSteelType.Visible = false; this.txtStdSteelNo.Visible = false; this.txtStdSteelValue.Visible = false; this.txtActualValue.Visible = false; ultraLabel46.Visible = false; ultraLabel48.Visible = false; ultraLabel47.Visible = false; ultraLabel49.Visible = false; ultraLabel37.Visible = true; ultraLabel39.Visible = true; this.txtPHY_DIR.Visible = true; txtPHY_DIR.Items.Clear(); txtPHY_DIR.Items.Add("纵向"); txtPHY_DIR.Items.Add("横向"); this.txtPHY_DIR.Text = row.Cells["PhyDir"].Value.ToString(); this.txtSAMPLE_TYPE.Visible = true; txtSAMPLE_TYPE.Items.Clear(); string specName = row.Cells["SpecName"].Text.Trim();//规格 if (!specName.Equals("")) { int x = specName.IndexOf("x");//x位置 string width = specName.Substring(0, x); string height = specName.Substring(x + 1); txtSAMPLE_TYPE.Items.Add("305*76.2*" + height); } txtSAMPLE_TYPE.Items.Add("305*76.2*19"); ultraLabel40.Visible = false; this.ultraSAMPLE_STYLE.Visible = false; } } /// /// 合并单元格 /// /// /// private void MergedCell(UltraGrid ug, string[] columnKeys) { if (columnKeys.Length == 0) { return; } ug.DisplayLayout.Override.MergedCellStyle = MergedCellStyle.Never; for (int i = 0; i < columnKeys.Length; i++) { ug.DisplayLayout.Bands[0].Columns[columnKeys[i]].MergedCellStyle = MergedCellStyle.Always; } } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if (ultraTabControl1.SelectedTab.Index == 0) { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryRecord")) { toolMenu.Toolbars[0].Tools["QueryRecord"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Audit")) { toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit")) { toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit")) { toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit")) { toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintMechanics")) { toolMenu.Toolbars[0].Tools["PrintMechanics"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpFile")) { toolMenu.Toolbars[0].Tools["UpFile"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpPicture")) { toolMenu.Toolbars[0].Tools["UpPicture"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintPicture")) { toolMenu.Toolbars[0].Tools["PrintPicture"].InstanceProps.Visible = DefaultableBoolean.False; } ultraOptionSet1.Visible = true; chkRegTime.Text = "收样日期"; this.chkPrintK.Visible = true; this.cmbPrintK.Visible = true; } else if (ultraTabControl1.SelectedTab.Index == 1) { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryRecord")) { toolMenu.Toolbars[0].Tools["QueryRecord"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Audit")) { toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit")) { toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit")) { toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit")) { toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintMechanics")) { toolMenu.Toolbars[0].Tools["PrintMechanics"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpFile")) { toolMenu.Toolbars[0].Tools["UpFile"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpPicture")) { toolMenu.Toolbars[0].Tools["UpPicture"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintPicture")) { toolMenu.Toolbars[0].Tools["PrintPicture"].InstanceProps.Visible = DefaultableBoolean.False; } ultraOptionSet1.Visible = true; chkRegTime.Text = "收样日期"; this.chkPrintK.Visible = true; this.cmbPrintK.Visible = true; } else if (ultraTabControl1.SelectedTab.Index == 2) { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryRecord")) { toolMenu.Toolbars[0].Tools["QueryRecord"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Audit")) { toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit")) { toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit")) { toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit")) { toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintMechanics")) { toolMenu.Toolbars[0].Tools["PrintMechanics"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpFile")) { toolMenu.Toolbars[0].Tools["UpFile"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpPicture")) { toolMenu.Toolbars[0].Tools["UpPicture"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintPicture")) { toolMenu.Toolbars[0].Tools["PrintPicture"].InstanceProps.Visible = DefaultableBoolean.False; } this.chkPrintK.Visible = false; this.cmbPrintK.Visible = false; //ultraOptionSet1.Visible = false; chkRegTime.Text = "录入日期"; } else if (ultraTabControl1.SelectedTab.Index == 3) { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryRecord")) { toolMenu.Toolbars[0].Tools["QueryRecord"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Audit")) { toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit")) { toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit")) { toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit")) { toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("PrintMechanics")) { toolMenu.Toolbars[0].Tools["PrintMechanics"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("UpFile")) { toolMenu.Toolbars[0].Tools["UpFile"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("UpPicture")) { toolMenu.Toolbars[0].Tools["UpPicture"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("PrintPicture")) { toolMenu.Toolbars[0].Tools["PrintPicture"].InstanceProps.Visible = DefaultableBoolean.True; } //ultraOptionSet1.Visible = false; this.chkPrintK.Visible = true; this.cmbPrintK.Visible = true; chkRegTime.Text = "审核日期"; } } private void FrmLabMecDataCJAuditMJ_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Audit")) { toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit")) { toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit")) { toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit")) { toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintMechanics")) { toolMenu.Toolbars[0].Tools["PrintMechanics"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpFile")) { toolMenu.Toolbars[0].Tools["UpFile"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpPicture")) { toolMenu.Toolbars[0].Tools["UpPicture"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintPicture")) { toolMenu.Toolbars[0].Tools["PrintPicture"].InstanceProps.Visible = DefaultableBoolean.False; } this.chkPrintK.Visible = true; this.cmbPrintK.Visible = true; } private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { UltraGridRow uRow = this.ultraGrid2.ActiveRow; if (uRow.Cells["CraftFileNo"].Text.Trim() == "" || uRow.Cells["CraftPath"].Text.Trim() == "") { return; } PublicPipeAndOutdec.ViewCarft_No(uRow.Cells["CraftPath"].Text.Trim()); } private void ultraTextEditor3_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { UltraGridRow uRow = this.ultraGrid15.ActiveRow; if (uRow.Cells["CraftFileNo"].Text.Trim() == "" || uRow.Cells["CraftPath"].Text.Trim() == "") { return; } PublicPipeAndOutdec.ViewCarft_No(uRow.Cells["CraftPath"].Text.Trim()); } private void ultraTextEditor4_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { UltraGridRow uRow = this.ultraGrid28.ActiveRow; if (uRow.Cells["CraftFileNo"].Text.Trim() == "" || uRow.Cells["CraftPath"].Text.Trim() == "") { return; } PublicPipeAndOutdec.ViewCarft_No(uRow.Cells["CraftPath"].Text.Trim()); } private void ultraTextEditor5_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { UltraGridRow uRow = this.ultraGrid41.ActiveRow; if (uRow.Cells["CraftFileNo"].Text.Trim() == "" || uRow.Cells["CraftPath"].Text.Trim() == "") { return; } PublicPipeAndOutdec.ViewCarft_No(uRow.Cells["CraftPath"].Text.Trim()); } private void ultraGrid4_CellChange(object sender, CellEventArgs e) { this.ultraGrid4.UpdateData(); UltraGridRow ur = this.ultraGrid4.ActiveRow; UltraGridRow uRow = this.ultraGrid2.ActiveRow; string specName = uRow.Cells["ItemNameS"].Text.Trim();//试验尺寸 int x = specName.IndexOf("×");//x位置 string width = specName.Substring(0, x).Replace("m",""); string height = specName.Substring(x + 1).Replace("m",""); int m = 1; string ak1 = "";//真实值 string ak2 = ""; string ak3 = ""; int akNum = 0; foreach(UltraGridRow row in this.ultraGrid4.Rows) { m = 1; if (row.Cells["PhyName"].Text.Contains("侧膨胀值")) { //akNum = akNum + 1; if (e.Cell.Column.Key == "Value1") { if (row.Cells["Value2"].Text != "") { m = m + 1; } if (row.Cells["Value3"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3()) + double.Parse(row.Cells["Value3"].Text.ToString3())) / m), 2).ToString(); } if (e.Cell.Column.Key == "Value2") { if (row.Cells["Value1"].Text != "") { m = m + 1; } if (row.Cells["Value3"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3()) + double.Parse(row.Cells["Value3"].Text.ToString3())) / m), 2).ToString(); } if (e.Cell.Column.Key == "Value3") { if (row.Cells["Value1"].Text != "") { m = m + 1; } if (row.Cells["Value2"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3()) + double.Parse(row.Cells["Value3"].Text.ToString3())) / m), 2).ToString(); } } else { if (e.Cell.Column.Key == "Value1") { if (row.Cells["Value2"].Text != "") { m = m + 1; } if (row.Cells["Value3"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3()) + double.Parse(row.Cells["Value3"].Text.ToString3())) / m)).ToString(); } if (e.Cell.Column.Key == "Value2") { if (row.Cells["Value1"].Text != "") { m = m + 1; } if (row.Cells["Value3"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3()) + double.Parse(row.Cells["Value3"].Text.ToString3())) / m)).ToString(); } if (e.Cell.Column.Key == "Value3") { if (row.Cells["Value1"].Text != "") { m = m + 1; } if (row.Cells["Value2"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3()) + double.Parse(row.Cells["Value3"].Text.ToString3())) / m)).ToString(); } } } //if (akNum > 0 && ur.Cells["PhyName"].Text.Contains("侧膨胀值")) //{ // if (e.Cell.Column.Key == "Value1") // { // if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value1"].Value.ToString3())) return; // ak1 = (Math.Round(100 * double.Parse(ur.Cells["Value1"].Text.Trim().ToString3()) / (double.Parse(width) * (double.Parse(height) - 2)), 0)).ToString(); // foreach (UltraGridRow akRow in this.ultraGrid4.Rows) // { // //if (akRow.Cells["PhyName"].Text.Contains("ak")) // //{ // // akRow.Cells["Value1"].Value = ak1; // if (akRow.Cells["Value2"].Text != "") // { // m = m + 1; // } // if (akRow.Cells["Value3"].Text != "") // { // m = m + 1; // } // m = m + 1; // akRow.Cells["AverageValue"].Value = Math.Round(((double.Parse(akRow.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(akRow.Cells["Value2"].Text.ToString3()) + double.Parse(akRow.Cells["Value3"].Text.ToString3())) / m), 2).ToString(); // //} // } // } // if (e.Cell.Column.Key == "Value2") // { // if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value2"].Value.ToString3())) return; // ak2 = (Math.Round(100 * double.Parse(ur.Cells["Value2"].Text.Trim().ToString3()) / (double.Parse(width) * (double.Parse(height) - 2)), 0)).ToString(); // foreach (UltraGridRow akRow in this.ultraGrid4.Rows) // { // //if (akRow.Cells["PhyName"].Text.Contains("ak")) // //{ // // akRow.Cells["Value2"].Value = ak2; // if (ur.Cells["Value1"].Text != "") // { // m = m + 1; // } // if (ur.Cells["Value3"].Text != "") // { // m = m + 1; // } // m = m + 1; // akRow.Cells["AverageValue"].Value = Math.Round(((double.Parse(akRow.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(akRow.Cells["Value2"].Text.ToString3()) + double.Parse(akRow.Cells["Value3"].Text.ToString3())) / m), 2).ToString(); // //} // } // } // if (e.Cell.Column.Key == "Value3") // { // if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value3"].Value.ToString3())) return; // ak3 = (Math.Round(100 * double.Parse(ur.Cells["Value3"].Text.Trim().ToString3()) / (double.Parse(width) * (double.Parse(height) - 2)), 0)).ToString(); // foreach (UltraGridRow akRow in this.ultraGrid4.Rows) // { // //if (akRow.Cells["PhyName"].Text.Contains("ak")) // //{ // // akRow.Cells["Value3"].Value = ak3; // if (akRow.Cells["Value1"].Text != "") // { // m = m + 1; // } // if (akRow.Cells["Value2"].Text != "") // { // m = m + 1; // } // m = m + 1; // akRow.Cells["AverageValue"].Value = Math.Round(((double.Parse(akRow.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(akRow.Cells["Value2"].Text.ToString3()) + double.Parse(akRow.Cells["Value3"].Text.ToString3())) / m), 2).ToString(); // //} // } // } //} //else //{ // if (e.Cell.Column.Key == "Value1" || e.Cell.Column.Key == "Value2" || e.Cell.Column.Key == "Value3") // { // if (ur.Cells["Value1"].Text != "") // { // m = m + 1; // } // if (ur.Cells["Value2"].Text != "") // { // m = m + 1; // } // if (ur.Cells["Value3"].Text != "") // { // m = m + 1; // } // ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(ur.Cells["Value2"].Text.Trim().ToString3()) + double.Parse(ur.Cells["Value3"].Text.Trim().ToString3())) / m)).ToString(); // } //} } private void ultraGrid5_CellChange(object sender, CellEventArgs e) { this.ultraGrid5.UpdateData(); UltraGridRow ur = this.ultraGrid5.ActiveRow; int m = 0; if (e.Cell.Column.Key == "Value1" || e.Cell.Column.Key == "Value2" || e.Cell.Column.Key == "Value3" || e.Cell.Column.Key == "Value4") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value2"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value3"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value4"].Value.ToString3())) { return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3())) / m), 1).ToString(); } } private void ultraGrid7_CellChange(object sender, CellEventArgs e) { this.ultraGrid7.UpdateData(); UltraGridRow ur = this.ultraGrid7.ActiveRow; int m = 0; string comFormual = this.ultraComFormual.Text.Trim(); if (e.Cell.Column.Key == "Value1D1" || e.Cell.Column.Key == "Value1D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value1D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value1D2"].Value.ToString3())) { return; } if (comFormual.Equals("HV5")) { ur.Cells["Value1"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3()))/2,2),0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value1"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3()) + double.Parse(ur.Cells["Value5"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value2D1" || e.Cell.Column.Key == "Value2D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value2D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value2D2"].Value.ToString3())) { return; } if (comFormual.Equals("HV5")) { ur.Cells["Value2"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value2"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3()) + double.Parse(ur.Cells["Value5"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value3D1" || e.Cell.Column.Key == "Value3D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value3D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value3D2"].Value.ToString3())) { return; } if (comFormual.Equals("HV5")) { ur.Cells["Value3"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value3"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3()) + double.Parse(ur.Cells["Value5"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value4D1" || e.Cell.Column.Key == "Value4D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value4D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value4D2"].Value.ToString3())) { return; } if (comFormual.Equals("HV5")) { ur.Cells["Value4"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value4D1"].Text.ToString3()) + double.Parse(ur.Cells["Value4D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value4"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value4D1"].Text.ToString3()) + double.Parse(ur.Cells["Value4D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3()) + double.Parse(ur.Cells["Value5"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value5D1" || e.Cell.Column.Key == "Value5D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value5D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value5D2"].Value.ToString3())) { return; } if (comFormual.Equals("HV5")) { ur.Cells["Value5"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value5D1"].Text.ToString3()) + double.Parse(ur.Cells["Value5D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value5"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value5D1"].Text.ToString3()) + double.Parse(ur.Cells["Value5D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3()) + double.Parse(ur.Cells["Value5"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value1" || e.Cell.Column.Key == "Value2" || e.Cell.Column.Key == "Value3" || e.Cell.Column.Key == "Value4" || e.Cell.Column.Key == "Value5") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value2"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value3"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value4"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value5"].Value.ToString3())) { return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3()) + double.Parse(ur.Cells["Value5"].Text.ToString3())) / m), 0).ToString(); } } private void ultraGrid6_CellChange(object sender, CellEventArgs e) { this.ultraGrid6.UpdateData(); UltraGridRow ur = this.ultraGrid6.ActiveRow; int m = 0; string comFormual = this.ultraComFormual.Text.Trim(); if (e.Cell.Column.Key == "Value1D1" || e.Cell.Column.Key == "Value1D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value1D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value1D2"].Value.ToString3())) { return; } if (comFormual.Equals("HBW2.5")) { ur.Cells["Value1"].Value = (Math.Round(0.102 * 2 * 1838.75 / (2.5 * 3.142 * (2.5 - Math.Sqrt(6.25 - Math.Pow(double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW5")) { ur.Cells["Value1"].Value = (Math.Round(0.102 * 2 * 7355 / (5 * 3.142 * (5 - Math.Sqrt(25 - Math.Pow(double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW10")) { ur.Cells["Value1"].Value = (Math.Round(0.102 * 2 * 29420 / (10 * 3.142 * (10 - Math.Sqrt(100 - Math.Pow(double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value2D1" || e.Cell.Column.Key == "Value2D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value2D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value2D2"].Value.ToString3())) { return; } if (comFormual.Equals("HBW2.5")) { ur.Cells["Value2"].Value = (Math.Round(0.102 * 2 * 1838.75 / (2.5 * 3.142 * (2.5 - Math.Sqrt(6.25 - Math.Pow(double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW5")) { ur.Cells["Value2"].Value = (Math.Round(0.102 * 2 * 7355 / (5 * 3.142 * (5 - Math.Sqrt(25 - Math.Pow(double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW10")) { ur.Cells["Value2"].Value = (Math.Round(0.102 * 2 * 29420 / (10 * 3.142 * (10 - Math.Sqrt(100 - Math.Pow(double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value3D1" || e.Cell.Column.Key == "Value3D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value3D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value3D2"].Value.ToString3())) { return; } if (comFormual.Equals("HBW2.5")) { ur.Cells["Value3"].Value = (Math.Round(0.102 * 2 * 1838.75 / (2.5 * 3.142 * (2.5 - Math.Sqrt(6.25 - Math.Pow(double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW5")) { ur.Cells["Value3"].Value = (Math.Round(0.102 * 2 * 7355 / (5 * 3.142 * (5 - Math.Sqrt(25 - Math.Pow(double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW10")) { ur.Cells["Value3"].Value = (Math.Round(0.102 * 2 * 29420 / (10 * 3.142 * (10 - Math.Sqrt(100 - Math.Pow(double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if(ur.Cells["Value4"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value4D1" || e.Cell.Column.Key == "Value4D2") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value4D1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value4D2"].Value.ToString3())) { return; } if (comFormual.Equals("HBW2.5")) { ur.Cells["Value4"].Value = (Math.Round(0.102 * 2 * 1838.75 / (2.5 * 3.142 * (2.5 - Math.Sqrt(6.25 - Math.Pow(double.Parse(ur.Cells["Value4D1"].Text.ToString3()) + double.Parse(ur.Cells["Value4D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW5")) { ur.Cells["Value4"].Value = (Math.Round(0.102 * 2 * 7355 / (5 * 3.142 * (5 - Math.Sqrt(25 - Math.Pow(double.Parse(ur.Cells["Value4D1"].Text.ToString3()) + double.Parse(ur.Cells["Value4D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW10")) { ur.Cells["Value4"].Value = (Math.Round(0.102 * 2 * 29420 / (10 * 3.142 * (10 - Math.Sqrt(100 - Math.Pow(double.Parse(ur.Cells["Value4D1"].Text.ToString3()) + double.Parse(ur.Cells["Value4D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value1" || e.Cell.Column.Key == "Value2" || e.Cell.Column.Key == "Value3" || e.Cell.Column.Key == "Value4") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value2"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value3"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value4"].Value.ToString3())) { return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.ToString3()) + double.Parse(ur.Cells["Value2"].Text.ToString3()) + double.Parse(ur.Cells["Value3"].Text.ToString3()) + double.Parse(ur.Cells["Value4"].Text.ToString3())) / m), 0).ToString(); } } private void ultraButton1_Click(object sender, EventArgs e) { if (this.TxtYbEuestion.Text.Trim() == "") { MessageUtil.ShowTips("请选择计算公式!"); return; } double d = 0.0; double c = 0.0; double t = 0.0; if(this.TxtYbEuestion.Text.Trim() == "0.65*D" || this.TxtYbEuestion.Text.Trim() == "7*D/8" ||this.TxtYbEuestion.Text.Trim() == "2*D/3") { if(this.TxtYbD.Text.Trim() == "") { MessageUtil.ShowTips("请输入管子公称外径!"); return; } }else if(this.TxtYbEuestion.Text.Trim() == "(1+C)*T/(C+T/D)") { if(this.TxtYbD.Text.Trim() == "" || this.TxtYbC.Text.Trim() == "" || this.TxtYbS.Text.Trim() == "") { MessageUtil.ShowTips("请输入管子的公称外径壁厚以及压扁系数!"); return; } } d = double.Parse(this.TxtYbD.Text.Trim().ToString3()); t = double.Parse(this.TxtYbS.Text.Trim().ToString3()); c = double.Parse(this.TxtYbC.Text.Trim().ToString3()); if (this.TxtYbEuestion.Text.Trim() == "0.65*D") { this.TxtYbSpac.Text = Math.Ceiling((0.65 * d)).ToString(); } else if (this.TxtYbEuestion.Text.Trim() == "7*D/8") { this.TxtYbSpac.Text = Math.Ceiling(((7 * d) / 8)).ToString(); } else if (this.TxtYbEuestion.Text.Trim() == "2*D/3") { this.TxtYbSpac.Text = Math.Ceiling(((2 * d) / 3)).ToString(); } else if (this.TxtYbEuestion.Text.Trim() == "(1+C)*T/(C+T/D)") { this.TxtYbSpac.Text = Math.Floor((((1 + c) * t) / (c + t / d))).ToString(); } } /** * 验证字符串 如：1<2 * * @param strA * 数字字符串 * @param sign * 符号 * @param strB * 数字字符串 * @return true Or false */ private bool checkStr(string strA, string sign, string strB) { if (strA.Length == 0 || strB.Length == 0) { return true; } if (!StringUtil.IsDouble(strB) || !StringUtil.IsDouble(strA)) { return true; } double a = double.Parse(strA); double b = double.Parse(strB); if (sign.Equals("=")) { if (a == b) { return true; } else { return false; } } if (sign.Equals(">")) { if (a > b) { return true; } else { return false; } } if (sign.Equals(">=")) { if (a >= b) { return true; } else { return false; } } if (sign.Equals("<")) { if (a < b) { return true; } else { return false; } } if (sign.Equals("<=")) { if (a <= b) { return true; } else { return false; } } return false; } private void ultraGrid15_AfterRowActivate(object sender, EventArgs e) { ultraTabControl3.Visible = true; ultraTabControl4.Visible = false; ultraTabControl5.Visible = false; ultraTabControl2.Visible = false; UltraGridRow row = this.ultraGrid15.ActiveRow; if (row == null) return; initCheckMethod(row.Cells["PhyCodeMax"].Value.ToString(), row.Cells["checkStd"].Text);//根据试样组加载试验方法 initCheckEqiupment(row.Cells["PhyCodeMax"].Value.ToString());//根据试样组加载试验设备 List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailPhyItem", new object[] { row.Cells["CheckNo"].Value.ToString(), row.Cells["SampleNo"].Value.ToString(), row.Cells["PhyCodeMax"].Value.ToString() }, this.ob); if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0001"))//拉伸 { PipeCheckconsignPhydetailEntitybindingSource.DataSource = listSource; foreach (UltraGridRow forRow in ultraGrid16.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["0"].Selected = true; ultraTabControl3.Tabs["0"].Visible = true; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0002"))//冲击 { PipeCheckconsignPhydetailEntityCjbindingSource.DataSource = listSource; foreach (UltraGridRow forRow in ultraGrid17.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["1"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = true; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0003"))//布氏 { ultraComFormual1.Items.Clear(); cmbStdSteelType1.Items.Clear(); PipeCheckconsignPhydetailEntityBSbindingSource.DataSource = listSource; MergedCell(ultraGrid6, new string[] { "PhyName" }); foreach (UltraGridRow forRow in ultraGrid20.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["4"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = true; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = true; this.cmbStdSteelType1.Visible = true; this.txtStdSteelNo1.Visible = true; this.txtStdSteelValue1.Visible = true; this.txtActualValue1.Visible = true; ultraLabel59.Visible = true; ultraLabel53.Visible = true; ultraLabel52.Visible = true; ultraLabel51.Visible = true; ultraLabel50.Visible = true; if (this.UserInfo.GetDeptid().Equals("002001007009")) { ultraComFormual1.Items.Add("HBW2.5"); ultraComFormual1.Items.Add("HBW5"); ultraComFormual1.Items.Add("HBW10"); cmbStdSteelType1.Items.Add("HBW2.5/187.5"); cmbStdSteelType1.Items.Add("HBW 5/750"); cmbStdSteelType1.Items.Add("HBW 10/1000"); } else { ultraComFormual1.Items.Add("HBW 2.5/187.5"); ultraComFormual1.Items.Add("HBW 5/750"); ultraComFormual1.Items.Add("HBW 10/3000"); cmbStdSteelType1.Items.Add("HBW 2.5/187.5"); cmbStdSteelType1.Items.Add("HBW 5/750"); cmbStdSteelType1.Items.Add("HBW 10/3000"); } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0004") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0018"))//洛氏 { cmbStdSteelType1.Items.Clear(); PipeCheckconsignPhydetailEntityLSbindingSource.DataSource = listSource; MergedCell(ultraGrid5, new string[] { "PhyName" }); foreach (UltraGridRow forRow in ultraGrid18.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["2"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = true; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = true; this.txtStdSteelNo1.Visible = true; this.txtStdSteelValue1.Visible = true; this.txtActualValue1.Visible = true; ultraLabel59.Visible = false; ultraLabel53.Visible = true; ultraLabel52.Visible = true; ultraLabel51.Visible = true; ultraLabel50.Visible = true; cmbStdSteelType1.Items.Add("HRA"); cmbStdSteelType1.Items.Add("HRB"); cmbStdSteelType1.Items.Add("HRC"); } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0005"))//维氏 { ultraComFormual1.Items.Clear(); cmbStdSteelType1.Items.Clear(); PipeCheckconsignPhydetailEntityWSbindingSource.DataSource = listSource; MergedCell(ultraGrid5, new string[] { "PhyName" }); foreach (UltraGridRow forRow in ultraGrid19.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value5"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value5"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["3"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = true; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = true; this.cmbStdSteelType1.Visible = true; this.txtStdSteelNo1.Visible = true; this.txtStdSteelValue1.Visible = true; this.txtActualValue1.Visible = true; ultraLabel59.Visible = true; ultraLabel53.Visible = true; ultraLabel52.Visible = true; ultraLabel51.Visible = true; ultraLabel50.Visible = true; ultraComFormual1.Items.Add("HV5"); ultraComFormual1.Items.Add("HV10"); cmbStdSteelType1.Items.Add("HV5"); cmbStdSteelType1.Items.Add("HV10"); cmbStdSteelType1.Items.Add("HV0.2"); } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0014") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0016") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0031"))//组织 { PipeCheckconsignPhydetailEntityZZbindingSource.DataSource = listSource; foreach (UltraGridRow forRow in ultraGrid23.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["7"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = true; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0013"))//晶粒度 { PipeCheckconsignPhydetailEntityJLDbindingSource.DataSource = listSource; foreach (UltraGridRow forRow in ultraGrid22.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["6"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = true; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = true; this.txtStdSteelNo1.Visible = true; this.txtStdSteelValue1.Visible = true; this.txtActualValue1.Visible = true; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0012"))//夹杂 { PipeCheckconsignPhydetailEntityJZWbindingSource.DataSource = listSource; foreach (UltraGridRow forRow in ultraGrid21.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["PhyCode"].Text.ToString().Equals("P0618") || forRow.Cells["PhyCode"].Text.ToString().Equals("P0619")) { if (!forRow.Cells["Value1"].Text.ToString().Equals("是") && !forRow.Cells["Value1"].Text.ToString().Equals("否")) { forRow.RowSelectorAppearance.BackColor = Color.Red; ; } } } ultraTabControl3.Tabs["5"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = true; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; ultraGrid21.DisplayLayout.Bands[0].Columns["Value1"].Header.Caption = "一象限"; ultraGrid21.DisplayLayout.Bands[0].Columns["Value2"].Header.Caption = "二象限"; ultraGrid21.DisplayLayout.Bands[0].Columns["Value3"].Header.Caption = "三象限"; ultraGrid21.DisplayLayout.Bands[0].Columns["Value4"].Header.Caption = "四象限"; if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0115")) { ultraGrid21.DisplayLayout.Bands[0].Columns["Value2"].Hidden = false; ultraGrid21.DisplayLayout.Bands[0].Columns["Value3"].Hidden = false; ultraGrid21.DisplayLayout.Bands[0].Columns["Value4"].Hidden = false; } else { ultraGrid21.DisplayLayout.Bands[0].Columns["Value2"].Hidden = true; ultraGrid21.DisplayLayout.Bands[0].Columns["Value3"].Hidden = true; ultraGrid21.DisplayLayout.Bands[0].Columns["Value4"].Hidden = true; } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0010"))//工艺 { if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0027") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0038") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0082") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0083") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0098"))//弯曲 { PipeCheckconsignPhydetailEntityWQbindingSource.DataSource = listSource; ultraTabControl3.Tabs["9"].Selected = true; for (int i = 0; i < ultraGrid25.Rows.Count; i++) { if (this.ultraGrid25.Rows[i].Cells["IsGood"].Text == "不符合") { ultraGrid25.Rows[i].RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = true; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; } else if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0009"))//压扁 { ultraTxtYbEuestion.Text = ""; ultraTxtYbD.Text = ""; ultraTxtYbS.Text = ""; ultraTxtYbC.Text = ""; ultraTxtYbSpac.Text = ""; ultraTxtYbQualfiled.Text = ""; ultraTxtYbDefect.Text = ""; ultraTxtYbMemo.Text = ""; PipeCheckconsignPhydetailEntityYBbindingSource.DataSource = listSource; ultraTabControl3.Tabs["8"].Selected = true; for (int i = 0; i < ultraGrid24.Rows.Count; i++) { if (this.ultraGrid24.Rows[i].Cells["IsGood"].Text == "不符合" || this.ultraGrid24.Rows[i].Cells["IsDefect"].Text == "不符合") { ultraGrid24.Rows[i].RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = true; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; int x = row.Cells["SpecName"].Text.IndexOf('x'); ultraTxtYbD.Text = row.Cells["SpecName"].Text.Substring(0, x); ultraTxtYbS.Text = row.Cells["SpecName"].Text.Substring(x + 1); ultraGrid24.DisplayLayout.Bands[0].Columns["IsGood"].Header.Caption = "试验结果(一次)"; ultraGrid24.DisplayLayout.Bands[0].Columns["IsDefect"].Header.Caption = "试验结果(二次)"; } else if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0026"))//扩口 { PipeCheckconsignPhydetailEntityKKbindingSource.DataSource = listSource; ultraTabControl3.Tabs["10"].Selected = true; for (int i = 0; i < ultraGrid26.Rows.Count; i++) { if (this.ultraGrid26.Rows[i].Cells["IsGood"].Text == "不符合") { ultraGrid26.Rows[i].RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = true; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = false; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0050") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0060")) { pipeCheckconsignPhydetailEntityQTBindingSource.DataSource = listSource; ultraTabControl3.Tabs["11"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = true; ultraTabControl3.Tabs["12"].Visible = false; ultraGrid55.DisplayLayout.Bands[0].Columns["AverageValue"].Header.Caption = "最小值"; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0057") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0066"))//落锤试验 { PipeCheckconsignDetailEntityLCbindingSource.DataSource = listSource; ultraTabControl3.Tabs["12"].Selected = true; ultraTabControl3.Tabs["0"].Visible = false; ultraTabControl3.Tabs["1"].Visible = false; ultraTabControl3.Tabs["2"].Visible = false; ultraTabControl3.Tabs["3"].Visible = false; ultraTabControl3.Tabs["4"].Visible = false; ultraTabControl3.Tabs["5"].Visible = false; ultraTabControl3.Tabs["6"].Visible = false; ultraTabControl3.Tabs["7"].Visible = false; ultraTabControl3.Tabs["8"].Visible = false; ultraTabControl3.Tabs["9"].Visible = false; ultraTabControl3.Tabs["10"].Visible = false; ultraTabControl3.Tabs["11"].Visible = false; ultraTabControl3.Tabs["12"].Visible = true; //ultraGrid55.DisplayLayout.Bands[0].Columns["AverageValue"].Header.Caption = "最小值"; this.ultraComFormual1.Visible = false; this.cmbStdSteelType1.Visible = false; this.txtStdSteelNo1.Visible = false; this.txtStdSteelValue1.Visible = false; this.txtActualValue1.Visible = false; ultraLabel59.Visible = false; ultraLabel53.Visible = false; ultraLabel52.Visible = false; ultraLabel51.Visible = false; ultraLabel50.Visible = false; } initCheckData(row);//加载编辑区信息 } private void initCheckData(UltraGridRow row) { this.txtCHECK_TEMP1.Text = row.Cells["CheckTemp"].Text; this.ultraDEVICE_NAME1.Value = row.Cells["DeviceNo"].Text; if (!String.IsNullOrEmpty(row.Cells["FormualNo"].Text)) { this.ultraComMethod1.Value = row.Cells["FormualNo"].Text; } this.cmbChemOrder1.Value = row.Cells["CheckShift"].Text; this.cmbChemGroup1.Value = row.Cells["CheckClass"].Text; this.txtChemUser1.Text = row.Cells["CheckName"].Text; this.ultraComFormual1.Text = row.Cells["HardnessType"].Text; cmbStdSteelType1.Text = row.Cells["StdSteelType"].Text; this.txtStdSteelNo1.Text = row.Cells["StdSteelNo"].Text; this.txtStdSteelValue1.Text = row.Cells["StdSteelValue"].Text; this.txtActualValue1.Text = row.Cells["ActualValue"].Text; this.ultraComFormual1.Text = row.Cells["HardnessType"].Text; } private void ultraGrid28_AfterRowActivate(object sender, EventArgs e) { ultraTabControl3.Visible = false; ultraTabControl4.Visible = true; ultraTabControl5.Visible = false; ultraTabControl2.Visible = false; UltraGridRow row = this.ultraGrid28.ActiveRow; List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailPhyItem", new object[] { row.Cells["CheckNo"].Value.ToString(), row.Cells["SampleNo"].Value.ToString(), row.Cells["PhyCodeMax"].Value.ToString() }, this.ob); if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0001"))//拉伸 { PipeCheckconsignPhydetailEntitybindingSource.DataSource = listSource; ultraTabControl4.Tabs["0"].Selected = true; ultraTabControl4.Tabs["0"].Visible = true; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid29.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["SplineItemNameS"].Text.ToString().Equals("")) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //else //{ // string[] SampleType = forRow.Cells["SampleType"].Text.Split(new char[2] { '=', 'm' }); // string[] SplineItemNameS = forRow.Cells["SplineItemNameS"].Text.Split(new char[2] { '=', 'm' }); // if (SampleType.Count() == 1) // { // if (!forRow.Cells["SampleType"].Text.Trim().Equals(forRow.Cells["SplineItemNameS"].Text.Trim())) // { // forRow.RowSelectorAppearance.BackColor = Color.Red; // } // } // else // { // if (!SampleType[1].ToString3().Equals(SplineItemNameS[1].ToString3()) || !SampleType[4].ToString3().Equals(SplineItemNameS[4].ToString3())) // { // forRow.RowSelectorAppearance.BackColor = Color.Red; // } // } //} string a = forRow.Cells["SplineItemNameS"].Text.Trim().Replace("0=", "o=").Replace(" ",""); if (!forRow.Cells["SampleType"].Text.Trim().Replace(" ", "").Equals(forRow.Cells["SplineItemNameS"].Text.Trim().Replace("0=", "o=").Replace(" ", ""))) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!forRow.Cells["PhyDir"].Text.Trim().Equals(forRow.Cells["SplineItemNameF"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["ItemNameW"].Text.Trim().Equals("室温")) { if (forRow.Cells["CheckTemp"].Text.Trim().ToString().Equals("") || forRow.Cells["CheckTemp"].Value == null) { MessageUtil.ShowTips("没有温度!"); return; } else { if (int.Parse(forRow.Cells["CheckTemp"].Text.Trim()) > 35 || int.Parse(forRow.Cells["CheckTemp"].Text.Trim()) < 10) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } else { if (!forRow.Cells["CheckTemp"].Text.Trim().Equals(forRow.Cells["ItemNameW"].Text.Trim().Replace("℃", ""))) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0002"))//冲击 { PipeCheckconsignPhydetailEntityCjbindingSource.DataSource = listSource; ultraTabControl4.Tabs["1"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = true; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid30.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["SplineItemNameS"].Text.ToString().Equals("")) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //else //{ // string[] SampleType = forRow.Cells["SampleType"].Text.Split(new char[2] { '=', 'm' }); // string[] SplineItemNameS = forRow.Cells["SplineItemNameS"].Text.Split(new char[2] { '=', 'm' }); // if (SampleType.Count() == 1) // { // if (!forRow.Cells["SampleType"].Text.Trim().Equals(forRow.Cells["SplineItemNameS"].Text.Trim())) // { // forRow.RowSelectorAppearance.BackColor = Color.Red; // } // } // else // { // if (!SampleType[1].ToString3().Equals(SplineItemNameS[1].ToString3()) || !SampleType[4].ToString3().Equals(SplineItemNameS[4].ToString3())) // { // forRow.RowSelectorAppearance.BackColor = Color.Red; // } // } //} if (!forRow.Cells["SampleType"].Text.Trim().Replace(" ", "").Equals(forRow.Cells["SplineItemNameS"].Text.Trim().Replace("0=", "o=").Replace(" ", ""))) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!forRow.Cells["PhyDir"].Text.Trim().Equals(forRow.Cells["SplineItemNameF"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["ItemNameW"].Text.Trim().Equals("室温")) { if (int.Parse(forRow.Cells["CheckTemp"].Text.Trim()) > 35 || int.Parse(forRow.Cells["CheckTemp"].Text.Trim()) < 10) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } else { if (!forRow.Cells["CheckTemp"].Text.Trim().Equals(forRow.Cells["ItemNameW"].Text.Trim().Replace("℃", ""))) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0003"))//布氏 { PipeCheckconsignPhydetailEntityBSbindingSource.DataSource = listSource; MergedCell(ultraGrid6, new string[] { "PhyName" }); ultraTabControl4.Tabs["4"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = true; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid33.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0004") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0018"))//洛氏 { PipeCheckconsignPhydetailEntityLSbindingSource.DataSource = listSource; MergedCell(ultraGrid5, new string[] { "PhyName" }); ultraTabControl4.Tabs["2"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = true; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid31.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0005"))//维氏 { PipeCheckconsignPhydetailEntityWSbindingSource.DataSource = listSource; MergedCell(ultraGrid5, new string[] { "PhyName" }); ultraTabControl4.Tabs["3"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = true; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid32.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value5"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value5"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0014") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0016") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0031"))//组织 { PipeCheckconsignPhydetailEntityZZbindingSource.DataSource = listSource; ultraTabControl4.Tabs["7"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = true; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid36.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0013"))//晶粒度 { PipeCheckconsignPhydetailEntityJLDbindingSource.DataSource = listSource; ultraTabControl4.Tabs["6"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = true; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid35.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0012"))//夹杂 { PipeCheckconsignPhydetailEntityJZWbindingSource.DataSource = listSource; ultraTabControl4.Tabs["5"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = true; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid34.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["PhyCode"].Text.ToString().Equals("P0618") || forRow.Cells["PhyCode"].Text.ToString().Equals("P0619")) { if (!forRow.Cells["Value1"].Text.ToString().Equals("是") && !forRow.Cells["Value1"].Text.ToString().Equals("否")) { forRow.RowSelectorAppearance.BackColor = Color.Red; ; } } } ultraGrid34.DisplayLayout.Bands[0].Columns["Value1"].Header.Caption = "一象限"; ultraGrid34.DisplayLayout.Bands[0].Columns["Value2"].Header.Caption = "二象限"; ultraGrid34.DisplayLayout.Bands[0].Columns["Value3"].Header.Caption = "三象限"; ultraGrid34.DisplayLayout.Bands[0].Columns["Value4"].Header.Caption = "四象限"; if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0115")) { ultraGrid34.DisplayLayout.Bands[0].Columns["Value2"].Hidden = false; ultraGrid34.DisplayLayout.Bands[0].Columns["Value3"].Hidden = false; ultraGrid34.DisplayLayout.Bands[0].Columns["Value4"].Hidden = false; } else { ultraGrid34.DisplayLayout.Bands[0].Columns["Value2"].Hidden = true; ultraGrid34.DisplayLayout.Bands[0].Columns["Value3"].Hidden = true; ultraGrid34.DisplayLayout.Bands[0].Columns["Value4"].Hidden = true; } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0010"))//工艺 { if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0027") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0038") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0082") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0083") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0098"))//弯曲 { PipeCheckconsignPhydetailEntityWQbindingSource.DataSource = listSource; ultraTabControl4.Tabs["9"].Selected = true; for (int i = 0; i < ultraGrid38.Rows.Count; i++) { if (this.ultraGrid38.Rows[i].Cells["IsGood"].Text == "不符合") { ultraGrid38.Rows[i].RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = true; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; } else if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0009"))//压扁 { PipeCheckconsignPhydetailEntityYBbindingSource.DataSource = listSource; ultraTabControl4.Tabs["8"].Selected = true; for (int i = 0; i < ultraGrid37.Rows.Count; i++) { if (this.ultraGrid37.Rows[i].Cells["IsGood"].Text == "不符合" || this.ultraGrid37.Rows[i].Cells["IsDefect"].Text == "不符合") { ultraGrid37.Rows[i].RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = true; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; ultraGrid37.DisplayLayout.Bands[0].Columns["IsGood"].Header.Caption = "试验结果(一次)"; ultraGrid37.DisplayLayout.Bands[0].Columns["IsDefect"].Header.Caption = "试验结果(二次)"; } else if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0026"))//扩口 { PipeCheckconsignPhydetailEntityKKbindingSource.DataSource = listSource; ultraTabControl4.Tabs["10"].Selected = true; for (int i = 0; i < ultraGrid39.Rows.Count; i++) { if (this.ultraGrid39.Rows[i].Cells["IsGood"].Text == "不符合") { ultraGrid39.Rows[i].RowSelectorAppearance.BackColor = Color.Red; } } ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = true; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = false; } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0050") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0060"))//其他 { PipeCheckconsignPhydetailEntityKKbindingSource.DataSource = listSource; ultraTabControl4.Tabs["11"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = true; ultraTabControl4.Tabs["12"].Visible = false; ultraGrid56.DisplayLayout.Bands[0].Columns["AverageValue"].Header.Caption = "最小值"; foreach (UltraGridRow forRow in ultraGrid56.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0057") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0066"))//落锤试验 { PipeCheckconsignDetailEntityLCbindingSource.DataSource = listSource; ultraTabControl4.Tabs["12"].Selected = true; ultraTabControl4.Tabs["0"].Visible = false; ultraTabControl4.Tabs["1"].Visible = false; ultraTabControl4.Tabs["2"].Visible = false; ultraTabControl4.Tabs["3"].Visible = false; ultraTabControl4.Tabs["4"].Visible = false; ultraTabControl4.Tabs["5"].Visible = false; ultraTabControl4.Tabs["6"].Visible = false; ultraTabControl4.Tabs["7"].Visible = false; ultraTabControl4.Tabs["8"].Visible = false; ultraTabControl4.Tabs["9"].Visible = false; ultraTabControl4.Tabs["10"].Visible = false; ultraTabControl4.Tabs["11"].Visible = false; ultraTabControl4.Tabs["12"].Visible = true; //ultraGrid56.DisplayLayout.Bands[0].Columns["AverageValue"].Header.Caption = "最小值"; //foreach (UltraGridRow forRow in ultraGrid56.Rows) //{ // if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) // { // forRow.RowSelectorAppearance.BackColor = Color.Red; // } // if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) // { // forRow.RowSelectorAppearance.BackColor = Color.Red; // } //} } } private void ultraGrid14_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraGrid14.ActiveRow; List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailPHY", new object[] { uRow.Cells["CheckNo"].Value.ToString(), uRow.Cells["SampleNo"].Value.ToString(), "345", arrId, this.ultraOptionSet1.CheckedItem.DataValue.ToString() }, this.ob); PipeCheckconsignDetailEntitybindingSource4.DataSource = listSource; } private void ultraButton2_Click(object sender, EventArgs e) { if (this.ultraTxtYbEuestion.Text.Trim() == "") { MessageUtil.ShowTips("请选择计算公式!"); return; } double d = 0.0; double c = 0.0; double t = 0.0; if (this.ultraTxtYbEuestion.Text.Trim() == "0.65*D" || this.ultraTxtYbEuestion.Text.Trim() == "7*D/8" || this.ultraTxtYbEuestion.Text.Trim() == "2*D/3") { if (this.ultraTxtYbD.Text.Trim() == "") { MessageUtil.ShowTips("请输入管子公称外径!"); return; } } else if (this.ultraTxtYbEuestion.Text.Trim() == "(1+C)*T/(C+T/D)") { if (this.ultraTxtYbD.Text.Trim() == "" || this.ultraTxtYbC.Text.Trim() == "" || this.ultraTxtYbS.Text.Trim() == "") { MessageUtil.ShowTips("请输入管子的公称外径壁厚以及压扁系数!"); return; } } d = double.Parse(this.ultraTxtYbD.Text.Trim().ToString3()); t = double.Parse(this.ultraTxtYbS.Text.Trim().ToString3()); c = double.Parse(this.ultraTxtYbC.Text.Trim().ToString3()); if (this.ultraTxtYbEuestion.Text.Trim() == "0.65*D") { this.ultraTxtYbSpac.Text = Math.Floor((0.65 * d)).ToString(); } else if (this.ultraTxtYbEuestion.Text.Trim() == "7*D/8") { this.ultraTxtYbSpac.Text = Math.Floor(((7 * d) / 8)).ToString(); } else if (this.ultraTxtYbEuestion.Text.Trim() == "2*D/3") { this.ultraTxtYbSpac.Text = Math.Floor(((2 * d) / 3)).ToString(); } else if (this.ultraTxtYbEuestion.Text.Trim() == "(1+C)*T/(C+T/D)") { this.ultraTxtYbSpac.Text = Math.Floor((((1 + c) * t) / (c + t / d))).ToString(); } } private void ultraGrid17_CellChange(object sender, CellEventArgs e) { this.ultraGrid17.UpdateData(); UltraGridRow ur = this.ultraGrid17.ActiveRow; UltraGridRow uRow = this.ultraGrid15.ActiveRow; string specName = uRow.Cells["ItemNameS"].Text.Trim();//试验尺寸 int x = specName.IndexOf("×");//x位置 string width = specName.Substring(0, x).Replace("m", ""); string height = specName.Substring(x + 1).Replace("m", ""); int m = 0; string ak1 = "";//真实值 string ak2 = ""; string ak3 = ""; int akNum = 0; foreach (UltraGridRow row in this.ultraGrid17.Rows) { if (row.Cells["PhyName"].Text.Contains("ak")) { akNum = akNum + 1; } } if (akNum > 0 && ur.Cells["PhyName"].Text.Contains("冲击功")) { if (e.Cell.Column.Key == "Value1") { if (ur.Cells["Value1"].Text == "-") { return; } ak1 = (Math.Round(100 * double.Parse(ur.Cells["Value1"].Text.Trim().Replace('<','-').ToString3()) / (double.Parse(width) * (double.Parse(height) - 2)), 0)).ToString(); foreach (UltraGridRow akRow in this.ultraGrid17.Rows) { if (akRow.Cells["PhyName"].Text.Contains("ak")) { akRow.Cells["Value1"].Value = ak1; if (akRow.Cells["Value2"].Text != "") { m = m + 1; } if (akRow.Cells["Value3"].Text != "") { m = m + 1; } m = m + 1; akRow.Cells["AverageValue"].Value = Math.Round(((double.Parse(akRow.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(akRow.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(akRow.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m)).ToString(); } } } if (e.Cell.Column.Key == "Value2") { if (ur.Cells["Value2"].Text == "-") { return; } ak2 = (Math.Round(100 * double.Parse(ur.Cells["Value2"].Text.Trim().Replace('<','-').ToString3()) / (double.Parse(width) * (double.Parse(height) - 2)), 0)).ToString(); foreach (UltraGridRow akRow in this.ultraGrid17.Rows) { if (akRow.Cells["PhyName"].Text.Contains("ak")) { akRow.Cells["Value2"].Value = ak2; if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } m = m + 1; akRow.Cells["AverageValue"].Value = Math.Round(((double.Parse(akRow.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(akRow.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(akRow.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m)).ToString(); } } } if (e.Cell.Column.Key == "Value3") { if (ur.Cells["Value3"].Text == "-") { return; } ak3 = (Math.Round(100 * double.Parse(ur.Cells["Value3"].Text.Trim().Replace('<', '-').ToString3()) / (double.Parse(width) * (double.Parse(height) - 2)), 0)).ToString(); foreach (UltraGridRow akRow in this.ultraGrid17.Rows) { if (akRow.Cells["PhyName"].Text.Contains("ak")) { akRow.Cells["Value3"].Value = ak3; if (akRow.Cells["Value1"].Text != "") { m = m + 1; } if (akRow.Cells["Value2"].Text != "") { m = m + 1; } m = m + 1; akRow.Cells["AverageValue"].Value = Math.Round(((double.Parse(akRow.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(akRow.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(akRow.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m)).ToString(); } } } } else if (ur.Cells["PhyName"].Text.Contains("侧膨胀值LE")) { if (e.Cell.Column.Key == "Value1") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value1"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Trim().Replace('<', '-').ToString3())) / m), 2).ToString(); } if (e.Cell.Column.Key == "Value2") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 2).ToString(); } if (e.Cell.Column.Key == "Value3") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 2).ToString(); } } else { if (e.Cell.Column.Key == "Value1") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value1"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Trim().Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value2") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value3") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Trim().Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } } } private void ultraGrid18_CellChange(object sender, CellEventArgs e) { this.ultraGrid18.UpdateData(); UltraGridRow ur = this.ultraGrid18.ActiveRow; int m = 0; if (e.Cell.Column.Key == "Value1") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value1"].Text == "-") { return; } if (ur.Cells["Value1"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 1).ToString(); } if (e.Cell.Column.Key == "Value2") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text == "-") { return; } if (ur.Cells["Value2"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('-', '0').Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('-', '0').Replace('<', '-').ToString3())) / m), 1).ToString(); } if (e.Cell.Column.Key == "Value3") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text == "-") { return; } if (ur.Cells["Value3"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 1).ToString(); } } private void ultraGrid19_CellChange(object sender, CellEventArgs e) { this.ultraGrid19.UpdateData(); UltraGridRow ur = this.ultraGrid19.ActiveRow; int m = 0; string comFormual = this.ultraComFormual.Text.Trim(); if (e.Cell.Column.Key == "Value1D1" || e.Cell.Column.Key == "Value1D2") { if (comFormual.Equals("HV5")) { ur.Cells["Value1"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value1"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value2D1" || e.Cell.Column.Key == "Value2D2") { if (comFormual.Equals("HV5")) { ur.Cells["Value2"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value2"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value3D1" || e.Cell.Column.Key == "Value3D2") { if (comFormual.Equals("HV5")) { ur.Cells["Value3"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value3"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value4D1" || e.Cell.Column.Key == "Value4D2") { if (comFormual.Equals("HV5")) { ur.Cells["Value4"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value4D1"].Text.ToString3()) + double.Parse(ur.Cells["Value4D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value4"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value4D1"].Text.ToString3()) + double.Parse(ur.Cells["Value4D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value5D1" || e.Cell.Column.Key == "Value5D2") { if (comFormual.Equals("HV5")) { ur.Cells["Value5"].Value = Math.Round(0.1891 * 49.03 / Math.Pow((double.Parse(ur.Cells["Value5D1"].Text.ToString3()) + double.Parse(ur.Cells["Value5D2"].Text.ToString3())) / 2, 2), 0); } else if (comFormual.Equals("HV10")) { ur.Cells["Value5"].Value = Math.Round(0.1891 * 98.07 / Math.Pow((double.Parse(ur.Cells["Value5D1"].Text.ToString3()) + double.Parse(ur.Cells["Value5D2"].Text.ToString3())) / 2, 2), 0); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value1") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } if (ur.Cells["Value1"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value2") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value3") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value4") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value5") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value4"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text != "") { m = m + 1; } if (ur.Cells["Value5"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value4"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value5"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } } private void ultraGrid20_CellChange(object sender, CellEventArgs e) { this.ultraGrid20.UpdateData(); UltraGridRow ur = this.ultraGrid20.ActiveRow; int m = 0; string comFormual = this.ultraComFormual.Text.Trim(); if (e.Cell.Column.Key == "Value1D1" || e.Cell.Column.Key == "Value1D2") { if (comFormual.Equals("HBW2.5")) { ur.Cells["Value1"].Value = (Math.Round(0.102 * 2 * 1838.75 / (2.5 * 3.142 * (2.5 - Math.Sqrt(6.25 - Math.Pow(double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW5")) { ur.Cells["Value1"].Value = (Math.Round(0.102 * 2 * 7355 / (5 * 3.142 * (5 - Math.Sqrt(25 - Math.Pow(double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW10")) { ur.Cells["Value1"].Value = (Math.Round(0.102 * 2 * 29420 / (10 * 3.142 * (10 - Math.Sqrt(100 - Math.Pow(double.Parse(ur.Cells["Value1D1"].Text.ToString3()) + double.Parse(ur.Cells["Value1D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 2).ToString(); } if (e.Cell.Column.Key == "Value2D1" || e.Cell.Column.Key == "Value2D2") { if (comFormual.Equals("HBW2.5")) { ur.Cells["Value2"].Value = (Math.Round(0.102 * 2 * 1838.75 / (2.5 * 3.142 * (2.5 - Math.Sqrt(6.25 - Math.Pow(double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW5")) { ur.Cells["Value2"].Value = (Math.Round(0.102 * 2 * 7355 / (5 * 3.142 * (5 - Math.Sqrt(25 - Math.Pow(double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW10")) { ur.Cells["Value2"].Value = (Math.Round(0.102 * 2 * 29420 / (10 * 3.142 * (10 - Math.Sqrt(100 - Math.Pow(double.Parse(ur.Cells["Value2D1"].Text.ToString3()) + double.Parse(ur.Cells["Value2D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 2).ToString(); } if (e.Cell.Column.Key == "Value3D1" || e.Cell.Column.Key == "Value3D2") { if (comFormual.Equals("HBW2.5")) { ur.Cells["Value3"].Value = (Math.Round(0.102 * 2 * 1838.75 / (2.5 * 3.142 * (2.5 - Math.Sqrt(6.25 - Math.Pow(double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW5")) { ur.Cells["Value3"].Value = (Math.Round(0.102 * 2 * 7355 / (5 * 3.142 * (5 - Math.Sqrt(25 - Math.Pow(double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else if (comFormual.Equals("HBW10")) { ur.Cells["Value3"].Value = (Math.Round(0.102 * 2 * 29420 / (10 * 3.142 * (10 - Math.Sqrt(100 - Math.Pow(double.Parse(ur.Cells["Value3D1"].Text.ToString3()) + double.Parse(ur.Cells["Value3D2"].Text.ToString3()), 2) / 4))), 0)).ToString(); } else { MessageUtil.ShowTips("公式选择错误!"); return; } if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value1") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value1"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value2") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } if (e.Cell.Column.Key == "Value3") { if (ur.Cells["Value1"].Text != "") { m = m + 1; } if (ur.Cells["Value2"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text != "") { m = m + 1; } if (ur.Cells["Value3"].Text == "-") { return; } ur.Cells["AverageValue"].Value = Math.Round(((double.Parse(ur.Cells["Value1"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value2"].Text.Replace('<', '-').ToString3()) + double.Parse(ur.Cells["Value3"].Text.Replace('<', '-').ToString3())) / m), 0).ToString(); } } private void ultraGrid27_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraGrid27.ActiveRow; if(uRow.HasChild()) { return; } if(uRow == null) { return; } List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailPHYNoFrim", new object[] { uRow.Cells["CheckNo"].Value.ToString(), "3", arrId, ultraOptionSet1.CheckedItem.DataValue.ToString() }, this.ob); PipeCheckconsignDetailEntitybindingSource2.DataSource = listSource; } //private void ultraGrid27_CellChange(object sender, CellEventArgs e) //{ // if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK") // { // ultraGrid27.UpdateData(); // if (e.Cell.Value.ToString() == "True") // { // foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows) // { // dr.Cells["CHK1"].Value = "True"; // } // } // else // { // foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows) // { // dr.Cells["CHK1"].Value = "False"; // } // } // } //} private void ultraGrid40_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraGrid40.ActiveRow; if (uRow.HasChild()) { return; } if (uRow == null) { return; } List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailPHYFrim", new object[] { uRow.Cells["CheckNo"].Value.ToString(), arrId, ultraOptionSet1.CheckedItem.DataValue.ToString() }, this.ob); PipeCheckconsignDetailEntitybindingSource3.DataSource = listSource; List listSource1 = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryDetaiFlag", new object[] { uRow.Cells["CheckNo"].Value.ToString(), arrId }, this.ob); pipeCheckconsignDetailEntityBindingSource7.DataSource = listSource1; for(int i = 0;i listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmDataCJBase.queryCheckConsignBaseDetailPhyItem", new object[] { row.Cells["CheckNo"].Value.ToString(), row.Cells["SampleNo"].Value.ToString(), row.Cells["PhyCodeMax"].Value.ToString() }, this.ob); if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0001"))//拉伸 { PipeCheckconsignPhydetailEntitybindingSource.DataSource = listSource; ultraTabControl5.Tabs["0"].Selected = true; ultraTabControl5.Tabs["0"].Visible = true; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid42.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["SplineItemNameS"].Text.ToString().Equals("")) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } string a = forRow.Cells["SplineItemNameS"].Text.Trim().Replace("0=", "o=").Replace(" ", ""); if (!forRow.Cells["SampleType"].Text.Trim().Replace(" ", "").Equals(forRow.Cells["SplineItemNameS"].Text.Trim().Replace("0=", "o=").Replace(" ", ""))) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!forRow.Cells["PhyDir"].Text.Trim().Equals(forRow.Cells["SplineItemNameF"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["ItemNameW"].Text.Trim().Equals("室温")) { if (int.Parse(forRow.Cells["CheckTemp"].Text.Trim()) > 35 || int.Parse(forRow.Cells["CheckTemp"].Text.Trim()) < 10) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } else { if (!forRow.Cells["CheckTemp"].Text.Trim().Equals(forRow.Cells["ItemNameW"].Text.Trim().Replace("℃", ""))) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0002"))//冲击 { PipeCheckconsignPhydetailEntityCjbindingSource.DataSource = listSource; ultraTabControl5.Tabs["1"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = true; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid43.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["SplineItemNameS"].Text.ToString().Equals("")) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!forRow.Cells["SampleType"].Text.Trim().Replace(" ", "").Equals(forRow.Cells["SplineItemNameS"].Text.Trim().Replace("0=", "o=").Replace(" ", ""))) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!forRow.Cells["PhyDir"].Text.Trim().Equals(forRow.Cells["SplineItemNameF"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["ItemNameW"].Text.Trim().Equals("室温")) { if (int.Parse(forRow.Cells["CheckTemp"].Text.Trim()) > 35 || int.Parse(forRow.Cells["CheckTemp"].Text.Trim()) < 10) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } else { if (!forRow.Cells["CheckTemp"].Text.Trim().Equals(forRow.Cells["ItemNameW"].Text.Trim().Replace("℃", ""))) { forRow.RowSelectorAppearance.BackColor = Color.Red; } } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0003"))//布氏 { PipeCheckconsignPhydetailEntityBSbindingSource.DataSource = listSource; MergedCell(ultraGrid6, new string[] { "PhyName" }); ultraTabControl5.Tabs["4"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = true; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid46.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0004") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0018"))//洛氏 { PipeCheckconsignPhydetailEntityLSbindingSource.DataSource = listSource; MergedCell(ultraGrid5, new string[] { "PhyName" }); ultraTabControl5.Tabs["2"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = true; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid44.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0005"))//维氏 { PipeCheckconsignPhydetailEntityWSbindingSource.DataSource = listSource; MergedCell(ultraGrid5, new string[] { "PhyName" }); ultraTabControl5.Tabs["3"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = true; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid45.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } //力学实验冲击，硬度单点值，平均值超上限都变红。 if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value2"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value3"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value4"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value5"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value5"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0014") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0016") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0031"))//组织 { PipeCheckconsignPhydetailEntityZZbindingSource.DataSource = listSource; ultraTabControl5.Tabs["7"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = true; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid49.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0013"))//晶粒度 { PipeCheckconsignPhydetailEntityJLDbindingSource.DataSource = listSource; ultraTabControl5.Tabs["6"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = true; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid48.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0012"))//夹杂 { PipeCheckconsignPhydetailEntityJZWbindingSource.DataSource = listSource; ultraTabControl5.Tabs["5"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = true; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; foreach (UltraGridRow forRow in ultraGrid47.Rows) { if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["Value1"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (forRow.Cells["PhyCode"].Text.ToString().Equals("P0618") || forRow.Cells["PhyCode"].Text.ToString().Equals("P0619")) { if (!forRow.Cells["Value1"].Text.ToString().Equals("是") && !forRow.Cells["Value1"].Text.ToString().Equals("否")) { forRow.RowSelectorAppearance.BackColor = Color.Red; ; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } } ultraGrid47.DisplayLayout.Bands[0].Columns["Value1"].Header.Caption = "一象限"; ultraGrid47.DisplayLayout.Bands[0].Columns["Value2"].Header.Caption = "二象限"; ultraGrid47.DisplayLayout.Bands[0].Columns["Value3"].Header.Caption = "三象限"; ultraGrid47.DisplayLayout.Bands[0].Columns["Value4"].Header.Caption = "四象限"; if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0115")) { ultraGrid47.DisplayLayout.Bands[0].Columns["Value2"].Hidden = false; ultraGrid47.DisplayLayout.Bands[0].Columns["Value3"].Hidden = false; ultraGrid47.DisplayLayout.Bands[0].Columns["Value4"].Hidden = false; } else { ultraGrid47.DisplayLayout.Bands[0].Columns["Value2"].Hidden = true; ultraGrid47.DisplayLayout.Bands[0].Columns["Value3"].Hidden = true; ultraGrid47.DisplayLayout.Bands[0].Columns["Value4"].Hidden = true; } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0010"))//工艺 { if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0027") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0038") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0082") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0083") || row.Cells["PhyCodeMax"].Value.ToString().Equals("C0098"))//弯曲 { PipeCheckconsignPhydetailEntityWQbindingSource.DataSource = listSource; ultraTabControl5.Tabs["9"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = true; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; } else if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0009"))//压扁 { PipeCheckconsignPhydetailEntityYBbindingSource.DataSource = listSource; ultraTabControl5.Tabs["8"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = true; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; for (int i = 0; i < ultraGrid50.Rows.Count; i++) { if (this.ultraGrid50.Rows[i].Cells["IsGood"].Text == "不符合" || this.ultraGrid50.Rows[i].Cells["IsDefect"].Text == "不符合") { ultraGrid37.Rows[i].RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } ultraGrid50.DisplayLayout.Bands[0].Columns["IsGood"].Header.Caption = "试验结果(一次)"; ultraGrid50.DisplayLayout.Bands[0].Columns["IsDefect"].Header.Caption = "试验结果(二次)"; } else if (row.Cells["PhyCodeMax"].Value.ToString().Equals("C0026"))//扩口 { PipeCheckconsignPhydetailEntityKKbindingSource.DataSource = listSource; ultraTabControl5.Tabs["10"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = true; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = false; for (int i = 0; i < ultraGrid52.Rows.Count; i++) { if (this.ultraGrid52.Rows[i].Cells["IsGood"].Text == "不符合") { ultraGrid52.Rows[i].RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0050") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0060")) { pipeCheckconsignPhydetailEntityQTBindingSource.DataSource = listSource; ultraTabControl5.Tabs["11"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = true; ultraTabControl5.Tabs["12"].Visible = false; ultraGrid57.DisplayLayout.Bands[0].Columns["AverageValue"].Header.Caption = "最小值"; foreach (UltraGridRow forRow in ultraGrid57.Rows) { if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) { forRow.RowSelectorAppearance.BackColor = Color.Red; this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; } } } else if (row.Cells["PhyCodeMin"].Value.ToString().Equals("R0057") || row.Cells["PhyCodeMin"].Value.ToString().Equals("R0066")) //落锤试验 { PipeCheckconsignDetailEntityLCbindingSource.DataSource = listSource; ultraTabControl5.Tabs["12"].Selected = true; ultraTabControl5.Tabs["0"].Visible = false; ultraTabControl5.Tabs["1"].Visible = false; ultraTabControl5.Tabs["2"].Visible = false; ultraTabControl5.Tabs["3"].Visible = false; ultraTabControl5.Tabs["4"].Visible = false; ultraTabControl5.Tabs["5"].Visible = false; ultraTabControl5.Tabs["6"].Visible = false; ultraTabControl5.Tabs["7"].Visible = false; ultraTabControl5.Tabs["8"].Visible = false; ultraTabControl5.Tabs["9"].Visible = false; ultraTabControl5.Tabs["10"].Visible = false; ultraTabControl5.Tabs["11"].Visible = false; ultraTabControl5.Tabs["12"].Visible = true; //ultraGrid57.DisplayLayout.Bands[0].Columns["AverageValue"].Header.Caption = "最小值"; //foreach (UltraGridRow forRow in ultraGrid57.Rows) //{ // if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMinSign"].Text.Trim(), forRow.Cells["StdMin"].Text.Trim())) // { // forRow.RowSelectorAppearance.BackColor = Color.Red; // this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; // } // if (!checkStr(forRow.Cells["AverageValue"].Text.Trim(), forRow.Cells["StdMaxSign"].Text.Trim(), forRow.Cells["StdMax"].Text.Trim())) // { // forRow.RowSelectorAppearance.BackColor = Color.Red; // this.ultraGrid40.ActiveRow.RowSelectorAppearance.BackColor = Color.Red; // } //} } } private void ultraGrid8_CellChange(object sender, CellEventArgs e) { this.ultraGrid8.UpdateData(); if (e.Cell.Column.Key == "Value1") { if(!StringUtil.IsDouble(e.Cell.Row.Cells["Value1"].Value.ToString3()) && e.Cell.Row.Cells["Value1"].Value.ToString2() == "") { return; //if (!(e.Cell.Row.Cells["Value1"].Value.ToString2().Substring(e.Cell.Row.Cells["Value1"].Value.ToString2().Length - 1, 1)).Equals("0") && !(e.Cell.Row.Cells["Value1"].Value.ToString2().Substring(e.Cell.Row.Cells["Value1"].Value.ToString2().Length - 1, 1)).Equals("5")) //{ // MessageUtil.ShowTips("末尾位只能是0或者5"); // return; //} } List list = PipeCheckconsignPhydetailEntityJZWbindingSource.DataSource as List; list.Where(p => p.PhyCode == "P0064").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0052" || q.PhyCode == "P0057" || q.PhyCode == "P0060" || q.PhyCode == "P0061").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C+D)细系总和 }); list.Where(p => p.PhyCode == "P0065").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0058" || q.PhyCode == "P0059" || q.PhyCode == "P0062").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C+D)粗系总和 }); list.Where(p => p.PhyCode == "P0069").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0059").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+C)粗系总和 }); list.Where(p => p.PhyCode == "P0070").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0059").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+C)细系总和 }); list.Where(p => p.PhyCode == "P0071").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0052" || q.PhyCode == "P0057" || q.PhyCode == "P0060").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C)细系总和 }); list.Where(p => p.PhyCode == "P0072").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0058" || q.PhyCode == "P0059").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C)粗系总和 }); list.Where(p => p.PhyCode == "P0085").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0052" || q.PhyCode == "P0056" || q.PhyCode == "P0057" || q.PhyCode == "P0058" || q.PhyCode == "P0059" || q.PhyCode == "P0060" || q.PhyCode == "P0061" || q.PhyCode == "P0062").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C+D)粗细系总和 }); list.Where(p => p.PhyCode == "P0090").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0058").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B)粗系总和 }); list.Where(p => p.PhyCode == "P0091").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0052" || q.PhyCode == "P0057").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B)细系总和 }); list.Where(p => p.PhyCode == "P0096").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0058" || q.PhyCode == "P0062").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(B+D)粗系总和 }); list.Where(p => p.PhyCode == "P0097").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0057" || q.PhyCode == "P0061").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(B+D)粗系总和 }); ultraGrid8.Refresh(); } } private void ultraGrid21_CellChange(object sender, CellEventArgs e) { this.ultraGrid21.UpdateData(); if (e.Cell.Column.Key == "Value1") { List list = PipeCheckconsignPhydetailEntityJZWbindingSource.DataSource as List; list.Where(p => p.PhyCode == "P0064").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0052" || q.PhyCode == "P0057" || q.PhyCode == "P0060" || q.PhyCode == "P0061").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C+D)细系总和 }); list.Where(p => p.PhyCode == "P0065").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0058" || q.PhyCode == "P0059" || q.PhyCode == "P0062").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C+D)粗系总和 }); list.Where(p => p.PhyCode == "P0069").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0059").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+C)粗系总和 }); list.Where(p => p.PhyCode == "P0070").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0059").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+C)细系总和 }); list.Where(p => p.PhyCode == "P0071").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0052" || q.PhyCode == "P0057" || q.PhyCode == "P0060").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C)细系总和 }); list.Where(p => p.PhyCode == "P0072").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0058" || q.PhyCode == "P0059").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C)粗系总和 }); list.Where(p => p.PhyCode == "P0085").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0052" || q.PhyCode == "P0056" || q.PhyCode == "P0057" || q.PhyCode == "P0058" || q.PhyCode == "P0059" || q.PhyCode == "P0060" || q.PhyCode == "P0061" || q.PhyCode == "P0062").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B+C+D)粗细系总和 }); list.Where(p => p.PhyCode == "P0090").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0056" || q.PhyCode == "P0058").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B)粗系总和 }); list.Where(p => p.PhyCode == "P0091").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0052" || q.PhyCode == "P0057").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(A+B)细系总和 }); list.Where(p => p.PhyCode == "P0096").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0058" || q.PhyCode == "P0062").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(B+D)粗系总和 }); list.Where(p => p.PhyCode == "P0097").ToList().ForEach(p => { p.Value1 = list.Where(q => q.PhyCode == "P0057" || q.PhyCode == "P0061").Sum(q => double.Parse(q.Value1.ToString3())).ToString();//(B+D)粗系总和 }); ultraGrid21.Refresh(); } } private void ultraGrid10_CellChange(object sender, CellEventArgs e) { this.ultraGrid10.UpdateData(); if (e.Cell.Column.Key == "Value1") { if (StringUtil.IsDouble(e.Cell.Row.Cells["Value1"].Value.ToString3())) return; } } private void chkRegTime_CheckedChanged(object sender, EventArgs e) { this.RegStartTime.Enabled = this.RegEndTime.Enabled = this.chkRegTime.Checked; } private void chkCheckNo_CheckedChanged(object sender, EventArgs e) { this.txtCheckNo.Enabled = this.chkCheckNo.Checked; } private void chkJudgeNo_CheckedChanged(object sender, EventArgs e) { this.txtJudgeNo.Enabled = this.chkJudgeNo.Checked; } private void chkSteel_CheckedChanged(object sender, EventArgs e) { this.txtSteel.Enabled = this.chkSteel.Checked; } private void chkGroup_CheckedChanged(object sender, EventArgs e) { this.cmbGroup.Enabled = this.chkGroup.Checked; } private void chkSampleNo_CheckedChanged(object sender, EventArgs e) { this.txtSampleNo.Enabled = this.chkSampleNo.Checked; } private void chkOrderNo_CheckedChanged(object sender, EventArgs e) { this.txtOrderNo.Enabled = this.chkOrderNo.Checked; } private void chkSpec_CheckedChanged(object sender, EventArgs e) { this.txtSpec.Enabled = this.chkSpec.Checked; } private void ultraGrid24_AfterRowActivate(object sender, EventArgs e) { this.ultraGrid24.UpdateData(); UltraGridRow row = this.ultraGrid24.ActiveRow; if (row == null) return; ultraTxtYbEuestion.Text = row.Cells["CalculationFormula"].Text; ultraTxtYbC.Text = row.Cells["Value7"].Text; ultraTxtYbSpac.Text = row.Cells["Value8"].Text; ultraTxtYbQualfiled.Text = row.Cells["IsGood"].Text; ultraTxtYbDefect.Text = row.Cells["IsDefect"].Text; ultraTxtYbMemo.Text = row.Cells["Remark"].Text; } private void ultraGrid25_AfterRowActivate(object sender, EventArgs e) { this.ultraGrid25.UpdateData(); UltraGridRow row = this.ultraGrid25.ActiveRow; if (row == null) return; ultraTxtWqDiameter.Text = row.Cells["Value9"].Text; ultraTxtWqAngle.Text = row.Cells["Value10"].Text; ultraTxtWqQualfiled.Text = row.Cells["IsGood"].Text; ultraTxtWqMemo.Text = row.Cells["Remark"].Text; } private void ultraGrid26_AfterRowActivate(object sender, EventArgs e) { this.ultraGrid26.UpdateData(); UltraGridRow row = this.ultraGrid26.ActiveRow; if (row == null) return; ultraTxtKkTop.Text = row.Cells["Value11"].Text; ultraTxtKkFlarRate.Text = row.Cells["Value12"].Text; ultraTxtKkGood.Text = row.Cells["IsGood"].Text; ultraTxtKkMemo.Text = row.Cells["Remark"].Text; } private void ultraComMethod_ValueChanged(object sender, EventArgs e) { ultraComMethodName.Clear(); if (String.IsNullOrEmpty(this.ultraComMethod.Value.ToString2())) return; DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryMothName", new object[] { this.ultraComMethod.Value.ToString2() }, ob); if(ds.Rows.Count > 0) { ultraComMethodName.DataSource = ds; ultraComMethodName.ValueMember = "STD_ID"; ultraComMethodName.SelectedIndex = 0; } } private void chkIsProuctor_CheckedChanged(object sender, EventArgs e) { this.cmbIsProductor.Enabled = this.chkIsProuctor.Checked; } private void chkType_CheckedChanged(object sender, EventArgs e) { this.cmbType.Enabled = this.chkType.Checked; } private void chkPrintK_CheckedChanged(object sender, EventArgs e) { this.cmbPrintK.Enabled = this.chkPrintK.Checked; } private void ultraGrid53_CellChange(object sender, CellEventArgs e) { this.ultraGrid53.UpdateData(); UltraGridRow ur = this.ultraGrid53.ActiveRow; int m = 0; double min = 0.0; if (e.Cell.Column.Key == "Value1" || e.Cell.Column.Key == "Value2" || e.Cell.Column.Key == "Value3") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value2"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value3"].Value.ToString3())) { return; } min = double.Parse(ur.Cells["Value1"].Text.ToString3()); if (double.Parse(ur.Cells["Value2"].Text.ToString3()) < min) { min = double.Parse(ur.Cells["Value2"].Text.ToString3()); } if (double.Parse(ur.Cells["Value3"].Text.ToString3()) < min) { min = double.Parse(ur.Cells["Value3"].Text.ToString3()); } ur.Cells["AverageValue"].Value = Math.Round(min, 3).ToString(); } } private void ultraGrid55_CellChange(object sender, CellEventArgs e) { this.ultraGrid55.UpdateData(); UltraGridRow ur = this.ultraGrid55.ActiveRow; int m = 0; double min = 0.0; if (e.Cell.Column.Key == "Value1" || e.Cell.Column.Key == "Value2" || e.Cell.Column.Key == "Value3") { if (!StringUtil.IsDouble(e.Cell.Row.Cells["Value1"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value2"].Value.ToString3()) || !StringUtil.IsDouble(e.Cell.Row.Cells["Value3"].Value.ToString3())) { return; } min = double.Parse(ur.Cells["Value1"].Text.ToString3()); if (double.Parse(ur.Cells["Value2"].Text.ToString3()) < min) { min = double.Parse(ur.Cells["Value2"].Text.ToString3()); } if (double.Parse(ur.Cells["Value3"].Text.ToString3()) < min) { min = double.Parse(ur.Cells["Value3"].Text.ToString3()); } ur.Cells["AverageValue"].Value = Math.Round(min, 3).ToString(); } } private void ultraGrid13_AfterRowActivate(object sender, EventArgs e) { this.ultraGrid13.UpdateData(); UltraGridRow ur = this.ultraGrid13.ActiveRow; if (ur.Cells["PhyCode"].Text.ToString().Equals("P0048")) { this.TxtYbDefect.Enabled = false; } else { this.TxtYbDefect.Enabled = true; } } private void ultraGrid58_CellChange(object sender, CellEventArgs e) { int m = 1; foreach (UltraGridRow row in this.ultraGrid58.Rows) { m = 1; //落锤试验DWTT 自动计算 if (row.Cells["PhyCodeMin"].Text.ToString().Equals("R0057")) { if (e.Cell.Column.Key == "Value1") { if (!StringUtil.IsInt(row.Cells["Value1"].Text.ToString()) || int.Parse(row.Cells["Value1"].Text.ToString3()) > 100 || int.Parse(row.Cells["Value1"].Text.ToString3()) < 0) { MessageUtil.ShowTips("请输入0到100之间的数字！"); return; } if (row.Cells["Value2"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3())) / m)).ToString(); } if (e.Cell.Column.Key == "Value2") { if (!StringUtil.IsInt(row.Cells["Value2"].Text.ToString()) || int.Parse(row.Cells["Value2"].Text.ToString3()) > 100 || int.Parse(row.Cells["Value2"].Text.ToString3()) < 0) { MessageUtil.ShowTips("请输入0到100之间的数字！"); return; } if (row.Cells["Value1"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3())) / m)).ToString(); } } } } private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { } private void ultraGrid59_CellChange(object sender, CellEventArgs e) { // this.ultraGrid59.UpdateData(); int m = 1; foreach (UltraGridRow row in this.ultraGrid59.Rows) { m = 1; //落锤试验DWTT 自动计算 if (row.Cells["PhyCodeMin"].Text.ToString().Equals("R0057")) { if (e.Cell.Column.Key == "Value1") { if (!StringUtil.IsInt(row.Cells["Value1"].Text.ToString()) || int.Parse(row.Cells["Value1"].Text.ToString3()) > 100 || int.Parse(row.Cells["Value1"].Text.ToString3()) < 0) { MessageUtil.ShowTips("请输入0到100之间的数字！"); return; } if (row.Cells["Value2"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3())) / m)).ToString(); } if (e.Cell.Column.Key == "Value2") { if (!StringUtil.IsInt(row.Cells["Value2"].Text.ToString()) || int.Parse(row.Cells["Value2"].Text.ToString3()) > 100 || int.Parse(row.Cells["Value2"].Text.ToString3()) < 0) { MessageUtil.ShowTips("请输入0到100之间的数字！"); return; } if (row.Cells["Value1"].Text != "") { m = m + 1; } row.Cells["AverageValue"].Value = Math.Round(((double.Parse(row.Cells["Value1"].Text.Trim().ToString3()) + double.Parse(row.Cells["Value2"].Text.ToString3())) / m)).ToString(); } } } } private void ultraGrid59_AfterRowActivate(object sender, EventArgs e) { this.ultraGrid59.UpdateData(); UltraGridRow row = this.ultraGrid59.ActiveRow; if (row == null) return; ultraSAMPLE_JB.Text = row.Cells["SampleJb"].Text; ultraNOTCH_SHAPE.Text = row.Cells["NotchShape"].Text; ultraNOTCH_TYPE.Text = row.Cells["NotchType"].Text; } private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { } } }