/// <summary> /// 添加单体信息 /// </summary> /// <param name="monomers">单体实体对象</param> /// <returns></returns> public int insertMono(Monomers monomers) { string cmdText = "insert into T_Monomers(monId,singleHeadId,bookNum,ISBN,number,uPrice,totalPrice,realPrice,discount,shelvesId,type) values(@monId,@singleHeadId,@bookNum,@ISBN,@number,@uPrice,@totalPrice,@realPrice,@discount,@shelvesId,@type)"; string[] param = { "@monId", "@singleHeadId", "@bookNum", "@ISBN", "@number", "@uPrice", "@totalPrice", "@realPrice", "@discount", "@shelvesId", "@type" }; object[] values = { monomers.MonomersId, monomers.SingleHeadId.SingleHeadId, monomers.BookNum.BookNum, monomers.Isbn.Isbn, monomers.Number, monomers.UPrice.Price, monomers.TotalPrice, monomers.RealPrice, monomers.Discount, monomers.ShelvesId, monomers.Type }; int row = db.ExecuteNoneQuery(cmdText, param, values); return(row); }
/// <summary> /// 添加单体信息 /// </summary> /// <param name="monomers">单体实体对象</param> /// <returns></returns> public Result insertMono(Monomers monomers) { int row = monoDao.insertMono(monomers); if (row > 0) { return(Result.添加成功); } else { return(Result.添加失败); } }
/// <summary> /// 获取折扣 /// </summary> /// <param name="userID"></param> /// <returns></returns> public Monomers getDiscount() { string sql = "select disCount from T_NewBook"; Monomers monomers = new Monomers(); MySqlDataReader reader = db.ExecuteReader(sql, null, null); while (reader.Read()) { monomers.Discount = reader.GetDouble(0); } reader.Close(); return(monomers);; }
protected void selectIsbn() { //货架 GoodsShelvesBll goodsShelvesBll = new GoodsShelvesBll(); User user = (User)Session["user"]; int regionId = user.ReginId.RegionId; dsGoods = goodsShelvesBll.Select(regionId); string action = Request["action"]; string isbn = Request["isbn"]; DataTable monTable = new DataTable(); DataRow dr = monTable.NewRow(); if (action == "isbn") { long monId = Convert.ToInt64(Request["sid"]); DataSet dsBook = basicBll.SelectByIsbn(isbn); if (dsBook == null || dsBook.Tables[0].Rows.Count <= 0) { Response.Write("ISBN不存在"); Response.End(); } else { int billCount = Convert.ToInt32(Request["billCount"]); string bookName = dsBook.Tables[0].Rows[0]["bookName"].ToString(); string bookNum = dsBook.Tables[0].Rows[0]["bookNum"].ToString(); string supplier = dsBook.Tables[0].Rows[0]["supplier"].ToString(); double uPrice = Convert.ToDouble(dsBook.Tables[0].Rows[0]["price"]); if (dsBook.Tables[0].Rows[0]["author"].ToString() == null || dsBook.Tables[0].Rows[0]["author"].ToString() == "") { discount = 100; } else { discount = Convert.ToDouble(dsBook.Tables[0].Rows[0]["author"]); if (discount < 1) { discount = discount * 100; } } double totalPrice = Convert.ToDouble((billCount * uPrice).ToString("0.00")); double realPrice = Convert.ToDouble((totalPrice * discount * 0.01).ToString("0.00")); monTable.Columns.Add("ISBN", typeof(string)); monTable.Columns.Add("uPrice", typeof(double)); monTable.Columns.Add("bookName", typeof(string)); monTable.Columns.Add("bookNum", typeof(string)); monTable.Columns.Add("discount", typeof(double)); monTable.Columns.Add("monId", typeof(long)); monTable.Columns.Add("number", typeof(string)); monTable.Columns.Add("totalPrice", typeof(double)); monTable.Columns.Add("realPrice", typeof(double)); monTable.Columns.Add("singleHeadId", typeof(string)); monTable.Columns.Add("supplier", typeof(string)); dr["ISBN"] = isbn; dr["uPrice"] = uPrice; dr["bookName"] = bookName; dr["bookNum"] = bookNum; dr["discount"] = discount; dr["monId"] = monId; dr["number"] = billCount; dr["totalPrice"] = totalPrice; dr["realPrice"] = realPrice; dr["singleHeadId"] = singleHeadId; dr["supplier"] = supplier; monTable.Rows.Add(dr); int count = dsBook.Tables[0].Rows.Count; StringBuilder sb = new StringBuilder(); if (count == 1) { for (int i = 0; i < monTable.Rows.Count; i++) { bookNumList = (List <string>)Session["List"]; foreach (string bookNums in bookNumList) { if (bookNums == monTable.Rows[i]["bookNum"].ToString()) { Response.Write("已添加过此图书"); Response.End(); } } bookNumList.Add(monTable.Rows[i]["bookNum"].ToString()); Session["List"] = bookNumList; sb.Append("<tr><td>" + monTable.Rows[i]["monId"] + "</td>"); sb.Append("<td><textarea class='isbn textareaISBN' row='1' maxlength='13'>" + monTable.Rows[i]["ISBN"] + "</textarea></td>"); sb.Append("<td style='display:none'>" + monTable.Rows[i]["bookNum"] + "</td>"); sb.Append("<td>" + monTable.Rows[i]["bookName"] + "</td>"); sb.Append("<td>" + monTable.Rows[i]["supplier"] + "</td>"); sb.Append("<td><textarea class='count textareaCount' row='1'>" + 0 + "</textarea></td>"); sb.Append("<td>" + monTable.Rows[i]["uPrice"] + "</td>"); sb.Append("<td><textarea class='discount textareaDiscount' row='1'>" + monTable.Rows[i]["discount"] + "</textarea></td>"); sb.Append("<td>" + monTable.Rows[i]["totalPrice"] + "</td>"); sb.Append("<td>" + monTable.Rows[i]["realPrice"] + "</td>"); sb.Append("<td><button class='btn btn-danger btn-sm'><i class='fa fa-trash'></i></button></td></tr>"); } Response.Write(sb.ToString()); Response.End(); } else { sb.Append("<tbody>"); for (int i = 0; i < dsBook.Tables[0].Rows.Count; i++) { sb.Append("<tr><td><div class='pretty inline much'><input type = 'radio' name='radio' value='" + dsBook.Tables[0].Rows[i]["bookNum"].ToString() + "'><label><i class='mdi mdi-check'></i></label></div></td>"); sb.Append("<td>" + dsBook.Tables[0].Rows[i]["bookNum"].ToString() + "</td>"); sb.Append("<td>" + dsBook.Tables[0].Rows[i]["ISBN"].ToString() + "</td>"); sb.Append("<td>" + dsBook.Tables[0].Rows[i]["bookName"].ToString() + "</td>"); sb.Append("<td>" + dsBook.Tables[0].Rows[i]["price"].ToString() + "</td>"); sb.Append("<td>" + dsBook.Tables[0].Rows[i]["supplier"].ToString() + "</td></tr>"); } sb.Append("</tbody>"); Response.Write(sb.ToString()); Response.End(); //Response.Write("一号多书"); //Response.End(); } } } else if (action == "add") { long monId = Convert.ToInt64(Request["sid"]); monTable.Columns.Add("ISBN", typeof(string)); monTable.Columns.Add("uPrice", typeof(double)); monTable.Columns.Add("bookName", typeof(string)); monTable.Columns.Add("bookNum", typeof(string)); monTable.Columns.Add("discount", typeof(double)); monTable.Columns.Add("monId", typeof(long)); monTable.Columns.Add("number", typeof(string)); monTable.Columns.Add("totalPrice", typeof(double)); monTable.Columns.Add("realPrice", typeof(double)); monTable.Columns.Add("singleHeadId", typeof(string)); monTable.Columns.Add("supplier", typeof(string)); string bookNum = Request["bookNum"].ToString(); BookBasicData bookBasicData = basicBll.SelectById(bookNum); string supplier = bookBasicData.Publisher; string bookName = bookBasicData.BookName; string publisher = bookBasicData.Publisher; double price = bookBasicData.Price; string _isbn = bookBasicData.Isbn; string discount = bookBasicData.Author; if (discount == "" || discount == null) { discount = "100"; } bookNumList = (List <string>)Session["List"]; foreach (string bookNums in bookNumList) { if (bookNums == bookNum) { Response.Write("已添加过此图书"); Response.End(); } } dr["ISBN"] = _isbn; dr["uPrice"] = price; dr["bookName"] = bookName; dr["bookNum"] = bookNum; dr["discount"] = discount; dr["monId"] = monId; dr["number"] = 0; dr["totalPrice"] = 0; dr["realPrice"] = 0; dr["singleHeadId"] = singleHeadId; dr["supplier"] = supplier; monTable.Rows.Add(dr); for (int k = 0; k < monTable.Rows.Count; k++) { StringBuilder sb = new StringBuilder(); for (int i = 0; i < monTable.Rows.Count; i++) { sb.Append("<tr><td>" + monTable.Rows[i]["monId"] + "</td>"); sb.Append("<td><textarea class='isbn textareaISBN' row='1' maxlength='13'>" + monTable.Rows[i]["ISBN"] + "</textarea></td>"); sb.Append("<td style='display:none'>" + monTable.Rows[i]["bookNum"] + "</td>"); sb.Append("<td>" + monTable.Rows[i]["bookName"] + "</td>"); sb.Append("<td>" + monTable.Rows[i]["supplier"] + "</td>"); sb.Append("<td><textarea class='count textareaCount' row='1'>" + monTable.Rows[i]["number"] + "</textarea></td>"); sb.Append("<td>" + monTable.Rows[i]["uPrice"] + "</td>"); sb.Append("<td><textarea class='discount textareaDiscount' row='1'>" + monTable.Rows[i]["discount"] + "</textarea></td>"); sb.Append("<td>" + monTable.Rows[i]["totalPrice"] + "</td>"); sb.Append("<td>" + monTable.Rows[i]["realPrice"] + "</td>"); sb.Append("<td><button class='btn btn-danger btn-sm'><i class='fa fa-trash'></i></button></td></tr>"); bookNumList.Add(bookNum); Session["List"] = bookNumList; } Response.Write(sb.ToString()); Response.End(); } } else if (action == "save") { string json = Request["json"]; DataTable dataTable = jsonToDt(json); int Count = dataTable.Rows.Count; Monomers monomers = new Monomers(); BookBasicData book = new BookBasicData(); int count = 0, counts = 0; double total, allTotal = 0, real, allReal = 0; for (int i = 0; i < Count; i++) { DataRow drow = dataTable.Rows[i]; string bookNum = drow["书号"].ToString(); count = Convert.ToInt32(drow["数量"]); int billCount = Convert.ToInt32(drow["数量"]); string goodsId = "0"; //货架ID DataSet dsGoods = stockBll.SelectByBookNum(bookNum, user.ReginId.RegionId); //出库组织库存量 int rgId = int.Parse(Session["jsRegionId"].ToString()); //接收组织ID DataSet jsGoods = stockBll.SelectByBookNum(bookNum, rgId); //接收组织库存量 for (int j = 0; j < dsGoods.Tables[0].Rows.Count; j++) { billCount = count; int stockNum = Convert.ToInt32(dsGoods.Tables[0].Rows[j]["stockNum"]); //原库存量 goodsId = dsGoods.Tables[0].Rows[j]["goodsShelvesId"].ToString(); //获取货架ID if (billCount <= stockNum) { int a = stockNum - billCount; Result result = stockBll.update(a, goodsId, bookNum); if (result == Result.更新失败) { Response.Write("添加失败"); Response.End(); } //if (jsGoods.Tables[0].Rows.Count > 0)//判断库存中是否有数据 //{ // int jsstockNum = Convert.ToInt32(jsGoods.Tables[0].Rows[0]["stockNum"]);//接收组织原库存量 // int jsgoodsId = Convert.ToInt32(jsGoods.Tables[0].Rows[0]["goodsShelvesId"]);//接收组织库存Id // int jsNewStock = jsstockNum + billCount;//获取接收组织新的库存 // result = stockBll.update(jsNewStock, jsgoodsId, bookNum);//更新入库库存 // if (result == Result.更新失败) // { // Response.Write("更新失败"); // Response.End(); // } //} //else//没有数据时,直接添加 //{ // //int jsgoodsId = Convert.ToInt32(jsGoods.Tables[0].Rows[0]["goodsShelvesId"]);//接收组织库存Id // int jsstockNum = billCount;//库存量 // Region reg = new Region(); // reg.RegionId = rgId; // DataSet gds = goodsShelvesBll.Select(rgId); // int gid = int.Parse(gds.Tables[0].Rows[0]["goodsShelvesId"].ToString()); // GoodsShelves goods = new GoodsShelves(); // goods.GoodsShelvesId = gid; // BookBasicData jsbook = new BookBasicData(); // jsbook.BookNum = bookNum; // jsbook.Isbn = drow["ISBN号"].ToString(); // Stock stock = new Stock();//库存实体 // stock.BookNum = jsbook; // stock.ISBN = jsbook; // stock.RegionId = reg; // stock.StockNum = billCount; // stock.GoodsShelvesId = goods; // result = stockBll.insert(stock);//写入库存 // if (result == Result.添加失败) // { // Response.Write("添加失败"); // Response.End(); // } //} Session["List"] = null; break; } else { if (stockNum != 0) { Result result; count = billCount - stockNum; if (count > 0) { result = stockBll.update(0, goodsId, bookNum);//记录存在且库存不为0 if (result == Result.更新失败) { Response.Write("添加失败"); Response.End(); } count = billCount - stockNum; continue; } if (count == 0) { Session["List"] = null; break; } } //Response.Write("库存不足"); //Response.End(); } } //添加出库单体 book.Isbn = drow["ISBN号"].ToString(); book.Price = Convert.ToDouble(drow["单价"]); book.BookNum = drow["书号"].ToString(); monomers.Isbn = book; monomers.UPrice = book; monomers.BookNum = book; monomers.Discount = Convert.ToDouble(drow["折扣"]); monomers.MonomersId = Convert.ToInt32(drow["单据编号"]); monomers.Number = Convert.ToInt32(drow["数量"]); monomers.TotalPrice = Convert.ToDouble(drow["码洋"]); monomers.RealPrice = Convert.ToDouble(drow["实洋"]); monomers.ShelvesId = goodsId;//货架ID SingleHead single = new SingleHead(); single.SingleHeadId = Session["singleHeadId"].ToString(); monomers.SingleHeadId = single; count = Convert.ToInt32(drow["数量"]); counts = counts + count; total = Convert.ToDouble(drow["码洋"]); allTotal = allTotal + total; real = Convert.ToDouble(drow["实洋"]); allReal = allReal + real; Result row = warehousingBll.insertMono(monomers); if (row == Result.添加失败) { Response.Write("添加失败"); Response.End(); } //book.Isbn = drow["ISBN号"].ToString(); //book.Price = Convert.ToDouble(drow["单价"]); //book.BookNum = drow["书号"].ToString(); //monomers.Isbn = book; //monomers.UPrice = book; //monomers.BookNum = book; //monomers.Discount = Convert.ToDouble(drow["折扣"]); //monomers.MonomersId = Convert.ToInt32(drow["单据编号"]); //monomers.Number = Convert.ToInt32(drow["商品数量"]); //monomers.TotalPrice = Convert.ToDouble(drow["码洋"]); //monomers.RealPrice = Convert.ToDouble(drow["实洋"]); //SingleHead single = new SingleHead(); //single.SingleHeadId = Session["singleHeadId"].ToString(); //monomers.SingleHeadId = single; //count = Convert.ToInt32(drow["商品数量"]); //counts = counts + count; //total = Convert.ToDouble(drow["码洋"]); //allTotal = allTotal + total; //real = Convert.ToDouble(drow["实洋"]); //allReal = allReal + real; //Result row = warehousingBll.insertMono(monomers); //if (row == Result.添加失败) //{ // Response.Write("添加失败"); // Response.End(); //} //else if (row == Result.添加成功) //{ // string bookNum = drow["书号"].ToString(); // int billCount = Convert.ToInt32(drow["商品数量"]); // DataSet dsGoods = stockBll.SelectByBookNum(bookNum, user.ReginId.RegionId); // for (int j = 0; j < dsGoods.Tables[0].Rows.Count; j++) // { // billCount = count; // int stockNum = Convert.ToInt32(dsGoods.Tables[0].Rows[j]["stockNum"]); // int goodsId = Convert.ToInt32(dsGoods.Tables[0].Rows[j]["goodsShelvesId"]); // if (billCount <= stockNum) // { // int a = stockNum - billCount; // Result result = stockBll.update(a, goodsId, bookNum); // if (result == Result.更新失败) // { // Response.Write("添加失败"); // Response.End(); // } // } // else // { // count = billCount - stockNum; // Result result = stockBll.update(0, goodsId, bookNum); // if (count == 0) // { // Session["List"] = null; // Response.Write("添加成功"); // Response.End(); // } // if (result == Result.更新失败) // { // Response.Write("添加失败"); // Response.End(); // } // } // } //} } SingleHead singleHead = new SingleHead(); singleHead.SingleHeadId = Session["singleHeadId"].ToString(); singleHead.AllBillCount = counts; singleHead.AllRealPrice = allReal; singleHead.AllTotalPrice = allTotal; Result head = warehousingBll.updateHead(singleHead); if (head == Result.更新成功) { Response.Write("添加成功"); Response.End(); } else { Response.Write("添加失败"); Response.End(); } } else if (action == "changeDiscount") { double discount = Convert.ToDouble(Request["discount"]); Result result = warehousingBll.updateDiscount(discount); if (result == Result.更新成功) { Response.Write("更新成功"); Response.End(); } else { Response.Write("更新失败"); Response.End(); } } else if (action == "checkNum") { int regId = user.ReginId.RegionId; string bookNum = Request["bookNum"].ToString(); int billCount = Convert.ToInt32(Request["count"]); DataSet dsGoods = stockBll.SelectByBookNum(bookNum, regId); int j = dsGoods.Tables[0].Rows.Count; if (dsGoods != null && dsGoods.Tables[0].Rows.Count > 0) { int count = billCount; int allCount = 0, allCounts = 0; for (int i = 0; i < dsGoods.Tables[0].Rows.Count; i++) { allCount = Convert.ToInt32(dsGoods.Tables[0].Rows[i]["stockNum"]); allCounts = allCounts + allCount; } if (billCount > allCounts) { Response.Write("库存不足"); Response.End(); } } else { Response.Write("库存不足"); Response.End(); } } }