private void 插入ToolStripMenuItem1_Click(object sender, EventArgs e) { //DataGridView dataGridView2 = new DataGridView(); // this.Load += new EventHandler(Form1_Load); /* DataGridView dataGridView2 = new DataGridView(); * CalendarColumn col = new CalendarColumn();*/ // test f = new test(); chutie f = new chutie(); f.ShowDialog(); }
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(); }
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(); }
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(); }
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(); }