public List <V_BatTime> GetProcedures(DateTime start, DateTime end) { SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime), new SqlParameter("@End", SqlDbType.DateTime) }; parms[0].Value = SqlTypeConverter.DBNullDateTimeChecker(start); parms[1].Value = SqlTypeConverter.DBNullDateTimeChecker(end); var entities = new List <V_BatTime>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_BatTime_Repository_GetProcedures, parms)) { while (rdr.Read()) { var entity = new V_BatTime(); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PackId = SqlTypeConverter.DBNullInt32Handler(rdr["PackId"]); entity.Type = SqlTypeConverter.DBNullBatTypeHandler(rdr["Type"]); entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.EndTime = entity.StartTime; entity.ProcTime = entity.StartTime; entities.Add(entity); } } return(entities); }
public V_BatTime GetPreProcedure(string device, int pack, DateTime start, DateTime end) { SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100), new SqlParameter("@PackId", SqlDbType.Int), new SqlParameter("@Start", SqlDbType.DateTime), new SqlParameter("@End", SqlDbType.DateTime) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(device); parms[1].Value = SqlTypeConverter.DBNullInt32Checker(pack); parms[2].Value = SqlTypeConverter.DBNullDateTimeChecker(start); parms[3].Value = SqlTypeConverter.DBNullDateTimeChecker(end); V_BatTime entity = null; using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_BatTime_Repository_GetPreProcedure, parms)) { if (rdr.Read()) { entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PackId = SqlTypeConverter.DBNullInt32Handler(rdr["PackId"]); entity.Type = SqlTypeConverter.DBNullBatTypeHandler(rdr["Type"]); entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]); entity.ProcTime = entity.StartTime; } } return(entity); }
public List <V_Bat> GetProcDetails(string device, int pack, EnmBatType type, DateTime start, DateTime end) { SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100), new SqlParameter("@PackId", SqlDbType.Int), new SqlParameter("@Type", SqlDbType.Int), new SqlParameter("@Start", SqlDbType.DateTime), new SqlParameter("@End", SqlDbType.DateTime) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(device); parms[1].Value = SqlTypeConverter.DBNullInt32Checker(pack); parms[2].Value = (int)type; parms[3].Value = SqlTypeConverter.DBNullDateTimeChecker(start); parms[4].Value = SqlTypeConverter.DBNullDateTimeChecker(end); var entities = new List <V_Bat>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Bat_Repository_GetProcDetails, parms)) { while (rdr.Read()) { var entity = new V_Bat(); entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]); entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]); entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.PackId = SqlTypeConverter.DBNullInt32Handler(rdr["PackId"]); entity.Type = SqlTypeConverter.DBNullBatTypeHandler(rdr["Type"]); entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]); entity.ValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ValueTime"]); entities.Add(entity); } } return(entities); }