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.IO; using Microsoft.Office.Interop.Excel; using ET; using System.Collections; namespace Core.LZMes.Client.UIK { public partial class UIK020010 : FrmBase { private string yardAddr = "";//上料钢卷垛位 private string c_coilNo = "";//冷轧卷号 private int coil_no_index = -1;//冷轧卷在轧制计划的下标位置 public UIK020010() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Save": this.DoSave(); break; case "Exit": this.Close(); break; case "Export": this.DoExport(); break; } } ///

/// 查询酸轧轧制计划 ///

private void DoQuery() { this.dataSet1.Tables[0].Clear(); this.dataSet3.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK02.UIK020010"; ccp.MethodName = "queryAcidRollingPlan"; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataRowCollection drs = dataSet1.Tables[0].Rows; for (int i = 0; i < drs.Count; i++) { if (drs[i]["STATUS_CD"].ToString().Equals("上鞍座")) { ultraGrid1.Rows[i].Appearance.BackColor = Color.FromArgb(192,255,192); } else if (drs[i]["STATUS_CD"].ToString().Equals("预备吊销钢卷")) { ultraGrid1.Rows[i].Appearance.BackColor = Color.Red; } else if (drs[i]["STATUS_CD"].ToString().Equals("真正吊销钢卷")) { ultraGrid1.Rows[i].Appearance.BackColor = Color.Red; } else if (drs[i]["STATUS_CD"].ToString().Equals("焊接")) { ultraGrid1.Rows[i].Appearance.BackColor = Color.SpringGreen; } else if (drs[i]["STATUS_CD"].ToString().Equals("生产完成")) { ultraGrid1.Rows[i].Appearance.BackColor = Color.Green; } //if (drs[i]["STATUS_CD"].ToString().Equals("上鞍座") && drs[i]["YARD_ADDR"].ToString().Equals("")&&) //{ // ultraGrid1.Rows[i].Appearance.BackColor = Color.FromArgb(180, 0, 180); //} } CoreClientParam ccp3 = new CoreClientParam(); ccp3.ServerName = "UIK.UIK02.UIK020010"; ccp3.MethodName = "queryAddClassInf"; ccp3.SourceDataTable = this.dataSet3.Tables[0]; this.ExecuteQueryToDataTable(ccp3, CoreInvokeType.Internal); } private void ultraGrid1_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e) { Infragistics.Win.UltraWinGrid.UltraGrid uGrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender; int index = uGrid.ActiveRow.Index; if (index > 0) { string statusCd = uGrid.Rows[index - 1].Cells["STATUS_CD"].Text.Trim(); if ("计划中".Equals(statusCd)) { MessageBox.Show("必须按照轧制计划顺序上料，请确认后重新选择！"); return; } } string coilNo = uGrid.ActiveRow.Cells["H_COIL_NO"].Text.Trim(); this.textBox3.Text = coilNo; yardAddr = uGrid.ActiveRow.Cells["YARD_ADDR"].Text.Trim(); c_coilNo = uGrid.ActiveRow.Cells["C_COIL_NO"].Text.Trim(); coil_no_index = uGrid.ActiveRow.VisibleIndex; dataSet2.Tables[0].Clear(); DataRow dr = dataSet2.Tables[0].NewRow(); dr["COIL_NO"] = coilNo; dr["COIL_LEN"] = uGrid.ActiveRow.Cells["COIL_LEN"].Text.Trim(); dr["COIL_WGT"] = uGrid.ActiveRow.Cells["COIL_WGT"].Text.Trim(); dr["LEN_DET"] = 1; dr["YARD_ADDR"] = yardAddr; this.textBox2.Text = yardAddr; dataSet2.Tables[0].Rows.Add(dr); } ///

/// 酸轧上料操作 ///

private void DoSave() { if (this.ultraComboEditor1.SelectedIndex < 0) { MessageBox.Show("上料位置为空，请选择相应开卷机后再进行上料操作！"); this.ultraComboEditor1.Focus(); return; } if (this.textBox3.Text.Trim().Equals("")) { MessageBox.Show("钢卷号信息为空，请选择相应的钢卷后再进行上料操作！"); return; } if (null == this.ultraDateTimeEditor1.Value) { MessageBox.Show("上料时间为空，请选择相应的上料时间后再进行上料操作！"); return; } string coilNo = this.textBox3.Text.Trim(); if ("".Equals(coilNo)) { MessageBox.Show("上料钢卷为空，请选择相应的原料卷后再进行上料操作！"); return; } string feedingLine = this.ultraComboEditor1.Value.ToString(); CoreClientParam ccp2 = new CoreClientParam(); System.Data.DataTable dt = new System.Data.DataTable(); ccp2.ServerName = "UIK.UIK02.UIK020010"; ccp2.MethodName = "SelectSTATUS_CD"; ccp2.ServerParams = new object[] { coilNo }; ccp2.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp2, CoreInvokeType.Internal); if (dt.Rows.Count <= 0) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK02.UIK020010"; ccp.MethodName = "hasCoilOnYardAddr"; ccp.ServerParams = new Object[] { yardAddr }; ccp = this.ExecuteQuery(ccp, CoreInvokeType.Internal); int count = int.Parse(ccp.ReturnObject.ToString()); if (count > 0 && DialogResult.No == MessageBox.Show("选择的钢卷堆放位置上方有其他钢卷，是否继续上料？", "提示", MessageBoxButtons.YesNo)) { return; } string trnfRegId = this.UserInfo.GetUserID(); string trnfShift = this.UserInfo.GetUserOrder(); string trnfGroup = this.UserInfo.GetUserGroup(); string trnfDTime = this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"); CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "UIK.UIK02.UIK020010"; ccp1.MethodName = "saveAcidRolling"; ccp1.ServerParams = new Object[] { coilNo, c_coilNo, "T", trnfRegId, trnfShift, trnfGroup, trnfDTime }; this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (0 != ccp1.ReturnCode) { MessageBox.Show("上料失败"); return; } else { MessageBox.Show("上料成功"); } } else { string trnfRegId = this.UserInfo.GetUserID(); string trnfShift = this.UserInfo.GetUserOrder(); string trnfGroup = this.UserInfo.GetUserGroup(); string trnfDTime = this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"); CoreClientParam ccp3 = new CoreClientParam(); System.Data.DataTable dt1 = new System.Data.DataTable(); ccp3.ServerName = "UIK.UIK02.UIK020010"; ccp3.MethodName = "InsertInformation"; ccp3.ServerParams = new object[] { trnfRegId, trnfShift, trnfGroup, trnfDTime,coilNo}; this.ExecuteNonQuery(ccp3, CoreInvokeType.Internal); if (0 != ccp3.ReturnCode) { MessageBox.Show("插入失败"); return; } else { MessageBox.Show("插入成功"); } } //this.DoPrint(); this.DoQuery(); } ///

/// 导出 ///

private void DoExport() { try { if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK) { string fileName = this.saveFileDialog1.FileName; ultraGridExcelExporter1.Export(ultraGrid1, fileName); System.Diagnostics.Process.Start(fileName); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } ///

/// 酸轧上吊销 ///

/// /// private void pictureBox1_Click(object sender, EventArgs e) { if ("".Equals(this.textBox3.Text.Trim())) { MessageBox.Show("请选择需要吊销的钢卷！"); return; } if (0 > this.ultraComboEditor2.SelectedIndex) { MessageBox.Show("请选择吊销类型！"); return; } if (null == this.ultraDateTimeEditor2.Value) { MessageBox.Show("请选择吊销时间！"); return; } if ("".Equals(textBox2.Text.Trim())) { MessageBox.Show("请输入吊销后堆放的位置！"); return; } //钢卷入库 string coilNo = textBox3.Text.Trim(); string yardAddr = textBox2.Text.Trim(); //判断垛位 try { string[] tmpArray = yardAddr.Split('-'); if (tmpArray[1].Length < 3) { tmpArray[1] = "0" + tmpArray[1]; } if (tmpArray[2].Length < 2) { tmpArray[2] = "0" + tmpArray[2]; } if (Convert.ToInt32(tmpArray[0]) != 1) { MessageBox.Show("垛位输入有误，请重新输入！"); return; } if (Convert.ToInt32(tmpArray[2]) > 69) { MessageBox.Show("垛位行数不能超过69，请重新输入！"); return; } if (Convert.ToInt32(tmpArray[1].Substring(0, 2)) > 17) { MessageBox.Show("垛位列数不能超过17，请重新输入！"); return; } if ((tmpArray[1].Substring(2, 1)) != "A") { MessageBox.Show("垛位格式不对，请重新输入！"); return; } yardAddr = tmpArray[0] + "-" + tmpArray[1] + "-" + tmpArray[2]; } catch (Exception ex) { MessageBox.Show("垛位错误！"); return; } string entryShift = this.UserInfo.GetUserOrder(); string entryGroup = this.UserInfo.GetUserGroup(); string reg_id = this.UserInfo.GetUserID(); string entryDtime = ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd"); MessageBox.Show("请确认退卷信息：钢卷号："+coilNo ); if (MessageBox.Show("您确认要退卷吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { CoreClientParam ccp = new CoreClientParam(); System.Data.DataTable dt = new System.Data.DataTable(); ccp.ServerName = "UIK.UIK02.UIK020010"; ccp.MethodName = "SelectCoilYard"; ccp.ServerParams = new object[] { yardAddr }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt.Rows.Count > 0) { MessageBox.Show("该垛位上已有钢卷，请重新输入垛位信息！"); return; } else { CoreClientParam ccp2 = new CoreClientParam(); ccp2.ServerName = "UIK.UIK02.UIK020010"; ccp2.MethodName = "saveCoilYard"; ccp2.ServerParams = new object[] { coilNo, yardAddr, entryShift, entryGroup, entryDtime, reg_id, "C" }; this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal); if (0 != ccp2.ReturnCode) { MessageBox.Show("退回失败！"); } else { MessageBox.Show("退回成功"); } } } //修改轧制计划、取消取样标识 } private void UIK020010_Load(object sender, EventArgs e) { this.ultraComboEditor2.SelectedIndex = 0; this.ultraComboEditor6.SelectedIndex = 0; this.ultraComboEditor6.Text = ""; this.ultraGrid2.DisplayLayout.ValueLists.Add("List1"); this.ultraGrid2.DisplayLayout.ValueLists["List1"].ValueListItems.Add(1, "合格"); this.ultraGrid2.DisplayLayout.ValueLists["List1"].ValueListItems.Add(2, "不合格"); this.ultraGrid2.DisplayLayout.ValueLists["List1"].DisplayStyle = Infragistics.Win.ValueListDisplayStyle.DisplayText; this.ultraGrid2.DisplayLayout.Bands[0].Columns[3].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; this.ultraGrid2.DisplayLayout.Bands[0].Columns[3].ValueList = this.ultraGrid2.DisplayLayout.ValueLists["List1"]; } private void ultraComboEditor2_SelectionChanged(object sender, EventArgs e) { if (0 == this.ultraComboEditor2.SelectedIndex) { this.ultraComboEditor6.ReadOnly = true; this.ultraComboEditor6.Text = ""; } else { this.ultraComboEditor6.ReadOnly = false; } } ///

/// 打印生产流程卡 ///

private void DoPrint() { if (coil_no_index >= 0) { Infragistics.Win.UltraWinGrid.UltraGridRow uRow = ultraGrid1.Rows[coil_no_index]; string[] param = new string[8]; string cCoilNo = uRow.Cells["C_COIL_NO"].Text.Trim(); param[0] = cCoilNo.Substring(0,cCoilNo.LastIndexOf('-')); param[1] = uRow.Cells["STL_GRD"].Text.Trim(); param[2] = uRow.Cells["H_COIL_NO"].Text.Trim(); param[3] = uRow.Cells["IT_IW"].Text.Trim(); param[4] = uRow.Cells["COIL_WGT"].Text.Trim(); string tw = uRow.Cells["T_W"].Text.Trim(); param[5] = tw.Substring(0,tw.IndexOf('*')); param[6] = tw.Substring(tw.IndexOf('*')+1); param[7] = uRow.Cells["ORD_FL"].Text.Trim().Equals("1") ? "订单" : ""; try { string fileName = AppDomain.CurrentDomain.BaseDirectory + "\\tmp.xls"; this.ExportExcel(param, fileName); string printerName = new System.Drawing.Printing.PrintDocument().PrinterSettings.PrinterName; Tools.PrintUtil.printExcel(fileName, printerName); } catch (Exception ex) { MessageBox.Show("打印失败,请关闭程序后重新操作！"); } } } ///

/// 导出 Excel 文件 ///

/// 要导出的数据 /// 操作人 private void ExportExcel(string []list, String strExcelFileName) { if (list == null || list.Length < 1) { return; } StreamWriter writer = new StreamWriter(strExcelFileName, false, Encoding.UTF8); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine("siy "); writer.WriteLine("siy "); writer.WriteLine("11111 "); writer.WriteLine("steering "); writer.WriteLine("11.8107 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine("13590 "); writer.WriteLine("19200 "); writer.WriteLine("0 "); writer.WriteLine("285 "); writer.WriteLine("False "); writer.WriteLine("False "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 冷轧厂生产流程卡 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 编号： "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 冷轧批号： "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" " + list[0] + " "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 酸轧入口确认人 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 酸轧班组： "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 酸轧生产日期： "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 年月日 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 钢种 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 热轧钢卷号 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 热轧卷规格 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 热轧卷重量 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 热轧卷实测厚度 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 热轧卷实测宽度 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 热轧卷质量情况 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 是否订单材 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "+ list[1] +" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" " + list[2] + " "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" " + list[3] + " "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" " + list[4] + " "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" " + list[5] + " "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" " + list[6] + " "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" " + list[7] + " "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 冷轧钢卷号 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 冷轧后规格 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 是否切边 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 质量判定 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 冷轧后钢卷磅重(Kg) "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 自动化磅房重量(Kg) "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 冷轧卷中间库堆垛位 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 备注 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 物流填表班组 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 物流中间库填表时间 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" 年月日 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine("

"); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine("3 "); writer.WriteLine("1 "); writer.WriteLine("1 "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine("False "); writer.WriteLine("False "); writer.WriteLine(" "); writer.WriteLine(" "); writer.WriteLine(" "); writer.Close(); } private void ultraGrid3_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { if (e.Cell.Column.Key == "SELECT_ITEM") { if (e.Cell.Text == "True") { string coilNo; coilNo = e.Cell.Row.Cells["OLD_SAMPL_NO"].Text; /*for循环控制单选*/ int i = this.ultraGrid3.Rows.Count; for (int j = 0; j < i; j++) { if (this.ultraGrid3.Rows[j].Cells["OLD_SAMPL_NO"].Text != coilNo) { this.ultraGrid3.Rows[j].Cells["SELECT_ITEM"].Value = false; } } string trnfRegId = this.UserInfo.GetUserID(); string trnfShift = this.UserInfo.GetUserOrder(); string trnfGroup = this.UserInfo.GetUserGroup(); string trnfDTime = this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"); CoreClientParam ccp3 = new CoreClientParam(); System.Data.DataTable dt1 = new System.Data.DataTable(); ccp3.ServerName = "UIK.UIK02.UIK020010"; ccp3.MethodName = "InsertInformation"; ccp3.ServerParams = new object[] { trnfRegId, trnfShift, trnfGroup, trnfDTime, coilNo }; this.ExecuteNonQuery(ccp3, CoreInvokeType.Internal); if (0 != ccp3.ReturnCode) { MessageBox.Show("插入失败"); return; } else { MessageBox.Show("插入成功"); } DoQuery(); } } } } }