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