public int Update(ProductSellRecord info)
{
string commandText = string.Format("update ProductSellRecord set productID={0}, num={1}, price={2} where ID={3}",
info.ProductID, info.Num, info.Price, info.ID);
return(DbHelperAccess.executeNonQuery(commandText));
}
public int Insert(ProductSellRecord info)
{
try
{
//string commandText = @"insert into Users(userName,userPassword,userLevel,userPhone,userAddress) values (
//?userName,?userPassword,?userLevel,?userPhone,?userAddress)";
string commandText = string.Format("insert into ProductSellRecord(productID, num, price, sellID) values('{0}', '{1}', '{2}', '{3}')",
info.ProductID, info.Num, info.Price, info.SellID);
return(DbHelperAccess.executeNonQuery(commandText));
}
catch (Exception ex)
{
throw ex;
}
}