XinYu_LZMES_Client/Core.LZMes.Client.UIK/UIK02/UIK020010.cs

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;
            }
        }

        /// <summary>
        /// 查询酸轧轧制计划
        /// </summary>
        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);
        }

        /// <summary>
        /// 酸轧上料操作
        /// </summary>
        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();
        }

        /// <summary>
        /// 导出
        /// </summary>



        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());
            }
        }
        /// <summary>
        /// 酸轧上吊销
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        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;
            }
        }

        /// <summary>
        /// 打印生产流程卡
        /// </summary>
        
        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("打印失败,请关闭程序后重新操作！");
                }
            }
        }
        
        /// <summary>
        /// 导出 Excel 文件
        /// </summary>
        /// <param name="list">要导出的数据</param>
        /// <param name="regId">操作人</param>
        private void ExportExcel(string []list, String strExcelFileName)
        {
            if (list == null || list.Length < 1)
            {
                return;
            }

            StreamWriter writer = new StreamWriter(strExcelFileName, false, Encoding.UTF8);
            writer.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?>                                                            ");
            writer.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>                                                             ");
            writer.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"                                       ");
            writer.WriteLine("xmlns:o=\"urn:schemas-microsoft-com:office:office\"                                                    ");
            writer.WriteLine("xmlns:x=\"urn:schemas-microsoft-com:office:excel\"                                                     ");
            writer.WriteLine("xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\"                                              ");
            writer.WriteLine("xmlns:html=\"http://www.w3.org/TR/REC-html40\">                                                        ");
            writer.WriteLine("<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">                                 ");
            writer.WriteLine("<Author>siy</Author>                                                                                   ");
            writer.WriteLine("<LastAuthor>siy</LastAuthor>                                                                           ");
            writer.WriteLine("<Created>11111</Created>                                                                               ");
            writer.WriteLine("<Company>steering</Company>                                                                            ");
            writer.WriteLine("<Version>11.8107</Version>                                                                             ");
            writer.WriteLine("</DocumentProperties>                                                                                  ");
            writer.WriteLine("<ExcelWorkbook xmlns=\"urn:schemas-microsoft-com:office:excel\">                                       ");
            writer.WriteLine("<WindowHeight>13590</WindowHeight>                                                                     ");
            writer.WriteLine("<WindowWidth>19200</WindowWidth>                                                                       ");
            writer.WriteLine("<WindowTopX>0</WindowTopX>                                                                             ");
            writer.WriteLine("<WindowTopY>285</WindowTopY>                                                                           ");
            writer.WriteLine("<ProtectStructure>False</ProtectStructure>                                                             ");
            writer.WriteLine("<ProtectWindows>False</ProtectWindows>                                                                 ");
            writer.WriteLine("</ExcelWorkbook>                                                                                       ");
            writer.WriteLine("<Styles>                                                                                               ");
            writer.WriteLine("<Style ss:ID=\"Default\" ss:Name=\"Normal\">                                                           ");
            writer.WriteLine("<Alignment ss:Vertical=\"Center\"/>                                                                    ");
            writer.WriteLine("<Borders/>                                                                                             ");
            writer.WriteLine("<Font ss:FontName=\"宋体\" x:CharSet=\"134\" ss:Size=\"12\"/>                                            ");
            writer.WriteLine("<Interior/>                                                                                            ");
            writer.WriteLine("<NumberFormat/>                                                                                        ");
            writer.WriteLine("<Protection/>                                                                                          ");
            writer.WriteLine("</Style>                                                                                               ");
            writer.WriteLine("<Style ss:ID=\"s11\">                                                                                  ");
            writer.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\"/>                                           ");
            writer.WriteLine("<Borders>                                                                                              ");
            writer.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>      ");
            writer.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>        ");
            writer.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>       ");
            writer.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>         ");
            writer.WriteLine("</Borders>                                                                                             ");
            writer.WriteLine("<Font ss:FontName=\"SimSun\" x:CharSet=\"134\" ss:Size=\"18\" ss:Bold=\"1\"/>                          ");
            writer.WriteLine("<Interior ss:Color=\"#FFFFFF\" ss:Pattern=\"Solid\"/>                                                  ");
            writer.WriteLine("</Style>                                                                                               ");
            writer.WriteLine("<Style ss:ID=\"s21\">                                                                                  ");
            writer.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\"/>                                           ");
            writer.WriteLine("<Borders>                                                                                              ");
            writer.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>      ");
            writer.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>        ");
            writer.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>       ");
            writer.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>                              ");
            writer.WriteLine("</Borders>                                                                                             ");
            writer.WriteLine("<Font ss:FontName=\"SimSun\" x:CharSet=\"134\" ss:Size=\"12\" ss:Bold=\"1\"/>                          ");
            writer.WriteLine("<Interior ss:Color=\"#FFFFFF\" ss:Pattern=\"Solid\"/>                                                  ");
            writer.WriteLine("</Style>                                                                                               ");
            writer.WriteLine("<Style ss:ID=\"s12\">                                                                                  ");
            writer.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\"/>                                           ");
            writer.WriteLine("<Borders>                                                                                              ");
            writer.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>                           ");
            writer.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>        ");
            writer.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>       ");
            writer.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>         ");
            writer.WriteLine("</Borders>                                                                                             ");
            writer.WriteLine("<Font ss:FontName=\"SimSun\" x:CharSet=\"134\" ss:Size=\"12\" ss:Bold=\"1\"/>                          ");
            writer.WriteLine("<Interior ss:Color=\"#FFFFFF\" ss:Pattern=\"Solid\"/>                                                  ");
            writer.WriteLine("</Style>                                                                                               ");
            writer.WriteLine("<Style ss:ID=\"s13\">                                                                                  ");
            writer.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\"/>                                           ");
            writer.WriteLine("<Borders>                                                                                              ");
            writer.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>                           ");
            writer.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>        ");
            writer.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>       ");
            writer.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\" ss:Color=\"#FFFFFF\"/>         ");
            writer.WriteLine("</Borders>                                                                                             ");
            writer.WriteLine("<Font ss:FontName=\"SimSun\" x:CharSet=\"134\" ss:Size=\"12\" ss:Bold=\"1\"/>                          ");
            writer.WriteLine("<Interior ss:Color=\"#FFFFFF\" ss:Pattern=\"Solid\"/>                                                  ");
            writer.WriteLine("</Style>                                                                                               ");
            writer.WriteLine("<Style ss:ID=\"s22\">                                                                                  ");
            writer.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\" ss:WrapText=\"1\"/>                         ");
            writer.WriteLine("<Borders>                                                                                              ");
            writer.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>                           ");
            writer.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>                             ");
            writer.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>                            ");
            writer.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>                              ");
            writer.WriteLine("</Borders>                                                                                             ");
            writer.WriteLine(" <Font ss:FontName=\"SimSun\" x:CharSet=\"134\" ss:Size=\"12\" ss:Bold=\"1\"/>                         ");
            writer.WriteLine("<Interior ss:Color=\"#FFFFFF\" ss:Pattern=\"Solid\"/>                                                  ");
            writer.WriteLine("</Style>                                                                                               ");
            writer.WriteLine("</Styles>                                                                                              ");
            writer.WriteLine("<Worksheet ss:Name=\"Sheet1\">                                                                         ");
            writer.WriteLine("<Table  ss:DefaultColumnWidth=\"54\" ss:DefaultRowHeight=\"14.25\">                                    ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Column ss:Width=\"42\"/>                                                                              ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"50\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s11\" ss:MergeAcross=\"16\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\">冷轧厂生产流程卡</Data>                                                           ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s13\" ss:MergeAcross=\"12\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                           ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s13\" ss:MergeAcross=\"1\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\">编号：</Data>                                                           ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s13\" ss:MergeAcross=\"1\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                           ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\">                                                                           ");
            writer.WriteLine("  <Cell ss:StyleID=\"s12\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">冷轧批号：</Data>                                                              ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s12\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">" + list[0] + "</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s12\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">酸轧入口确认人</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s12\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s12\"  ss:MergeAcross=\"1\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\">酸轧班组：</Data>                                                              ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s12\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s12\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">酸轧生产日期：</Data>                                                            ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s12\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">      年   月   日</Data>                                                  ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">钢种</Data>                                                                 ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">热轧钢卷号</Data>                                                              ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">热轧卷规格</Data>                                                              ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\"  ss:MergeAcross=\"1\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\">热轧卷重量</Data>                                                              ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">热轧卷实测厚度</Data>                                                            ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">热轧卷实测宽度</Data>                                                            ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">热轧卷质量情况</Data>                                                            ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">是否订单材</Data>                                                              ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">"+ list[1] +"</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">" + list[2] + "</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">" + list[3] + "</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\"  ss:MergeAcross=\"1\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\">" + list[4] + "</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">" + list[5] + "</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">" + list[6] + "</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">" + list[7] + "</Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\"  ss:MergeAcross=\"1\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\"  ss:MergeAcross=\"1\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">冷轧钢卷号</Data>                                                              ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">冷轧后规格</Data>                                                              ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">是否切边</Data>                                                               ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">质量判定</Data>                                                               ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">冷轧后钢卷磅重(Kg)</Data>                                                            ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">自动化磅房重量(Kg)</Data>                                                            ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">冷轧卷中间库堆垛位</Data>                                                          ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">备注</Data>                                                                 ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">                                                          ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            
            writer.WriteLine("  <Cell ss:StyleID=\"s22\" ss:MergeAcross=\"1\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("<Row ss:AutoFitHeight=\"0\">                                                                           ");
            writer.WriteLine("  <Cell ss:StyleID=\"s21\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">物流填表班组</Data>                                                             ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s21\" ss:MergeAcross=\"4\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s21\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\">物流中间库填表时间</Data>                                                          ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s21\"  ss:MergeAcross=\"2\">                                                      ");
            writer.WriteLine("    <Data ss:Type=\"String\">      年    月    日</Data>                                                  ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("  <Cell ss:StyleID=\"s21\" ss:MergeAcross=\"2\">                                                       ");
            writer.WriteLine("    <Data ss:Type=\"String\"></Data>                                                                   ");
            writer.WriteLine("  </Cell>                                                                                              ");
            writer.WriteLine("</Row>                                                                                                 ");
            writer.WriteLine("</Table>                                                                                               ");
            writer.WriteLine("<WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">                                    ");
            writer.WriteLine("<Unsynced/>                                                                                            ");
            writer.WriteLine("<Selected/>                                                                                            ");
            writer.WriteLine("<DoNotDisplayGridlines/>                                                                               ");
            writer.WriteLine("<Panes>                                                                                                ");
            writer.WriteLine("<Pane>                                                                                                 ");
            writer.WriteLine("<Number>3</Number>                                                                                     ");
            writer.WriteLine("<ActiveRow>1</ActiveRow>                                                                               ");
            writer.WriteLine("<ActiveCol>1</ActiveCol>                                                                               ");
            writer.WriteLine("</Pane>                                                                                                ");
            writer.WriteLine("</Panes>                                                                                               ");
            writer.WriteLine("<ProtectObjects>False</ProtectObjects>                                                                 ");
            writer.WriteLine("<ProtectScenarios>False</ProtectScenarios>                                                             ");
            writer.WriteLine("</WorksheetOptions>                                                                                    ");
            writer.WriteLine("</Worksheet>                                                                                           ");
            writer.WriteLine("</Workbook>                                                                                            ");
            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();

                }
            }

        }
    }
}