public void Save(质量日报内容 n)
{
conn.Open();
conn.Close();
}
public 质量日报内容 GetRiReport(DateTime riqi)
{
质量日报内容 result = new 质量日报内容(riqi);
StringBuilder sbSql = new StringBuilder();
sbSql.AppendLine("SELECT MC,round(avg(TFE),3),round(avg(SIO),3),round(avg(CAO),3),round(avg(FEO),3),round(avg(MGO),3),round(avg(S),3),round(avg(ALO),3),round(avg(TIO2),3),round(avg(P),3),round(avg(MNO),3),round(avg(CR),3),round(avg(PB),3),round(avg(ZN),3),round(avg(JJS),3),round(avg(V2O5),3),round(avg(CU),3),round(avg(MO),3),round(avg(NI),3),round(avg(SN),3),round(avg(SB),3),round(avg(AS1),3),round(avg(JD),3) FROM DDYL WHERE trunc(SJ) =to_date(:RQ) and mc not like '%高炉机烧%' group by mc");
// sbSql.AppendLine("FROM DDYL WHERE trunc(SJ) = :RQ)");
conn.Open();
OracleCommand cmduery = new OracleCommand(sbSql.ToString(), conn);
cmduery.Parameters.Add(":RQ", OracleType.DateTime).Value = riqi;
OracleDataReader dr = cmduery.ExecuteReader();
while (dr.Read())
{
质量日报内容项 x = new 质量日报内容项(dr.GetString(0));
x.TFE = dr.IsDBNull(1) ? null : (double?)dr.GetDouble(1);
x.SiO2 = dr.IsDBNull(2) ? null : (double?)dr.GetDouble(2);
x.CaO = dr.IsDBNull(3) ? null : (double?)dr.GetDouble(3);
x.FeO = dr.IsDBNull(4) ? null : (double?)dr.GetDouble(4);
x.MgO = dr.IsDBNull(5) ? null : (double?)dr.GetDouble(5);
x.S = dr.IsDBNull(6) ? null : (double?)dr.GetDouble(6);
x.Al2O3 = dr.IsDBNull(7) ? null : (double?)dr.GetDouble(7);
x.TiO2 = dr.IsDBNull(8) ? null : (double?)dr.GetDouble(8);
x.P = dr.IsDBNull(9) ? null : (double?)dr.GetDouble(9);
x.MnO = dr.IsDBNull(10) ? null : (double?)dr.GetDouble(10);
x.Cr = dr.IsDBNull(11) ? null : (double?)dr.GetDouble(11);
x.Pb = dr.IsDBNull(12) ? null : (double?)dr.GetDouble(12);
x.Zn = dr.IsDBNull(13) ? null : (double?)dr.GetDouble(13);
x.JJS = dr.IsDBNull(14) ? null : (double?)dr.GetDouble(14);
x.V2O5 = dr.IsDBNull(15) ? null : (double?)dr.GetDouble(15);
x.Cu = dr.IsDBNull(16) ? null : (double?)dr.GetDouble(16);
x.Mo = dr.IsDBNull(17) ? null : (double?)dr.GetDouble(17);
x.Ni = dr.IsDBNull(18) ? null : (double?)dr.GetDouble(18);
x.Sn = dr.IsDBNull(19) ? null : (double?)dr.GetDouble(19);
x.Sb = dr.IsDBNull(20) ? null : (double?)dr.GetDouble(20);
x.As = dr.IsDBNull(21) ? null : (double?)dr.GetDouble(21);
x.R = dr.IsDBNull(22) ? null : (double?)dr.GetDouble(22);
result.Add(x);
}
dr.Close();
conn.Close();
return(result);
}
