public List <V_BatTime> GetProcedures(string device, DateTime start, DateTime end) { SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100), new SqlParameter("@Start", SqlDbType.DateTime), new SqlParameter("@End", SqlDbType.DateTime) }; parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start); parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end); var entities = new List <V_BatTime>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_BatTime_Repository_GetProcedures2, parms)) { while (rdr.Read()) { var entity = new V_BatTime(); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PackId = SqlTypeConverter.DBNullInt32Handler(rdr["PackId"]); entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]); entity.ProcTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ProcTime"]); entities.Add(entity); } } return(entities); }
public List <V_BatTime> GetValues(DateTime start, DateTime end, EnmBatStatus type) { SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime), new SqlParameter("@End", SqlDbType.DateTime), new SqlParameter("@Type", SqlDbType.Int) }; parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start); parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end); parms[2].Value = (int)type; var entities = new List <V_BatTime>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_BatTime_Repository_GetValues2, parms)) { while (rdr.Read()) { var entity = new V_BatTime(); 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.PackId = SqlTypeConverter.DBNullInt32Handler(rdr["PackId"]); entity.Type = SqlTypeConverter.DBNullBatStatusHandler(rdr["Type"]); entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]); entity.ProcTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ProcTime"]); 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); }