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