Exemplo n.º 1
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();
        }