//public IReportGen reportGen { get; set; }
public ActionResult Index()
{
InventoryAgeSearchModel serch = new InventoryAgeSearchModel();
serch.TypeLocation = "0";
TempData["Display"] = "0";
TempData["InventoryAgeSearchModel"] = serch;
//初始化数据
ViewBag.Range1 = 7;
ViewBag.Range2 = 14;
ViewBag.Range3 = 30;
ViewBag.Range4 = 60;
ViewBag.Range5 = 90;
ViewBag.Range6 = 180;
ViewBag.Range7 = 360;
ViewBag.Range8 = 720;
ViewBag.Range9 = 1080;
ViewBag.Range10 = 1440;
ViewBag.Range11 = 1800;
return View();
}
public ActionResult List(GridCommand command, InventoryAgeSearchModel searchModel)
{
searchModel.Level = ((int)com.Sconit.CodeMaster.LocationLevel.Donotcollect).ToString();
ViewBag.Range1 = searchModel.Range1;
ViewBag.Range2 = searchModel.Range2;
ViewBag.Range3 = searchModel.Range3;
ViewBag.Range4 = searchModel.Range4;
ViewBag.Range5 = searchModel.Range5;
ViewBag.Range6 = searchModel.Range6;
ViewBag.Range7 = searchModel.Range7;
ViewBag.Range8 = searchModel.Range8;
ViewBag.Range9 = searchModel.Range9;
ViewBag.Range10 = searchModel.Range10;
ViewBag.Range11 = searchModel.Range11;
TempData["Display"] = searchModel.Level;
TempData["InventoryAgeSearchModel"] = searchModel;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
IList<Location> locationList = GetReportLocations(searchModel.SAPLocation,searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
if (string.IsNullOrEmpty(ViewBag.Location))
ViewBag.Location = Resources.View.LocationDetailView.LocationDetailView_Location;
else
ViewBag.Location = ViewBag.Location;
if (locationList.Count > 200)
{
if (string.IsNullOrEmpty(searchModel.itemFrom) || string.IsNullOrEmpty(searchModel.itemTo))
{
SaveErrorMessage(Resources.EXT.ControllerLan.Con_ItemCodeCanNotBeEmpty);
return View();
}
}
if (itemList.Count > 200)
{
SaveErrorMessage(Resources.EXT.ControllerLan.Con_PartExceedTwoHundred);
return View();
}
if (searchModel.TypeLocation == "0")
{
if (string.IsNullOrEmpty(searchModel.Level))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_SummaryToCanNotBeEmpty);
return View();
}
if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo) && string.IsNullOrEmpty(searchModel.locationFrom) && string.IsNullOrEmpty(searchModel.locationTo)
&& string.IsNullOrEmpty(searchModel.regionFrom) && string.IsNullOrEmpty(searchModel.regionTo))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_ConditionSearchNeeded);
return View();
}
if (string.IsNullOrEmpty(searchModel.itemFrom))
{
if (!string.IsNullOrEmpty(searchModel.itemTo))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_CanNotInputSecondItemWhenErrorFirstItemIsEmpty);
return View();
}
}
if (string.IsNullOrEmpty(searchModel.locationFrom))
{
if (!string.IsNullOrEmpty(searchModel.locationTo))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_CanNotInputSecondLocationWhenErrorFirstLocationIsEmpty);
return View();
}
}
if (string.IsNullOrEmpty(searchModel.regionFrom))
{
if (!string.IsNullOrEmpty(searchModel.regionTo))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_CanNotInputSecondAreaWhenErrorFirstAreaIsEmpty);
return View();
}
}
}
else
{
if (string.IsNullOrEmpty(searchModel.SAPLocation))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_SAPLocationCanNotBeEmpty_1);
return View();
}
}
return View();
}
private ReportSearchStatementModel PrepareSearchStatement(GridCommand command, InventoryAgeSearchModel searchModel)
{
ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel();
reportSearchStatementModel.ProcedureName = "USP_Report_InventoryAge";
IList<Location> locationList = GetReportLocations(null
,searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
string location = string.Empty;
foreach (var lcoList in locationList)
{
if (location == string.Empty)
{
location = lcoList.Code;
}
else
{
location += "," + lcoList.Code;
}
}
IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
string item = string.Empty;
foreach (var ite in itemList)
{
if (item == string.Empty)
{
item = ite.Code;
}
else
{
item += "," + ite.Code;
}
}
SqlParameter[] parameters = new SqlParameter[19];
parameters[0] = new SqlParameter("@Locations", SqlDbType.VarChar, 8000);
parameters[0].Value = location;
parameters[1] = new SqlParameter("@Items", SqlDbType.VarChar, 8000);
parameters[1].Value = item;
parameters[2] = new SqlParameter("@SortDesc", SqlDbType.VarChar, 50);
parameters[2].Value = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
parameters[3] = new SqlParameter("@PageSize", SqlDbType.Int);
parameters[3].Value = command.PageSize;
parameters[4] = new SqlParameter("@Page", SqlDbType.Int);
parameters[4].Value = command.Page;
parameters[5] = new SqlParameter("@SummaryLevel", SqlDbType.VarChar, 50);
parameters[5].Value = searchModel.Level;
parameters[6] = new SqlParameter("@Range1", SqlDbType.Int);
parameters[6].Value = searchModel.Range1;
parameters[7] = new SqlParameter("@Range2", SqlDbType.Int);
parameters[7].Value = searchModel.Range2;
parameters[8] = new SqlParameter("@Range3", SqlDbType.Int);
parameters[8].Value = searchModel.Range3;
parameters[9] = new SqlParameter("@Range4", SqlDbType.Int);
parameters[9].Value = searchModel.Range4;
parameters[10] = new SqlParameter("@Range5", SqlDbType.Int);
parameters[10].Value = searchModel.Range5;
parameters[11] = new SqlParameter("@Range6", SqlDbType.Int);
parameters[11].Value = searchModel.Range6;
parameters[12] = new SqlParameter("@Range7", SqlDbType.Int);
parameters[12].Value = searchModel.Range7;
parameters[13] = new SqlParameter("@Range8", SqlDbType.Int);
parameters[13].Value = searchModel.Range8;
parameters[14] = new SqlParameter("@Range9", SqlDbType.Int);
parameters[14].Value = searchModel.Range9;
parameters[15] = new SqlParameter("@Range10", SqlDbType.Int);
parameters[15].Value = searchModel.Range10;
parameters[16] = new SqlParameter("@Range11", SqlDbType.Int);
parameters[16].Value = searchModel.Range11;
parameters[17] = new SqlParameter("@IsSummaryBySAPLoc", SqlDbType.Bit);
parameters[17].Value = searchModel.TypeLocation == "1" ? true : false; ;
reportSearchStatementModel.Parameters = parameters;
return reportSearchStatementModel;
}
public ActionResult _AjaxList(GridCommand command, InventoryAgeSearchModel searchModel)
{
searchModel.Level = ((int)com.Sconit.CodeMaster.LocationLevel.Donotcollect).ToString();
IList<Location> locationList = GetReportLocations(null, searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
if (locationList.Count > 200)
{
if (string.IsNullOrEmpty(searchModel.itemFrom) || string.IsNullOrEmpty(searchModel.itemTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
if (itemList.Count > 200)
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
if (searchModel.TypeLocation == "0")
{
if (string.IsNullOrEmpty(searchModel.Level))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo) && string.IsNullOrEmpty(searchModel.locationFrom) && string.IsNullOrEmpty(searchModel.locationTo)
&& string.IsNullOrEmpty(searchModel.regionFrom) && string.IsNullOrEmpty(searchModel.regionTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
if (string.IsNullOrEmpty(searchModel.itemFrom))
{
if (!string.IsNullOrEmpty(searchModel.itemTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
if (string.IsNullOrEmpty(searchModel.locationFrom))
{
if (!string.IsNullOrEmpty(searchModel.locationTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
if (string.IsNullOrEmpty(searchModel.regionFrom))
{
if (!string.IsNullOrEmpty(searchModel.regionTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
}
else
{
if (string.IsNullOrEmpty(searchModel.SAPLocation))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
var list = GetInventoryAgeAjaxPageData<InventoryAge>(reportSearchStatementModel);
var itemCategoryList = this.genericMgr.FindAll<ItemCategory>();
foreach (var listdata in list.Data)
{
listdata.ItemFromDesc = itemMgr.GetCacheItem(listdata.Item).FullDescription;
listdata.MaterialsGroup = itemMgr.GetCacheItem(listdata.Item).MaterialsGroup;
listdata.MaterialsGroupDesc = GetItemCategory(listdata.MaterialsGroup, Sconit.CodeMaster.SubCategory.MaterialsGroup, itemCategoryList).Description;
}
return PartialView(list);
}
public ActionResult Export(InventoryAgeSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value;
searchModel.Level = ((int)com.Sconit.CodeMaster.LocationLevel.Donotcollect).ToString();
IList<Location> locationList = GetReportLocations(null, searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
if (locationList.Count > 200)
{
if (string.IsNullOrEmpty(searchModel.itemFrom) || string.IsNullOrEmpty(searchModel.itemTo))
{
command.PageSize = 0;
}
}
if (itemList.Count > 200)
{
command.PageSize = 0;
}
if (searchModel.TypeLocation == "0")
{
if (string.IsNullOrEmpty(searchModel.Level))
{
command.PageSize = 0;
}
if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo) && string.IsNullOrEmpty(searchModel.locationFrom) && string.IsNullOrEmpty(searchModel.locationTo)
&& string.IsNullOrEmpty(searchModel.regionFrom) && string.IsNullOrEmpty(searchModel.regionTo))
{
command.PageSize = 0;
}
if (string.IsNullOrEmpty(searchModel.itemFrom))
{
if (!string.IsNullOrEmpty(searchModel.itemTo))
{
command.PageSize = 0;
}
}
if (string.IsNullOrEmpty(searchModel.locationFrom))
{
if (!string.IsNullOrEmpty(searchModel.locationTo))
{
command.PageSize = 0;
}
}
if (string.IsNullOrEmpty(searchModel.regionFrom))
{
if (!string.IsNullOrEmpty(searchModel.regionTo))
{
command.PageSize = 0;
}
}
}
else
{
if (string.IsNullOrEmpty(searchModel.SAPLocation))
{
command.PageSize = 0;
}
}
var list = new GridModel<InventoryAge>();
if (command.PageSize != 0)
{
ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
list = GetInventoryAgeAjaxPageData<InventoryAge>(reportSearchStatementModel);
var itemCategoryList = this.genericMgr.FindAll<ItemCategory>();
foreach (var listdata in list.Data)
{
listdata.ItemFromDesc = itemMgr.GetCacheItem(listdata.Item).Description;
listdata.MaterialsGroup = itemMgr.GetCacheItem(listdata.Item).MaterialsGroup;
listdata.MaterialsGroupDesc = GetItemCategory(listdata.MaterialsGroup, Sconit.CodeMaster.SubCategory.MaterialsGroup, itemCategoryList).Description;
}
}
StringBuilder str = new StringBuilder("<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" class=\"display\" id=\"datatable\" width=\"100%\"><thead><tr>");
#region Head
str.Append("<th>"+Resources.EXT.ControllerLan.Con_ItemCode+"</th>");
str.Append("<th>"+Resources.EXT.ControllerLan.Con_ItemDescription+"</th>");
str.Append("<th>"+Resources.EXT.ControllerLan.Con_MaterialGroupDescription+"</th>");
str.Append("<th>" + Resources.EXT.ControllerLan.Con_Location + "</th>");
str.Append("<th>0-" + searchModel.Range1 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range1 + "-" + searchModel.Range2 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range2 + "-" + searchModel.Range3 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range3 + "-" + searchModel.Range4 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range4 + "-" + searchModel.Range5 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range5 + "-" + searchModel.Range6 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range6 + "-" + searchModel.Range7 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range7 + "-" + searchModel.Range8 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range8 + "-" + searchModel.Range9 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range9 + "-" + searchModel.Range10 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range10 + "-" + searchModel.Range11 + Resources.EXT.ControllerLan.Con_DayWord+"</th>");
str.Append("<th>" + searchModel.Range11 + "-" + Resources.EXT.ControllerLan.Con_LaterDate+"</th>");
str.Append("</tr></thead><tbody>");
#endregion
foreach (var las in list.Data)
{
str.Append("<tr>");
str.Append("<td>");
str.Append(las.Item);
str.Append("</td>");
str.Append("<td>");
str.Append(las.ItemFromDesc);
str.Append("</td>");
str.Append("<td>");
str.Append(las.MaterialsGroupDesc);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Location);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range0);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range1);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range2);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range3);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range4);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range5);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range6);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range7);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range8);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range9);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range10);
str.Append("</td>");
str.Append("<td>");
str.Append(las.Range11);
str.Append("</td>");
str.Append("</tr>");
}
str.Append("</tbody></table>");
//ExportToXLS<InventoryAge>("libraryAgeStatements.xls", list.Data.ToList());
return new DownloadFileActionResult(str.ToString(), "LibraryAgeStatement.xls");
}
public ActionResult List(GridCommand command, InventoryAgeSearchModel searchModel)
{
ViewBag.Range1 = searchModel.Range1;
ViewBag.Range2 = searchModel.Range2;
ViewBag.Range3 = searchModel.Range3;
ViewBag.Range4 = searchModel.Range4;
ViewBag.Range5 = searchModel.Range5;
ViewBag.Range6 = searchModel.Range6;
ViewBag.Range7 = searchModel.Range7;
ViewBag.Range8 = searchModel.Range8;
ViewBag.Range9 = searchModel.Range9;
ViewBag.Range10 = searchModel.Range10;
ViewBag.Range11 = searchModel.Range11;
TempData["Display"] = searchModel.Level;
TempData["InventoryAgeSearchModel"] = searchModel;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
IList<Location> locationList = GetReportLocations(searchModel.SAPLocation,searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
if (string.IsNullOrEmpty(ViewBag.Location))
ViewBag.Location = Resources.View.LocationDetailView.LocationDetailView_Location;
else
ViewBag.Location = ViewBag.Location;
if (locationList.Count > 200)
{
if (string.IsNullOrEmpty(searchModel.itemFrom) || string.IsNullOrEmpty(searchModel.itemTo))
{
SaveErrorMessage("物料代码为必选项！");
return View();
}
}
if (itemList.Count > 200)
{
SaveErrorMessage("零件超过200个！");
return View();
}
if (searchModel.TypeLocation == "0")
{
if (string.IsNullOrEmpty(searchModel.Level))
{
SaveWarningMessage("汇总至为必选项！");
return View();
}
if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo) && string.IsNullOrEmpty(searchModel.locationFrom) && string.IsNullOrEmpty(searchModel.locationTo)
&& string.IsNullOrEmpty(searchModel.plantFrom) && string.IsNullOrEmpty(searchModel.plantTo) && string.IsNullOrEmpty(searchModel.regionFrom) && string.IsNullOrEmpty(searchModel.regionTo))
{
SaveWarningMessage("请根据条件查询！");
return View();
}
if (string.IsNullOrEmpty(searchModel.itemFrom))
{
if (!string.IsNullOrEmpty(searchModel.itemTo))
{
SaveWarningMessage("错误：第一个物料为空的情况下，不能输入第二个物料！");
return View();
}
}
if (string.IsNullOrEmpty(searchModel.locationFrom))
{
if (!string.IsNullOrEmpty(searchModel.locationTo))
{
SaveWarningMessage("错误：第一个库位为空的情况下，不能输入第二个库位！");
return View();
}
}
if (string.IsNullOrEmpty(searchModel.regionFrom))
{
if (!string.IsNullOrEmpty(searchModel.regionTo))
{
SaveWarningMessage("错误：第一个区域为空的情况下，不能输入第二个区域！");
return View();
}
}
if (string.IsNullOrEmpty(searchModel.plantFrom))
{
if (!string.IsNullOrEmpty(searchModel.plantTo))
{
SaveWarningMessage("错误：第一个分厂为空的情况下，不能输入第二个分厂！");
return View();
}
}
if (string.IsNullOrEmpty(searchModel.TheFactoryFrom))
{
if (!string.IsNullOrEmpty(searchModel.TheFactoryTo))
{
SaveWarningMessage("错误：第一个工厂为空的情况下，不能输入第二个工厂！");
return View();
}
}
}
else
{
if (string.IsNullOrEmpty(searchModel.SAPLocation))
{
SaveWarningMessage("错误：根据SAP库位查询，SAP库位不能为空！");
return View();
}
}
return View();
}
public ActionResult _AjaxList(GridCommand command, InventoryAgeSearchModel searchModel)
{
IList<Location> locationList = GetReportLocations(null, searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
if (locationList.Count > 200)
{
if (string.IsNullOrEmpty(searchModel.itemFrom) || string.IsNullOrEmpty(searchModel.itemTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
if (itemList.Count > 200)
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
if (searchModel.TypeLocation == "0")
{
if (string.IsNullOrEmpty(searchModel.Level))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo) && string.IsNullOrEmpty(searchModel.locationFrom) && string.IsNullOrEmpty(searchModel.locationTo)
&& string.IsNullOrEmpty(searchModel.plantFrom) && string.IsNullOrEmpty(searchModel.plantTo) && string.IsNullOrEmpty(searchModel.regionFrom) && string.IsNullOrEmpty(searchModel.regionTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
if (string.IsNullOrEmpty(searchModel.itemFrom))
{
if (!string.IsNullOrEmpty(searchModel.itemTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
if (string.IsNullOrEmpty(searchModel.locationFrom))
{
if (!string.IsNullOrEmpty(searchModel.locationTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
if (string.IsNullOrEmpty(searchModel.regionFrom))
{
if (!string.IsNullOrEmpty(searchModel.regionTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
if (string.IsNullOrEmpty(searchModel.plantFrom))
{
if (!string.IsNullOrEmpty(searchModel.plantTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
if (string.IsNullOrEmpty(searchModel.TheFactoryFrom))
{
if (!string.IsNullOrEmpty(searchModel.TheFactoryTo))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
}
else
{
if (string.IsNullOrEmpty(searchModel.SAPLocation))
{
return PartialView(new GridModel(new List<InventoryAge>()));
}
}
ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
GridModel<InventoryAge> gridModel = GetInventoryAgeAjaxPageData<InventoryAge>(reportSearchStatementModel);
return PartialView(gridModel);
}