コード例 #1
0
 /// <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);
 }
コード例 #2
0
 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);
 }
コード例 #3
0
        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;
        }