public void addsalemon(HttpContext context) { string SaleHeadId = context.Request["saleheadID"]; string saleId = context.Request["saletaskID"]; int number = Convert.ToInt32(context.Request["number"]); string bookNum = context.Request["bookNum"]; SaleTaskBll saletaskbll = new SaleTaskBll(); BookBasicData book = new BookBasicData(); BookBasicBll bookbll = new BookBasicBll(); if (teamtype == "team") { int regionid = saletaskbll.GetregionidBysaleid(saleId); DataSet stockbook = stobll.SelectByBookNum(bookNum, regionid); int allstockNum = 0; for (int h = 0; h < stockbook.Tables[0].Rows.Count; h++) { allstockNum += Convert.ToInt32(stockbook.Tables[0].Rows[h]["stockNum"]); } if (number > allstockNum) { context.Response.Write("库存数量不足,当前最大库存为:" + allstockNum); context.Response.End(); } else { BookBasicBll Bookbll = new BookBasicBll(); book = Bookbll.SelectById(bookNum); string remarks = book.Remarks; string defaultdiscount; string bookISBN = book.Isbn; string saleHeadId = SaleHeadId; SaleTask task = saletaskbll.selectById(saleId); defaultdiscount = task.DefaultDiscount.ToString(); if (defaultdiscount == "-1") { if (double.Parse(remarks) < 1) { remarks = (double.Parse(remarks) * 100).ToString(); } } double disCount = double.Parse(remarks); int count = salemonbll.SelectBySaleHeadId(saleHeadId); int saleIdmonomerId; if (count == 0) { saleIdmonomerId = 1; salemonbll.updateHeadstate(saleId, SaleHeadId, 1); } else { saleIdmonomerId = count + 1; } double price = Convert.ToInt32(book.Price); double totalPrice = price * number; double realPrice = totalPrice * (disCount / 100); DateTime Time = DateTime.Now.ToLocalTime(); SaleMonomer newSalemon = new SaleMonomer() { AlreadyBought = 0, SaleIdMonomerId = saleIdmonomerId, BookNum = bookNum, ISBN1 = bookISBN, SaleHeadId = saleHeadId, Number = number, UnitPrice = price, TotalPrice = totalPrice, RealPrice = realPrice, RealDiscount = disCount, Datetime = Time, SaleTaskId = saleId }; //for (int j = 0; j < stockbook.Tables[0].Rows.Count; j++) //{ // int stockNum = Convert.ToInt32(stockbook.Tables[0].Rows[j]["stockNum"]); // string goodsId = stockbook.Tables[0].Rows[j]["goodsShelvesId"].ToString(); // if (number <= stockNum) // { // int stockcount = stockNum - number; // stobll.update(stockcount, goodsId, bookNum); // } // else // { // number = number - stockNum; // stobll.update(0, goodsId, bookNum); // if (number == 0) // { // break; // } // } //} Result insertres = salemonbll.addsale(regionid, newSalemon); string op = context.Request["op"]; if (insertres == Result.添加成功) { //更新单头 updateSalehead(context); if (op == "change") { context.Response.Write("修改成功"); context.Response.End(); } else { context.Response.Write("添加成功"); context.Response.End(); } } else { if (op == "change") { context.Response.Write("修改失败"); context.Response.End(); } else { context.Response.Write("添加失败"); context.Response.End(); } } } } else { BookBasicData bookData = bookbll.SelectById(bookNum); string remarks = bookData.Remarks; string defaultdiscount; string bookISBN = bookData.Isbn; SaleTask task = saletaskbll.selectById(saleId); defaultdiscount = task.DefaultDiscount.ToString(); if (defaultdiscount == "-1") { if (double.Parse(remarks) < 1) { remarks = (double.Parse(remarks) * 100).ToString(); } } //if (remarks == "" || remarks == null) //{ // remarks = defaultdiscount; //} else { remarks = defaultdiscount; } double disCount = double.Parse(remarks); book = bookbll.SelectById(bookNum); string saleHeadId = SaleHeadId; int saleIdmonomerId; int count = salemonbll.SelectByPerSaleHeadId(saleHeadId); if (count == 0) { saleIdmonomerId = 1; salemonbll.updatePerHeadstate(saleId, SaleHeadId, 1); } else { saleIdmonomerId = count + 1; } double price = Convert.ToDouble(book.Price); double totalPrice = price * number; double realPrice = totalPrice * (disCount / 100); DateTime Time = DateTime.Now.ToLocalTime(); SaleMonomer newSalemon = new SaleMonomer() { AlreadyBought = 0, SaleIdMonomerId = saleIdmonomerId, BookNum = bookNum, ISBN1 = bookISBN, SaleHeadId = saleHeadId, Number = number, UnitPrice = price, TotalPrice = totalPrice, RealPrice = realPrice, RealDiscount = disCount, Datetime = Time, SaleTaskId = saleId }; Result res = salemonbll.perInsert(newSalemon); string op = context.Request["op"]; if (res == Result.添加成功) { //更新单头 updateSalehead(context); if (op == "change") { context.Response.Write("修改成功"); context.Response.End(); } else { context.Response.Write("添加成功"); context.Response.End(); } } else { if (op == "change") { context.Response.Write("修改失败"); context.Response.End(); } else { context.Response.Write("添加失败"); context.Response.End(); } } } }
protected void Page_Load(object sender, EventArgs e) { user = (User)Session["user"]; type = Session["saleType"].ToString(); saleId = Session["saleId"].ToString(); //getData(); getlimt(); SaleTask task = saletaskbll.selectById(saleId); defaultdiscount = task.DefaultDiscount.ToString(); SaleHeadId = Session["saleheadId"].ToString(); //更新单头 updateSalehead(); string op = Request["op"]; //isbn回车 if (op == "search") { string ISBN = Request["ISBN"]; bookds = bookbll.SelectByIsbn(ISBN); if (bookds != null) { //如果有两条及两条以上显示表格 if (bookds.Tables[0].Rows.Count > 1) { getbook(); } //只有一条数据 else { backbook(); } } else { Response.Write("无数据"); Response.End(); } } //一书多号选择后执行 if (op == "add") { showBook(); } //添加销售 if (op == "addsale") { SaleHeadBll saleheadbll = new SaleHeadBll(); string saletaskId = saleheadbll.SelectTaskByheadId(SaleHeadId); string customerId = saletaskbll.getCustomerId(saletaskId); int AlreadyBought = user.ReginId.RegionId; //判断馆藏 LibraryCollectionBll library = new LibraryCollectionBll(); bookISBN = Request["bookISBN"]; Result libresult = library.Selectbook(customerId, bookISBN); if (libresult == Result.记录不存在) { bookISBN = Request["bookISBN"]; disCount = double.Parse(Request["discount"]); number = Convert.ToInt32(Request["number"]); bookNum = Request["bookNum"].ToString(); if (number < 0) { number = Math.Abs(number); DataSet bookNumds = salemonbll.getsalemonDetail(SaleHeadId, saleId, bookNum); if (bookNumds != null) { int booknumber = int.Parse(bookNumds.Tables[0].Rows[0]["number"].ToString()); if (number > booknumber) { msg.Messege = "输入的负数不能大于已购数量,已购数为:" + booknumber; Response.Write(ObjectToJson(msg)); Response.End(); } else { number = number * -1; addsalemon(); } } else { msg.Messege = "该书籍没有购买过,数量不能为负数"; Response.Write(ObjectToJson(msg)); Response.End(); } } else { addsalemon(); } } else { msg.Messege = "客户馆藏已存在"; Response.Write(ObjectToJson(msg)); Response.End(); } } //客户馆藏已存在,继续录入 if (op == "addRsMon") { bookISBN = Request["bookISBN"]; disCount = double.Parse(Request["discount"]); number = Convert.ToInt32(Request["number"]); bookNum = Request["bookNum"].ToString(); if (number < 0) { number = Math.Abs(number); DataSet bookNumds = salemonbll.getsalemonDetail(SaleHeadId, saleId, bookNum); if (bookNumds != null) { int booknumber = int.Parse(bookNumds.Tables[0].Rows[0]["number"].ToString()); if (number > booknumber) { msg.Messege = "输入的负数不能大于已购数量,已购数为:" + booknumber; Response.Write(ObjectToJson(msg)); Response.End(); } else { number = number * -1; addsalemon(); } } else { msg.Messege = "该书籍没有购买过,数量不能为负数"; Response.Write(ObjectToJson(msg)); Response.End(); } } else { addsalemon(); } } //完成单据 if (op == "success") { //判断是否有单体 int row = salemonbll.SelectBySaleHeadId(SaleHeadId); if (row > 0) { //修改单头状态为2 Result result = salemonbll.updateHeadstate(saleId, SaleHeadId, 2); if (result == Result.更新成功) { Response.Write("状态修改成功"); Response.End(); } else { Response.Write("状态修改失败"); Response.End(); } } else { Response.Write("没有数据"); Response.End(); } } //返回按钮 if (op == "back") { updateSalehead(); int row = salemonbll.SelectBySaleHeadId(SaleHeadId); if (row > 0) { string state = salemonbll.getsaleHeadState(SaleHeadId, saleId); if (state == "0") { Result res = salemonbll.updateHeadstate(saleId, SaleHeadId, 1); if (res == Result.更新成功) { Response.Write("更新成功"); Response.End(); } else { Response.Write("更新失败"); Response.End(); } } else { Response.Write("无数据"); Response.End(); } } else { Response.Write("无数据"); Response.End(); } } }
/// <summary> /// 添加销退单头 /// </summary> public void Insert() { string saleTaskId = Session["saleId"].ToString(); SaleTaskBll saleBll = new SaleTaskBll(); SaleTask sale = saleBll.selectById(saleTaskId); User user = new User(); user.UserId = sale.UserId; //用户Id string headId; string sellId; //单头Id sellOffHeadBll sellBll = new sellOffHeadBll(); DateTime nowTime = DateTime.Now; string nowDt = nowTime.ToString("yyyy-MM-dd"); long count = 0; //判断数据库中是否已经有记录 DataSet backds = soBll.getAllTime(); if (backds != null && backds.Tables[0].Rows.Count > 0) { for (int i = 0; i < backds.Tables[0].Rows.Count; i++) { string time = backds.Tables[0].Rows[i]["makingTime"].ToString(); DateTime dt = Convert.ToDateTime(time); string sqlTime = dt.ToString("yyyy-MM-dd"); if (sqlTime == nowDt) { //count += 1; string id = backds.Tables[0].Rows[i]["sellOffHeadID"].ToString(); string st1 = id.Substring(2); count = long.Parse(st1); headId = (count + 1).ToString(); //生成流水号 if (count > 0) { sellId = "XT" + headId; } else { count = 1; sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); } SaleTask st = new SaleTask() { SaleTaskId = saleTaskId }; SellOffHead sell = new SellOffHead() { SellOffHeadId = sellId, SaleTaskId = st, MakingTime = nowTime, User = user }; Result row = sellBll.Insert(sell); if (row == Result.添加成功) { Response.Write("添加成功"); Response.End(); } else { Response.Write("添加失败"); Response.End(); } break; } else { count = 1; sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); SaleTask st = new SaleTask() { SaleTaskId = saleTaskId }; SellOffHead sell = new SellOffHead() { SellOffHeadId = sellId, SaleTaskId = st, MakingTime = nowTime, User = user }; Result row = sellBll.Insert(sell); if (row == Result.添加成功) { Response.Write("添加成功"); Response.End(); } else { Response.Write("添加失败"); Response.End(); } } } } else { count = 1; sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); SaleTask st = new SaleTask() { SaleTaskId = saleTaskId }; SellOffHead sell = new SellOffHead() { SellOffHeadId = sellId, SaleTaskId = st, MakingTime = nowTime, User = user }; Result row = sellBll.Insert(sell); if (row == Result.添加成功) { Response.Write("添加成功"); Response.End(); } else { Response.Write("添加失败"); Response.End(); } } }