public ActionResult AbnormalPODSearch(AbnormalPODSearchModel model, int?PageIndex)
{
if (model.IsExport)
{
model.Config = ((Projects)ApplicationConfigHelper.GetApplicationConfig()).ProjectCollection.First(p => p.Id == base.UserInfo.ProjectID.ToString()).ModuleCollection.First(m => m.Id == "M001").Tables.TableCollection.First(t => t.Name == "Pod");
return(this.GetAbnormalPODSearchToExcel(model));
}
else if (model.IsExportTrack)
{
return(this.GetAbnormalPODTrackSearchToExcel(model));
}
else
{
var Result = new AKZOService().GetAbnormalPODSearch(new GetAbnormalPODSearchRequest()
{
SqlWhere = this.GetWhere(model), PageSize = UtilConstants.PAGESIZE, PageIndex = PageIndex ?? 0
}).Result;
model.AbnormalTable = Result.AbnormalTable;
model.PageIndex = Result.PageIndex;
model.PageSize = Result.PageSize;
model.PageCount = Result.PageCount;
}
return(View(model));
}
private void GenQueryAbnormalPODSearchModel(AbnormalPODSearchModel model)
{
model.Config = ((Projects)ApplicationConfigHelper.GetApplicationConfig()).ProjectCollection.First(p => p.Id == base.UserInfo.ProjectID.ToString()).ModuleCollection.First(m => m.Id == "M001").Tables.TableCollection.First(t => t.Name == "Pod");
if (base.UserInfo.UserType == 2)
{
model.Customers = ApplicationConfigHelper.GetProjectUserCustomers(base.UserInfo.ProjectID, base.UserInfo.ID)
.Select(c => new SelectListItem()
{
Value = c.CustomerID.ToString(), Text = c.CustomerName
});
}
else if (base.UserInfo.UserType == 0)
{
model.Customers = new List <SelectListItem>()
{
new SelectListItem()
{
Value = base.UserInfo.CustomerOrShipperID.ToString(), Text = ApplicationConfigHelper.GetApplicationCustomers().First(c => c.ID == base.UserInfo.CustomerOrShipperID).Name
}
};
}
else
{
model.Customers = Enumerable.Empty <SelectListItem>();
}
}
public string GetWhere(AbnormalPODSearchModel model)
{
string sql = "";
if (!string.IsNullOrEmpty(model.BeginActualDeliveryDate.ToString()))
{
sql += " AND POD.ActualDeliveryDate>='" + model.BeginActualDeliveryDate.ToString() + "'";
}
if (!string.IsNullOrEmpty(model.EndActualDeliveryDate.ToString()))
{
sql += " AND POD.ActualDeliveryDate<='" + model.EndActualDeliveryDate.ToString() + "'";
}
return(sql);
}
public ActionResult GetAbnormalPODTrackSearchToExcel(AbnormalPODSearchModel model)
{
var Result = new AKZOService().GetAbnormalPODTrackSearchToExcel(new GetAbnormalPODSearchRequest()
{
SqlWhere = this.GetWhere(model)
}).Result;
var columns = ((Projects)ApplicationConfigHelper.GetApplicationConfig()).ProjectCollection.First(p => p.Id == base.UserInfo.ProjectID.ToString()).ModuleCollection.First(m => m.Id == "M001").Tables.TableCollection.First(t => t.Name == "PodTrack")
.ColumnCollection.Where(c => (c.IsKey && c.ForView) || (!c.IsKey && !c.IsHide) || (!c.IsKey && c.IsHide && c.InnerColumns.Any(innerc => innerc.CustomerID == _CustomerID)))
.Select(c =>
{
if (c.InnerColumns.Count == 0)
{
return(c);
}
else
{
if (c.InnerColumns.Any(innerc => innerc.CustomerID == _CustomerID))
{
return(c.InnerColumns.First(innerc => innerc.CustomerID == _CustomerID));
}
return(c);
}
});
return(this.ExportPodTracksToExcel(Result, columns));
//var Result = new AKZOService().GetAbnormalPODTrackSearchToExcel(new GetAbnormalPODSearchRequest() { SqlWhere = this.GetWhere(model) }).Result;
//DataTable Exprottable = Result.AbnormalTable;
//string ReportName = "POD跟踪异常数据报表" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";
//ExcelHelper excelHelper = new ExcelHelper();
//string targetPath = Path.Combine(Runbow.TWS.Common.Constants.UPLOAD_FOLDER_PATH, base.UserInfo.ProjectID.ToString(), "Temp");
//string fileFullPath = Path.Combine(targetPath, ReportName);
//excelHelper.CreateExcelByDataTable(fileFullPath, Exprottable);
//excelHelper.Dispose();
//string mimeType = "application/msexcel";
//FileStream fs = MyFile.Open(fileFullPath, FileMode.Open);
//return File(fs, mimeType, Url.Encode(ReportName));
}
public ActionResult GetAbnormalPODSearchToExcel(AbnormalPODSearchModel model)
{
var podCollection = new AKZOService().GetAbnormalPODSearchToExcel(new GetAbnormalPODSearchRequest()
{
SqlWhere = this.GetWhere(model)
}).Result;
this.GenQueryAbnormalPODSearchModel(model);
long?customerID;
if (model.Customers.Count() == 1)
{
customerID = model.Customers.First().Value.ObjectToInt64();
}
else
{
customerID = model.SearchCondition.CustomerID;
}
return(this.ExportPodsToExcel(podCollection, model.Config.ColumnCollection, customerID));
}
public ActionResult AbnormalPODSearch()
{
AbnormalPODSearchModel model = new AbnormalPODSearchModel();
return(View(model));
}
