public TransportRecordListModel QueryDailyTransportModel(string clientName, DateTime deliverDate, string received, string paid, string error)
{
TransportRecordListModel listModel = new TransportRecordListModel();
using (SQLDBDataContext context = new SQLDBDataContext())
{
int totalCount = context.TransportRecords.Count(x => (string.IsNullOrEmpty(clientName) || x.ClientName == clientName) &&
x.DeliverDate.Date == deliverDate);
listModel.TotalCount = totalCount;
if (totalCount % TransportRecordListModel.PageSize > 0)
{
listModel.TotalPage++;
}
if (listModel.TotalPage < 1)
{
listModel.TotalPage = 1;
}
listModel.ClientName = clientName;
listModel.DeliverDate = deliverDate;
listModel.ItemList = (from x in context.TransportRecords
orderby x.ID descending
where (string.IsNullOrEmpty(clientName) || x.ClientName == clientName) &&
x.DeliverDate.Date == deliverDate &&
((received == "Y" && x.Received) || (received == "N" && !x.Received) || (received != "Y" && received != "N")) &&
((paid == "Y" && x.Paid) || (paid == "N" && !x.Paid) || (paid != "Y" && paid != "N")) &&
((error == "Y" && x.Error) || (error == "N" && !x.Error) || (error != "Y" && error != "N"))
select new TransportRecordModel()
{
ID = x.ID,
AccountPayble = x.AccountPayble,
CarLicense = x.CarLicense,
ClientName = x.ClientName,
Comment = x.Comment,
Deductions = x.Deductions,
DeliverDate = x.DeliverDate,
DeliverPrice = x.DeliverPrice,
DeliverType = x.DeliverType,
Driver = x.Driver,
FromLocation = x.FromLocation,
HandlingFee = x.HandlingFee,
PackageName = x.PackageName,
PayDate = x.PayDate,
PrePay = x.PrePay,
Quantity = x.Quantity,
Reparations = x.Reparations,
ShortBargeFee = x.ShortBargeFee,
Status = x.Status,
ToLocation = x.ToLocation,
Volume = x.Volume,
TrayNo = x.TrayNo,
OilCard = x.OilCard,
BusinessArea = x.BusinessArea,
Error = x.Error,
Received = x.Received,
Paid = x.Paid,
ReceivedDate = x.ReceivedDate
}).ToList();
}
return(listModel);
}
public ActionResult ExcelLocalReport()
{
string clientName = TryGetRequiredString("ClientName");
string deliverDate = TryGetRequiredString("DeliverDate");
string received = TryGetRequiredString("received");
string paid = TryGetRequiredString("paid");
string error = TryGetRequiredString("error");
DateTime dtDeliverDate;
if (!DateTime.TryParse(deliverDate, out dtDeliverDate))
{
ViewBag.ErrorMessage = "必须选中一个日期才能导出日报表";
return(View("Error"));
}
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "GBK";
Response.ContentEncoding = Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + deliverDate + "_" + clientName + ".xls");
if (clientName == "NA")
{
clientName = string.Empty;
}
TransportRecordListModel model = businessProvider.QueryDailyTransportModel(clientName, dtDeliverDate, received, paid, error);
return(View(model));
}
public ActionResult Index(TransportRecordListModel model, int page = 1)
{
ViewBag.Clients = CreateClientListForQuery();
model = businessProvider.QueryTransportModel(model.ClientName, model.DeliverDate, model.Received, model.Paid, model.Error, page);
return(View(model));
}
public ActionResult LocalTransportRecordList(TransportRecordListModel model, int page = 1)
{
ViewBag.Clients = CreateClientListForQuery();
model = businessProvider.QueryTransportModel(model.ClientName, model.DeliverDate, model.Received, model.Paid, model.Error, page, ((UserModel)ViewBag.LoggedUser).Area);
return(View(model));
}
public TransportRecordListModel QueryTransportModel(string clientName, DateTime?deliverDate, string received, string paid, string error, int pageIndex, BusinessAreaModel area)
{
TransportRecordListModel listModel = new TransportRecordListModel();
if (pageIndex < 1)
{
pageIndex = 1;
}
using (SQLDBDataContext context = new SQLDBDataContext())
{
bool checkDeliverDate = deliverDate.HasValue;
DateTime dd = DateTime.MinValue;
if (checkDeliverDate)
{
dd = deliverDate.Value;
}
string areaName = string.Empty;
if (area != null)
{
areaName = area.AreaName;
}
int totalCount = context.TransportRecords.Count(x => (string.IsNullOrEmpty(clientName) || x.ClientName == clientName) &&
(!checkDeliverDate || x.DeliverDate.Date == dd) && (string.IsNullOrEmpty(areaName) || x.BusinessArea == areaName));
listModel.TotalCount = totalCount;
listModel.TotalPage = totalCount / TransportRecordListModel.PageSize;
listModel.PageIndex = pageIndex;
if (totalCount % TransportRecordListModel.PageSize > 0)
{
listModel.TotalPage++;
}
if (listModel.TotalPage < 1)
{
listModel.TotalPage = 1;
}
if (pageIndex > listModel.TotalPage)
{
pageIndex = listModel.TotalPage;
}
int startIndex = (pageIndex - 1) * TransportRecordListModel.PageSize;
listModel.ClientName = clientName;
listModel.DeliverDate = deliverDate;
listModel.ItemList = (from x in context.TransportRecords
orderby x.ID descending
where (string.IsNullOrEmpty(clientName) || x.ClientName == clientName) &&
(!checkDeliverDate || x.DeliverDate.Date == dd) &&
(string.IsNullOrEmpty(areaName) || x.BusinessArea == areaName) &&
((received == "Y" && x.Received) || (received == "N" && !x.Received) || (received != "Y" && received != "N")) &&
((paid == "Y" && x.Paid) || (paid == "N" && !x.Paid) || (paid != "Y" && paid != "N")) &&
((error == "Y" && x.Error) || (error == "N" && !x.Error) || (error != "Y" && error != "N"))
select new TransportRecordModel()
{
ID = x.ID,
AccountPayble = x.AccountPayble,
CarLicense = x.CarLicense,
ClientName = x.ClientName,
Comment = x.Comment,
Deductions = x.Deductions,
DeliverDate = x.DeliverDate,
DeliverPrice = x.DeliverPrice,
DeliverType = x.DeliverType,
Driver = x.Driver,
FromLocation = x.FromLocation,
HandlingFee = x.HandlingFee,
PackageName = x.PackageName,
PayDate = x.PayDate,
PrePay = x.PrePay,
Quantity = x.Quantity,
Reparations = x.Reparations,
ShortBargeFee = x.ShortBargeFee,
Status = x.Status,
ToLocation = x.ToLocation,
Volume = x.Volume,
TrayNo = x.TrayNo,
OilCard = x.OilCard,
BusinessArea = x.BusinessArea,
Error = x.Error,
Paid = x.Paid,
Received = x.Received,
ReceivedDate = x.ReceivedDate,
HistoryItem = (from y in x.TransportRecordsOptionHistory
orderby y.LogDateTime
select new TransportRecordsHistoryModel()
{
Description = y.Description,
LogDateTime = y.LogDateTime,
Operation = y.Operation,
TransportRecordID = y.TransportRecordID,
UserID = y.UserID,
User = new UserModel()
{
Comment = y.Users.Comment,
CreateDateTime = y.Users.CreateDateTime,
LastLoginIP = y.Users.LastLoginIP,
LastLoginTime = y.Users.LastLoginTime,
AreaID = y.Users.AreaID,
Area = new BusinessAreaModel()
{
AreaName = y.Users.BusinessArea.AreaName,
ID = y.Users.BusinessArea.ID
},
Name = y.Users.Name,
Password = y.Users.Password,
RoleID = y.Users.RoleId,
UserID = y.Users.UserID,
Role = new RoleModel()
{
RoleID = y.Users.Roles.RoleID,
RoleName = y.Users.Roles.RoleName
}
}
}).ToList()
}).Skip(startIndex).Take(TransportRecordListModel.PageSize).ToList();
}
return(listModel);
}
