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