/// <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;
}
/// <summary>
/// Returns items that have been issued using an STV/Invoice number for SRM
/// </summary>
/// <param name="stvID">The STV ID.</param>
/// <param name="storeID">The store ID.</param>
/// <returns></returns>
public static DataTable GetItemsBySTVInvoiceNoForStockReturn(int stvID,int storeID)
{
var query = HCMIS.Repository.Queries.Item.SelectGetItemsBySTVInvoiceNoForStockReturn(stvID, storeID);
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;
}
/// <summary>
/// Returns the price list by Manufacturer for items received on a specific date
/// </summary>
/// <param name="date">Date in Gregorian Calendar</param>
/// <param name="storeID">The store ID.</param>
/// <returns></returns>
public static DataTable GetItemPriceListByManufacturer(DateTime date, Int32 storeID)
{
var query = HCMIS.Repository.Queries.Item.SelectGetItemPriceListByManufacturer(date, storeID);
Item itm = new Item();
itm.LoadFromRawSql(query);
itm.AddColumn("UnitsSelling", typeof(string));
//For the items that haven't been priced
while (!itm.EOF)
{
string priceString = itm.GetColumn("UnitsSellingBeforeFormat").ToString();
itm.SetColumn("UnitsSelling", FormatNumber(priceString));
itm.MoveNext();
}
return itm.DataTable;
}