public int Insert(ProductSell info, List <ProductSellRecord> records) { try { //string commandText = @"insert into Users(userName,userPassword,userLevel,userPhone,userAddress) values ( //?userName,?userPassword,?userLevel,?userPhone,?userAddress)"; string commandText = string.Format("insert into ProductSell(name, sellTime, comment, status, customerID) values('{0}', '{1}', '{2}', '{3}', {4})", info.Name, info.SellTime, info.Comment, info.Status, info.CustomerID); DbHelperAccess.executeNonQuery(commandText); int ProductSellID = DbHelperAccess.executeMax("ID", "ProductSell"); ProductSellRecordDao dao = new ProductSellRecordDao(); foreach (ProductSellRecord record in records) { record.SellID = ProductSellID; dao.Insert(record); } return(ProductSellID); } catch (Exception ex) { throw ex; } }
public static ProductSellRecordDao getInstance() { if (dao == null) { dao = new ProductSellRecordDao(); } return(dao); }
public void Update(ProductSell info, List <ProductSellRecord> records) { string commandText = string.Format("update ProductSell set name='{0}', sellTime='{1}', comment='{2}', customerID='{3}' where ID={4}", info.Name, info.SellTime, info.Comment, info.CustomerID, info.ID); DbHelperAccess.executeNonQuery(commandText); ProductSellRecordDao.getInstance().DeleteBySellID(info.ID); foreach (ProductSellRecord record in records) { record.SellID = info.ID; ProductSellRecordDao.getInstance().Insert(record); } }