private void GetProductionOrderPendingFirmOrders() { string queryString; SqlProgrammability.Inventories.Inventories inventories = new SqlProgrammability.Inventories.Inventories(this.totalSmartPortalEntities); queryString = " @LocationID Int, @NMVNTaskID int, @ProductionOrderID Int, @PlannedOrderID Int, @CustomerID Int, @FirmOrderIDs varchar(3999), @IsReadonly bit " + "\r\n"; queryString = queryString + " WITH ENCRYPTION " + "\r\n"; queryString = queryString + " AS " + "\r\n"; queryString = queryString + " BEGIN " + "\r\n"; queryString = queryString + " IF (@PlannedOrderID <> 0) " + "\r\n"; queryString = queryString + " " + this.BuildSQLPendingFirmOrders(true) + "\r\n"; queryString = queryString + " ELSE " + "\r\n"; queryString = queryString + " " + this.BuildSQLPendingFirmOrders(false) + "\r\n"; queryString = queryString + " END " + "\r\n"; this.totalSmartPortalEntities.CreateStoredProcedure("GetProductionOrderPendingFirmOrders", queryString); }
private void GetSemifinishedProductPendingMaterialIssueDetails() { string queryString; SqlProgrammability.Inventories.Inventories inventories = new SqlProgrammability.Inventories.Inventories(this.totalSmartPortalEntities); queryString = " @LocationID Int, @SemifinishedProductID Int, @MaterialIssueID Int, @CustomerID Int, @MaterialIssueDetailIDs varchar(3999), @IsReadonly bit " + "\r\n"; queryString = queryString + " WITH ENCRYPTION " + "\r\n"; queryString = queryString + " AS " + "\r\n"; queryString = queryString + " BEGIN " + "\r\n"; queryString = queryString + " IF (@MaterialIssueID <> 0) " + "\r\n"; queryString = queryString + " " + this.BuildSQLMaterialIssue(true) + "\r\n"; queryString = queryString + " ELSE " + "\r\n"; queryString = queryString + " " + this.BuildSQLMaterialIssue(false) + "\r\n"; queryString = queryString + " END " + "\r\n"; this.totalSmartPortalEntities.CreateStoredProcedure("GetSemifinishedProductPendingMaterialIssueDetails", queryString); }
private void GetSalesReturnPendingGoodsIssueDetails() { string queryString; SqlProgrammability.Inventories.Inventories inventories = new SqlProgrammability.Inventories.Inventories(this.totalSmartPortalEntities); queryString = " @LocationID Int, @SalesReturnID Int, @GoodsIssueID Int, @CustomerID Int, @ReceiverID Int, @TradePromotionID int, @VATPercent decimal(18, 2), @FromDate DateTime, @ToDate DateTime, @GoodsIssueDetailIDs varchar(3999), @IsReadonly bit " + "\r\n"; queryString = queryString + " WITH ENCRYPTION " + "\r\n"; queryString = queryString + " AS " + "\r\n"; queryString = queryString + " BEGIN " + "\r\n"; queryString = queryString + " SET @ToDate = DATEADD (hour, 23, DATEADD (minute, 59, DATEADD (second, 59, @ToDate))) " + "\r\n"; queryString = queryString + " IF (@GoodsIssueID <> 0) " + "\r\n"; queryString = queryString + " " + this.BuildSQLGoodsIssue(true) + "\r\n"; queryString = queryString + " ELSE " + "\r\n"; queryString = queryString + " " + this.BuildSQLGoodsIssue(false) + "\r\n"; queryString = queryString + " END " + "\r\n"; this.totalSmartPortalEntities.CreateStoredProcedure("GetSalesReturnPendingGoodsIssueDetails", queryString); }