private void ConvertToModelManage(IDataReader reader, ClassRegisterManage model) { if (reader["Id"] != DBNull.Value) model.Id = Convert.ToInt32(reader["Id"]); if (reader["ClassId"] != DBNull.Value) model.ClassId = Convert.ToInt32(reader["ClassId"]); if (reader["PlanId"] != DBNull.Value) model.PlanId = Convert.ToInt32(reader["PlanId"]); if (reader["AccountId"] != DBNull.Value) model.AccountId = Convert.ToInt32(reader["AccountId"]); if (reader["Status"] != DBNull.Value) model.Status = Convert.ToInt32(reader["Status"]); if (reader["ApplyRemark"] != DBNull.Value) model.ApplyRemark = reader["ApplyRemark"].ToString(); if (reader["BatchCode"] != DBNull.Value) model.BatchCode = (Guid)(reader["BatchCode"]); if (reader["ManagerId"] != DBNull.Value) model.ManagerId = Convert.ToInt32(reader["ManagerId"]); if (reader["IsPass"] != DBNull.Value) model.IsPass = Convert.ToBoolean(reader["IsPass"]); if (reader["CurrentSchedule"] != DBNull.Value) model.CurrentSchedule = Convert.ToInt32(reader["CurrentSchedule"]); if (reader["TotalSchedule"] != DBNull.Value) model.TotalSchedule = Convert.ToInt32(reader["TotalSchedule"]); if (reader["ReadingScore"] != DBNull.Value) model.ReadingScore = Convert.ToDouble(reader["ReadingScore"]); if (reader["DiscussScore"] != DBNull.Value) model.DiscussScore = Convert.ToDouble(reader["DiscussScore"]); if (reader["HomeWorkScore"] != DBNull.Value) model.HomeWorkScore = Convert.ToDouble(reader["HomeWorkScore"]); if (reader["TestingScore"] != DBNull.Value) model.TestingScore = Convert.ToDouble(reader["TestingScore"]); if (reader["ExaminationScore"] != DBNull.Value) model.ExaminationScore = Convert.ToDouble(reader["ExaminationScore"]); if (reader["CommentScore"] != DBNull.Value) model.CommentScore = Convert.ToDouble(reader["CommentScore"]); if (reader["OtherScore"] != DBNull.Value) model.OtherScore = Convert.ToDouble(reader["OtherScore"]); if (reader["TotalScore"] != DBNull.Value) model.TotalScore = Convert.ToDouble(reader["TotalScore"]); if (reader["Result"] != DBNull.Value) model.Result = Convert.ToInt32(reader["Result"]); if (reader["ResultCreater"] != DBNull.Value) model.ResultCreater = Convert.ToInt32(reader["ResultCreater"]); if (reader["Delflag"] != DBNull.Value) model.Delflag = Convert.ToBoolean(reader["Delflag"]); if (reader["CreateDate"] != DBNull.Value) model.CreateDate = Convert.ToDateTime(reader["CreateDate"]); if (reader["TrainingId"] != DBNull.Value) model.TrainingId = Convert.ToInt32(reader["TrainingId"]); if (reader["RealName"] != DBNull.Value) model.RealName = reader["RealName"].ToString(); if (reader["Nickname"] != DBNull.Value) model.Nickname = reader["Nickname"].ToString(); if (reader["UserName"] != DBNull.Value) model.UserName = reader["UserName"].ToString(); if (reader["TeacherNo"] != DBNull.Value) model.TeacherNo = reader["TeacherNo"].ToString(); if (reader["TTitle"] != DBNull.Value) model.TTitle = reader["TTitle"].ToString(); if (reader["CTitle"] != DBNull.Value) model.CTitle = reader["CTitle"].ToString(); if (reader["SignUpStartTime"] != DBNull.Value) model.SignUpStartTime = Convert.ToDateTime(reader["SignUpStartTime"].ToString()); if (reader["SignUpEndTime"] != DBNull.Value) model.SignUpEndTime = Convert.ToDateTime(reader["SignUpEndTime"].ToString()); if (reader["OpenClassFrom"] != DBNull.Value) model.OpenClassFrom = Convert.ToDateTime(reader["OpenClassFrom"].ToString()); if (reader["OpenClassTo"] != DBNull.Value) model.OpenClassTo = Convert.ToDateTime(reader["OpenClassTo"].ToString()); if (reader["CId"] != DBNull.Value) model.CId = Convert.ToInt32(reader["CId"]); if (reader["People"] != DBNull.Value) model.People = Convert.ToInt32(reader["People"]); if (reader["LimitPeopleCnt"] != DBNull.Value) model.LimitPeopleCnt = Convert.ToInt32(reader["LimitPeopleCnt"]); }
public List<ClassRegisterManage> GetListManage(int pageSize, int pageIndex, string where, string orderBy, out int recordCount) { if (string.IsNullOrEmpty(orderBy)) throw new ArgumentNullException(); StringBuilder s = new StringBuilder(); s.Append(" (select mcr.*,mbi.RealName,ma.Nickname,ma.UserName,mbi.TeacherNo,td.Title as TTitle,cd.Title as CTitle,cd.SignUpStartTime,cd.SignUpEndTime,cd.Id as CId,cd.People,cd.LimitPeopleCnt "); s.Append(" ,cd.OpenClassFrom,cd.OpenClassTo "); s.Append(" from Member_ClassRegister mcr left join Member_Account ma on mcr.AccountId=ma.Id "); s.Append(" left join Member_BaseInfo mbi on ma.Id=mbi.AccountId "); s.Append(" left join Class_Detail cd on mcr.ClassId=cd.Id "); s.Append(" left join Traning_Detail td on mcr.TrainingId=td.Id "); s.Append(" where 1=1 and mcr.Delflag='false' and cd.delflag='false' and td.delflag='false' and td.Status=5 and cd.Status in(3,5,6)"); if (!string.IsNullOrEmpty(where)) s.Append(where); s.Append(" and mcr.Delflag='false' and ma.Delflag='false' and cd.Delflag='false' and td.Delflag='false') as tc "); StringBuilder sb = new StringBuilder(); sb.Append("select COUNT(1) from "); sb.Append(s.ToString()); recordCount = Convert.ToInt32(MSEntLibSqlHelper.ExecuteScalarBySql(sb.ToString())); int start = (pageIndex - 1) * pageSize + 1; int end = pageIndex * pageSize; StringBuilder sql = new StringBuilder(); sql.Append("select * from (select *,ROW_NUMBER() over (order by " + orderBy + ") as [RowNum] from " + s); sql.Append(") as T where [RowNum] between " + start + " and " + end); List<ClassRegisterManage> list = new List<ClassRegisterManage>(); using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql.ToString())) { while (reader.Read()) { ClassRegisterManage model = new ClassRegisterManage(); ConvertToModelManage(reader, model); list.Add(model); } } return list; }