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