using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; using System.Collections; using Core.Mes.Client.Comm.Tool; namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec { public partial class FrmCheckConsignAdd : FrmBase { //private DataTable m_dtSelectPhyMax;//已选择的大项 //public DataTable DtSelectPhyMax //{ // get { return m_dtSelectPhyMax; } // set { m_dtSelectPhyMax = value; } //} private string letter = ""; private string[] plineCodes = { }; //private string checkNo = ""; private DataTable m_dtSelectPhySampleCode;//选择的取样码 public DataTable DtSelectPhySampleCode { get { return m_dtSelectPhySampleCode; } set { m_dtSelectPhySampleCode = value; } } private DataTable m_dtSelectPhyMin;//已选择的小项 public DataTable DtSelectPhyMin { get { return m_dtSelectPhyMin; } set { m_dtSelectPhyMin = value; } } private DataTable m_dtSelectPhyR;//已选择的方向温度尺寸 public DataTable DtSelectPhyR { get { return m_dtSelectPhyR; } set { m_dtSelectPhyR = value; } } public FrmCheckConsignAdd() { InitializeComponent(); } protected override void OnLoad(EventArgs e) { base.OnLoad(e); publicUltraGridDetail1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框 publicUltraGridChemDetail1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob); } private void FrmCheckConsignAdd_Load(object sender, EventArgs e) { InitColumns(); InitBase(); } //加载基础信息 private void InitBase() { PublicPipeAndOutdec.InitComboEditor(ultraSTEEL_NO, "com.steering.lims.data.pipe.FrmCheckConsignAdd.queryGrade", "GRADECODE", this.ob, false);//钢种 PublicPipeAndOutdec.InitComboEditor(ultraSTEEL_GRADE, "com.steering.lims.data.pipe.FrmCheckConsignAdd.querySteel", "STEELCODE", this.ob, false);//钢级 PublicPipeAndOutdec.InitComboEditor(ultraPRODUCT_STD, "com.steering.lims.data.pipe.FrmCheckConsignAdd.queryStd", "STD_CODE", this.ob, false);//产品标准 PublicPipeAndOutdec.InitComboEditor(ultraDIMATER, "com.steering.lims.data.pipe.FrmCheckConsignAdd.queryDimater", "SPEC_CODE", this.ob, false);//外径 PublicPipeAndOutdec.InitComboEditor(ultraHEIGHT, "com.steering.lims.data.pipe.FrmCheckConsignAdd.queryHeight", "SPEC_CODE", this.ob, false);//壁厚 } private void InitColumns() { publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(outdecUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件 publicUltraGridDetail1.UltraGrid1.CellChange += new CellEventHandler(UltraGrid1_CellChange); string[] arrColumnsBase = new string[] { "CHECK_NO", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "ISPRODUCER", "SPEC_REQ", "FLAG", "FLAG_DESC", "REMARK", "PLINE_CODE", "CRAFT_SOURCE", "LOT_NO", "CRAFT_PATH", "CRAFT_FILE_NO" }; string[] arrCaptionBase = new string[] { "检验编号", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "特殊要求", "标志位", "标志位", "备注", "产线", "委托类型", "生产批号", "工艺文件路径", "工艺文件号" }; publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase); publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHECK_NO" }, true); publicUltraGridBase1.setOtherColumnReadOnly(null);//可编辑列 string[] arrColumns = new string[] { "CHK", "SAMPLE_NO", "HX", "ONH" };//"FLAG", string[] arrCaption = new string[] { "选择", "样管号", "化学", "ONH" };//"试样状态", publicUltraGridDetail1.InitColumns(arrColumns, arrCaption); //publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "FLAG" }, false);//不需要显示的行 publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.TemplateOnBottom; //加载产线 DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode", new object[] { plineCodes }, ob); if (dt != null && dt.Rows.Count > 0) { PPLINE_CODE.DataSource = dt; PPLINE_CODE.ValueMember = "PLINE_CODE"; PPLINE_CODE.DisplayMember = "PLINE_NAME"; } } void UltraGrid1_CellChange(object sender, CellEventArgs e) { if ((e.Cell.Column.Key.Equals("HX") || e.Cell.Column.Key.Equals("ONH")) && e.Cell.Text.Trim() != "" && publicUltraGridChemDetail1.DataTable.Select("SAMPLE_NO = '" + e.Cell.Row.Cells["SAMPLE_NO"].Text.Trim() + "'").Length == 0) { DataRow dr = publicUltraGridChemDetail1.DataTable.NewRow(); dr["SAMPLE_NO"] = e.Cell.Row.Cells["SAMPLE_NO"].Text.Trim(); publicUltraGridChemDetail1.DataTable.Rows.Add(dr); } else if ((e.Cell.Column.Key.Equals("HX") || e.Cell.Column.Key.Equals("ONH")) && e.Cell.Text.Trim() == "") { foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows) { if (dr["SAMPLE_NO"].ToString() == e.Cell.Row.Cells["SAMPLE_NO"].Text.Trim()) { publicUltraGridChemDetail1.DataTable.Rows.Remove(dr); return; } } } } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { //新增、修改修约值、审核、删除、退出 switch (ToolbarKey) { case "Query": QueryCheckConsignBase(); break; case "Add": AddCheckConsign(); break; case "Update": UpdateCheckConsign(); break; case "Clear": if (MessageUtil.ShowYesNoAndQuestion("是否确认清空？") == DialogResult.Yes) { ClearCheckConsign(); MessageUtil.ShowTips("清空成功！"); } break; case "Delete": DeleteCheckConsign(); break; case "Print": printTrust(); break; case "PrintLable": printLable(); break; case "Close": if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes) { this.Close(); } break; } } //查询检验委托基本信息 /// /// 查询检验委托基本信息 /// private void QueryCheckConsignBase() { try { //PublicPipeBase ArrayList arrayList = new ArrayList(); arrayList = pipeQueryBase1.GetQueryInfo("012"); arrayList.Add(plineCodes); publicUltraGridBase1.QueryCheckConsignBase("pipe.FrmCheckConsignAdd", arrayList, this.ob); if (publicUltraGridBase1.Ug.Rows.Count == 0) { ClearCheckConsign(); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } void outdecUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; ClearCheckConsign(); ultraCRAFT_PATH.DataSource = null; PublicPipeAndOutdec.ShowBaseInfo(publicUltraGridBase1.Ur, panel4); QueryCheckConsignDetail(); QueryCheckConsignChemDetail(); //赋值给全局变量 QueryCheckConsignPhyDetail("pipe.FrmCheckConsignAdd");//对于已经生成的委托单查询大项小项信息 } finally { this.Cursor = Cursors.Default; } } //查询检验委托明细信息 /// /// 查询检验委托明细信息 /// private void QueryCheckConsignDetail() { try { ArrayList al = new ArrayList(); al.Add(""); al.Add(publicUltraGridBase1.Ug.ActiveRow.Cells["CHECK_NO"].Value.ToString()); //al.Add(checkNo); publicUltraGridDetail1.QueryCheckConsignDetail("pipe.PublicPipeBase", al, this.ob, 4); //RefreshAutoSize();//自适应 //if (publicUltraGridDetail1.DataTable != null) //{ // txtCheckNo.Text = publicUltraGridDetail1.DataTable.Rows.Count.ToString(); //} } catch (Exception ex) { MessageUtil.ShowWarning(ex.Message); return; } } //查询检验委托化学明细信息 private void QueryCheckConsignChemDetail() { try { ArrayList al = new ArrayList(); al.Add(""); al.Add(publicUltraGridBase1.Ug.ActiveRow.Cells["CHECK_NO"].Value.ToString()); //al.Add(checkNo); publicUltraGridChemDetail1.QueryCheckConsignChemDetail("pipe.PublicPipeBase", al, this.ob); //RefreshAutoSize();//自适应 } catch (Exception ex) { MessageUtil.ShowWarning(ex.Message); return; } } //查询检验委托基本信息 /// /// 查询检验委托基本信息 /// /// private void QueryCheckConsignPhyDetail(string path) { try { ArrayList arrayList = new ArrayList(); arrayList.Add(publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text); //DataTable dtMax = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignDetail", // new Object[] { arrayList }, ob); //if (dtMax != null) //{ // m_dtSelectPhyMax = dtMax.Copy(); //} DataTable dtSampleCode = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignPhyDetail_SampleCode", new Object[] { arrayList }, ob); if (dtSampleCode != null) { m_dtSelectPhySampleCode = dtSampleCode.Copy(); } DataTable dtMin = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignPhyDetail", new Object[] { arrayList }, ob); if (dtMin != null) { m_dtSelectPhyMin = dtMin.Copy(); } DataTable dtR = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignPhyDetail_R", new Object[] { arrayList }, ob); if (dtR != null) { m_dtSelectPhyR = dtR.Copy(); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key.ToString()) { case "AddPhy": AddPhyItems(); break; } } //增加理化检验项目 /// /// 增加理化检验项目 /// private void AddPhyItems() { //20160704 FrmBaseSelectItems _selectItems = new FrmBaseSelectItems(this.ob);//0810 //_selectItems.DtSelectPhyMax = m_dtSelectPhyMax; _selectItems.DtSelectPhySampleCode = m_dtSelectPhySampleCode;//20160522 _selectItems.DtSelectPhyMin = m_dtSelectPhyMin; _selectItems.DtSelectPhyR = m_dtSelectPhyR; _selectItems.ShowDialog(); //m_dtSelectPhyMax = _selectItems.DtSelectPhyMax;//接受FrmSelectItems参数 m_dtSelectPhySampleCode = _selectItems.DtSelectPhySampleCode; m_dtSelectPhyMin = _selectItems.DtSelectPhyMin; m_dtSelectPhyR = _selectItems.DtSelectPhyR; publicUltraGridDetail1.AddColumns(4, m_dtSelectPhySampleCode, publicUltraGridDetail1.DataTable);//把选中的大项增加到publicUltraGridDetail1.DataTable } //增加检验委托 /// /// 增加检验委托 /// private void AddCheckConsign() { try { if (txtCHECK_NO.Text.Trim() == "") { MessageUtil.ShowWarning("检验编号不能为空！"); return; } if (ultraCRAFT_SOURCE.Value.ToString() == "7") { if (txtHEAT_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("炉号不能为空！"); return; } if (txtBATCH_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("性能批号不能为空！"); return; } if (ultraCRAFT_FILE_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("工艺文件不能为空！"); return; } if (ultraCRAFT_PATH.Text.ToString().Trim() == "") { MessageUtil.ShowTips("工艺文件路径不能为空！"); return; } } if (ultraCRAFT_SOURCE.Value.ToString() == "6") { AddCheckConsignHTT(); } else { if (PPLINE_CODE.Text.Trim() == "") { MessageUtil.ShowTips("产线不能为空!"); return; } string strAddChem = isChem(); if (strAddChem != "") { MessageUtil.ShowWarning(strAddChem); return; } //if (m_dtSelectPhyMax == null || m_dtSelectPhyMin == null || m_dtSelectPhyR == null) //{ // MessageUtil.ShowWarning("请选择合适的检验项目！"); // return; //} if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes) { //string strCHECK_NO = checkNo; string strCHECK_NO = txtCHECK_NO.Text.Trim();//检验委托编号 string strBATCH_NO = txtBATCH_NO.Text.Trim();//性能批号 string SUPPLY_UNIT_CODE = ""; string SUPPLY_UNIT = ""; DataTable dts = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode3", new Object[] { PPLINE_CODE.Value.ToString().Substring(0, 4) }, ob); if (dts.Rows.Count > 0) { SUPPLY_UNIT_CODE = dts.Rows[0]["SUPPLY_UNIT_CODE"].ToString(); SUPPLY_UNIT = dts.Rows[0]["SUPPLY_UNIT"].ToString(); } ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List ArrayList alBase = new ArrayList();//基础表list ArrayList alDetail = new ArrayList();//检验信息详细表list ArrayList alPhyDetail = new ArrayList();//理化信息list ArrayList alChemDetail = new ArrayList();//化学信息list ArrayList alBaseParams = new ArrayList();//基础表参数list ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list ArrayList alPhyDetailParams = new ArrayList();//理化信息参数list ArrayList alChemDetailParams = new ArrayList();//化学信息参数list alBase.Add(GetCheckConsignBase());//增加基础表参数 if (publicUltraGridDetail1.DataTable.Rows.Count > 0) { publicUltraGridDetail1.Ug.UpdateData(); ArrayList al = publicUltraGridChemDetail1.GetCheckChem(); bool isHaveChem = false;//判断是否有化学元素 int i = 0; foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows) { isHaveChem = false; string strSAMPLE_NO = dr["SAMPLE_NO"].ToString().Trim(); DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.querySampleNo", new Object[] { strSAMPLE_NO }, ob); if (dt.Rows.Count > 0) { if (!dt.Rows[0][0].Equals("0")) { MessageUtil.ShowTips("试样号：" + strSAMPLE_NO + "已存在，请换一个试样号!"); return; } } if (dr["CHK"].ToString() == "True" && strSAMPLE_NO != "") { foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns) { if (dc.ColumnName != "CHK" && dc.ColumnName != "SAMPLE_NO" && dr[dc.ColumnName].ToString().Trim() != "")//列不为SAMPLE_NO才增加 { string strPHY_CODE_MAX = dc.ColumnName; string strPHY_NAME_MAX = dc.Caption.Trim(); string strSAMPLE_COUNT = dr[strPHY_CODE_MAX].ToString().Trim(); alDetailParams = new ArrayList();//增加明细表参数 alDetailParams.Add(strCHECK_NO); alDetailParams.Add(strSAMPLE_NO); alDetailParams.Add(strBATCH_NO); alDetailParams.Add(strPHY_CODE_MAX); if (strPHY_CODE_MAX == "HX") { alDetailParams.Add(((ArrayList)al[i])[0]); if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alDetailParams.Add(getDeptID("002001007010")); } else { alDetailParams.Add("002001007010"); } isHaveChem = true; } else if (strPHY_CODE_MAX == "ONH") { alDetailParams.Add(((ArrayList)al[i])[1]); if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alDetailParams.Add(getDeptID("002001007010")); } else { alDetailParams.Add("002001007010"); } isHaveChem = true; } else if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0)//非金属夹杂物、晶粒度、组织都归物理实验室 { alDetailParams.Add(strPHY_NAME_MAX); if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alDetailParams.Add(getDeptID("002001007015")); } else { alDetailParams.Add("002001007015"); } } else { alDetailParams.Add(strPHY_NAME_MAX); if (m_dtSelectPhySampleCode != null && m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'").Length > 0) { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alDetailParams.Add(getDeptID(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString())); } else { alDetailParams.Add(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString()); } } else { alDetailParams.Add(""); } } alDetailParams.Add(strSAMPLE_COUNT); DataRow[] arrAddRDetail = new DataRow[] { }; if (m_dtSelectPhyR != null) { arrAddRDetail = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸 } if (arrAddRDetail.Length > 0) { alDetailParams.Add(arrAddRDetail[0]["ITEM_NAME_F"].ToString());//方向描述 alDetailParams.Add(arrAddRDetail[0]["ITEM_NAME_C"].ToString());//尺寸描述 } else { alDetailParams.Add(""); alDetailParams.Add(""); } alDetail.Add(alDetailParams);//增加明细表参数List //201508.05HC 修改 //增加理化明细信息参数list 没选择则不新增 if (m_dtSelectPhySampleCode != null && m_dtSelectPhyMin != null && m_dtSelectPhyR != null) { DataRow[] arrAddMin = m_dtSelectPhyMin.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的小项 foreach (DataRow drMin in arrAddMin) { //' AND PHY_CODE = '" + drMin["PHY_CODE"].ToString() + "' DataRow[] arrAddR = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸 if (arrAddR.Length == 0) { alPhyDetailParams = new ArrayList(); alPhyDetailParams.Add(strCHECK_NO); alPhyDetailParams.Add(strSAMPLE_NO); alPhyDetailParams.Add(strBATCH_NO); alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码 alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述 if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0) { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alPhyDetailParams.Add(getDeptID("002001007015")); } else { alPhyDetailParams.Add("002001007015"); } //alPhyDetailParams.Add("002001007015");//部门 } else { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alPhyDetailParams.Add(getDeptID(drMin["DEPT_ID"].ToString()));//部门 } else { alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门 } } alPhyDetailParams.Add(drMin["PHY_CODE_MIN"].ToString());//试样组 alPhyDetailParams.Add(drMin["PHY_NAME_MIN"].ToString());//试样组 alPhyDetailParams.Add(drMin["PHY_CODE"].ToString());//检验项代码 alPhyDetailParams.Add(drMin["PHY_NAME"].ToString());//检验项描述 alPhyDetailParams.Add(drMin["PHY_UNIT"].ToString());//值单位 alPhyDetailParams.Add("");//方向代码 alPhyDetailParams.Add("");//方向描述 alPhyDetailParams.Add("");//温度代码 alPhyDetailParams.Add("");//温度描述 alPhyDetailParams.Add("");//尺寸代码 alPhyDetailParams.Add("");//尺寸描述 alPhyDetail.Add(alPhyDetailParams); } else { foreach (DataRow drR in arrAddR) { alPhyDetailParams = new ArrayList(); alPhyDetailParams.Add(strCHECK_NO); alPhyDetailParams.Add(strSAMPLE_NO); alPhyDetailParams.Add(strBATCH_NO); alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码 alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述 if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0) { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alPhyDetailParams.Add(getDeptID("002001007015")); } else { alPhyDetailParams.Add("002001007015"); } //alPhyDetailParams.Add("002001007015");//部门 } else { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alPhyDetailParams.Add(getDeptID(drMin["DEPT_ID"].ToString()));//部门 } else { alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门 } //alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门 } alPhyDetailParams.Add(drMin["PHY_CODE_MIN"].ToString());//试样组 alPhyDetailParams.Add(drMin["PHY_NAME_MIN"].ToString());//试样组 alPhyDetailParams.Add(drMin["PHY_CODE"].ToString());//检验项代码 alPhyDetailParams.Add(drMin["PHY_NAME"].ToString());//检验项描述 alPhyDetailParams.Add(drMin["PHY_UNIT"].ToString());//值单位 alPhyDetailParams.Add(drR["ITEM_CODE_F"].ToString());//方向代码 alPhyDetailParams.Add(drR["ITEM_NAME_F"].ToString());//方向描述 alPhyDetailParams.Add(drR["ITEM_CODE_W"].ToString());//温度代码 alPhyDetailParams.Add(drR["ITEM_NAME_W"].ToString());//温度描述 alPhyDetailParams.Add(drR["ITEM_CODE_C"].ToString());//尺寸代码 alPhyDetailParams.Add(drR["ITEM_NAME_C"].ToString());//尺寸描述 alPhyDetail.Add(alPhyDetailParams); } } } } } } } if (isHaveChem) { i++; } } } if (publicUltraGridChemDetail1.Ug.Rows.Count > 0) { publicUltraGridChemDetail1.Ug.UpdateData(); foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows) { foreach (DataColumn dc in publicUltraGridChemDetail1.DataTable.Columns) { string strCHEM_NAME = dc.Caption; DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.querySampleNoHX", new Object[] { dr["SAMPLE_NO"].ToString() }, ob); if (dt.Rows.Count > 0) { if (!dt.Rows[0][0].Equals("0")) { MessageUtil.ShowTips("试样号：" + dr["SAMPLE_NO"].ToString() + "已存在，请换一个试样号!"); return; } } if (strCHEM_NAME != "样管号" && dr["ANA_" + strCHEM_NAME.ToUpper()].ToString() == "√") { alChemDetailParams = new ArrayList();//增加化学明细表参数 alChemDetailParams.Add(strCHECK_NO); alChemDetailParams.Add(dr["SAMPLE_NO"].ToString()); alChemDetailParams.Add(strBATCH_NO); alChemDetailParams.Add(strCHEM_NAME); alChemDetailParams.Add(strCHEM_NAME); alChemDetail.Add(alChemDetailParams); } } } } alAll.Add(alBase); //alAll.Add(alJg); alAll.Add(alDetail); alAll.Add(alPhyDetail); alAll.Add(alChemDetail); PublicServer.SetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.AddCheckConsign", new Object[] { strCHECK_NO, alAll }, this.ob); //生产补样 if (ultraCRAFT_SOURCE.Value.ToString() == "7") { //ultraCRAFT_FILE_NO.Text AddCheckConsignBY(alDetail); } else { MessageUtil.ShowTips("新增成功！"); } } } QueryCheckConsignBase(); } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } //判断化学录入是否符合规则 /// /// 判断化学录入是否符合规则 /// /// private string isChem() { publicUltraGridDetail1.Ug.UpdateData(); if (publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns.Exists("SAMPLE_NO") && publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns.Exists("CHK")) { bool isHaveItems = false; string strTemp = ""; foreach (UltraGridRow ur in publicUltraGridDetail1.Ug.Rows) { if (ur.Cells["CHK"].Text.Trim() == "True") { isHaveItems = false; if (ur.Cells["SAMPLE_NO"].Text.Trim() == "") { return "试样号不能为空！"; } else { foreach (UltraGridColumn uc in publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns) { if (uc.Key != "CHK" && uc.Key != "SAMPLE_NO") { if (ur.Cells[uc.Key].Text.Trim() != "") { isHaveItems = true; } } } if (isHaveItems == false) { return "试样号" + ur.Cells["SAMPLE_NO"].Text.Trim() + "没有选择检验项目！"; } if (strTemp == ur.Cells["SAMPLE_NO"].Text.Trim()) { return "存在相同的试样号请重新输入！"; } else { strTemp = ur.Cells["SAMPLE_NO"].Text.Trim(); } } } } if (isHaveItems == false) { return "请勾选至少一条试样号信息！"; } } string strFlag = "";//存放有化学元素的样管号 string strType = "";//存放化学元素类型标示 //publicUltraGridDetail1.Ug.UpdateData(); foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows) { bool IsHaveChemCol = false; bool IsHaveONHCol = false; //bool IsNull = false; foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns) { if (dc.ColumnName == "HX" && dr["HX"].ToString() != "") { IsHaveChemCol = true; } if (dc.ColumnName == "ONH" && dr["ONH"].ToString() != "") { IsHaveONHCol = true; } } if (IsHaveChemCol == true && IsHaveONHCol == true) { strFlag += dr["SAMPLE_NO"].ToString() + " "; strType += "ALL" + " "; } else if (IsHaveChemCol == true && IsHaveONHCol == false) { strFlag += dr["SAMPLE_NO"].ToString() + " "; strType += "HX" + " "; } else if (IsHaveChemCol == false && IsHaveONHCol == true) { strFlag += dr["SAMPLE_NO"].ToString() + " "; strType += "ONH" + " "; } } if (strFlag == "") { return ""; } else { string[] arrFlag = strFlag.Trim().Split(' '); string[] arrType = strType.Trim().Split(' '); bool isHaveChem; bool isHaveONH; publicUltraGridChemDetail1.Ug.UpdateData(); foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows) { isHaveChem = false; isHaveONH = false; string strSAMPLE_NO = dr["SAMPLE_NO"].ToString(); if (strFlag.IndexOf(strSAMPLE_NO) < 0) { return "化学元素选择输入了不正确的样管号！"; } for (int i = 0; i < arrFlag.Length; i++) { if (arrFlag[i] == strSAMPLE_NO) { if (dr["ANA_O"].ToString() == "√" || dr["ANA_N"].ToString() == "√" || dr["ANA_H"].ToString() == "√") { isHaveONH = true; } foreach (string strChem in PublicPipeAndOutdec.chemMin.Split(' ')) { if ("ONH".IndexOf(strChem) < 0 && dr["ANA_" + strChem.ToUpper()].ToString() == "√") { isHaveChem = true; } } if (arrType[i] == "HX") { if (isHaveONH == true) { return "样管号" + strSAMPLE_NO + "输入了ONH！"; } if (isHaveChem == false) { return "样管号" + strSAMPLE_NO + "请选择化学元素！"; } } else if (arrType[i] == "ONH") { if (isHaveChem == true) { return "样管号" + strSAMPLE_NO + "选择了化学元素请填写试样数！"; } if (isHaveONH == false) { return "样管号" + strSAMPLE_NO + "请选择ONH！"; } } else if (arrType[i] == "ALL") { if (isHaveChem == false && isHaveONH == false) { return "样管号" + strSAMPLE_NO + "请选择化学元素和ONH！"; } else if (isHaveChem == false) { return "样管号" + strSAMPLE_NO + "请选择化学元素！"; } else if (isHaveONH == false) { return "样管号" + strSAMPLE_NO + "请选择ONH！"; } } } } } } return ""; } //获取检验委托基本信息 /// /// 获取检验委托基本信息 /// /// private ArrayList GetCheckConsignBase() { string SUPPLY_UNIT_CODE = ""; string SUPPLY_UNIT = ""; DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode3", new Object[] { PPLINE_CODE.Value.ToString().Substring(0, 4) }, ob); if (dt.Rows.Count > 0) { SUPPLY_UNIT_CODE = dt.Rows[0]["SUPPLY_UNIT_CODE"].ToString(); SUPPLY_UNIT = dt.Rows[0]["SUPPLY_UNIT"].ToString(); } ArrayList al = new ArrayList(); al.Add(txtCHECK_NO.Text); //al.Add(checkNo); al.Add(txtHEAT_NO.Text); al.Add(ultraSTEEL_GRADE.Text); al.Add(ultraSTEEL_NO.Text);//钢号 //al.Add(txtLARGE_SAMPLE_COUNT.Text);//样管数 al.Add(txtLOT_NO.Text);//生产批号 if (ultraCRAFT_PATH.Value == null) { al.Add(""); //工艺文件路径 } else { al.Add(ultraCRAFT_PATH.Value.ToString()); //工艺文件路径 } al.Add(ultraCRAFT_FILE_NO.Text);//工艺文件名称 al.Add(ultraPRODUCT_STD.Text); al.Add(txtCONTRACT_NO.Text); al.Add(ultraDIMATER.Text); al.Add(ultraHEIGHT.Text); al.Add(ultraCONSIGN_DEPT.Text == "" ? this.UserInfo.GetDepartment() : ultraCONSIGN_DEPT.Text);//委托单位 al.Add(ultraCONSIGN_NAME.Text == "" ? UserInfo.GetUserName() : ultraCONSIGN_NAME.Text); al.Add(ultraISPRODUCER.Text == "" ? "0" : ultraISPRODUCER.Value); al.Add(txtSPEC_REQ.Text);//特殊要求 al.Add("1");//默认委托单位已送样 al.Add(txtREMARK.Text);//备注 al.Add("1");//数据类型 1 人工委托 al.Add(PPLINE_CODE.Value.ToString().Substring(0, 4));//产线代码 al.Add(PPLINE_CODE.Value.ToString().Substring(4,1));//工序代码 al.Add(ultraCRAFT_SOURCE.Value.ToString2());//试样类型 al.Add(txtBATCH_NO.Text);//性能批号 al.Add(SUPPLY_UNIT_CODE);//制造商 al.Add(SUPPLY_UNIT);//制造商 return al; } //清空检验委托 /// /// 清空检验委托 /// private void ClearCheckConsign() { ClearCheckConsignBase(); publicUltraGridDetail1.DataTable.Rows.Clear(); PublicPipeAndOutdec.ReMoveColumns(publicUltraGridDetail1.DataTable, 4);//清除列 publicUltraGridChemDetail1.DataTable.Rows.Clear(); //if (m_dtSelectPhyMax != null) //{ // m_dtSelectPhyMax.Rows.Clear(); //} if (m_dtSelectPhySampleCode != null) { m_dtSelectPhySampleCode.Rows.Clear(); } if (m_dtSelectPhyMin != null) { m_dtSelectPhyMin.Rows.Clear(); } if (m_dtSelectPhyR != null) { m_dtSelectPhyR.Rows.Clear(); }//清理内存表 } private void ClearCheckConsignBase() { //txtCHECK_NO.Text = ""; txtCHECK_NO.Text = ""; txtHEAT_NO.Text = ""; ultraSTEEL_GRADE.Text = ""; ultraSTEEL_NO.Text = "";//钢号 ultraPRODUCT_STD.Text = ""; txtCONTRACT_NO.Text = ""; ultraDIMATER.Text = ""; ultraHEIGHT.Text = ""; ultraCONSIGN_DEPT.Text = "";//委托单位 ultraCONSIGN_NAME.Text = ""; txtCONSIGN_TIME.Text = ""; ultraISPRODUCER.Text = "否"; txtSPEC_REQ.Text = "";//特殊要求 txtREMARK.Text = "";//备注 txtLOT_NO.Text = ""; ultraCRAFT_PATH.Text = ""; ultraCRAFT_FILE_NO.Text = ""; } //修改检验委托 /// /// 修改检验委托 /// private void UpdateCheckConsign() { try { if (publicUltraGridBase1.Ur == null) { MessageUtil.ShowWarning("请选择需要修改的数据！"); return; } if (ultraCRAFT_SOURCE.Value.ToString() == "7") { if (txtHEAT_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("炉号不能为空！"); return; } if (txtBATCH_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("性能批号不能为空！"); return; } } if (ultraCRAFT_SOURCE.Value.ToString() == "6") { AddCheckConsignHTT(); } else { if (PPLINE_CODE.Text.Trim() == "") { MessageUtil.ShowTips("产线不能为空!"); return; } string strAddChem = isChem(); if (strAddChem != "") { MessageUtil.ShowWarning(strAddChem); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes) { //判断状态位 string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim(); string strBATCH_NO = txtBATCH_NO.Text.Trim();//性能批号 string SUPPLY_UNIT_CODE = ""; string SUPPLY_UNIT = ""; DataTable dts = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode3", new Object[] { PPLINE_CODE.Value.ToString().Substring(0, 4) }, ob); if (dts.Rows.Count > 0) { SUPPLY_UNIT_CODE = dts.Rows[0]["SUPPLY_UNIT_CODE"].ToString(); SUPPLY_UNIT = dts.Rows[0]["SUPPLY_UNIT"].ToString(); } ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List ArrayList alBase = new ArrayList();//基础表list ArrayList alDetail = new ArrayList();//检验信息详细表list ArrayList alPhyDetail = new ArrayList();//理化信息list ArrayList alChemDetail = new ArrayList();//化学信息list ArrayList alBaseParams = new ArrayList();//基础表参数list ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list ArrayList alPhyDetailParams = new ArrayList();//理化信息参数list ArrayList alChemDetailParams = new ArrayList();//化学信息参数list alBase.Add(GetCheckConsignBase());//增加基础表参数 if (publicUltraGridDetail1.DataTable.Rows.Count > 0) { publicUltraGridDetail1.Ug.UpdateData(); ArrayList al = publicUltraGridChemDetail1.GetCheckChem(); bool isHaveChem = false;//判断是否有化学元素 int i = 0; foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows) { isHaveChem = false; string strSAMPLE_NO = dr["SAMPLE_NO"].ToString().Trim(); if (strSAMPLE_NO != "") { foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns) { if (dc.ColumnName != "CHK" && dc.ColumnName != "SAMPLE_NO" && dr[dc.ColumnName].ToString().Trim() != "")//列不为SAMPLE_NO才增加 { string strPHY_CODE_MAX = dc.ColumnName; string strPHY_NAME_MAX = dc.Caption.Trim(); string strSAMPLE_COUNT = dr[strPHY_CODE_MAX].ToString().Trim(); alDetailParams = new ArrayList();//增加明细表参数 alDetailParams.Add(strCHECK_NO); alDetailParams.Add(strSAMPLE_NO); alDetailParams.Add(strBATCH_NO); //alDetailParams.Add(strSAMPLE_SIZE); alDetailParams.Add(strPHY_CODE_MAX); if (strPHY_CODE_MAX == "HX") { alDetailParams.Add(((ArrayList)al[i])[0]); if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alDetailParams.Add(getDeptID("002001007010")); } else { alDetailParams.Add("002001007010"); } isHaveChem = true; } else if (strPHY_CODE_MAX == "ONH") { alDetailParams.Add(((ArrayList)al[i])[1]); if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alDetailParams.Add(getDeptID("002001007010")); } else { alDetailParams.Add("002001007010"); } isHaveChem = true; } else if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0)//非金属夹杂物、晶粒度、组织都归物理实验室 { alDetailParams.Add(strPHY_NAME_MAX); if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alDetailParams.Add(getDeptID("002001007015")); } else { alDetailParams.Add("002001007015"); } } else { alDetailParams.Add(strPHY_NAME_MAX); if (m_dtSelectPhySampleCode != null && m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'").Length > 0) { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alDetailParams.Add(getDeptID(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString())); } else { alDetailParams.Add(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString()); } } else { alDetailParams.Add(""); } } alDetailParams.Add(strSAMPLE_COUNT); DataRow[] arrAddRDetail = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸 if (arrAddRDetail.Length > 0) { alDetailParams.Add(arrAddRDetail[0]["ITEM_NAME_F"].ToString());//方向描述 alDetailParams.Add(arrAddRDetail[0]["ITEM_NAME_C"].ToString());//尺寸描述 } else { alDetailParams.Add(""); alDetailParams.Add(""); } alDetail.Add(alDetailParams);//增加明细表参数List //201508.05HC 修改 //增加理化明细信息参数list 没选择则不新增 if (m_dtSelectPhySampleCode != null && m_dtSelectPhyMin != null && m_dtSelectPhyR != null) { DataRow[] arrAddMin = m_dtSelectPhyMin.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的小项 foreach (DataRow drMin in arrAddMin) { // AND PHY_CODE = '" + drMin["PHY_CODE"].ToString() + "' DataRow[] arrAddR = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸 if (arrAddR.Length == 0) { alPhyDetailParams = new ArrayList(); alPhyDetailParams.Add(strCHECK_NO); alPhyDetailParams.Add(strSAMPLE_NO); alPhyDetailParams.Add(strBATCH_NO); alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码 alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述 if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0) { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alPhyDetailParams.Add(getDeptID("002001007015")); } else { alPhyDetailParams.Add("002001007015"); }//部门 } else { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alPhyDetailParams.Add(getDeptID(drMin["DEPT_ID"].ToString())); } else { alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门 } } alPhyDetailParams.Add(drMin["PHY_CODE_MIN"].ToString());//试样组 alPhyDetailParams.Add(drMin["PHY_NAME_MIN"].ToString());//试样组 alPhyDetailParams.Add(drMin["PHY_CODE"].ToString());//检验项代码 alPhyDetailParams.Add(drMin["PHY_NAME"].ToString());//检验项描述 alPhyDetailParams.Add(drMin["PHY_UNIT"].ToString());//值单位 alPhyDetailParams.Add("");//方向代码 alPhyDetailParams.Add("");//方向描述 alPhyDetailParams.Add("");//温度代码 alPhyDetailParams.Add("");//温度描述 alPhyDetailParams.Add("");//尺寸代码 alPhyDetailParams.Add("");//尺寸描述 alPhyDetail.Add(alPhyDetailParams); } else { foreach (DataRow drR in arrAddR) { alPhyDetailParams = new ArrayList(); alPhyDetailParams.Add(strCHECK_NO); alPhyDetailParams.Add(strSAMPLE_NO); alPhyDetailParams.Add(strBATCH_NO); alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码 alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述 if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0) { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alPhyDetailParams.Add(getDeptID("002001007015")); } else { alPhyDetailParams.Add("002001007015"); } //alPhyDetailParams.Add("002001007015");//部门 } else { if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) { alPhyDetailParams.Add(getDeptID(drMin["DEPT_ID"].ToString())); } else { alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门 } //alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门 } alPhyDetailParams.Add(drMin["PHY_CODE_MIN"].ToString());//试样组 alPhyDetailParams.Add(drMin["PHY_NAME_MIN"].ToString());//试样组 alPhyDetailParams.Add(drMin["PHY_CODE"].ToString());//检验项代码 alPhyDetailParams.Add(drMin["PHY_NAME"].ToString());//检验项描述 alPhyDetailParams.Add(drMin["PHY_UNIT"].ToString());//值单位 alPhyDetailParams.Add(drR["ITEM_CODE_F"].ToString());//方向代码 alPhyDetailParams.Add(drR["ITEM_NAME_F"].ToString());//方向描述 alPhyDetailParams.Add(drR["ITEM_CODE_W"].ToString());//温度代码 alPhyDetailParams.Add(drR["ITEM_NAME_W"].ToString());//温度描述 alPhyDetailParams.Add(drR["ITEM_CODE_C"].ToString());//尺寸代码 alPhyDetailParams.Add(drR["ITEM_NAME_C"].ToString());//尺寸描述 alPhyDetail.Add(alPhyDetailParams); } } } } } } } if (isHaveChem) { i++; } } } if (publicUltraGridChemDetail1.Ug.Rows.Count > 0) { publicUltraGridChemDetail1.Ug.UpdateData(); foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows) { foreach (DataColumn dc in publicUltraGridChemDetail1.DataTable.Columns) { string strCHEM_NAME = dc.Caption; if (strCHEM_NAME != "样管号" && dr["ANA_" + strCHEM_NAME.ToUpper()].ToString() == "√") { alChemDetailParams = new ArrayList();//增加化学明细表参数 alChemDetailParams.Add(strCHECK_NO); alChemDetailParams.Add(dr["SAMPLE_NO"].ToString()); alChemDetailParams.Add(strBATCH_NO); alChemDetailParams.Add(strCHEM_NAME); alChemDetailParams.Add(strCHEM_NAME); alChemDetail.Add(alChemDetailParams); } } } } alAll.Add(alBase); //alAll.Add(alJg); alAll.Add(alDetail); alAll.Add(alPhyDetail); alAll.Add(alChemDetail); PublicServer.SetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.UpdateCheckConsign", new Object[] { strCHECK_NO, alAll }, this.ob); if (ultraCRAFT_SOURCE.Value.ToString() == "7") { AddCheckConsignBY(alDetail); } //QueryCheckConsignBase(); //PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, "CHECK_NO", strCHECK_NO); MessageUtil.ShowTips("修改成功！"); } } QueryCheckConsignBase(); } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } /// /// 委外热处理样 /// private void AddCheckConsignHTT() { if (txtCONTRACT_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("合同号不能为空！"); return; } if (txtHEAT_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("炉号不能为空！"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignAdd"; ccp.MethodName = "AddCheckConsignHTT"; ccp.ServerParams = new object[] { txtCHECK_NO.Text, txtHEAT_NO.Text, txtCONTRACT_NO.Text}; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnInfo == "委外热处理样！") { MessageUtil.ShowTips("新增成功!"); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } /// /// 生产补样 /// private void AddCheckConsignBY(ArrayList alDetailParams) { if (txtCONTRACT_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("合同号不能为空！"); return; } if (txtHEAT_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("炉号不能为空！"); return; } if (txtBATCH_NO.Text.ToString().Trim() == "") { MessageUtil.ShowTips("性能批号不能为空！"); return; } ArrayList list = new ArrayList(); list.Add(txtCHECK_NO.Text); list.Add(txtHEAT_NO.Text); list.Add(txtBATCH_NO.Text); list.Add(txtCONTRACT_NO.Text); list.Add(PPLINE_CODE.Value.ToString().Substring(0, 4)); list.Add(ultraCRAFT_FILE_NO.Text); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignAdd"; ccp.MethodName = "AddCheckConsignBY"; ccp.ServerParams = new object[] { list, alDetailParams }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnInfo == "生产补样！") { MessageUtil.ShowTips("新增成功！"); } else { MessageUtil.ShowTips(ccp.ReturnInfo); string strCHECK_NO = txtCHECK_NO.Text.Trim(); ArrayList al = new ArrayList(); al.Add(strCHECK_NO); int i = PublicServer.SetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.DeleteCheckConsign", new Object[] { strCHECK_NO, al }, this.ob); QueryCheckConsignBase(); } } //删除检验委托new 方法 /// /// 删除检验委托new 方法 /// private void DeleteCheckConsign() { try { if (publicUltraGridBase1.Ur == null) { MessageUtil.ShowWarning("请选择需要删除的数据！"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes) { string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim(); ArrayList al = new ArrayList(); al.Add(strCHECK_NO); int i = PublicServer.SetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.DeleteCheckConsign", new Object[] { strCHECK_NO, al }, this.ob); if (ultraCRAFT_SOURCE.Value.ToString() == "6" || ultraCRAFT_SOURCE.Value.ToString() == "7") { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignAdd"; ccp.MethodName = "DeleteCheckConsignHTT"; ccp.ServerParams = new object[] { txtCHECK_NO.Text, txtHEAT_NO.Text }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnInfo == "委外热处理样！") { } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } QueryCheckConsignBase(); MessageUtil.ShowTips("删除成功！"); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } //private void ultraComType_ValueChanged(object sender, EventArgs e) //{ // if (ultraCRAFT_SOURCE.Value.ToString2().Equals("2")) // { // letter = "K"; // } // else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("3")) // { // letter = "Y"; // } // else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("4")) // { // letter = "W"; // } // else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("5")) // { // letter = "N"; // } // DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.getCheckNo", new object[] { letter, ultraCRAFT_SOURCE.Value.ToString2() }, ob); // txtCHECK_NO.Text = ds.Rows[0][0].ToString(); // //checkNo = ds.Rows[0][0].ToString(); //} private void ultraButton1_Click(object sender, EventArgs e) { if (ultraCRAFT_SOURCE.Value.ToString2().Equals("2")) { letter = "K"; } else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("3")) { letter = "Y"; } else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("4")) { letter = "W"; } else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("5")) { letter = "N"; } else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("6")) { letter = "M"; } else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("7")) { letter = "O"; } DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.getCheckNo", new object[] { letter, ultraCRAFT_SOURCE.Value.ToString2() }, ob); txtCHECK_NO.Text = ds.Rows[0][0].ToString(); //checkNo = ds.Rows[0][0].ToString(); } /// /// 打印 /// private void printTrust() { this.publicUltraGridBase1.Ug.UpdateData(); UltraGridRow uRow = this.publicUltraGridBase1.Ug.ActiveRow; if (uRow == null) return; string checkNo = uRow.Cells["CHECK_NO"].Text.Trim(); string strurl = ""; strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPortCheckConsignOrder.cpt" + "&CHECK_NO=" + checkNo; FrmRepExcel fBug = new FrmRepExcel(ob, strurl); fBug.AutoSize = true; fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.WindowState = FormWindowState.Maximized; fBug.Text = "检验委托单"; fBug.Show(); } /// /// 打印标签 /// private void printLable() { this.publicUltraGridBase1.Ug.UpdateData(); UltraGridRow uRow = this.publicUltraGridBase1.Ug.ActiveRow; if (uRow == null) return; string checkNo = uRow.Cells["CHECK_NO"].Text.Trim(); string strurl = ""; strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepEntrustLabelSD.cpt" + "&CHECK_NO=" + checkNo; FrmRepExcel fBug = new FrmRepExcel(ob, strurl); fBug.AutoSize = true; fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.WindowState = FormWindowState.Maximized; fBug.Text = "样管号标签"; fBug.Show(); } private void PPLINE_CODE_ValueChanged(object sender, EventArgs e) { if (!"".Equals(PPLINE_CODE.Value.ToString())) { DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode", new object[] { PPLINE_CODE.Value.ToString() }, ob); if (dt != null && dt.Rows.Count > 0) { PPLINE_CODE.Value = dt.Rows[0]["PLINE_CODE"].ToString(); PPLINE_CODE.Text = dt.Rows[0]["PLINE_NAME"].ToString(); } } } private void txtCONTRACT_NO_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 13) { //工艺文件 DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.initCraftPath", new object[] { txtCONTRACT_NO.Text }, ob); if (dt != null && dt.Rows.Count > 0) { ultraCRAFT_PATH.DataSource = dt; ultraCRAFT_PATH.ValueMember = "CRAFT_PATH"; ultraCRAFT_PATH.DisplayMember = "CRAFT_PATH"; } } } /// /// 更新天淮实验室 /// /// /// public string getDeptID(string DeptID) { string newDeptID = ""; DataTable dts = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.getDeptIdTH", new Object[] { DeptID }, ob); if (dts.Rows.Count > 0) { newDeptID = dts.Rows[0]["newDeptID"].ToString(); } return newDeptID; } } }