/// <summary> /// 获取身份认证的分页集合 /// </summary> public PagingDataSet <Identification> GetIdentifications(IdentificationQuery query, int pageIndex, int pageSize) { Sql sql = Sql.Builder.Select("*").From("spb_Identifications"); if (query.UserId > 0) { sql.Where("UserId = @0", query.UserId); } if (query.IdentificationTypeId > 0) { sql.Where("IdentificationTypeId = @0", query.IdentificationTypeId); } if (query.startTime.HasValue) { sql.Where("DateCreated >= @0", query.startTime.Value); } if (query.endTime.HasValue) { sql.Where("DateCreated < @0", query.endTime.Value.AddDays(1)); } if (query.identificationStatus.HasValue) { sql.Where("Status=@0", query.identificationStatus.Value); } sql.OrderBy("DateCreated desc"); return(GetPagingEntities(pageSize, pageIndex, sql)); }
public ActionResult ManageIdentifications(IdentificationQuery query, string userId, int pageSize = 20, int pageIndex = 1) { //标识类型下拉列表 IEnumerable <IdentificationType> identificationTypes = identificationService.GetIdentificationTypes(null); SelectList identificationTypeSelectList = new SelectList(identificationTypes.Select(n => new { text = n.Name, value = n.IdentificationTypeId }), "value", "text"); ViewData["typeSelectList"] = identificationTypeSelectList; //获得所有的认证标识 Dictionary <long, string> identificationTypesDic = identificationTypes.ToDictionary(n => n.IdentificationTypeId, n => n.Name); ViewData["identificationTypesDic"] = identificationTypesDic; //处理userid为query.UserId赋值 if (!string.IsNullOrEmpty(userId)) { if (!string.IsNullOrEmpty(userId.Trim(','))) { query.UserId = long.Parse(userId.Trim(',')); } } //用户选择器默认值 ViewData["userId"] = query.UserId; PagingDataSet <Identification> identifications = identificationService.GetIdentifications(query, pageIndex, pageSize); return(View(identifications)); }
/// <summary> ///分页检索身份认证 /// </summary> ///<param name="query">查询条件</param> /// <param name="pageIndex">当前页码</param> /// <param name="pageSize">每页记录数</param> /// <returns></returns> public PagingDataSet <Identification> GetIdentifications(IdentificationQuery query, int pageIndex, int pageSize) { return(iIdentificationRepository.GetIdentifications(query, pageIndex, pageSize)); }
public ActionResult ManageIdentifications(IdentificationQuery query, string userId, int pageSize = 20, int pageIndex = 1) { //标识类型下拉列表 IEnumerable<IdentificationType> identificationTypes = identificationService.GetIdentificationTypes(null); SelectList identificationTypeSelectList = new SelectList(identificationTypes.Select(n => new { text = n.Name, value = n.IdentificationTypeId }), "value", "text"); ViewData["typeSelectList"] = identificationTypeSelectList; //获得所有的认证标识 Dictionary<long, string> identificationTypesDic = identificationTypes.ToDictionary(n => n.IdentificationTypeId, n => n.Name); ViewData["identificationTypesDic"] = identificationTypesDic; //处理userid为query.UserId赋值 if (!string.IsNullOrEmpty(userId)) { if (!string.IsNullOrEmpty(userId.Trim(','))) { query.UserId = long.Parse(userId.Trim(',')); } } //用户选择器默认值 ViewData["userId"] = query.UserId; PagingDataSet<Identification> identifications = identificationService.GetIdentifications(query, pageIndex, pageSize); return View(identifications); }
/// <summary> ///分页检索身份认证 /// </summary> ///<param name="query">查询条件</param> /// <param name="pageIndex">当前页码</param> /// <param name="pageSize">每页记录数</param> /// <returns></returns> public PagingDataSet<Identification> GetIdentifications(IdentificationQuery query, int pageIndex, int pageSize) { return iIdentificationRepository.GetIdentifications(query, pageIndex, pageSize); }