private ReportSearchStatementModel PrepareSearchStatement(GridCommand command, HistoryInventorySearchModel searchModel) { ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel(); reportSearchStatementModel.ProcedureName = "USP_Report_GetHistoryInv"; IList<Location> locationList = GetReportLocations(searchModel.SAPLocation, searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo); string locations = string.Empty; foreach (var lcoList in locationList) { if (locations == string.Empty) { locations = lcoList.Code; } else { locations += "," + lcoList.Code; } } IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo); string items = string.Empty; foreach (var ite in itemList) { if (items == string.Empty) { items = ite.Code; } else { items += "," + ite.Code; } } SqlParameter[] parm = new SqlParameter[8]; parm[0] = new SqlParameter("@Locations", SqlDbType.VarChar, 50); parm[0].Value = locations; parm[1] = new SqlParameter("@Items", SqlDbType.VarChar, 4000); parm[1].Value = items; parm[2] = new SqlParameter("@HistoryData", SqlDbType.DateTime); parm[2].Value = searchModel.HistoryDate; parm[3] = new SqlParameter("@SortDesc", SqlDbType.VarChar, 100); parm[3].Value = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); parm[4] = new SqlParameter("@PageSize", SqlDbType.Int); parm[4].Value =command.PageSize; parm[5] = new SqlParameter("@Page", SqlDbType.Int); parm[5].Value = command.Page; parm[6] = new SqlParameter("@IsSummaryBySAPLoc", SqlDbType.Bit); parm[6].Value = searchModel.TypeLocation == "1" ? true : false; ; parm[7] = new SqlParameter("@SummaryLevel", SqlDbType.VarChar, 50); parm[7].Value = searchModel.Level; reportSearchStatementModel.Parameters = parm; return reportSearchStatementModel; }
private ReportSearchStatementModel PrepareShelfLifeWarningSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel) { ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel(); reportSearchStatementModel.ProcedureName = "USP_Report_ShelfLifeWarning"; SqlParameter[] parameters = new SqlParameter[6]; parameters[0] = new SqlParameter("@Location", SqlDbType.VarChar, 8000); parameters[0].Value = searchModel.Location; parameters[1] = new SqlParameter("@Item", SqlDbType.VarChar, 8000); parameters[1].Value = searchModel.Item; if (searchModel.SearchCondition == 0) { searchModel.GetType = "ByExpireTime"; } else if (searchModel.SearchCondition == 1) { searchModel.GetType = "ByOutOfExpireTime"; } else if (searchModel.SearchCondition == 2) { searchModel.GetType = "ByRemindExpireTime"; } else { searchModel.GetType = "Summary"; } parameters[2] = new SqlParameter("@Type", SqlDbType.VarChar); parameters[2].Value = searchModel.GetType; parameters[3] = new SqlParameter("@PageSize", SqlDbType.VarChar); parameters[3].Value = command.PageSize; parameters[4] = new SqlParameter("@Page", SqlDbType.VarChar); parameters[4].Value = command.Page; //parameters[5] = new SqlParameter("@IsSumByItem", SqlDbType.VarChar); //parameters[5].Value = searchModel.IsSumByItem; reportSearchStatementModel.Parameters = parameters; return reportSearchStatementModel; }
private ReportSearchStatementModel PrepareSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel) { ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel(); reportSearchStatementModel.ProcedureName = "USP_Busi_GetPlusInventoryHuId"; SqlParameter[] parameters = new SqlParameter[6]; parameters[0] = new SqlParameter("@Location", SqlDbType.VarChar, 50); parameters[0].Value = searchModel.Location; parameters[1] = new SqlParameter("@Item", SqlDbType.VarChar, 50); parameters[1].Value = searchModel.Item; parameters[2] = new SqlParameter("@LotNoFrom", SqlDbType.VarChar, 50); parameters[2].Value = searchModel.LotNoFrom; parameters[3] = new SqlParameter("@LotNoTo", SqlDbType.VarChar,50); parameters[3].Value = searchModel.LotNoTo; parameters[4] = new SqlParameter("@IsFrozen", SqlDbType.Bit); parameters[4].Value = searchModel.IsFreeze; parameters[5] = new SqlParameter("@IsConsignment", SqlDbType.Bit); parameters[5].Value = searchModel.IsConsignment; reportSearchStatementModel.Parameters = parameters; return reportSearchStatementModel; }
private ReportSearchStatementModel PrepareSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel) { ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel(); reportSearchStatementModel.ProcedureName = "USP_Report_RealTimeLocationDet"; 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; //逻辑修改,默认按供应商group parameters[6] = new SqlParameter("@IsGroupByManufactureParty", SqlDbType.Bit); parameters[6].Value = true; parameters[7] = new SqlParameter("@IsGroupByLotNo", SqlDbType.Bit); parameters[7].Value = searchModel.hideLotNo; parameters[8] = new SqlParameter("@IsSummaryBySAPLoc", SqlDbType.Bit); parameters[8].Value = searchModel.TypeLocation == "1" ? true : false; ; reportSearchStatementModel.Parameters = parameters; return reportSearchStatementModel; }
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; }
private ReportSearchStatementModel PrepareSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel) { searchModel.HuOption = searchModel.HuOption ?? 4; searchModel.HuOption = searchModel.HuOption == 0 ? 4 : searchModel.HuOption; ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel(); reportSearchStatementModel.ProcedureName = "USP_Report_AngingSearch"; SqlParameter[] parameters = new SqlParameter[6]; parameters[0] = new SqlParameter("@Location", SqlDbType.VarChar, 8000); parameters[0].Value = searchModel.Location; parameters[1] = new SqlParameter("@Item", SqlDbType.VarChar, 8000); parameters[1].Value = searchModel.Item; parameters[2] = new SqlParameter("@LotNo", SqlDbType.VarChar); parameters[2].Value = searchModel.LotNo; parameters[3] = new SqlParameter("@HuOption", SqlDbType.VarChar); parameters[3].Value = searchModel.HuOption; parameters[4] = new SqlParameter("@IsIncludeEmptyStock", SqlDbType.Bit); parameters[4].Value = searchModel.IsIncludeEmptyStock; parameters[5] = new SqlParameter("@IsIncludeNoNeedAging", SqlDbType.Bit); parameters[5].Value = searchModel.IsIncludeNoNeedAging; //parameters[3] = new SqlParameter("@PageSize", SqlDbType.Int); //parameters[3].Value = command.PageSize; //parameters[4] = new SqlParameter("@Page", SqlDbType.Int); //parameters[4].Value = command.Page; reportSearchStatementModel.Parameters = parameters; return reportSearchStatementModel; }
private ReportSearchStatementModel PrepareSearchStatement(DatFileSearchModel searchModel) { ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel(); reportSearchStatementModel.ProcedureName = "USP_Report_GetFISDatInfo"; /* * @IpNo varchar(50), @Supplier varchar(50), @Location varchar(50), @Item varchar(50), @WmsNo varchar(50), @HandResult varchar(50), @MoveType varchar(50), --@SapLocation varchar(50), @IsCs varchar(50), @StartDate datetime, @EndDate datetime * */ SqlParameter[] parameters = new SqlParameter[10]; parameters[0] = new SqlParameter("@IpNo", SqlDbType.VarChar, 50); parameters[0].Value = searchModel.IpNo; parameters[1] = new SqlParameter("@Supplier", SqlDbType.VarChar, 50); parameters[1].Value = searchModel.Supplier; parameters[2] = new SqlParameter("@Location", SqlDbType.VarChar, 50); parameters[2].Value = searchModel.Location; parameters[3] = new SqlParameter("@Item", SqlDbType.VarChar, 50); parameters[3].Value = searchModel.Item; parameters[4] = new SqlParameter("@WmsNo", SqlDbType.VarChar, 50); parameters[4].Value = searchModel.WmsNo; parameters[5] = new SqlParameter("@HandResult", SqlDbType.VarChar, 50); parameters[5].Value = searchModel.HandResult; parameters[6] = new SqlParameter("@MoveType", SqlDbType.VarChar, 50); parameters[6].Value = searchModel.MoveType; parameters[7] = new SqlParameter("@IsCs", SqlDbType.VarChar, 50); parameters[7].Value = searchModel.IsCs; parameters[8] = new SqlParameter("@StartDate", SqlDbType.DateTime); parameters[8].Value = searchModel.StartDate; parameters[9] = new SqlParameter("@EndDate", SqlDbType.DateTime); parameters[9].Value = searchModel.EndDate; reportSearchStatementModel.Parameters = parameters; return reportSearchStatementModel; }
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; if (locationList.Count > 200) { if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo)) { locationList = locationList.Take(200).ToList(); } } foreach (var lcoList in locationList) { if (location == string.Empty) { location = lcoList.Code; } else { location += "," + lcoList.Code; } } IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo); if (itemList.Count > 200) { itemList = itemList.Take(200).ToList(); } 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; }