public IList <RandomExamCountStatistic> GetCountWithOrg(int SuitRange, int OrgID, DateTime DateFrom, DateTime DateTo, int railSystemId, int style) { IList <RandomExamCountStatistic> objList = new List <RandomExamCountStatistic>(); Database db = DatabaseFactory.CreateDatabase(); //DbCommand dbCommand = db.GetStoredProcCommand("USP_EXAM_GRADE_Org_Count"); string sqlCommand = "USP_EXAM_GRADE_Org_Count"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_random_exam_suitrange", DbType.Int32, SuitRange); db.AddInParameter(dbCommand, "p_random_exam_orgid", DbType.Int32, OrgID); db.AddInParameter(dbCommand, "p_random_exam_dateFrom", DbType.DateTime, DateFrom); db.AddInParameter(dbCommand, "p_random_exam_dateTo", DbType.DateTime, DateTo); db.AddInParameter(dbCommand, "p_rail_system_id", DbType.Int32, railSystemId); db.AddInParameter(dbCommand, "p_exam_style", DbType.Int32, style); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { RandomExamCountStatistic obj = CreateModelObject(dataReader); objList.Add(obj); } } return(objList); }
public IList <RandomExamCountStatistic> GetCountWithOrg(int SuitRange, int OrgID, DateTime DateFrom, DateTime DateTo, int railSystemId, int style) { IList <RandomExamCountStatistic> objList = dal.GetCountWithOrg(SuitRange, OrgID, DateFrom, DateTo, railSystemId, style); if (SuitRange == 1) { int sumExamCount = 0; int sumEmployeeCount = 0; foreach (RandomExamCountStatistic statistic in objList) { sumExamCount += statistic.ExamCount; sumEmployeeCount += statistic.EmployeeCount; } RandomExamCountStatistic obj = new RandomExamCountStatistic(); obj.OrgID = 0; obj.OrgName = "ºÏ¼Æ"; obj.ExamCount = sumExamCount; obj.EmployeeCount = sumEmployeeCount; objList.Add(obj); } return(objList); }