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;
}
}
}
}