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 System.Collections;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win;
using System.Net;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.Lims.Data.PipeAndOutdec.数据管理.外委实验管理;
namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
//工程力学录入界面 各检验大项分Tab页展示
public partial class FrmLabEngDataCJAudit : FrmBase
{
private string[] arrId;//数据权限
private string[] plineCodes = { };
private DataTable m_dtPhyMax;//存放所有要检验的项目
private DataTable m_dtPhyItems;//存放所有要检验的项目试验方法
private DataTable m_dtPhyMaxAdd;//存放所有已检验的项目
private DataTable m_dtPhyItemsAdd;//存放所有已检验的项目试验方法
private DataTable m_dtPhyMaxAudit;
private DataTable m_dtPhyItemsAudit;
private DataTable m_dtPhyMaxAuditAdd;
private DataTable m_dtPhyItemsAuditAdd;
private string CHECK_NO = "";
private string SAMPLE_NO = "";
private string PHY_CODE_MAX = "";
private string arrIdStr = "002001007014,002023003004";
private int tabIndex = 0;//保存当前的tab页
public FrmLabEngDataCJAudit()
{
InitializeComponent();
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
//publicUltraGridBase1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
//publicUltraGridBase2.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase1_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase2_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase3_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase4_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase5_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase6_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase7_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase8_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase9_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase10_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase11_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase12_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase13_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase13_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase13_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase14_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
publicUltraGridDataCJBase14_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase14_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase15_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase15_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase15_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase16_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase16_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase16_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase17_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase17_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase17_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase18_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase18_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase18_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase19_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase19_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase19_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase20_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
publicUltraGridDataCJBase20_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase20_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase21_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase21_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
publicUltraGridDataCJBase21_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase22_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase22_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase22_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase23_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase23_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase23_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase24_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase24_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//publicUltraGridDataCJBase24_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//pipeQueryBase1.ShowPrintControl();
}
private void FrmDataCJBase_Load(object sender, EventArgs e)
{
//arrId = this.ValidDataPurviewIds;//获取数据权限
arrId = new string[] { "002001007014", "002023003004" };//工程力学项目
plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
InitColumns();
publicDataCJBase1.checkNameEnable();
publicDataCJBase2.checkNameEnable();
publicDataCJBase3.checkNameEnable();
publicDataCJBase4.checkNameEnable();
}
private void InitColumns()
{
pipeShowBase1.ChangeLabel();
pipeShowBase2.ChangeLabel();
//未录入
publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
publicUltraGridBase1.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
//string[] arrColumnsBase = new string[] { "CHECK_NO", "SAMPLE_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" };
//string[] arrCaptionBase = new string[] { "检验编号", "样管号", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "特殊要求", "标志位", "标志位", "备注" };
//publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase);
//publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
//publicUltraGridBase1.setOtherColumnReadOnly(null);//可编辑列
publicUltraGridDataCJBase1_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase1_2.InitColumnsPhyDetail();
publicUltraGridDataCJBase2_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase2_2.InitColumnsPhyDetail();
publicUltraGridDataCJBase3_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase3_2.InitColumnsPhyDetail();
publicUltraGridDataCJBase4_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase4_2.InitColumnsPhyDetail();
//publicUltraGridDataCJBase5_1.InitColumnsPhyConfigItems();
//publicUltraGridDataCJBase5_2.InitColumnsPhyDetail();
//publicUltraGridDataCJBase6_1.InitColumnsPhyConfigItems();
//publicUltraGridDataCJBase6_2.InitColumnsPhyDetail();
//已录入
publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件
publicUltraGridBase2.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
//publicUltraGridBase2.InitColumns(arrColumnsBase, arrCaptionBase);
//publicUltraGridBase2.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
//publicUltraGridBase2.setOtherColumnReadOnly(new string[] { null });//可编辑列
publicUltraGridDataCJBase7_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase7_2.InitColumnsPhyDetail();
publicUltraGridDataCJBase8_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase8_2.InitColumnsPhyDetail();
publicUltraGridDataCJBase9_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase9_2.InitColumnsPhyDetail();
publicUltraGridDataCJBase10_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase10_2.InitColumnsPhyDetail();
//publicUltraGridDataCJBase11_1.InitColumnsPhyConfigItems();
//publicUltraGridDataCJBase11_2.InitColumnsPhyDetail();
//publicUltraGridDataCJBase12_1.InitColumnsPhyConfigItems();
//publicUltraGridDataCJBase12_2.InitColumnsPhyDetail();
PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK", "CHECK_NO" }, true);
PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK", "SAMPLE_NO" }, true, 1);//显示列
PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" });//可编辑列
PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" }, 1);
publicUltraGridDataCJBase13_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase13_1.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase13_2.InitColumnsPhyDetail(null);
publicUltraGridDataCJBase13_2.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase14_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase14_1.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase14_2.InitColumnsPhyDetail(null);
publicUltraGridDataCJBase14_2.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase15_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase15_1.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase15_2.InitColumnsPhyDetail(null);
publicUltraGridDataCJBase15_2.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase16_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase16_2.InitColumnsPhyDetail(null);
//publicUltraGridDataCJBase17_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase17_2.InitColumnsPhyDetail(null);
//publicUltraGridDataCJBase18_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase18_2.InitColumnsPhyDetail(null);
PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "CHECK_NO" }, true);
PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "SAMPLE_NO" }, true, 1);//显示列
PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" });//可编辑列
PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" }, 1);
publicUltraGridDataCJBase19_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase19_2.InitColumnsPhyDetail(null);
publicUltraGridDataCJBase20_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase20_2.InitColumnsPhyDetail(null);
publicUltraGridDataCJBase21_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase21_2.InitColumnsPhyDetail(null);
publicUltraGridDataCJBase22_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase22_2.InitColumnsPhyDetail(null);
//publicUltraGridDataCJBase23_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase23_2.InitColumnsPhyDetail(null);
//publicUltraGridDataCJBase24_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase24_2.InitColumnsPhyDetail(null);
}
///
/// 重写基类方法
///
///
///
public override void ToolBar_Click(object sender, string ToolbarKey)
{
//查询、确认、退出
switch (ToolbarKey)
{
case "Query":
if (ultraTabControl1.SelectedTab.Index == 0)
{
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
}
else if (ultraTabControl1.SelectedTab.Index == 1)
{
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
}
else if (ultraTabControl1.SelectedTab.Index == 2)
{
QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
}
else if (ultraTabControl1.SelectedTab.Index == 3)
{
QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
}
break;
case "Add":
if (ultraTabControl2.SelectedTab.Index == 0)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase1_2, publicUltraGridDataCJBase1_1);
}
else if (ultraTabControl2.SelectedTab.Index == 1)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase2_2, publicUltraGridDataCJBase2_1);
}
else if (ultraTabControl2.SelectedTab.Index == 2)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase3_2, publicUltraGridDataCJBase3_1);
}
else if (ultraTabControl2.SelectedTab.Index == 3)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase4_2, publicUltraGridDataCJBase4_1);
}
//else if (ultraTabControl2.SelectedTab.Index == 4)
//{
// AddCheckConsignProcessResult(publicUltraGridDataCJBase5_2, publicUltraGridDataCJBase5_1);
//}
//else if (ultraTabControl2.SelectedTab.Index == 5)
//{
// AddCheckConsignProcessResult(publicUltraGridDataCJBase6_2, publicUltraGridDataCJBase6_1);
//}
break;
case "Update":
if (ultraTabControl3.SelectedTab.Index == 0)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
}
else if (ultraTabControl3.SelectedTab.Index == 1)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
}
else if (ultraTabControl3.SelectedTab.Index == 2)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
}
else if (ultraTabControl3.SelectedTab.Index == 3)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
}
//else if (ultraTabControl3.SelectedTab.Index == 4)
//{
// UpdateCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
//}
//else if (ultraTabControl3.SelectedTab.Index == 5)
//{
// UpdateCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
//}
//UpdateCheckConsignProcessResult();
break;
case "Delete":
if (ultraTabControl3.SelectedTab.Index == 0)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
}
else if (ultraTabControl3.SelectedTab.Index == 1)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
}
else if (ultraTabControl3.SelectedTab.Index == 2)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
}
else if (ultraTabControl3.SelectedTab.Index == 3)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
}
//else if (ultraTabControl3.SelectedTab.Index == 4)
//{
// DeleteCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
//}
//else if (ultraTabControl3.SelectedTab.Index == 5)
//{
// DeleteCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
//}
//DeleteCheckConsignProcessResult();
break;
case "Audit":
AuditCheckConsignDetail();//SingleAuditCheckConsignDetail()
break;
case "CancelAudit":
CancelAuditCheckConsignDetail();//SingleAuditCheckConsignDetail()
break;
case "SingleAudit":
if (ultraTabControl4.SelectedTab.Index == 0)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase13_2);
}
else if (ultraTabControl4.SelectedTab.Index == 1)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase14_2);
}
else if (ultraTabControl4.SelectedTab.Index == 2)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase15_2);
}
else if (ultraTabControl4.SelectedTab.Index == 3)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase16_2);
}
//else if (ultraTabControl4.SelectedTab.Index == 4)
//{
// SingleAuditCheckConsignDetail(publicUltraGridDataCJBase17_2);
//}
//else if (ultraTabControl4.SelectedTab.Index == 5)
//{
// SingleAuditCheckConsignDetail(publicUltraGridDataCJBase18_2);
//}
break;
case "CancelSingleAudit":
if (ultraTabControl5.SelectedTab.Index == 0)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase19_2);
}
else if (ultraTabControl5.SelectedTab.Index == 1)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase20_2);
}
else if (ultraTabControl5.SelectedTab.Index == 2)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase21_2);
}
else if (ultraTabControl5.SelectedTab.Index == 3)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase22_2);
}
//else if (ultraTabControl5.SelectedTab.Index == 4)
//{
// CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase23_2);
//}
//else if (ultraTabControl5.SelectedTab.Index == 5)
//{
// CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase24_2);
//}
break;
case "SaveParm":
SaveParm();
break;
case "DoPrint":
doPrint();
break;
case "UpFile":
UpFile();
break;
case "Close":
if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
{
this.Close();
}
break;
}
}
#region 公共方法
///
///
///
///
private UltraGridRow getugr()
{
UltraGridRow ugr = null;
if (ultraTabControl1.SelectedTab.Index == 0)
{
if (ultraTabControl2.SelectedTab.Index == 0)
{
ugr = publicUltraGridDataCJBase1_2.Ug.ActiveRow;
}
else if (ultraTabControl2.SelectedTab.Index == 1)
{
ugr = publicUltraGridDataCJBase2_2.Ug.ActiveRow;
}
else if (ultraTabControl2.SelectedTab.Index == 2)
{
ugr = publicUltraGridDataCJBase3_2.Ug.ActiveRow;
}
else if (ultraTabControl2.SelectedTab.Index == 3)
{
ugr = publicUltraGridDataCJBase4_2.Ug.ActiveRow;
}
//else if (ultraTabControl2.SelectedTab.Index == 4)
//{
// ugr = publicUltraGridDataCJBase5_2.Ug.ActiveRow;
//}
//ugr = publicUltraGridDetail1.Ug.ActiveRow;
}
else if (ultraTabControl1.SelectedTab.Index == 1)
{
//ugr = publicUltraGridDetail2.Ug.ActiveRow;
if (ultraTabControl3.SelectedTab.Index == 0)
{
ugr = publicUltraGridDataCJBase7_2.Ug.ActiveRow;
}
else if (ultraTabControl3.SelectedTab.Index == 1)
{
ugr = publicUltraGridDataCJBase8_2.Ug.ActiveRow;
}
else if (ultraTabControl3.SelectedTab.Index == 2)
{
ugr = publicUltraGridDataCJBase9_2.Ug.ActiveRow;
}
else if (ultraTabControl3.SelectedTab.Index == 3)
{
ugr = publicUltraGridDataCJBase10_2.Ug.ActiveRow;
}
//else if (ultraTabControl2.SelectedTab.Index == 4)
//{
// ugr = publicUltraGridDataCJBase11_2.Ug.ActiveRow;
//}
}
else if (ultraTabControl1.SelectedTab.Index == 2)
{
//ugr = publicUltraGridDetail3.Ug.ActiveRow;
if (ultraTabControl4.SelectedTab.Index == 0)
{
ugr = publicUltraGridDataCJBase13_2.Ug.ActiveRow;
}
else if (ultraTabControl4.SelectedTab.Index == 1)
{
ugr = publicUltraGridDataCJBase14_2.Ug.ActiveRow;
}
else if (ultraTabControl4.SelectedTab.Index == 2)
{
ugr = publicUltraGridDataCJBase15_2.Ug.ActiveRow;
}
else if (ultraTabControl4.SelectedTab.Index == 3)
{
ugr = publicUltraGridDataCJBase16_2.Ug.ActiveRow;
}
//else if (ultraTabControl2.SelectedTab.Index == 4)
//{
// ugr = publicUltraGridDataCJBase17_2.Ug.ActiveRow;
//}
}
else if (ultraTabControl1.SelectedTab.Index == 3)
{
//ugr = publicUltraGridDetail4.Ug.ActiveRow;
if (ultraTabControl5.SelectedTab.Index == 0)
{
ugr = publicUltraGridDataCJBase19_2.Ug.ActiveRow;
}
else if (ultraTabControl5.SelectedTab.Index == 1)
{
ugr = publicUltraGridDataCJBase20_2.Ug.ActiveRow;
}
else if (ultraTabControl5.SelectedTab.Index == 2)
{
ugr = publicUltraGridDataCJBase21_2.Ug.ActiveRow;
}
else if (ultraTabControl5.SelectedTab.Index == 3)
{
ugr = publicUltraGridDataCJBase22_2.Ug.ActiveRow;
}
//else if (ultraTabControl2.SelectedTab.Index == 4)
//{
// ugr = publicUltraGridDataCJBase23_2.Ug.ActiveRow;
//}
}
if (ugr != null)
{
CHECK_NO = ugr.Cells["CHECK_NO"].Value.ToString();
SAMPLE_NO = ugr.Cells["SAMPLE_NO"].Value.ToString();
PHY_CODE_MAX = ugr.Cells["PHY_CODE_MAX"].Value.ToString();
}
else
{
CHECK_NO = "";
SAMPLE_NO = "";
PHY_CODE_MAX = "";
}
publicDataCJBase1.initCheckEqiupment(arrId, PHY_CODE_MAX, this.ob);
publicDataCJBase2.initCheckEqiupment(arrId, PHY_CODE_MAX, this.ob);
publicDataCJBase3.initCheckEqiupment(arrId, PHY_CODE_MAX, this.ob);
publicDataCJBase4.initCheckEqiupment(arrId, PHY_CODE_MAX, this.ob);
return ugr;
}
///
/// 试验条件
///
private void SaveParm()
{
getugr();
FrmLabEngDataParm labDateParm = new FrmLabEngDataParm(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, this.ob);
labDateParm.ShowDialog();
if (ultraTabControl1.SelectedTab.Index == 0)
{
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
}
else if (ultraTabControl1.SelectedTab.Index == 1)
{
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
}
else if (ultraTabControl1.SelectedTab.Index == 2)
{
QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
}
else if (ultraTabControl1.SelectedTab.Index == 3)
{
QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
}
}
//设备信息赋值给实体类
///
/// 设备信息赋值给实体类
///
///
///
///
///
private PipeCheckconsignDetailEntity getCheckDetal(string checkNo, string sampleNo, string phyCodeMax)
{
//设备信息
ArrayList listDetail = new ArrayList();
listDetail.Add(sampleNo);
listDetail.Add(checkNo);
listDetail.Add(phyCodeMax);
DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryChemCheckConsignDetail",
new Object[] { listDetail }, ob);
PipeCheckconsignDetailEntity checkDetal = new PipeCheckconsignDetailEntity();
if (dtDetail.Rows.Count > 0)
{
checkDetal.CheckName = dtDetail.Rows[0]["CHECK_NAME"].ToString();
checkDetal.CheckTime = dtDetail.Rows[0]["CHECK_TIME"].ToString();
checkDetal.CheckShift = dtDetail.Rows[0]["CHECK_SHIFT"].ToString();
checkDetal.CheckClass = dtDetail.Rows[0]["CHECK_CLASS"].ToString();
checkDetal.DeviceNo = dtDetail.Rows[0]["DEVICE_NO"].ToString();
checkDetal.DeviceName = dtDetail.Rows[0]["DEVICE_NAME"].ToString();
checkDetal.CheckTemp = dtDetail.Rows[0]["CHECK_TEMP"].ToString();
checkDetal.Remark = dtDetail.Rows[0]["REMARK"].ToString();
checkDetal.AuditName = dtDetail.Rows[0]["AUDIT_NAME"].ToString();
checkDetal.AuditTime = dtDetail.Rows[0]["AUDIT_TIME"].ToString();
checkDetal.FormualNo = dtDetail.Rows[0]["FORMUAL_NO"].ToString();
checkDetal.FormualName = dtDetail.Rows[0]["FORMUAL_NAME"].ToString();
}
return checkDetal;
}
//打印
///
/// 打印
///
private void doPrint()
{
getugr();
string strurl = "";
if (PHY_CODE_MAX.Equals("C0018") || PHY_CODE_MAX.Equals("C0035") || PHY_CODE_MAX.Equals("C0065")) //压溃试验、滑脱试验、爆破试验
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCBurst.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0064")) //上、卸扣试验
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCAntigalling.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0036") || PHY_CODE_MAX.Equals("C0037") || PHY_CODE_MAX.Equals("C0066")) //抗内压强度、复合力试验
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCCombinedStress.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
FrmExcel fre = new FrmExcel(this.ob, strurl);
fre.AutoSize = true;
fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
fre.WindowState = FormWindowState.Maximized;
fre.Show();
}
//查询上传的PDF文件
///
/// 查询上传的PDF文件
///
private void SelectFile(string filePathNew)
{
dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePathNew);
down.DeleteButton.Visible = false;
down.ShowDialog();
}
//上传
///
/// 上传
///
private void UpFile()
{
getugr();
WebClient webClient = new WebClient();
List listPdf = new List();
string date = DateTime.Now.ToString("yyyyMMdd");
DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { CHECK_NO, arrId }, ob);
if (int.Parse(ds.Rows[0][0].ToString()) > 0)
{
MessageUtil.ShowTips("还有未审核试样组,不允许上传报告!");
return;
}
string url = "";
string filePathNew = ""; //报告目录
string reportNo = ""; //报告编号
if (PHY_CODE_MAX.Equals("C0018") || PHY_CODE_MAX.Equals("C0035") || PHY_CODE_MAX.Equals("C0065")) //压溃试验、滑脱试验、爆破试验
{
url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCBurst.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
reportNo = CHECK_NO + SAMPLE_NO + "Burst";
}
else if (PHY_CODE_MAX.Equals("C0064")) //上、卸扣试验
{
url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCAntigalling.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
reportNo = CHECK_NO + SAMPLE_NO + "Antigalling";
}
else if (PHY_CODE_MAX.Equals("C0036") || PHY_CODE_MAX.Equals("C0037") || PHY_CODE_MAX.Equals("C0066")) //抗内压强度、复合力试验
{
url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCCombinedStress.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
reportNo = CHECK_NO + SAMPLE_NO + "CombinedStress";
}
filePathNew = "Lims/pipe/gongcheng/" + CHECK_NO + "/";
byte[] pdf = webClient.DownloadData(url);
FileBean fileBean = new FileBean();
fileBean.setFile(pdf);
fileBean.setFileName(reportNo + ".pdf");
fileBean.setPathName(filePathNew);
listPdf.Add(fileBean);
webClient.Dispose();
bool a = FileHelper.Upload(listPdf);
if (a)
{
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm";
ccp.MethodName = "updatePipeReport";
ccp.ServerParams = new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, "GONGCHENG_PATH", filePathNew };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (ccp.ReturnInfo.Equals("上传成功!"))
{
MessageUtil.ShowTips(ccp.ReturnInfo);
SelectFile(filePathNew);
}
else
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
else
{
MessageUtil.ShowError("系统生成PDF失败，请稍后再试！");
return;
}
}
///
/// 自动上传
///
private void UpFileAuto()
{
getugr();
WebClient webClient = new WebClient();
List listPdf = new List();
string date = DateTime.Now.ToString("yyyyMMdd");
string url = "";
string filePathNew = ""; //报告目录
string reportNo = ""; //报告编号
if (PHY_CODE_MAX.Equals("C0018") || PHY_CODE_MAX.Equals("C0035") || PHY_CODE_MAX.Equals("C0065")) //压溃试验、滑脱试验、爆破试验
{
url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCBurst.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
reportNo = CHECK_NO + SAMPLE_NO + "Burst";
}
else if (PHY_CODE_MAX.Equals("C0064")) //上、卸扣试验
{
url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCAntigalling.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
reportNo = CHECK_NO + SAMPLE_NO + "Antigalling";
}
else if (PHY_CODE_MAX.Equals("C0036") || PHY_CODE_MAX.Equals("C0037") || PHY_CODE_MAX.Equals("C0066")) //抗内压强度、复合力试验
{
url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCCombinedStress.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
reportNo = CHECK_NO + SAMPLE_NO + "CombinedStress";
}
filePathNew = "Lims/pipe/gongcheng/" + CHECK_NO + "/";
byte[] pdf = webClient.DownloadData(url);
FileBean fileBean = new FileBean();
fileBean.setFile(pdf);
fileBean.setFileName(reportNo + ".pdf");
fileBean.setPathName(filePathNew);
listPdf.Add(fileBean);
webClient.Dispose();
bool a = FileHelper.Upload(listPdf);
if (a)
{
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm";
ccp.MethodName = "updatePipeReport";
ccp.ServerParams = new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, "GONGCHENG_PATH", filePathNew };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (ccp.ReturnInfo.Equals("上传成功!"))
{
}
else
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
else
{
MessageUtil.ShowError("系统自动上传报告失败，请全部审核后手动上传报告！");
return;
}
}
//颜色改变
///
/// 颜色改变
///
///
///
private void ChangeColor(DataTable dtPhyMax, Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
{
if (dtPhyMax == null || dtPhyMax.Rows.Count == 0) return;
int i = -1;
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')").Rows.Count > 0)
{
i = i == -1 ? i = 0 : i;
ultraTabControl.Tabs[0].Appearance.BackColor = Color.GreenYellow;
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')").Rows.Count > 0)
{
i = i == -1 ? i = 1 : i;
ultraTabControl.Tabs[1].Appearance.BackColor = Color.GreenYellow;
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0046'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0046'").Rows.Count > 0)
{
i = i == -1 ? i = 2 : i;
ultraTabControl.Tabs[2].Appearance.BackColor = Color.GreenYellow;//
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')").Rows.Count > 0)
{
i = i == -1 ? i = 3 : i;
ultraTabControl.Tabs[3].Appearance.BackColor = Color.GreenYellow;//其他
}
//if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')").Rows.Count > 0)
//{
// i = i == -1 ? i = 4 : i;
// ultraTabControl.Tabs[4].Appearance.BackColor = Color.GreenYellow;//工艺
//}
//if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')").Rows.Count > 0)
//{
// i = i == -1 ? i = 5 : i;
// ultraTabControl.Tabs[5].Appearance.BackColor = Color.GreenYellow;//其他
//}
ultraTabControl.SelectedTab = i == -1 ? ultraTabControl.Tabs[0] : ultraTabControl.Tabs[i];
}
//赋值
///
/// 赋值
///
///
private void ClearPhyDetailItems(Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
{
//ultraTabControl.SelectedTab = ultraTabControl.Tabs[0];
ultraTabControl.Tabs[0].Appearance.BackColor = Control.DefaultBackColor;
ultraTabControl.Tabs[1].Appearance.BackColor = Control.DefaultBackColor;
ultraTabControl.Tabs[2].Appearance.BackColor = Control.DefaultBackColor;
ultraTabControl.Tabs[3].Appearance.BackColor = Control.DefaultBackColor;
//ultraTabControl.Tabs[4].Appearance.BackColor = Control.DefaultBackColor;
//ultraTabControl.Tabs[5].Appearance.BackColor = Control.DefaultBackColor;
if (ultraTabControl == ultraTabControl2)
{
publicUltraGridDataCJBase1_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase2_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase3_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase4_1.DataTable.Rows.Clear();
//publicUltraGridDataCJBase5_1.DataTable.Rows.Clear();
//publicUltraGridDataCJBase6_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase1_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase2_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase3_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase4_2.DataTable.Rows.Clear();
//publicUltraGridDataCJBase5_2.DataTable.Rows.Clear();
//publicUltraGridDataCJBase6_2.DataTable.Rows.Clear();
splitContainer1.Panel1Collapsed = true;
splitContainer2.Panel1Collapsed = true;
splitContainer3.Panel1Collapsed = true;
splitContainer4.Panel1Collapsed = true;
//splitContainer5.Panel1Collapsed = true;
//splitContainer6.Panel1Collapsed = true;
}
else if (ultraTabControl == ultraTabControl3)
{
publicUltraGridDataCJBase7_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase8_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase9_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase10_1.DataTable.Rows.Clear();
//publicUltraGridDataCJBase11_1.DataTable.Rows.Clear();
//publicUltraGridDataCJBase12_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase7_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase8_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase9_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase10_2.DataTable.Rows.Clear();
//publicUltraGridDataCJBase11_2.DataTable.Rows.Clear();
//publicUltraGridDataCJBase12_2.DataTable.Rows.Clear();
splitContainer7.Panel1Collapsed = true;
splitContainer8.Panel1Collapsed = true;
splitContainer9.Panel1Collapsed = true;
splitContainer10.Panel1Collapsed = true;
//splitContainer11.Panel1Collapsed = true;
//splitContainer12.Panel1Collapsed = true;
}
else if (ultraTabControl == ultraTabControl4)
{
publicUltraGridDataCJBase13_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase14_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase15_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase16_1.DataTable.Rows.Clear();
//publicUltraGridDataCJBase17_1.DataTable.Rows.Clear();
//publicUltraGridDataCJBase18_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase13_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase14_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase15_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase16_2.DataTable.Rows.Clear();
//publicUltraGridDataCJBase17_2.DataTable.Rows.Clear();
//publicUltraGridDataCJBase18_2.DataTable.Rows.Clear();
splitContainer13.Panel1Collapsed = true;
splitContainer14.Panel1Collapsed = true;
splitContainer15.Panel1Collapsed = true;
splitContainer16.Panel1Collapsed = true;
//splitContainer17.Panel1Collapsed = true;
//splitContainer18.Panel1Collapsed = true;
}
else if (ultraTabControl == ultraTabControl5)
{
publicUltraGridDataCJBase19_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase20_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase21_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase22_1.DataTable.Rows.Clear();
//publicUltraGridDataCJBase23_1.DataTable.Rows.Clear();
//publicUltraGridDataCJBase24_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase19_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase20_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase21_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase22_2.DataTable.Rows.Clear();
//publicUltraGridDataCJBase23_2.DataTable.Rows.Clear();
//publicUltraGridDataCJBase24_2.DataTable.Rows.Clear();
splitContainer19.Panel1Collapsed = true;
splitContainer20.Panel1Collapsed = true;
splitContainer21.Panel1Collapsed = true;
splitContainer22.Panel1Collapsed = true;
//splitContainer23.Panel1Collapsed = true;
//splitContainer24.Panel1Collapsed = true;
}
}
#endregion
#region 录入区域
//查询检验委托基本信息
///
/// 查询检验委托基本信息
///
///
///
private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
{
try
{
//各试验室各检验项目设置权限
publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("pipe.PublicPipeBase", pipeQueryBase1.GetQueryInfo(strFlag), this.ob, arrId, plineCodes);
if (publicUltraGridBase.Ug.Rows.Count == 0)
{
if (publicUltraGridBase == publicUltraGridBase1)
{
ClearPhyDetailItems(ultraTabControl2);
}
else if (publicUltraGridBase == publicUltraGridBase2)
{
ClearPhyDetailItems(ultraTabControl3);
}
}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
//查询试验方法项目信息
///
/// 查询试验方法项目信息
///
///
///
///
///
private void QueryCheckMethodPhyConfigItems(PublicUltraGridDataCJBase publicUltraGridDataCJBase, DataTable dtHide, SplitContainer splitContainer, DataTable dt)
{
try
{
PublicPipeAndOutdec.ChangeSplit(splitContainer, dt);
publicUltraGridDataCJBase.HideNullColumn(dtHide, publicUltraGridDataCJBase.Ug);
publicUltraGridDataCJBase.QueryCheckMethodPhyConfigItems(dt);
//PublicPipeAndOutdec.RefreshAndAutoSizeColumns(publicUltraGridDataCJBase.Ug, new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" }, false);//刷新Grid
}
catch (Exception e)
{
MessageUtil.ShowError(e.Message);
}
}
#endregion
#region 未录入
void pipeUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
{
try
{
pipeShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);
//赋值给全局变量
UltraGridRow ur = publicUltraGridBase1.Ur;
ArrayList arrayList = new ArrayList();
arrayList.Add("2");
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
if (arrId != null && arrId.Length > 0)
{
ClearPhyDetailItems(ultraTabControl2);
//查询检验项目明细
DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
if (dt == null || dt.Rows.Count == 0)
{
m_dtPhyMax = null;
m_dtPhyItems = null;
return;
}
m_dtPhyMax = dt.Copy();
DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
new Object[] { arrayList, arrId }, ob);
if (dtItems == null || dtItems.Rows.Count == 0)
{
m_dtPhyItems = null;
//return;
}
else
{
m_dtPhyItems = dtItems.Copy();
}
ChangeColor(m_dtPhyMax, ultraTabControl2);
AddPhyDetailItems();
//设备信息
getugr();
publicDataCJBase1.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase1.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
}
}
private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
{
//if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
if (toolMenu == null) return;
AddPhyDetailItems();
//设备信息
getugr();
publicDataCJBase1.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase1.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
//赋值
///
/// 赋值
///
private void AddPhyDetailItems()
{
if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
//R0019 抗挤毁强度,R0020 抗内压强度，R0021 连接强度,R0046 上卸扣试验,R0047 爆破，R0048 复合力试验,R0049 摩擦磨损试验
if (ultraTabControl2.SelectedTab.Index == 0)//压溃(抗挤毁强度),爆破,整管拉伸、滑脱（连接强度）
{
publicUltraGridDataCJBase1_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
publicUltraGridDataCJBase1_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase1_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
}
else if (ultraTabControl2.SelectedTab.Index == 1)//复合力，密封、静水压（抗内压强度）
{
publicUltraGridDataCJBase2_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
publicUltraGridDataCJBase2_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase2_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer2, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
}
else if (ultraTabControl2.SelectedTab.Index == 2)//上卸扣试验 R0046
{
publicUltraGridDataCJBase3_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0046'"));
publicUltraGridDataCJBase3_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase3_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0046'"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0046'"));
}
else if (ultraTabControl2.SelectedTab.Index == 3)//其他
{
publicUltraGridDataCJBase4_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
publicUltraGridDataCJBase4_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase4_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer4, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
}
//else if (ultraTabControl2.SelectedTab.Index == 4)//
//{
// publicUltraGridDataCJBase5_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"));//
// publicUltraGridDataCJBase5_2.DataTable.AcceptChanges();
// QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase5_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"), splitContainer5, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0010')"));
//}
//else if (ultraTabControl2.SelectedTab.Index == 5)//其他
//{
// publicUltraGridDataCJBase6_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
// publicUltraGridDataCJBase6_2.DataTable.AcceptChanges();
// QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase6_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer6, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
//}
tabIndex = ultraTabControl2.SelectedTab.Index;
}
//新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT，新增之前先删除表里数据
///
/// 新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT，新增之前先删除表里数据
///
///
///
private void AddCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
{
try
{
if (ultraTabControl1.SelectedTab.Index != 0)
{
MessageUtil.ShowWarning("只有在未录入数据页才能进行新增操作！");
return;
}
if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
{
MessageUtil.ShowWarning("请选择需要新增的试样信息！");
return;
}
if (publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
{
return;
}
//bool isNullValue = true;
publicUltraGridDataCJBase.Ug.UpdateData();
foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
{
if (dr["VALUE1"].ToString() == "" && dr["VALUE2"].ToString() == "" && dr["VALUE3"].ToString() == "" && dr["VALUE4"].ToString() == "" && dr["VALUE5"].ToString() == "" && dr["VALUE6"].ToString() == "" && dr["VALUE7"].ToString() == "" && dr["VALUE8"].ToString() == "" && dr["VALUE9"].ToString() == "")
{
MessageUtil.ShowWarning(dr["PHY_NAME"] + "没有录入任何数据不允许新增！");
return;
}
}
if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
{
string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
ArrayList alAll = new ArrayList();
ArrayList alPhyItems = new ArrayList();//删除信息详细表list
ArrayList alDetail = new ArrayList();//检验信息详细表list
ArrayList alProcessResult = new ArrayList();//化学信息list
ArrayList alPhyItemsParams = new ArrayList();
ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
ArrayList alProcessResultParams = new ArrayList();//化学信息参数list
string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//获取修改明细表参数JHYGG_CHECKCONSIGN_DETAIL
string row = "";
foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
{
if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
{
row += dr["PHY_CODE_MAX"].ToString() + " ";
alDetailParams = new ArrayList();
alDetailParams.Add(publicDataCJBase1.StrTemp);//温度
alDetailParams.Add(publicDataCJBase1.StrDevice_No);//设备编码
alDetailParams.Add(publicDataCJBase1.StrDevice_Name);//设备名称
alDetailParams.Add(publicDataCJBase1.StrRemark);//备注
alDetailParams.Add(publicDataCJBase1.StrFORMUAL_NO);//实验方法
alDetailParams.Add(publicDataCJBase1.StrFORMUAL_NAME);//方法名称
//alDetailParams.Add("");
//alDetailParams.Add("");
//alDetailParams.Add("");
//alDetailParams.Add("");
alDetailParams.Add(UserInfo.GetUserOrderText());//班次
alDetailParams.Add(UserInfo.GetUserGroupText());//班组
alDetailParams.Add(UserInfo.GetUserName());//录入人
alDetailParams.Add(strTime);//录入时间
alDetailParams.Add("3");//录入标志位
alDetailParams.Add("2");
alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
alDetailParams.Add(strSAMPLE_NO);
alDetailParams.Add(strCHECK_NO);
alDetail.Add(alDetailParams);
}
}
publicUltraGridDataCJBase.Ug.UpdateData();
foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
{
alProcessResultParams = new ArrayList();
alProcessResultParams.Add(dr["VALUE1"].ToString());
alProcessResultParams.Add(dr["VALUE2"].ToString());
alProcessResultParams.Add(dr["VALUE3"].ToString());
alProcessResultParams.Add(dr["VALUE4"].ToString());
alProcessResultParams.Add(dr["VALUE5"].ToString());
alProcessResultParams.Add(dr["VALUE6"].ToString());
alProcessResultParams.Add(dr["VALUE7"].ToString());
alProcessResultParams.Add(dr["VALUE8"].ToString());
alProcessResultParams.Add(dr["VALUE9"].ToString());
alProcessResultParams.Add(dr["VALUE10"].ToString());
alProcessResultParams.Add(dr["VALUE11"].ToString());
alProcessResultParams.Add(dr["VALUE12"].ToString());
alProcessResultParams.Add(dr["VALUE13"].ToString());
alProcessResultParams.Add(dr["VALUE14"].ToString());
alProcessResultParams.Add(dr["VALUE15"].ToString());
alProcessResultParams.Add(dr["REMARK"].ToString());
alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
alProcessResult.Add(alProcessResultParams);
//alDeleteParams = new ArrayList();
//alDeleteParams.Add(dr["PHYDETAIL_ID"].ToString());
//alDelete.Add(alDeleteParams);
}
if (publicUltraGridDataCJBaseItems.DataTable != null)
{
publicUltraGridDataCJBaseItems.Ug.UpdateData();
foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
{
alPhyItemsParams = new ArrayList();
alPhyItemsParams.Add(strCHECK_NO);
alPhyItemsParams.Add(strSAMPLE_NO);
alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());
alPhyItemsParams.Add(dr["VALUE1"].ToString());
alPhyItemsParams.Add(dr["VALUE2"].ToString());
alPhyItemsParams.Add(dr["VALUE3"].ToString());
alPhyItemsParams.Add(dr["VALUE4"].ToString());
alPhyItemsParams.Add(dr["VALUE5"].ToString());
alPhyItemsParams.Add(dr["VALUE6"].ToString());
alPhyItemsParams.Add(dr["VALUE7"].ToString());
alPhyItemsParams.Add(dr["VALUE8"].ToString());
alPhyItemsParams.Add(dr["VALUE9"].ToString());
alPhyItemsParams.Add(dr["VALUE10"].ToString());
alPhyItemsParams.Add(dr["VALUE11"].ToString());
alPhyItemsParams.Add(dr["VALUE12"].ToString());
alPhyItemsParams.Add(dr["VALUE13"].ToString());
alPhyItemsParams.Add(dr["VALUE14"].ToString());
alPhyItemsParams.Add(dr["VALUE15"].ToString());
alPhyItemsParams.Add("");
alPhyItems.Add(alPhyItemsParams);
}
}
alAll.Add(alDetail);
alAll.Add(alProcessResult);
if (alPhyItems.Count > 0)
{
alAll.Add(alPhyItems);
}
PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AddCheckConsignProcessResult",
new Object[] { alAll }, this.ob);
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
MessageUtil.ShowTips("新增成功！");
}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
private void ultraTabControl2_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
{
int cnt = 0;
if (tabIndex == 0)
{
publicUltraGridDataCJBase1_2.Ug.UpdateData();
cnt = publicUltraGridDataCJBase1_2.DataTable.Rows.Cast().Where(
a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
}
else if (tabIndex == 1)
{
publicUltraGridDataCJBase2_2.Ug.UpdateData();
cnt = publicUltraGridDataCJBase2_2.DataTable.Rows.Cast().Where(
a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
}
else if (tabIndex == 2)
{
publicUltraGridDataCJBase3_2.Ug.UpdateData();
cnt = publicUltraGridDataCJBase3_2.DataTable.Rows.Cast().Where(
a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
}
else if (tabIndex == 3)
{
publicUltraGridDataCJBase4_2.Ug.UpdateData();
cnt = publicUltraGridDataCJBase4_2.DataTable.Rows.Cast().Where(
a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
}
//else if (tabIndex == 4)
//{
// publicUltraGridDataCJBase5_2.Ug.UpdateData();
// cnt = publicUltraGridDataCJBase5_2.DataTable.Rows.Cast().Where(
// a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
//}
//else if (tabIndex == 5)
//{
// publicUltraGridDataCJBase6_2.Ug.UpdateData();
// cnt = publicUltraGridDataCJBase6_2.DataTable.Rows.Cast().Where(
// a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
//}
if (cnt > 0)
{
if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗？") == System.Windows.Forms.DialogResult.No)
{
e.Cancel = true;
}
}
}
#endregion
#region 已录入
private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
{
//if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
if (toolMenu == null) return;
AddPhyDetailItems_Log();
//设备信息
getugr();
publicDataCJBase2.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase2.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
void pipeUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
{
try
{
pipeShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);
//赋值给全局变量
UltraGridRow ur = publicUltraGridBase2.Ur;
ArrayList arrayList = new ArrayList();
arrayList.Add("345");
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
if (arrId != null && arrId.Length > 0)
{
ClearPhyDetailItems(ultraTabControl3);
//查询检验项目明细
DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
if (dt == null || dt.Rows.Count == 0)
{
m_dtPhyMaxAdd = null;
m_dtPhyItemsAdd = null;
return;
}
m_dtPhyMaxAdd = dt.Copy();
DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodResult",
new Object[] { arrayList, arrId }, ob);
if (dtItems == null || dtItems.Rows.Count == 0)
{
m_dtPhyItemsAdd = null;
//return;
}
else
{
m_dtPhyItemsAdd = dtItems.Copy();
}
ChangeColor(m_dtPhyMaxAdd, ultraTabControl3);
AddPhyDetailItems_Log();
//设备信息
getugr();
publicDataCJBase1.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase1.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
}
}
//赋值
///
/// 赋值
///
private void AddPhyDetailItems_Log()
{
if (m_dtPhyMaxAdd == null || m_dtPhyMaxAdd.Rows.Count == 0) return;
//R0019 抗挤毁强度，R0047 爆破，复合力R0048
if (ultraTabControl3.SelectedTab.Index == 0)
{
publicUltraGridDataCJBase7_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
publicUltraGridDataCJBase7_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase7_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer7, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
}
else if (ultraTabControl3.SelectedTab.Index == 1)
{
publicUltraGridDataCJBase8_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
publicUltraGridDataCJBase8_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase8_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer8, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
}
else if (ultraTabControl3.SelectedTab.Index == 2)
{
publicUltraGridDataCJBase9_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0046'"));//
publicUltraGridDataCJBase9_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase9_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0046'"), splitContainer9, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0046'"));
}
else if (ultraTabControl3.SelectedTab.Index == 3)//其他
{
publicUltraGridDataCJBase10_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
publicUltraGridDataCJBase10_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase10_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer10, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
}
//else if (ultraTabControl3.SelectedTab.Index == 4)//
//{
// publicUltraGridDataCJBase11_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
// publicUltraGridDataCJBase11_2.DataTable.AcceptChanges();
// QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase11_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer11, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0010')"));
//}
//else if (ultraTabControl3.SelectedTab.Index == 5)//其他
//{
// publicUltraGridDataCJBase12_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
// publicUltraGridDataCJBase12_2.DataTable.AcceptChanges();
// QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase12_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer12, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
//}
tabIndex = ultraTabControl3.SelectedTab.Index;
}
//修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
///
/// 修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
///
///
///
private void UpdateCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
{
try
{
if (ultraTabControl1.SelectedTab.Index != 1)
{
MessageUtil.ShowTips("只有在已录入数据页才能进行修改操作！");
return;
}
if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
{
MessageUtil.ShowWarning("请选择需要修改的试样信息！");
return;
}
if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
{
return;
}
//if (publicUltraGridBase2.Ur.Cells["FLAG"].Text == "已审核")
//{
// MessageUtil.ShowTips("已审核的数据不允许修改！");
// return;
//}
if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
{
string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
ArrayList alAll = new ArrayList();
ArrayList alProcessResult = new ArrayList();//过程信息list新值
ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
ArrayList alDeletePhyItems = new ArrayList();
ArrayList alPhyItems = new ArrayList();
ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
ArrayList alDeletePhyItemsParams = new ArrayList();
ArrayList alPhyItemsParams = new ArrayList();
string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//用m_OldDt获取原值
foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
{
alProcessResultParamsLog = new ArrayList();
alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
alProcessResultParamsLog.Add(strTime);//操作时间
alProcessResultParamsLog.Add("0");
//alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改
alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
}
string row = "";
publicUltraGridDataCJBase.Ug.UpdateData();
foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
{
if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
{
row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
}
alProcessResultParams = new ArrayList();
alProcessResultParams.Add(dr["VALUE1"].ToString());
alProcessResultParams.Add(dr["VALUE2"].ToString());
alProcessResultParams.Add(dr["VALUE3"].ToString());
alProcessResultParams.Add(dr["VALUE4"].ToString());
alProcessResultParams.Add(dr["VALUE5"].ToString());
alProcessResultParams.Add(dr["VALUE6"].ToString());
alProcessResultParams.Add(dr["VALUE7"].ToString());
alProcessResultParams.Add(dr["VALUE8"].ToString());
alProcessResultParams.Add(dr["VALUE9"].ToString());
alProcessResultParams.Add(dr["VALUE10"].ToString());
alProcessResultParams.Add(dr["VALUE11"].ToString());
alProcessResultParams.Add(dr["VALUE12"].ToString());
alProcessResultParams.Add(dr["VALUE13"].ToString());
alProcessResultParams.Add(dr["VALUE14"].ToString());
alProcessResultParams.Add(dr["VALUE15"].ToString());
alProcessResultParams.Add(dr["REMARK"].ToString());
//alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
alProcessResult.Add(alProcessResultParams);//新值
}
if (publicUltraGridDataCJBaseItems.DataTable != null)
{
string strMethod = "";
publicUltraGridDataCJBaseItems.Ug.UpdateData();
foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
{
if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
{
strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
alDeletePhyItemsParams = new ArrayList();
alDeletePhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
alDeletePhyItemsParams.Add(strSAMPLE_NO);
alDeletePhyItemsParams.Add(strCHECK_NO);
alDeletePhyItems.Add(alDeletePhyItemsParams);
}
alPhyItemsParams = new ArrayList();
alPhyItemsParams.Add(strCHECK_NO);
alPhyItemsParams.Add(strSAMPLE_NO);
alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());
alPhyItemsParams.Add(dr["VALUE1"].ToString());
alPhyItemsParams.Add(dr["VALUE2"].ToString());
alPhyItemsParams.Add(dr["VALUE3"].ToString());
alPhyItemsParams.Add(dr["VALUE4"].ToString());
alPhyItemsParams.Add(dr["VALUE5"].ToString());
alPhyItemsParams.Add(dr["VALUE6"].ToString());
alPhyItemsParams.Add(dr["VALUE7"].ToString());
alPhyItemsParams.Add(dr["VALUE8"].ToString());
alPhyItemsParams.Add(dr["VALUE9"].ToString());
alPhyItemsParams.Add(dr["VALUE10"].ToString());
alPhyItemsParams.Add(dr["VALUE11"].ToString());
alPhyItemsParams.Add(dr["VALUE12"].ToString());
alPhyItemsParams.Add(dr["VALUE13"].ToString());
alPhyItemsParams.Add(dr["VALUE14"].ToString());
alPhyItemsParams.Add(dr["VALUE15"].ToString());
alPhyItemsParams.Add("");
alPhyItems.Add(alPhyItemsParams);
}
}
alAll.Add(alProcessResultLog);//原值
alAll.Add(alProcessResult);//新值
if (alDeletePhyItems.Count > 0)
{
alAll.Add(alDeletePhyItems);
}
if (alPhyItems.Count > 0)
{
alAll.Add(alPhyItems);
}
row = row.Remove(0, 1);
ArrayList al = new ArrayList();
al.Add(strCHECK_NO);
al.Add(strSAMPLE_NO);
al.Add(row);
PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.UpdateCheckConsignProcessResult",
new Object[] { al, alAll }, this.ob);
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
//QueryCheckConsignBaseDetail_Distinct("2");
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
MessageUtil.ShowTips("修改成功！");
}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
//删除检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
///
/// 删除检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
///
///
///
private void DeleteCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
{
try
{
if (ultraTabControl1.SelectedTab.Index != 1)
{
MessageUtil.ShowTips("只有在已录入数据页才能进行删除操作！");
return;
}
if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
{
MessageUtil.ShowWarning("请选择需要删除的试样信息！");
return;
}
if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
{
return;
}
if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
{
string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
ArrayList alAll = new ArrayList();
ArrayList alDetail = new ArrayList();
ArrayList alProcessResult = new ArrayList();//过程信息list新值
ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
ArrayList alPhyItems = new ArrayList();
ArrayList alDetailParams = new ArrayList();
ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
ArrayList alPhyItemsParams = new ArrayList();
string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
{
alDetailParams = new ArrayList();
alDetailParams.Add("");
alDetailParams.Add("");
alDetailParams.Add("");
alDetailParams.Add("");
alDetailParams.Add("");
alDetailParams.Add("");
alDetailParams.Add("");//班次
alDetailParams.Add("");//班组
alDetailParams.Add("");//录入人
alDetailParams.Add("");//录入时间
alDetailParams.Add("2");//删除之后回到待录入状态
alDetailParams.Add("3");
alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
alDetailParams.Add(strSAMPLE_NO);
alDetailParams.Add(strCHECK_NO);
alDetail.Add(alDetailParams);
}
//用m_OldDt获取原值
foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
{
alProcessResultParamsLog = new ArrayList();
alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
alProcessResultParamsLog.Add(strTime);//操作时间
alProcessResultParamsLog.Add("1");
alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
//alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改
alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
}
string row = "";
publicUltraGridDataCJBase.Ug.UpdateData();//修改原值
foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
{
if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
{
row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
}
alProcessResultParams = new ArrayList();
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
alProcessResultParams.Add("");
//alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
alProcessResult.Add(alProcessResultParams);//新值
}
if (publicUltraGridDataCJBaseItems.DataTable != null)
{
string strMethod = "";
publicUltraGridDataCJBaseItems.Ug.UpdateData();
foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
{
if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
{
strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
alPhyItemsParams = new ArrayList();
alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
alPhyItemsParams.Add(strSAMPLE_NO);
alPhyItemsParams.Add(strCHECK_NO);
alPhyItems.Add(alPhyItemsParams);
}
}
}
alAll.Add(alDetail);
alAll.Add(alProcessResultLog);//原值
alAll.Add(alProcessResult);
if (alPhyItems.Count > 0)
{
alAll.Add(alPhyItems);
}
row = row.Remove(0, 1);
ArrayList al = new ArrayList();
al.Add(strCHECK_NO);
al.Add(strSAMPLE_NO);
al.Add(row);
PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.DeleteCheckConsignProcessResult",
new Object[] { al, alAll }, this.ob);
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
MessageUtil.ShowTips("删除成功！");
}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
private void ultraTabControl3_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
{
int cnt = 0;
if (tabIndex == 0)
{
publicUltraGridDataCJBase7_2.Ug.UpdateData();
cnt = publicUltraGridDataCJBase7_2.DataTable.Rows.Cast().Where(
a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
}
else if (tabIndex == 1)
{
publicUltraGridDataCJBase8_2.Ug.UpdateData();
cnt = publicUltraGridDataCJBase8_2.DataTable.Rows.Cast().Where(
a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
}
else if (tabIndex == 2)
{
publicUltraGridDataCJBase9_2.Ug.UpdateData();
cnt = publicUltraGridDataCJBase9_2.DataTable.Rows.Cast().Where(
a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
}
else if (tabIndex == 3)
{
publicUltraGridDataCJBase10_2.Ug.UpdateData();
cnt = publicUltraGridDataCJBase10_2.DataTable.Rows.Cast().Where(
a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
}
//else if (tabIndex == 4)
//{
// publicUltraGridDataCJBase11_2.Ug.UpdateData();
// cnt = publicUltraGridDataCJBase11_2.DataTable.Rows.Cast().Where(
// a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
//}
//else if (tabIndex == 5)
//{
// publicUltraGridDataCJBase12_2.Ug.UpdateData();
// cnt = publicUltraGridDataCJBase12_2.DataTable.Rows.Cast().Where(
// a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
//}
if (cnt > 0)
{
if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗？") == System.Windows.Forms.DialogResult.No)
{
e.Cancel = true;
}
}
}
#endregion
#region 审核区域
//查询检验委托基本信息
///
/// 查询检验委托基本信息
///
///
///
private void QueryCheckConsignBaseDetail_Distinct(UltraGrid ultraGrid, string strFlag)
{
try
{
if (ultraGrid == ultraGrid1)
{
dataTable2.Rows.Clear();
dataTable1.Rows.Clear();
}
else
{
dataTable4.Rows.Clear();
dataTable3.Rows.Clear();
}
//各试验室各检验项目设置权限
DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignBase_Distinct",
arrId == null ? new Object[] { pipeQueryBase1.GetQueryInfo(strFlag) } : new Object[] { pipeQueryBase1.GetQueryInfo(strFlag), arrId, plineCodes }, ob);
if (dt == null || dt.Rows.Count == 0)
{
ClearPhyDetailItems(ultraGrid == ultraGrid1 ? ultraTabControl4 : ultraTabControl5);
return;
}
GridHelper.CopyDataToDatatable(dt, ultraGrid == ultraGrid1 ? dataTable1 : dataTable3, true);
DataTable dtSample = PublicServer.GetData("com.steering.lims.data.pipe.PublicPipeBase.QueryCheckConsignBaseDetail_Distinct",
arrId == null ? new Object[] { pipeQueryBase1.GetQueryInfo(strFlag) } : new Object[] { pipeQueryBase1.GetQueryInfo(strFlag), arrId, plineCodes }, ob);
if (dtSample == null || dtSample.Rows.Count == 0)
{
return;
}
else
{
GridHelper.CopyDataToDatatable(dtSample, ultraGrid == ultraGrid1 ? dataTable2 : dataTable4, true);
}
GridHelper.RefreshAndAutoSize(ultraGrid);
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
#endregion
#region 未审核
private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
{
try
{
//if (ultraGrid1.ActiveRow.HasChild())
//{
// try
// {
// ultraGrid1.ActiveRow.GetChild(Infragistics.Win.UltraWinGrid.ChildRow.First).Activate();
// }
// catch (Exception ex)
// {
// }
//}
if (ultraGrid1.ActiveRow.HasParent())
{
pipeShowBase3.ShowBaseInfo(ultraGrid1.ActiveRow.ParentRow);
//赋值给全局变量
UltraGridRow ur = ultraGrid1.ActiveRow;
ArrayList arrayList = new ArrayList();
arrayList.Add("3");
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
if (arrId != null && arrId.Length > 0)
{
ClearPhyDetailItems(ultraTabControl4);
//查询检验项目明细
DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
if (dt == null || dt.Rows.Count == 0)
{
m_dtPhyMaxAudit = null;
m_dtPhyItemsAudit = null;
return;
}
m_dtPhyMaxAudit = dt.Copy();
DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
new Object[] { arrayList, arrId }, ob);
if (dtItems == null || dtItems.Rows.Count == 0)
{
m_dtPhyItemsAudit = null;
//return;
}
else
{
m_dtPhyItemsAudit = dtItems.Copy();
}
ChangeColor(m_dtPhyMaxAudit, ultraTabControl4);
AddPhyDetailItemsAudit();
//设备信息
getugr();
publicDataCJBase3.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase3.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
}
else
{
ultraGrid1.ActiveRow.Expanded = true;
//ultraGrid1.ActiveRow.ChildBands[0].Rows[0].Activated = true;
}
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
}
}
private void AddPhyDetailItemsAudit()
{
if (m_dtPhyMaxAudit == null || m_dtPhyMaxAudit.Rows.Count == 0) return;
//R0019 抗挤毁强度，R0047 爆破，复合力R0048
if (ultraTabControl4.SelectedTab.Index == 0)//压溃
{
publicUltraGridDataCJBase13_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));//
//publicUltraGridDataCJBase13_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase13_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer13, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
}
else if (ultraTabControl4.SelectedTab.Index == 1)
{
publicUltraGridDataCJBase14_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
//publicUltraGridDataCJBase14_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase14_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer14, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
}
else if (ultraTabControl4.SelectedTab.Index == 2)
{
publicUltraGridDataCJBase15_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0046'"));//
//publicUltraGridDataCJBase15_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase15_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0046'"), splitContainer15, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0046'"));
}
else if (ultraTabControl4.SelectedTab.Index == 3)//
{
publicUltraGridDataCJBase16_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
//publicUltraGridDataCJBase16_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase16_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer16, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
}
//else if (ultraTabControl4.SelectedTab.Index == 4)//
//{
// publicUltraGridDataCJBase17_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0010')"));//工艺
// //publicUltraGridDataCJBase17_2.DataTable.AcceptChanges();
// QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase17_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0010')"), splitContainer17, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0010')"));
//}
//else if (ultraTabControl4.SelectedTab.Index == 5)//
//{
// publicUltraGridDataCJBase18_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
// //publicUltraGridDataCJBase18_2.DataTable.AcceptChanges();
// QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase18_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer18, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
//}
//tabIndex = ultraTabControl4.SelectedTab.Index;
}
private void ultraTabControl4_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
{
//if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
if (toolMenu == null) return;
AddPhyDetailItemsAudit();
//设备信息
getugr();
publicDataCJBase3.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase3.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
private void AuditCheckConsignDetail()
{
try
{
if (ultraTabControl1.SelectedTab.Index != 2)
{
MessageUtil.ShowWarning("只有在未审核数据页才能进行审核操作！");
return;
}
if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
{
MessageUtil.ShowWarning("请选择需要审核的检验信息！");
return;
}
if (dataTable1 == null || dataTable1.Rows.Count == 0)
{
return;
}
ultraGrid1.UpdateData();
DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
if (arrBase == null || arrBase.Length == 0)
{
MessageUtil.ShowTips("请勾选至少一条检验信息！");
return;
}
string user = UserInfo.GetUserName();
string strDate = DateTime.Now.ToString();
DataTable dy = ServerHelper.GetData("com.steering.lims.data.pipe.FrmLabDateParm.getAuditName", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX }, ob);
if (dy.Rows.Count > 0 && dy != null)
{
if (user.Equals(dy.Rows[0]["CHECK_NAME"].ToString()))
{
MessageUtil.ShowTips("试验人与审核人是同一人，不能审核!");
return;
}
}
if (MessageUtil.ShowYesNoAndQuestion("是否确认审核？") == DialogResult.Yes)
{
ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
foreach (DataRow row in arrBase)
{
alBaseParams = new ArrayList();//增加要更新的基础标志位信息
alBaseParams.Add("4");
alBaseParams.Add(user);//审核人
alBaseParams.Add(strDate);//审核时间
alBaseParams.Add("");
alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
alBaseParams.Add("3");
alBaseParams.Add("");//PHY_CODE_MAX
alBaseParams.Add("");
alBaseParams.Add("");
alBaseParams.Add(row["SAMPLE_NO"].ToString());
alBaseParams.Add(row["CHECK_NO"].ToString());
alBaseParams.Add(arrIdStr);
alBase.Add(alBaseParams);
}
PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
new Object[] { alBase }, this.ob);
UpFileAuto();
QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
//QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
//PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
//PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
MessageUtil.ShowTips("审核成功！");
}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
private void SingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
{
try
{
if (ultraTabControl1.SelectedTab.Index != 2)
{
MessageUtil.ShowWarning("只有在未审核数据页才能进行单项审核操作！");
return;
}
if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
{
MessageUtil.ShowWarning("请选择需要单项审核的检验信息！");
return;
}
if (dataTable1 == null || dataTable1.Rows.Count == 0)
{
return;
}
ultraGrid1.UpdateData();
DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
if (arrBase == null || arrBase.Length == 0)
{
MessageUtil.ShowTips("请勾选至少一条检验信息！");
return;
}
// string row = "";
//foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
//{
// if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
// {
// row += dr["PHY_CODE_MAX"].ToString() + " ";
if (MessageUtil.ShowYesNoAndQuestion("是否确认单项审核？") == DialogResult.Yes)
{
ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
string user = UserInfo.GetUserName();
string strDate = DateTime.Now.ToString();
string rowSample = "";
foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
{
if (rowSample.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
{
rowSample += dr["PHY_CODE_MAX"].ToString() + " ";
}
}
DataTable dy = ServerHelper.GetData("com.steering.lims.data.pipe.FrmLabDateParm.getAuditName", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX }, ob);
if (dy.Rows.Count > 0 && dy != null)
{
if (user.Equals(dy.Rows[0]["CHECK_NAME"].ToString()))
{
MessageUtil.ShowTips("试验人与审核人是同一人，不能审核!");
return;
}
}
foreach (DataRow row in arrBase)
{
foreach (string strPHY_CODE_MAX in rowSample.Trim().Split(' '))
{
alBaseParams = new ArrayList();//增加要更新的基础标志位信息
alBaseParams.Add("4");
alBaseParams.Add(user);//审核人
alBaseParams.Add(strDate);//审核时间
alBaseParams.Add("");
alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
alBaseParams.Add("3");
alBaseParams.Add(strPHY_CODE_MAX);//PHY_CODE_MAX
alBaseParams.Add(strPHY_CODE_MAX);
alBaseParams.Add(strPHY_CODE_MAX);
alBaseParams.Add(row["SAMPLE_NO"].ToString());
alBaseParams.Add(row["CHECK_NO"].ToString());
alBaseParams.Add(arrIdStr);
alBase.Add(alBaseParams);
}
}
PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
new Object[] { alBase }, this.ob);
UpFileAuto();
QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
//QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
//PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
//PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
MessageUtil.ShowTips("单项审核成功！");
}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
private void ultraGrid1_CellChange(object sender, CellEventArgs e)
{
if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK")
{
ultraGrid1.UpdateData();
if (e.Cell.Value.ToString() == "True")
{
foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
{
dr.Cells["CHK"].Value = "True";
}
}
else
{
foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
{
dr.Cells["CHK"].Value = "False";
}
}
}
}
#endregion
#region 已审核
private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
{
try
{
if (ultraGrid2.ActiveRow.HasParent())
{
pipeShowBase4.ShowBaseInfo(ultraGrid2.ActiveRow.ParentRow);
//赋值给全局变量
UltraGridRow ur = ultraGrid2.ActiveRow;
ArrayList arrayList = new ArrayList();
arrayList.Add("45");
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
if (arrId != null && arrId.Length > 0)
{
ClearPhyDetailItems(ultraTabControl5);
//查询检验项目明细
DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
if (dt == null || dt.Rows.Count == 0)
{
m_dtPhyMaxAuditAdd = null;
m_dtPhyItemsAuditAdd = null;
return;
}
m_dtPhyMaxAuditAdd = dt.Copy();
DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
new Object[] { arrayList, arrId }, ob);
if (dtItems == null || dtItems.Rows.Count == 0)
{
m_dtPhyItemsAuditAdd = null;
//return;
}
else
{
m_dtPhyItemsAuditAdd = dtItems.Copy();
}
ChangeColor(m_dtPhyMaxAuditAdd, ultraTabControl5);
AddPhyDetailItemsAudit_Log();
//设备信息
getugr();
publicDataCJBase4.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase4.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
}
else
{
ultraGrid2.ActiveRow.Expanded = true;
//ultraGrid2.ActiveRow.ChildBands[0].Rows[0].Activated = true;
}
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
}
}
private void AddPhyDetailItemsAudit_Log()
{
if (m_dtPhyMaxAuditAdd == null || m_dtPhyMaxAuditAdd.Rows.Count == 0) return;
if (ultraTabControl5.SelectedTab.Index == 0)
{
publicUltraGridDataCJBase19_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));//
//publicUltraGridDataCJBase19_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase19_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer19, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
}
else if (ultraTabControl5.SelectedTab.Index == 1)
{
publicUltraGridDataCJBase20_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
//publicUltraGridDataCJBase20_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase20_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer20, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
}
else if (ultraTabControl5.SelectedTab.Index == 2)
{
publicUltraGridDataCJBase21_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0046'"));//
//publicUltraGridDataCJBase21_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase21_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0046'"), splitContainer21, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0046'"));
}
else if (ultraTabControl5.SelectedTab.Index == 3)//
{
publicUltraGridDataCJBase22_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
//publicUltraGridDataCJBase22_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase22_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer22, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
}
//else if (ultraTabControl5.SelectedTab.Index == 4)//
//{
// publicUltraGridDataCJBase23_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
// //publicUltraGridDataCJBase23_2.DataTable.AcceptChanges();
// QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase23_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer23, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0010')"));
//}
//else if (ultraTabControl5.SelectedTab.Index == 5)//
//{
// publicUltraGridDataCJBase24_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
// //publicUltraGridDataCJBase24_2.DataTable.AcceptChanges();
// QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase24_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer24, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
//}
}
private void ultraTabControl5_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
{
//if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
if (toolMenu == null) return;
AddPhyDetailItemsAudit_Log();
//设备信息
getugr();
publicDataCJBase4.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase4.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
private void CancelAuditCheckConsignDetail()
{
try
{
if (ultraTabControl1.SelectedTab.Index != 3)
{
MessageUtil.ShowWarning("只有在已审核数据页才能进行取消审核操作！");
return;
}
if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
{
MessageUtil.ShowWarning("请选择需要取消审核的检验信息！");
return;
}
if (dataTable3 == null || dataTable3.Rows.Count == 0)
{
return;
}
ultraGrid2.UpdateData();
DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
if (arrBase == null || arrBase.Length == 0)
{
MessageUtil.ShowTips("请勾选至少一条检验信息！");
return;
}
//if (MessageUtil.ShowYesNoAndQuestion("是否确认取消审核？") == DialogResult.Yes)
//{
WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
pc.ShowDialog();
if (pc.DialogResult != DialogResult.OK)
{
return;
}
string strRemark = pc.StrRemark;
string user = UserInfo.GetUserName();
string strDate = DateTime.Now.ToString();
strRemark = "取消审核由于" + strRemark + "(" + user + " " + strDate + ")";
string strCHECK_NO = "";
ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
foreach (DataRow row in arrBase)
{
DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryDetailFlag", new object[] { row["CHECK_NO"].ToString(), row["SAMPLE_NO"].ToString(), "" }, ob);
if (int.Parse(ds.Rows[0][0].ToString()) == 5)
{
MessageUtil.ShowTips("数据已接收，请联系判定站删除!");
return;
}
alBaseParams = new ArrayList();//增加要更新的基础标志位信息
alBaseParams.Add("3");
alBaseParams.Add(user);//审核人
alBaseParams.Add(strDate);//审核时间
alBaseParams.Add(strRemark);
alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
alBaseParams.Add("4");
alBaseParams.Add("");//PHY_CODE_MAX
alBaseParams.Add("");
alBaseParams.Add("");
alBaseParams.Add(row["SAMPLE_NO"].ToString());
alBaseParams.Add(row["CHECK_NO"].ToString());
alBaseParams.Add(arrIdStr);
if (strCHECK_NO == "")
{
strCHECK_NO = row["CHECK_NO"].ToString();
}
alBase.Add(alBaseParams);
}
PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
new Object[] { alBase }, this.ob);
QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
MessageUtil.ShowTips("取消审核成功！");
//}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
private void CancelSingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
{
try
{
if (ultraTabControl1.SelectedTab.Index != 3)
{
MessageUtil.ShowWarning("只有在已审核数据页才能进行取消单项审核操作！");
return;
}
if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
{
MessageUtil.ShowWarning("请选择需要取消单项审核的检验信息！");
return;
}
if (dataTable3 == null || dataTable3.Rows.Count == 0)
{
return;
}
ultraGrid2.UpdateData();
DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
if (arrBase == null || arrBase.Length == 0)
{
MessageUtil.ShowTips("请勾选至少一条检验信息！");
return;
}
//if (MessageUtil.ShowYesNoAndQuestion("是否确认单项审核？") == DialogResult.Yes)
//{
WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
pc.ShowDialog();
if (pc.DialogResult != DialogResult.OK)
{
return;
}
string strRemark = pc.StrRemark;
string user = UserInfo.GetUserName();
string strDate = DateTime.Now.ToString();
strRemark = "取消单项审核由于" + strRemark + "(" + user + " " + strDate + ")";
ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
string strCHECK_NO = "";
string rowSample = "";
foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
{
if (rowSample.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
{
rowSample += dr["PHY_CODE_MAX"].ToString() + " ";
}
}
foreach (DataRow row in arrBase)
{
foreach (string strPHY_CODE_MAX in rowSample.Trim().Split(' '))
{
DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryDetailFlag", new object[] { row["CHECK_NO"].ToString(), row["SAMPLE_NO"].ToString(), strPHY_CODE_MAX }, ob);
if (int.Parse(ds.Rows[0][0].ToString()) == 5)
{
MessageUtil.ShowTips("数据已接收，请联系判定站删除!");
return;
}
alBaseParams = new ArrayList();//增加要更新的基础标志位信息
alBaseParams.Add("3");
alBaseParams.Add(user);//审核人
alBaseParams.Add(strDate);//审核时间
alBaseParams.Add(strRemark);
alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
alBaseParams.Add("4");
alBaseParams.Add(strPHY_CODE_MAX);//PHY_CODE_MAX
alBaseParams.Add(strPHY_CODE_MAX);
alBaseParams.Add(strPHY_CODE_MAX);
alBaseParams.Add(row["SAMPLE_NO"].ToString());
alBaseParams.Add(row["CHECK_NO"].ToString());
alBaseParams.Add(arrIdStr);
if (strCHECK_NO == "")
{
strCHECK_NO = row["CHECK_NO"].ToString();
}
alBase.Add(alBaseParams);
}
}
PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
new Object[] { alBase }, this.ob);
QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
MessageUtil.ShowTips("取消单项审核成功！");
//}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
private void ultraGrid2_CellChange(object sender, CellEventArgs e)
{
if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK")
{
ultraGrid2.UpdateData();
if (e.Cell.Value.ToString() == "True")
{
foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
{
dr.Cells["CHK"].Value = "True";
}
}
else
{
foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
{
dr.Cells["CHK"].Value = "False";
}
}
}
}
#endregion
private void FrmLabEngDataCJAudit_Shown(object sender, EventArgs e)
{
if (toolMenu == null) return;
if (toolMenu.Toolbars[0].Tools.Exists("Query"))
{
toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Add"))
{
this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
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("Audit"))
{
toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
{
toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
{
toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
{
toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
}
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("Query"))
{
toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Add"))
{
this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
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("Audit"))
{
toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
{
toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
{
toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
{
toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
}
else if (ultraTabControl1.SelectedTab.Index == 1)
{
if (toolMenu.Toolbars[0].Tools.Exists("Query"))
{
toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Add"))
{
this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
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("Audit"))
{
toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
{
toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
{
toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
{
toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
}
else if (ultraTabControl1.SelectedTab.Index == 2)
{
if (toolMenu.Toolbars[0].Tools.Exists("Query"))
{
toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Add"))
{
this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
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("Audit"))
{
toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
{
toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
{
toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
{
toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
}
else if (ultraTabControl1.SelectedTab.Index == 3)
{
if (toolMenu.Toolbars[0].Tools.Exists("Query"))
{
toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Add"))
{
this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
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("Audit"))
{
toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
{
toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
{
toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
{
toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
}
}
}
}
}