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