private Type TypeCheck <T> ( )
{
var type = typeof(T);
if (mDic.ContainsKey(type) == false)
{
mDic.Add(type, new NamedObjectDict());
}
return(type);
}
public void Working()
{
using (OleDbConnection connection = new OleDbConnection(ConnectionString))
{
connection.Open();
using (OleDbCommand Command = connection.CreateCommand())
{
double val = .0;
foreach (var code in Codes)
{
var five = new PotentialFive();
foreach (var sf in SFS)
{
Command.CommandText = string.Format("Select SUM(JZRJQL),SUM(TZQDQL),SUM(SSCCQL),SUM(YYSSCCQL) from GYYD where HYDM='{0}' AND SFGSQY='{1}'AND TDSYQK='1'", code, sf);
using (var reader = Command.ExecuteReader())
{
if (reader.Read())
{
var values = new PotentialBase()
{
JZRJQL = double.TryParse(reader[0].ToString(), out val) ? val : .0,
TZQDQL = double.TryParse(reader[1].ToString(), out val) ? val : .0,
SSCCQL = double.TryParse(reader[2].ToString(), out val) ? val : .0,
YYSSCCQL = double.TryParse(reader[3].ToString(), out val) ? val : .0
};
switch (sf)
{
case "是":
five.Up = values;
break;
case "否":
five.Down = values;
break;
}
}
}
}
TypeDict.Add(code, five);
SSum = SSum + five;
}
}
connection.Close();
}
}