/// <summary> /// 获取管理审核列表 /// </summary> /// <param name="pc"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="total"></param> /// <returns></returns> public List<PracticalCourseListModel> GetMPCourseList(PracticalCourseSearchModel pc, int OrganId, int pageIndex, int pageSize, out int total) { return dal.GetMPCourseList(pc,OrganId, pageIndex, pageSize, out total); }
public ActionResult PracticalCourseList(int? pageIndex, string searchTitle, string state) { ViewBag.Title = "实践课程管理"; int i = TypeConverter.ObjectToInt(pageIndex, 1); PracticalCourseSearchModel psmodel = new PracticalCourseSearchModel(); psmodel.SearchTitle = Utils.ChkSQL(searchTitle); psmodel.State = TypeConverter.StrToInt(state, -1); Member_PracticalCourseBLL mpcBLL = new Member_PracticalCourseBLL(); int total = 0; int OrganId = Code.SiteCache.Instance.ManageOrganId; var data = mpcBLL.GetMPCourseList(psmodel,OrganId, i, 10, out total); ViewData["pc_searchTitle"] = string.IsNullOrEmpty(searchTitle) ? "" : searchTitle; ViewData["pc_state"] = psmodel.State; ViewBag.pageIndex = i; ViewBag.totalPage = total; return View(data); }
public List<PracticalCourseListModel> GetMPCourseList(PracticalCourseSearchModel pc,int OrganId, int pageIndex, int pageSize, out int total) { List<PracticalCourseListModel> list = new List<PracticalCourseListModel>(); string condition = " and OrganId='" + OrganId + "'";// " and (delflag = 0) "; if (!string.IsNullOrEmpty(pc.SearchTitle)) condition += " and (Nickname like '%" + pc.SearchTitle + "%' or TeacherNo like '%" + pc.SearchTitle + "%' or CredentialsNumber like '%" + pc.SearchTitle + "%' or Title like'%" + pc.SearchTitle + "%' )"; if (pc.State != -1) condition += " and Status = " + pc.State; if(!string.IsNullOrEmpty(pc.Where)) condition += pc.Where; total = 0; IDataParameter[] parms = new IDataParameter[] { new SqlParameter("@QueryFields", "*"), new SqlParameter("@QueryTb", "v_MemPraCourseList"), new SqlParameter("@Condition", condition), new SqlParameter("@SortCondition", " id desc "), new SqlParameter("@PageIndex", pageIndex), new SqlParameter("@PageSize", pageSize) }; using (IDataReader dr = MSEntLibSqlHelper.ExecuteDataReaderByStoredProc("sp_pager", parms)) { while (dr.Read()) { PracticalCourseListModel m = new PracticalCourseListModel(); m.Id = Convert.ToInt32(dr["id"]); m.Title = dr["Title"].ToString(); m.UserName = dr["UserName"].ToString(); m.Nickname = dr["Nickname"].ToString(); m.TeacherNo = dr["TeacherNo"].ToString(); m.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString()); if (!string.IsNullOrEmpty(dr["TraingCategory"].ToString())) { m.TraingCategory = Convert.ToInt32(dr["TraingCategory"]); } if (!string.IsNullOrEmpty(dr["TraingCategory"].ToString())) { m.TraingTopic = Convert.ToInt32(dr["TraingTopic"]); } if (dr["OrganId"] != null) { m.OrganId = Convert.ToInt32(dr["OrganId"].ToString()); } if (dr["Credits"] != null) { m.Credits = dr["Credits"].ToString(); } if (dr["OrganId"] != null) { m.OrganId = Convert.ToInt32(dr["OrganId"].ToString()); } if (!string.IsNullOrEmpty(dr["Creater"].ToString())) { m.Creater = Convert.ToInt32(dr["Creater"].ToString()); } else { m.Creater = Convert.ToInt32(dr["AccountId"].ToString()); } m.Status = Convert.ToInt32(dr["Status"].ToString()); list.Add(m); } if (dr.NextResult() && dr.Read()) { total = Convert.ToInt32(dr[0]); } } return list; }