//public IGenericMgr genericMgr { get; set; }
#region public
public ActionResult Index()
{
TransceiversSearchModel serch=new TransceiversSearchModel ();
serch.TypeLocation="0";
TempData["Display"] = "0";
TempData["TransceiversSearchModel"] = serch;
return View();
}
public ActionResult List(GridCommand command, TransceiversSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.EndDate.ToString()))
{
searchModel.EndDate = DateTime.Now;
}
SearchCacheModel SearchCacheModel= this.ProcessSearchModel(command,searchModel);
searchModel = SearchCacheModel.SearchObject as TransceiversSearchModel;
if (!string.IsNullOrEmpty(searchModel.SAPLocation))
TempData["SAPLocation"] = searchModel.SAPLocation;
TempData["Display"] = searchModel.Level;
//明细列表中所有参数
ViewBag.BeginDate = searchModel.BeginDate;
ViewBag.EndDate = searchModel.EndDate;
ViewBag.TypeLocation = searchModel.TypeLocation;
ViewBag.Level = searchModel.Level;
ViewBag.SAPLocation = searchModel.SAPLocation;
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 (string.IsNullOrEmpty(searchModel.BeginDate.ToString()))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_StartToTimeCanNotBeEmpty);
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 (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 (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);
return View();
}
}
return View();
}
private ReportSearchStatementModel PrepareSearchStatement(GridCommand command, TransceiversSearchModel searchModel)
{
ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel();
reportSearchStatementModel.ProcedureName = "USP_Report_RecSendDeposit";
IList<Location> locationList = GetReportLocations(searchModel.SAPLocation,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[9];
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("@BeginDate", SqlDbType.DateTime);
parameters[6].Value = searchModel.BeginDate;
parameters[7] = new SqlParameter("@EndDate", SqlDbType.DateTime);
parameters[7].Value = searchModel.EndDate;
parameters[8] = new SqlParameter("@IsSummaryBySAPLoc", SqlDbType.Bit);
parameters[8].Value = searchModel.TypeLocation == "1" ? true : false; ;
reportSearchStatementModel.Parameters = parameters;
return reportSearchStatementModel;
}
public ActionResult _AjaxList(GridCommand command, TransceiversSearchModel searchModel)
{
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 (locationList.Count > 200)
{
if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo))
{
return PartialView(new GridModel(new List<Transceivers>()));
}
}
if (itemList.Count > 200)
{
return PartialView(new GridModel(new List<Transceivers>()));
}
if (string.IsNullOrEmpty(searchModel.BeginDate.ToString()))
{
return PartialView(new GridModel(new List<Transceivers>()));
}
if (searchModel.TypeLocation == "0")
{
if (string.IsNullOrEmpty(searchModel.Level))
{
return PartialView(new GridModel(new List<Transceivers>()));
}
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<Transceivers>()));
}
if (string.IsNullOrEmpty(searchModel.itemFrom))
{
if (!string.IsNullOrEmpty(searchModel.itemTo))
{
return PartialView(new GridModel(new List<Transceivers>()));
}
}
if (string.IsNullOrEmpty(searchModel.locationFrom))
{
if (!string.IsNullOrEmpty(searchModel.locationTo))
{
return PartialView(new GridModel(new List<Transceivers>()));
}
}
if (string.IsNullOrEmpty(searchModel.regionFrom))
{
if (!string.IsNullOrEmpty(searchModel.regionTo))
{
return PartialView(new GridModel(new List<Transceivers>()));
}
}
}
else
{
if (string.IsNullOrEmpty(searchModel.SAPLocation))
{
return PartialView(new GridModel(new List<Transceivers>()));
}
}
ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
GridModel<Transceivers> gridModel = GetReportTransceiversAjaxPageData<Transceivers>(reportSearchStatementModel);
return PartialView(gridModel);
}
public ActionResult List(GridCommand command, TransceiversSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.EndDate.ToString()))
{
searchModel.EndDate = DateTime.Now;
}
SearchCacheModel SearchCacheModel = this.ProcessSearchModel(command, searchModel);
searchModel = SearchCacheModel.SearchObject as TransceiversSearchModel;
if (!string.IsNullOrEmpty(searchModel.SAPLocation))
TempData["SAPLocation"] = searchModel.SAPLocation;
TempData["Display"] = searchModel.Level;
//明细列表中所有参数
ViewBag.BeginDate = searchModel.BeginDate;
ViewBag.EndDate = searchModel.EndDate;
ViewBag.TypeLocation = searchModel.TypeLocation;
ViewBag.Level = searchModel.Level;
ViewBag.SAPLocation = searchModel.SAPLocation;
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 (string.IsNullOrEmpty(searchModel.BeginDate.ToString()))
{
SaveWarningMessage("开始时间必填！");
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)
&& string.IsNullOrEmpty(searchModel.TheFactoryFrom) && string.IsNullOrEmpty(searchModel.TheFactoryTo))
{
SaveWarningMessage("请根据条件查询！");
return View();
}
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 (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.TheFactoryFrom))
{
if (!string.IsNullOrEmpty(searchModel.TheFactoryTo))
{
SaveWarningMessage("错误：第一个工厂为空的情况下，不能输入第二个工厂！");
return View();
}
}
if (string.IsNullOrEmpty(searchModel.plantFrom))
{
if (!string.IsNullOrEmpty(searchModel.plantTo))
{
SaveWarningMessage("错误：第一个分厂为空的情况下，不能输入第二个分厂！");
return View();
}
}
}
else
{
if (string.IsNullOrEmpty(searchModel.SAPLocation))
{
SaveWarningMessage("错误：SAP库位查询时，SAP库位不能为空！");
return View();
}
}
return View();
}
public void ExportTransceivers(TransceiversSearchModel searchModel)
{
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = 65350;
ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
GridModel<Transceivers> gridModel = GetReportTransceiversAjaxPageData<Transceivers>(reportSearchStatementModel);
ExportToXLS<Transceivers>("Transceivers", "xls", gridModel.Data != null ? gridModel.Data.ToList() : new List<Transceivers>());
}
