public IStockDAO CreateStockDAO() { IStockDAO dao = null; if (_DbType == DatabaseType.SqlServer) { dao = new SqlServer.StockDAO(); } else if (_DbType == DatabaseType.MySql) { dao = new SqlServer.StockDAO(); } else if (_DbType == DatabaseType.Oracole) { dao = new SqlServer.StockDAO(); } else if (_DbType == DatabaseType.DB2) { dao = new SqlServer.StockDAO(); } else if (_DbType == DatabaseType.Postgre) { dao = new SqlServer.StockDAO(); } return(dao); }
public TransactionsController(IGameDAO gameDao, IUserDAO userDao, ITransactionDAO transactDao, IStockDAO stockDao) { this.gameDao = gameDao; this.userDao = userDao; this.transactionDao = transactDao; this.stockDao = stockDao; }
public ScheduledJobs(IUserDAO userDao, IGameDAO gameDao, ITransactionDAO transactionDao, IOwnedStocksHelper ownedHelper, IStockAPIDAO stockAPIDao, IStockDAO stockDao, IStockHistoryAPIDAO stockHistoryAPIDao) { this.userDao = userDao; this.gameDao = gameDao; this.transactionDao = transactionDao; this.ownedHelper = ownedHelper; this.stockAPIDao = stockAPIDao; this.stockDao = stockDao; this.stockHistoryAPIDao = stockHistoryAPIDao; }
public StocksController(IGameDAO gameDao, IUserDAO userDao, ITransactionDAO transactDao, IStockAPIDAO stockAPIDao, IStockDAO stockDao, IOwnedStocksHelper ownedHelper) { this.userDao = userDao; this.stockDao = stockDao; this.ownedHelper = ownedHelper; // TODO: Determine if these properties are needed with later refactoring this.gameDao = gameDao; this.transactDao = transactDao; this.stockAPIDao = stockAPIDao; }
/// <summary> /// 作废一条票据 /// </summary> /// <param name="bill">作废的票据</param> /// <param name="maker">做废人</param> /// <param name="makeDate">作废日期</param> /// <param name="remark">备注</param> public void BlankOutBill(Bills bill, string remark) { if (!bill.Actived) { throw new ApplicationException(string.Format("票据{0}已经被作废,不能重复被作废。", bill.ID)); } if (bill.IsCancelOut) { throw new ApplicationException(string.Format("票据{0}已被冲销,不能作废。", bill.ID)); } if (bill.IsRedBill) { throw new ApplicationException(string.Format("票据{0}是冲销票,不能作废。", bill.ID)); } using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IDbTransaction trans = conn.BeginTransaction(); try { //1、更新票据状态 bill.Actived = false; bill.Remark += remark; IBillsDAO billDao = DAOFactory.Instance.CreateBillsDAO(); billDao.UpdateBill(bill, conn, trans); //2、更改库存数据 IStockDAO stockDao = DAOFactory.Instance.CreateStockDAO(); foreach (BillsItem item in bill.Items) { Stock stock = stockDao.SelectStockByDrugsAndStorehouse(item.Drugs.ID, bill.Storehouse.ID, conn, trans); if (bill.BillsType.IsOut) { stock.Count += item.Count; } else { stock.Count -= item.Count; } stockDao.UpdateStock(stock, conn, trans); } //3、记录票据作废事件日志 LogServices.Info("作废票据" + bill.ID); //4、提交 trans.Commit(); } catch (Exception ex) { //5、回滚 bill.Actived = true; trans.Rollback(); throw ex; } } }
/// <summary> /// 开票并更改库存 /// </summary> /// <param name="bill"></param> public void MakeBill(StockBill bill) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IDbTransaction trans = conn.BeginTransaction(); try { // 1. 保存票据信息 IStockBillDAO sbDao = DAOFactory.Instance.CreateStockBillDAO(); sbDao.InsertBill(bill, conn, trans); // 2. 更改库存数据 IStockDAO sDao = DAOFactory.Instance.CreateStockDAO(); foreach (StockBillItem item in bill.Items) { Stock stock = sDao.SelectStockByGoodsAndStorehouse(item.Goods.ID, bill.Storehouse.ID, conn, trans); //如果库存中没有该商品,则创建该商品的库存信息。 if (stock == null) { stock = new Stock(); stock.Storehouse = bill.Storehouse; stock.Goods = item.Goods; stock.Count = 0; sDao.InsertStock(stock, conn, trans); } //执行出入库操作 if (bill.BillType.IsOutStorehouse)//出库 { stock.Count -= item.Count; } else// 入库 { stock.Count += item.Count; } sDao.UpdateStock(stock, conn, trans); } // 3. 提交 trans.Commit(); } catch (Exception ex) { // 4. 回滚 trans.Rollback(); throw ex; } } }
public IStockDAO CreateStockDAO() { IStockDAO dao = null; if (_DbType == DatabaseType.SqlServer) { dao = new SqlServer.StockDAO(); } else if (_DbType == DatabaseType.MySQL) { //dao = new MySQL.EventLogDAO(); } return(dao); }
/// <summary> /// 开出库或则入库的票 /// </summary> /// <param name="bill">票据</param> public void MakeBill(Bills bill) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IDbTransaction trans = conn.BeginTransaction(); try { //1、保存票据信息; IBillsDAO billDao = DAOFactory.Instance.CreateBillsDAO(); billDao.InsertBill(bill, conn, trans); //2、更改库存数据; IStockDAO stockDao = DAOFactory.Instance.CreateStockDAO(); foreach (BillsItem item in bill.Items) { Stock stock = stockDao.SelectStockByDrugsAndStorehouse(item.Drugs.ID, bill.Storehouse.ID, conn, trans); //如果库存中没有该商品,则创建库存信息 if (stock == null) { stock = new Stock(); stock.Storehouse = bill.Storehouse; stock.Drug = item.Drugs; stock.Count = 0; stockDao.InsertStock(stock, conn, trans); } if (bill.BillsType.IsOut) { stock.Count -= item.Count; } else { stock.Count += item.Count; } stockDao.UpdateStock(stock, conn, trans); } //3、提交 trans.Commit(); } catch (Exception ex) { //4、回滚 trans.Rollback(); throw ex; } } }
public StockHistoryAPIDAO(IStockDAO stockDao) { this.stockDao = stockDao; }
/// <summary> /// 冲销一个票据 /// </summary> /// <param name="bill">要冲销的票据</param> /// <param name="maker">冲销人</param> /// <param name="makeDate">冲销日期</param> /// <param name="remark">备注</param> public StockBill CancelOutBill(StockBill bill, string maker, DateTime makeDate, string remark) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { bill = this.FindBill(bill.ID); // 1. 构造负字票 StockBill redBill = new StockBill(); redBill.Actived = true; redBill.BillType = bill.BillType; redBill.Code = bill.Code; redBill.Company = bill.Company; redBill.CreateDate = DateTime.Now; redBill.IsCancelOut = false; redBill.IsRedBill = true; redBill.MakeDate = makeDate; redBill.Maker = maker; redBill.Remark = "对冲票据" + bill.ID.ToString(); redBill.Storehouse = bill.Storehouse; foreach (StockBillItem item in bill.Items) { StockBillItem redBillItem = new StockBillItem(); redBillItem.Goods = item.Goods; redBillItem.Count = item.Count * (-1); redBillItem.UnitPrice = item.UnitPrice; redBill.Items.Add(redBillItem); } IDbTransaction trans = conn.BeginTransaction(); try { IStockBillDAO sbDao = DAOFactory.Instance.CreateStockBillDAO(); // 2. 保存红票 sbDao.InsertBill(redBill, conn, trans); // 3. 保存原票据信息 bill.IsCancelOut = true; bill.Remark += " 被冲销" + redBill.ID.ToString(); sbDao.UpdateBill(bill, conn, trans); // 4. 更改库存数据 IStockDAO sDao = DAOFactory.Instance.CreateStockDAO(); foreach (StockBillItem redBillItem in redBill.Items) { Stock stock = sDao.SelectStockByGoodsAndStorehouse(redBillItem.Goods.ID, bill.Storehouse.ID, conn, trans); //执行出入库操作 if (redBill.BillType.IsOutStorehouse)//出库 { stock.Count -= redBillItem.Count; } else// 入库 { stock.Count += redBillItem.Count; } sDao.UpdateStock(stock, conn, trans); } // 5. 提交 trans.Commit(); } catch (Exception ex) { // 6. 回滚 bill.IsCancelOut = false; trans.Rollback(); throw ex; } return(redBill); } }
/// <summary> /// 作废一个票据 /// </summary> /// <param name="bill">要做作废的票据</param> /// <param name="remark">备注</param> public void BlankOutBill(StockBill bill, string remark) { if (!bill.Actived) { throw new ApplicationException(string.Format("票据{0}已经被作废,不能重复作废。", bill.ID)); } if (bill.IsCancelOut) { throw new ApplicationException(string.Format("票据{0}已经被冲销,不能作废。", bill.ID)); } if (bill.IsRedBill) { throw new ApplicationException(string.Format("票据{0}是冲销票,不能作废。", bill.ID)); } using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IDbTransaction trans = conn.BeginTransaction(); try { //1. 更新票据状态 bill.Actived = false; bill.Remark += remark; IStockBillDAO sbDao = DAOFactory.Instance.CreateStockBillDAO(); sbDao.UpdateBill(bill, conn, trans); //2. 更改库存数据 IStockDAO sDao = DAOFactory.Instance.CreateStockDAO(); foreach (StockBillItem item in bill.Items) { //List<Stock> stockList = sDao.SelectStocksByGoodsID(item.Goods.ID, conn); //Stock stock = null; //foreach (Stock s in stockList) //{ // if (s.Storehouse.ID == bill.Storehouse.ID) // { // stock = s; // break; // } //} Stock stock = sDao.SelectStockByGoodsAndStorehouse(item.Goods.ID, bill.Storehouse.ID, conn, trans); //执行出入库操作 if (bill.BillType.IsOutStorehouse)//出库 { stock.Count += item.Count; } else// 入库 { stock.Count -= item.Count; } sDao.UpdateStock(stock, conn, trans); } //3. 记录作废票据的事件日志 LogService.Info("作废单据" + bill.ID); // 4. 提交 trans.Commit(); } catch (Exception ex) { // 4. 回滚 bill.Actived = true; trans.Rollback(); throw ex; } } }
/// <summary> /// 冲销一条票据 /// </summary> /// <param name="bill">票据</param> /// <param name="maker">冲票人</param> /// <param name="makeDate">冲票日期</param> /// <param name="remark">备注</param> public Bills CancelOutBill(Bills bill, string maker, DateTime makeDate, string remark) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { //1、构造负子票 Bills redBill = new Bills(); redBill.Actived = true; redBill.BillsType = bill.BillsType; redBill.Code = bill.Code; redBill.Company = bill.Company; redBill.CreateDate = DateTime.Now; redBill.IsCancelOut = false; redBill.IsRedBill = true; redBill.MakeDate = makeDate; redBill.Maker = maker; redBill.Storehouse = bill.Storehouse; redBill.Remark = "对冲票据" + bill.ID.ToString(); foreach (BillsItem item in bill.Items) { BillsItem redbillitem = new BillsItem(); redbillitem.Drugs = item.Drugs; redbillitem.Count = item.Count * (-1); redbillitem.UnitPrice = item.UnitPrice; redbillitem.Money = item.Money * (-1); redBill.Items.Add(redbillitem); } IDbTransaction trans = conn.BeginTransaction(); try { IBillsDAO billDao = DAOFactory.Instance.CreateBillsDAO(); // 2. 保存红票 billDao.InsertBill(redBill, conn, trans); // 3. 保存原票据信息 bill.IsCancelOut = true; bill.Remark += " 被冲销" + redBill.ID.ToString(); billDao.UpdateBill(bill, conn, trans); // 4. 更改库存数据 IStockDAO stockDao = DAOFactory.Instance.CreateStockDAO(); foreach (BillsItem item in redBill.Items) { Stock stock = stockDao.SelectStockByDrugsAndStorehouse(item.Drugs.ID, bill.Storehouse.ID, conn, trans); if (redBill.BillsType.IsOut) { stock.Count -= item.Count; } else { stock.Count += item.Count; } stockDao.UpdateStock(stock, conn, trans); } //5、提交 trans.Commit(); } catch (Exception ex) { //6、回滚 bill.IsCancelOut = false; trans.Rollback(); throw ex; } return(redBill); } }
public OwnedStocksHelper(ITransactionDAO transactDao, IStockDAO stockDao) { this.transactDao = transactDao; this.stockDao = stockDao; }