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 FrmMatFGJudgeResultCJ : FrmBase { public FrmMatFGJudgeResultCJ() { 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 FrmMatFGJudgeResultCJ_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[] { "MAT_CODE", "MAT_NAME", "JUDGE_LEVEL_CODE", "JUDGE_LEVEL", "DEDUCT_WEIGHT", "REMARK" };//"FLAG","CHK", string[] arrCaption = new string[] { "送货单行号", "车号", "判定等级", "判定等级", "扣杂量", "备注" };//"试样状态","选择", publicUltraGridDetail1.InitColumns(arrColumns, arrCaption); publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "JUDGE_LEVEL" }, false); publicUltraGridDetail1.setOtherColumnReadOnly(new string[] { "JUDGE_LEVEL_CODE", "DEDUCT_WEIGHT", "REMARK" });//可编辑列 publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件 publicUltraGridBase2.InitColumnsBase(new string[] { "CHECK_NO", "FLAG_DESC" }, true, null); publicUltraGridDetail2.InitColumns(arrColumns, arrCaption); publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "JUDGE_LEVEL" }, false); publicUltraGridDetail2.setOtherColumnReadOnly(new string[] { "JUDGE_LEVEL_CODE", "DEDUCT_WEIGHT", "REMARK" });//可编辑列 matJudgeResultCJ1.QueryMatJudgeGrade_Fg(ob); matJudgeResultCJ2.QueryMatJudgeGrade_Fg(ob); publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns["JUDGE_LEVEL_CODE"].EditorComponent = matJudgeResultCJ1.Ult;//级别 publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns["JUDGE_LEVEL_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Columns["JUDGE_LEVEL_CODE"].EditorComponent = matJudgeResultCJ1.Ult;//级别 publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Columns["JUDGE_LEVEL_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; matJudgeResultCJ1.HideControl(); matJudgeResultCJ2.HideControl(); //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["MAT_NAME"].ToString() == "") { continue; } result += dr["MAT_NAME"].ToString() + "("; foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns) { if (dc.ColumnName == "MAT_NAME") { 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["MAT_NAME"].ToString() == "") { continue; } result += dr["MAT_NAME"].ToString() + "("; foreach (DataColumn dc in publicUltraGridDetail2.DataTable.Columns) { if (dc.ColumnName == "MAT_NAME") { 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.FrmMatFGJudgeResultCJ", 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(); } } 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.FrmMatFGJudgeResultCJ", 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, "1", "0"); } else if (ultraTabControl1.SelectedTab.Index == 1) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "1", "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 < 1 || publicUltraGridDetail1.DataTable.Rows.Count < 1) { MessageUtil.ShowWarning("查不到检验明细数据请刷新重试!"); return; } if (publicUltraGridBase1.Ur == null) { MessageUtil.ShowWarning("请选择需要判定的数据!"); return; } //if (matJudgeResultCJ1.StrResult == "") //{ // MessageUtil.ShowWarning("判定结果不能为空!"); // return; //} if (MessageUtil.ShowYesNoAndQuestion("是否确认判定?") == DialogResult.Yes) { publicUltraGridDetail1.Ug.UpdateData(); 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("");//判定结论编码 alBaseDetail.Add("");//判定结论 alBaseDetail.Add(matJudgeResultCJ1.StrRemark); alBaseDetail.Add("1"); alBaseDetail.Add("0"); alBaseDetail.Add(strCHECK_NO); alBase.Add(alBaseDetail); ArrayList alResult = new ArrayList(); ArrayList alResultDetail = new ArrayList();//改变Result表结果 foreach (UltraGridRow ur in publicUltraGridDetail1.Ug.Rows) { alResultDetail = new ArrayList(); alResultDetail.Add(ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim()); alResultDetail.Add(ur.Cells["JUDGE_LEVEL_CODE"].Value.ToString()); alResultDetail.Add(ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim()); alResultDetail.Add(ur.Cells["DEDUCT_WEIGHT"].Text.Trim()); alResultDetail.Add(ur.Cells["REMARK"].Text.Trim()); alResultDetail.Add(ur.Cells["MAT_NAME"].Text.Trim()); alResultDetail.Add(ur.Cells["MAT_CODE"].Text.Trim()); alResultDetail.Add(strCHECK_NO); alResult.Add(alResultDetail); } //foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows) //{ // alResultDetail = new ArrayList(); // alResultDetail.Add(dr["JUDGE_LEVEL"].ToString()); // alResultDetail.Add(dr["JUDGE_LEVEL_CODE"].ToString()); // alResultDetail.Add(dr["JUDGE_LEVEL"].ToString()); // alResultDetail.Add(dr["DEDUCT_WEIGHT"].ToString()); // alResultDetail.Add(dr["REMARK"].ToString()); // alResultDetail.Add(dr["MAT_NAME"].ToString()); // alResultDetail.Add(dr["MAT_CODE"].ToString()); // alResultDetail.Add(strCHECK_NO); // alResult.Add(alResultDetail); //} alAll.Add(alBase); alAll.Add(alResult); PublicServer.SetData("com.steering.lims.data.mat.FrmMatFGJudgeResultCJ.AddCheckConsignDetail", new Object[] { strCHECK_NO, alAll }, this.ob); QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "1", "0"); MessageUtil.ShowTips("判定成功!"); } } catch (Exception e) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "1", "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 < 1 || publicUltraGridDetail2.DataTable.Rows.Count < 1) { 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 alBase = new ArrayList(); 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(""); alBaseDetail.Add("");//判定结论 alBaseDetail.Add(matJudgeResultCJ2.StrRemark); alBaseDetail.Add("1"); alBaseDetail.Add("1"); alBaseDetail.Add(strCHECK_NO); alBase.Add(alBaseDetail); ArrayList alResult = new ArrayList(); ArrayList alResultDetail = new ArrayList();//改变Result表结果 foreach (DataRow dr in publicUltraGridDetail2.DataTable.Rows) { alResultDetail = new ArrayList(); alResultDetail.Add(dr["JUDGE_LEVEL"].ToString()); alResultDetail.Add(dr["JUDGE_LEVEL_CODE"].ToString()); alResultDetail.Add(dr["JUDGE_LEVEL"].ToString()); alResultDetail.Add(dr["DEDUCT_WEIGHT"].ToString()); alResultDetail.Add(dr["REMARK"].ToString()); alResultDetail.Add(dr["MAT_NAME"].ToString()); alResultDetail.Add(dr["MAT_CODE"].ToString()); alResultDetail.Add(strCHECK_NO); alResult.Add(alResultDetail); } alAll.Add(alBase); alAll.Add(alResult); PublicServer.SetData("com.steering.lims.data.mat.FrmMatFGJudgeResultCJ.UpdateCheckConsignDetail", new Object[] { strCHECK_NO, alAll }, this.ob); QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "1", "1"); PublicMat.ActiveOperateRow(publicUltraGridBase2.Ug, "CHECK_NO", strCHECK_NO); MessageUtil.ShowTips("修改成功!"); } } catch (Exception e) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "1", "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 < 1 || publicUltraGridDetail2.DataTable.Rows.Count < 1) { 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) { publicUltraGridDetail2.Ug.UpdateData(); string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text;//检验委托编号 ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List ArrayList alBase = new ArrayList(); ArrayList alBaseDetail = new ArrayList();//改变主表IS_JUDGE标志位 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); alBase.Add(alBaseDetail); ArrayList alResult = new ArrayList(); ArrayList alResultDetail = new ArrayList();//改变Result表结果 foreach (DataRow dr in publicUltraGridDetail2.DataTable.Rows) { alResultDetail = new ArrayList(); alResultDetail.Add(""); alResultDetail.Add(""); alResultDetail.Add(""); alResultDetail.Add(""); alResultDetail.Add(""); alResultDetail.Add(dr["MAT_NAME"].ToString()); alResultDetail.Add(dr["MAT_CODE"].ToString()); alResultDetail.Add(strCHECK_NO); alResult.Add(alResultDetail); } alAll.Add(alBase); alAll.Add(alResult); PublicServer.SetData("com.steering.lims.data.mat.FrmMatFGJudgeResultCJ.DeleteCheckConsignDetail", new Object[] { strCHECK_NO, alAll }, this.ob); QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "1", "1"); MessageUtil.ShowTips("取消判定成功!"); } } catch (Exception e) { QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "1", "1"); MessageUtil.ShowWarning(e.Message); return; } } private void RepLimsMatCheckResultJudgeBook() { } private void FrmMatFGJudgeResultCJ_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; } } } } }