C# Item.LoadFromRawSql方法代码示例

        /// <summary>
        /// Gets the item by manufactuer and unit.
        /// </summary>
        /// <returns></returns>
        public DataTable GetItemByManufactuerAndUnit()
        {
            string query = "";

            //all items = 0
            query = HCMIS.Repository.Queries.Item.SelectGetItemByManufactuerAndUnit();

            Item itms = new Item();
            itms.LoadFromRawSql(query);
            return itms.DataTable;
        }

        /// <summary>
        /// Gets list of ever received items
        /// </summary>
        /// <returns></returns>
        public static Dictionary<int, int> GetRecievedItems()
        {
            var query = HCMIS.Repository.Queries.Item.SelectGetRecievedItems();
            Item itms = new Item();
            itms.LoadFromRawSql(query);

            System.Collections.Generic.Dictionary<int, int> dict = new System.Collections.Generic.Dictionary<int, int>();

            int[] arr = new int[itms.RowCount];
            for (int i = 0; i < itms.RowCount; i++)
            {
                dict.Add(itms.ID, itms.ID);
                itms.MoveNext();
            }
            return dict;
        }

 public static void FixExpirySettings()
 {
     // Applys the default setting for those columns that do have null as expiry setting
     // pharmacuticals require batch and expiry, non pharmacuticals don't require it.
     Item items = new Item();
     var query = HCMIS.Repository.Queries.Item.UpdateFixExpirySettings();
     items.LoadFromRawSql(query);
 }

        public static DataTable GetItemsDetailByFilter(String Filter)
        {
            var query = HCMIS.Repository.Queries.Item.SelectGetItemsDetailByFilter(Filter);

            Item itms = new Item();
             itms.LoadFromRawSql(query);
            return itms.DataTable;
        }

 /// <summary>
 /// Gets the near expiry breakdown.
 /// </summary>
 /// <param name="itemType">Type of the item.</param>
 /// <returns></returns>
 public static DataTable GetNearExpiryBreakdown(int itemType, int modeID ,int warehouseID)
 {
     var query = HCMIS.Repository.Queries.Item.SelectGetNearExpiryBreakdown(itemType, modeID ,warehouseID);
     Item items = new Item();
     items.LoadFromRawSql(query);
     return items.DataTable;
 }

        /// <summary>
        /// Gets the items by commodity type for transfer to account.
        /// </summary>
        /// <param name="AccountFrom">The account from.</param>
        /// <param name="AccountTo">The account to.</param>
        /// <returns></returns>
        public static DataTable GetItemsByCommodityTypeForTransferToAccount(int AccountFrom, int AccountTo)
        {
            string query = "";

            //all items = 0
            query = HCMIS.Repository.Queries.Item.SelectGetItemsByCommodityTypeForTransferToAccount(AccountFrom, AccountTo);

            Item itms = new Item();
            itms.LoadFromRawSql(query);
            return itms.DataTable;
        }

        /// <summary>
        /// Returns items that have been issued using an STV/Invoice number for SRM
        /// </summary>
        /// <param name="receiptInvoiceID">The Receipt Invoice ID.</param>
        /// <returns></returns>
        public static DataTable GetItemsByReceiptInvoiceNoForSTVTransfer(int receiptInvoiceID)
        {
            string query = "";

            query = HCMIS.Repository.Queries.Item.SelectGetItemsByReceiptInvoiceNoForSTVTransfer(receiptInvoiceID);

            Item itms = new Item();
            itms.LoadFromRawSql(query);
            itms.AddColumn("LineNo", typeof(int));
            // make a better numbering
            int i = 1;
            while (!itms.EOF)
            {
                itms.SetColumn("LineNo", i++);
                itms.MoveNext();
            }
            return itms.DataTable;
        }

        public DataTable GetReceiveDocDetailForDiagnostics(int itemID,int ManufacturerID,int UnitID,int MovingAverageID)
        {
            string query = "";

               //all items = 0
               query = HCMIS.Repository.Queries.Item.SelectGetReceiveDocDetailForDiagnostics(itemID, ManufacturerID, UnitID, MovingAverageID);

               Item itms = new Item();
               itms.LoadFromRawSql(query);
               return itms.DataTable;
        }

 public static DataTable GetAllItemsByCommodityType(int CommodityType)
 {
     Item itms = new Item();
     itms.LoadFromRawSql(HCMIS.Repository.Queries.Item.SelectGetAllItemsByCommodityType(CommodityType));
     return itms.DataTable;
 }

 public static DataTable GetActiveItemsBySupplier(int supplierID, int? storeID)
 {
     string query = HCMIS.Repository.Queries.Item.SelectGetActiveItemsBySupplier(supplierID, storeID);
     Item it = new Item();
     it.LoadFromRawSql(query);
     return it.DataTable;
 }

        /// <summary>
        /// Gets the receive doc by item and manufactuer and unit.
        /// </summary>
        /// <param name="ItemID">The item ID.</param>
        /// <param name="ManufacturerID">The manufacturer ID.</param>
        /// <param name="ItemUnitID">The item unit ID.</param>
        /// <param name="AccountID">The account ID.</param>
        /// <returns></returns>
        public DataTable GetReceiveDocByItemAndManufactuerAndUnit(int ItemID, int ManufacturerID, int ItemUnitID,int AccountID)
        {
            string query = "";

            //all items = 0
            query = HCMIS.Repository.Queries.Item.SelectGetReceiveDocByItemAndManufactuerAndUnit(ItemID, ManufacturerID, ItemUnitID, AccountID);

            Item itms = new Item();
            itms.LoadFromRawSql(query);
            return itms.DataTable;
        }

        public DataTable GetJournalEntriesForDiagnostics(int AffectedLedgerID)
        {
            string query = "";

               //all items = 0
               query = HCMIS.Repository.Queries.Item.SelectGetJournalEntriesForDiagnostics(AffectedLedgerID);

               Item itms = new Item();
               itms.LoadFromRawSql(query);
               return itms.DataTable;
        }

 public DataTable GetItemsDistributedByAccount(int accountid, DateTime fromdate, DateTime todate)
 {
     var items = new Item();
     var query = HCMIS.Repository.Queries.Item.SelectItemsDistributedByAccount(accountid, fromdate, todate);
     items.LoadFromRawSql(query);
     return items.DataTable;
 }

        /// <summary>
        /// Returns the commodites by type
        /// </summary>
        /// <param name="commodityType">0 - All Items</param>
        /// <param name="storeID">The store ID.</param>
        /// <returns></returns>
        public static DataTable GetActiveItemsByCommodityTypeForReceiveScreen(int commodityType, int? storeID)
        {
            string query = "";

            if (Settings.IsRdfMode)
            {
                // let 0 mean all items
                if (commodityType == 0)
                {
                    query = HCMIS.Repository.Queries.Item.SelectGetActiveItemsByCommodityTypeForReceiveScreenAllItem(query, storeID);
                }
                else
                {
                    query = HCMIS.Repository.Queries.Item.SelectGetActiveItemsByCommodityTypeForReceiveScreen(commodityType, query, storeID);
                }
            }
            else
            {
                // handle the freaking program store
                query = HCMIS.Repository.Queries.Item.SelectGetActiveItemsByCommodityTypeForReceiveScreenNotRdfMode(
                    commodityType, query, storeID);
            }

            Item itms = new Item();
            itms.LoadFromRawSql(query);
            return itms.DataTable;
        }

        public static DataTable GetItemDetailForItemChanger(int ItemID,int ManufacturerID,int UnitID,int ActivityID)
        {
            var query = HCMIS.Repository.Queries.Item.SelectGetItemDetailForItemChanger(ItemID, ManufacturerID, UnitID, ActivityID);

            Item itms = new Item();
            itms.LoadFromRawSql(query);
            return itms.DataTable;
        }