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 Core.StlMes.Client.Lims.Data.PipeAndOutdec.封装类.实体类; using CoreFS.CA06; using Infragistics.Win.UltraWinEditors; using Infragistics.Win.UltraWinGrid; using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec.数据管理.外委实验管理 { //管材工程试验条件 public partial class FrmLabEngDataParm : FrmBase { private string CHECK_NO = ""; private string SAMPLE_NO = ""; private string PHY_CODE_MAX = ""; private OpeBase _ob; public FrmLabEngDataParm(string checkNo, string sampleNo, string phyCodeMax, OpeBase ob) { InitializeComponent(); EntityHelper.ShowGridCaption(ultraGrid3.DisplayLayout.Bands[0]); CHECK_NO = checkNo; SAMPLE_NO = sampleNo; PHY_CODE_MAX = phyCodeMax; _ob = ob; //ultraGrid1.ClickCellButton += new CellEventHandler(ultraGrid1_ClickCellButton); //添加缺陷项 //ultraGrid2.ClickCellButton += new CellEventHandler(ultraGrid2_ClickCellButton); //添加缺陷项 Query(); } private void FrmLabEngDataParm_Load(object sender, EventArgs e) { if (PHY_CODE_MAX == "C0036" || PHY_CODE_MAX == "C0037" || PHY_CODE_MAX == "C0066") //联合力、密封性能(含静水压)试验报告 { ultraTabControl1.Tabs[1].Visible = false; ultraTabControl1.Tabs[2].Visible = false; } else if (PHY_CODE_MAX == "C0018" || PHY_CODE_MAX == "C0020" || PHY_CODE_MAX == "C0035" || PHY_CODE_MAX == "C0065")// 压溃、爆破、拉力试验报告 { ultraTabControl1.Tabs[0].Visible = false; ultraTabControl1.Tabs[2].Visible = false; } else if (PHY_CODE_MAX == "C0064")// 上卸扣试验报告 { ultraTabControl1.Tabs[0].Visible = false; ultraTabControl1.Tabs[1].Visible = false; } } /// /// 查询 /// private void Query() { ArrayList list = new ArrayList(); list.Add(CHECK_NO); list.Add(SAMPLE_NO); list.Add(PHY_CODE_MAX); DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmLabDateParm.QueryOutdecCheckconsignDetail", new Object[] { list }, _ob); if (dt.Rows.Count > 0) { DataRow ur = dt.Rows[0]; ShowBaseInfo(ur); } DataTable dtParm = PublicServer.GetData("com.steering.lims.data.pipe.FrmLabDateParm.QueryPipeCheckconsignDetailParm", new Object[] { list }, _ob); GridHelper.CopyDataToDatatable(ref dtParm, ref this.dataTable1, true); GridHelper.CopyDataToDatatable(ref dtParm, ref this.dataTable2, true); List listSource = EntityHelper.GetData( "com.steering.lims.data.pipe.FrmLabDateParm.selectPhydetail", new object[] { list }, this._ob); bindingSource1.DataSource = listSource; GridHelper.RefreshAndAutoSize(this.ultraGrid3); } /// /// 点击Grid编辑区显示基本信息 /// /// public void ShowBaseInfo(DataRow ur) { if (ur != null) { if (PHY_CODE_MAX == "C0036" || PHY_CODE_MAX == "C0037" || PHY_CODE_MAX == "C0066") //联合力、密封性能(含静水压)试验报告 { foreach (DataColumn uc in ur.Table.Columns) { if (ultraPanel1.ClientArea.Controls.ContainsKey("ultra" + uc.ColumnName) == true)//判定是否存在text { ((UltraTextEditor)ultraPanel1.ClientArea.Controls["ultra" + uc.ColumnName]).Text = ur[uc.ColumnName].ToString(); } } } else if (PHY_CODE_MAX == "C0018" || PHY_CODE_MAX == "C0020" || PHY_CODE_MAX == "C0035" || PHY_CODE_MAX == "C0065")// 压溃、爆破、拉力试验报告 { foreach (DataColumn uc in ur.Table.Columns) { if (ultraPanel2.ClientArea.Controls.ContainsKey("ls" + uc.ColumnName) == true)//判定是否存在text { ((UltraTextEditor)ultraPanel2.ClientArea.Controls["ls" + uc.ColumnName]).Text = ur[uc.ColumnName].ToString(); } //else if (ultraPanel2.ClientArea.Controls.ContainsKey("_txt" + uc.ColumnName) == true) //{ // ((UltraComboEditor)ultraPanel2.ClientArea.Controls["_txt" + uc.ColumnName]).Text = ur[uc.ColumnName].ToString(); //} } } else if (PHY_CODE_MAX == "C0064")// 上卸扣试验报告 { foreach (DataColumn uc in ur.Table.Columns) { if (ultraPanel3.ClientArea.Controls.ContainsKey("kk" + uc.ColumnName) == true)//判定是否存在text { ((UltraTextEditor)ultraPanel3.ClientArea.Controls["kk" + uc.ColumnName]).Text = ur[uc.ColumnName].ToString(); } } } } } /// /// 保存联合力、密封性能(含静水压)试验报告 /// /// /// private void ultraButton1_Click(object sender, EventArgs e) { DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryDetailFlag", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX }, _ob); if (int.Parse(ds.Rows[0][0].ToString()) == 5) { MessageUtil.ShowTips("数据已判定接收,不能修改!"); return; } SaveCombinedStress(); MessageUtil.ShowTips("保存成功!"); Query(); } /// /// 保存联合力、密封性能(含静水压)试验报告 /// /// /// private void SaveCombinedStress() { PipeCheckconsignLabResultEntity outdecDetail = new PipeCheckconsignLabResultEntity(); outdecDetail.Standard = ultraSTANDARD.Text; //试验标准 outdecDetail.TestItem = ultraTEST_ITEM.Text; //试验项目 outdecDetail.PressureMedium = ultraPRESSURE_MEDIUM.Text; //压力介质 outdecDetail.Weight = ultraWEIGHT.Text; //单重 outdecDetail.TestResult = ultraTEST_RESULT.Text; //结果评定 outdecDetail.CheckNo = CHECK_NO; outdecDetail.SampleNo = SAMPLE_NO; outdecDetail.PhyCodeMax = PHY_CODE_MAX; string outdecDetailStr = JSONFormat.Format(outdecDetail); ultraGrid1.UpdateData(); ArrayList arrayList = new ArrayList(); for (int i = 0; i < ultraGrid1.Rows.Count; i++) { PipeCheckconsignDtlParmEntity ParmEntity = new PipeCheckconsignDtlParmEntity(); ParmEntity.CheckNo = CHECK_NO; ParmEntity.SampleNo = SAMPLE_NO; ParmEntity.PhyCodeMax = PHY_CODE_MAX; ParmEntity.Step = ultraGrid1.Rows[i].Cells["STEP"].Value.ToString(); ParmEntity.Load = ultraGrid1.Rows[i].Cells["LOAD"].Value.ToString(); ParmEntity.PressureMedium = ultraGrid1.Rows[i].Cells["PRESSURE_MEDIUM"].Value.ToString(); ParmEntity.InternalPressure = ultraGrid1.Rows[i].Cells["INTERNAL_PRESSURE"].Value.ToString(); ParmEntity.DoglegDegree = ultraGrid1.Rows[i].Cells["DOGLEG_DEGREE"].Value.ToString(); ParmEntity.HoldTime = ultraGrid1.Rows[i].Cells["HOLD_TIME"].Value.ToString(); ParmEntity.TestResult = ultraGrid1.Rows[i].Cells["TEST_RESULT"].Value.ToString(); arrayList.Add(JSONFormat.Format(ParmEntity)); } ultraGrid3.UpdateData(); ArrayList arrayList2 = new ArrayList(); for (int i = 0; i < ultraGrid3.Rows.Count; i++) { PipeCheckconsignPhydetailEntity3 ParmEntity = new PipeCheckconsignPhydetailEntity3(); ParmEntity.CheckNo = CHECK_NO; ParmEntity.SampleNo = SAMPLE_NO; ParmEntity.PhyCodeMax = PHY_CODE_MAX; ParmEntity.PhyCode = ultraGrid3.Rows[i].Cells["PhyCode"].Value.ToString(); ParmEntity.Value2 = ultraGrid3.Rows[i].Cells["Value2"].Value.ToString(); arrayList2.Add(JSONFormat.Format(ParmEntity)); } PublicServer.SetData("com.steering.lims.data.pipe.FrmLabDateParm.SaveCombinedStress", new Object[] { outdecDetailStr, arrayList, arrayList2 }, _ob); } /// /// 保存压溃、爆破、拉力试验报告 /// /// /// private void ultraButton2_Click(object sender, EventArgs e) { DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryDetailFlag", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX }, _ob); if (int.Parse(ds.Rows[0][0].ToString()) == 5) { MessageUtil.ShowTips("数据已判定接收,不能修改!"); return; } SaveBurst(); MessageUtil.ShowTips("保存成功!"); Query(); } /// /// 保存压溃、爆破、拉力试验报告 /// private void SaveBurst() { PipeCheckconsignLabResultEntity outdecDetail = new PipeCheckconsignLabResultEntity(); outdecDetail.Standard = lsSTANDARD.Text; //试验标准 outdecDetail.TestItem = lsTEST_ITEM.Text; //试验项目 outdecDetail.PressureMedium = lsPRESSURE_MEDIUM.Text; //压力介质 outdecDetail.Weight = lsWEIGHT.Text; //单重 outdecDetail.TestResult = lsTEST_RESULT.Text; //结果评定 outdecDetail.CheckNo = CHECK_NO; outdecDetail.SampleNo = SAMPLE_NO; outdecDetail.PhyCodeMax = PHY_CODE_MAX; string outdecDetailStr = JSONFormat.Format(outdecDetail); ultraGrid3.UpdateData(); ArrayList arrayList2 = new ArrayList(); for (int i = 0; i < ultraGrid3.Rows.Count; i++) { PipeCheckconsignPhydetailEntity3 ParmEntity = new PipeCheckconsignPhydetailEntity3(); ParmEntity.CheckNo = CHECK_NO; ParmEntity.SampleNo = SAMPLE_NO; ParmEntity.PhyCodeMax = PHY_CODE_MAX; ParmEntity.PhyCode = ultraGrid3.Rows[i].Cells["PhyCode"].Value.ToString(); ParmEntity.Value2 = ultraGrid3.Rows[i].Cells["Value2"].Value.ToString(); arrayList2.Add(JSONFormat.Format(ParmEntity)); } PublicServer.SetData("com.steering.lims.data.pipe.FrmLabDateParm.SaveBurst", new Object[] { outdecDetailStr, arrayList2 }, _ob); } /// /// 保存上卸扣试验条件 /// /// /// private void ultraButton3_Click(object sender, EventArgs e) { DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryDetailFlag", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX }, _ob); if (int.Parse(ds.Rows[0][0].ToString()) == 5) { MessageUtil.ShowTips("数据已判定接收,不能修改!"); return; } saveAntiGallingTest(); MessageUtil.ShowTips("保存成功!"); Query(); } /// /// 保存上卸扣试验条件 /// private void saveAntiGallingTest() { PipeCheckconsignLabResultEntity outdecDetail = new PipeCheckconsignLabResultEntity(); outdecDetail.Standard = kkSTANDARD.Text; //试验标准 outdecDetail.TestItem = kkTEST_ITEM.Text; //试验项目 outdecDetail.PressureMedium = kkPRESSURE_MEDIUM.Text; //压力介质 outdecDetail.Weight = kkWEIGHT.Text; //单重 outdecDetail.TestResult = kkTEST_RESULT.Text; //结果评定 outdecDetail.CheckNo = CHECK_NO; outdecDetail.SampleNo = SAMPLE_NO; outdecDetail.PhyCodeMax = PHY_CODE_MAX; string outdecDetailStr = JSONFormat.Format(outdecDetail); ultraGrid2.UpdateData(); ArrayList arrayList = new ArrayList(); for (int i = 0; i < ultraGrid2.Rows.Count; i++) { PipeCheckconsignDtlParmEntity ParmEntity = new PipeCheckconsignDtlParmEntity(); ParmEntity.CheckNo = CHECK_NO; ParmEntity.SampleNo = SAMPLE_NO; ParmEntity.PhyCodeMax = PHY_CODE_MAX; ParmEntity.Step = ultraGrid2.Rows[i].Cells["STEP"].Value.ToString(); ParmEntity.Pin = ultraGrid2.Rows[i].Cells["PIN"].Value.ToString(); ParmEntity.Box = ultraGrid2.Rows[i].Cells["BOX"].Value.ToString(); ParmEntity.CompoundType = ultraGrid2.Rows[i].Cells["COMPOUND_TYPE"].Value.ToString(); ParmEntity.CompoundWeight = ultraGrid2.Rows[i].Cells["COMPOUND_WEIGHT"].Value.ToString(); ParmEntity.MakeupTorque = ultraGrid2.Rows[i].Cells["MAKEUP_TORQUE"].Value.ToString(); ParmEntity.TotalTorque = ultraGrid2.Rows[i].Cells["TOTAL_TORQUE"].Value.ToString(); ParmEntity.BreakoutTorque = ultraGrid2.Rows[i].Cells["BREAKOUT_TORQUE"].Value.ToString(); ParmEntity.ObservedThreadResult = ultraGrid2.Rows[i].Cells["OBSERVED_THREAD_RESULT"].Value.ToString(); //ParmEntity.TestCurve1 = ultraGrid2.Rows[i].Cells["TEST_CURVE1"].Value.ToString(); //ParmEntity.TestCurve2 = ultraGrid2.Rows[i].Cells["TEST_CURVE2"].Value.ToString(); //ParmEntity.Photo1 = ultraGrid2.Rows[i].Cells["PHOTO1"].Value.ToString(); //ParmEntity.Photo2 = ultraGrid2.Rows[i].Cells["PHOTO2"].Value.ToString(); ParmEntity.ShoulderTorque = ultraGrid2.Rows[i].Cells["SHOULDER_TORQUE"].Value.ToString(); arrayList.Add(JSONFormat.Format(ParmEntity)); } ultraGrid3.UpdateData(); ArrayList arrayList2 = new ArrayList(); for (int i = 0; i < ultraGrid3.Rows.Count; i++) { PipeCheckconsignPhydetailEntity3 ParmEntity = new PipeCheckconsignPhydetailEntity3(); ParmEntity.CheckNo = CHECK_NO; ParmEntity.SampleNo = SAMPLE_NO; ParmEntity.PhyCodeMax = PHY_CODE_MAX; ParmEntity.PhyCode = ultraGrid3.Rows[i].Cells["PhyCode"].Value.ToString(); ParmEntity.Value2 = ultraGrid3.Rows[i].Cells["Value2"].Value.ToString(); arrayList2.Add(JSONFormat.Format(ParmEntity)); } PublicServer.SetData("com.steering.lims.data.pipe.FrmLabDateParm.SaveAntiGallingTest", new Object[] { outdecDetailStr, arrayList, arrayList2 }, _ob); } //private void ultraFILE_PATH1_EditorButtonClick(object sender, EditorButtonEventArgs e) //{ // if (e.Button.Key.ToLower().Equals("select")) // { // if (sender.Equals(ultraFILE_PATH1)) // { // selectFiel(ultraFILE_PATH1); // } // else if (sender.Equals(ultraFILE_PATH2)) // { // selectFiel(ultraFILE_PATH2); // } // else if (sender.Equals(ultraFILE_PATH3)) // { // selectFiel(ultraFILE_PATH3); // } // else if (sender.Equals(ultraFILE_PATH4)) // { // selectFiel(ultraFILE_PATH4); // } // else if (sender.Equals(ultraFILE_PATH5)) // { // selectFiel(ultraFILE_PATH5); // } // else if (sender.Equals(ultraFILE_PATH6)) // { // selectFiel(ultraFILE_PATH6); // } // else if (sender.Equals(ultraFILE_PATH7)) // { // selectFiel(ultraFILE_PATH7); // } // else if (sender.Equals(lsFILE_PATH1)) // { // selectFiel(lsFILE_PATH1); // } // else if (sender.Equals(lsFILE_PATH2)) // { // selectFiel(lsFILE_PATH2); // } // else if (sender.Equals(lsFILE_PATH3)) // { // selectFiel(lsFILE_PATH3); // } // else if (sender.Equals(kkFILE_PATH1)) // { // selectFiel(kkFILE_PATH1); // } // } // else if (e.Button.Key.ToLower().Equals("update")) // { // if (sender.Equals(ultraFILE_PATH1)) // { // updateFile("1"); // SaveCombinedStress(); // } // else if (sender.Equals(ultraFILE_PATH2)) // { // updateFile("2"); // SaveCombinedStress(); // } // else if (sender.Equals(ultraFILE_PATH3)) // { // updateFile("3"); // SaveCombinedStress(); // } // else if (sender.Equals(ultraFILE_PATH4)) // { // updateFile("4"); // SaveCombinedStress(); // } // else if (sender.Equals(ultraFILE_PATH5)) // { // updateFile("5"); // SaveCombinedStress(); // } // else if (sender.Equals(ultraFILE_PATH6)) // { // updateFile("6"); // SaveCombinedStress(); // } // else if (sender.Equals(ultraFILE_PATH7)) // { // updateFile("7"); // SaveCombinedStress(); // } // else if (sender.Equals(lsFILE_PATH1)) // { // updateFile("1"); // SaveCheckconsignDetailParm(); // } // else if (sender.Equals(lsFILE_PATH2)) // { // updateFile("2"); // SaveCheckconsignDetailParm(); // } // else if (sender.Equals(lsFILE_PATH3)) // { // updateFile("3"); // SaveCheckconsignDetailParm(); // } // else if (sender.Equals(kkFILE_PATH1)) // { // updateFile("1"); // saveAntiGallingTest(); // } // Query(); // } //} /// /// 查看图片 /// /// private void selectFiel(UltraTextEditor ultra) { string filePath = ""; if (!ultra.Text.Equals("")) { filePath = ultra.Value.ToString(); } dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath); down.DeleteButton.Visible = false; down.ShowDialog(); } /// /// 上传图片 /// /// private void updateFile(string pathNum) { string path = "Inspection/" + CHECK_NO + "/" + SAMPLE_NO + "/" + PHY_CODE_MAX + "/"; List list = new List(); FileBean bean = new FileBean(); OpenFileDialog file = new OpenFileDialog(); file.Filter = "图片文件(*.jpg);(*.gif);(*.png);(*.bmp)|*.jpg;*.gif;*.png;*.bmp"; file.Title = "选择需要上传的图片"; file.Multiselect = false; DialogResult drStat; drStat = file.ShowDialog(); if (drStat == DialogResult.OK) { string filePath = file.FileName; string fileName = System.IO.Path.GetFileName(filePath); bean = new FileBean(); bean.setFileName(fileName); bean.setPathName(path); bean.setFile(FileHelper.FileToArray(filePath)); list.Add(bean); bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list); if (isSuccess) { int count = ServerHelper.SetData("com.steering.lims.data.outdec.PublicOutdecBase.UpdateFilePath", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, pathNum, path + fileName }, _ob); MessageUtil.ShowTips("上传成功!"); } else { MessageUtil.ShowTips("上传失败,请重试!"); } } } private void ultraGrid1_AfterRowInsert(object sender, RowEventArgs e) { e.Row.Cells["STEP"].Value = dataTable1.Rows.Count + 1; } private void ultraGrid2_AfterRowInsert(object sender, RowEventArgs e) { e.Row.Cells["STEP"].Value = dataTable2.Rows.Count + 1; } private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e) { if (e.Cell.Column.Key == "BTN_DELETE") { for (int i = 0; i < dataTable1.Rows.Count; i++) { ultraGrid1.Rows[i].Cells["STEP"].Value = i + 1; if (dataTable1.Rows[i]["STEP"].ToString() == e.Cell.Row.Cells["STEP"].Value.ToString()) { dataTable1.Rows.RemoveAt(i); break; } } for (int i = 0; i < dataTable1.Rows.Count; i++) { ultraGrid1.Rows[i].Cells["STEP"].Value = i + 1; } ultraGrid1.DataBind(); } } private void ultraGrid2_ClickCellButton(object sender, CellEventArgs e) { if (e.Cell.Column.Key == "BTN_DELETE") { for (int i = 0; i < dataTable2.Rows.Count; i++) { ultraGrid2.Rows[i].Cells["STEP"].Value = i + 1; if (dataTable2.Rows[i]["STEP"].ToString() == e.Cell.Row.Cells["STEP"].Value.ToString()) { dataTable2.Rows.RemoveAt(i); break; } } for (int i = 0; i < dataTable2.Rows.Count; i++) { ultraGrid2.Rows[i].Cells["STEP"].Value = i + 1; } ultraGrid2.DataBind(); } } private void ultraTextEditor1_EditorButtonClick(object sender, EditorButtonEventArgs e) { UltraGridRow row = ultraGrid2.ActiveRow; string step = row.GetValue("STEP"); if (e.Button.Key.ToLower().Equals("select")) { string filePath = ""; if (ultraGrid2.ActiveCell.Column.Key == "TEST_CURVE1") { filePath = row.GetValue("TEST_CURVE1"); } else if (ultraGrid2.ActiveCell.Column.Key == "TEST_CURVE2") { filePath = row.GetValue("TEST_CURVE2"); } else if (ultraGrid2.ActiveCell.Column.Key == "PHOTO1") { filePath = row.GetValue("PHOTO1"); } else if (ultraGrid2.ActiveCell.Column.Key == "PHOTO2") { filePath = row.GetValue("PHOTO2"); } dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath); down.DeleteButton.Visible = false; down.ShowDialog(); } else if (e.Button.Key.ToLower().Equals("update")) { saveAntiGallingTest(); string pathColumn = ultraGrid2.ActiveCell.Column.Key; string path = "Inspection/" + CHECK_NO + "/" + SAMPLE_NO + "/" + PHY_CODE_MAX + "/"; List list = new List(); FileBean bean = new FileBean(); OpenFileDialog file = new OpenFileDialog(); file.Filter = "图片文件(*.jpg);(*.gif);(*.png);(*.bmp)|*.jpg;*.gif;*.png;*.bmp"; file.Title = "选择需要上传的图片"; file.Multiselect = false; DialogResult drStat; drStat = file.ShowDialog(); if (drStat == DialogResult.OK) { string filePath = file.FileName; string fileName = System.IO.Path.GetFileName(filePath); bean = new FileBean(); bean.setFileName(fileName); bean.setPathName(path); bean.setFile(FileHelper.FileToArray(filePath)); list.Add(bean); bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list); if (isSuccess) { int count = ServerHelper.SetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.UpdateFilePath", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, step, pathColumn, path + fileName }, _ob); MessageUtil.ShowTips("上传成功!"); Query(); } else { MessageUtil.ShowTips("上传失败,请重试!"); } } } } } }