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