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