using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Lims.Data.PipeAndOutdec.封装类.实体类; using CoreFS.CA06; 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 FrmAddPhy : FrmBase { private OpeBase _ob; private string _checkNo = ""; public FrmAddPhy(OpeBase ob, string checkNo) { this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; InitializeComponent(); _ob = ob; _checkNo = checkNo; } private void FrmAddPhy_Load(object sender, EventArgs e) { EntityHelper.ShowGridCaption(this.ultraGrid5.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(this.ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(this.ultraGrid2.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(this.ultraGrid3.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(this.ultraGrid4.DisplayLayout.Bands[0]); doQuery(); } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case"AddPhyMax": addPhyMax(); break; case"DeletePhyMax": deletePhyMax(); break; case "Add": addPhy(); break; case"Delete": detePhy(); break; case"UpdateRcl": updateRcl(); break; case "UpdateTsRemark": updateTsRemark(); break; case "Close": CloseForm(); break; } } /// /// 加载数据 /// private void doQuery() { List listSource = EntityHelper.GetData("com.steering.lims.data.pipe.FrmCheckConsignQuery.doQueryCheckNo", new object[] { _checkNo }, _ob); pipeCheckconsignBaseinfoEntityBindingSource.DataSource = listSource; } /// /// 新增试样组 /// private void addPhyMax() { this.ultraGrid3.UpdateData(); this.ultraGrid1.UpdateData(); UltraGridRow mRow = this.ultraGrid5.ActiveRow; if (mRow == null) return; UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; IQueryable checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择新增的试样组!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { CraftOrdDesignStdPicEntity craftPic = (CraftOrdDesignStdPicEntity)row.ListObject; string craftPicEntity = JSONFormat.Format(craftPic); parmList.Add(craftPicEntity); } PipeCheckconsignBaseinfoEntity pipeBase = (PipeCheckconsignBaseinfoEntity)mRow.ListObject; string pipeBaseEntity = JSONFormat.Format(pipeBase); PipeCheckconsignDetailEntity pipeDetailTity = (PipeCheckconsignDetailEntity)uRow.ListObject; string pipeDetailEntity = JSONFormat.Format(pipeDetailTity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignQuery"; ccp.MethodName = "addPhyMax"; ccp.ServerParams = new object[] {pipeBaseEntity, pipeDetailEntity, parmList }; ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("新增成功!")) { doQuery(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 增加检验项 /// private void addPhy() { this.ultraGrid4.UpdateData(); this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; IQueryable checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择新增的检验项!"); return; } ArrayList parmList = new ArrayList(); foreach(UltraGridRow row in checkMagRows) { CraftOrdDesignStdPicEntity craftPic = (CraftOrdDesignStdPicEntity)row.ListObject; string craftPicEntity = JSONFormat.Format(craftPic); parmList.Add(craftPicEntity); } PipeCheckconsignDetailEntity pipeDetailTity = (PipeCheckconsignDetailEntity)uRow.ListObject; string pipeDetailEntity = JSONFormat.Format(pipeDetailTity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignQuery"; ccp.MethodName = "addPhy"; ccp.ServerParams = new object[] { pipeDetailEntity, parmList }; ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("新增成功!")) { doQuery(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 删除检验项 /// private void detePhy() { this.ultraGrid2.UpdateData(); this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; IQueryable checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择删除的检验项!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { PipeCheckconsignPhydetailEntity phyTity = (PipeCheckconsignPhydetailEntity)row.ListObject; string phyEntity = JSONFormat.Format(phyTity); parmList.Add(phyEntity); } PipeCheckconsignDetailEntity pipeDetailTity = (PipeCheckconsignDetailEntity)uRow.ListObject; string pipeDetailEntity = JSONFormat.Format(pipeDetailTity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignQuery"; ccp.MethodName = "detePhy"; ccp.ServerParams = new object[] { pipeDetailEntity,parmList }; ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("删除成功!")) { doQuery(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 删除试样组 /// private void deletePhyMax() { this.ultraGrid1.UpdateData(); this.ultraGrid5.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; UltraGridRow uRow5 = this.ultraGrid5.ActiveRow; if (uRow == null || uRow5 == null) return; IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择删除的试样组!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { PipeCheckconsignDetailEntity phyTity = (PipeCheckconsignDetailEntity)row.ListObject; string phyEntity = JSONFormat.Format(phyTity); parmList.Add(phyEntity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignQuery"; ccp.MethodName = "deletePhyMax"; ccp.ServerParams = new object[] { parmList, uRow5.Cells["HeatNo"].Text, uRow5.Cells["CraftSource"].Text }; ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("删除成功!")) { doQuery(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 小样热处理 /// private void updateRcl() { this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要热处理试样!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { PipeCheckconsignDetailEntity phyTity = (PipeCheckconsignDetailEntity)row.ListObject; string phyEntity = JSONFormat.Format(phyTity); parmList.Add(phyEntity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignQuery"; ccp.MethodName = "updateRcl"; ccp.ServerParams = new object[] { parmList }; ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { doQuery(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 保存试样特殊要求备注 /// private void updateTsRemark() { this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要保存的试样!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { PipeCheckconsignDetailEntity phyTity = (PipeCheckconsignDetailEntity)row.ListObject; string phyEntity = JSONFormat.Format(phyTity); parmList.Add(phyEntity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignQuery"; ccp.MethodName = "updateTsRemark"; ccp.ServerParams = new object[] { parmList }; ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { doQuery(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } private void CloseForm() { this.Close(); } private void ultraGrid5_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraGrid5.ActiveRow; if (uRow == null) return; doQueryPhyMax(uRow); doQueryCraftFile(uRow); } /// /// 查询理化试样组信息 /// private void doQueryCraftFile(UltraGridRow uRow) { PipeCheckconsignBaseinfoEntity baseTity = (PipeCheckconsignBaseinfoEntity)uRow.ListObject; string baseEntity = JSONFormat.Format(baseTity); List listSource = EntityHelper.GetData("com.steering.lims.data.pipe.FrmCheckConsignQuery.doQueryCraftFile", new object[] { baseEntity }, _ob); craftOrdDesignStdPicEntityBindingSource.DataSource = listSource; } /// /// 查询检验单下试样号、试样组信息 /// /// private void doQueryPhyMax(UltraGridRow uRow) { List listSource = EntityHelper.GetData("com.steering.lims.data.pipe.FrmCheckConsignQuery.doQuerySampleNo", new object[] { uRow.Cells["CheckNo"].Text }, _ob); pipeCheckconsignDetailEntityBindingSource.DataSource = listSource; } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; doQueryPhy(uRow); } /// /// 查询检验项 /// /// private void doQueryPhy(UltraGridRow uRow) { List listSource = EntityHelper.GetData("com.steering.lims.data.pipe.FrmCheckConsignQuery.doQueryPhy", new object[] { uRow.Cells["CheckNo"].Text, uRow.Cells["SampleNo"].Text, uRow.Cells["PhyCodeMax"].Text }, _ob); pipeCheckconsignPhydetailEntityBindingSource.DataSource = listSource; } private void ultraGrid3_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraGrid3.ActiveRow; UltraGridRow row = this.ultraGrid5.ActiveRow; if (uRow == null || row == null) return; doQueryCraftFilePhy(uRow,row); } /// /// 查询工艺试样组理化项 /// /// private void doQueryCraftFilePhy(UltraGridRow uRow,UltraGridRow row) { List listSource = EntityHelper.GetData("com.steering.lims.data.pipe.FrmCheckConsignQuery.doQueryCraftFilePhy", new object[] { uRow.Cells["DesginKey"].Text, uRow.Cells["ProcessCode"].Text, uRow.Cells["PhyCodeMin"].Text, uRow.Cells["CraftSource"].Text, row.Cells["Pic"].Text,row.Cells["IndexSeq"].Text }, _ob); craftOrdDesignStdPicEntityBindingSource1.DataSource = listSource; } private void ultraGrid4_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid4.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHK"].Value = true; } } } } }