本文整理汇总了C#中Item.LoadFromRawSql方法的典型用法代码示例。如果您正苦于以下问题:C# Item.LoadFromRawSql方法的具体用法?C# Item.LoadFromRawSql怎么用?C# Item.LoadFromRawSql使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Item
的用法示例。
在下文中一共展示了Item.LoadFromRawSql方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetItemByManufactuerAndUnit
/// <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;
}
示例2: GetRecievedItems
/// <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;
}
示例3: FixExpirySettings
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);
}
示例4: GetItemsDetailByFilter
public static DataTable GetItemsDetailByFilter(String Filter)
{
var query = HCMIS.Repository.Queries.Item.SelectGetItemsDetailByFilter(Filter);
Item itms = new Item();
itms.LoadFromRawSql(query);
return itms.DataTable;
}
示例5: GetNearExpiryBreakdown
/// <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;
}
示例6: GetItemsByCommodityTypeForTransferToAccount
/// <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;
}
示例7: GetItemsByReceiptInvoiceNoForSTVTransfer
/// <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;
}
示例8: GetReceiveDocDetailForDiagnostics
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;
}
示例9: GetAllItemsByCommodityType
public static DataTable GetAllItemsByCommodityType(int CommodityType)
{
Item itms = new Item();
itms.LoadFromRawSql(HCMIS.Repository.Queries.Item.SelectGetAllItemsByCommodityType(CommodityType));
return itms.DataTable;
}
示例10: GetActiveItemsBySupplier
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;
}
示例11: GetReceiveDocByItemAndManufactuerAndUnit
/// <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;
}
示例12: GetJournalEntriesForDiagnostics
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;
}
示例13: GetItemsDistributedByAccount
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;
}
示例14: GetActiveItemsByCommodityTypeForReceiveScreen
/// <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;
}
示例15: GetItemDetailForItemChanger
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;
}