/// <summary> /// 根据单据信息构造台帐信息 /// </summary> /// <param name="billMaster">单据头</param> /// <param name="billOrder">单据明细信息</param> /// <param name="storeNum">库存处理后药品库存信息</param> /// <param name="accountYear">会计年份</param> /// <param name="accountMonth">会计月份</param> /// <param name="smallUnit">基本单位</param> /// <returns>台帐信息</returns> override protected YP_Account BuildAccount(BillMaster billMaster, BillOrder billOrder, decimal storeNum, int accountYear, int accountMonth, int smallUnit) { YP_OutMaster master = (YP_OutMaster)billMaster; YP_OutOrder order = (YP_OutOrder)billOrder; YP_Account account = new YP_Account(); account.AccountYear = accountYear; account.AccountMonth = accountMonth; account.AccountType = 2; account.Balance_Flag = 0; account.BillNum = master.BillNum; account.OpType = master.OpType; account.DeptID = master.DeptID; account.LeastUnit = smallUnit; account.UnitNum = order.UnitNum; account.MakerDicID = order.MakerDicID; account.RegTime = master.AuditTime; account.RetailPrice = order.RetailPrice; account.StockPrice = order.TradePrice; account.OrderID = order.OutStorageID; account.DebitFee = order.RetailFee; account.OverNum = storeNum; account.BalanceFee = 0; return(account); }
/// <summary> /// 根据单据信息构造台帐信息 /// </summary> /// <param name="billMaster">单据头</param> /// <param name="billOrder">单据明细信息</param> /// <param name="storeNum">库存处理后药品库存信息</param> /// <param name="accountYear">会计年份</param> /// <param name="accountMonth">会计月份</param> /// <param name="smallUnit">基本单位</param> /// <returns>台帐信息</returns> override protected YP_Account BuildAccount(BillMaster billMaster, BillOrder billOrder, decimal storeNum, int accountYear, int accountMonth, int smallUnit) { YP_DRMaster master = (YP_DRMaster)billMaster; YP_DROrder order = (YP_DROrder)billOrder; YP_Account account = new YP_Account(); account.AccountYear = accountYear; account.AccountMonth = accountMonth;; account.AccountType = 2; account.Balance_Flag = 0; account.BillNum = (master.InvoiceNum != 0 ? master.InvoiceNum : Convert.ToInt32(master.InpatientID)); account.OpType = master.OpType; account.DeptID = master.DeptID; account.LeastUnit = smallUnit; account.UnitNum = order.UnitNum; account.MakerDicID = order.MakerDicID; account.RegTime = master.OPTime; account.RetailPrice = order.RetailPrice; account.StockPrice = order.TradePrice; account.OrderID = order.OrderDrugOCID; if (master.InvoiceNum != 0) { account.DebitFee = order.RetailFee * master.RecipeNum; account.DebitNum = order.DrugOCNum * master.RecipeNum; } else { account.DebitFee = order.RetailFee; account.DebitNum = order.DrugOCNum; } account.OverNum = storeNum; return(account); }
/// <summary> /// 根据单据信息构造台帐信息 /// </summary> /// <param name="billMaster">单据头</param> /// <param name="billOrder">单据明细信息</param> /// <param name="storeNum">库存处理后药品库存信息</param> /// <param name="accountYear">会计年份</param> /// <param name="accountMonth">会计月份</param> /// <param name="smallUnit">基本单位</param> /// <returns>台帐信息</returns> override protected YP_Account BuildAccount(BillMaster billMaster, BillOrder billOrder, decimal storeNum, int accountYear, int accountMonth, int smallUnit) { YP_Account account = new YP_Account(); YP_CheckMaster master = (YP_CheckMaster)billMaster; YP_CheckOrder order = (YP_CheckOrder)billOrder; account.AccountYear = accountYear; account.AccountMonth = accountMonth;; account.AccountType = 2; account.Balance_Flag = 0; account.BillNum = master.BillNum; account.OpType = master.OpType; account.DeptID = master.DeptID; account.LeastUnit = smallUnit; account.UnitNum = order.UnitNum; account.MakerDicID = order.MakerDicID; account.RegTime = master.AuditTime; account.RetailPrice = order.RetailPrice; account.StockPrice = order.TradePrice; account.OrderID = order.CheckOrderID; if (order.CheckNum - order.FactNum > 0) { account.LenderNum = order.CheckNum - order.FactNum; account.LenderFee = Math.Abs(order.CKRetailFee - order.FTRetailFee); } else { account.DebitNum = order.FactNum - order.CheckNum; account.DebitFee = Math.Abs(order.CKRetailFee - order.FTRetailFee); } account.OverNum = storeNum; return(account); }
public ActionResult DeleteConfirmed(int id) { BillOrder billorder = db.BillOrders.Find(id); db.BillOrders.Remove(billorder); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// 根据单据信息构造台帐信息 /// </summary> /// <param name="billMaster">单据头</param> /// <param name="billOrder">单据明细信息</param> /// <param name="storeNum">库存处理后药品库存信息</param> /// <param name="accountYear">会计年份</param> /// <param name="accountMonth">会计月份</param> /// <param name="smallUnit">基本单位</param> /// <returns>台帐信息</returns> protected override YP_Account BuildAccount(BillMaster billMaster, BillOrder billOrder, decimal storeNum, int accountYear, int accountMonth, int smallUnit) { YP_InOrder order = (YP_InOrder)billOrder; YP_Account account = base.BuildAccount(billMaster, billOrder, storeNum, accountYear, accountMonth, smallUnit); account.LenderNum = order.InNum; return(account); }
public ActionResult Edit([Bind(Include = "BillOrderID,CustormerRefId,Shipdate,OrderDate,PayDay,BillOrderMoneyTotal,PaidStatus")] BillOrder billorder) { if (ModelState.IsValid) { db.Entry(billorder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustormerRefId = new SelectList(db.Customers, "CustomerID", "CustomerName", billorder.CustormerRefId); return(View(billorder)); }
// GET: /Admin/Bill/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BillOrder billorder = db.BillOrders.Find(id); if (billorder == null) { return(HttpNotFound()); } return(View(billorder)); }
// GET: /Admin/Bill/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BillOrder billorder = db.BillOrders.Find(id); if (billorder == null) { return(HttpNotFound()); } ViewBag.CustormerRefId = new SelectList(db.Customers, "CustomerID", "CustomerName", billorder.CustormerRefId); return(View(billorder)); }
/// <summary> /// 根据单据信息构造台帐信息 /// </summary> /// <param name="billMaster">单据头</param> /// <param name="billOrder">单据明细信息</param> /// <param name="storeNum">库存处理后药品库存信息</param> /// <param name="accountYear">会计年份</param> /// <param name="accountMonth">会计月份</param> /// <param name="smallUnit">基本单位</param> /// <returns>台帐信息</returns> protected override YP_Account BuildAccount(BillMaster billMaster, BillOrder billOrder, decimal storeNum, int accountYear, int accountMonth, int smallUnit) { YP_InOrder order = (YP_InOrder)billOrder; YP_Account account = base.BuildAccount(billMaster, billOrder, storeNum, accountYear, accountMonth, smallUnit); if (account.OpType != ConfigManager.OP_YF_APPLYIN) { account.LenderNum = Convert.ToInt32(order.InNum); } else { account.LenderNum = Convert.ToInt32(order.InNum * order.UnitNum); } return(account); }
private void insertToBills(BillOrder billOrder) { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO Bills(BillNumber,SellDate,EmployeeName,CustomerID,"); sb.Append("CustomerName,ProductID,ProductName,Amount,Discount,TotalPrice)"); sb.Append(" VALUES(@BillNumber,@SellDate,@EmployeeName,CustomerID,"); sb.Append("@CustomerName,@ProductID,@ProductName,@Amount,@Discount,@TotalPrice)"); string sqlInsert = sb.ToString(); OpenConnection(); OleDbTransaction tr = Conn.BeginTransaction(); OleDbCommand com = new OleDbCommand(); com.CommandType = CommandType.Text; com.CommandText = sqlInsert; com.Connection = Conn; com.Transaction = tr; com.Parameters.Add("@BillNumber", OleDbType.BigInt).Value = billOrder.BillNumber; com.Parameters.Add("@SellDate", OleDbType.Date).Value = billOrder.SellDate; com.Parameters.Add("@EmployeeName", OleDbType.VarChar).Value = billOrder.EmployeeName; com.Parameters.Add("@CustomerID", OleDbType.VarChar).Value = billOrder.CustomerID; com.Parameters.Add("@CustomerName", OleDbType.VarChar).Value = billOrder.CustomerName; com.Parameters.Add("@ProductID", OleDbType.VarChar).Value = billOrder.ProductID; com.Parameters.Add("@ProductName", OleDbType.VarChar).Value = billOrder.ProductName; com.Parameters.Add("@Amount", OleDbType.Integer).Value = billOrder.Amount; com.Parameters.Add("@Discount", OleDbType.Double).Value = billOrder.Discount; com.Parameters.Add("@TotalPrice", OleDbType.Double).Value = billOrder.TotalPrice; try { com.ExecuteNonQuery(); tr.Commit(); CloseConnection(); } catch (Exception ex) { tr.Rollback(); CloseConnection(); MessageBox.Show(ex.Message, cstWarning); } }
private void btnSaveBill_Click(object sender, EventArgs e) { dgvSell.Columns[0].Visible = false; tbSellProductID.Enabled = false; BillOrder billOrder = new BillOrder(); billOrder.CustomerID = tbSellCustomerID.Text.Trim(); billOrder.CustomerName = tbSellCustomerName.Text.Trim(); billOrder.EmployeeName = tbSellSeller.Text.Trim(); int iDay = dtpSellDate.Value.Day; int iMonth = dtpSellDate.Value.Month; int iYear = dtpSellDate.Value.Year; if (CultureInfo.CurrentCulture.ToString() == "th-TH") { iYear = iYear + 543; } billOrder.SellDate = MyPrint16.makeDateTransaction(iDay, iMonth, iYear); billOrder.BillNumber = int.Parse(tbSellNoBill.Text.ToString()); for (int i = 0; i < dgvSell.Rows.Count; i++) { billOrder.ProductID = dgvSell.Rows[i].Cells[1].Value.ToString(); billOrder.ProductName = dgvSell.Rows[i].Cells[2].Value.ToString(); billOrder.Amount = int.Parse(dgvSell.Rows[i].Cells[4].Value.ToString()); billOrder.Discount = double.Parse(dgvSell.Rows[i].Cells[5].Value.ToString()); billOrder.TotalPrice = double.Parse(dgvSell.Rows[i].Cells[6].Value.ToString()); insertToBills(billOrder); } btnNewBill.Visible = true; btnSellCancel.Visible = false; increaseCirculation(double.Parse(tbTotalPrice.Text), billOrder.SellDate); btnDeleteOrder.Enabled = false; btnSaveBill.Enabled = false; }
public void InsetToOrder(string username, string password) { Customer customer = db.Customers.Single(x => x.CustomerAccount.Equals(username) && x.CustomerPass.Equals(password)); if (customer != null) { List <CartItem> cardItem = (List <CartItem>)Session["CartSession"]; double totalMany = 0; foreach (var item in cardItem) { totalMany = totalMany + item.Book.BookQuantity * item.Book.BookPrices; } BillOrder billOrder = new BillOrder { CustormerRefId = customer.CustomerID, BillOrderMoneyTotal = totalMany, OrderDate = DateTime.Now, PaidStatus = false, PayDay = DateTime.Now, Shipdate = DateTime.Now, Customer = customer }; db.BillOrders.Add(billOrder); db.SaveChanges(); foreach (var item in cardItem) { OrderDetail orderDetail = new OrderDetail { BillOrderRefId = billOrder.BillOrderID, BookRefId = item.Book.BookID, Quantity = item.Book.BookQuantity }; db.OrderDetails.Add(orderDetail); db.SaveChanges(); } } }
/// <summary> /// 根据单据信息构造台帐信息 /// </summary> /// <param name="billMaster">单据头</param> /// <param name="billOrder">单据明细信息</param> /// <param name="storeNum">库存处理后药品库存信息</param> /// <param name="accountYear">会计年份</param> /// <param name="accountMonth">会计月份</param> /// <param name="smallUnit">基本单位</param> /// <returns>台帐信息</returns> protected abstract YP_Account BuildAccount(BillMaster billMaster, BillOrder billOrder, decimal storeNum, int accountYear, int accountMonth, int smallUnit);
public static Task <IEnumerable <Bill> > GetBillsAsync(this FreeAgentClient client, BillFilter filterBy = BillFilter.All, BillOrder orderBy = BillOrder.DueDate, DateTime?fromDate = null, DateTime?toDate = null) { var view = filterBy.GetMemberValue(); var sort = orderBy.GetMemberValue(); return(client.GetOrCreateAsync(c => c.BillList(client.Configuration.CurrentHeader, view, sort, fromDate, toDate), r => r.Bills)); }
private void btnSaveBill_Click(object sender, EventArgs e) { dgvSell.Columns[0].Visible = false; tbSellProductID.Enabled = false; BillOrder billOrder = new BillOrder(); billOrder.CustomerID = tbSellCustomerID.Text.Trim(); billOrder.CustomerName = tbSellCustomerName.Text.Trim(); billOrder.EmployeeName = tbSellSeller.Text.Trim(); int iDay = dtpSellDate.Value.Day; int iMonth = dtpSellDate.Value.Month; int iYear = dtpSellDate.Value.Year; if (CultureInfo.CurrentCulture.ToString() == "th-TH") iYear = iYear + 543; billOrder.SellDate = MyPrint16.makeDateTransaction(iDay, iMonth, iYear); billOrder.BillNumber = int.Parse(tbSellNoBill.Text.ToString()); for (int i = 0; i < dgvSell.Rows.Count; i++) { billOrder.ProductID = dgvSell.Rows[i].Cells[1].Value.ToString(); billOrder.ProductName = dgvSell.Rows[i].Cells[2].Value.ToString(); billOrder.Amount = int.Parse(dgvSell.Rows[i].Cells[4].Value.ToString()); billOrder.Discount = double.Parse(dgvSell.Rows[i].Cells[5].Value.ToString()); billOrder.TotalPrice = double.Parse(dgvSell.Rows[i].Cells[6].Value.ToString()); insertToBills(billOrder); } btnNewBill.Visible = true; btnSellCancel.Visible = false; increaseCirculation(double.Parse(tbTotalPrice.Text), billOrder.SellDate); btnDeleteOrder.Enabled = false; btnSaveBill.Enabled = false; }