| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471 |
- 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 Infragistics.Win.UltraWinGrid;
- using Infragistics.Win;
- using ThoughtWorks.QRCode.Codec;
- using System.Drawing.Printing;
- using System.IO;
- using System.Drawing.Imaging;
- using System.Drawing.Drawing2D;
- namespace Core.LZMes.Client.QCM
- {
- public partial class QCM0201YT : FrmBase
- {
- #region 初始化
- private String v_line_no = "";//RZ1-热轧 ZB1-中板线 HB1-厚板线 LT1-连退
- Image image2;//二维码
- private String v_BATCH_NO = "";//轧批号
- private int lennum = 0;//长度
- public QCM0201YT()
- {
- InitializeComponent();
- }
- private void QCM0201YT_Load(object sender, EventArgs e)
- {
- //获取自定义参数
- if (!this.CustomInfo.Equals(""))
- {
- v_line_no = this.CustomInfo;
- }
- this.ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_NAME_L_bj"].Header.Caption = "检验项目";
- this.ultraGrid4.DisplayLayout.Bands[0].Columns["PHY_NAME_L_bj"].Header.Caption = "检验项目";
- // dateTimePicker1.Value = DateTime.Now.Date.AddDays(-1);
- dateTimePicker2.Value = DateTime.Now.Date.AddDays(1);
- ValueList v = new ValueList();
- v.ValueListItems.Add("1", "是");
- v.ValueListItems.Add("0", "否");
- this.ultraGrid3.DisplayLayout.Bands[0].Columns["ISJUDGE"].ValueList = v.Clone();
- ValueList v1 = new ValueList();
- v1.ValueListItems.Add("0", "订单");
- v1.ValueListItems.Add("1", "人工");
- this.ultraGrid3.DisplayLayout.Bands[0].Columns["ITEM_FLAG"].ValueList = v1.Clone();
- this.ultraGrid6.DisplayLayout.Bands[0].Columns["ITEM_FLAG"].ValueList = v1.Clone();
- v1 = new ValueList();
- v1.ValueListItems.Add("0", "订单");
- v1.ValueListItems.Add("1", "人工复制");
- this.ultraGrid1.DisplayLayout.Bands[0].Columns["ITEM_FLAG"].ValueList = v1.Clone();
- this.ultraGrid4.DisplayLayout.Bands[0].Columns["ITEM_FLAG"].ValueList = v1.Clone();
- ValueList v2 = new ValueList();
- v2.ValueListItems.Add("A", "成分");
- v2.ValueListItems.Add("B", "材质");
- this.ultraGrid1.DisplayLayout.Bands[0].Columns["smp_catg"].ValueList = v2.Clone();
- this.ultraGrid4.DisplayLayout.Bands[0].Columns["smp_catg"].ValueList = v2.Clone();
- ValueList v3 = new ValueList();
- v3.ValueListItems.Add("YTSX", "优特酸洗");
- v3.ValueListItems.Add("YTZZ", "优特轧制");
- v3.ValueListItems.Add("YTPZ", "优特平整");
- v3.ValueListItems.Add("YTTH", "优特退火");
- v3.ValueListItems.Add("YTHZ", "优特横剪(开平)");
- v3.ValueListItems.Add("YTZJ", "优特纵剪(分条)");
- v3.ValueListItems.Add("YT1", "原料卷");
- this.ultraGrid1.DisplayLayout.Bands[0].Columns["PROCESS_CODE"].ValueList = v3.Clone();
- this.ultraGrid4.DisplayLayout.Bands[0].Columns["PROCESS_CODE"].ValueList = v3.Clone();
- if (!this.checkBox1.Checked)
- {
- this.textBox1.Enabled = false;
- }
- // this.DoQuery();
- }
- #endregion
- #region 功能
- public override void ToolBar_Click(object sender, string ToolbarKey)
- {
- switch (ToolbarKey)
- {
- case "Query":
- this.DoQuery();
- break;
- case "Send":
- this.DoSend();
- break;
- case "Unsend":
- this.DoUnsend();//撤销委托
- break;
- case "Add":
- this.AddBasePhy();//新增检验项
- break;
- case "AddArtificial":
- this.AddArtificial();//新增人工委托
- break;
- case "Update":
- this.DoUpdate();//修改取样材料号
- break;
- case "AddWt":
- this.DoAddWt();//新增复制单条委托
- break;
- case "DelWt":
- this.DoDelWt();//撤销复制单条委托
- break;
- case "DoDelete":
- this.DoDelete();//删除委托
- break;
- case "DoEject":
- this.DoEject();//卷板质量异常处理
- break;
- case "UpBatchNo":
- this.DoUpBatchNo();//复样 修改轧批号 (一炉5个轧批 1 2 3 4 5 取1号轧批委托 夹杂不合格 复 2 3轧批)
- break;
- case "UpRefBatchNo":
- this.DoUpRefBatchNo();//初样 修改指定的按炉引用 (一炉5个轧批 1 2 3 4 5 系统默认为 1 但是现场实际取的是3 所以要人工修改)
- break;
- case "doPrint":
- this.doPrint();//打印
- break;
- case "DoQuote":
- this.DoQuoteKY();
- break;
- }
- }
- #region 打印
- private void doPrint()
- {
- RowsCollection rowsCollection = this.ultraGrid1.Rows;
- if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
- {
- rowsCollection = this.ultraGrid1.Rows;
- }
- else if (this.ultraTabControl1.Tabs[1].Selected)
- {
- rowsCollection = this.ultraGrid4.Rows;
- }
- foreach (UltraGridRow ugr in rowsCollection)
- {
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- String specimenNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();//取样编号
- String materialNo = ugr.Cells["MATERIAL_NO"].Value.ToString();//子板号
- String batchNO = ugr.Cells["BATCH_NO"].Value.ToString();//轧批号
- String steelName = ugr.Cells["STEEL_NAME"].Value.ToString();//钢种
- String thck = ugr.Cells["THICK"].Value.ToString();//规格
- String phyNameLbj = ugr.Cells["PHY_NAME_L_bj"].Value.ToString();//项目
- String STATUS = ugr.Cells["STATUS"].Value.ToString();//发送状态
- if (STATUS.Equals("未发送"))
- {
- this.alert("当前委托还未发送!请先发送委托");
- return;
- }
- if (string.IsNullOrEmpty(specimenNo))
- {
- this.alert("未找到相应委托数据!请核实!!!");
- return;
- }
- v_BATCH_NO = materialNo;
- //二维码内容
- String qrCodeContent = materialNo;
- QRCodeEncoder qrCodeEncoder = new QRCodeEncoder();
- qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.BYTE;//二维码编码格式
- int num = qrCodeContent.Length;
- lennum = num;
- if (num <= 90)
- {
- qrCodeEncoder.QRCodeScale = 5;
- qrCodeEncoder.QRCodeVersion = 1;
- }
- else
- {
- qrCodeEncoder.QRCodeScale = 6;//二维码大小比例4
- qrCodeEncoder.QRCodeVersion = 14;//设置二维码的版本,默认7 该值影响二维码最高数据容量 7大致对应40个汉字长度,内容超出择需提升该数值
- }
- //设置错误校验级别,默认中等,二维码被遮挡住一部分实际上也是能扫出内容的,这个效验级别的意思就是
- //当遮挡部分最大占整体多少时仍然可以被扫出来,M大概在20%左右,H为30%,级别越高相应的数据容量会缩小
- qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.M;
- System.Drawing.Image image = qrCodeEncoder.Encode(qrCodeContent, Encoding.UTF8);//生成二维码图片 第一个参数打印内容
- image2 = image;
- string FilePath = @"C:\二维码";
- if (!Directory.Exists(FilePath))
- {
- Directory.CreateDirectory(FilePath);//判断是否有相应文件夹
- }
- PrintDocument printDocument = new PrintDocument();
- printDocument.PrinterSettings.PrinterName = "Deli DL-888T";//打印机名
- printDocument.PrintPage += new PrintPageEventHandler(pdt_PrintPage);//设置字体
- try
- {
- if (!printDocument.PrinterSettings.IsValid)
- {
- MessageBox.Show("打印设置无效!", "出错", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- printDocument.Print();
- }
- catch (Exception ex)
- {
- MessageBox.Show("打印过程出现异常!\n" + ex.Message, "出错", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- finally
- {
- printDocument.Dispose();
- }
- //增加打印标识
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
- ccp.MethodName = "doPrintLog";
- ccp.ServerParams = new object[] { specimenNo };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- //保存二维码
- //FilePath = @"C:\二维码\" + batchNO + "二维码.jpg";
- //System.IO.FileStream fs = new System.IO.FileStream(FilePath, System.IO.FileMode.Create, System.IO.FileAccess.Write, System.IO.FileShare.None);
- //image.Save(fs, System.Drawing.Imaging.ImageFormat.Jpeg);
- //fs.Close();
- image.Dispose();
- }
- }
- }
- void pdt_PrintPage(object sender, PrintPageEventArgs e)
- {
- Graphics grfx = e.Graphics;
- // grfx.DrawString(PRINT_SEQV, new Font("宋体", 15), Brushes.Black, 30, 70);//打印内容、字体、颜色、X、Y
- grfx.DrawString(v_BATCH_NO, new Font("宋体", 14), Brushes.Black, 68, 130);//打印内容、字体、颜色、X、Y
- grfx.DrawImage(image2, 70, 15, 120, 110);//图片、X、Y、宽、高
- }
- #endregion
- #endregion
- #region 功能方法
- #region 人工引用界面
- private void DoQuoteKY()
- {
- try
- {
- UltraGridRow row = this.ultraGrid1.ActiveRow;
- if (row == null)
- {
- this.alert("检验委托为空!请选择检验委托数据!!!");
- return;
- }
- if (!row.Cells["SMP_CATG"].Text.ToString().Equals("材质"))
- {
- this.alert("只有材质数据才可以引用!!!");
- return;
- }
- if (row.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
- {
- this.alert("夹杂不能使用当前按钮!");
- return;
- }
- String PLINE_CODE = row.Cells["PLINE_CODE"].Value.ToString();
- String txt_DESIGN_KEY = row.Cells["DESIGN_KEY"].Value.ToString();
- String txtDK = txt_DESIGN_KEY.Substring(0, 2);
- String SMP_TYPE_CODE = row.Cells["SMP_TYPE_CODE"].Value.ToString();
- int num = 0;
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- if (ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
- {
- this.alert("夹杂不能使用当前按钮!!!");
- return;
- }
- num = num + 1;
- }
- }
- if (num != 1)
- {
- this.alert("要勾选委托并且只能勾选一条引用!");
- return;
- }
-
- QCM0206 frmRbp = new QCM0206();
- frmRbp.StartPosition = FormStartPosition.CenterScreen;
- frmRbp.ob = this.ob;
- frmRbp.specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();
- frmRbp.smpNo = row.Cells["SMP_NO"].Value.ToString();
- frmRbp.batchNo = row.Cells["BATCH_NO"].Value.ToString();
- frmRbp.designKey = row.Cells["DESIGN_KEY"].Value.ToString();
- frmRbp.steelCode = row.Cells["STEEL_NAME"].Value.ToString();
- frmRbp.thick = row.Cells["THICK"].Value.ToString();
- frmRbp.ShowDialog();
- this.DoQuery();
-
- }
- catch (Exception ex)
- {
- MessageBox.Show("操作过程出现异常!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- #endregion
- #region 初样 修改取样轧批号按炉初样比如:夹杂
- private void DoUpRefBatchNo()
- {
- try
- {
- CoreClientParam ccp = new CoreClientParam();
- ArrayList smpNo = new ArrayList();//试样号
- ArrayList specimenNo = new ArrayList();//取样编号
- ArrayList batchNo = new ArrayList();//轧批号
- ArrayList heatnNo = new ArrayList();//炉号
- ArrayList materialNo = new ArrayList();//取样材料号
- ArrayList send_memo = new ArrayList();//发送备注
- ArrayList inspectionLot = new ArrayList();//检验号
- ArrayList plineCode = new ArrayList();
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- if (!ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("0") || !ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
- {
- this.alert("修改初样取样轧批号按钮是用来修改按炉取样的轧批,请谨慎操作!");
- return;
- }
- smpNo.Add(ugr.Cells["SMP_NO"].Value.ToString());
- specimenNo.Add(ugr.Cells["SPECIMEN_NO"].Value.ToString());
- batchNo.Add(ugr.Cells["BATCH_NO"].Value.ToString());
- heatnNo.Add(ugr.Cells["HEAT_NO"].Value.ToString());
- materialNo.Add(ugr.Cells["MATERIAL_NO"].Value.ToString());
- send_memo.Add(ugr.Cells["SEND_MEMO"].Value.ToString());
- inspectionLot.Add(ugr.Cells["INSPECTION_LOT"].Value.ToString());
- plineCode.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
- }
- }
- ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
- ccp.MethodName = "DoUpRefBatchNo";
- ccp.ServerParams = new object[] { smpNo, specimenNo, batchNo, heatnNo, materialNo, send_memo, inspectionLot, plineCode };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
- }
- this.DoQuery();
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错【初样修改轧批号】,请联系管理人员", "警告");
- }
- }
- #endregion
- #region 复样 修改轧批号
- private void DoUpBatchNo()
- {
- try
- {
- CoreClientParam ccp = new CoreClientParam();
- ArrayList smpNo = new ArrayList();//试样号
- ArrayList specimenNo = new ArrayList();//取样编号
- ArrayList batchNo = new ArrayList();//轧批号
- ArrayList materialNo = new ArrayList();//取样材料号
- ArrayList send_memo = new ArrayList();//发送备注
- ArrayList inspectionLot = new ArrayList();//检验号
- ArrayList plineCode = new ArrayList();
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- if ((!ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("1") && !ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("3")) || !ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
- {
- this.alert("修改复样轧批号按钮是用来修改按炉取样的轧批,请谨慎操作!");
- return;
- }
- smpNo.Add(ugr.Cells["SMP_NO"].Value.ToString());
- specimenNo.Add(ugr.Cells["SPECIMEN_NO"].Value.ToString());
- batchNo.Add(ugr.Cells["BATCH_NO"].Value.ToString());
- materialNo.Add(ugr.Cells["MATERIAL_NO"].Value.ToString());
- send_memo.Add(ugr.Cells["SEND_MEMO"].Value.ToString());
- inspectionLot.Add(ugr.Cells["INSPECTION_LOT"].Value.ToString());
- plineCode.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
- }
- }
- ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
- ccp.MethodName = "updateBatchNo";
- ccp.ServerParams = new object[] { smpNo, specimenNo, batchNo, materialNo, send_memo, inspectionLot, plineCode };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
- }
- this.DoQuery();
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错【复样修改轧批号】,请联系管理人员", "警告");
- }
- }
- #endregion
- #region 修改取样材料号
- private void DoUpdate()
- {
- try
- {
- //String plineCode = this.CustomInfo;
- CoreClientParam ccp = new CoreClientParam();
- ArrayList smpNo = new ArrayList();//试样号
- ArrayList specimenNo = new ArrayList();//取样编号
- ArrayList batchNo = new ArrayList();//轧批号
- ArrayList materialNo = new ArrayList();//取样材料号
- ArrayList send_memo = new ArrayList();//发送备注
- ArrayList inspectionLot = new ArrayList();//检验号
- ArrayList plineCode = new ArrayList();
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- smpNo.Add(ugr.Cells["SMP_NO"].Value.ToString());
- specimenNo.Add(ugr.Cells["SPECIMEN_NO"].Value.ToString());
- batchNo.Add(ugr.Cells["BATCH_NO"].Value.ToString());
- materialNo.Add(ugr.Cells["MATERIAL_NO"].Value.ToString());
- send_memo.Add(ugr.Cells["SEND_MEMO"].Value.ToString());
- inspectionLot.Add(ugr.Cells["INSPECTION_LOT"].Value.ToString());
- plineCode.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
- }
- }
- ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
- ccp.MethodName = "updateMaterialNo";
- ccp.ServerParams = new object[] { smpNo, specimenNo, batchNo, materialNo, send_memo, inspectionLot, plineCode };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错【修改取样材料号】,请联系管理人员", "警告");
- }
- }
- #endregion
- #region 新增人工委托
- private void AddArtificial()
- {
- try
- {
- QCM0205YT frmRbp = new QCM0205YT();
- frmRbp.StartPosition = FormStartPosition.CenterScreen;
- frmRbp.ob = this.ob;
- frmRbp.plineCode = "YT1";
- frmRbp.ShowDialog();
- this.DoQuery();
- }
- catch (Exception ex)
- {
- MessageBox.Show("操作过程出现异常!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- #endregion
- #region 新增检验项
- private void AddBasePhy()
- {
- try
- {
- UltraGridRow row = this.ultraGrid1.ActiveRow;
- if (row == null)
- {
- this.alert("检验委托为空!请选择检验委托数据!!!");
- return;
- }
- if (!row.Cells["SMP_CATG"].Text.ToString().Equals("材质"))
- {
- this.alert("只有材质数据才可以新增检验项!!!");
- return;
- }
- QCM0204 frmRbp = new QCM0204();
- frmRbp.StartPosition = FormStartPosition.CenterScreen;
- frmRbp.ob = this.ob;
- frmRbp.specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();
- frmRbp.smpNo = row.Cells["SMP_NO"].Value.ToString();
- frmRbp.plineCode = "YT1";
- frmRbp.ShowDialog();
- this.DoQueryPrg(row);//右下角
- }
- catch (Exception ex)
- {
- MessageBox.Show("操作过程出现异常!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- #endregion
- #region 新增复制单条委托
- private void DoAddWt()
- {
- try
- {
- int num = 0;
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- num = num + 1;
- }
- }
- if (num > 1)
- {
- this.alert("只能单条复制!为防止数据差错谢谢配合【谨慎复制】");
- return;
- }
- UltraGridRow row = this.ultraGrid1.ActiveRow;
- if (row == null)
- {
- this.alert("检验委托为空!请选择检验委托数据!!!");
- return;
- }
- String batchNo = row.Cells["BATCH_NO"].Value.ToString();//轧批号
- String designKey = row.Cells["DESIGN_KEY"].Value.ToString();//订单号
- String smpNo = row.Cells["SMP_NO"].Value.ToString();//试样号
- String specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();//取样编号
- String smpTypeName = row.Cells["SMP_TYPE_NAME"].Value.ToString();//取样类型
- if (MessageBox.Show("轧批号【" + batchNo + "】,确认复制当前委托一条?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
- if (smpTypeName.Equals("初样"))
- {
- ccp.MethodName = "DoAddWtZy";
- }
- else if (smpTypeName.Equals("复样"))
- {
- ccp.MethodName = "DoAddWtFy";
- }
- ccp.ServerParams = new object[] { batchNo, designKey, smpNo, specimenNo, this.UserInfo.GetUserName() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageBox.Show("复制委托成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
- }
- this.DoQuery();
- }
- catch (Exception ex)
- {
- MessageBox.Show("操作过程出现异常!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- #endregion
- #region 撤销复制单条委托
- private void DoDelWt()
- {
- try
- {
- int num = 0;
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- num = num + 1;
- }
- }
- if (num > 1)
- {
- this.alert("只能单条删除!为防止数据差错谢谢配合【谨慎删除】");
- return;
- }
- UltraGridRow row = this.ultraGrid1.ActiveRow;
- if (row == null)
- {
- this.alert("检验委托为空!请选择检验委托数据!!!");
- return;
- }
- String batchNo = row.Cells["BATCH_NO"].Value.ToString();//轧批号
- String designKey = row.Cells["DESIGN_KEY"].Value.ToString();//订单号
- String smpNo = row.Cells["SMP_NO"].Value.ToString();//试样号
- String specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();//取样编号
- String smpTypeName = row.Cells["SMP_TYPE_NAME"].Value.ToString();//取样类型
- String item_flag = row.Cells["ITEM_FLAG"].Value.ToString();//项目来源(0-订单,1-人工)
- if (MessageBox.Show("轧批号【" + batchNo + "】,确认撤销当前委托?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
- {
- return;
- }
- if (!item_flag.Equals("1"))
- {
- this.alert("只能撤销人工复制委托");
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
- if (smpTypeName.Equals("初样"))
- {
- ccp.MethodName = "DoDelWtZy";
- }
- else if (smpTypeName.Equals("复样"))
- {
- ccp.MethodName = "DoDelWtFy";
- }
- ccp.ServerParams = new object[] { batchNo, designKey, smpNo, specimenNo };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageBox.Show("撤销复制委托成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
- }
- this.DoQuery();
- }
- catch (Exception ex)
- {
- MessageBox.Show("操作过程出现异常!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- #endregion
- #region 删除委托
- private void DoDelete()
- {
- try
- {
- UltraGridRow row = this.ultraGrid1.ActiveRow;
- if (row == null)
- {
- this.alert("检验委托为空!请选择检验委托数据!!!");
- return;
- }
- String batchNoViw = row.Cells["BATCH_NO"].Value.ToString();//轧批号
- ArrayList batchNo = new ArrayList();//轧批号
- ArrayList designKey = new ArrayList();//订单号
- ArrayList smpNo = new ArrayList();//试样号
- ArrayList specimenNo = new ArrayList();//取样编号
- ArrayList smpTypeName = new ArrayList();//取样类型
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- batchNo.Add(ugr.Cells["BATCH_NO"].Value.ToString());//轧批号
- designKey.Add(ugr.Cells["DESIGN_KEY"].Value.ToString());//订单号
- smpNo.Add(ugr.Cells["SMP_NO"].Value.ToString());//试样号
- specimenNo.Add(ugr.Cells["SPECIMEN_NO"].Value.ToString());//取样编号
- smpTypeName.Add(ugr.Cells["SMP_TYPE_NAME"].Value.ToString());//取样类型
- if (ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("3"))
- {
- this.alert("件件取样暂时不支持删除!!!");
- return;
- }
- }
- }
- if (MessageBox.Show("确认删除轧批号【" + batchNoViw + "】委托?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
- ccp.MethodName = "DoDelete";
- ccp.ServerParams = new object[] { batchNo, designKey, smpNo, specimenNo, smpTypeName, this.UserInfo.GetUserName() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageBox.Show("删除委托成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
- }
- this.DoQuery();
- }
- catch (Exception ex)
- {
- MessageBox.Show("操作过程出现异常!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- #endregion
- #region 查询
- private void DoQuery()
- {
- try
- {
- //LIMS退回轧批
- if (this.ultraTabControl1.Tabs[2].Selected)
- {
- inLIMSQuery();
- return;
- }
- String checkboxVal = "";
- String STARTTIME = this.dateTimePicker1.Value.ToString("yyyy-MM-dd");
- String ENDTIME = this.dateTimePicker2.Value.ToString("yyyy-MM-dd");
- String MATERIAL_NO = this.textBox1.Text.Trim();
- String VALIDFLAG = "1";
- String CERT_INST_NAME = this.textBox2.Text.Trim();//认证机构
- String PLINE_NAME = "优特钢";
- String PLINE_CODE = "YT1";
- String DESIGN_KEY = this.txt_steel_name.Text.Trim();
- String SMP_CATG = this.cbx_smp_catg.Text.Trim();
- String heatNo = this.selheatNo.Text.Trim();
- String onbatch1 = this.textBox3.Text.Trim();
- String onbatch2 = this.textBox4.Text.Trim();
- if (this.checkBox3.Checked)
- {
- STARTTIME = "";
- ENDTIME = "";
- }
- else
- {
- onbatch1 = "";
- onbatch2 = "";
- }
- if (this.checkBox2.Checked)
- {
- STARTTIME = "";
- ENDTIME = "";
- }
- else
- {
- heatNo = "";
- }
- if (CERT_INST_NAME.Equals("全部"))
- {
- CERT_INST_NAME = "";
- }
- SMP_CATG = "";
-
- if (this.checkBox1.Checked)
- {
- checkboxVal = "1";
- STARTTIME = "";
- ENDTIME = "";
- if (string.IsNullOrEmpty(MATERIAL_NO))
- {
- this.alert("您勾选了查询取样材料号条件未输入!");
- this.textBox1.Focus();
- return;
- }
- }
- else
- {
- MATERIAL_NO = "";
- }
- CoreClientParam ccp = new CoreClientParam();
- if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
- {
- this.dataSet1.Clear();
- ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
- ccp.MethodName = "getQltySampleInfoYT";
- ccp.SourceDataTable = this.dataSet1.Tables[0];
- }
- else if (this.ultraTabControl1.Tabs[1].Selected)
- {
- this.dataSet5.Clear();
- ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
- ccp.MethodName = "getQltySampleInfoYT";
- ccp.SourceDataTable = this.dataSet5.Tables[0];
- }
- Hashtable ht = new Hashtable();
- ht.Add("MATERIAL_NO", MATERIAL_NO);
- ht.Add("STARTTIME", STARTTIME);
- ht.Add("ENDTIME", ENDTIME);
- ht.Add("VALIDFLAG", VALIDFLAG);
- ht.Add("CERT_INST_NAME", CERT_INST_NAME);
- ht.Add("PLINE_NAME", PLINE_NAME);
- ht.Add("PLINE_CODE", PLINE_CODE);
- ht.Add("checkboxVal", checkboxVal);
- if (this.ultraTabControl1.Tabs[0].Selected)
- {
- ht.Add("STATUS", "0");
- }
- if (this.ultraTabControl1.Tabs[1].Selected)
- {
- ht.Add("TAB_NAME", "1");//发送时间
- }
- ht.Add("DESIGN_KEY", DESIGN_KEY);
- ht.Add("SMP_CATG", SMP_CATG);
- ht.Add("HEAT_NO", heatNo);
- ht.Add("BATCH_NO", onbatch1);
- ht.Add("BATCH_NO2", onbatch2);
- ccp.ServerParams = new object[] { ht };
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
- {
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- switch (ugr.Cells["STATUS"].Text.ToString())
- {
- case "0":
- ugr.Cells["STATUS"].Value = "未发送";
- break;
- case "1":
- ugr.Cells["STATUS"].Value = "已引用";
- break;
- case "2":
- ugr.Cells["STATUS"].Value = "已接收";
- break;
- case "3":
- ugr.Cells["STATUS"].Value = "已完成";
- break;
- case "4":
- ugr.Cells["STATUS"].Value = "检化验系统退回";
- break;
- case "5":
- ugr.Cells["STATUS"].Value = "重判";
- break;
- case "7":
- ugr.Cells["STATUS"].Value = "确认接收样";
- break;
- }
- if (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样")
- {
- ugr.Cells["SMP_TYPE_NAME"].Appearance.ForeColor = Color.Red;
- }
- }
- int num = this.ultraGrid1.Rows.Count();
- if (num <= 0)
- {
- this.dataSet2.Clear();
- this.dataSet3.Clear();
- }
- }
- else if (this.ultraTabControl1.Tabs[1].Selected)
- {
- foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
- {
- switch (ugr.Cells["STATUS"].Text.ToString())
- {
- case "0":
- ugr.Cells["STATUS"].Value = "未发送";
- break;
- case "1":
- ugr.Cells["STATUS"].Value = "已引用";
- break;
- case "2":
- ugr.Cells["STATUS"].Value = "已接收";
- break;
- case "3":
- ugr.Cells["STATUS"].Value = "已完成";
- break;
- case "4":
- ugr.Cells["STATUS"].Value = "检化验系统退回";
- break;
- case "5":
- ugr.Cells["STATUS"].Value = "重判";
- break;
- case "7":
- ugr.Cells["STATUS"].Value = "确认接收样";
- break;
- }
- if (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样")
- {
- ugr.Cells["SMP_TYPE_NAME"].Appearance.ForeColor = Color.Red;
- }
- }
- int num = this.ultraGrid4.Rows.Count();
- if (num <= 0)
- {
- this.dataSet6.Clear();
- }
- }
-
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错,请联系管理人员", "警告");
- }
- }
- private void inLIMSQuery()
- {
- try
- {
- String checkboxVal = "";
- String STARTTIME = this.dateTimePicker1.Value.ToString("yyyy-MM-dd");
- String ENDTIME = this.dateTimePicker2.Value.ToString("yyyy-MM-dd");
- String MATERIAL_NO = this.textBox1.Text.Trim();
- String VALIDFLAG = "1";
- String CERT_INST_NAME = this.textBox2.Text.Trim();//认证机构
- String PLINE_NAME = "优特钢";
- String PLINE_CODE = "YT1";
- String DESIGN_KEY = this.txt_steel_name.Text.Trim();
- String SMP_CATG = this.cbx_smp_catg.Text.Trim();
- String heatNo = this.selheatNo.Text.Trim();
- String onbatch1 = this.textBox3.Text.Trim();
- String onbatch2 = this.textBox4.Text.Trim();
- if (this.checkBox3.Checked)
- {
- checkboxVal = "1";
- STARTTIME = "";
- ENDTIME = "";
- }
- else
- {
- onbatch1 = "";
- onbatch2 = "";
- }
- if (this.checkBox2.Checked)
- {
- STARTTIME = "";
- ENDTIME = "";
- }
- else
- {
- heatNo = "";
- }
- if (CERT_INST_NAME.Equals("全部"))
- {
- CERT_INST_NAME = "";
- }
- SMP_CATG = "";
- if (this.checkBox1.Checked)
- {
-
- STARTTIME = "";
- ENDTIME = "";
- if (string.IsNullOrEmpty(MATERIAL_NO))
- {
- this.alert("您勾选了查询取样材料号条件未输入!");
- this.textBox1.Focus();
- return;
- }
- }
- else
- {
- MATERIAL_NO = "";
- }
- Hashtable ht = new Hashtable();
- ht.Add("MATERIAL_NO", MATERIAL_NO);
- ht.Add("STARTTIME", STARTTIME);
- ht.Add("ENDTIME", ENDTIME);
- ht.Add("VALIDFLAG", VALIDFLAG);
- ht.Add("CERT_INST_NAME", CERT_INST_NAME);
- ht.Add("PLINE_NAME", PLINE_NAME);
- ht.Add("PLINE_CODE", PLINE_CODE);
- ht.Add("checkboxVal", checkboxVal);
- if (this.ultraTabControl1.Tabs[0].Selected)
- {
- ht.Add("STATUS", "0");
- }
- if (this.ultraTabControl1.Tabs[1].Selected)
- {
- ht.Add("TAB_NAME", "1");//发送时间
- }
- ht.Add("DESIGN_KEY", DESIGN_KEY);
- ht.Add("SMP_CATG", SMP_CATG);
- ht.Add("HEAT_NO", heatNo);
- ht.Add("BATCH_NO", onbatch1);
- ht.Add("BATCH_NO2", onbatch2);
- CoreClientParam ccp = new CoreClientParam();
- this.dataSet10.Clear();
- ccp.ServerName = "QCM.JHY01.JHY0102.QuerryJhyQtly";
- ccp.MethodName = "ZHBQueryLims";
- ccp.SourceDataTable = this.dataSet10.Tables[0];
- ccp.ServerParams = new object[] { ht };
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错,请联系管理人员", "警告");
- }
- }
- #endregion
-
- #region 查找检验项目
- private void DoQueryPrg(UltraGridRow ugr)
- {
- try
- {
- this.dataSet3.Clear();
- String specimen_no = ugr.Cells["SPECIMEN_NO"].Value.ToString();
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
- ccp.MethodName = "getQltySampleItem";
- ccp.ServerParams = new object[] { specimen_no };
- ccp.SourceDataTable = this.dataSet3.Tables[0];
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错,请联系管理人员", "警告");
- }
- }
- #endregion
- #region 查询订单信息
- private void DoQueryOrder(UltraGridRow ugr)
- {
- try
- {
- this.dataSet2.Clear();
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
- ccp.MethodName = "getQltySampleOrd";
- ccp.ServerParams = new object[] { ugr.Cells["SMP_NO"].Text.ToString() };
- ccp.SourceDataTable = this.dataSet2.Tables[0];
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- //foreach (UltraGridRow ugr2 in this.ultraGrid2.Rows)
- //{
- // ugr2.Cells["Column1"].Value = ugr2.Cells["THICK"].Value + "*" + ugr2.Cells["WIDTH"].Value + "*" + ugr2.Cells["LENGTH"].Value;
- //}
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错,请联系管理人员", "警告");
- }
- }
- #endregion
- #region 发送检验委托
- private void DoSend()
- {
- try
- {
- DoUpdate();//先修改取样材料号
- List<UltraGridRow> lists = new List<UltraGridRow>();
- CoreClientParam ccp = new CoreClientParam();
- string SPECIMEN_NO = "";
- string fh = "";
- int num = 0;
- foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
- {
- string specimeNo = "";
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
- num = num + 1;
- if (num <= 1)
- {
- SPECIMEN_NO = specimeNo;
- fh = ",";
- }
- else
- {
- SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
- }
- lists.Add(ugr);
- }
- }
- ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
- ccp.MethodName = "SendLIMES";
- ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserID(), this.UserInfo.GetUserName(), " " };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- for (int i = 0; i < lists.Count; i++)
- {
- lists[i].Delete(false);
- }
- MessageBox.Show("发送成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
- }
- //this.DoQuery();
- int conut = this.ultraGrid1.Rows.Count();
- if (conut <= 0)
- {
- this.dataSet2.Clear();
- this.dataSet3.Clear();
- }
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错,请联系管理人员", "警告");
- }
- }
- #endregion
- #region 撤销检验委托
- private void DoUnsend()
- {
- try
- {
- if (MessageBox.Show("确认撤销发送?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
- {
- return;
- }
- List<UltraGridRow> lists = new List<UltraGridRow>();
- String zhyy = "MES撤回";
- CoreClientParam ccp = new CoreClientParam();
- string SPECIMEN_NO = "";
- string fh = "";
- int num = 0;
- foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
- {
- string specimeNo = "";
- if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
- {
- specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
- num = num + 1;
- if (num <= 1)
- {
- SPECIMEN_NO = specimeNo;
- fh = ",";
- }
- else
- {
- SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
- }
- lists.Add(ugr);
- }
- }
- ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
- ccp.MethodName = "CancelLIMES";
- ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserName(), zhyy };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- for (int i = 0; i < lists.Count; i++)
- {
- lists[i].Delete(false);
- }
- MessageBox.Show("撤销发送成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
- }
- // this.DoQuery();
- int conut = this.ultraGrid4.Rows.Count();
- if (conut <= 0)
- {
- this.dataSet6.Clear();
- }
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错,请联系管理人员", "警告");
- }
- }
- #endregion
- #region 卷板质量异常处理
- private void DoEject()
- {
- QCM0307 frmRbp = new QCM0307();
- frmRbp.StartPosition = FormStartPosition.CenterScreen;
- frmRbp.ob = this.ob;
- frmRbp.ShowDialog();
- }
- #endregion
- #endregion
- #region 其它事件
- #region 查询下拉框 取样材料号
- private void ultraGrid1_AfterCellActivate(object sender, EventArgs e)
- {
- this.dataSet4.Clear();
- String batchNo = this.ultraGrid1.ActiveRow.Cells["BATCH_NO"].Value.ToString();
- String plineCode = this.ultraGrid1.ActiveRow.Cells["PLINE_CODE"].Value.ToString();
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";//调用java地址
- ccp.MethodName = "getBilletId";//调用的方法
- ccp.ServerParams = new object[] { batchNo, plineCode };
- ccp.SourceDataTable = this.dataSet4.Tables[0];
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- ValueList VDEFECT_DESC = new ValueList();
- for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++)
- {
- VDEFECT_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["MATERIAL_NO"].ToString(), ccp.SourceDataTable.Rows[i]["MATERIAL_NO"].ToString());
- }
- this.ultraGrid1.DisplayLayout.Bands[0].Columns["MATERIAL_NO"].ValueList = VDEFECT_DESC;
- }
- #endregion
- private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
- {
- int num = this.ultraGrid1.Rows.Count();
- if (num >= 1)
- {
- Infragistics.Win.UltraWinGrid.UltraGrid uGrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
- string specimen_no = uGrid.ActiveRow.Cells["SPECIMEN_NO"].Text.Trim();
- string smp_no = uGrid.ActiveRow.Cells["SMP_NO"].Text.Trim();
- this.dataSet3.Tables[0].Clear();
- this.dataSet2.Tables[0].Clear();
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
- ccp.MethodName = "getQltySampleItemNew";
- ccp.ServerParams = new object[] { specimen_no };
- ccp.SourceDataTable = this.dataSet3.Tables[0];
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- }
- else
- {
- this.dataSet2.Clear();
- this.dataSet3.Clear();
- }
- }
- #region 选择tab 显示相应按钮
- private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- if (this.ultraTabControl1.SelectedTab.Index == 0)
- {
- this.ToolBarItemEnable(this, "Send", true);
- this.ToolBarItemEnable(this, "Add", true);
- this.ToolBarItemEnable(this, "AddArtificial", true);
- this.ToolBarItemEnable(this, "Unsend", false);
- this.ToolBarItemEnable(this, "AddWt", true);
- this.ToolBarItemEnable(this, "DelWt", true);
- this.ToolBarItemEnable(this, "DoDelete", true);
- this.ToolBarItemEnable(this, "DoQuote", true);
- this.ToolBarItemEnable(this, "doPrint", false);
- }
- else if (this.ultraTabControl1.SelectedTab.Index == 1)
- {
- this.ToolBarItemEnable(this, "Send", false);
- this.ToolBarItemEnable(this, "Add", false);
- this.ToolBarItemEnable(this, "AddArtificial", false);
- this.ToolBarItemEnable(this, "Unsend", true);
- this.ToolBarItemEnable(this, "AddWt", false);
- this.ToolBarItemEnable(this, "DelWt", false);
- this.ToolBarItemEnable(this, "DoDelete", false);
- this.ToolBarItemEnable(this, "DoQuote", false);
- this.ToolBarItemEnable(this, "doPrint", true);
- }
- else if (this.ultraTabControl1.SelectedTab.Index == 2)
- {
- this.ToolBarItemEnable(this, "Send", false);
- this.ToolBarItemEnable(this, "Add", false);
- this.ToolBarItemEnable(this, "AddArtificial", false);
- this.ToolBarItemEnable(this, "Unsend", false);
- this.ToolBarItemEnable(this, "AddWt", false);
- this.ToolBarItemEnable(this, "DelWt", false);
- this.ToolBarItemEnable(this, "DoDelete", false);
- this.ToolBarItemEnable(this, "DoQuote", false);
- this.ToolBarItemEnable(this, "doPrint", false);
- }
- }
- #endregion
- private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
- {
- Infragistics.Win.UltraWinGrid.UltraGrid uGrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
- string specimen_no = uGrid.ActiveRow.Cells["SPECIMEN_NO"].Text.Trim();
- string smp_no = uGrid.ActiveRow.Cells["SMP_NO"].Text.Trim();
- this.dataSet6.Tables[0].Clear();
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
- ccp.MethodName = "getQltySampleItemNew";
- ccp.ServerParams = new object[] { specimen_no };
- ccp.SourceDataTable = this.dataSet6.Tables[0];
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- }
- private void ultraGrid1_CellChange(object sender, CellEventArgs e)
- {
- ultraGrid1.UpdateData();
- }
- private void ultraGrid1_AfterHeaderCheckStateChanged(object sender, AfterHeaderCheckStateChangedEventArgs e)
- {
- ultraGrid1.UpdateData();
- }
- private void ultraGrid4_AfterHeaderCheckStateChanged(object sender, AfterHeaderCheckStateChangedEventArgs e)
- {
- ultraGrid4.UpdateData();
- }
- private void ultraGrid4_CellChange(object sender, CellEventArgs e)
- {
- ultraGrid4.UpdateData();
- }
- #endregion
- #region 右下角 删除 名称
- private void ultraGrid3_InitializeRow(object sender, InitializeRowEventArgs e)
- {
- e.Row.Cells["deletebol"].Value = "删除";
- }
- #endregion
- #region 右下角 删除
- private void ultraGrid3_ClickCellButton(object sender, CellEventArgs e)
- {
- ultraGrid3.UpdateData();
- if (e.Cell.Column.Key == "deletebol")
- {
- if (MessageBox.Show("确定要删除这一项目?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.No)
- {
- return;
- }
- try
- {
- CoreClientParam ccp = new CoreClientParam();
- String seq = "";//检验项目流水号
- String specimenNo = "";//取样编号
- UltraGridRow row = ultraGrid3.ActiveRow;
- if (!row.Cells["ITEM_FLAG"].Value.ToString().Equals("1"))
- {
- MessageBox.Show("不能删除系统生成的项目,只能删除人工生成的项目!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- seq = row.Cells["SEQ"].Value.ToString();
- specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();
- ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
- ccp.MethodName = "deleteInfo";
- ccp.ServerParams = new object[] { seq, specimenNo };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageBox.Show(ccp.ReturnInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
- }
- this.DoQueryPrg(this.ultraGrid1.ActiveRow);
- }
- catch (Exception ex)
- {
- System.Diagnostics.Debug.WriteLine(ex.ToString());
- MessageBox.Show("系统出错,请联系管理人员", "警告");
- }
- }
- }
- #endregion
- #region 勾选框触发
- private void checkBox1_Click(object sender, EventArgs e)
- {
- if (this.checkBox1.Checked)
- {
- this.dateTimePicker1.Enabled = false;
- this.dateTimePicker2.Enabled = false;
- this.textBox1.Enabled = true;
- }
- else
- {
- if (!this.checkBox2.Checked && !this.checkBox3.Checked)
- {
- this.dateTimePicker1.Enabled = true;
- this.dateTimePicker2.Enabled = true;
- }
- this.textBox1.Enabled = false;
- }
- }
- private void checkBox2_Click(object sender, EventArgs e)
- {
- if (this.checkBox2.Checked)
- {
- this.dateTimePicker1.Enabled = false;
- this.dateTimePicker2.Enabled = false;
- this.selheatNo.Enabled = true;
- }
- else
- {
- if (!this.checkBox1.Checked && !this.checkBox3.Checked)
- {
- this.dateTimePicker1.Enabled = true;
- this.dateTimePicker2.Enabled = true;
- }
- this.selheatNo.Enabled = false;
- }
- }
- private void checkBox3_Click(object sender, EventArgs e)
- {
- if (this.checkBox3.Checked)
- {
- this.dateTimePicker1.Enabled = false;
- this.dateTimePicker2.Enabled = false;
- this.textBox3.Enabled = true;
- this.textBox4.Enabled = true;
- }
- else
- {
- if (!this.checkBox1.Checked && !this.checkBox2.Checked)
- {
- this.dateTimePicker1.Enabled = true;
- this.dateTimePicker2.Enabled = true;
- }
- this.textBox3.Enabled = false;
- this.textBox4.Enabled = false;
- }
- }
- #endregion
-
-
- }
- }
|