public JsonResult Query(string title, string qtype, string ynpic, string ynanimal, int page = 1, int rows = 20) { Bank bank = new Bank(); PaginModel pm = new PaginModel() { page = page, pagesize = rows }; bool?ispic = null; if (!string.IsNullOrEmpty(ynpic)) { ispic = ynpic == "Y"; } bool?isanimal = null; if (!string.IsNullOrEmpty(ynanimal)) { isanimal = ynanimal == "Y"; } OperateResultModel orm = bank.QueryBanks(title, qtype, ispic, isanimal, true, null, pm); return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Query(string papername, int page = 1, int rows = 20) { Bank bank = new Bank(); PaginModel pm = new PaginModel() { page = page, pagesize = rows }; OperateResultModel orm = bank.QueryPapers(papername, pm); return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Index(string xueyh, string xingming, int page = 1, int rows = 20) { PaginModel pm = new PaginModel() { page = page, pagesize = rows }; Study study = new Study(); OperateResultModel orm = study.QueryTestRecords(xueyh, xingming, pm); return(JsonResultHelper.ConvertToJsonResult(orm)); }
/// <summary> /// 学习记录 /// </summary> /// <param name="xueyh">学员号</param> /// <returns></returns> public JsonResult score(string xueyh, int page = 1) { PaginModel pm = new PaginModel() { page = page, pagesize = 15 }; Study study = new Study(); OperateResultModel orm = study.QueryTestRecords(xueyh, "", pm); return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Index(string username, string userno, int page = 1, int pagesize = 30) { Permission permission = new Permission(); PaginModel pm = new PaginModel() { page = page, pagesize = pagesize }; OperateResultModel orm = permission.QueryUsers(userno, username, pm); return(JsonResultHelper.ConvertToJsonResult(orm)); }
public async Task <IActionResult> GetUsers([FromBody] PaginModel pagin) { //var usersdata = _context.Users.OrderBy(m => m.UserName).Skip(pagin.results * (pagin.page - 1)) // .Select(user => new // { // name = user.UserName, // email = user.Email, // details = user.Details, // country = user.Country, // city = user.City, // address = user.Address, // startstudy = (user.StartStudy == null) ? null : user.StartStudy.Value.ToShortDateString() // }); var qry = _context.Users.OrderBy(m => m.UserName) .Select(user => new { name = user.UserName, email = user.Email, details = user.Details, country = user.Country, city = user.City, address = user.Address, startstudy = (user.StartStudy == null) ? null : user.StartStudy.Value.ToShortDateString() }); if (!string.IsNullOrWhiteSpace(pagin.filter)) { qry = qry.Where(p => p.name.Contains(pagin.filter)); } int count = qry.Count(); var model = await PagingList.CreateAsync( qry, pagin.results, pagin.page, pagin.field, "name"); if (pagin.order == "descend") { model.Reverse(); } // model.RouteValue = new RouteValueDictionary { //{ "filter", pagin.filter} // }; return(Ok(new { all = count, users = model })); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="xueyh">学员号</param> /// <param name="xingming">姓名</param> /// <returns></returns> public OperateResultModel Query(string xueyh, string xingming, PaginModel pm) { List <DBMemberEntity> entities = new List <DBMemberEntity>(); if (!string.IsNullOrEmpty(xueyh)) { entities.AddMember("xueyh", xueyh, QueryTypeEnum.fruzz); } if (!string.IsNullOrEmpty(xingming)) { entities.AddMember("xingming", xingming, QueryTypeEnum.fruzz); } OperateResultModel orm = Query(entities, "createdate desc", pm); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_test_records> >((DataTable)orm.rows); } return(orm); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="userno">用户编号</param> /// <param name="username">用户姓名</param> /// <param name="pm">分页信息</param> /// <returns></returns> public OperateResultModel Query(string userno, string username, PaginModel pm) { List <DBMemberEntity> entitys = new List <DBMemberEntity>(); if (!string.IsNullOrEmpty(userno)) { entitys.AddMember("userno", userno, QueryTypeEnum.fruzz); } if (!string.IsNullOrEmpty(username)) { entitys.AddMember("username", username, QueryTypeEnum.fruzz); } OperateResultModel orm = Query(entitys, "userno", pm); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <sysuser> >((DataTable)orm.rows); } return(orm); }
/// <summary> /// 获取分页List /// </summary> /// <param name="model">分页Model</param> /// <param name="totalCount">记返回总记录数</param> /// <param name="totalPageCount">返回总页数</param> /// <returns>数据集</returns> public DataSet GetPaginList(PaginModel model, out int totalCount, out int totalPageCount) { try { //Database db = DatabaseFactory.CreateDatabase(); Database db = factory.CreateDefault(); DbCommand dbCommand = db.GetStoredProcCommand("Paging"); db.AddInParameter(dbCommand, "TableName", DbType.AnsiString, model.TableName); db.AddInParameter(dbCommand, "FieldList", DbType.AnsiString, model.FieldList); db.AddInParameter(dbCommand, "PrimaryKey", DbType.AnsiString, model.PrimaryKey); db.AddInParameter(dbCommand, "Where", DbType.AnsiString, model.WhereStr); db.AddInParameter(dbCommand, "Order", DbType.AnsiString, model.Order); db.AddInParameter(dbCommand, "SortType", DbType.Int32, model.SortType); db.AddInParameter(dbCommand, "RecorderCount", DbType.Int32, model.RecorderCount); db.AddInParameter(dbCommand, "PageSize", DbType.Int32, model.PageSize); db.AddInParameter(dbCommand, "PageIndex", DbType.Int32, model.PageIndex); db.AddOutParameter(dbCommand, "TotalCount", DbType.Int32, int.MaxValue); db.AddOutParameter(dbCommand, "TotalPageCount", DbType.Int32, int.MaxValue); DataSet ds = db.ExecuteDataSet(dbCommand); totalCount = (int)db.GetParameterValue(dbCommand, "TotalCount"); totalPageCount = (int)db.GetParameterValue(dbCommand, "TotalPageCount"); return(ds); } catch (Exception ex) { Shu.Comm.CMMLog.Error(ex.Message); //HttpContext.Current.Response.Write(ex.Message); // //HttpContext.Current.Response.Redirect("~/SessionError.htm"); //throw new Exception(ex.Message); } totalCount = 0; totalPageCount = 0; return(new DataSet()); }
/// <summary> /// 查询练习记录 /// </summary> /// <param name="xueyh">学员号</param> /// <param name="xingming">姓名</param> /// <returns></returns> public OperateResultModel QueryTestRecords(string xueyh, string xingming, PaginModel pm) { TblTestRecordsDal dal = new TblTestRecordsDal(); return(dal.Query(xueyh, xingming, pm)); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="jiaolh">教练号</param> /// <param name="xingming">姓名</param> /// <param name="shenfhm">身份号码</param> /// <param name="pm">分页信息</param> /// <returns></returns> public OperateResultModel QueryJiaolians(string jiaolh, string xingming, string shenfhm, PaginModel pm) { TblJiaolianDal dal = new TblJiaolianDal(); return(dal.Query(jiaolh, xingming, shenfhm, pm)); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="xueyh">学员号</param> /// <param name="xingming">姓名</param> /// <param name="shenfhm">身份号码</param> /// <param name="pm">分页信息</param> /// <returns></returns> public OperateResultModel Query(string xueyh, string xingming, string shenfhm, PaginModel pm) { List <DBMemberEntity> entities = new List <DBMemberEntity>(); if (!string.IsNullOrEmpty(xueyh)) { entities.AddMember("xueyh", xueyh); } if (!string.IsNullOrEmpty(xingming)) { entities.AddMember("xingming", xingming); } if (!string.IsNullOrEmpty(shenfhm)) { entities.AddMember("shenfhm", shenfhm); } OperateResultModel orm = Query(entities, "xueyh desc", pm); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_xueyuan> >((DataTable)orm.rows); } return(orm); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="title">标题</param> /// <param name="qtype">题型</param> /// <param name="ispic">是否图片题</param> /// <param name="isanimal">是否动画题</param> /// <param name="isOrder">true:顺序 false:随机</param> /// <param name="kemu"> /// 科目 /// KM1:科目一 /// KM4:科目四 /// KMA:客车 /// KMB:货车 /// </param> /// <param name="pm">分页实体</param> /// <returns></returns> public OperateResultModel Query(string title, string qtype, bool?ispic, bool?isanimal, bool isOrder, string kemu, PaginModel pm) { List <DBMemberEntity> members = new List <DBMemberEntity>(); members.AddMember("title", title, QueryTypeEnum.fruzz); if (!string.IsNullOrEmpty(qtype)) { members.AddMember("qtype", qtype); } if (ispic != null) { members.AddMember("picpath", "", QueryTypeEnum.notequal); } if (isanimal != null) { members.AddMember("animepath", "", QueryTypeEnum.notequal); } if (!string.IsNullOrEmpty(kemu)) { switch (kemu) { case "KM1": kemu = "C"; break; case "KM4": kemu = "D"; break; case "KMA": kemu = "A"; break; case "KMB": kemu = "B"; break; default: break; } members.AddMember("belongtype", kemu, QueryTypeEnum.fruzz); } string orderby = "id"; if (!isOrder) { orderby = " NEWID() "; } OperateResultModel orm = Query(members, orderby, pm); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_bank> >((DataTable)orm.rows); } return(orm); }
/// <summary> /// 获取分页List /// </summary> /// <param name="model">分页Model</param> /// <param name="totalCount">记返回总记录数</param> /// <param name="totalPageCount">返回总页数</param> /// <returns>数据集</returns> public DataSet GetPaginList(PaginModel model, out int totalCount, out int totalPageCount) { return(dal.GetPaginList(model, out totalCount, out totalPageCount)); }
/// <summary> /// 查询用户信息 /// </summary> /// <param name="username">用户姓名</param> /// <param name="userno">用户编号</param> /// <param name="pm">分页信息</param> /// <returns></returns> public OperateResultModel QueryUsers(string userno, string username, PaginModel pm) { SysUserDal dal = new SysUserDal(); return(dal.Query(userno, username, pm)); }
public OperateResultModel Query(List <DBMemberEntity> entities, string orderby, PaginModel pm) { string tablename = typeof(T).Name; OperateResultModel orm = dbhelper.Query(tablename, entities, orderby, pm); return(orm); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="xueyh">学员号</param> /// <param name="xingming">姓名</param> /// <param name="shenfhm">身份号码</param> /// <param name="pm">分页信息</param> /// <returns></returns> public OperateResultModel QueryXueyuans(string xueyh, string xingming, string shenfhm, PaginModel pm) { TblXueyuanDal dal = new TblXueyuanDal(); return(dal.Query(xueyh, xingming, shenfhm, pm)); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="title">标题</param> /// <param name="qtype">题型</param> /// <param name="ispic">是否图片题</param> /// <param name="isanimal">是否动画题</param> /// <param name="isorder">true:顺序 false:随机</param> /// <param name="kemu">科目</param> /// <param name="pm">分页实体</param> /// <returns></returns> public OperateResultModel QueryBanks(string title, string qtype, bool?ispic, bool?isanimal, bool isorder, string kemu, PaginModel pm) { TblBankDal dal = new TblBankDal(); return(dal.Query(title, qtype, ispic, isanimal, isorder, kemu, pm)); }