protected void Page_Load(object sender, EventArgs e) { type = Session["type"].ToString(); string exportOp = Request.QueryString["op"]; if (exportOp == "export") { export(); } SaleTaskBll saletaskBll = new SaleTaskBll(); saletaskId = Session["saleId"].ToString(); DataSet userds = saletaskBll.getcustomerName(saletaskId); customerName = userds.Tables[0].Rows[0]["customerName"].ToString(); //getData(); saleheadId = Session["saleheadId"].ToString(); saletaskId = Session["saleId"].ToString(); string op = Request["op"]; if (op == "paging") { getData(); } getSaleHeadBasic(); print(); }
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(); } } } }
private void getBook(HttpContext context) { string ISBN = context.Request["ISBN"]; string type = context.Request["type"]; DataSet bookds = bookbll.SelectByIsbn(ISBN); if (bookds != null) { string saleId = context.Request["saletaskID"]; string customerId = saletaskbll.getCustomerId(saleId); LibraryCollectionBll library = new LibraryCollectionBll(); Result libresult = library.Selectbook(customerId, ISBN); if (libresult == Result.记录不存在 || type == "continue") { SaleTaskBll saletaskbll = new SaleTaskBll(); DataSet limtds = saletaskbll.SelectBysaleTaskId(saleId); string copy = limtds.Tables[0].Rows[0]["defaultCopy"].ToString(); //如果有两条及两条以上 if (bookds.Tables[0].Rows.Count > 1) { DataTable dt = new DataTable(); dt.Columns.Add("bookNum", typeof(string)); dt.Columns.Add("rownum", typeof(int)); dt.Columns.Add("bookName", typeof(string)); dt.Columns.Add("unitPrice", typeof(double)); dt.Columns.Add("count", typeof(int)); dt.Columns.Add("color", typeof(string)); for (int i = 0; i < bookds.Tables[0].Rows.Count; i++) { int regionid = saletaskbll.GetregionidBysaleid(saleId); int count = stobll.selectStockNum(bookds.Tables[0].Rows[i]["bookNum"].ToString(), regionid); if (count == 0) { continue; } dt.Rows.Add(bookds.Tables[0].Rows[i]["bookNum"].ToString(), Convert.ToInt32((i + 1)), bookds.Tables[0].Rows[i]["bookName"].ToString(), Convert.ToDouble(bookds.Tables[0].Rows[i]["price"].ToString()), count, ""); } if (dt.Rows.Count == 1) { book book = new book(); //bookNum,ISBN,price,author,bookName,supplier int regionid = saletaskbll.GetregionidBysaleid(saleId); int count = stobll.selectStockNum(dt.Rows[0]["bookNum"].ToString(), regionid); if (count != 0) { book.BookNum = bookds.Tables[0].Rows[0]["bookNum"].ToString(); book.BookName = bookds.Tables[0].Rows[0]["bookName"].ToString(); book.Price = double.Parse(bookds.Tables[0].Rows[0]["price"].ToString()); book.count = count; if (copy == "" || copy == null) { book.number = "0"; } else { book.number = copy; } string json = JsonHelper.JsonSerializerBySingleData(book); context.Response.Write(json); context.Response.End(); } else { context.Response.Write("无库存"); context.Response.End(); } } else if (dt.Rows.Count != 0) { Page page = new Page(); if (copy == "" || copy == null) { page.number = "0"; } else { page.number = copy; } page.data = JsonHelper.ToJson(dt, "book"); page.type = "books"; string json = JsonHelper.JsonSerializerBySingleData(page); context.Response.Write(json); context.Response.End(); } else { context.Response.Write("无库存"); context.Response.End(); } } //只有一条数据 else { book book = new book(); //bookNum,ISBN,price,author,bookName,supplier int regionid = saletaskbll.GetregionidBysaleid(saleId); int count = stobll.selectStockNum(bookds.Tables[0].Rows[0]["bookNum"].ToString(), regionid); if (count != 0) { book.BookNum = bookds.Tables[0].Rows[0]["bookNum"].ToString(); book.BookName = bookds.Tables[0].Rows[0]["bookName"].ToString(); book.Price = double.Parse(bookds.Tables[0].Rows[0]["price"].ToString()); book.count = count; if (copy == "" || copy == null) { book.number = "0"; } else { book.number = copy; } string json = JsonHelper.JsonSerializerBySingleData(book); context.Response.Write(json); context.Response.End(); } else { context.Response.Write("无库存"); context.Response.End(); } } } else { context.Response.Write("馆藏存在"); context.Response.End(); } } else { context.Response.Write("无数据"); context.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(); } } }
protected void Page_Load(object sender, EventArgs e) { user = (User)Session["user"]; permission(); //获取组织 dsRegion = regionBll.select(); //获取操作员 dsUser = saleheadbll.selectCzy(); string op = Request["op"]; saleTaskid = Session["saleId"].ToString(); SaleTaskBll saleBll = new SaleTaskBll(); finishTime = saleBll.getSaleTaskFinishTime(saleTaskid); //getData(); if (op == "paging") { getData(); } string saleheadId = Request["ID"]; type = Session["type"].ToString(); //添加销售单体 if (op == "addDetail") { if (finishTime != null && finishTime != "") { Response.Write("该销售计划已完成"); Response.End(); } else { SaleMonomerBll salemonbll = new SaleMonomerBll(); int state = salemonbll.saleheadstate(saleTaskid, saleheadId); if (state == 2) { Response.Write("失败"); Response.End(); } else { Session["saleheadId"] = saleheadId; Session["saleType"] = "addsale"; Response.Write("成功"); Response.End(); } } } //if (op == "saleback") //{ // saleback(); //} if (op == "Settlement") { string salehead = Request["ID"]; string taskId = Request["taskId"]; Settlement(taskId, salehead, 0); } if (op == "SettlementAll") { SettlementAll(); } if (op == "logout") { //删除身份凭证 FormsAuthentication.SignOut(); //设置Cookie的值为空 Response.Cookies[FormsAuthentication.FormsCookieName].Value = null; //设置Cookie的过期时间为上个月今天 Response.Cookies[FormsAuthentication.FormsCookieName].Expires = DateTime.Now.AddMonths(-1); } //查看 if (op == "look") { string type = Request["type"]; Session["type"] = type; Session["saleheadId"] = saleheadId; Session["saleType"] = "look"; Response.Write("成功"); Response.End(); } //完成此销售任务 if (op == "finish") { //判断该销售任务下是否还有未完成单据0新建单据 1未完成,2完成,3未结算 SaleTaskBll salebll = new SaleTaskBll(); DataSet saleHeadStateds = salebll.SelectHeadStateBySaleId(saleTaskid); int count = saleHeadStateds.Tables[0].Rows.Count; int state = 4; for (int i = 0; i < count; i++) { state = Convert.ToInt32(saleHeadStateds.Tables[0].Rows[i]["state"]); if (state == 0 || state == 1) { break; } } if (state == 0) { Response.Write("失败,有新建的单据"); Response.End(); } if (state == 1) { Response.Write("失败,有采集中的单据"); Response.End(); } else { DateTime finishTime = DateTime.Now.ToLocalTime(); int row = salebll.updatefinishTime(finishTime, saleTaskid); if (row > 0) { Response.Write("成功"); Response.End(); } else { Response.Write("失败"); Response.End(); } } //if (state < 2) //{ // Response.Write("未完成失败"); // Response.End(); //} //else if (state == 2) //{ // DateTime finishTime = DateTime.Now.ToLocalTime(); // int row = salebll.updatefinishTime(finishTime, saleTaskid); // if (row > 0) // { // Response.Write("成功"); // Response.End(); // } // else // { // Response.Write("失败"); // Response.End(); // } //} } //添加 if (op == "add") { //获取销售任务的状态 SaleHeadBll saleheadbll = new SaleHeadBll(); SaleHead salehead = new SaleHead(); string remarks = Request["remarks"]; if (remarks == "" || remarks == null) { remarks = ""; } string saleId = Session["saleId"].ToString(); string SaleHeadId; int count = saleheadbll.getCount(); if (count > 0) { string time = saleheadbll.getSaleHeadTime(); string nowTime = DateTime.Now.ToLocalTime().ToString(); string equalsTime = DateTime.Now.ToLocalTime().ToString("yyyyMMdd"); if (time.Equals(equalsTime)) { nowTime = DateTime.Now.ToString("yyyy-MM-dd"); string getheadId = saleheadbll.getSaleHeadIdByTime(nowTime); if (getheadId == "" || getheadId == null) { count = 1; SaleHeadId = "XS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); } else { string js = getheadId.Remove(0, getheadId.Length - 6); count = Convert.ToInt32(js) + 1; SaleHeadId = "XS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); } } else { count = 1; SaleHeadId = "XS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); } } else { count = 1; SaleHeadId = "XS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); } salehead.SaleHeadId = SaleHeadId; salehead.SaleTaskId = saleId; salehead.KindsNum = 0; salehead.Number = 0; salehead.AllTotalPrice = 0; salehead.AllRealPrice = 0; User user = (User)Session["user"]; salehead.UserId = user.UserId; salehead.RegionId = user.ReginId.RegionId; salehead.DateTime = DateTime.Now.ToLocalTime(); salehead.State = 0; salehead.Remarks = remarks; Result result = saleheadbll.Insert(salehead); if (result == Result.添加成功) { Response.Write("添加成功"); Response.End(); } else { Response.Write("添加失败"); Response.End(); } } //删除 if (op == "del") { string salehead = Request["ID"]; string headstate = Request["state"]; SaleMonomerBll salemonbll = new SaleMonomerBll(); int state; if (headstate == "预采") { state = salemonbll.perSaleheadstate(saleTaskid, salehead); } else { state = salemonbll.saleheadstate(saleTaskid, salehead); } if (state == 0) { Result result = salemonbll.realDelete(saleTaskid, salehead); if (result == Result.除成功) { Response.Write("删除成功"); Response.End(); } else { Response.Write("删除失败"); Response.End(); } } else if (state == 1) { Response.Write("单据采集中"); Response.End(); } else if (state == 2) { Response.Write("单据完成"); Response.End(); } else if (state == 3) { int count = salemonbll.WeChatSelectcountbyHeadID(salehead, saleTaskid); if (count > 0) { Response.Write("该预采单已有数据,不能删除"); Response.End(); } else { Result result = salemonbll.DeleteHead(saleTaskid, salehead, "copy"); if (result == Result.除成功) { Response.Write("删除成功"); Response.End(); } else { Response.Write("删除失败"); Response.End(); } } //Result result = salemonbll.realDeleteHeadAndMon(saleTaskid, salehead); //if (result == Result.删除成功) //{ // Response.Write("删除成功"); // Response.End(); //} //else //{ // Response.Write("删除失败"); // Response.End(); //} } else { Response.Write("删除失败"); Response.End(); } } }