C# ReceiveDoc.LoadFromRawSql方法代码示例

 public static bool checkOutstandingReceives(int warehouseID)
 {
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectCheckOutstandingReceives(warehouseID, ReceiptConfirmationStatus.Constants.GRV_PRINTED, ReceiptType.CONSTANTS.STOCK_RETURN, ReceiptType.CONSTANTS.STANDARD_RECEIPT);
     ReceiveDoc receipt = new ReceiveDoc();
     receipt.LoadFromRawSql(query);
     return receipt.Getint("count") == 0;
 }

 /// <summary>
 /// Gets the last issued date for the facility
 /// </summary>
 /// <param name="storeId"></param>
 /// <param name="itemId"></param>
 /// <returns></returns>
 public static DateTime GetLastReceivedDate()
 {
     var rd = new ReceiveDoc();
     rd.LoadFromRawSql(String.Format("SELECT TOP (1) EurDate FROM ReceiveDoc ORDER BY EurDate DESC"));
     DateTime dt = (rd.DataTable.Rows.Count > 0) ? Convert.ToDateTime(rd.DataTable.Rows[0]["EurDate"]) : new DateTime();
     return dt;
 }

 public static DataTable GetRelatedReceiveForUnitCostAndSellingPrice(int ReceiptID,CostElement costElement)
 {
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetRelatedReceiveForUnitCostAndSellingPriceRd(ReceiptID, costElement.ItemID, costElement.ItemUnitID, costElement.ManufacturerID, costElement.MovingAverageID, costElement.AverageCost, costElement.SellingPrice);
     ReceiveDoc receivedoc = new ReceiveDoc();
     receivedoc.LoadFromRawSql(query);
     return receivedoc.DataTable;
 }

 public static int FixQuantityProblem(int itemId)
 {
     BLL.ReceiveDoc rd = new ReceiveDoc();
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectFixQuantityProblem(itemId);
     rd.LoadFromRawSql(query);
     int i = Convert.ToInt32(rd.GetColumn("Count"));
     query =
         HCMIS.Repository.Queries.ReceiveDoc.UpdateFixQuantityProblemReceivedoc(itemId);
     rd.LoadFromRawSql(query);
     return i;
 }

 public static DataTable ListOfItemPendingPrintAndConfirmation(int itemID, int ManufacturerID, int ItemUnitID, int MovingAverageID)
 {
     ReceiveDoc rd = new ReceiveDoc();
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectListOfItemPendingPrintAndConfirmation(itemID, ManufacturerID, ItemUnitID, MovingAverageID, ReceiptConfirmationStatus.Constants.GRNF_PRINTED, ReceiptConfirmationStatus.Constants.GRV_PRINTED);
     rd.LoadFromRawSql(query);
     return rd.DataTable;
 }

        /// <summary>
        /// Loads the pricing summary
        /// </summary>
        /// <param name="itemID">The item ID.</param>
        /// <param name="storeID">The store ID.</param>
        /// <param name="supplierID">The supplier ID.</param>
        /// <param name="manufacturerID">The manufacturer ID.</param>
        /// <param name="unitId">The unit id.</param>
        /// <returns></returns>
        public static DataView LoadForCostSheetDetail(int itemID, int storeID, int supplierID, int manufacturerID, int unitId)
        {
            //They asked that beginningBalance shows on the moving Average
            //u do what they ask
            if (!BLL.Settings.SkipBeginningBalancePricing)
            {
                Activity st = new Activity();
                st.LoadByPrimaryKey(storeID);
                String query;
                query = HCMIS.Repository.Queries.ReceiveDoc.SelectLoadForCostSheetDetailSkipBeginningBalancePricing(itemID, storeID, supplierID, manufacturerID, unitId);

                ReceiveDoc receivedoc = new ReceiveDoc();
                receivedoc.LoadFromRawSql(query);
                return receivedoc.DefaultView;
            }
            else
            {
                Activity st = new Activity();
                st.LoadByPrimaryKey(storeID);
                String query;
                query = HCMIS.Repository.Queries.ReceiveDoc.SelectLoadForCostSheetDetail(itemID, storeID, supplierID, manufacturerID, unitId);

                ReceiveDoc receivedoc = new ReceiveDoc();
                receivedoc.LoadFromRawSql(query);
                return receivedoc.DefaultView;
            }
        }

 public static DataTable GetOutstandingReceives(int warehouseID = 0)
 {
     var query =
         HCMIS.Repository.Queries.ReceiveDoc.SelectGetOutstandingReceives(
             ReceiptConfirmationStatus.Constants.GRNF_PRINTED, warehouseID, ReceiptType.CONSTANTS.STOCK_RETURN,
             ReceiptType.CONSTANTS.STANDARD_RECEIPT);
     ReceiveDoc receipt = new ReceiveDoc();
     receipt.LoadFromRawSql(query);
     return receipt.DataTable;
 }

 public static bool IsShortageOrDamageForBatchElectronicReceive(int reference)
 {
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectIsBatchElectronicReceive(reference);
     ReceiveDoc rd = new ReceiveDoc();
     rd.LoadFromRawSql(query);
     var invoicedQty = rd.DataTable.AsEnumerable().Select(t => t.Field<decimal>("InvoicedQty")).FirstOrDefault<decimal>();
     var TotalReceived = rd.DataTable.AsEnumerable().Select(t => t.Field<decimal>("TotalReceived")).FirstOrDefault<decimal>();
     return invoicedQty != TotalReceived;
 }

        internal PalletLocation GetWhereItIsLocated()
        {
            int receiveDocID = this.ID;
            var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetWhereItIsLocated(receiveDocID);
            BLL.ReceiveDoc rd = new ReceiveDoc();
            rd.LoadFromRawSql(query);

            if(rd.RowCount==0)
            {
                throw new Exception(string.Format("Pallet doesn't exist for the receive ID = {0}", receiveDocID));
            }

            int palletLocationID = Convert.ToInt32(rd.GetColumn("PalletLocationID")); //We just take the first one.
            BLL.PalletLocation pl = new PalletLocation();
            pl.LoadByPrimaryKey(palletLocationID);
            return pl;
        }

 public static DataTable GetOutstandingReceiveDeliveryNote(int warehouseID = 0)
 {
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetOutstandingReceiveDeliveryNote(warehouseID, ReceiptConfirmationStatus.Constants.GRNF_PRINTED, ReceiptType.CONSTANTS.DELIVERY_NOTE);
     ReceiveDoc receipt = new ReceiveDoc();
     receipt.LoadFromRawSql(query);
     return receipt.DataTable;
 }

 /// <summary>
 /// Returns a QtyPerPack of an item as it exists in the ReceiveDoc table.
 /// </summary>
 /// <param name="itemID">The item ID.</param>
 /// <returns></returns>
 public static int GetNextQtyPerPackFor(int itemID)
 {
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetNextQtyPerPackFor(itemID);
     ReceiveDoc receiveDoc = new ReceiveDoc();
     receiveDoc.LoadFromRawSql(query);
     if (receiveDoc.RowCount > 0)
     {
         return receiveDoc.QtyPerPack;
     }
     return 1;
 }

 public static DataTable GetItemInformation(int ItemID, int ItemUnitID, int ManufacturerID, int AccountID)
 {
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetItemInformation(ItemID, ItemUnitID, ManufacturerID, AccountID);
     ReceiveDoc receivedoc = new ReceiveDoc();
     receivedoc.LoadFromRawSql(query);
     return receivedoc.DataTable;
 }

 public static DataTable GetCutOffNumber(int fiscalPeriodID, int accountID)
 {
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetCutOffNumber(fiscalPeriodID, accountID);
     ReceiveDoc receipt = new ReceiveDoc();
     receipt.LoadFromRawSql(query);
     return receipt.DataTable;
 }

 public static decimal GetSoundStock(CostElement costElement)
 {
     ReceiveDoc receipt = new ReceiveDoc();
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetSoundStock(costElement.ItemID, costElement.ItemUnitID, costElement.ManufacturerID, costElement.MovingAverageID, ReceiptConfirmationStatus.Constants.GRV_PRINTED);
     receipt.LoadFromRawSql(query);
     return Convert.ToDecimal(receipt.GetColumn("Quantity"));
 }

 public static DataTable GetOutstandingTransfer(int receiptType)
 {
     var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetOutstandingTransfer(receiptType, ReceiptConfirmationStatus.Constants.GRNF_PRINTED);
     ReceiveDoc receipt = new ReceiveDoc();
     receipt.LoadFromRawSql(query);
     return receipt.DataTable;
 }