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; }