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 Core.Mes.Client.Comm.Tool; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Control; using Infragistics.Win; using System.Collections; using Core.Mes.Client.Comm.Server; namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec { public partial class FrmLabSampleConfirm : FrmBase { private string[] arrId;//数据权限 private string[] plineCodes = { }; private DataTable _dtPline = null; public FrmLabSampleConfirm() { InitializeComponent(); } protected override void OnLoad(EventArgs e) { base.OnLoad(e); //publicUltraGridDetail1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框 //publicUltraGridDetail2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; } private void FrmLabSampleConfirm_Load(object sender, EventArgs e) { arrId = this.ValidDataPurviewIds;//获取数据权限 plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob); //pipeQueryBase1.ShowControl(); InitColumns(); } private void InitColumns() { //是否小样热处理 string[] arrColumns = new string[] { "CHK", "ISRCL", "ISRCL_DESC", "FLAG", "FLAG_DESC", "CHECK_NO", "SAMPLE_NO", "SAMPLE_NO_MIN", "PHY_CODE_MAX", "PHY_NAME_MAX", "ITEM_NAME_S", "INSERT_FLAG", "LAB_PRINT_COUNT", "SAMPLE_COUNT", "IS_RUSH", "ISPRODUCER", "ISPRODUCER_DESC", "CRAFT_SOURCE", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "JG_SEND_NAME", "JG_SEND_TIME", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "CRAFT_PATH", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "SPEC_REQ", "REMARK", "SAMPLE_REMARK", "AUDIT_TIME", "DEPT_ID" };//"ISPRODUCER", string[] arrCaption = new string[] { "选择", "热处理状态", "热处理状态", "状态", "状态", "检验编号", "试样号", "钢印号", "检验项代码", "检验项", "试样尺寸", "加入试验项目", "打印次数", "试样数", "是否加急", "是否监制", "是否监制", "委托类型", "通知监制", "通知监制", "送样人", "送样时间", "收样人", "收样时间", "炉号", "钢级", "钢号", "技术标准", "合同号", "工艺文件路径", "外径", "壁厚", "委托单位", "委托人", "委托时间", "特殊要求", "备注", "来样操作备注", "审核时间", "所属实验室" };//"是否监制", publicUltraGridDetail1.InitColumnsLab(arrColumns, arrCaption); publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "ISRCL", "FLAG", "FLAG_DESC", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "AUDIT_TIME", "INSERT_FLAG", "DEPT_ID" }, false);//不需要显示的行 publicUltraGridDetail1.setOtherColumnReadOnly(new string[] { "CHK" });//可编辑列 //publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No; publicUltraGridDetail2.InitColumnsLab(arrColumns, arrCaption); publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "ISRCL", "ISRCL_DESC", "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "AUDIT_TIME", "DEPT_ID" }, false); if (!arrId.Contains("002001007009")) { publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "ISRCL", "ISRCL_DESC", "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "AUDIT_TIME", "INSERT_FLAG", "DEPT_ID" }, false); } publicUltraGridDetail2.setOtherColumnReadOnly(new string[] { "CHK" }); //publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No; publicUltraGridDetail3.InitColumnsLab(arrColumns, arrCaption); publicUltraGridDetail3.setColumnShowOrHidden(new string[] { "ISRCL", "ISRCL_DESC", "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "AUDIT_TIME", "INSERT_FLAG", "DEPT_ID" }, false); publicUltraGridDetail3.setOtherColumnReadOnly(new string[] { "CHK" }); publicUltraGridDetail4.InitColumnsLab(arrColumns, arrCaption); publicUltraGridDetail4.setColumnShowOrHidden(new string[] { "ISRCL", "ISRCL_DESC", "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "INSERT_FLAG", "DEPT_ID" }, false); publicUltraGridDetail4.setOtherColumnReadOnly(new string[] { "CHK" }); pipeQueryBaseLab1.UpdateControl("加工下发时间"); pipeQueryBaseLab1.BindComboxNew(this.UserInfo.GetDeptid(), this.ob); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { //查询、确认、退出 switch (ToolbarKey) { case "Query": if (ultraTabControl1.SelectedTab.Index == 0) { QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1"); } else if (ultraTabControl1.SelectedTab.Index == 1) { QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23"); } else if (ultraTabControl1.SelectedTab.Index == 2) { QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9"); } else if (ultraTabControl1.SelectedTab.Index == 3) { QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45"); } break; case "Confirm": UpdateCheckConsignDetail(); break; case "Cancel": CancelUpdateCheckConsignDetail(); break; case "Resample": ResampleRest(); break; case "ResampleBack": ResampleRestBack(); break; case "Add": Add(); break; case "CancelAdd": CancelAdd(); break; case "Print": if (ultraTabControl1.SelectedTab.Index == 0) { RepLimsPipeLabSampleConfirm(publicUltraGridDetail1); } else if (ultraTabControl1.SelectedTab.Index == 1) { RepLimsPipeLabSampleConfirm(publicUltraGridDetail2); } else if (ultraTabControl1.SelectedTab.Index == 3) { RepLimsPipeLabSampleConfirm(publicUltraGridDetail4); } break; case "PrintHX": printHX(); break; case "Export": ExportData(); break; case "Close": if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes) { this.Close(); } break; } } /// /// 导出 /// private void ExportData() { if (this.ultraTabControl1.Tabs[0].Active) { GridHelper.ulGridToExcel(publicUltraGridDetail1.Ug, "未确认数据"); } else if (this.ultraTabControl1.Tabs[1].Active) { GridHelper.ulGridToExcel(publicUltraGridDetail2.Ug, "已确认数据"); } else if (this.ultraTabControl1.Tabs[2].Active) { GridHelper.ulGridToExcel(publicUltraGridDetail3.Ug, "重取样数据"); } else if (this.ultraTabControl1.Tabs[3].Active) { GridHelper.ulGridToExcel(publicUltraGridDetail4.Ug, "已确认完成检验项"); } } //查询检验委托基本信息 /// /// 查询检验委托基本信息 /// /// /// private void QueryCheckConsignDetailInfo(PublicUltraGridDetail publicUltraGridDetail, string strFlag) { try { if (strFlag.Equals("1")) //未确认 { ArrayList alist = new ArrayList(); alist = pipeQueryBaseLab1.GetQueryInfo(strFlag); publicUltraGridDetail.QueryCheckConsignBaseDetailReceiveTime("pipe.PublicPipeBase", alist, this.ob, arrId, plineCodes, "1", this.CustomInfo.ToString()); } else if (strFlag.Equals("23"))//已确认未完成 { if (!pipeQueryBaseLab1.chkINSERT_FLAG.Checked && pipeQueryBaseLab1.ultraINSERT_FLAG.Value == null) { pipeQueryBaseLab1.chkINSERT_FLAG.Checked = true; pipeQueryBaseLab1.ultraINSERT_FLAG.SelectedIndex = pipeQueryBaseLab1.ultraINSERT_FLAG.FindStringExact("否"); } ArrayList alist = new ArrayList(); alist = pipeQueryBaseLab1.GetQueryInfo(strFlag); publicUltraGridDetail.QueryCheckConsignBaseDetailReceiveTime("pipe.PublicPipeBase", alist, this.ob, arrId, plineCodes, "2", this.CustomInfo.ToString()); } else if (strFlag.Equals("45"))//已确认已完成 { ArrayList alist = new ArrayList(); alist = pipeQueryBaseLab1.GetQueryInfo(strFlag); publicUltraGridDetail.QueryCheckConsignBaseDetailReceiveTime("pipe.PublicPipeBase", alist, this.ob, arrId, plineCodes, "2", this.CustomInfo.ToString()); } else if (strFlag.Equals("9")) //查询重取样 { ArrayList alist = new ArrayList(); alist = pipeQueryBaseLab1.GetQueryInfo(strFlag); publicUltraGridDetail.QueryResample("pipe.PublicPipeBase", alist, this.ob, arrId, plineCodes, this.CustomInfo.ToString()); } PublicPipeAndOutdec.RefreshAndAutoSizeColumns(publicUltraGridDetail.Ug, new string[] { "PHY_NAME_MAX", "PRODUCT_STD", "SAMPLE_REMARK" }, false); //加急置顶,红色 foreach (UltraGridRow uRow in publicUltraGridDetail.Ug.Rows) { if (uRow.Cells["IS_RUSH"].Value.ToString().Equals("是")) { uRow.Cells["IS_RUSH"].Appearance.BackColor = Color.Red; } } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); } } #region 未确认 //确认来样,更新检验委托加工信息2015-08-03修改为一个检验编号确认 /// /// 确认来样 /// private void UpdateCheckConsignDetail() { try { if (publicUltraGridDetail1.Ug == null || publicUltraGridDetail1.Ug.Rows.Count == 0) { return; } if (ultraTabControl1.SelectedTab.Index != 0) { MessageUtil.ShowTips("只有选择了未确认页才能进行来样确认操作!"); return; } publicUltraGridDetail1.Ug.UpdateData(); DataRow[] arrBase = publicUltraGridDetail1.DataTable.Select("CHK = 'True' AND FLAG = '1'"); if (arrBase == null || arrBase.Length == 0) { MessageUtil.ShowTips("请勾选状态为加工已下发的检验信息!"); return; } foreach (DataRow row in arrBase) { if ("1234".Contains(row["ISRCL"].ToString())) { MessageUtil.ShowTips("选择试样包含小样热处理没有做完的试样号,实验室不能确认!"); return; } } if (MessageUtil.ShowYesNoAndQuestion("是否来样确认?") == DialogResult.Yes) { DateTime SeverTime = comm.GetSeverTime(this.ob); string Time = SeverTime.ToLongTimeString(); string strDate2 = ""; Time = Time.Replace(":", ""); string user = UserInfo.GetUserName(); string strDate = DateTime.Now.ToString(); int a= 0,b= 0; ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息 //力学、化学实验来样确认前要有当天的交接记录,设备运行记录 if ("002001007009".Equals(UserInfo.GetDeptid()) || "002001007010".Equals(UserInfo.GetDeptid())) { if (int.Parse(Time) < 70000) { strDate2 = SeverTime.AddDays(-1).ToString("yyyy-MM-dd"); } else { strDate2 = SeverTime.ToString("yyyy-MM-dd"); } DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.PublicPipeBase.doQueryClassRecord", new object[] { UserInfo.GetDeptid(), UserInfo.GetUserOrderText(), strDate2 }, ob); DataTable dd = ServerHelper.GetData("com.steering.lims.data.pipe.PublicPipeBase.doQueryRunRecord", new object[] { UserInfo.GetDeptid(), UserInfo.GetUserOrderText(), strDate2 }, ob); if (ds.Rows.Count > 0) { a = int.Parse( ds.Rows[0]["ACOUNT"].ToString()); } if (dd.Rows.Count > 0) { b = int.Parse(dd.Rows[0]["ACOUNT"].ToString()); } if (a == 0 ) { MessageUtil.ShowTips("没有今天的交接班记录,不能确认!"); return; } if ( b == 0) { MessageUtil.ShowTips("没有今天的设备使用运行记录,不能确认!"); return; } } if ("002001007010".Equals(UserInfo.GetDeptid()) || "002023003001".Equals(UserInfo.GetDeptid())) { foreach (DataRow row in arrBase) { if ("HX".Equals(row["PHY_CODE_MAX"].ToString())) { publicUltraGridDetail1.UpdateCheckConsignDetailHX("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", user, strDate, "1", ""); } else { publicUltraGridDetail1.UpdateCheckConsignDetail("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", user, strDate, "1", ""); } } } else { foreach (DataRow row in arrBase) { if("HX".Equals(row["PHY_CODE_MAX"]. ToString()) || row["PHY_CODE_MAX"].ToString() == "ONH" ) { MessageUtil.ShowTips("不是化学实验室人员请不要确认化学数据!"); return; } } if ("002023003002".Equals(UserInfo.GetDeptid())) { publicUltraGridDetail1.UpdateCheckConsignDetailTH("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", user, strDate, "1", ""); } else { publicUltraGridDetail1.UpdateCheckConsignDetail("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", user, strDate, "1", ""); } } QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1"); QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23"); QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9"); QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45"); MessageUtil.ShowTips("来样确认成功!"); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); } } #endregion #region 已确认 /// /// 取消确认 /// private void CancelUpdateCheckConsignDetail() { try { if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0) { return; } if (ultraTabControl1.SelectedTab.Index != 1) { MessageUtil.ShowTips("只有选择了已确认页才能进行取消确认操作!"); return; } publicUltraGridDetail2.Ug.UpdateData(); DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True' AND FLAG = '2'"); if (arrBase == null || arrBase.Length == 0) { MessageUtil.ShowTips("请勾选状态为试验室已确认的检验信息!"); return; } //if (MessageUtil.ShowYesNoAndQuestion("是否取消确认?") == DialogResult.Yes) //{ WinCancelSampleComfirm pc = new WinCancelSampleComfirm(); pc.ShowDialog(); if (pc.DialogResult != DialogResult.OK) { return; } string strRemark = pc.StrRemark; string user = UserInfo.GetUserName(); string strDate = DateTime.Now.ToString(); strRemark = this.Text + "取消确认由于" + strRemark + "(" + user + " " + strDate + ")"; publicUltraGridDetail2.UpdateCheckConsignDetail("pipe.FrmLabSampleConfirm", this.ob, arrBase, "1", "", "", "2", strRemark); QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23"); QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1"); QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9"); QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45"); MessageUtil.ShowTips("取消确认成功!"); //} } catch (Exception e) { MessageUtil.ShowWarning(e.Message); } } /// /// 加入试验项目(仅力学试验有要求) /// private void Add() { try { if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0) { return; } if (ultraTabControl1.SelectedTab.Index != 1) { MessageUtil.ShowTips("只有选择了已确认页才能进行操作!"); return; } publicUltraGridDetail2.Ug.UpdateData(); DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True' AND FLAG = '2'"); if (arrBase == null || arrBase.Length == 0) { MessageUtil.ShowTips("请勾选状态为试验室已确认的检验信息!"); return; } string strRemark = ""; string user = UserInfo.GetUserName(); string strDate = DateTime.Now.ToString(); if ("002023021004".Equals(UserInfo.GetDeptid())) { publicUltraGridDetail2.UpdateCheckConsignDetailLX("pipe.FrmLabSampleConfirm", this.ob, arrBase, "1", "", "", "", strRemark); } QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23"); QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1"); QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9"); QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45"); MessageUtil.ShowTips("加入试验项目成功!"); //} } catch (Exception e) { MessageUtil.ShowWarning(e.Message); } } /// /// 取消加入 /// private void CancelAdd() { try { if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0) { return; } if (ultraTabControl1.SelectedTab.Index != 1) { MessageUtil.ShowTips("只有选择了已确认页才能进行操作!"); return; } publicUltraGridDetail2.Ug.UpdateData(); DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True' AND FLAG = '2'"); if (arrBase == null || arrBase.Length == 0) { MessageUtil.ShowTips("请勾选状态为试验室已确认的检验信息!"); return; } //foreach (DataRow row in arrBase) //{ // DataTable dtFlag = PublicServer.GetData("com.steering.lims.data.pipe.FrmLabSampleConfirm.GetFlag", new object[] { row["CHECK_NO"].ToString(), row["SAMPLE_NO"].ToString(), row["PHY_CODE_MAX"].ToString() }, this.ob); // if (dtFlag.Rows.Count > 0) // { // if (!dtFlag.Rows[0]["FLAG"].ToString().Equals("2")) // { // MessageBox.Show("不是试验室确认状态,不能取消加入!"); // return; // } // } //} string strRemark = ""; string user = UserInfo.GetUserName(); string strDate = DateTime.Now.ToString(); publicUltraGridDetail2.UpdateCheckConsignDetailLX("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", "", "", "", strRemark); QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23"); QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1"); QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9"); QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45"); MessageUtil.ShowTips("取消加入成功!"); //} } catch (Exception e) { MessageUtil.ShowWarning(e.Message); } } /// /// 重取样 /// private void ResampleRest() { try { if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0) { return; } if (ultraTabControl1.SelectedTab.Index != 1) { MessageUtil.ShowTips("只有选择了已确认页才能进行取消确认操作!"); return; } publicUltraGridDetail2.Ug.UpdateData(); DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True' AND FLAG IN( '2','3')"); if (arrBase == null || arrBase.Length == 0) { MessageUtil.ShowTips("请勾选状态为试验室已确认的检验信息!"); return; } ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息 ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息 foreach (DataRow row in arrBase) { alBaseParams = new ArrayList();//增加要更新的基础标志位信息 alBaseParams.Add(row["PHY_CODE_MAX"].ToString()); alBaseParams.Add(row["SAMPLE_NO"].ToString()); alBaseParams.Add(row["CHECK_NO"].ToString()); alBase.Add(alBaseParams); } PublicServer.SetData("com.steering.lims.data.pipe.FrmLabSampleConfirm.ResampleRest", new Object[] { alBase }, ob); QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23"); QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1"); QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9"); QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45"); MessageUtil.ShowTips("重取样成功!"); //} } catch (Exception e) { MessageUtil.ShowWarning(e.Message); } } /// /// 取消重取样 /// private void ResampleRestBack() { try { if (publicUltraGridDetail3.Ug == null || publicUltraGridDetail3.Ug.Rows.Count == 0) { return; } if (ultraTabControl1.SelectedTab.Index != 2) { MessageUtil.ShowTips("只有选择了已确认页才能进行取消重取样操作!"); return; } publicUltraGridDetail3.Ug.UpdateData(); DataRow[] arrBase = publicUltraGridDetail3.DataTable.Select("CHK = 'True' "); ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息 ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息 foreach (DataRow row in arrBase) { alBaseParams = new ArrayList();//增加要更新的基础标志位信息 alBaseParams.Add(row["PHY_CODE_MAX"].ToString()); alBaseParams.Add(row["SAMPLE_NO"].ToString()); alBaseParams.Add(row["CHECK_NO"].ToString()); alBase.Add(alBaseParams); } PublicServer.SetData("com.steering.lims.data.pipe.FrmLabSampleConfirm.ResampleRestBack", new Object[] { alBase }, ob); QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23"); QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1"); QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9"); QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45"); MessageUtil.ShowTips("取消重取样成功!"); //} } catch (Exception e) { MessageUtil.ShowWarning(e.Message); } } /// /// 打印化学小标签 /// private void printHX() { try { DataRow[] arrBase = null; if (ultraTabControl1.SelectedTab.Index == 0) { publicUltraGridDetail1.Ug.UpdateData(); arrBase = publicUltraGridDetail1.DataTable.Select("CHK = 'True'"); } else if (ultraTabControl1.SelectedTab.Index == 1) { publicUltraGridDetail2.Ug.UpdateData(); arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True'"); } else if (ultraTabControl1.SelectedTab.Index == 3) { publicUltraGridDetail4.Ug.UpdateData(); arrBase = publicUltraGridDetail4.DataTable.Select("CHK = 'True'"); } this.Cursor = Cursors.WaitCursor; if (arrBase == null || arrBase.Length == 0) { MessageUtil.ShowWarning("请选择您要打印的化学小标签!"); return; } string strCHECK_NO = ""; foreach (DataRow row in arrBase) { strCHECK_NO += "'" + row["CHECK_NO"].ToString() + row["SAMPLE_NO"].ToString() + "',"; } strCHECK_NO = strCHECK_NO.Remove(0, 1); strCHECK_NO = strCHECK_NO.Remove(strCHECK_NO.Length - 2); string strurl = ""; if (UserInfo.GetDeptid().Equals("002001007010") || UserInfo.GetDeptid().Equals("002023003001")) //化学实验室 { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeTabHX.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO; } else { MessageUtil.ShowWarning("该实验室暂无小标签打印功能!"); return; } FrmRepExcel fBug = new FrmRepExcel(ob, strurl); fBug.AutoSize = true; fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.WindowState = FormWindowState.Maximized; //fBug.Text = "试验室来样确认单"; fBug.Show(); } finally { this.Cursor = Cursors.Default; } } /// /// /// /// private void RepLimsPipeLabSampleConfirm(PublicUltraGridDetail publicUltraGridDetail) { try { string a = UserInfo.GetDepartment(); string b = UserInfo.GetDeptid(); this.Cursor = Cursors.WaitCursor; publicUltraGridDetail.Ug.UpdateData(); DataRow[] arrBase = publicUltraGridDetail.DataTable.Select("CHK = 'True'"); if (arrBase == null || arrBase.Length == 0) { MessageUtil.ShowWarning("请选择您要打印的来样确认单!"); return; } string strCHECK_NO = ""; string strCHECK_NOHX = ""; ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息 ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息 foreach (DataRow row in arrBase) { strCHECK_NO += "'" + row["CHECK_NO"].ToString() + row["SAMPLE_NO"].ToString() + row["PHY_CODE_MAX"].ToString() + "',"; if (!strCHECK_NOHX.Contains(row["CHECK_NO"].ToString())) { strCHECK_NOHX += "'" + row["CHECK_NO"].ToString() + "',"; } alBaseParams = new ArrayList();//增加要更新的基础标志位信息 alBaseParams.Add(row["PHY_CODE_MAX"].ToString()); alBaseParams.Add(row["SAMPLE_NO"].ToString()); alBaseParams.Add(row["CHECK_NO"].ToString()); alBase.Add(alBaseParams); } PublicServer.SetData("com.steering.lims.data.pipe.FrmLabSampleConfirm.UpdatePipeLabPrintCount", new Object[] { alBase }, ob); strCHECK_NO = strCHECK_NO.Remove(0, 1); strCHECK_NO = strCHECK_NO.Remove(strCHECK_NO.Length - 2); strCHECK_NOHX = strCHECK_NOHX.Remove(0, 1); strCHECK_NOHX = strCHECK_NOHX.Remove(strCHECK_NOHX.Length - 2); string strurl = ""; if (UserInfo.GetDeptid().Equals("002001007010") || UserInfo.GetDeptid().Equals("002023003001")) //化学实验室 { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLabSampleConfirmHX.cpt&op=view" + "&CHECK_NO=" + strCHECK_NOHX; } else if (UserInfo.GetDeptid().Equals("002001007009") || UserInfo.GetDeptid().Equals("002023003002")) //材料力学试验室 { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLabSampleConfirmLX.cpt" + "&CHECK_NO=" + strCHECK_NOHX; } else if (UserInfo.GetDeptid().Equals("002001007013")) //腐蚀试验室 { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLabSampleConfirmFS.cpt&op=view" + "&CHECK_NO=" + strCHECK_NO; } else { strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLabSampleConfirm.cpt&op=view" + "&CHECK_NO=" + strCHECK_NO; } FrmRepExcel fBug = new FrmRepExcel(ob, strurl); fBug.AutoSize = true; fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.WindowState = FormWindowState.Maximized; fBug.Text = "试验室来样确认单"; fBug.Show(); } finally { this.Cursor = Cursors.Default; } } #endregion private void FrmLabSampleConfirm_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd")) { toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Resample")) { toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack")) { toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.False; } //if (toolMenu.Toolbars[0].Tools.Exists("Print")) //{ // toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; //} } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if (ultraTabControl1.SelectedTab.Index == 0) { pipeQueryBaseLab1.UpdateControl("加工下发时间"); if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Resample")) { toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack")) { toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("PrintHX")) { toolMenu.Toolbars[0].Tools["PrintHX"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd")) { toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.False; } } else if (ultraTabControl1.SelectedTab.Index == 1) { pipeQueryBaseLab1.UpdateControl("收样时间"); if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Resample")) { toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack")) { toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("PrintHX")) { toolMenu.Toolbars[0].Tools["PrintHX"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd")) { toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.True; } } else if (ultraTabControl1.SelectedTab.Index == 2) { pipeQueryBaseLab1.UpdateControl("收样时间"); if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Resample")) { toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack")) { toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("PrintHX")) { toolMenu.Toolbars[0].Tools["PrintHX"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd")) { toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.False; } } else if (ultraTabControl1.SelectedTab.Index == 3) { pipeQueryBaseLab1.UpdateControl("收样时间"); if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Confirm")) { toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Cancel")) { toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Resample")) { toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack")) { toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("PrintHX")) { toolMenu.Toolbars[0].Tools["PrintHX"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd")) { toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.False; } } } } }