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 FrmMatJudgeResultCJ : FrmBase { public FrmMatJudgeResultCJ() { 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 FrmMatJudgeResultCJ_Load(object sender, EventArgs e) { InitColumns(); } private void InitColumns() { publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件 publicUltraGridBase1.InitColumnsBase(new string[] { "CHECK_NO" }, true, null); string[] arrColumns = new string[] { "SAMPLE_NO" };//"FLAG","CHK", string[] arrCaption = new string[] { "试样号" };//"试样状态","选择", publicUltraGridDetail1.InitColumns(arrColumns, arrCaption); publicUltraGridDetail1.setOtherColumnReadOnly(null);//可编辑列 publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件 publicUltraGridBase2.InitColumnsBase(new string[] { "CHECK_NO", "FLAG_DESC" }, true, null); publicUltraGridDetail2.InitColumns(arrColumns, arrCaption); publicUltraGridDetail2.setOtherColumnReadOnly(null);//可编辑列 //matJudgeResultCJ1.QueryMatJudgeGrade(ob); //matJudgeResultCJ2.QueryMatJudgeGrade(ob); matJudgeResultCJ1.btnOk.Click += new EventHandler(btnOk_Click); matJudgeResultCJ2.btnOk.Click += new EventHandler(btnOk_Click_); } void btnOk_Click(object sender, EventArgs e) { string result = ""; foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows) { if (dr["SAMPLE_NO"].ToString() == "") { continue; } result += dr["SAMPLE_NO"].ToString() + "("; foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns) { if (dc.ColumnName == "SAMPLE_NO") { continue; } result += dc.Caption + ":" + dr[dc.ColumnName].ToString() + ";"; } result = result.Remove(result.Length - 1) + ");"; matJudgeResultCJ1.StrRemark = result; } } void btnOk_Click_(object sender, EventArgs e) { string result = ""; foreach (DataRow dr in publicUltraGridDetail2.DataTable.Rows) { if (dr["SAMPLE_NO"].ToString() == "") { continue; } result += dr["SAMPLE_NO"].ToString() + "("; foreach (DataColumn dc in publicUltraGridDetail2.DataTable.Columns) { if (dc.ColumnName == "SAMPLE_NO") { continue; } result += dc.Caption + ":" + dr[dc.ColumnName].ToString() + ";"; } result = result.Remove(result.Length - 1) + ");"; matJudgeResultCJ2.StrRemark = result; } } 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); } //查询检验委托基本信息 private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag, string strJudge) { try { //查询出检验的委托已经审核的信息 ArrayList al = matQueryBase1.GetQueryInfo(strJudge); al.Insert(0, strFlag); publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("mat.FrmMatJudgeResultCJ", al, this.ob, null); if (publicUltraGridBase.Ug.Rows.Count == 0) { if (publicUltraGridBase == publicUltraGridBase1) { matShowBase1.ClearCheckConsign(); matJudgeResultCJ1.ClearAll(); publicUltraGridDetail1.DataTable.Rows.Clear(); } else { matShowBase2.ClearCheckConsign(); matJudgeResultCJ2.ClearAll(); publicUltraGridDetail2.DataTable.Rows.Clear(); } //ClearCheckConsign(); } else if (publicUltraGridBase == publicUltraGridBase2) { GridHelper.RefreshAndAutoSize(publicUltraGridBase.Ug); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } //查询检验委托明细信息 private void QueryCheckConsignDetail_Dept(PublicUltraGridBase publicUltraGridBase, PublicUltraGridDetail publicUltraGridDetail) { try { ArrayList arrayList = new ArrayList(); arrayList.Add("2345"); arrayList.Add(""); arrayList.Add(""); arrayList.Add(""); arrayList.Add(publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim()); publicUltraGridDetail.QueryCheckConsignDetail_Dept("mat.FrmMatJudgeResultCJ", arrayList, this.ob, 1, null); publicUltraGridDetail.setOtherColumnReadOnly(null);//可编辑列 } catch (Exception ex) { MessageUtil.ShowWarning(ex.Message); return; } } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { //新增、修改修约值、审核、删除、退出 switch (ToolbarKey) { case "Query": if (ultraTabControl1.SelectedTab.Index == 0) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "3", "0");//已经审核才能判定 } else if (ultraTabControl1.SelectedTab.Index == 1) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "45", "1"); } break; case "Judge": AddCheckConsignDetail(); break; case "Update": UpdateCheckConsignDetail(); break; case "Delete": DeleteCheckConsignDetail(); break; case "Print": //RepLimsMatCheckResultJudgeBook(); break; case "Close": if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes) { this.Close(); } break; } } //取消判定 private void AddCheckConsignDetail() { try { if (ultraTabControl1.SelectedTab.Index != 0) { MessageUtil.ShowTips("只有选择了未判定数据页才能进行判定操作!"); return; } if (publicUltraGridDetail1.DataTable == null || publicUltraGridDetail1.DataTable.Columns.Count < 2 || publicUltraGridDetail1.DataTable.Rows.Count < 2) { MessageUtil.ShowWarning("查不到检验明细数据请刷新重试!"); return; } if (publicUltraGridBase1.Ur == null) { MessageUtil.ShowWarning("请选择需要判定的数据!"); return; } if (matJudgeResultCJ1.StrResult == "") { MessageUtil.ShowWarning("判定结果不能为空!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认判定?") == DialogResult.Yes) { string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text;//检验委托编号 ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List ArrayList alBase = new ArrayList(); ArrayList alBaseDetail = new ArrayList();//改变主表IS_JUDGE标志位 alBaseDetail.Add(matJudgeResultCJ1.StrName == "" ? UserInfo.GetUserName() : matJudgeResultCJ1.StrName); alBaseDetail.Add(DateTime.Now.ToString()); alBaseDetail.Add(matJudgeResultCJ1.StrShift == "" ? UserInfo.GetUserOrderText() : matJudgeResultCJ1.StrShift); alBaseDetail.Add(matJudgeResultCJ1.StrClass == "" ? UserInfo.GetUserGroupText() : matJudgeResultCJ1.StrClass); alBaseDetail.Add("");//总结果 alBaseDetail.Add(matJudgeResultCJ1.StrResult_Code); alBaseDetail.Add(matJudgeResultCJ1.StrResult);//判定等级 alBaseDetail.Add(matJudgeResultCJ1.StrJudgeResult);//一判结果 alBaseDetail.Add(matJudgeResultCJ1.StrJudgeResult);//二判结果 StrJudgeResultTwo alBaseDetail.Add(matJudgeResultCJ1.StrRemark); alBaseDetail.Add("1"); alBaseDetail.Add("0"); alBaseDetail.Add(strCHECK_NO); alBase.Add(alBaseDetail); ArrayList alDetail = new ArrayList();//改变从表FLAG标志位 为4已判定 ArrayList alDetailPara = new ArrayList(); alDetailPara.Add("4"); alDetailPara.Add("3"); alDetailPara.Add(strCHECK_NO); alDetail.Add(alDetailPara); ArrayList alDetailResult = new ArrayList();//存放判定结果 ArrayList alDetailResultPara = new ArrayList(); foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns) { if (dc.ColumnName.IndexOf("M") == 0) { alDetailResultPara = new ArrayList(); alDetailResultPara.Add(publicUltraGridDetail1.DataTable.Rows[1][dc.ColumnName].ToString()); alDetailResultPara.Add(dc.ColumnName); alDetailResultPara.Add(strCHECK_NO); alDetailResult.Add(alDetailResultPara); } } alAll.Add(alBase); alAll.Add(alDetail); alAll.Add(alDetailResult); PublicServer.SetData("com.steering.lims.data.mat.FrmMatJudgeResultCJ.AddCheckConsignDetail", new Object[] { strCHECK_NO, alAll }, this.ob); QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "3", "0"); MessageUtil.ShowTips("判定成功!"); } } catch (Exception e) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "3", "0"); MessageUtil.ShowWarning(e.Message); return; } } //取消判定 private void UpdateCheckConsignDetail() { try { if (ultraTabControl1.SelectedTab.Index != 1) { MessageUtil.ShowTips("只有选择了已判定数据页才能进行修改操作!"); return; } if (publicUltraGridDetail2.DataTable == null || publicUltraGridDetail2.DataTable.Columns.Count < 2 || publicUltraGridDetail2.DataTable.Rows.Count < 2) { MessageUtil.ShowWarning("查不到检验明细数据请刷新重试!"); return; } if (publicUltraGridBase2.Ur == null) { MessageUtil.ShowWarning("请选择需要修改的数据!"); return; } if (matJudgeResultCJ2.StrResult == "") { MessageUtil.ShowWarning("判定结果不能为空!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.Yes) { string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text;//检验委托编号 //ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List ArrayList alBaseDetail = new ArrayList();//改变主表IS_JUDGE标志位 alBaseDetail.Add(matJudgeResultCJ2.StrName == "" ? UserInfo.GetUserName() : matJudgeResultCJ2.StrName); alBaseDetail.Add(DateTime.Now.ToString()); alBaseDetail.Add(matJudgeResultCJ2.StrShift == "" ? UserInfo.GetUserOrderText() : matJudgeResultCJ2.StrShift); alBaseDetail.Add(matJudgeResultCJ2.StrClass == "" ? UserInfo.GetUserGroupText() : matJudgeResultCJ2.StrClass); alBaseDetail.Add("");//总结果 alBaseDetail.Add(matJudgeResultCJ1.StrResult_Code); alBaseDetail.Add(matJudgeResultCJ2.StrResult);//判定结论 alBaseDetail.Add(matJudgeResultCJ1.StrJudgeResult);//一判结果 alBaseDetail.Add(matJudgeResultCJ1.StrJudgeResult);//二判结果 StrJudgeResultTwo 默认等于一判结果 alBaseDetail.Add(matJudgeResultCJ2.StrRemark); alBaseDetail.Add("1"); alBaseDetail.Add("1"); alBaseDetail.Add(strCHECK_NO); PublicServer.SetData("com.steering.lims.data.mat.FrmMatJudgeResultCJ.UpdateCheckConsignDetail", new Object[] { strCHECK_NO, alBaseDetail }, this.ob); QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "456", "1"); PublicMat.ActiveOperateRow(publicUltraGridBase2.Ug, "CHECK_NO", strCHECK_NO); MessageUtil.ShowTips("修改成功!"); } } catch (Exception e) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "456", "1"); MessageUtil.ShowWarning(e.Message); return; } } //取消判定 private void DeleteCheckConsignDetail() { try { if (ultraTabControl1.SelectedTab.Index != 1) { MessageUtil.ShowTips("只有选择了已判定数据页才能进行取消判定操作!"); return; } if (publicUltraGridDetail2.DataTable == null || publicUltraGridDetail2.DataTable.Columns.Count < 2 || publicUltraGridDetail2.DataTable.Rows.Count < 2) { MessageUtil.ShowWarning("查不到检验明细数据请刷新重试!"); return; } if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false) { MessageUtil.ShowWarning("请选择需要取消判定的数据!"); return; } //if (matJudgeResultCJ2.StrResult == "") //{ // MessageUtil.ShowWarning("判定结果不能为空!"); // return; //} if (MessageUtil.ShowYesNoAndQuestion("是否确认取消判定?") == DialogResult.Yes) { string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text;//检验委托编号 ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List ArrayList alBaseDetail = new ArrayList();//改变主表IS_JUDGE标志位 alBaseDetail.Add(""); alBaseDetail.Add(""); alBaseDetail.Add(""); alBaseDetail.Add(""); alBaseDetail.Add("");//总结果 alBaseDetail.Add(""); alBaseDetail.Add("");//判定结论 alBaseDetail.Add(""); alBaseDetail.Add(""); alBaseDetail.Add(""); alBaseDetail.Add("0"); alBaseDetail.Add("1"); alBaseDetail.Add(strCHECK_NO); ArrayList alDetail = new ArrayList();//改变从表FLAG标志位 为4已判定 alDetail.Add("3"); alDetail.Add("4"); alDetail.Add(strCHECK_NO); alAll.Add(alBaseDetail); alAll.Add(alDetail); PublicServer.SetData("com.steering.lims.data.mat.FrmMatJudgeResultCJ.DeleteCheckConsignDetail", new Object[] { strCHECK_NO, alAll }, this.ob); QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "456", "1"); MessageUtil.ShowTips("取消判定成功!"); } } catch (Exception e) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "456", "1"); MessageUtil.ShowWarning(e.Message); return; } } private void RepLimsMatCheckResultJudgeBook() { } private void FrmMatJudgeResultCJ_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (ultraTabControl1.SelectedTab.Index == 0) { if (toolMenu.Toolbars[0].Tools.Exists("Judge")) { toolMenu.Toolbars[0].Tools["Judge"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { this.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("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; } } else if (ultraTabControl1.SelectedTab.Index == 1) { if (toolMenu.Toolbars[0].Tools.Exists("Judge")) { toolMenu.Toolbars[0].Tools["Judge"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { this.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("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; } } } 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("Judge")) { toolMenu.Toolbars[0].Tools["Judge"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { this.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("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; } } else if (ultraTabControl1.SelectedTab.Index == 1) { if (toolMenu.Toolbars[0].Tools.Exists("Judge")) { toolMenu.Toolbars[0].Tools["Judge"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { this.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("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; } } } } }