/// <summary> /// Index /// </summary> /// <param name="pageIndex">pageIndex</param> /// <returns>结果</returns> public ActionResult Index(int pageIndex = 1) { string where = null; List<SqlParameter> condition = this.GetConditon(out where); MPagerInParamDAO param = new MPagerInParamDAO() { DataBaseName = "UsermanagedbRead", FieldNames = "KeyID, RoleName,RoleAlias, ModifyTime,AddTime,IsValid,IsDelete", PageIndex = pageIndex, Parameters = condition, PageSize = 20, TableName = "RoleInfo", Sort = "ModifyTime DESC", Condition = where, DataBaseType = DBAccessLayer.Model.MDataBaseType.MYSQL, }; string json = JsonConvert.SerializeObject(param); MPagerReturnDAO result = ServiceFactory.GetPagerContractDAO().PagerQuery(param); List<VMRoleInfo> list = new List<VMRoleInfo>(); if (result != null && result.PageData != null && result.PageData.Rows.Count > 0) { foreach (DataRow row in result.PageData.Rows) { VMRoleInfo model = new VMRoleInfo(); model.KeyID = row["KeyID"].ToString(); model.RoleName = row["RoleName"].ToString(); model.IsValid = Convert.ToInt32(row["IsValid"].ToString()); model.ModifyTime = Convert.ToDateTime(row["ModifyTime"].ToString()); model.AddTime = Convert.ToDateTime(row["AddTime"].ToString()); model.IsDelete = Convert.ToInt32(row["IsDelete"].ToString()); model.RoleAlias = row["RoleAlias"].ToString(); list.Add(model); } } PagedList<VMRoleInfo> pagelist = new PagedList<VMRoleInfo>(list, result.PageIndex, param.PageSize, (int)result.RowCount); return this.View(pagelist); }
private static void TestPagerQuery() { Help.DBAccessLayer.Model.PagerQueryModel.MPagerInParam para = new Help.DBAccessLayer.Model.PagerQueryModel.MPagerInParam() { DataBaseName = "UsermanagedbRead", FieldNames = "*", PageIndex = 1, Parameters = new List<System.Data.SqlClient.SqlParameter>(), Sort = string.Empty, TableName = "RoleInfo", DataBaseType = Help.DBAccessLayer.Model.MDataBaseType.MYSQL, Condition = string.Empty, PageSize = 20, }; BPagerQuery bll = new BPagerQuery(); var ret = bll.PagerQuery(para); }