C# (CSharp) EL.Transactions.Inventories示例

示例#1

 public bool UpdateStocks(EL.Transactions.Inventories inventoryEL)
 {
     return(Helper.executeNonQueryBool("update inventories set quantityinstocks = '" + inventoryEL.Quantityinstocks + "', inventorylastupdated = '" + inventoryEL.Inventorylastupdated + "' where inventoryid = '" + inventoryEL.Inventoryid + "'"));
 }

示例#2

 public bool Update(EL.Transactions.Inventories inventoryEL)
 {
     return(Helper.executeNonQueryBool("update inventories set reorderlevel = '" + inventoryEL.Reorderlevel + "', inventorylastupdated = '" + DateTime.Today.ToString("yyyy-MM-dd") + "'  where inventoryid = '" + inventoryEL.Inventoryid + "'"));
 }

示例#3

 public bool UpdateStocks(EL.Transactions.Inventories inventoryEL)
 {
     return(InventoryDL.UpdateStocks(inventoryEL));
 }

示例#4

 public long Insert(EL.Transactions.Inventories inventoryEL)
 {
     return(Helper.executeNonQueryLong("insert into inventories (productid, quantityinstocks, reorderlevel, inventorylastupdated) values ('" + inventoryEL.Productid + "', '" + inventoryEL.Quantityinstocks + "', '" + inventoryEL.Reorderlevel + "', '" + DateTime.Today.ToString("yyyy-MM-dd") + "' )"));
 }

示例#5

 public long Insert(EL.Transactions.Inventories inventoryEL)
 {
     return(InventoryDL.Insert(inventoryEL));
 }