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;
        }
Example #2
0
        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;
        }