Beispiel #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            listView1.Clear();
            string str = comboBox1.Text;
            string str_item;
            // Mysql_excute conn = new Mysql_excute();

            DateTime input_1_to;
            DateTime input_1_from;

            //获取输入的时间
            DateTime.TryParse(watermarkTextBox1.Text, out input_1_from);
            DateTime.TryParse(watermarkTextBox2.Text, out input_1_to);

            SqlConnection sqlCnt1 = new SqlConnection(strConn);

            sqlCnt1.Open();

            //获取原料表 表头的记录
            string [] str_yuanliao_header = { "炉号", "入炉原料化学分析时间", "品种",     "TFe", "FeO", "S",      "SiO2", "CaO",  "MgO",   "Al2O3", "P2O5",  "MnO", "TiO2", "R2", "H2O",
                                              "A",  "V",          "fuel_S", "C固",  "P",   "机烧粒度时间", "<5",   "5-10", "10-15", "15-25", "25-40", ">40" };

            //创建高炉操作的查询表头,动态创建
            if (str == "")
            {
                List <string> list  = new List <string>();
                Key_Value     kv    = new Key_Value();
                int           count = 0;
                foreach (var item in kv.MyDictionary)
                {
                    count++;
                    list.Add(item.Key);
                }
                string[] str123 = new string[count];
                str123 = list.ToArray();
                //设置列标题
                for (int i = 0; i < count; ++i)
                {
                    ColumnHeader ch = new ColumnHeader();
                    ch.Text = str123[i];
                    this.listView1.Columns.Add(ch);
                }
                //总表以出铁时间为基准
                //chutie ,
                string sql = string.Format(@"select HeatNum,outIronTime,meterialBatch,theoryYield,yield_1 ,yield_2,difference,type_1,type_1_Si,
type_1_S, type_1_Mn, type_1_P, type_1_Ti, type_2, type_2_Si, type_2_S, type_2_Ti, ironDeep, zhaYang ,
GaoLuOperationTime,waistEastTemp,waistSouthTemp,waistWestTemp,waistNorthTemp ,HearthEastTemp,HearthSouthTemp,
HearthWestTemp,HearthNorthTemp,batchNum ,airtightTemp ,fuelRatio,windVolume ,hotWindpress ,coldWindpress,
windTemp ,toptempSoutheast,toptempSouthwest,toptempNorthwest,toptempNortheast,topPress,breathIndex,OVolume,
requiresCoal,actualCoal,load,Vj ,Vk,coalRatio,COutilization,blastIndex,blastCokeRatio,blastCoalRatio,
blastMineRatio,combustionRatio,JiaoDing,banZu,zhibanren,jiluren,beizhu, 
YuanLiaoTime, pingZhong, TFe, FeO, S, SiO2, CaO, MgO, Al2O3, P2O5, MnO, TiO2, R2, fuel_H2O,
fuel_A, fuel_V, fuel_S, fuel_C, fuel_P, granularityTime, JSLD_Lessthan5, JSLD_5to10, JSLD_10to15,
JSLD_15to25, JSLD_25to40, JSLD_Morethan40 ,VirtualHeatNum, LuZhaTime, slag_SiO2, slag_CaO, slag_MgO, 
slag_Al2O3, slag_R2, slag_R3 from Project_Iron where outIronTime >= '{0}' 
and outIronTime <= '{1}'", input_1_from, input_1_to);

                SqlCommand    sqlCmd1 = new SqlCommand(sql, sqlCnt1);
                SqlDataReader reader  = sqlCmd1.ExecuteReader();

                while (reader.Read())
                {
                    ListViewItem lt = new ListViewItem();
                    lt.Text = reader[0].ToString();
                    for (int i = 1; i < count; ++i)
                    {
                        lt.SubItems.Add(reader[i].ToString());
                    }
                    listView1.Items.Add(lt);
                }
                sqlCnt1.Close();
            }
            else if (str == "原料记录")
            {
                //str_item = "yuanliao";
                string sql = string.Format(@"select HeatNum,YuanLiaoTime, pingZhong,TFe,FeO,S,SiO2,CaO,MgO,Al2O3,P2O5,
MnO,TiO2,R2,fuel_H2O,fuel_A,fuel_V,fuel_S,fuel_C,fuel_P,granularityTime,JSLD_Lessthan5,JSLD_5to10,JSLD_10to15,JSLD_15to25,
JSLD_25to40,JSLD_Morethan40 from Project_Iron where YuanLiaoTime >= '{0}' 
and YuanLiaoTime <= '{1}'", input_1_from, input_1_to);

                SqlCommand    sqlCmd1 = new SqlCommand(sql, sqlCnt1);
                SqlDataReader reader  = sqlCmd1.ExecuteReader();

                for (int i = 0; i < str_yuanliao_header.Length; ++i)
                {
                    ColumnHeader ch = new ColumnHeader();
                    ch.Text = str_yuanliao_header[i];   //设置列标题
                    this.listView1.Columns.Add(ch);
                }
                while (reader.Read())
                {
                    ListViewItem lt = new ListViewItem();
                    lt.Text = reader[0].ToString();
                    for (int i = 1; i < str_yuanliao_header.Length; ++i)
                    {
                        lt.SubItems.Add(reader[i].ToString());
                    }
                    listView1.Items.Add(lt);
                }
                sqlCnt1.Close();
            }
            else if (str == "高炉操作记录")
            {
                str_item = "gaolu_caozuo_qingkuang";
                string       sql      = string.Format(@"select HeatNum,GaoLuOperationTime,waistEastTemp,waistSouthTemp,waistWestTemp,waistNorthTemp ,HearthEastTemp,HearthSouthTemp,
HearthWestTemp,HearthNorthTemp,batchNum ,airtightTemp ,fuelRatio,windVolume ,hotWindpress ,coldWindpress,
windTemp ,toptempSoutheast,toptempSouthwest,toptempNorthwest,toptempNortheast,topPress,breathIndex,OVolume,
requiresCoal,actualCoal,load,Vj ,Vk,coalRatio,COutilization,blastIndex,blastCokeRatio,blastCoalRatio,
blastMineRatio,combustionRatio,JiaoDing,banZu,zhibanren,jiluren,beizhu from Project_Iron where GaoLuOperationTime >= '{0}' 
and GaoLuOperationTime <= '{1}'", input_1_from, input_1_to);
                DataGridView lg_gaolu = new GaoLu().retu_();
                search_fengzhuang(lg_gaolu, sql, ref sqlCnt1, comboBox1.Text);
                sqlCnt1.Close();
            }
            else if (str == "出铁记录")
            {
                str_item = "chutie_qingkuang";
                string sql = string.Format(@"select HeatNum,outIronTime,meterialBatch,theoryYield,yield_1 ,yield_2,difference,type_1,type_1_Si,
type_1_S,type_1_Mn,type_1_P,type_1_Ti,type_2,type_2_Si,type_2_S,type_2_Ti,ironDeep,zhaYang from Project_Iron where outIronTime >= '{0}' 
and outIronTime <= '{1}'", input_1_from, input_1_to);
                //MySqlDataReader DataSet = conn.getmysqlread(sql);
                // SqlCommand sqlCmd1 = new SqlCommand(sql, sqlCnt1);
                //SqlDataReader reader = sqlCmd1.ExecuteReader();

                DataGridView chutie_dgw = new chutie().chutie_retu();
                search_fengzhuang(chutie_dgw, sql, ref sqlCnt1, comboBox1.Text);
                sqlCnt1.Close();
            }
            else if (str == "炉渣记录")
            {
                str_item = "luzha_huaxue_fenxi";
                //创建炉渣查询的表头t
                DataGridView str_lz = new LuZhaFenXi().luzhan_retu();       //改变的

                string sql = string.Format(@"select HeatNum,VirtualHeatNum,LuZhaTime,slag_SiO2,slag_CaO,slag_MgO,slag_Al2O3 ,slag_R2, slag_R3 from Project_Iron where outIronTime >= '{0}' 
and outIronTime <= '{1}'", input_1_from, input_1_to);
                //search_fengzhuang(str_lz, sql, ref sqlCnt1, comboBox1.Text);

                SqlCommand    sqlCmd3 = new SqlCommand(sql, sqlCnt1);
                SqlDataReader DataSet = sqlCmd3.ExecuteReader();
                int           col_len = str_lz.ColumnCount; //改变
                                                            //零时de
                                                            //查出出铁查询的表头
                string[] str_ = new string[col_len + 1];
                str_[0] = "炉号";
                for (int i = 1; i < col_len + 1; ++i)
                {
                    str_[i] = str_lz.Columns[i - 1].HeaderText;           //改变的
                }

                //设置列标题
                for (int i = 0; i < col_len + 1; ++i)
                {
                    ColumnHeader ch = new ColumnHeader();
                    ch.Text = str_[i];
                    this.listView1.Columns.Add(ch);
                }
                while (DataSet.Read())
                {
                    ListViewItem lt = new ListViewItem();
                    // string stt = DataSet[0].ToString() ;
                    // string stt1 = DataSet[1].ToString();
                    lt.Text = DataSet[0].ToString();
                    lt.UseItemStyleForSubItems = false;
                    for (int i = 1; i < col_len; ++i)
                    {
                        lt.SubItems.Add(DataSet[i].ToString());
                    }
                    listView1.Items.Add(lt);
                }
                //sqlCnt1.Close();

                sqlCnt1.Close();
            }
            sqlCnt1.Close();
        }
Beispiel #2
0
        private void temp_fun()
        {
            string str = comboBox1.Text;

            comboBox2.Items.Clear();
            int col_len = 0;

            //原料
            string[] str_yuanliao_header = { "炉号",    "入炉原料化学分析时间", "TFe", "FeO", "SiO2", "CaO",        "MgO",    "P2O5", "MnO",  "TiO2",  "R2",    "A",
                                             "Al2O3", "S",          "C固",  "P",   "V",    "入炉原料化学分析时间", "机烧粒度时间", "<5",   "5-10", "10-15", "15-25",
                                             "25-40", ">40" };
            if (str == "")
            {
                List <string> list  = new List <string>();
                Key_Value     kv1   = new Key_Value();
                int           count = 0;
                foreach (var item in kv1.MyDictionary)
                {
                    count++;
                    list.Add(item.Key);
                }
                string[] str123 = new string[count];
                str123 = list.ToArray();

                for (int i = 0; i < count; ++i)
                {
                    comboBox2.Items.Add(str123[i]);
                }
            }
            else if (str == "原料记录")
            {
                for (int i = 0; i < str_yuanliao_header.Length; ++i)
                {
                    comboBox2.Items.Add(str_yuanliao_header[i]);
                }
            }
            else if (str == "高炉操作记录")
            {
                DataGridView dgw = new GaoLu().retu_();
                col_len = dgw.ColumnCount;       //改变

                //查出出铁查询的表头
                string[] str_gl = new string[col_len];
                for (int i = 0; i < col_len; ++i)
                {
                    str_gl[i] = dgw.Columns[i].HeaderText;           //改变的
                    comboBox2.Items.Add(str_gl[i]);
                }
            }
            else if (str == "出铁记录")
            {
                DataGridView dgw = new chutie().chutie_retu();
                col_len = dgw.ColumnCount;       //改变

                //查出出铁查询的表头
                string[] str_gl = new string[col_len];
                for (int i = 0; i < col_len; ++i)
                {
                    str_gl[i] = dgw.Columns[i].HeaderText;           //改变的
                    comboBox2.Items.Add(str_gl[i]);
                }
            }
            else if (str == "炉渣记录")
            {
                DataGridView dgw = new LuZhaFenXi().luzhan_retu();
                col_len = dgw.ColumnCount;       //改变

                //查出出铁查询的表头
                string[] str_gl = new string[col_len];
                for (int i = 0; i < col_len; ++i)
                {
                    str_gl[i] = dgw.Columns[i].HeaderText;           //改变的
                    comboBox2.Items.Add(str_gl[i]);
                }
            }
            //comboBox2.Text = comboBox2.SelectedItem.ToString();
        }
Beispiel #3
0
        private void 插入炉渣分析数据ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            LuZhaFenXi f = new LuZhaFenXi();

            f.ShowDialog();
        }
Beispiel #4
0
        private void button2_Click(object sender, EventArgs e)
        {
            double input_2_to;
            double input_2_from;
            string input_2_element;

            listView1.Clear();
            string str = comboBox1.Text;

            // Mysql_excute conn = new Mysql_excute();

            double.TryParse(watermarkTextBox3.Text, out input_2_from);
            double.TryParse(watermarkTextBox4.Text, out input_2_to);
            input_2_element = comboBox2.Text.ToString();
            // MySqlDataReader DataSet;
            //获取原料表 表头的记录
            string[] str_yuanliao_header = { "炉号",    "入炉原料化学分析时间", "TFe", "FeO", "SiO2", "CaO",        "MgO",    "P2O5", "MnO",  "TiO2",  "R2",    "A",
                                             "Al2O3", "S",          "C固",  "P",   "V",    "入炉原料化学分析时间", "机烧粒度时间", "<5",   "5-10", "10-15", "15-25",
                                             "25-40", ">40" };
            //SqlConnection sqlCnt2 = new SqlConnection(strConn);
            SqlConnection sqlCnt1 = new SqlConnection(strConn);
            SqlConnection sqlCnt2 = new SqlConnection(strConn);

            sqlCnt1.Open();
            sqlCnt2.Open();
            Key_Value kv     = new Key_Value();
            string    str_tt = comboBox2.Text.ToString();

            //kv.MyDictionary.ContainsKey();
            str_tt = kv.MyDictionary[str_tt];

            //创建高炉操作的查询表头,动态创建
            if (str == "")
            {
                List <string> list  = new List <string>();
                Key_Value     kv1   = new Key_Value();
                int           count = 0;
                foreach (var item in kv1.MyDictionary)
                {
                    count++;
                    list.Add(item.Key);
                }
                string[] str123 = new string[count];
                str123 = list.ToArray();
                //设置列标题
                for (int i = 0; i < count; ++i)
                {
                    ColumnHeader ch = new ColumnHeader();
                    ch.Text = str123[i];
                    this.listView1.Columns.Add(ch);
                }
                //总表以出铁时间为基准
                //chutie ,
                string sql = string.Format(@"select HeatNum,outIronTime,meterialBatch,theoryYield,yield_1 ,yield_2,difference,type_1,type_1_Si,
type_1_S, type_1_Mn, type_1_P, type_1_Ti, type_2, type_2_Si, type_2_S, type_2_Ti, ironDeep, zhaYang ,
GaoLuOperationTime,waistEastTemp,waistSouthTemp,waistWestTemp,waistNorthTemp ,HearthEastTemp,HearthSouthTemp,
HearthWestTemp,HearthNorthTemp,batchNum ,airtightTemp ,fuelRatio,windVolume ,hotWindpress ,coldWindpress,
windTemp ,toptempSoutheast,toptempSouthwest,toptempNorthwest,toptempNortheast,topPress,breathIndex,OVolume,
requiresCoal,actualCoal,load,Vj ,Vk,coalRatio,COutilization,blastIndex,blastCokeRatio,blastCoalRatio,
blastMineRatio,combustionRatio,JiaoDing,banZu,zhibanren,jiluren,beizhu, 
YuanLiaoTime, pingZhong, TFe, FeO, S, SiO2, CaO, MgO, Al2O3, P2O5, MnO, TiO2, R2, fuel_H2O,
fuel_A, fuel_V, fuel_S, fuel_C, fuel_P, granularityTime, JSLD_Lessthan5, JSLD_5to10, JSLD_10to15,
JSLD_15to25, JSLD_25to40, JSLD_Morethan40 ,VirtualHeatNum, LuZhaTime, slag_SiO2, slag_CaO, slag_MgO, 
slag_Al2O3, slag_R2, slag_R3 from Project_Iron where {0} >= {1} 
and {2} <= {3}", kv.MyDictionary[input_2_element], input_2_from, kv.MyDictionary[input_2_element], input_2_to);

                SqlCommand    sqlCmd1 = new SqlCommand(sql, sqlCnt1);
                SqlDataReader reader  = sqlCmd1.ExecuteReader();

                while (reader.Read())
                {
                    ListViewItem lt = new ListViewItem();
                    lt.Text = reader[0].ToString();
                    for (int i = 1; i < count; ++i)
                    {
                        lt.SubItems.Add(reader[i].ToString());
                    }
                    listView1.Items.Add(lt);
                }
                sqlCnt1.Close();
            }
            else if (str == "原料记录")
            {
                index_of = Array.IndexOf(str_yuanliao_header, input_2_element);

                /*string sql1 = string.Format(@"SELECT column_name FROM
                 * INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= Project_Iron LIMIT {1},1", index_of);
                 * // DataSet = conn.getmysqlread(sql1);
                 *
                 * while (DataSet.Read())
                 *  Text = DataSet[0].ToString();*/
                // SqlCommand sqlCmd1 = new SqlCommand(sql1, sqlCnt1);
                //SqlDataReader DataSet = sqlCmd1.ExecuteReader();

                string        sql     = string.Format(@"select HeatNum,YuanLiaoTime,pingZhong,TFe,FeO,S,SiO2,CaO,MgO,Al2O3,P2O5,MnO,TiO2,R2,fuel_H2O,
fuel_A,fuel_V,fuel_S,fuel_C,fuel_P,granularityTime,JSLD_Lessthan5,JSLD_5to10,JSLD_10to15,
JSLD_15to25,JSLD_25to40,JSLD_Morethan40 from Project_Iron where {0} >= {1} 
and {2} <={3}", str_tt, input_2_from, str_tt, input_2_to);
                SqlCommand    sqlCmd2 = new SqlCommand(sql, sqlCnt1);
                SqlDataReader DataSet = sqlCmd2.ExecuteReader();
                for (int i = 0; i < str_yuanliao_header.Length; ++i)
                {
                    ColumnHeader ch = new ColumnHeader();
                    ch.Text = str_yuanliao_header[i];   //设置列标题
                    this.listView1.Columns.Add(ch);
                }
                while (DataSet.Read())
                {
                    ListViewItem lt = new ListViewItem();
                    // string stt = DataSet[0].ToString() ;
                    // string stt1 = DataSet[1].ToString();
                    lt.Text = DataSet[0].ToString();
                    lt.UseItemStyleForSubItems = false;
                    for (int i = 1; i < str_yuanliao_header.Length; ++i)
                    {
                        lt.SubItems.Add(DataSet[i].ToString());
                    }
                    // lt.SubItems[str_yuanliao_header.ToList().IndexOf(input_2_element)].BackColor = Color.Red;
                    // lt.SubItems[str_yuanliao_header.ToList().IndexOf(input_2_element)].ForeColor = Color.Blue;

                    //listView1.Items[j++].SubItems[2].BackColor = Color.Red;
                    listView1.Items.Add(lt);
                }
            }
            else if (str == "高炉操作记录")
            {
                DataGridView dgw     = new GaoLu().retu_();
                int          col_len = dgw.ColumnCount; //改变
                //查出出铁查询的表头
                string[] str_ = new string[col_len];
                for (int i = 0; i < col_len; ++i)
                {
                    str_[i] = dgw.Columns[i].HeaderText;           //改变的
                }
                index_of = Array.IndexOf(str_, input_2_element);

                /* string sql1 = string.Format(@"SELECT column_name FROM
                 * INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= '{0}' LIMIT {1},1", str_item,index_of);
                 *
                 * //DataSet = conn.getmysqlread(sql1);
                 * SqlCommand sqlCmd1 = new SqlCommand(sql1, sqlCnt1);
                 * SqlDataReader DataSet = sqlCmd1.ExecuteReader();
                 * while (DataSet.Read())
                 *   Text = DataSet[0].ToString();*/
                string sql = string.Format(@"select GaoLuOperationTime,waistEastTemp,waistSouthTemp,waistWestTemp,waistNorthTemp ,HearthEastTemp,HearthSouthTemp,
HearthWestTemp,HearthNorthTemp,batchNum ,airtightTemp ,fuelRatio,windVolume ,hotWindpress ,coldWindpress,
windTemp ,toptempSoutheast,toptempSouthwest,toptempNorthwest,toptempNortheast,topPress,breathIndex,OVolume,
requiresCoal,actualCoal,load,Vj ,Vk,coalRatio,COutilization,blastIndex,blastCokeRatio,blastCoalRatio,
blastMineRatio,combustionRatio,JiaoDing,banZu,zhibanren,jiluren,beizhu from Project_Iron where {0} >= {1} 
and {2} <= {3}", str_tt, input_2_from, str_tt, input_2_to);

                DataGridView lg_gaolu = new GaoLu().retu_();
                search_fengzhuang(lg_gaolu, sql, ref sqlCnt2, comboBox2.Text);
                sqlCnt2.Close();
            }
            else if (str == "出铁记录")
            {
                // str_item = "chutie_qingkuang";
                DataGridView dgw     = new chutie().chutie_retu();
                int          col_len = dgw.ColumnCount; //改变

                //查出出铁查询的表头
                string[] str_ = new string[col_len];
                for (int i = 0; i < col_len; ++i)
                {
                    str_[i] = dgw.Columns[i].HeaderText;           //改变的
                }

                /* index_of = Array.IndexOf(str_, input_2_element);
                 * string sql1 = string.Format(@"SELECT column_name FROM
                 * INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= '{0}' LIMIT {1},1",str_item,index_of);
                 * SqlCommand sqlCmd1 = new SqlCommand(sql1, sqlCnt1);
                 * SqlDataReader DataSet = sqlCmd1.ExecuteReader();
                 * while (DataSet.Read())
                 *   Text = DataSet[0].ToString();*/

                string sql = string.Format(@"select HeatNum,outIronTime,meterialBatch,theoryYield,yield_1 ,yield_2,difference,type_1,type_1_Si,
type_1_S,type_1_Mn,type_1_P,type_1_Ti,type_2,type_2_Si,type_2_S,type_2_Ti,ironDeep,zhaYang from Project_Iron where {0} >= {1}
and {2} <= {3}", str_tt, input_2_from, str_tt, input_2_to);
                //SqlCommand sqlCmd2 = new SqlCommand(sql, sqlCnt2);
                // SqlDataReader DataSet = sqlCmd2.ExecuteReader();
                //DataSet = conn.getmysqlread(sql);
                DataGridView chutie_dgw = new chutie().chutie_retu();
                search_fengzhuang(chutie_dgw, sql, ref sqlCnt2, input_2_element);
                sqlCnt2.Close();
            }
            else if (str == "炉渣记录")
            {
                //str_item = "luzha_huaxue_fenxi";
                DataGridView dgw     = new LuZhaFenXi().luzhan_retu();
                int          col_len = dgw.ColumnCount; //改变

                //查出出铁查询的表头
                string[] str_ = new string[col_len];
                for (int i = 0; i < col_len; ++i)
                {
                    str_[i] = dgw.Columns[i].HeaderText;           //改变的
                }

                /* index_of = Array.IndexOf(str_, input_2_element);
                 * string sql1 = string.Format(@"SELECT column_name FROM
                 * INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= '{0}' LIMIT {1},1",str_item,index_of);
                 * SqlCommand sqlCmd1 = new SqlCommand(sql1, sqlCnt1);
                 * SqlDataReader DataSet = sqlCmd1.ExecuteReader();
                 * // DataSet = conn.getmysqlread(sql1);
                 * while (DataSet.Read())
                 *   Text = DataSet[0].ToString();*/
                //创建炉渣查询的表头
                DataGridView str_lz = new LuZhaFenXi().luzhan_retu();       //改变的

                string sql = string.Format(@"select VirtualHeatNum,LuZhaTime,slag_SiO2,slag_CaO,slag_MgO,slag_Al2O3 ,slag_R2, slag_R3 from Project_Iron where {0} >= {1} 
and {2} <= {3}", str_tt, input_2_from, str_tt, input_2_to);
                search_fengzhuang(str_lz, sql, ref sqlCnt2, input_2_element);
            }
            sqlCnt1.Close();
            sqlCnt2.Close();
        }
Beispiel #5
0
        public void button6_Click(object sender, EventArgs e)
        {
            //new 出铁的
            chutie ct = new chutie();

            ct.C_t_qk = new chu_tie_qingkuang();
            ct.ShowDialog();
            //还不能关闭ct,否则后边无法进行元素的使用

            //new 出来高炉的
            GaoLu gl = new GaoLu();

            gl.G_l_c_z = new ShiTiLei.GaoLuCaoZuo();
            gl.ShowDialog();

            //new 出来炉渣的
            LuZhaFenXi lz = new LuZhaFenXi();

            lz.Luzha1 = new ShiTiLei.LuZha();
            lz.ShowDialog();

            //new 出来原料的
            RuLuYuannLiao yl = new RuLuYuannLiao();

            yl.YL1 = new ShiTiLei.YuanLiao();
            yl.ShowDialog();

            SqlConnection sqlCnt1 = new SqlConnection(strConn);

            sqlCnt1.Open();
            //出铁 、高炉、炉渣、原料
            string sql_temp = string.Format(@"insert into Project_Iron (
HeatNum,outIronTime,meterialBatch,theoryYield,yield_1 ,yield_2,difference,type_1,type_1_Si,
type_1_S,type_1_Mn,type_1_P,type_1_Ti,type_2,type_2_Si,type_2_S,type_2_Ti,ironDeep,zhaYang,FlagChuTie, 

GaoLuOperationTime,waistEastTemp,waistSouthTemp,waistWestTemp,waistNorthTemp ,HearthEastTemp,HearthSouthTemp,
HearthWestTemp,HearthNorthTemp,batchNum ,airtightTemp ,fuelRatio,windVolume ,hotWindpress ,coldWindpress,
windTemp ,toptempSoutheast,toptempSouthwest,toptempNorthwest,toptempNortheast,topPress,breathIndex,OVolume,
requiresCoal,actualCoal,load,Vj ,Vk,coalRatio,COutilization,blastIndex,blastCokeRatio,blastCoalRatio,
blastMineRatio,combustionRatio,JiaoDing,banZu,zhibanren,jiluren,beizhu ,FlagGaoLu,         

VirtualHeatNum,LuZhaTime,slag_SiO2,slag_CaO,slag_MgO,slag_Al2O3 ,slag_R2, slag_R3,FlagLuZha,              
YuanLiaoTime,pingZhong,TFe,FeO,S,SiO2,CaO,MgO,Al2O3,P2O5,MnO,TiO2,R2,fuel_H2O,
fuel_A,fuel_V,fuel_S,fuel_C,fuel_P,granularityTime,JSLD_Lessthan5,JSLD_5to10,JSLD_10to15,
JSLD_15to25,JSLD_25to40,JSLD_Morethan40,FlagYuanLiao)values('{0}', '{1}' ,'{2}' ,             
'{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}',
'{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}',
'{35}','{36}','{37}','{38}','{39}','{40}','{41}','{42}','{43}','{44}','{45}','{46}','{47}','{48}','{49}','{50}','{51}','{52}',
'{53}','{54}','{55}','{56}','{57}','{58}','{59}','{60}','{61}','{62}','{63}','{64}','{65}','{66}','{67}','{68}','{69}','{70}',
'{71}','{72}','{73}','{74}','{75}','{76}','{77}','{78}','{79}','{80}','{81}','{82}','{83}','{84}','{85}','{86}','{87}','{88}',
'{89}','{90}','{91}','{92}','{93}','{94}','{95}','{96}')",
                                            ct.C_t_qk.HeatNum1,
                                            ct.C_t_qk.outIronTime_,
                                            ct.C_t_qk.meterialBatch_,
                                            ct.C_t_qk.theoryYield_,
                                            ct.C_t_qk.yield_1_,
                                            ct.C_t_qk.yield_2_,
                                            ct.C_t_qk.difference_,
                                            ct.C_t_qk.type_1_,
                                            ct.C_t_qk.type_1_Si_,
                                            ct.C_t_qk.type_1_S_,
                                            ct.C_t_qk.type_1_Mn_,
                                            ct.C_t_qk.type_1_P_,
                                            ct.C_t_qk.type_1_Ti_,
                                            ct.C_t_qk.type_2_,
                                            ct.C_t_qk.type_2_Si_,
                                            ct.C_t_qk.type_2_S_,
                                            ct.C_t_qk.type_2_Ti_,
                                            ct.C_t_qk.ironDeep_,
                                            ct.C_t_qk.ZhaYang,
                                            1,
                                            gl.G_l_c_z.GaoLuOperationTime1,
                                            gl.G_l_c_z.WaistEastTemp,
                                            gl.G_l_c_z.WaitSouthTemp,
                                            gl.G_l_c_z.WaistWestTemp,
                                            gl.G_l_c_z.WaistNorthTemp,
                                            gl.G_l_c_z.HearthEastTemp1,
                                            gl.G_l_c_z.HearthSouthTemp1,
                                            gl.G_l_c_z.HearthWestTemp1,
                                            gl.G_l_c_z.HearthNorthTemp1,
                                            gl.G_l_c_z.BatchNum,
                                            gl.G_l_c_z.AirtightTemp,
                                            gl.G_l_c_z.FuelRatio,
                                            gl.G_l_c_z.WindVolume,
                                            gl.G_l_c_z.HotWindpress,
                                            gl.G_l_c_z.ColdWindpress,
                                            gl.G_l_c_z.WindTemp,
                                            gl.G_l_c_z.ToptempSoutheast,
                                            gl.G_l_c_z.ToptempSouthwest,
                                            gl.G_l_c_z.ToptempNorthwest,
                                            gl.G_l_c_z.ToptempNortheast,
                                            gl.G_l_c_z.TopPress,
                                            gl.G_l_c_z.BreathIndex,
                                            gl.G_l_c_z.OVolume1,
                                            gl.G_l_c_z.RequiresCoal,
                                            gl.G_l_c_z.ActualCoal,
                                            gl.G_l_c_z.Load,
                                            gl.G_l_c_z.Vj1,
                                            gl.G_l_c_z.Vk1,
                                            gl.G_l_c_z.CoalRatio,
                                            gl.G_l_c_z.COutilization1,
                                            gl.G_l_c_z.BlastIndex,
                                            gl.G_l_c_z.BlastCokeRatio,
                                            gl.G_l_c_z.BlastCoalRatio,
                                            gl.G_l_c_z.BlastMineRatio,
                                            gl.G_l_c_z.CombustionRatio,
                                            gl.G_l_c_z.JiaoDing1,
                                            gl.G_l_c_z.Banzu,
                                            gl.G_l_c_z.Zhibanren,
                                            gl.G_l_c_z.Jiluren,
                                            gl.G_l_c_z.Beizhu,
                                            1,
                                            lz.Luzha1.VirtualHeatNum1,
                                            lz.Luzha1.Datetiem,
                                            lz.Luzha1.Slag_SiO2,
                                            lz.Luzha1.Slag_CaO,
                                            lz.Luzha1.Slag_MgO,
                                            lz.Luzha1.Slag_Al2O3,
                                            lz.Luzha1.Slag_R2,
                                            lz.Luzha1.Slag_R3,
                                            1,
                                            yl.YL1.Datetime,
                                            yl.YL1.PingZhong,
                                            yl.YL1.TFe1,
                                            yl.YL1.FeO1,
                                            yl.YL1.S1,
                                            yl.YL1.SiO21,
                                            yl.YL1.CaO1,
                                            yl.YL1.MgO1,
                                            yl.YL1.Al2O31,
                                            yl.YL1.P2O51,
                                            yl.YL1.MnO1,
                                            yl.YL1.TiO21,
                                            yl.YL1.R21,
                                            yl.YL1.Fuel_H2O,
                                            yl.YL1.Fuel_A,
                                            yl.YL1.Fuel_V,
                                            yl.YL1.Fuel_S,
                                            yl.YL1.Fuel_C,
                                            yl.YL1.Fuel_P,
                                            yl.YL1.GranularityTime1,
                                            yl.YL1.JSLD_Lessthan51,
                                            yl.YL1.JSLD_5to101,
                                            yl.YL1.JSLD_10to151,
                                            yl.YL1.JSLD_15to251,
                                            yl.YL1.JSLD_25to401,
                                            yl.YL1.JSLD_Morethan401,
                                            1
                                            );
            SqlCommand sqlCmd1 = new SqlCommand(sql_temp, sqlCnt1);

            if (sqlCmd1.ExecuteNonQuery() > 0)
            {
                MessageBox.Show("插入成功!");
            }
            sqlCnt1.Close();
            ct.Close();
            gl.Close();
            lz.Close();
            yl.Close();
        }