public List <SwitchesReportControllingModel> getControllingByDT(int objectID, DateTime startDate, DateTime endDate)
{
List <SwitchesReportControllingModel> list = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ObjectID", objectID),
new SqlParameter("@StartDate", startDate),
new SqlParameter("@EndDate", endDate),
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("uspGet_EquipmentControllingByDT", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
list = new List <SwitchesReportControllingModel>();
foreach (DataRow row in table.Rows)
{
SwitchesReportControllingModel model = new SwitchesReportControllingModel();
model.Name = row["Name"].ToString();
model.Status = row["Status"].ToString();
model.TotalTime = row["TotalTime"].ToString();
model.StartTime = Convert.ToDateTime(row["StartTime"]);
model.EndTime = Convert.ToDateTime(row["EndTime"]);
list.Add(model);
}
}
}
return(list);
}
public List <SwitchesReportControllingModel> getControllingToday(int objectID)
{
List <SwitchesReportControllingModel> list = new List <SwitchesReportControllingModel>();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ObjectID", objectID), };
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("uspGET_TodayControlling", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
list = new List <SwitchesReportControllingModel>();
foreach (DataRow row in table.Rows)
{
SwitchesReportControllingModel model = new SwitchesReportControllingModel();
model.Name = row["Name"].ToString();
model.Status = row["Status"].ToString();
if (model.Status == "0")
{
model.Status = "OFF";
}
if (model.Status == "1")
{
model.Status = "ON";
}
model.TotalTime = row["TotalTime"].ToString();
model.StartTime = Convert.ToDateTime(row["StartTime"]);
model.EndTime = Convert.ToDateTime(row["EndTime"]);
list.Add(model);
}
}
}
return(list);
}
