public static DataView GetStockCardByDate(int storeId, int itemId, int? unitID, int physicalStoreTypeID, int manufactuerID, DateTime fromDate, DateTime toDate)
{
var ld = new ListDictionary();
ld.Add("@ItemID", itemId);
ld.Add("@UnitID", unitID);
ld.Add("@StoreID", storeId);
ld.Add("@fromdate", fromDate);
ld.Add("@toDate", toDate);
ld.Add("@Warehouse", physicalStoreTypeID);
ld.Add("@Manufacturer", manufactuerID);
Balance bal = new Balance();
bal.LoadFromSql("[Rpt_StockCardByDate]", ld, CommandType.StoredProcedure);
bal.Rewind();
int Balance = 0;
while (!bal.EOF)
{
Balance += Convert.ToInt32(bal.GetColumn("Balance"));
bal.SetColumn("Balance", Balance);
bal.MoveNext();
}
return bal.DefaultView;
}
public static DataView GetStockCardByWarehouse(int storeId, int itemId, int? unitID, int fiscalYear, int physicalStoreTypeID,int manufactuerID)
{
var ld = new ListDictionary();
ld.Add("@ItemID", itemId);
ld.Add("@UnitID", unitID);
ld.Add("@StoreID", storeId);
ld.Add("@FiscalYear", fiscalYear);
ld.Add("@Warehouse", physicalStoreTypeID);
ld.Add("@Manufacturer",manufactuerID);
Balance bal = new Balance();
bal.LoadFromSql("[Rpt_StockCard]", ld, CommandType.StoredProcedure);
bal.Rewind();
decimal Balance = 0;
while (!bal.EOF)
{
Balance += Convert.ToDecimal(bal.GetColumn("Balance"));
bal.SetColumn("Balance", Balance);
bal.MoveNext();
}
return bal.DefaultView;
}
/// <summary>
/// Gets bin card by supplier
/// </summary>
/// <param name="itemId"></param>
/// <param name="supplierId"></param>
/// <returns></returns>
public static DataView GetBinCard(int storeId, int itemId, int? unitID, int fiscalYear, int supplierId)
{
var ld = new ListDictionary();
ld.Add("@ItemID", itemId);
ld.Add("@UnitID", unitID);
ld.Add("@StoreID", storeId);
ld.Add("@FiscalYear", fiscalYear);
ld.Add("@SupplierID", supplierId);
Balance bal = new Balance();
bal.LoadFromSql("Rpt_BinCardBySupplier", ld, CommandType.StoredProcedure);
bal.Rewind();
int Balance = 0;
while (!bal.EOF)
{
Balance += Convert.ToInt32(bal.GetColumn("Balance"));
bal.SetColumn("Balance", Balance);
bal.MoveNext();
}
return bal.DefaultView;
}
