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