/// <summary> /// 收银删除 /// </summary> public void delete() { int retailMonomerId = Convert.ToInt32(Request["retailId"]); string retailHeadId = Request["headId"]; SaleMonomer monomer = retailBll.GetMonomer(retailMonomerId, retailHeadId); Result del = retailBll.delete(retailMonomerId, retailHeadId); if (del == Result.除成功) { string headId = Request["headId"]; SaleHead saleHead = retailBll.GetHead(headId); SaleHead newHead = new SaleHead(); newHead.SaleHeadId = headId; newHead.Number = saleHead.Number - monomer.Number; newHead.KindsNum = saleHead.KindsNum - 1; newHead.AllTotalPrice = saleHead.AllTotalPrice - monomer.TotalPrice; newHead.AllRealPrice = saleHead.AllRealPrice - monomer.RealPrice; Result head = retailBll.UpdateHeadNumber(newHead); if (head == Result.更新成功) { Response.Write("删除成功|:" + newHead.Number + "|:" + newHead.AllTotalPrice + "|:" + newHead.AllRealPrice); Response.End(); } else { Response.Write("删除失败|:"); Response.End(); } } else { Response.Write("删除失败|:"); Response.End(); } }
/// <summary> /// 查询零售单体 /// </summary> /// <param name="retailMonomerId">零售单体ID</param> /// <param name="retailHeadId">零售单头ID</param> /// <returns>数据集</returns> public SaleMonomer GetMonomer(int retailMonomerId, string retailHeadId) { string cmdText = "select retailHeadId,unitPrice,realDiscount,totalPrice,realPrice,number from V_RetailMonomer where retailMonomerId=@retailMonomerId and retailHeadId=@retailHeadId"; string[] param = { "@retailMonomerId", "@retailHeadId" }; object[] values = { retailMonomerId, retailHeadId }; DataSet ds = db.FillDataSet(cmdText, param, values); if (ds == null || ds.Tables[0].Rows.Count <= 0) { return(null); } else { SaleMonomer sale = new SaleMonomer(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { sale.UnitPrice = Convert.ToDouble(ds.Tables[0].Rows[i]["unitPrice"]); sale.RealDiscount = Convert.ToDouble(ds.Tables[0].Rows[i]["realDiscount"]); sale.TotalPrice = Convert.ToDouble(ds.Tables[0].Rows[i]["totalPrice"]); sale.RealPrice = Convert.ToDouble(ds.Tables[0].Rows[i]["realPrice"]); sale.Number = Convert.ToInt32(ds.Tables[0].Rows[i]["number"]); sale.SaleHeadId = ds.Tables[0].Rows[i]["retailHeadId"].ToString(); } return(sale); } }
/// <summary> /// 更新零售数量 /// </summary> /// <param name="sale">零售实体对象</param> /// <returns>受影响行数</returns> public int UpdateNumber(SaleMonomer sale) { string cmdText = "update T_RetailMonomer set number=@number,totalPrice=@totalPrice,realPrice=@realPrice where retailMonomerId=@retailMonomerId and retailHeadId=@retailHeadId"; string[] param = { "@number", "totalPrice", "@realPrice", "@retailMonomerId", "@retailHeadId" }; object[] values = { sale.Number, sale.TotalPrice, sale.RealPrice, sale.SaleIdMonomerId, sale.SaleHeadId }; int row = db.ExecuteNoneQuery(cmdText, param, values); return(row); }
/// <summary> /// 添加零售单体 /// </summary> /// <param name="task">零售单体实体</param> /// <returns>受影响行数</returns> public int InsertRetail(SaleMonomer salemonomer) { string cmdText = "insert into T_RetailMonomer(retailMonomerId,bookNum,ISBN,retailHeadId,number,unitPrice,totalPrice,realDiscount,realPrice,dateTime) values(@saleIdMonomerId,@bookNum,@ISBN,@saleHeadId,@number,@unitPrice,@totalPrice,@realDiscount,@realPrice,@dateTime)"; string[] param = { "@saleIdMonomerId", "@bookNum", "@ISBN", "@saleHeadId", "@number", "@unitPrice", "@totalPrice", "@realDiscount", "@realPrice", "@dateTime" }; object[] values = { salemonomer.SaleIdMonomerId, salemonomer.BookNum, salemonomer.ISBN1, salemonomer.SaleHeadId, salemonomer.Number, salemonomer.UnitPrice, salemonomer.TotalPrice, salemonomer.RealDiscount, salemonomer.RealPrice, salemonomer.Datetime }; int row = db.ExecuteNoneQuery(cmdText, param, values); return(row); }
/// <summary> /// 零售单体添加 /// </summary> /// <param name="salemonomer">零售单体实体</param> /// <returns>返回结果</returns> public Result InsertRetail(SaleMonomer salemonomer) { int row = dao.InsertRetail(salemonomer); if (row > 0) { return(Result.添加成功); } else { return(Result.添加失败); } }
/// <summary> /// 预采单体添加 /// </summary> /// <param name="salemonomer">单体实体</param> /// <returns>返回结果</returns> public Result perInsert(SaleMonomer salemonomer) { int row = SaleMonomerdao.perInsert(salemonomer); if (row > 0) { return(Result.添加成功); } else { return(Result.添加失败); } }
/// <summary> /// 更新销售单体 /// </summary> /// <param name="salemonomer">销售单体实体</param> /// <returns></returns> public Result Update(SaleMonomer salemonomer) { int row = SaleMonomerdao.Update(salemonomer); if (row > 0) { return(Result.更新成功); } else { return(Result.更新失败); } }
/// <summary> /// 更新零售数量 /// </summary> /// <param name="sale">零售实体对象</param> /// <returns>受影响行数</returns> public Result UpdateNumber(SaleMonomer sale) { int row = dao.UpdateNumber(sale); if (row > 0) { return(Result.更新成功); } else { return(Result.更新失败); } }
/// <summary> /// 添加现采销售单体 /// </summary> /// <param name="RegionId">地区id</param> /// <param name="sale">销售单体</param> /// <returns></returns> public Result addsale(int RegionId, SaleMonomer sale) { string saleText = "insert into T_SaleMonomer set saleIdMonomerId=" + sale.SaleIdMonomerId + ",bookNum='" + sale.BookNum + "',ISBN='" + sale.ISBN1 + "',saleHeadId='" + sale.SaleHeadId + "',number=" + sale.Number + ",unitPrice=" + sale.UnitPrice + ",totalPrice=" + sale.TotalPrice + ",realDiscount=" + sale.RealDiscount + ",realPrice=" + sale.RealPrice + ",dateTime='" + sale.Datetime + "',alreadyBought=" + sale.AlreadyBought + ",saleTaskId='" + sale.SaleTaskId + "'"; string stockText = "select goodsShelvesId,stockNum from T_Stock where bookNum = '" + sale.BookNum + "' and regionId = " + RegionId + " order by stockNum asc"; int row = SaleMonomerdao.addsale(saleText, stockText, sale); if (row > 0) { return(Result.添加成功); } else { return(Result.添加失败); } }
/// <summary> /// 根据书号查找isbn,单价,折扣 /// </summary> /// <param name="bookNum">书号</param> /// <returns></returns> public SaleMonomer SelectBookNum(string bookNum, string retailHeadId) { MySqlHelp db = new MySqlHelp(); string comTexts = "select count(*) from T_RetailMonomer where bookNum=@bookNum and retailHeadId=@retailHeadId"; string[] parames = { "@bookNum", "@retailHeadId" }; object[] value = { bookNum, retailHeadId }; int row = Convert.ToInt32(db.ExecuteScalar(comTexts, parames, value)); if (row == 0) { return(null); } else { string comText = "select bookName,bookNum,ISBN,number,unitPrice,realDiscount,totalPrice,realPrice from V_RetailMonomer where bookNum=@bookNum"; string[] param = { "@bookNum" }; object[] values = { bookNum }; DataSet ds = db.FillDataSet(comText, param, values); if (ds != null || ds.Tables[0].Rows.Count > 0) { SaleMonomer retail = new SaleMonomer(); retail.ISBN1 = ds.Tables[0].Rows[0]["ISBN"].ToString(); retail.BookName = ds.Tables[0].Rows[0]["bookName"].ToString(); retail.BookNum = ds.Tables[0].Rows[0]["bookNum"].ToString(); retail.Number = Convert.ToInt32(ds.Tables[0].Rows[0]["number"]); retail.UnitPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["unitPrice"]); retail.RealDiscount = Convert.ToDouble(ds.Tables[0].Rows[0]["realDiscount"]); retail.TotalPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["totalPrice"]); retail.RealPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["realPrice"]); return(retail); } else { return(null); } } }
/// <summary> /// 收银添加图书 /// </summary> /// <param name="bookNum"></param> public void add(string bookNum, string headId, string addType) { Result record = retailBll.selectByBookNum(bookNum, headId); if (record == Result.记录不存在) { BookBasicData bookBasicData = basicBll.SelectById(bookNum); string isbn = bookBasicData.Isbn; string bookName = bookBasicData.BookName; double discount = 100; if (bookBasicData.Remarks != "") { discount = Convert.ToDouble(bookBasicData.Remarks); } discount = discount * 0.01; int billCount = Convert.ToInt32(Request["billCount"]); if (billCount <= 0) { billCount = 1; } int row = monTable.Rows.Count; double uPrice = bookBasicData.Price; SaleMonomer monomers = new SaleMonomer(); double totalPrice = Convert.ToDouble((billCount * uPrice).ToString("0.00")); double realPrice = Convert.ToDouble((totalPrice * discount).ToString("0.00")); DataSet ds = retailBll.GetRetail(headId); int monId = 0; if (ds != null && ds.Tables[0].Rows.Count > 0) { int k = ds.Tables[0].Rows.Count - 1; monId = Convert.ToInt32(ds.Tables[0].Rows[k]["retailMonomerId"]); } monomers.ISBN1 = isbn; monomers.UnitPrice = uPrice; monomers.BookNum = bookNum; monomers.SaleIdMonomerId = monId + 1; monomers.RealDiscount = discount * 100; monomers.Number = 1; monomers.TotalPrice = uPrice; monomers.RealPrice = uPrice * discount; monomers.SaleHeadId = headId; monomers.Datetime = Convert.ToDateTime(com.getDate()); Result mon = retailBll.InsertRetail(monomers); if (mon == Result.添加成功) { SaleHead sale = retailBll.GetHead(headId); SaleHead newSale = new SaleHead(); newSale.SaleHeadId = headId; newSale.KindsNum = sale.KindsNum + 1; newSale.Number = sale.Number + 1; newSale.AllTotalPrice = sale.AllTotalPrice + monomers.TotalPrice; newSale.AllRealPrice = sale.AllRealPrice + monomers.RealPrice; Result update = retailBll.UpdateHeadNumber(newSale); if (update == Result.更新成功) { StringBuilder sb = new StringBuilder(); DataSet dsNew = retailBll.GetRetail(headId); if (dsNew != null && dsNew.Tables[0].Rows.Count > 0) { int counts = dsNew.Tables[0].Rows.Count; for (int i = 0; i < counts; i++) { DataRow dr = dsNew.Tables[0].Rows[i]; sb.Append("<tr><td>" + dr["retailMonomerId"].ToString() + "</td>"); sb.Append("<td>" + dr["ISBN"].ToString() + "</td>"); sb.Append("<td>" + dr["bookName"].ToString() + "</td>"); sb.Append("<td>" + dr["unitPrice"].ToString() + "</td>"); sb.Append("<td style='display:none'>" + dr["number"].ToString() + "</td>"); //sb.Append("<td><input class='numberEnd' type='number' style='width:50px;border:none;' name='points',min='1' value='" + dr["number"].ToString() + "'/></td>"); sb.Append("<td><div class='gw_num' style='width:100%'><em class='jian' style='height:100%;width:40%;'>-</em>"); sb.Append("<input type = 'text' min='1' value='" + dr["number"].ToString() + "' class='num' readonly='readonly' style='width:20%;height:100%'/>"); sb.Append("<em class='add' style='height:100%;width:40%;'>+</em></div></td>"); sb.Append("<td>" + dr["realDiscount"].ToString() + "</td>"); sb.Append("<td>" + dr["totalPrice"].ToString() + "</td>"); sb.Append("<td>" + dr["realPrice"].ToString() + "</td>"); sb.Append("<td style='display:none'>" + dr["bookNum"].ToString() + "</td>"); sb.Append("<td><button class='btn btn-danger btn-sm delete'><i class='fa fa-trash'></i></button></td></tr>"); } if (addType == "other") { Response.Write(addType + "|:" + sb.ToString() + "|:" + newSale.KindsNum + "," + newSale.Number + "," + newSale.AllTotalPrice + "," + newSale.AllRealPrice + "|:" + headId); Response.End(); } else { Response.Write(sb.ToString() + "|:" + newSale.KindsNum + "," + newSale.Number + "," + newSale.AllTotalPrice + "," + newSale.AllRealPrice + "|:" + headId); Response.End(); } } } else { Response.Write("添加失败|:"); Response.End(); } } else { Response.Write("添加失败|:"); Response.End(); } } else { Response.Write("已添加过此图书|:"); Response.End(); } }
public void insert() { string json = Request["json"]; DataTable dataTable = jsonToDt(json); int row, rows = 0; double total, allTotal = 0, real, allReal = 0; int Counts = dataTable.Rows.Count; for (int i = 0; i < Counts; i++) { DataRow dr = dataTable.Rows[i]; row = Convert.ToInt32(dr["数量"]); total = Convert.ToDouble(dr["码洋"]); real = Convert.ToDouble(dr["实洋"]); rows = rows + row; allTotal = allTotal + total; allReal = allReal + real; } User user = (User)Session["user"]; DateTime nowTime = DateTime.Now; string nowDt = nowTime.ToString("yyyy-MM-dd"); long count = 0; //生成流水号方法 DataSet backds = retailBll.getAllTime(2); 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]["dateTime"].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]["retailHeadId"].ToString(); string st1 = id.Substring(10); long rowes = long.Parse(st1) + 1; count = rowes; break; } } if (count == 0) { count = 1; } } else { count = 1; } //添加单头 string retailHeadId = "LT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); single.AllRealPrice = 0 - Math.Abs(allReal); single.AllTotalPrice = 0 - Math.Abs(allTotal); single.KindsNum = Counts; single.Number = 0 - Math.Abs(rows); single.RegionId = user.ReginId.RegionId; single.SaleHeadId = retailHeadId; single.UserId = user.UserId; single.DateTime = DateTime.Now; single.State = 2; single.PayType = "退款"; Result result = retailBll.InsertRetail(single); if (result == Result.添加成功) {//添加单体 Session["List"] = new List <string>(); SaleMonomer monomers = new SaleMonomer(); int Count = dataTable.Rows.Count; for (int i = 0; i < Count; i++) { DataRow dr = dataTable.Rows[i]; monomers.ISBN1 = dr["ISBN"].ToString(); monomers.UnitPrice = Convert.ToDouble(dr["单价"]); monomers.BookNum = dr["书号"].ToString(); monomers.RealDiscount = Convert.ToDouble(dr["折扣"]); monomers.SaleIdMonomerId = i + 1; monomers.Number = 0 - Math.Abs(Convert.ToInt32(dr["数量"])); monomers.TotalPrice = 0 - Math.Abs(Convert.ToDouble(dr["码洋"])); monomers.RealPrice = 0 - Math.Abs(Convert.ToDouble(dr["实洋"])); monomers.SaleHeadId = retailHeadId; monomers.Datetime = DateTime.Now; DataSet dsStock = stockBll.SelectByBookNum(monomers.BookNum, user.ReginId.RegionId); if (dsStock == null || dsStock.Tables[0].Rows.Count <= 0) { Response.Write("库存不足"); Response.End(); } else { string goodsId = dsStock.Tables[0].Rows[0]["goodsShelvesId"].ToString(); int stockNum = Convert.ToInt32(dsStock.Tables[0].Rows[0]["stockNum"]); Result stock = stockBll.update(stockNum + Math.Abs(monomers.Number), goodsId, monomers.BookNum); if (stock == Result.更新失败) { Response.Write("更新失败"); Response.End(); } else { Result mon = retailBll.InsertRetail(monomers); if (mon == Result.添加失败) { Response.Write("添加失败"); Response.End(); } } } } Response.Write("添加成功"); Response.End(); } else { Response.Write("添加失败"); Response.End(); } }
public void add(string bookNum, string headId) { bookNumList = (List <string>)Session["List"]; foreach (string bookNums in bookNumList) { if (bookNums == bookNum) { Response.Write("已添加过此图书"); Response.End(); } } Result isBookNum = retailBll.selectByBookNum(bookNum, headId); if (isBookNum == Result.记录不存在) { Response.Write("记录不存在"); Response.End(); } else { SaleMonomer retail = retailBll.SelectBookNum(bookNum, headId); string isbn = retail.ISBN1; string bookName = retail.BookName; int billCount = Convert.ToInt32(Request["billCount"]); double discount = retail.RealDiscount; int row = monTable.Rows.Count; double uPrice = retail.UnitPrice; SaleMonomer monomers = new SaleMonomer(); //double totalPrice = Convert.ToDouble((billCount * uPrice).ToString("0.00")); //double realPrice = Convert.ToDouble((totalPrice * discount).ToString("0.00")); monTable.Columns.Add("ISBN", typeof(string)); monTable.Columns.Add("unitPrice", typeof(double)); monTable.Columns.Add("bookNum", typeof(string)); monTable.Columns.Add("bookName", typeof(string)); monTable.Columns.Add("realDiscount", typeof(double)); monTable.Columns.Add("number", typeof(int)); monTable.Columns.Add("totalPrice", typeof(double)); monTable.Columns.Add("realPrice", typeof(double)); DataRow monRow = monTable.NewRow(); monRow["ISBN"] = isbn; monRow["unitPrice"] = uPrice; monRow["bookNum"] = bookNum; monRow["bookName"] = bookName; monRow["realDiscount"] = discount; monRow["number"] = retail.Number; monRow["totalPrice"] = uPrice; monRow["realPrice"] = uPrice * discount * 0.01; monTable.Rows.Add(monRow); StringBuilder sb = new StringBuilder(); int counts = monTable.Rows.Count; for (int i = 0; i < counts; i++) { bookNumList.Add(bookNum); Session["List"] = bookNumList; DataRow dr = monTable.Rows[i]; sb.Append("<tr><td>" + dr["ISBN"].ToString() + "</td>"); sb.Append("<td>" + dr["bookName"].ToString() + "</td>"); sb.Append("<td>" + dr["unitPrice"].ToString() + "</td>"); sb.Append("<td style='display:none'>" + dr["number"].ToString() + "</td>"); sb.Append("<td><input class='number' type='number' style='width:50px;border:none;' name='points' min='1' max='" + dr["number"].ToString() + "' value='" + dr["number"].ToString() + "'/></td>"); sb.Append("<td>" + dr["realDiscount"].ToString() + "</td>"); sb.Append("<td>" + dr["totalPrice"].ToString() + "</td>"); sb.Append("<td>" + dr["realPrice"].ToString() + "</td>"); sb.Append("<td style='display:none'>" + dr["bookNum"].ToString() + "</td>"); sb.Append("<td><button class='btn btn-danger btn-sm btn-delete'><i class='fa fa-trash'></i></button></td>"); sb.Append("<td style='display:none'>" + dr["number"].ToString() + "</td></tr>"); } Response.Write(sb.ToString()); Response.End(); } }
public void insert() { string json = Request["json"]; DataTable dataTable = jsonToDt(json); int row, rows = 0; double total, allTotal = 0, real, allReal = 0; int Counts = dataTable.Rows.Count; for (int i = 0; i < Counts; i++) { DataRow dr = dataTable.Rows[i]; row = Convert.ToInt32(dr["数量"]); total = Convert.ToDouble(dr["码洋"]); real = Convert.ToDouble(dr["实洋"]); rows = rows + row; allTotal = allTotal + total; allReal = allReal + real; } DateTime nowTime = Convert.ToDateTime(com.getDate()); string nowDt = nowTime.ToString("yyyy-MM-dd"); long count = 0; //判断数据库中是否已经有记录 DataSet backds = retailBll.getAllTime(0); if (backds != null && backds.Tables[0].Rows.Count > 0) { string time = backds.Tables[0].Rows[0]["dateTime"].ToString(); DateTime dt = Convert.ToDateTime(time); string sqlTime = dt.ToString("yyyy-MM-dd"); if (sqlTime == nowDt) { //count += 1; string id = backds.Tables[0].Rows[0]["retailHeadId"].ToString(); int st1 = Convert.ToInt32(id.Substring(10)); if (st1 <= 0) { st1 = 0; } count = st1 + 1; } else { count = 1; } } else { count = 1; } string retailHeadId = "LS" + Convert.ToDateTime(com.getDate()).ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); single.AllRealPrice = allReal; single.AllTotalPrice = allTotal; single.KindsNum = Counts; single.Number = rows; single.RegionId = user.ReginId.RegionId; single.SaleHeadId = retailHeadId; single.UserId = user.UserId; single.DateTime = Convert.ToDateTime(com.getDate()); single.State = 0; single.PayType = "未支付"; headID = retailHeadId; Result result = retailBll.InsertRetail(single); if (result == Result.添加成功) { Session["List"] = new List <long>(); SaleMonomer monomers = new SaleMonomer(); int Count = dataTable.Rows.Count; for (int i = 0; i < Count; i++) { DataRow dr = dataTable.Rows[i]; monomers.ISBN1 = dr["ISBN"].ToString(); monomers.UnitPrice = Convert.ToDouble(dr["单价"]); monomers.BookNum = dr["书号"].ToString(); monomers.RealDiscount = Convert.ToDouble(dr["折扣"]); monomers.SaleIdMonomerId = i + 1; monomers.Number = Convert.ToInt32(dr["数量"]); monomers.TotalPrice = Convert.ToDouble(dr["码洋"]); monomers.RealPrice = Convert.ToDouble(dr["实洋"]); monomers.SaleHeadId = retailHeadId; monomers.Datetime = Convert.ToDateTime(com.getDate()); Result mon = retailBll.InsertRetail(monomers); if (mon == Result.添加失败) { Response.Write("添加失败|:"); Response.End(); } } Response.Write("添加成功|:" + retailHeadId); Response.End(); } else { Response.Write("添加失败|:"); Response.End(); } }
/// <summary> /// 添加销售 /// </summary> public void addsalemon() { string headState = salemonbll.getsaleHeadState(SaleHeadId, saleId); if (headState == "2") { msg.Messege = "该单据已完成,不能再添加数据!"; Response.Write(ObjectToJson(msg)); Response.End(); } else { int RegionId = user.ReginId.RegionId; DataSet stockbook = stockbll.SelectByBookNum(bookNum, RegionId); 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) { msg.Messege = "库存不足,当前最大库存为:" + allstockNum; Response.Write(ObjectToJson(msg)); Response.End(); } else { BookBasicBll Bookbll = new BookBasicBll(); BookBasicData book = new BookBasicData(); book = Bookbll.SelectById(bookNum); string saleHeadId = SaleHeadId; int count = salemonbll.SelectBySaleHeadId(saleHeadId); 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; // stockbll.update(stockcount, goodsId, bookNum); // } // else // { // number = number - stockNum; // stockbll.update(0, goodsId, bookNum); // if (number == 0) // { // break; // } // } //} Result res = salemonbll.addsale(RegionId, newSalemon); if (res == Result.添加成功) { updateSalehead(); msg.DataTable = getData(); msg.DataTable1 = "<tr class='first'> <td></td><td><input type='text' id='ISBN' class='isbn textareaISBN' /> </td><td></td><td></td><td></td><td><input class='count textareaCount' type='number'/></td><td><input class='discount textareaDiscount' onkeyup='this.value=this.value.replace(/[^\r\n0-9]/g,'');' /></td><td></td><td></td></tr>"; msg.AllKinds = allkinds.ToString(); msg.Number = allnumber.ToString(); msg.AlltotalPrice = alltotalprice.ToString(); msg.AllrealPrice = allreadprice.ToString(); msg.Messege = "添加成功"; Response.Write(ObjectToJson(msg)); Response.End(); } else { msg.Messege = "添加失败"; Response.Write(ObjectToJson(msg)); Response.End(); } } } }
/// <summary> /// 插入数据库 /// </summary> /// <param name="context"></param> public void insert(HttpContext context) { string openid = context.Request["openid"]; string json = context.Request["data"]; DataTable dataTable = jsonToDt(json); string kindNum = context.Request["kindNum"]; string totalNumber = context.Request["totalNumber"]; string totalPrice = context.Request["totalPrice"]; string totalReal = context.Request["totalReal"]; string userId = context.Request["userid"]; DateTime nowTime = DateTime.Now; string nowDt = nowTime.ToString("yyyy-MM-dd"); long count = 0; //判断数据库中是否已经有记录 DataSet backds = retailBll.getAllTime(0); if (backds != null && backds.Tables[0].Rows.Count > 0) { for (int j = 0; j < backds.Tables[0].Rows.Count; j++) { string time = backds.Tables[0].Rows[j]["dateTime"].ToString(); DateTime dt = Convert.ToDateTime(time); string sqlTime = dt.ToString("yyyy-MM-dd"); if (sqlTime == nowDt) { //count += 1; string id = backds.Tables[0].Rows[j]["retailHeadId"].ToString(); int st1 = Convert.ToInt32(id.Substring(10)); if (st1 <= 0) { st1 = 0; } count = st1 + 1; break; } else { count = 1; break; } } if (count == 0) { count = 1; } } else { count = 1; } int Length = userId.Length; string regionId = userId.Substring(0, userId.Length - 2); string retailHeadId = "LS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0'); single.AllRealPrice = Convert.ToDouble(totalReal); single.AllTotalPrice = Convert.ToDouble(totalPrice); single.KindsNum = Convert.ToInt32(kindNum); single.Number = Convert.ToInt32(totalNumber); single.RegionId = Convert.ToInt32(regionId); single.SaleHeadId = retailHeadId; single.UserId = userId; single.DateTime = DateTime.Now; single.State = 0; single.PayType = "未支付"; single.OpenId = openid; Result result = retailBll.Insert(single); if (result == Result.添加成功) { SaleMonomer monomers = new SaleMonomer(); int Count = dataTable.Rows.Count; for (int i = 0; i < Count; i++) { DataRow dr = dataTable.Rows[i]; monomers.ISBN1 = dr["ISBN"].ToString(); monomers.UnitPrice = Convert.ToDouble(dr["price"]); monomers.BookNum = dr["bookNum"].ToString(); monomers.RealDiscount = Convert.ToDouble(dr["discount"]); monomers.SaleIdMonomerId = i + 1; monomers.Number = Convert.ToInt32(dr["number"]); monomers.TotalPrice = Convert.ToDouble(dr["totalPrice"]); monomers.RealPrice = Convert.ToDouble(dr["totalReal"]); monomers.SaleHeadId = retailHeadId; monomers.Datetime = DateTime.Now; Result mon = retailBll.InsertRetail(monomers); if (mon == Result.添加失败) { retailM.type = "添加失败"; string jsonFail = JsonHelper.JsonSerializerBySingleData(retailM); context.Response.Write(jsonFail); context.Response.End(); } } retailM.type = "添加成功"; retailM.retailHeadId = retailHeadId; string jsonSucc = JsonHelper.JsonSerializerBySingleData(retailM); context.Response.Write(jsonSucc); context.Response.End(); } else { retailM.type = "添加失败"; string jsonFail = JsonHelper.JsonSerializerBySingleData(retailM); context.Response.Write(jsonFail); context.Response.End(); } }
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(); } } } }
/// <summary> /// 收银修改数量 /// </summary> public void change() { string type = Request["type"]; int number = Convert.ToInt32(Request["number"]); int retailId = Convert.ToInt32(Request["retailId"]); string headId = Request["headId"]; SaleMonomer monomer = retailBll.GetMonomer(retailId, headId); int oldNumber = monomer.Number; double oldTotal = monomer.TotalPrice; double oldReal = monomer.RealPrice; double price = monomer.UnitPrice; double realDiscount = monomer.RealDiscount; double total = 0, real = 0; SaleMonomer sale = new SaleMonomer(); sale.SaleIdMonomerId = retailId; sale.Number = number; sale.TotalPrice = number * price; sale.RealPrice = number * price * realDiscount * 0.01; sale.SaleHeadId = headId; Result change = retailBll.UpdateNumber(sale); if (change == Result.更新成功) { SaleHead head = retailBll.GetHead(headId); SaleHead newHead = new SaleHead(); int newNumber = 0; double newTotal = 0, newReal = 0; if (type == "jia") { newNumber = head.Number + 1; newTotal = head.AllTotalPrice + price; newReal = head.AllRealPrice + (price * realDiscount * 0.01); } else if (type == "jian") { newNumber = head.Number - 1; newTotal = head.AllTotalPrice - price; newReal = head.AllRealPrice - (price * realDiscount * 0.01); } newHead.SaleHeadId = headId; newHead.Number = newNumber; newHead.AllTotalPrice = newTotal; newHead.AllRealPrice = newReal; newHead.KindsNum = head.KindsNum; Result headRe = retailBll.UpdateHeadNumber(newHead); if (headRe == Result.更新成功) { Response.Write("更新成功|:" + newNumber + "," + newTotal + "," + newReal + "|:" + total + "|:" + real); Response.End(); } else { Response.Write("更新失败|:"); Response.End(); } } else { Response.Write("更新失败|:"); Response.End(); } }
/// <summary> /// 添加销售单体,并更新库存 /// </summary> /// <param name="saleText">添加单体语句</param> /// <param name="stockText">查询库存语句</param> /// <param name="sale">销售单体</param> /// <returns></returns> public int addsale(string saleText, string stockText, SaleMonomer sale) { OpenConn(); int error = 1; MySqlTransaction tran = sqlConn.BeginTransaction(); MySqlCommand myCmd; myCmd = new MySqlCommand(saleText, sqlConn); myCmd.Transaction = tran; try { //添加单体信息 myCmd.ExecuteNonQuery(); //查询库存数据 MySqlCommand myCmdQueryBookss = new MySqlCommand(stockText, sqlConn); MySqlDataAdapter myAdp = new MySqlDataAdapter(myCmdQueryBookss); DataSet ds = new DataSet(); myAdp.Fill(ds); int number = sale.Number; for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { int stockNum = Convert.ToInt32(ds.Tables[0].Rows[j]["stockNum"]); string goodsId = ds.Tables[0].Rows[j]["goodsShelvesId"].ToString(); if (number <= stockNum) { int stockcount = stockNum - number; //更新库存 string upcmd = "update T_Stock set stockNum=" + stockcount + " where goodsShelvesId=" + goodsId + " and bookNum='" + sale.BookNum + "'"; MySqlCommand myCmdupdate = new MySqlCommand(upcmd, sqlConn); try { myCmdupdate.ExecuteNonQuery(); if ((number == stockNum) || number < 0) { break; } } catch (Exception ex) { error = 0; throw ex; } } else { number = number - stockNum; MySqlCommand myCmdupdate = new MySqlCommand("update T_Stock set stockNum=" + 0 + " where goodsShelvesId=" + goodsId + " and bookNum='" + sale.BookNum + "'", sqlConn); try { myCmdupdate.ExecuteNonQuery(); } catch (Exception ex) { error = 0; throw ex; } if (number == 0) { break; } } } tran.Commit(); return(error); } catch (Exception ex) { error = 0; tran.Rollback(); return(error); throw ex; } finally { CloseConn(); } }
public void add(string bookNum, string addType) { bookNumList = (List <string>)Session["List"]; foreach (string bookNums in bookNumList) { if (bookNums == bookNum) { if (addType == "other") { Response.Write("已添加过此图书|:"); Response.End(); } else { Response.Write("已添加过此图书"); Response.End(); } } } BookBasicData bookBasicData = basicBll.SelectById(bookNum); string isbn = bookBasicData.Isbn; string bookName = bookBasicData.BookName; double discount = 100; if (bookBasicData.Remarks == "") { discount = 100; } else { discount = Convert.ToInt32(bookBasicData.Remarks); if (discount <= 1) { discount = discount * 100; } } int row = monTable.Rows.Count; double uPrice = bookBasicData.Price; SaleMonomer monomers = new SaleMonomer(); monTable.Columns.Add("ISBN", typeof(string)); monTable.Columns.Add("unitPrice", typeof(double)); monTable.Columns.Add("bookNum", typeof(long)); monTable.Columns.Add("bookName", typeof(string)); monTable.Columns.Add("realDiscount", typeof(double)); monTable.Columns.Add("number", typeof(int)); monTable.Columns.Add("totalPrice", typeof(double)); monTable.Columns.Add("realPrice", typeof(double)); DataRow monRow = monTable.NewRow(); monRow["ISBN"] = isbn; monRow["unitPrice"] = uPrice; monRow["bookNum"] = bookNum; monRow["bookName"] = bookName; monRow["realDiscount"] = discount; monRow["number"] = 1; monRow["totalPrice"] = uPrice; monRow["realPrice"] = uPrice * discount * 0.01; monTable.Rows.Add(monRow); StringBuilder sb = new StringBuilder(); int counts = monTable.Rows.Count; for (int i = 0; i < counts; i++) { bookNumList.Add(bookNum); Session["List"] = bookNumList; DataRow dr = monTable.Rows[i]; sb.Append("<tr><td>" + dr["ISBN"].ToString() + "</td>"); sb.Append("<td>" + dr["bookName"].ToString() + "</td>"); sb.Append("<td>" + dr["unitPrice"].ToString() + "</td>"); sb.Append("<td style='display:none'>" + dr["number"].ToString() + "</td>"); sb.Append("<td><div class='gw_num' style='width:100%'><em class='jian' style='height:100%;width:40%;'>-</em>"); sb.Append("<input type = 'text' min='1' value='" + dr["number"].ToString() + "' class='num' readonly='readonly' style='width:20%;height:100%'/>"); sb.Append("<em class='add' style='height:100%;width:40%;'>+</em></div></td>"); sb.Append("<td>" + dr["realDiscount"].ToString() + "</td>"); sb.Append("<td>" + dr["totalPrice"].ToString() + "</td>"); sb.Append("<td style='display:none'>" + dr["realPrice"].ToString() + "</td>"); sb.Append("<td style='display:none'>" + dr["bookNum"].ToString() + "</td>"); sb.Append("<td><button class='btn btn-danger btn-sm btn-delete'><i class='fa fa-trash'></i></button></td></tr>"); } if (addType == "other") { Response.Write(addType + "|:" + sb.ToString()); Response.End(); } else { Response.Write(sb.ToString()); Response.End(); } }