/// <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);
}
