public BsTableDataSource <LogInfoViewModel> GetLogList(GetLogList request) { if (string.IsNullOrEmpty(request.typename)) { throw new Exception("类型不能为空"); } BsTableDataSource <LogInfoViewModel> rlog = new BsTableDataSource <LogInfoViewModel>(); switch (request.typename) { case "townperson": rlog = GetLogList(request, "防汛防台责任人"); break; case "groupperson": rlog = GetLogList(request, "防汛防台工作组"); break; case "gridperson": rlog = GetLogList(request, "网格责任人"); break; case "transferperson": rlog = GetLogList(request, "转移人员清单"); break; case "picperson": rlog = GetLogList(request, "形势图"); break; } return(rlog); }
public BsTableDataSource <LogInfoViewModel> GetLogList(GetLogList request, string typename) { using (var db = DbFactory.Open()) { var stime = ""; var etime = ""; if (string.IsNullOrEmpty(request.starttime) && string.IsNullOrEmpty(request.starttime)) { stime = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd"); etime = DateTime.Now.ToString("yyyy-MM-dd"); } else { stime = request.starttime; etime = request.endtime; } var builder = db.From <LogInfo>(); builder.Where(w => w.adcd == request.adcd && w.Operation.Contains(typename) && (w.OperationType == OperationTypeEnums.新增 || w.OperationType == OperationTypeEnums.更新)); builder.Where(w => w.tm > Convert.ToDateTime(stime) && w.tm < Convert.ToDateTime(etime)); var count = db.Select(builder).Count; if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "asc") { builder.OrderBy(o => request.Sort); } else if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "desc") { builder.OrderByDescending(o => request.Sort); } else { builder.OrderByDescending(o => o.tm); } var PageSize = request.PageSize == 0 ? 15 : request.PageSize; var PageIndex = request.PageIndex == 0 ? 0 : request.PageIndex * PageSize; builder.Limit(PageIndex, PageSize); var _list = db.Select <LogInfoViewModel>(builder); return(new BsTableDataSource <LogInfoViewModel>() { rows = _list, total = count }); } }
public BsTableDataSource <LogInfoViewModel> GET(GetLogList request) { return(LogMyManager.GetLogList(request)); }