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> /// 第一次扫描isbn /// </summary> /// <param name="context"></param> public void isbn(HttpContext context) { string isbn = context.Request["isbn"]; string regionId = context.Request["regionId"]; if (isbn != null && isbn != "") { DataTable bookDs = retailBll.SelectByIsbn(isbn); if (bookDs == null) { retailM.type = "ISBN不存在"; string json = JsonHelper.JsonSerializerBySingleData(retailM); context.Response.Write(json); context.Response.End(); } else { int count = bookDs.Rows.Count; if (bookDs != null && count > 0) { if (count == 1) { string bookNum = bookDs.Rows[0]["bookNum"].ToString(); int stockNum = stockBll.selectStockNum(bookNum, Convert.ToInt32(regionId)); if (stockNum <= 0) { retailM.type = "无库存信息"; string json = JsonHelper.JsonSerializerBySingleData(retailM); context.Response.Write(json); context.Response.End(); } else { retailM.type = "一号一书"; double discount = 100; if (bookDs.Rows[0]["discount"].ToString() != null && bookDs.Rows[0]["discount"].ToString() != "") { discount = Convert.ToDouble(bookDs.Rows[0]["discount"]); } bookDs.Columns.Add("number", typeof(string)); bookDs.Rows[0]["number"] = "1"; bookDs.Columns.Add("focus", typeof(bool)); bookDs.Rows[0]["focus"] = false; bookDs.Columns.Add("totalPrice", typeof(string)); bookDs.Rows[0]["totalPrice"] = bookDs.Rows[0]["price"].ToString(); bookDs.Columns.Add("totalReal", typeof(string)); bookDs.Rows[0]["totalReal"] = (Convert.ToDouble(bookDs.Rows[0]["price"]) * discount * 0.01).ToString(); bookDs.Columns.Add("stockNum", typeof(string)); bookDs.Rows[0]["stockNum"] = stockNum.ToString(); string data = JsonHelper.ToJson(bookDs, "retail"); retailM.data = data; string json = JsonHelper.JsonSerializerBySingleData(retailM); context.Response.Write(json); context.Response.End(); } } else { retailM.type = "一号多书"; string strJson = JsonHelper.JsonSerializerBySingleData(retailM); context.Response.Write(strJson); context.Response.End(); } } else { retailM.type = "ISBN不存在"; string strJson = JsonHelper.JsonSerializerBySingleData(retailM); context.Response.Write(strJson); context.Response.End(); } } } }
/// <summary> /// 客户选择图书 /// </summary> /// <returns></returns> public string getIsbn() { string op = Request["op"]; string isbn = Request["isbn"]; double disCount = Convert.ToDouble(Request["disCount"]); int billCount = Convert.ToInt32(Request["billCount"]); if (isbn != null && isbn != "") { BookBasicBll bookBasicBll = new BookBasicBll(); DataSet bookDs = bookBasicBll.SelectByIsbn(isbn); if (bookDs != null && bookDs.Tables[0].Rows.Count > 0) { int count = bookDs.Tables[0].Rows.Count; if (count == 1) { string headId = "", bookNum = ""; if (op == "isbn") { headId = Request["headId"]; bookNum = bookDs.Tables[0].Rows[0]["bookNum"].ToString(); } else if (op == "newRetail") { headId = insertHead(); bookNum = bookDs.Tables[0].Rows[0]["bookNum"].ToString(); } add(bookNum, headId, "one"); } if (op == "choose" || op == "newChoose") { int counts = bookDs.Tables[0].Rows.Count; StringBuilder sb = new StringBuilder(); int i = 0; while (i < counts) { DataRow dr = bookDs.Tables[0].Rows[i]; User user = (User)Session["user"]; string bookNum = dr["bookNum"].ToString(); int stockNum = stockBll.selectStockNum(dr["bookNum"].ToString(), user.ReginId.RegionId); if (stockNum <= 0) { bookDs.Tables[0].Rows.RemoveAt(i); counts--; } else { i++; } } if (counts == 0) { Response.Write("无库存|:"); Response.End(); } else if (counts == 1) { string headId = ""; if (op == "choose") { headId = Request["headId"]; } else if (op == "newChoose") { headId = insertHead(); } add(bookDs.Tables[0].Rows[0]["bookNum"].ToString(), headId, "other"); } else { counts = bookDs.Tables[0].Rows.Count; for (int j = 0; j < counts; j++) { DataRow dr = bookDs.Tables[0].Rows[j]; sb.Append("<tr><td><div class='pretty inline'><input type = 'radio' name='radio' value='" + dr["bookNum"].ToString() + "'><label><i class='mdi mdi-check'></i></label></div></td>"); sb.Append("<td>" + dr["ISBN"].ToString() + "</td>"); sb.Append("<td>" + dr["bookNum"].ToString() + "</td>"); sb.Append("<td>" + dr["bookName"].ToString() + "</td>"); sb.Append("<td>" + dr["price"].ToString() + "</td>"); sb.Append("<td>" + dr["supplier"].ToString() + "</td></tr>"); } Response.Write("|:" + sb.ToString()); Response.End(); } } Response.Write("一号多书"); Response.End(); } else { Response.Write("ISBN不存在"); Response.End(); } } return(null); }