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 Core.Mes.Client.Comm.Tool; using System.Collections; using Core.Mes.Client.Comm.Control; using Infragistics.Win; namespace Core.StlMes.Client.Lims.Data.Mat { public partial class FrmMatZbsDataCJ : FrmBase { public FrmMatZbsDataCJ() { InitializeComponent(); } protected override void OnLoad(EventArgs e) { base.OnLoad(e); publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框 publicUltraGridDetail1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框 publicUltraGridDetail2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; } private void FrmMatZbsDataCJ_Load(object sender, EventArgs e) { InitColumns(); } private void InitColumns() { publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件 publicUltraGridBase1.InitColumnsBase(new string[] { "CHECK_NO" }, true, null); publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件 publicUltraGridBase2.InitColumnsBase(new string[] { "CHECK_NO" }, true, null); string[] arrColumns = new string[] { "MAT_CODE", "MAT_NAME", "ZBS_VALUE", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "CHECK_CYCLE", "JUDGE_TYPE_CODE", "JUDGE_TYPE", "CHECK_CONDITION", "REMARK" };//"FLAG","CHK", string[] arrCaption = new string[] { "检验项", "检验项", "质保结果", "下限符号", "下限", "上限符号", "上限", "检验周期", "验收方式", "验收方式", "试验要求", "备注" };//"试样状态","选择", publicUltraGridDetail1.InitColumns(arrColumns, arrCaption); publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "MAT_CODE" }, false); publicUltraGridDetail1.setOtherColumnReadOnly(new string[] { "ZBS_VALUE" });//可编辑列 publicUltraGridDetail2.InitColumns(arrColumns, arrCaption); publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "MAT_CODE" }, false); publicUltraGridDetail2.setOtherColumnReadOnly(new string[] { "ZBS_VALUE" });//可编辑列 } void publicUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e) { matShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur); QueryCheckConsignDetail_Dept(publicUltraGridBase1, publicUltraGridDetail1); } void publicUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e) { matShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur); //matJudgeResultCJ2.ShowBaseInfo(publicUltraGridBase2.Ur); QueryCheckConsignDetail_Dept(publicUltraGridBase2, publicUltraGridDetail2); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { //新增、修改修约值、审核、删除、退出 switch (ToolbarKey) { case "Query": if (ultraTabControl1.SelectedTab.Index == 0) { QueryZbsCheckConsignDetail(publicUltraGridBase1, "0"); } else if (ultraTabControl1.SelectedTab.Index == 1) { QueryZbsCheckConsignDetail(publicUltraGridBase2, "12"); } break; case "Add": AddZbsCheckConsignDetail(); break; case "Update": UpdateZbsCheckConsignDetail(); break; case "Delete": DeleteZbsCheckConsignDetail(); break; case "View": //RepLimsMatCheckResultJudgeBook(); break; case "Close": if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes) { this.Close(); } break; } } //查询检验委托基本信息 private void QueryZbsCheckConsignDetail(PublicUltraGridBase publicUltraGridBase, string strFlag) { try { ArrayList al = matQueryBase1.GetQueryInfo(strFlag); publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("mat.FrmMatZbsDataCJ", al, this.ob, null); if (publicUltraGridBase.Ug.Rows.Count == 0) { if (publicUltraGridBase == publicUltraGridBase1) { matShowBase1.ClearCheckConsign(); publicUltraGridDetail1.DataTable.Rows.Clear(); } else { matShowBase2.ClearCheckConsign(); publicUltraGridDetail2.DataTable.Rows.Clear(); } //ClearCheckConsign(); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } //查询检验委托明细信息 private void QueryCheckConsignDetail_Dept(PublicUltraGridBase publicUltraGridBase, PublicUltraGridDetail publicUltraGridDetail) { try { ArrayList arrayList = new ArrayList(); arrayList.Add(publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim()); publicUltraGridDetail.QueryCheckConsignDetail_Dept("mat.FrmMatZbsDataCJ", arrayList, this.ob, -1, null); //publicUltraGridDetail.setOtherColumnReadOnly(null);//可编辑列 } catch (Exception ex) { MessageUtil.ShowWarning(ex.Message); return; } } private void AddZbsCheckConsignDetail() { try { if (ultraTabControl1.SelectedTab.Index != 0) { MessageUtil.ShowTips("只有选择了未录入数据页才能进行新增操作!"); return; } if (publicUltraGridBase1.Ur == null) { MessageUtil.ShowWarning("请选择需要新增的数据!"); return; } if (publicUltraGridDetail1.DataTable == null || publicUltraGridDetail1.DataTable.Columns.Count < 1 || publicUltraGridDetail1.DataTable.Rows.Count < 1) { MessageUtil.ShowWarning("查不到检验明细数据请刷新重试!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认新增?") == DialogResult.Yes) { publicUltraGridDetail1.Ug.UpdateData(); string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text;//检验委托编号 ArrayList all = new ArrayList(); ArrayList alBase = new ArrayList(); ArrayList alBaseDetail = new ArrayList();//改变主表IS_JUDGE标志位 alBaseDetail.Add(UserInfo.GetUserName()); alBaseDetail.Add(DateTime.Now.ToString()); alBaseDetail.Add(""); alBaseDetail.Add(""); alBaseDetail.Add("1"); alBaseDetail.Add("0"); alBaseDetail.Add(strCHECK_NO); alBase.Add(alBaseDetail); ArrayList alResult = new ArrayList(); ArrayList alResultDetail = new ArrayList(); foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows) { alResultDetail = new ArrayList(); if (dr["JUDGE_TYPE_CODE"].ToString().Trim() == "409002" || dr["JUDGE_TYPE"].ToString().Trim() == "检验") { alResultDetail.Add("");//如果为验证则质保书结果写入实际结果列 alResultDetail.Add("");//如果为验证则质保书结果写入实际结果列 } else { alResultDetail.Add(dr["ZBS_VALUE"].ToString()); alResultDetail.Add(dr["ZBS_VALUE"].ToString()); } alResultDetail.Add(dr["ZBS_VALUE"].ToString()); //alResultDetail.Add(dr["MAT_NAME"].ToString()); alResultDetail.Add(dr["MAT_CODE"].ToString()); alResultDetail.Add(strCHECK_NO); alResult.Add(alResultDetail); } all.Add(alBase); all.Add(alResult); PublicServer.SetData("com.steering.lims.data.mat.FrmMatZbsDataCJ.AddZbsCheckConsignDetail", new Object[] { strCHECK_NO, all }, this.ob); QueryZbsCheckConsignDetail(publicUltraGridBase1, "0"); MessageUtil.ShowTips("新增成功!"); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } private void UpdateZbsCheckConsignDetail() { try { if (ultraTabControl1.SelectedTab.Index != 1) { MessageUtil.ShowTips("只有选择了已录入数据页才能进行修改操作!"); return; } if (publicUltraGridBase2.Ur == null) { MessageUtil.ShowWarning("请选择需要修改的数据!"); return; } if (publicUltraGridDetail2.DataTable == null || publicUltraGridDetail2.DataTable.Columns.Count < 1 || publicUltraGridDetail2.DataTable.Rows.Count < 1) { MessageUtil.ShowWarning("查不到检验明细数据请刷新重试!"); return; } //if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.Yes) //{ WinCancelReason pc = new WinCancelReason(); pc.ShowDialog(); if (pc.DialogResult != DialogResult.OK) { return; } string strSample_Remark = pc.StrRemark; strSample_Remark = this.Text + "修改由于" + strSample_Remark + "(" + UserInfo.GetUserName() + " " + DateTime.Now.ToString() + ")"; publicUltraGridDetail2.Ug.UpdateData(); string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text;//检验委托编号 ArrayList all = new ArrayList(); ArrayList alBase = new ArrayList(); ArrayList alBaseDetail = new ArrayList(); alBaseDetail.Add(UserInfo.GetUserName()); alBaseDetail.Add(DateTime.Now.ToString()); alBaseDetail.Add(strSample_Remark); alBaseDetail.Add(strSample_Remark); alBaseDetail.Add("1"); alBaseDetail.Add("1"); alBaseDetail.Add(strCHECK_NO); alBase.Add(alBaseDetail); ArrayList alResult = new ArrayList(); ArrayList alResultDetail = new ArrayList(); foreach (DataRow dr in publicUltraGridDetail2.DataTable.Rows) { alResultDetail = new ArrayList(); alResultDetail.Add(dr["ZBS_VALUE"].ToString()); alResultDetail.Add(dr["MAT_NAME"].ToString()); alResultDetail.Add(dr["MAT_CODE"].ToString()); alResultDetail.Add(strCHECK_NO); alResult.Add(alResultDetail); } all.Add(alBase); all.Add(alResult); PublicServer.SetData("com.steering.lims.data.mat.FrmMatZbsDataCJ.UpdateZbsCheckConsignDetail", new Object[] { strCHECK_NO, all }, this.ob); QueryZbsCheckConsignDetail(publicUltraGridBase2, "12"); MessageUtil.ShowTips("修改成功!"); //} } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } private void DeleteZbsCheckConsignDetail() { try { if (ultraTabControl1.SelectedTab.Index != 1) { MessageUtil.ShowTips("只有选择了已录入数据页才能进行删除操作!"); return; } if (publicUltraGridBase2.Ur == null) { MessageUtil.ShowWarning("请选择需要删除的数据!"); return; } if (publicUltraGridDetail2.DataTable == null || publicUltraGridDetail2.DataTable.Columns.Count < 1 || publicUltraGridDetail2.DataTable.Rows.Count < 1) { MessageUtil.ShowWarning("查不到检验明细数据请刷新重试!"); return; } //if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.Yes) //{ WinCancelReason pc = new WinCancelReason(); pc.ShowDialog(); if (pc.DialogResult != DialogResult.OK) { return; } string strSample_Remark = pc.StrRemark; strSample_Remark = this.Text + "删除由于" + strSample_Remark + "(" + UserInfo.GetUserName() + " " + DateTime.Now.ToString() + ")"; publicUltraGridDetail2.Ug.UpdateData(); string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text;//检验委托编号 ArrayList all = new ArrayList(); ArrayList alBase = new ArrayList(); ArrayList alBaseDetail = new ArrayList(); alBaseDetail.Add(""); alBaseDetail.Add(""); alBaseDetail.Add(strSample_Remark); alBaseDetail.Add(strSample_Remark); alBaseDetail.Add("0"); alBaseDetail.Add("1"); alBaseDetail.Add(strCHECK_NO); alBase.Add(alBaseDetail); ArrayList alResult = new ArrayList(); ArrayList alResultDetail = new ArrayList(); foreach (DataRow dr in publicUltraGridDetail2.DataTable.Rows) { alResultDetail = new ArrayList(); alResultDetail.Add(""); alResultDetail.Add(dr["MAT_NAME"].ToString()); alResultDetail.Add(dr["MAT_CODE"].ToString()); alResultDetail.Add(strCHECK_NO); alResult.Add(alResultDetail); } all.Add(alBase); all.Add(alResult); PublicServer.SetData("com.steering.lims.data.mat.FrmMatZbsDataCJ.DeleteZbsCheckConsignDetail", new Object[] { strCHECK_NO, all }, this.ob); QueryZbsCheckConsignDetail(publicUltraGridBase2, "12"); MessageUtil.ShowTips("删除成功!"); //} } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } } }