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 Core.StlMes.Client.Lims.Data.PipeAndOutdec.数据管理.外委实验管理;
using Core.StlMes.Client.Lims.Data.PipeAndOutdec.封装类.实体类;
using Core.Mes.Client.Comm.Server;
namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
//应力腐蚀录入界面 各检验大项分Tab页展示
public partial class FrmOutdecLabCorDataCJAudit : 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 int tabIndex = 0;//保存当前的tab页
public FrmOutdecLabCorDataCJAudit()
{
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;
publicUltraGridDataCJBase111.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase111.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase11.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase121.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase121.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase21.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase131.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase131.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase31.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase141.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase141.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase41.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase151.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase151.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase51.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase161.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase161.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase61.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;
publicUltraGridDataCJBase112.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase112.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase12.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase122.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase122.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase22.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase132.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase132.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase32.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase142.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase142.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase42.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase152.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase152.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase52.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase162.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase162.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase62.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;
publicUltraGridDataCJBase113.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase113.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase13.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase123.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase123.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase23.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase133.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase133.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase33.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase143.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase143.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase43.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase153.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase153.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase53.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase163.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase163.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase63.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;
publicUltraGridDataCJBase114.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase114.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase14.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase124.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase124.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase24.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase134.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase134.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase34.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase144.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase144.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase44.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase154.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase154.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase54.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
publicUltraGridDataCJBase164.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
publicUltraGridDataCJBase164.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
publicUltraGridDataCJBase64.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
}
private void FrmDataCJBase_Load(object sender, EventArgs e)
{
//arrId = this.ValidDataPurviewIds;//获取数据权限
arrId = new string[] { "002001007013" };//应力腐蚀项目
plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
InitColumns();
publicDataCJBase1.checkNameEnable();
publicDataCJBase2.checkNameEnable();
publicDataCJBase3.checkNameEnable();
publicDataCJBase4.checkNameEnable();
//publicDataCJBase1.initCheckEqiupment(arrId, this.ob);
//publicDataCJBase2.initCheckEqiupment(arrId, this.ob);
//publicDataCJBase3.initCheckEqiupment(arrId, this.ob);
//publicDataCJBase4.initCheckEqiupment(arrId, this.ob);
publicUltraGridDataCJBase1_2.Ug.CellChange += Ug_CellChange;
publicUltraGridDataCJBase2_2.Ug.CellChange += Ug_CellChange;
publicUltraGridDataCJBase7_2.Ug.CellChange += Ug_CellChange;
publicUltraGridDataCJBase8_2.Ug.CellChange += Ug_CellChange;
outdecQueryBase1.ShowControlProofRingNo();
outdecQueryBase1.ShowControl();
}
///
/// 自动求平均值
///
///
///
private void Ug_CellChange(object sender, CellEventArgs e)
{
int a = 0,b = 0,c=0,n=0;
publicUltraGridDataCJBase1_2.Ug.UpdateData();
publicUltraGridDataCJBase2_2.Ug.UpdateData();
publicUltraGridDataCJBase7_2.Ug.UpdateData();
publicUltraGridDataCJBase8_2.Ug.UpdateData();
if (e.Cell.Column.Key == "VALUE1" || e.Cell.Column.Key == "VALUE2" || e.Cell.Column.Key == "VALUE3")
{
if (e.Cell.Row.Cells["VALUE1"].Value.ToString() != "")
{ a += 1; }
if (e.Cell.Row.Cells["VALUE2"].Value.ToString() != "")
{ a += 1; }
if (e.Cell.Row.Cells["VALUE3"].Value.ToString() != "")
{ a += 1; }
e.Cell.Row.Cells["VALUE4"].Value = Math.Round((double.Parse(e.Cell.Row.Cells["VALUE1"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["VALUE2"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["VALUE3"].Value.ToString3()) ) / a);
}
if (e.Cell.Column.Key == "VALUE5" || e.Cell.Column.Key == "VALUE6" || e.Cell.Column.Key == "VALUE7")
{
if (e.Cell.Row.Cells["VALUE5"].Value.ToString() != "")
{ b += 1; }
if (e.Cell.Row.Cells["VALUE6"].Value.ToString() != "")
{ b += 1; }
if (e.Cell.Row.Cells["VALUE7"].Value.ToString() != "")
{ b += 1; }
e.Cell.Row.Cells["VALUE8"].Value = Math.Round((double.Parse(e.Cell.Row.Cells["VALUE5"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["VALUE6"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["VALUE7"].Value.ToString3())) / b);
}
if (e.Cell.Column.Key == "VALUE9" || e.Cell.Column.Key == "VALUE10" || e.Cell.Column.Key == "VALUE11")
{
if (e.Cell.Row.Cells["VALUE9"].Value.ToString() != "")
{ c += 1; }
if (e.Cell.Row.Cells["VALUE10"].Value.ToString() != "")
{ c += 1; }
if (e.Cell.Row.Cells["VALUE11"].Value.ToString() != "")
{ c += 1; }
e.Cell.Row.Cells["VALUE12"].Value = Math.Round((double.Parse(e.Cell.Row.Cells["VALUE9"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["VALUE10"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["VALUE11"].Value.ToString3())) / c);
}
if (e.Cell.Row.Cells["VALUE4"].Value.ToString() != "")
{ n += 1; }
if (e.Cell.Row.Cells["VALUE8"].Value.ToString() != "")
{ n += 1; }
if (e.Cell.Row.Cells["VALUE12"].Value.ToString() != "")
{ n += 1; }
e.Cell.Row.Cells["AVERAGE"].Value = Math.Round((double.Parse(e.Cell.Row.Cells["VALUE4"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["VALUE8"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["VALUE12"].Value.ToString3())) / n);
}
private void InitColumns()
{
outdecShowBase1.ChangeLabel();
outdecShowBase2.ChangeLabel();
outdecQueryBase1.BindComboxNew(this.UserInfo.GetDeptid(), this.ob);
//未录入
publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
publicUltraGridBase1.InitColumnsOutdecBase(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.InitColumnsOutdecPhyDetailHIC();
publicUltraGridDataCJBase2_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase2_2.InitColumnsOutdecPhyDetailHIC();
//publicUltraGridDataCJBase2_2.InitColumnsOutdecPhyDetailSSC();
publicUltraGridDataCJBase3_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase3_2.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase111.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase121.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase131.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase141.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase151.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase161.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase11.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase21.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase31.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase41.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase51.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase61.InitColumnsOutdecPhyDetail();
//publicUltraGridDetail1.InitColumnsPipeDetailFS(new string[] { "PHY_NAME_MAX", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3" }, new string[] { "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3" }, true, this.ob, "0");
//已录入
publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件
publicUltraGridBase2.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "CHECK_TIME" }, 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.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase7_2.InitColumnsOutdecPhyDetailHIC();
publicUltraGridDataCJBase8_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase8_2.InitColumnsOutdecPhyDetailHIC();
//publicUltraGridDataCJBase8_2.InitColumnsOutdecPhyDetailSSC();
publicUltraGridDataCJBase9_1.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase9_2.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase112.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase122.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase132.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase142.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase152.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase162.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase12.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase22.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase32.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase42.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase52.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase62.InitColumnsOutdecPhyDetail();
// publicUltraGridDetail2.InitColumnsPipeDetailFS(new string[] { "PHY_NAME_MAX", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3" }, new string[] { "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3" }, true, this.ob, "0");
//publicUltraGridDataCJBase10_1.InitColumnsPhyConfigItems();
//publicUltraGridDataCJBase10_2.InitColumnsOutdecPhyDetail();
//publicUltraGridDataCJBase11_1.InitColumnsPhyConfigItems();
//publicUltraGridDataCJBase11_2.InitColumnsOutdecPhyDetail();
//publicUltraGridDataCJBase12_1.InitColumnsPhyConfigItems();
//publicUltraGridDataCJBase12_2.InitColumnsOutdecPhyDetail();
//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);
publicUltraGridBase3.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase3_PublicUltraGridBaseActive);//调用委托事件
publicUltraGridBase3.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO", "CHECK_TIME" }, true, null);
publicUltraGridDataCJBase13_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase13_1.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase13_2.InitColumnsOutdecPhyDetailHIC();
publicUltraGridDataCJBase13_2.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase14_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase14_1.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase14_2.InitColumnsOutdecPhyDetailHIC();
publicUltraGridDataCJBase14_2.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase15_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase15_1.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase15_2.InitColumnsOutdecPhyDetail(null);
publicUltraGridDataCJBase15_2.setOtherColumnReadOnly(null);
publicUltraGridDataCJBase113.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase123.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase133.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase143.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase153.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase163.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase13.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase23.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase33.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase43.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase53.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase63.InitColumnsOutdecPhyDetail();
// publicUltraGridDetail3.InitColumnsPipeDetailFS(new string[] { "PHY_NAME_MAX", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3" }, null, true, this.ob, "1");
// publicUltraGridDetail3.setUltraTextEditor1Hidden();
//publicUltraGridDataCJBase16_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase16_2.InitColumnsOutdecPhyDetail(null);
//publicUltraGridDataCJBase17_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase17_2.InitColumnsOutdecPhyDetail(null);
//publicUltraGridDataCJBase18_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase18_2.InitColumnsOutdecPhyDetail(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);
publicUltraGridBase4.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase4_PublicUltraGridBaseActive);//调用委托事件
publicUltraGridBase4.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO", "CHECK_TIME" }, true, null);
publicUltraGridDataCJBase19_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase19_2.InitColumnsOutdecPhyDetailHIC();
publicUltraGridDataCJBase20_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase20_2.InitColumnsOutdecPhyDetailHIC();
publicUltraGridDataCJBase21_1.InitColumnsPhyConfigItems(null);
publicUltraGridDataCJBase21_2.InitColumnsOutdecPhyDetail(null);
publicUltraGridDataCJBase114.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase124.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase134.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase144.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase154.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase164.InitColumnsPhyConfigItems();
publicUltraGridDataCJBase14.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase24.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase34.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase44.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase54.InitColumnsOutdecPhyDetail();
publicUltraGridDataCJBase64.InitColumnsOutdecPhyDetail();
//publicUltraGridDetail4.InitColumnsPipeDetailFS(new string[] { "PHY_NAME_MAX", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3" }, null, true, this.ob, "1");
//publicUltraGridDataCJBase22_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase22_2.InitColumnsOutdecPhyDetail(null);
//publicUltraGridDataCJBase23_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase23_2.InitColumnsOutdecPhyDetail(null);
//publicUltraGridDataCJBase24_1.InitColumnsPhyConfigItems(null);
//publicUltraGridDataCJBase24_2.InitColumnsOutdecPhyDetail(null);
}
///
/// 重写基类方法
///
///
///
public override void ToolBar_Click(object sender, string ToolbarKey)
{
//查询、确认、退出
switch (ToolbarKey)
{
case "Query":
if (ultraTabControl1.SelectedTab.Index == 0)
{
QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase1, "2");
}
else if (ultraTabControl1.SelectedTab.Index == 1)
{
QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase2, "3");
}
else if (ultraTabControl1.SelectedTab.Index == 2)
{
QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase3, "3");
}
else if (ultraTabControl1.SelectedTab.Index == 3)
{
QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase4, "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(publicUltraGridDataCJBase11, publicUltraGridDataCJBase111);
}
else if (ultraTabControl2.SelectedTab.Index == 4)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase21, publicUltraGridDataCJBase121);
}
else if (ultraTabControl2.SelectedTab.Index == 5)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase31, publicUltraGridDataCJBase131);
}
else if (ultraTabControl2.SelectedTab.Index == 6)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase41, publicUltraGridDataCJBase141);
}
else if (ultraTabControl2.SelectedTab.Index == 7)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase51, publicUltraGridDataCJBase151);
}
else if (ultraTabControl2.SelectedTab.Index == 8)
{
AddCheckConsignProcessResult(publicUltraGridDataCJBase61, publicUltraGridDataCJBase161);
}
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(publicUltraGridDataCJBase12, publicUltraGridDataCJBase112);
}
else if (ultraTabControl3.SelectedTab.Index == 4)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase22, publicUltraGridDataCJBase122);
}
else if (ultraTabControl3.SelectedTab.Index == 5)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase32, publicUltraGridDataCJBase132);
}
else if (ultraTabControl3.SelectedTab.Index == 6)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase42, publicUltraGridDataCJBase142);
}
else if (ultraTabControl3.SelectedTab.Index == 7)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase52, publicUltraGridDataCJBase152);
}
else if (ultraTabControl3.SelectedTab.Index == 8)
{
UpdateCheckConsignProcessResult(publicUltraGridDataCJBase62, publicUltraGridDataCJBase162);
}
//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(publicUltraGridDataCJBase12, publicUltraGridDataCJBase112);
}
else if (ultraTabControl3.SelectedTab.Index == 4)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase22, publicUltraGridDataCJBase122);
}
else if (ultraTabControl3.SelectedTab.Index == 5)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase32, publicUltraGridDataCJBase132);
}
else if (ultraTabControl3.SelectedTab.Index == 6)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase42, publicUltraGridDataCJBase142);
}
else if (ultraTabControl3.SelectedTab.Index == 7)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase52, publicUltraGridDataCJBase152);
}
else if (ultraTabControl3.SelectedTab.Index == 8)
{
DeleteCheckConsignProcessResult(publicUltraGridDataCJBase62, publicUltraGridDataCJBase162);
}
//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(publicUltraGridDataCJBase13);
}
else if (ultraTabControl4.SelectedTab.Index == 4)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase23);
}
else if (ultraTabControl4.SelectedTab.Index == 5)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase33);
}
else if (ultraTabControl4.SelectedTab.Index == 6)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase43);
}
else if (ultraTabControl4.SelectedTab.Index == 7)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase53);
}
else if (ultraTabControl4.SelectedTab.Index == 8)
{
SingleAuditCheckConsignDetail(publicUltraGridDataCJBase63);
}
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(publicUltraGridDataCJBase14);
}
else if (ultraTabControl5.SelectedTab.Index == 4)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase24);
}
else if (ultraTabControl5.SelectedTab.Index == 5)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase34);
}
else if (ultraTabControl5.SelectedTab.Index == 6)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase44);
}
else if (ultraTabControl5.SelectedTab.Index == 7)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase54);
}
else if (ultraTabControl5.SelectedTab.Index == 8)
{
CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase64);
}
break;
case "SaveParm":
SaveParm();
break;
case "DoPrint":
doPrint();
break;
case "Close":
if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
{
this.Close();
}
break;
}
}
#region 公共方法
//打印
///
/// 打印
///
private void doPrint()
{
getugr();
string strurl = "";
if (PHY_CODE_MAX.Equals("C0007")) //HIC
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecHIC.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0061")) //SOHIC
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecSOHIC.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0030")) ////SSC-A
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecSSCA.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0031")) ////SSC-B
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecSSCB.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0032")) //SSC-C
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecSSCC.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0033")) //SSC-D
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecSSCD.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0072")) //盐雾试验
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecSaltSpray.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
}
else if (PHY_CODE_MAX.Equals("C0123")) //点蚀试验
{
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecPitting.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();
}
//设备信息赋值给实体类
///
/// 设备信息赋值给实体类
///
///
///
///
///
private OutdecCheckconsignDetailEntity 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.outdec.FrmOutdecChemDataManage.QueryChemCheckConsignDetail",
new Object[] { listDetail }, ob);
OutdecCheckconsignDetailEntity checkDetal = new OutdecCheckconsignDetailEntity();
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();
}
return checkDetal;
}
//获取激活行UltraGridRow信息
///
/// 获取激活行UltraGridRow信息
///
///
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 = publicUltraGridDataCJBase11.Ug.ActiveRow;
}
else if (ultraTabControl2.SelectedTab.Index == 4)
{
ugr = publicUltraGridDataCJBase21.Ug.ActiveRow;
}
else if (ultraTabControl2.SelectedTab.Index == 5)
{
ugr = publicUltraGridDataCJBase31.Ug.ActiveRow;
}
else if (ultraTabControl2.SelectedTab.Index == 6)
{
ugr = publicUltraGridDataCJBase41.Ug.ActiveRow;
}
else if (ultraTabControl2.SelectedTab.Index == 7)
{
ugr = publicUltraGridDataCJBase51.Ug.ActiveRow;
}
else if (ultraTabControl2.SelectedTab.Index == 8)
{
ugr = publicUltraGridDataCJBase61.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 = publicUltraGridDataCJBase12.Ug.ActiveRow;
}
else if (ultraTabControl3.SelectedTab.Index == 4)
{
ugr = publicUltraGridDataCJBase22.Ug.ActiveRow;
}
else if (ultraTabControl3.SelectedTab.Index == 5)
{
ugr = publicUltraGridDataCJBase32.Ug.ActiveRow;
}
else if (ultraTabControl3.SelectedTab.Index == 6)
{
ugr = publicUltraGridDataCJBase42.Ug.ActiveRow;
}
else if (ultraTabControl3.SelectedTab.Index == 7)
{
ugr = publicUltraGridDataCJBase52.Ug.ActiveRow;
}
else if (ultraTabControl3.SelectedTab.Index == 8)
{
ugr = publicUltraGridDataCJBase62.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 = publicUltraGridDataCJBase13.Ug.ActiveRow;
}
else if (ultraTabControl4.SelectedTab.Index == 4)
{
ugr = publicUltraGridDataCJBase23.Ug.ActiveRow;
}
else if (ultraTabControl4.SelectedTab.Index == 5)
{
ugr = publicUltraGridDataCJBase33.Ug.ActiveRow;
}
else if (ultraTabControl4.SelectedTab.Index == 6)
{
ugr = publicUltraGridDataCJBase43.Ug.ActiveRow;
}
else if (ultraTabControl4.SelectedTab.Index == 7)
{
ugr = publicUltraGridDataCJBase53.Ug.ActiveRow;
}
else if (ultraTabControl4.SelectedTab.Index == 8)
{
ugr = publicUltraGridDataCJBase63.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 = publicUltraGridDataCJBase14.Ug.ActiveRow;
}
else if (ultraTabControl5.SelectedTab.Index == 4)
{
ugr = publicUltraGridDataCJBase24.Ug.ActiveRow;
}
else if (ultraTabControl5.SelectedTab.Index == 5)
{
ugr = publicUltraGridDataCJBase34.Ug.ActiveRow;
}
else if (ultraTabControl5.SelectedTab.Index == 6)
{
ugr = publicUltraGridDataCJBase44.Ug.ActiveRow;
}
else if (ultraTabControl5.SelectedTab.Index == 7)
{
ugr = publicUltraGridDataCJBase54.Ug.ActiveRow;
}
else if (ultraTabControl5.SelectedTab.Index == 8)
{
ugr = publicUltraGridDataCJBase64.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 = "";
}
return ugr;
}
//试验条件
///
/// 试验条件
///
private void SaveParm()
{
getugr();
if (PHY_CODE_MAX.Equals("C0007")) //氢致开裂试验HIC
{
ArrayList list = new ArrayList();
list.Add(CHECK_NO);
list.Add(SAMPLE_NO);
list.Add(PHY_CODE_MAX);
DataTable dt = ServerHelper.GetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.selectHicParm", new object[] { list }, this.ob);
if (dt.Rows.Count == 0)
{
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.lims.data.outdec.FrmOutdecLabDateParm";
ccp.MethodName = "insertHicParm";
ccp.ServerParams = new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (!ccp.ReturnInfo.Equals("保存成功!"))
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
}
else if (PHY_CODE_MAX.Equals("C0033"))//SSC-D
{
ArrayList list = new ArrayList();
list.Add(CHECK_NO);
list.Add(SAMPLE_NO);
list.Add(PHY_CODE_MAX);
DataTable dt = ServerHelper.GetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.selectSscdParm", new object[] { list }, this.ob);
if (dt.Rows.Count == 0)
{
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.lims.data.outdec.FrmOutdecLabDateParm";
ccp.MethodName = "insertSscdParm";
ccp.ServerParams = new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (!ccp.ReturnInfo.Equals("保存成功!"))
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
}
FrmOutdecLabCorDateParm labDateParm = new FrmOutdecLabCorDateParm(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, this.ob);
labDateParm.ShowDialog();
}
//颜色改变
///
/// 颜色改变
///
///
///
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 = 'R0007'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0007'").Rows.Count > 0)
{
i = i == -1 ? i = 0 : i;
ultraTabControl.Tabs[0].Appearance.BackColor = Color.GreenYellow; //HIC
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0043'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0043'").Rows.Count > 0)
{
i = i == -1 ? i = 1 : i;
ultraTabControl.Tabs[1].Appearance.BackColor = Color.GreenYellow; //SOHIC
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MAX = 'C0030'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MAX = 'C0030'").Rows.Count > 0)
{
i = i == -1 ? i = 2 : i;
ultraTabControl.Tabs[2].Appearance.BackColor = Color.GreenYellow;//SSC-A
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MAX = 'C0031'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MAX = 'C0031'").Rows.Count > 0)
{
i = i == -1 ? i = 3 : i;
ultraTabControl.Tabs[3].Appearance.BackColor = Color.GreenYellow;//SSC-B
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MAX = 'C0032'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MAX = 'C0032'").Rows.Count > 0)
{
i = i == -1 ? i = 4 : i;
ultraTabControl.Tabs[4].Appearance.BackColor = Color.GreenYellow;//SSC-C
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MAX = 'C0033'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MAX = 'C0033'").Rows.Count > 0)
{
i = i == -1 ? i = 5 : i;
ultraTabControl.Tabs[5].Appearance.BackColor = Color.GreenYellow;//SSC-D
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0056'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0056'").Rows.Count > 0)
{
i = i == -1 ? i = 6 : i;
ultraTabControl.Tabs[6].Appearance.BackColor = Color.GreenYellow;//盐雾试验
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0061'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0061'").Rows.Count > 0)
{
i = i == -1 ? i = 7 : i;
ultraTabControl.Tabs[7].Appearance.BackColor = Color.GreenYellow;//点蚀试验
}
if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')").Rows.Count > 0)
{
i = i == -1 ? i = 8 : i;
ultraTabControl.Tabs[8].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;
ultraTabControl.Tabs[6].Appearance.BackColor = Control.DefaultBackColor;
ultraTabControl.Tabs[7].Appearance.BackColor = Control.DefaultBackColor;
ultraTabControl.Tabs[8].Appearance.BackColor = Control.DefaultBackColor;
if (ultraTabControl == ultraTabControl2)
{
publicUltraGridDataCJBase1_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase2_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase3_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase1_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase2_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase3_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase111.DataTable.Rows.Clear();
publicUltraGridDataCJBase121.DataTable.Rows.Clear();
publicUltraGridDataCJBase131.DataTable.Rows.Clear();
publicUltraGridDataCJBase141.DataTable.Rows.Clear();
publicUltraGridDataCJBase151.DataTable.Rows.Clear();
publicUltraGridDataCJBase161.DataTable.Rows.Clear();
publicUltraGridDataCJBase11.DataTable.Rows.Clear();
publicUltraGridDataCJBase21.DataTable.Rows.Clear();
publicUltraGridDataCJBase31.DataTable.Rows.Clear();
publicUltraGridDataCJBase41.DataTable.Rows.Clear();
publicUltraGridDataCJBase51.DataTable.Rows.Clear();
publicUltraGridDataCJBase61.DataTable.Rows.Clear();
splitContainer1.Panel1Collapsed = true;
splitContainer2.Panel1Collapsed = true;
splitContainer3.Panel1Collapsed = true;
splitContainer4.Panel1Collapsed = true;
splitContainer5.Panel1Collapsed = true;
splitContainer6.Panel1Collapsed = true;
splitContainer10.Panel1Collapsed = true;
splitContainer11.Panel1Collapsed = true;
splitContainer12.Panel1Collapsed = true;
}
else if (ultraTabControl == ultraTabControl3)
{
publicUltraGridDataCJBase7_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase8_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase9_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase7_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase8_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase9_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase112.DataTable.Rows.Clear();
publicUltraGridDataCJBase122.DataTable.Rows.Clear();
publicUltraGridDataCJBase132.DataTable.Rows.Clear();
publicUltraGridDataCJBase142.DataTable.Rows.Clear();
publicUltraGridDataCJBase152.DataTable.Rows.Clear();
publicUltraGridDataCJBase162.DataTable.Rows.Clear();
publicUltraGridDataCJBase12.DataTable.Rows.Clear();
publicUltraGridDataCJBase22.DataTable.Rows.Clear();
publicUltraGridDataCJBase32.DataTable.Rows.Clear();
publicUltraGridDataCJBase42.DataTable.Rows.Clear();
publicUltraGridDataCJBase52.DataTable.Rows.Clear();
publicUltraGridDataCJBase62.DataTable.Rows.Clear();
splitContainer7.Panel1Collapsed = true;
splitContainer8.Panel1Collapsed = true;
splitContainer9.Panel1Collapsed = true;
splitContainer16.Panel1Collapsed = true;
splitContainer17.Panel1Collapsed = true;
splitContainer18.Panel1Collapsed = true;
splitContainer22.Panel1Collapsed = true;
splitContainer23.Panel1Collapsed = true;
splitContainer24.Panel1Collapsed = true;
}
else if (ultraTabControl == ultraTabControl4)
{
publicUltraGridDataCJBase13_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase14_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase15_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase13_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase14_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase15_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase113.DataTable.Rows.Clear();
publicUltraGridDataCJBase123.DataTable.Rows.Clear();
publicUltraGridDataCJBase133.DataTable.Rows.Clear();
publicUltraGridDataCJBase143.DataTable.Rows.Clear();
publicUltraGridDataCJBase153.DataTable.Rows.Clear();
publicUltraGridDataCJBase163.DataTable.Rows.Clear();
publicUltraGridDataCJBase13.DataTable.Rows.Clear();
publicUltraGridDataCJBase23.DataTable.Rows.Clear();
publicUltraGridDataCJBase33.DataTable.Rows.Clear();
publicUltraGridDataCJBase43.DataTable.Rows.Clear();
publicUltraGridDataCJBase53.DataTable.Rows.Clear();
publicUltraGridDataCJBase63.DataTable.Rows.Clear();
splitContainer13.Panel1Collapsed = true;
splitContainer14.Panel1Collapsed = true;
splitContainer15.Panel1Collapsed = true;
splitContainer25.Panel1Collapsed = true;
splitContainer26.Panel1Collapsed = true;
splitContainer27.Panel1Collapsed = true;
splitContainer28.Panel1Collapsed = true;
splitContainer29.Panel1Collapsed = true;
splitContainer30.Panel1Collapsed = true;
}
else if (ultraTabControl == ultraTabControl5)
{
publicUltraGridDataCJBase19_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase20_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase21_1.DataTable.Rows.Clear();
publicUltraGridDataCJBase19_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase20_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase21_2.DataTable.Rows.Clear();
publicUltraGridDataCJBase114.DataTable.Rows.Clear();
publicUltraGridDataCJBase124.DataTable.Rows.Clear();
publicUltraGridDataCJBase134.DataTable.Rows.Clear();
publicUltraGridDataCJBase144.DataTable.Rows.Clear();
publicUltraGridDataCJBase154.DataTable.Rows.Clear();
publicUltraGridDataCJBase164.DataTable.Rows.Clear();
publicUltraGridDataCJBase14.DataTable.Rows.Clear();
publicUltraGridDataCJBase24.DataTable.Rows.Clear();
publicUltraGridDataCJBase34.DataTable.Rows.Clear();
publicUltraGridDataCJBase44.DataTable.Rows.Clear();
publicUltraGridDataCJBase54.DataTable.Rows.Clear();
publicUltraGridDataCJBase64.DataTable.Rows.Clear();
splitContainer19.Panel1Collapsed = true;
splitContainer20.Panel1Collapsed = true;
splitContainer21.Panel1Collapsed = true;
splitContainer31.Panel1Collapsed = true;
splitContainer32.Panel1Collapsed = true;
splitContainer33.Panel1Collapsed = true;
splitContainer34.Panel1Collapsed = true;
splitContainer35.Panel1Collapsed = true;
splitContainer36.Panel1Collapsed = true;
}
}
#endregion
#region 录入区域
//查询检验委托基本信息
///
/// 查询检验委托基本信息
///
///
///
private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
{
try
{
//各试验室各检验项目设置权限
publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("outdec.PublicOutdecBase", outdecQueryBase1.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 QueryCheckConsignBaseDetail_DistinctFS(PublicUltraGridBase publicUltraGridBase, string strFlag)
{
try
{
//各试验室各检验项目设置权限
publicUltraGridBase.QueryCheckConsignBaseDetail_DistinctFS("outdec.PublicOutdecBase", outdecQueryBase1.GetQueryInfo(strFlag), this.ob, arrId,plineCodes, strFlag);
if (publicUltraGridBase.Ug.Rows.Count == 0)
{
if (publicUltraGridBase == publicUltraGridBase1)
{
ClearPhyDetailItems(ultraTabControl2);
}
else if (publicUltraGridBase == publicUltraGridBase2)
{
ClearPhyDetailItems(ultraTabControl3);
}
else if (publicUltraGridBase == publicUltraGridBase3)
{
ClearPhyDetailItems(ultraTabControl4);
}
else if (publicUltraGridBase == publicUltraGridBase4)
{
ClearPhyDetailItems(ultraTabControl5);
}
}
}
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
{
outdecShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);
//赋值给全局变量
UltraGridRow ur = publicUltraGridBase1.Ur;
ArrayList arrayList = new ArrayList();
arrayList.Add("2");
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
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.outdec.FrmOutdecDataCJBase.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.outdec.FrmOutdecDataCJBase.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();
ArrayList list = new ArrayList();
list.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
list.Add(ur.Cells["CHECK_NO"].Text.Trim());
list.Add(ur.Cells["DEPT_ID"].Text.Trim());
//list.Add("002001007013"); //
//publicUltraGridDetail1.QueryCheckConsignDetailFilePath("outdec.PublicOutdecBase", list, this.ob);
}
}
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.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
//未录入赋值
///
/// 未录入赋值
///
private void AddPhyDetailItems()
{
if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
if (ultraTabControl2.SelectedTab.Index == 0)//HIC R0007/
{
publicUltraGridDataCJBase1_2.QueryCheckConsignPhyDetailHIC(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0007'"));//HIC
publicUltraGridDataCJBase1_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase1_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0007'"), splitContainer1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0007'"));
}
else if (ultraTabControl2.SelectedTab.Index == 1)//SOHIC试验 R0043
{
publicUltraGridDataCJBase2_2.QueryCheckConsignPhyDetailHIC(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0043'"));//SOHIC试验
publicUltraGridDataCJBase2_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase2_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0043'"), splitContainer2, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0043'"));
}
else if (ultraTabControl2.SelectedTab.Index == 2)//SSC-A试验
{
publicUltraGridDataCJBase3_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MAX = 'C0030'"));//SSC-A试验
publicUltraGridDataCJBase3_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase3_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MAX = 'C0030'"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MAX = 'C0030'"));
}
else if (ultraTabControl2.SelectedTab.Index == 3)//SSC-B试验
{
publicUltraGridDataCJBase11.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MAX = 'C0031'"));//SSC-B试验
publicUltraGridDataCJBase11.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase111, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MAX = 'C0031'"), splitContainer4, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MAX = 'C0031'"));
}
else if (ultraTabControl2.SelectedTab.Index == 4)//SSC-C试验
{
publicUltraGridDataCJBase21.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MAX = 'C0032'"));//SSC-C试验
publicUltraGridDataCJBase21.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase121, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MAX = 'C0032'"), splitContainer5, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MAX = 'C0032'"));
}
else if (ultraTabControl2.SelectedTab.Index == 5)//SSC-D试验
{
publicUltraGridDataCJBase31.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MAX = 'C0033'"));
publicUltraGridDataCJBase31.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase131, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MAX = 'C0033'"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MAX = 'C0033'"));
}
else if (ultraTabControl2.SelectedTab.Index == 6)//盐雾试验
{
publicUltraGridDataCJBase41.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0056'"));
publicUltraGridDataCJBase41.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase141, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0056'"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0056'"));
}
else if (ultraTabControl2.SelectedTab.Index == 7)//点蚀试验
{
publicUltraGridDataCJBase51.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0061'"));
publicUltraGridDataCJBase51.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase151, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0061'"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0061'"));
}
else if (ultraTabControl2.SelectedTab.Index == 8)//其它
{
publicUltraGridDataCJBase61.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"));
publicUltraGridDataCJBase61.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase161, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"));
}
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.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);
alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
alDetailParams.Add(publicDataCJBase1.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrName);//录入人
alDetailParams.Add(publicDataCJBase1.StrTime == "" ? strTime : publicDataCJBase1.StrTime);//录入时间
//alDetailParams.Add(publicDataCJBase1.StrAuditName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrAuditName);//审核人
//alDetailParams.Add(publicDataCJBase1.StrAuditTime == "" ? strTime : publicDataCJBase1.StrAuditTime);//审核时间
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["AVERAGE"].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.outdec.FrmOutdecDataCJBase.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 });
publicDataCJBase1.StrRemark = "";
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.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
void pipeUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
{
try
{
outdecShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);
//赋值给全局变量
UltraGridRow ur = publicUltraGridBase2.Ur;
ArrayList arrayList = new ArrayList();
arrayList.Add("345");
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
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.outdec.FrmOutdecDataCJBase.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.outdec.FrmOutdecDataCJBase.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();
publicDataCJBase2.ClearAll();
if (CHECK_NO != "")
{ publicDataCJBase2.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
ArrayList list = new ArrayList();
list.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
list.Add(ur.Cells["CHECK_NO"].Text.Trim());
list.Add(ur.Cells["DEPT_ID"].Text.Trim());
//list.Add("002001007013"); //
//publicUltraGridDetail2.QueryCheckConsignDetailFilePath("outdec.PublicOutdecBase", list, this.ob);
}
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
}
}
//已录入赋值
///
/// 已录入赋值
///
private void AddPhyDetailItems_Log()
{
if (m_dtPhyMaxAdd == null || m_dtPhyMaxAdd.Rows.Count == 0) return;
if (ultraTabControl3.SelectedTab.Index == 0)//HIC试验
{
publicUltraGridDataCJBase7_2.QueryCheckConsignPhyDetailHIC(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0007'"));//HIC试验
publicUltraGridDataCJBase7_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase7_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0007'"), splitContainer7, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0007'"));
}
else if (ultraTabControl3.SelectedTab.Index == 1)//SOHIC试验
{
publicUltraGridDataCJBase8_2.QueryCheckConsignPhyDetailHIC(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0043'"));//SOHIC试验
publicUltraGridDataCJBase8_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase8_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0043'"), splitContainer8, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0043'"));
}
else if (ultraTabControl3.SelectedTab.Index == 2)
{
publicUltraGridDataCJBase9_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MAX = 'C0030'"));//SSC-A试验
publicUltraGridDataCJBase9_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase9_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MAX = 'C0030'"), splitContainer9, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MAX = 'C0030'"));
}
else if (ultraTabControl3.SelectedTab.Index == 3)//SSC-B试验
{
publicUltraGridDataCJBase12.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MAX = 'C0031'"));//SSC-B试验
publicUltraGridDataCJBase12.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase112, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MAX = 'C0031'"), splitContainer16, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MAX = 'C0031'"));
}
else if (ultraTabControl3.SelectedTab.Index == 4)//SSC-C试验
{
publicUltraGridDataCJBase22.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MAX = 'C0032'"));//SSC-C试验
publicUltraGridDataCJBase22.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase122, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MAX = 'C0032'"), splitContainer17, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MAX = 'C0032'"));
}
else if (ultraTabControl3.SelectedTab.Index == 5)//SSC-D试验
{
publicUltraGridDataCJBase32.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MAX = 'C0033'"));
publicUltraGridDataCJBase32.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase132, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MAX = 'C0033'"), splitContainer18, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MAX = 'C0033'"));
}
else if (ultraTabControl3.SelectedTab.Index == 6)//盐雾试验
{
publicUltraGridDataCJBase42.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0056'"));
publicUltraGridDataCJBase42.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase142, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0056'"), splitContainer22, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0056'"));
}
else if (ultraTabControl3.SelectedTab.Index == 7)//点蚀试验
{
publicUltraGridDataCJBase52.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0061'"));
publicUltraGridDataCJBase52.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase152, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0061'"), splitContainer23, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0061'"));
}
else if (ultraTabControl3.SelectedTab.Index == 8)//其它
{
publicUltraGridDataCJBase62.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"));
publicUltraGridDataCJBase62.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase162, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"), splitContainer24, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"));
}
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["AVERAGE"].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.outdec.FrmOutdecDataCJBase.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);
}
}
///
/// 将 试验条件 转ArrayList
///
///
///
//private ArrayList getCheckConsignDetailArrayList(PublicUltraGridDetail publicUltraGridDetail)
//{
// ArrayList alAll = new ArrayList();
// ArrayList list = new ArrayList();
// foreach (DataRow dr in publicUltraGridDetail.DataTable.Rows)
// {
// list = new ArrayList();
// // "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3", "NOTE", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT"
// //
// list.Add(dr["TECHNICAL_STANDARD"].ToString()); //技术标准
// list.Add(dr["DEGREASING_METHOD"].ToString()); //试样脱脂方法
// list.Add(dr["NACE_PH"].ToString()); //通入H2S前NACE-A溶液pH值
// list.Add(dr["NACE_PH_S"].ToString()); //试验开始NACE-A溶液pH值
// list.Add(dr["NACE_PH_F"].ToString()); //试验结束NACE-A溶液pH值
// list.Add(dr["NACE_SOLUTION_S"].ToString()); //试验开始NACE-A溶液H2S浓度
// list.Add(dr["NACE_SOLUTION_F"].ToString()); //试验结束NACE-A溶液H2S浓度
// list.Add(dr["TEST_TEMP"].ToString()); //试验温度
// list.Add(dr["SPECIMEN_SIZE1"].ToString()); //试样尺寸1
// list.Add(dr["SPECIMEN_SIZE2"].ToString()); //试样尺寸2
// list.Add(dr["SPECIMEN_SIZE3"].ToString()); //试样尺寸3
// list.Add(dr["TEST_DURATION1"].ToString()); //试验持续时间1
// list.Add(dr["TEST_DURATION2"].ToString()); //试验持续时间2
// list.Add(dr["TEST_DURATION3"].ToString()); //试验持续时间3
// list.Add(dr["PSEUDO_STRESS"].ToString()); //假定应力
// list.Add(dr["PROOF_RING_NO1"].ToString()); //应力环号1
// list.Add(dr["PROOF_RING_NO2"].ToString()); //应力环号2
// list.Add(dr["PROOF_RING_NO3"].ToString()); //应力环号3
// list.Add(dr["YSMIN1"].ToString()); //名义最小屈服强度1
// list.Add(dr["YSMIN2"].ToString()); //名义最小屈服强度2
// list.Add(dr["YSMIN3"].ToString()); //名义最小屈服强度3
// list.Add(dr["ACTUAL_LOAD1"].ToString()); //实际加载挠度1
// list.Add(dr["ACTUAL_LOAD2"].ToString()); //实际加载挠度2
// list.Add(dr["ACTUAL_LOAD3"].ToString()); //实际加载挠度3
// list.Add(dr["ACTUAL_S_YSMIN1"].ToString()); //实际载荷比率1
// list.Add(dr["ACTUAL_S_YSMIN2"].ToString()); //实际载荷比率2
// list.Add(dr["ACTUAL_S_YSMIN3"].ToString()); //实际载荷比率3
// list.Add(dr["ARM_DISPLACEMENT1"].ToString()); //悬壁位移1
// list.Add(dr["ARM_DISPLACEMENT2"].ToString()); //悬壁位移2
// list.Add(dr["ARM_DISPLACEMENT3"].ToString()); //悬壁位移3
// list.Add(dr["CRACK_LENGTH1"].ToString()); //裂纹长度1
// list.Add(dr["CRACK_LENGTH2"].ToString()); //裂纹长度2
// list.Add(dr["CRACK_LENGTH3"].ToString()); //裂纹长度3
// list.Add(dr["NOTE"].ToString()); //备注
// list.Add(dr["STEP"].ToString()); //步骤
// list.Add(dr["LOAD"].ToString()); //载荷(kips)
// list.Add(dr["PRESSURE_MEDIUM"].ToString()); //压力介质
// list.Add(dr["INTERNAL_PRESSURE"].ToString()); //内压力(MPa)
// list.Add(dr["DOGLEG_DEGREE"].ToString()); //狗腿度(°/100ft)
// list.Add(dr["HOLD_TIME"].ToString()); //保持时间(min)
// list.Add(dr["PIN"].ToString()); //外螺纹端
// list.Add(dr["BOX"].ToString()); //内螺纹端
// list.Add(dr["COMPOUND_TYPE"].ToString()); //螺纹脂类型
// list.Add(dr["COMPOUND_WEIGHT"].ToString()); //螺纹脂用量（g）
// list.Add(dr["MAKE_UP_TORQUE"].ToString()); //上扣要求（ft-lb)
// list.Add(dr["TOTAL_TORQUE"].ToString()); //上扣扭矩
// list.Add(dr["BREAK_OUT_TORQUE"].ToString()); //卸扣扭矩（ft-lb)
// list.Add(dr["OBSERVED_RESULT"].ToString()); //螺纹检查
// list.Add(dr["CHECK_NO"].ToString()); //检验编号
// list.Add(dr["SAMPLE_NO"].ToString()); //试样号
// list.Add(dr["PHY_CODE_MAX"].ToString()); //检验项目大类代码PHY_CODE
// alAll.Add(list);
// }
// return alAll;
//}
//删除检验委托过程结果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("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["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("1");
//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.outdec.FrmOutdecDataCJBase.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
// {
// ClearPhyDetailItems(ultraGrid == ultraGrid1 ? ultraTabControl4 : ultraTabControl5);//20160523
// if (ultraGrid == ultraGrid1)
// {
// dataTable2.Rows.Clear();
// dataTable1.Rows.Clear();
// }
// else
// {
// dataTable4.Rows.Clear();
// dataTable3.Rows.Clear();
// }
// //各试验室各检验项目设置权限
// DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckConsignBase_Distinct",
// arrId == null ? new Object[] { outdecQueryBase1.GetQueryInfo(strFlag) } : new Object[] { outdecQueryBase1.GetQueryInfo(strFlag), arrId }, 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.outdec.PublicOutdecBase.QueryCheckConsignBaseDetail_Distinct",
//arrId == null ? new Object[] { outdecQueryBase1.GetQueryInfo(strFlag) } : new Object[] { outdecQueryBase1.GetQueryInfo(strFlag), arrId }, 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.HasParent())
// {
// outdecShowBase3.ShowBaseInfo(ultraGrid1.ActiveRow.ParentRow);
// //赋值给全局变量
// UltraGridRow ur = ultraGrid1.ActiveRow;
// ArrayList arrayList = new ArrayList();
// arrayList.Add("3");
// arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
// 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.outdec.FrmOutdecDataCJBase.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.outdec.FrmOutdecDataCJBase.QueryCheckMethodResult",
// 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.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
// ArrayList list = new ArrayList();
// list.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
// list.Add(ur.Cells["CHECK_NO"].Text.Trim());
// list.Add(ur.Cells["DEPT_ID"].Text.Trim());
// //list.Add("002001007013"); //
// //publicUltraGridDetail3.QueryCheckConsignDetailFilePath("outdec.PublicOutdecBase", list, this.ob);
// }
// }
// else
// {
// ultraGrid1.ActiveRow.Expanded = true;
// //ultraGrid1.ActiveRow.ChildBands[0].Rows[0].Activated = true;
// }
// }
// catch (Exception ex)
// {
// MessageUtil.ShowWarning(ex.Message);
// }
//}
private void pipeUltraGridBase3_PublicUltraGridBaseActive(object sender, EventArgs e)
{
try
{
//if (ultraGrid1.ActiveRow.HasParent())
//{
outdecShowBase3.ShowBaseInfo(publicUltraGridBase3.Ug.ActiveRow);
//赋值给全局变量
UltraGridRow ur = publicUltraGridBase3.Ug.ActiveRow;
ArrayList arrayList = new ArrayList();
arrayList.Add("3");
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
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.QueryCheckMethodResult",
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.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
ArrayList list = new ArrayList();
list.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
list.Add(ur.Cells["CHECK_NO"].Text.Trim());
list.Add(ur.Cells["DEPT_ID"].Text.Trim());
//list.Add("002001007013"); //
//publicUltraGridDetail3.QueryCheckConsignDetailFilePath("outdec.PublicOutdecBase", list, this.ob);
}
//}
//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;
if (ultraTabControl4.SelectedTab.Index == 0)//HIC试验
{
publicUltraGridDataCJBase13_2.QueryCheckConsignPhyDetailHIC(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0007'"));//HIC试验
//publicUltraGridDataCJBase13_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase13_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0007'"), splitContainer13, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0007'"));
}
else if (ultraTabControl4.SelectedTab.Index == 1)//SOHIC试验
{
publicUltraGridDataCJBase14_2.QueryCheckConsignPhyDetailHIC(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0043'"));//SSOHIC试验
//publicUltraGridDataCJBase14_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase14_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0043'"), splitContainer14, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0043'"));
}
else if (ultraTabControl4.SelectedTab.Index == 2)//SSC-A试验
{
publicUltraGridDataCJBase15_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MAX = 'C0030'"));//SSC-A试验
//publicUltraGridDataCJBase15_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase15_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MAX = 'C0030'"), splitContainer15, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MAX = 'C0030'"));
}
else if (ultraTabControl4.SelectedTab.Index == 3)//SSC-B试验
{
publicUltraGridDataCJBase13.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MAX = 'C0031'"));//SSC-B试验
//publicUltraGridDataCJBase13.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase113, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MAX = 'C0031'"), splitContainer25, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MAX = 'C0031'"));
}
else if (ultraTabControl4.SelectedTab.Index == 4)//SSC-C试验
{
publicUltraGridDataCJBase23.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MAX = 'C0032'"));//SSC-C试验
//publicUltraGridDataCJBase23.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase123, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MAX = 'C0032'"), splitContainer26, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MAX = 'C0032'"));
}
else if (ultraTabControl4.SelectedTab.Index == 5)//SSC-D试验
{
publicUltraGridDataCJBase33.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MAX = 'C0033'"));
//publicUltraGridDataCJBase33.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase133, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MAX = 'C0033'"), splitContainer27, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MAX = 'C0033'"));
}
else if (ultraTabControl4.SelectedTab.Index == 6)//盐雾试验
{
publicUltraGridDataCJBase43.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0056'"));
//publicUltraGridDataCJBase43.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase143, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0056'"), splitContainer28, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0056'"));
}
else if (ultraTabControl4.SelectedTab.Index == 7)//点蚀试验
{
publicUltraGridDataCJBase53.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0061'"));
//publicUltraGridDataCJBase53.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase153, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0061'"), splitContainer29, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0061'"));
}
else if (ultraTabControl4.SelectedTab.Index == 8)//其它
{
publicUltraGridDataCJBase63.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"));
//publicUltraGridDataCJBase63.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase163, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"), splitContainer30, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"));
}
//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.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
///
/// 审核
///
private void AuditCheckConsignDetail()
{
try
{
if (ultraTabControl1.SelectedTab.Index != 2)
{
MessageUtil.ShowWarning("只有在未审核数据页才能进行审核操作！");
return;
}
if (publicUltraGridBase3.Ug.ActiveRow == null || publicUltraGridBase3.Ug.ActiveRow.Activated == false)
{
MessageUtil.ShowWarning("请选择需要审核的检验信息！");
return;
}
publicUltraGridBase3.Ug.UpdateData();
UltraGridRow arrBase = publicUltraGridBase3.Ug.ActiveRow;
if (MessageUtil.ShowYesNoAndQuestion("是否确认审核？") == DialogResult.Yes)
{
ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
string user = UserInfo.GetUserName();
string strDate = DateTime.Now.ToString();
//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(arrBase.Cells["SAMPLE_NO"].Value.ToString());
alBaseParams.Add(arrBase.Cells["CHECK_NO"].Value.ToString());
alBase.Add(alBaseParams);
//}
PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AuditCheckConsignDetail",
new Object[] { alBase }, this.ob);
//QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase3, "3");
MessageUtil.ShowTips("审核成功！");
}
}
catch (Exception e)
{
MessageUtil.ShowWarning(e.Message);
}
}
///
/// 单项审核
///
///
private void SingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
{
try
{
if (ultraTabControl1.SelectedTab.Index != 2)
{
MessageUtil.ShowWarning("只有在未审核数据页才能进行单项审核操作！");
return;
}
if (publicUltraGridBase3.Ug.ActiveRow == null || publicUltraGridBase3.Ug.ActiveRow.Activated == false)
{
MessageUtil.ShowWarning("请选择需要单项审核的检验信息！");
return;
}
publicUltraGridBase3.Ug.UpdateData();
UltraGridRow arrBase = publicUltraGridBase3.Ug.ActiveRow;
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() + " ";
}
}
//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(arrBase.Cells["SAMPLE_NO"].Value.ToString());
alBaseParams.Add(arrBase.Cells["CHECK_NO"].Value.ToString());
alBase.Add(alBaseParams);
}
//}
PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AuditCheckConsignDetail",
new Object[] { alBase }, this.ob);
QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase3, "3");
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())
// {
// outdecShowBase4.ShowBaseInfo(ultraGrid2.ActiveRow.ParentRow);
// //赋值给全局变量
// UltraGridRow ur = ultraGrid2.ActiveRow;
// ArrayList arrayList = new ArrayList();
// arrayList.Add("4");
// arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
// 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.outdec.FrmOutdecDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
// if (dt == null || dt.Rows.Count == 0)
// {
// m_dtPhyMaxAuditAdd = null;
// m_dtPhyItemsAuditAdd = null;
// return;
// }
// m_dtPhyMaxAuditAdd = dt.Copy();
// //QueryCheckMethodPhyConfigItems20160523
// DataTable dtItems = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckMethodResult",
// 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.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
// ArrayList list = new ArrayList();
// list.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
// list.Add(ur.Cells["CHECK_NO"].Text.Trim());
// list.Add(ur.Cells["DEPT_ID"].Text.Trim());
// //list.Add("002001007013"); //
// // publicUltraGridDetail1.QueryCheckConsignDetailFilePath("outdec.PublicOutdecBase", list, this.ob);
// }
// }
// else
// {
// ultraGrid2.ActiveRow.Expanded = true;
// //ultraGrid2.ActiveRow.ChildBands[0].Rows[0].Activated = true;
// }
// }
// catch (Exception ex)
// {
// MessageUtil.ShowWarning(ex.Message);
// }
//}
private void pipeUltraGridBase4_PublicUltraGridBaseActive(object sender, EventArgs e)
{
try
{
outdecShowBase4.ShowBaseInfo(publicUltraGridBase4.Ug.ActiveRow);
//赋值给全局变量
UltraGridRow ur = publicUltraGridBase4.Ug.ActiveRow;
ArrayList arrayList = new ArrayList();
arrayList.Add("45");
arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
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();
//QueryCheckMethodPhyConfigItems20160523
DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodResult",
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.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
ArrayList list = new ArrayList();
list.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
list.Add(ur.Cells["CHECK_NO"].Text.Trim());
list.Add(ur.Cells["DEPT_ID"].Text.Trim());
//list.Add("002001007013"); //
// publicUltraGridDetail1.QueryCheckConsignDetailFilePath("outdec.PublicOutdecBase", list, this.ob);
}
}
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)//HIC试验
{
publicUltraGridDataCJBase19_2.QueryCheckConsignPhyDetailHIC(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0007'"));//HIC试验
//publicUltraGridDataCJBase19_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase19_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0007'"), splitContainer19, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0007'"));
}
else if (ultraTabControl5.SelectedTab.Index == 1)//SOHIC试验
{
publicUltraGridDataCJBase20_2.QueryCheckConsignPhyDetailHIC(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0043'"));//SOHIC试验
//publicUltraGridDataCJBase20_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase20_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0043'"), splitContainer20, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0043'"));
}
else if (ultraTabControl5.SelectedTab.Index == 2)//SSC-A试验
{
publicUltraGridDataCJBase21_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MAX = 'C0030'"));//SSC-A试验
//publicUltraGridDataCJBase21_2.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase21_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MAX = 'C0030'"), splitContainer21, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MAX = 'C0030'"));
}
else if (ultraTabControl5.SelectedTab.Index == 3)//SSC-B试验
{
publicUltraGridDataCJBase14.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MAX = 'C0031'"));//SSC-B试验
//publicUltraGridDataCJBase14.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase114, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MAX = 'C0031'"), splitContainer31, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MAX = 'C0031'"));
}
else if (ultraTabControl5.SelectedTab.Index == 4)//SSC-C试验
{
publicUltraGridDataCJBase24.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MAX = 'C0032'"));//SSC-C试验
//publicUltraGridDataCJBase24.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase124, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MAX = 'C0032'"), splitContainer32, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MAX = 'C0032'"));
}
else if (ultraTabControl5.SelectedTab.Index == 5)//SSC-D试验
{
publicUltraGridDataCJBase34.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MAX = 'C0033'"));
//publicUltraGridDataCJBase34.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase134, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MAX = 'C0033'"), splitContainer33, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MAX = 'C0033'"));
}
else if (ultraTabControl5.SelectedTab.Index == 6)//盐雾试验
{
publicUltraGridDataCJBase44.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0056'"));
//publicUltraGridDataCJBase44.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase144, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0056'"), splitContainer34, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0056'"));
}
else if (ultraTabControl5.SelectedTab.Index == 7)//点蚀试验
{
publicUltraGridDataCJBase54.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0061'"));
//publicUltraGridDataCJBase54.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase154, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0061'"), splitContainer35, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0061'"));
}
else if (ultraTabControl5.SelectedTab.Index == 8)//其它
{
publicUltraGridDataCJBase64.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"));
//publicUltraGridDataCJBase64.DataTable.AcceptChanges();
QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase164, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"), splitContainer36, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN NOT IN ('R0007', 'R0008','R0043','R0056','R0061')"));
}
}
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.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
}
///
/// 取消审核
///
private void CancelAuditCheckConsignDetail()
{
try
{
if (ultraTabControl1.SelectedTab.Index != 3)
{
MessageUtil.ShowWarning("只有在已审核数据页才能进行取消审核操作！");
return;
}
if (publicUltraGridBase4.Ug.ActiveRow == null || publicUltraGridBase4.Ug.ActiveRow.Activated == false)
{
MessageUtil.ShowWarning("请选择需要取消审核的检验信息！");
return;
}
publicUltraGridBase4.Ug.UpdateData();
//DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
UltraGridRow arrBase = publicUltraGridBase4.Ug.ActiveRow;
DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryDetailFlag", new object[] { arrBase.Cells["CHECK_NO"].Value.ToString(), arrBase.Cells["SAMPLE_NO"].Value.ToString(), "" }, ob);
if (int.Parse(ds.Rows[0][0].ToString()) == 5)
{
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)
//{
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(arrBase.Cells["SAMPLE_NO"].Value.ToString());
alBaseParams.Add(arrBase.Cells["CHECK_NO"].Value.ToString());
if (strCHECK_NO == "")
{
strCHECK_NO = arrBase.Cells["CHECK_NO"].Value.ToString();
}
alBase.Add(alBaseParams);
//}
PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AuditCheckConsignDetail",
new Object[] { alBase }, this.ob);
QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase4, "456");
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase4.Ug, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase3.Ug, 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 (publicUltraGridBase4.Ug.ActiveRow == null || publicUltraGridBase4.Ug.ActiveRow.Activated == false)
{
MessageUtil.ShowWarning("请选择需要取消单项审核的检验信息！");
return;
}
publicUltraGridBase4.Ug.UpdateData();
UltraGridRow arrBase = publicUltraGridBase4.Ug.ActiveRow;
//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(' '))
{
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(arrBase.Cells["SAMPLE_NO"].Value.ToString());
alBaseParams.Add(arrBase.Cells["CHECK_NO"].Value.ToString());
if (strCHECK_NO == "")
{
strCHECK_NO = arrBase.Cells["CHECK_NO"].Value.ToString();
}
alBase.Add(alBaseParams);
}
//}
PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AuditCheckConsignDetail",
new Object[] { alBase }, this.ob);
QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase4, "4");
// QueryCheckConsignBaseDetail_DistinctFS(publicUltraGridBase3.Ug, "3");
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase4.Ug, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase3.Ug, 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 FrmOutdecLabCorDataCJAudit_Shown(object sender, EventArgs e)
{
if (toolMenu == null) return;
if (ultraTabControl1.SelectedTab.Index == 0)
{
if (toolMenu.Toolbars[0].Tools.Exists("Add"))
{
toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
{
toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("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("Add"))
{
toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
{
toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("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("Add"))
{
toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
{
toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("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("Add"))
{
toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
{
toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("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;
}
}
}
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("Add"))
{
toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
{
toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("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("Add"))
{
toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
{
toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
}
if (toolMenu.Toolbars[0].Tools.Exists("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("Add"))
{
toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
{
toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("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("Add"))
{
toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Update"))
{
this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
{
toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
}
if (toolMenu.Toolbars[0].Tools.Exists("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;
}
}
}
}
}