public DataTableJsonResult <UserUIModel> GetUserList() { using (var db = new EFContext()) { List <UserUIModel> userlist = db.SysUsers.Where(m => m.IsDelete == 0) .Select(x => new UserUIModel() { UserIdUIModel = x.UserId, UserNickNameUIModel = x.UserNickName, UserPhoneNumberUIModel = x.UserPhoneNumber, UserGenderUIModel = x.UserGender, CreateTimeUIModel = x.CreateTime, IsDisableUIModel = x.IsDisable == 0 ? "正常" : "禁用中", }) .ToList(); DataTableJsonResult <UserUIModel> resultdata = new DataTableJsonResult <UserUIModel>(); resultdata.code = 0; resultdata.data = userlist; resultdata.count = userlist.Count; return(resultdata); } }
public DataTableJsonResult <LectureUIModel> GetLectureList() { using (var db = new EFContext()) { List <LectureUIModel> lecturelist = db.Lecturers.Select(x => new LectureUIModel() { LecturerIdUIModel = x.LecturerId, LecturerNameUIModel = x.LecturerName, LecturerPhoneNumberUIModel = x.LecturerPhoneNumber, LecturerGenderUIModel = x.LecturerGender, IntroductionUIModel = x.Introduction, CreateTimeUIModel = x.CreateTime, }) .ToList(); DataTableJsonResult <LectureUIModel> tableresult = new DataTableJsonResult <LectureUIModel>(); tableresult.code = 0; tableresult.count = lecturelist.Count; tableresult.data = lecturelist; return(tableresult); } }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; var userName = Request.Get("extra_search[UserName]"); var checkUserName = string.IsNullOrWhiteSpace(userName); var createTimeBegin = Request.Get("extra_search[CreateTimeBegin]"); var checkCreateTimeBegin = string.IsNullOrWhiteSpace(createTimeBegin); var createTimeBeginTime = createTimeBegin.To <DateTime>(); var createTimeEnd = Request.Get("extra_search[CreateTimeEnd]"); var checkCreateTimeEnd = string.IsNullOrWhiteSpace(createTimeEnd); var createTimeEndTime = createTimeEnd.To <DateTime>().DayEnd(); Expression <Func <BackupInfo, bool> > expression = l => (checkUserName || l.CreateUserName.Contains(userName)) && (checkCreateTimeBegin || l.CreateTime >= createTimeBeginTime) && (checkCreateTimeEnd || l.CreateTime <= createTimeEndTime); result.data = _currencyService.GetListPaged(pageIndex, pageSize, expression, out totalCount, new OrderModelField { PropertyName = sortColumn, IsDesc = isDesc }); result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public DataTableJsonResult <ProjectSignUIModel> GetProjecSigntrList() { using (var db = new EFContext()) { var projectsignlist = from list in db.ProjectSign join list2 in db.Projects on list.ProjectId equals list2.ProjectId join list3 in db.Students on list.StudentId equals list3.StudentId select new ProjectSignUIModel() { SignTimeUIModel = list.SignTime, ProjectStatusUIModel = list.ProjectStatus, ProjectSignIdUIModel = list.ProjectSignId, GitAddressUIModel = list.GitAddress, ProjectScoreUIModel = list.ProjectScore, ProjectNameUIModel = list2.ProjectName, StudentIdUIModel = list3.StudentId, StudentNameUIModel = list3.StudentName }; DataTableJsonResult <ProjectSignUIModel> tableprosign = new DataTableJsonResult <ProjectSignUIModel>(); tableprosign.code = 0; tableprosign.count = projectsignlist.Count(); tableprosign.data = projectsignlist.ToList(); return(tableprosign); } }
/// <summary> /// 获取导师列表 /// </summary> /// <returns></returns> public ActionResult GetLectureList() { DataTableJsonResult <LectureUIModel> tableresult = lectureservice.GetLectureList(); return(Json(tableresult, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; Expression <Func <User, object> > orderByExpression; //设置排序 switch (sortColumn) { case "CreateTime": orderByExpression = u => new { u.CreateTime }; break; case "PhoneNumber": orderByExpression = u => new { u.PhoneNumber }; break; case "Email": orderByExpression = u => new { u.Email }; break; case "LockoutEnabled": orderByExpression = u => new { u.LockoutEnabled }; break; default: orderByExpression = u => new { u.UserName }; break; } //分页查询 var users = _userContainer.GetListPaged(pageIndex, pageSize, u => u.UserType == UserType.Admin && !u.UserName.Equals(_userContainer.CurrentUser.UserName, StringComparison.OrdinalIgnoreCase), orderByExpression, isDesc, out totalCount); foreach (var user in users) { var tempUser = _userContainer.FindUser(user.UserName); if (tempUser != null) { user.AllRoles = tempUser.AllRoles; } } result.data = users; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 result.draw = Request["draw"].To <int>(); var roles = _roleService.GetAdminRoles(); result.data = roles; result.recordsTotal = roles.Count; result.recordsFiltered = roles.Count; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var applyStateType = Request.Get("extra_search[ApplyStateType]"); var checkApplyStateType = string.IsNullOrWhiteSpace(applyStateType); var applyStateTypeInt = applyStateType.To <int>(); var paymentType = Request.Get("extra_search[PaymentType]"); var checkPaymentType = string.IsNullOrWhiteSpace(paymentType); var paymentTypeInt = paymentType.To <int>(); Expression <Func <Models.CrashApply, bool> > expression = null; expression = c => (checkApplyStateType || (int)c.ApplyState == applyStateTypeInt) && (checkPaymentType || (int)c.PaymentType == paymentTypeInt); Expression <Func <Models.CrashApply, object> > orderByExpression; switch (sortColumn) { case "Money": orderByExpression = c => new { c.Money }; break; case "CreateTime": orderByExpression = c => new { c.CreateTime }; break; default: orderByExpression = c => new { c.CreateTime }; break; } //分页查询 var list = _walletService.GetCrashApplyByPage(pageIndex, pageSize, expression, orderByExpression, isDesc, out totalCount); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var status = Request.Get("extra_search[Status]"); var checkStatus = string.IsNullOrWhiteSpace(status); var title = Request.Get("extra_search[Title]"); var checkTitle = string.IsNullOrWhiteSpace(title); var createName = Request.Get("extra_search[CreateName]"); var checkCreateName = string.IsNullOrWhiteSpace(createName); var createTimeBegin = Request.Get("extra_search[CreateTimeBegin]"); var checkCreateTimeBegin = string.IsNullOrWhiteSpace(createTimeBegin); var createTimeBeginTime = createTimeBegin.To <DateTime>(); var createTimeEnd = Request.Get("extra_search[CreateTimeEnd]"); var checkCreateTimeEnd = string.IsNullOrWhiteSpace(createTimeEnd); var createTimeEndTime = createTimeEnd.To <DateTime>(); Expression <Func <Models.Discovery, bool> > expression = l => (checkTitle || l.Title.Contains(title)) && (checkCreateName || l.CreateName.Contains(createName)) && (checkStatus || ((int)l.Status).ToString().Equals(status)) && (checkCreateTimeBegin || l.CreateTime >= createTimeBeginTime) && (checkCreateTimeEnd || l.CreateTime <= createTimeEndTime) && (l.Status > 0); //分页查询 var list = _currencyService.GetListPaged <Models.Discovery>(pageIndex, pageSize, expression, out totalCount, new OrderModelField { PropertyName = sortColumn, IsDesc = isDesc }); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var moduleKey = Request.Get("extra_search[ModuleKey]"); var checkModuleKey = string.IsNullOrWhiteSpace(moduleKey); var phone = Request.Get("extra_search[Phone]"); var checkPhone = string.IsNullOrWhiteSpace(phone); var message = Request.Get("extra_search[Message]"); var checkMessage = string.IsNullOrWhiteSpace(message); var userName = Request.Get("extra_search[UserName]"); var checkUserName = string.IsNullOrWhiteSpace(userName); var createTimeBegin = Request.Get("extra_search[CreateTimeBegin]"); var checkCreateTimeBegin = string.IsNullOrWhiteSpace(createTimeBegin); var createTimeBeginTime = createTimeBegin.To <DateTime>(); var createTimeEnd = Request.Get("extra_search[CreateTimeEnd]"); var checkCreateTimeEnd = string.IsNullOrWhiteSpace(createTimeEnd); var createTimeEndTime = createTimeEnd.To <DateTime>(); Expression <Func <SmsLog, bool> > expression = l => (checkModuleKey || l.ModuleKey.Equals(moduleKey, StringComparison.OrdinalIgnoreCase)) && (checkPhone || l.Phone.Contains(phone)) && (checkMessage || l.Message.Contains(message)) && (checkUserName || l.UserName.Contains(userName)) && (checkCreateTimeBegin || l.CreateTime >= createTimeBeginTime) && (checkCreateTimeEnd || l.CreateTime <= createTimeEndTime); result.data = _currencyService.GetListPaged(pageIndex, pageSize, expression, out totalCount, new OrderModelField { PropertyName = sortColumn, IsDesc = isDesc }); result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 供选择文件对话框中加载数据 /// </summary> /// <returns></returns> public ActionResult SelectOnPage(int pageIndex, int fileType = 0) { var result = new DataTableJsonResult(); int totalCount; var notCheckFileType = fileType == -1; Expression <Func <StorageFile, bool> > expression = l => l.IsPublic && (notCheckFileType || (int)l.FileType == fileType); result.data = _currencyService.GetListPaged(pageIndex, 20, expression, out totalCount, new OrderModelField { PropertyName = "CreateTime", IsDesc = true }); result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; var list = _systemMessageService.GetSystemMessageListByPage(pageIndex, pageSize, out totalCount); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var orderNo = Request.Get("extra_search[OrderNo]"); var checkOrderNo = string.IsNullOrWhiteSpace(orderNo); var consignee = Request.Get("extra_search[Consignee]"); var checkConsignee = string.IsNullOrWhiteSpace(consignee); var createTimeBegin = Request.Get("extra_search[CreateTimeBegin]"); var checkCreateTimeBegin = string.IsNullOrWhiteSpace(createTimeBegin); var createTimeBeginTime = createTimeBegin.To <DateTime>(); var createTimeEnd = Request.Get("extra_search[CreateTimeEnd]"); var checkCreateTimeEnd = string.IsNullOrWhiteSpace(createTimeEnd); var createTimeEndTime = createTimeEnd.To <DateTime>(); Expression <Func <Order, bool> > expression = l => (checkOrderNo || l.OrderNo.Contains(orderNo)) && (checkConsignee || l.Consignee.Contains(consignee)) && l.OrderStatus != OrderStatus.Deleted && l.RefundStatus == OrderRefundStatus.Refunding && (checkCreateTimeBegin || l.CreateTime >= createTimeBeginTime) && (checkCreateTimeEnd || l.CreateTime <= createTimeEndTime); //分页查询 var list = _currencyService.GetListPaged <Order>(pageIndex, pageSize, expression, out totalCount, new OrderModelField { PropertyName = sortColumn, IsDesc = isDesc }); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var name = Request.Get("extra_search[Name]"); var checkName = string.IsNullOrWhiteSpace(name); var goodsNo = Request.Get("extra_search[GoodsNo]"); var checkGoodsNo = string.IsNullOrWhiteSpace(goodsNo); var status = Request.Get("extra_search[Status]"); var checkStatus = string.IsNullOrWhiteSpace(status); var categoryId = Request.Get("extra_search[CategoryId]"); var checkCategoryId = string.IsNullOrWhiteSpace(categoryId); var config = _configService.Get <SystemConfig>(); Expression <Func <Models.GoodsCategoryNameView, bool> > expression = l => (checkName || l.Name.ToString().Equals(name, StringComparison.OrdinalIgnoreCase)) && (checkGoodsNo || l.GoodsNo.Contains(goodsNo)) && (checkStatus || ((int)l.Status).ToString().Equals(status)) && (checkCategoryId || l.MergerId.Contains(categoryId)) && l.Stock <= config.StockWarning && l.Status != GoodsStatus.Delete; //分页查询 var list = _currencyService.GetListPaged <GoodsCategoryNameView>(pageIndex, pageSize, expression, out totalCount, new OrderModelField { PropertyName = sortColumn, IsDesc = isDesc }); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public DataTableJsonResult <ProjectUIModel> GetProjectList() { using (var db = new EFContext()) { var prolists = from list in db.Projects join list2 in db.Lecturers on list.LecturerId equals list2.LecturerId select new ProjectUIModel() { ProjectIdUIModel = list.ProjectId, ProjectNameUIModel = list.ProjectName, ProjectFrameworkUIModel = list.ProjectFramework, ProdifficultyUIModel = list.Prodifficulty, StudyTimeUIModel = list.StudyTime, LecturerNameUIModel = list2.LecturerName, PalyAddressUIModel = list.PalyAddress, CreateTimeUIModel = list.CreateTime, }; //List <ProjectUIModel> prolist = db.Projects.Join(db.Lecturers,) // .Select(x => new ProjectUIModel() // { // ProjectIdUIModel = x.ProjectId, // ProjectNameUIModel = x.ProjectName, // ProjectFrameworkUIModel = x.ProjectFramework, // ProdifficultyUIModel = x.Prodifficulty, // StudyTimeUIModel = x.StudyTime, // LecturerName = x.GuideTeacher, // PalyAddressUIModel = x.PalyAddress, // CreateTimeUIModel = x.CreateTime, // }) // .ToList(); DataTableJsonResult <ProjectUIModel> tablepro = new DataTableJsonResult <ProjectUIModel>(); tablepro.code = 0; tablepro.count = prolists.Count(); tablepro.data = prolists.ToList(); return(tablepro); } }
public ActionResult ListOnPage() { //return Json("", JsonRequestBehavior.AllowGet); var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var name = Request.Get("extra_search[Name]"); var checkName = string.IsNullOrWhiteSpace(name); Expression <Func <Models.Shipping, bool> > expression = l => ((checkName || l.Name.Equals(name)) && (int)l.Status > (int)ShippingStatus.Delete); Expression <Func <Models.Shipping, object> > orderByExpression; //设置排序 switch (sortColumn) { default: orderByExpression = act => new { act.CreateTime }; break; } //分页查询 var list = _shippingService.GetListPaged(pageIndex, pageSize, expression, orderByExpression, isDesc, out totalCount); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage(WalletType walletType, string memberId) { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //分页查询 var list = _walletService.GetWalletBillByMemberId(memberId, pageIndex, pageSize, out totalCount, walletType); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //分页查询 var list = _currencyService.GetListPaged <GoodsType>(pageIndex, pageSize, out totalCount, new OrderModelField { PropertyName = sortColumn, IsDesc = isDesc }); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GroupListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var name = Request.Get("extra_search[Name]"); var checkName = string.IsNullOrWhiteSpace(name); var goodsNo = Request.Get("extra_search[GoodsNo]"); var checkGoodsNo = string.IsNullOrWhiteSpace(goodsNo); var status = Request.Get("extra_search[Status]"); var checkStatus = string.IsNullOrWhiteSpace(status); Expression <Func <Models.Goods, bool> > expression = l => (l.IsGroupon) && (checkName || l.Name.ToString().Contains(name)) && (checkGoodsNo || l.GoodsNo.Contains(goodsNo)) && (checkStatus || ((int)l.Status).ToString().Equals(status)) && l.Status != GoodsStatus.Delete; //分页查询 var list = _currencyService.GetListPaged <Goods>(pageIndex, pageSize, expression, out totalCount, new OrderModelField { PropertyName = sortColumn, IsDesc = isDesc }).Select(x => new ListShortGoodsModel(x)); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public DataTableJsonResult <StudentUIModel> GetStudentList() { using (var db = new EFContext()) { List <StudentUIModel> stulist = db.Students .Select(x => new StudentUIModel() { StudentIdUIModel = x.StudentId, StudentNameUIModel = x.StudentName, StudentGenderUIModel = x.StudentGender, StudentPhoneNumberUIModel = x.StudentPhoneNumber, CityUIModel = x.City, EducationUIModel = x.Education, CreateTimeUIModel = x.CreateTime, }) .ToList(); DataTableJsonResult <StudentUIModel> tablestu = new DataTableJsonResult <StudentUIModel>(); tablestu.code = 0; tablestu.count = stulist.Count; tablestu.data = stulist; return(tablestu); } }
public ActionResult GetStudentList() { DataTableJsonResult <StudentUIModel> tablestu = studentservice.GetStudentList(); return(Json(tablestu, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage(StatisticalView model) { var result = new DataTableJsonResult(); List <StatisticalReports> statisticalReports = new List <StatisticalReports>(); int draw, pageIndex = 1, pageSize = 10000, totalCount = 1; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var year = Request.Get("extra_search[Year]"); var statisticalway = Request.Get("extra_search[Statisticalway]"); var statisticalwayint = statisticalway.To <int>(); var startTime = Request.Get("extra_search[StartTime]"); DateTime?createTimestartTime = null; if (startTime != "") { createTimestartTime = startTime.To <DateTime>().DayZero(); } var endTime = Request.Get("extra_search[EndTime]"); DateTime?createTimeendTime = null; if (endTime != "") { createTimeendTime = endTime.To <DateTime>().DayEnd(); } var province = Request.Get("extra_search[State_Province]"); var city = Request.Get("extra_search[State_City]"); switch (statisticalwayint) { case 1: //年 { statisticalReports = _statisticalService.YearStatisticalReports(); } break; case 2: //月 { statisticalReports = _statisticalService.MonthStatisticalReports(year); } break; case 3: //区间 { var statistical = _statisticalService.StatisticalReports(createTimestartTime, createTimeendTime); statisticalReports.Add(statistical); } break; case 4: //地区统计 { statisticalReports = _statisticalService.AreaOrderStatisticalReport(province, city); } break; default: break; } result.data = statisticalReports; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 项目报名列表 /// </summary> /// <returns></returns> public ActionResult GetProjecSigntrForList() { DataTableJsonResult <ProjectSignUIModel> tableprosign = projectsignservice.GetProjecSigntrList(); return(Json(tableprosign, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var title = Request.Get("extra_search[Title]"); var checkTitle = string.IsNullOrWhiteSpace(title); var lastUpdateTime = Request.Get("extra_search[LastUpdateTime]"); var checklastUpdateTime = string.IsNullOrWhiteSpace(lastUpdateTime); var createlastUpdateTime = lastUpdateTime.To <DateTime>(); Expression <Func <Models.SinglePage, bool> > expression = l => (checkTitle || l.Title.Contains(title)) && (checklastUpdateTime || l.LastUpdateTime >= createlastUpdateTime); Expression <Func <Models.SinglePage, object> > orderByExpression; //设置排序 switch (sortColumn) { case "Title": orderByExpression = act => new { act.Title }; break; case "LastUpdateTime": orderByExpression = act => new { act.LastUpdateTime }; break; case "SubTitle": orderByExpression = act => new { act.SubTitle }; break; case "Id": orderByExpression = act => new { act.Id }; break; case "Content": orderByExpression = act => new { act.Content }; break; case "key": orderByExpression = act => new { act.Key }; break; default: orderByExpression = act => new { act.Id }; break; } //分页查询 var list = _singlePageService.GetListPaged(pageIndex, pageSize, expression, orderByExpression, isDesc, out totalCount); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取项目列表 /// </summary> /// <returns></returns> public ActionResult GetProjectrList() { DataTableJsonResult <ProjectUIModel> tablepro = projectservice.GetProjectList(); return(Json(tablepro, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { //return Json("", JsonRequestBehavior.AllowGet); var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 //var type = Request.Get("extra_search[FeedbackType]"); //var checkTypeId = string.IsNullOrWhiteSpace(type); var feedbackType = Request.Get("extra_search[FeedbackType]", "1").To <int>(); var sourceType = Request.Get("extra_search[SourceType]"); var checkSourceType = string.IsNullOrWhiteSpace(sourceType); var sourceId = Request.Get("extra_search[SourceId]"); var checkSourceId = string.IsNullOrWhiteSpace(sourceId); var status = Request.Get("extra_search[ProcesseStatus]"); var checkStatus = string.IsNullOrWhiteSpace(status); var statusInt = status.To <int>(); var createTimeBegin = Request.Get("extra_search[CreateTimeBegin]"); var checkCreateTimeBegin = string.IsNullOrWhiteSpace(createTimeBegin); var createTimeBeginTime = createTimeBegin.To <DateTime>(); var createTimeEnd = Request.Get("extra_search[CreateTimeEnd]"); var checkCreateTimeEnd = string.IsNullOrWhiteSpace(createTimeEnd); var createTimeEndTime = createTimeEnd.To <DateTime>(); Expression <Func <Models.Feedback, bool> > expression = l => (checkSourceType || l.SourceType.Equals(sourceType, StringComparison.OrdinalIgnoreCase)) && (checkSourceId || l.SourceId.ToString().Equals(sourceId)) && (int)l.FeedbackType == feedbackType && (checkCreateTimeBegin || l.CreateTime >= createTimeBeginTime) && (checkCreateTimeEnd || l.CreateTime <= createTimeEndTime) && (checkStatus || (int)l.ProcesseStatus == statusInt) && ((int)l.Status > (int)FeedbackStatus.Delete); Expression <Func <Models.Feedback, object> > orderByExpression; //设置排序 switch (sortColumn) { default: orderByExpression = act => new { act.CreateTime }; break; } //分页查询 var list = _feedbackService.GetListPaged(pageIndex, pageSize, expression, orderByExpression, isDesc, out totalCount); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var orderNo = Request.Get("extra_search[OrderNo]"); var checkOrderNo = string.IsNullOrWhiteSpace(orderNo); var consignee = Request.Get("extra_search[Consignee]"); var checkConsignee = string.IsNullOrWhiteSpace(consignee); var memberName = Request.Get("extra_search[MemberName]"); var checkMemberName = string.IsNullOrWhiteSpace(memberName); var orderStatus = Request.Get("extra_search[OrderStatus]"); var checkOrderStatus = string.IsNullOrWhiteSpace(orderStatus); var orderStatusInt = orderStatus.To <int>(); var refundStatus = Request.Get("extra_search[RefundStatus]"); var checkRefundStatus = string.IsNullOrWhiteSpace(refundStatus); var refundStatusInt = refundStatus.To <int>(); var payStatus = Request.Get("extra_search[PayStatus]"); var checkPayStatus = string.IsNullOrWhiteSpace(payStatus); var payStatusInt = payStatus.To <int>(); var shippingStatus = Request.Get("extra_search[ShippingStatus]"); var checkShippingStatus = string.IsNullOrWhiteSpace(shippingStatus); var shippingStatusInt = shippingStatus.To <int>(); var paymentId = Request.Get("extra_search[PaymentId]"); var checkPaymentId = string.IsNullOrWhiteSpace(paymentId); var createTimeBegin = Request.Get("extra_search[CreateTimeBegin]"); var checkCreateTimeBegin = string.IsNullOrWhiteSpace(createTimeBegin); var createTimeBeginTime = createTimeBegin.To <DateTime>(); var createTimeEnd = Request.Get("extra_search[CreateTimeEnd]"); var checkCreateTimeEnd = string.IsNullOrWhiteSpace(createTimeEnd); var createTimeEndTime = createTimeEnd.To <DateTime>(); Expression <Func <Order, bool> > expression = l => (checkOrderNo || l.OrderNo.Contains(orderNo)) && (checkConsignee || l.Consignee.Contains(consignee)) && l.OrderStatus != OrderStatus.Deleted && (checkOrderStatus || (int)l.OrderStatus == orderStatusInt) && (checkRefundStatus || (int)l.RefundStatus == refundStatusInt) && (checkPayStatus || (int)l.PayStatus == payStatusInt) && (checkShippingStatus || (int)l.ShippingStatus == shippingStatusInt) && (checkCreateTimeBegin || l.CreateTime >= createTimeBeginTime) && (checkCreateTimeEnd || l.CreateTime <= createTimeEndTime) && (checkPaymentId || l.PaymentId.ToString() == paymentId) && (checkMemberName || l.MemberName.Contains(memberName)); //分页查询 var list = _currencyService.GetListPaged <Order>(pageIndex, pageSize, expression, out totalCount, new[] { new OrderModelField { PropertyName = sortColumn, IsDesc = isDesc } }, new[] { "OrderGoods" }).Select(o => new ViewModels.SimpleOderModel(o)); result.data = list; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ListOnPage() { var result = new DataTableJsonResult(); //取参数值 int draw, pageIndex, pageSize, totalCount; string sortColumn; bool isDesc; Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc); result.draw = draw; //取查询条件 var userName = Request.Get("extra_search[UserName]"); var checkUserName = string.IsNullOrWhiteSpace(userName); var nickName = Request.Get("extra_search[NickName]"); var checkNickName = string.IsNullOrWhiteSpace(nickName); var sex = Request.Get("extra_search[Sex]"); var checkSex = string.IsNullOrWhiteSpace(sex); var sexInt = sex.To <int>(); var createTimeBegin = Request.Get("extra_search[CreateTimeBegin]"); var checkCreateTimeBegin = string.IsNullOrWhiteSpace(createTimeBegin); var createTimeBeginTime = createTimeBegin.To <DateTime>(); var createTimeEnd = Request.Get("extra_search[CreateTimeEnd]"); var checkCreateTimeEnd = string.IsNullOrWhiteSpace(createTimeEnd); var createTimeEndTime = createTimeEnd.To <DateTime>(); var invitationCode = Request.Get("extra_search[InvitationCode]"); var checkInvitationCode = string.IsNullOrWhiteSpace(invitationCode); var phoneNumber = Request.Get("extra_search[PhoneNumber]"); var checkPhoneNumber = string.IsNullOrWhiteSpace(phoneNumber); var province = Request.Get("extra_search[Order_Province]"); var checkProvince = string.IsNullOrWhiteSpace(province); var city = Request.Get("extra_search[Order_City]"); var checkCity = string.IsNullOrWhiteSpace(city); var buyMoneyMin = Request.Get("extra_search[BuyMoneyMin]"); var checkBuyMoneyMin = string.IsNullOrWhiteSpace(buyMoneyMin) || decimal.Parse(buyMoneyMin) <= 0; var buyMoneyMinDec = 0M; if (!checkBuyMoneyMin) { buyMoneyMinDec = decimal.Parse(buyMoneyMin); } var buyMoneyMax = Request.Get("extra_search[BuyMoneyMax]"); var checkBuyMoneyMax = string.IsNullOrWhiteSpace(buyMoneyMax) || decimal.Parse(buyMoneyMax) <= 0; var buyMoneyMaxDec = 0M; if (!checkBuyMoneyMax) { buyMoneyMaxDec = decimal.Parse(buyMoneyMax); } var integralMin = Request.Get("extra_search[IntegralMin]"); var checkIntegralMin = string.IsNullOrWhiteSpace(integralMin) || decimal.Parse(integralMin) <= 0; var integralMinDec = 0M; if (!checkIntegralMin) { integralMinDec = decimal.Parse(integralMin); } var integralMax = Request.Get("extra_search[IntegralMax]"); var checkIntegralMax = string.IsNullOrWhiteSpace(integralMax) || decimal.Parse(integralMax) <= 0; var integralMaxDec = 0M; if (!checkIntegralMax) { integralMaxDec = decimal.Parse(integralMax); } Expression <Func <MemberFull, bool> > expression = l => (checkUserName || l.UserName.Contains(userName)) && (checkNickName || l.NickName.Contains(nickName)) && (checkPhoneNumber || l.PhoneNumber.Contains(phoneNumber)) && (checkInvitationCode || l.InvitationCode.Contains(invitationCode)) && (checkSex || (int)l.Sex == sexInt) && (checkCreateTimeBegin || l.CreateTime >= createTimeBeginTime) && (checkCreateTimeEnd || l.CreateTime <= createTimeEndTime) && (checkProvince || l.Province == province) && (checkCity || l.City == city) && (checkBuyMoneyMin || l.BuyMoney >= buyMoneyMinDec) && (checkBuyMoneyMax || l.BuyMoney <= buyMoneyMaxDec) && (checkIntegralMin || l.Integral >= integralMinDec) && (checkIntegralMax || l.Integral <= integralMaxDec) && l.UserType == UserType.Member; Expression <Func <MemberFull, object> > orderByExpression; //设置排序 switch (sortColumn) { case "Birthday": orderByExpression = u => new { u.Birthday }; break; case "Sex": orderByExpression = u => new { u.Sex }; break; case "NickName": orderByExpression = u => new { u.NickName }; break; case "CreateTime": orderByExpression = u => new { u.CreateTime }; break; case "PhoneNumber": orderByExpression = u => new { u.PhoneNumber }; break; case "Email": orderByExpression = u => new { u.Email }; break; case "LockoutEnabled": orderByExpression = u => new { u.LockoutEnabled }; break; case "BuyMoney": orderByExpression = u => new { u.BuyMoney }; break; case "OrderCount": orderByExpression = u => new { u.OrderCount }; break; case "Integral": orderByExpression = u => new { u.Integral }; break; default: orderByExpression = u => new { u.UserName }; break; } //分页查询 var members = _memberService.GetMemberFullListPaged(pageIndex, pageSize, expression, orderByExpression, isDesc, out totalCount); result.data = members; result.recordsTotal = totalCount; result.recordsFiltered = totalCount; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetUserList() { DataTableJsonResult <UserUIModel> datatableresult = userservice.GetUserList(); return(Json(datatableresult, JsonRequestBehavior.AllowGet)); }