/// <summary> /// 添加销退单头 /// </summary> /// <param name="sm"></param> /// <returns></returns> public int Insert(SellOffMonomer sm) { string cmdText = "insert into T_SellOffMonomer(sellOffMonomerId,sellOffHead,bookNum,isbn,price,count,totalPrice,realPrice,dateTime,realDiscount) values(@sellOffMonomerId,@sellOffHeadID,@bookNum,@isbn,@price,@count,@totalPrice,@realPrice,@dateTime,@realDiscount)"; string[] param = { "@sellOffMonomerId", "@sellOffHeadID", "@bookNum", "@isbn", "@price", "@count", "@totalPrice", "@realPrice", "@dateTime", "@realDiscount" }; object[] values = { sm.SellOffMonomerId, sm.SellOffHeadId, sm.BookNum, sm.ISBN1, sm.Price, sm.Count, sm.TotalPrice, sm.RealPrice, sm.Time, sm.Discount }; int row = db.ExecuteNoneQuery(cmdText, param, values); return(row); }
/// <summary> /// 添加 /// </summary> /// <param name="sm"></param> /// <returns></returns> public Result Insert(SellOffMonomer sm) { int row = dao.Insert(sm); if (row > 0) { return(Result.添加成功); } else { return(Result.添加失败); } }
/// <summary> /// 添加销退单体 /// </summary> public void addSalemon() { string sellId = Session["sellId"].ToString(); string isbn = Request["ISBN"];//ISBN if (isbn == "" || isbn == null) { Response.Write("请先输入ISBN号"); Response.End(); } else { string bookNo = Request["bookNum"]; if (bookNo == null || bookNo == "") { bookNo = bookds.Tables[0].Rows[0]["bookNum"].ToString();//书号 } int bookCount = smBll.getBookCount(bookNo); if (bookCount > 0) { BookBasicData book = new BookBasicData(); book = bookBll.SelectById(bookNo); double unitPrice = book.Price; //定价 //double discount = double.Parse(Request["discount"]);//实际折扣 //获取默认折扣 DataSet stds = smBll.getSaleTask(sellId); string stId = Session["saleId"].ToString(); DataSet seds = smBll.getDisCount(stId, bookNo); string dc = null; if (seds.Tables[0].Rows.Count > 0) { dc = seds.Tables[0].Rows[0]["realDiscount"].ToString(); } double discount = 0;//默认折扣 if (dc != null) { discount = double.Parse(dc); } int count = int.Parse(Request["count"]); //数量 double totalPrice = unitPrice * count; //码洋 double d = totalPrice * (discount / 100); double realPrice = Math.Round(d, 2); //实洋 string headId = Session["sellId"].ToString(); //单头Id int moNum = smBll.GetCount(headId); int smId; smId = moNum + 1;//单体Id DateTime time = DateTime.Now; //获取默认折扣 //DataSet stds = smBll.getSaleTask(sellId); //string stId = stds.Tables[0].Rows[0]["saleTaskId"].ToString();//销售任务Id DataSet countds = smBll.selctByBookNum(bookNo, stId); int num = 0; SellOffMonomer sm = new SellOffMonomer(); sm.SellOffMonomerId = smId.ToString(); sm.SellOffHeadId = headId; sm.BookNum = long.Parse(bookNo); sm.ISBN1 = isbn; sm.Count = count; sm.TotalPrice = totalPrice; sm.RealPrice = realPrice; sm.Price = unitPrice; sm.Time = time; sm.Discount = discount; //DataSet smcountds = smBll.selecctSm(bookNo, sellId); int allcount = smBll.selecctSm(bookNo, sellId); //string state = null; if (countds != null)//获取销售中的相应的数量 { for (int i = 0; i < countds.Tables[0].Rows.Count; i++) { num = num + int.Parse(countds.Tables[0].Rows[i]["number"].ToString()); } } //if (smcountds != null)//获取销退单体中已有的数量 //{ // for (int i = 0; i < smcountds.Tables[0].Rows.Count; i++) // { // allcount = allcount + int.Parse(smcountds.Tables[0].Rows[i]["count"].ToString()); // } //} if ((count + allcount) > num)//判断销退数量是否大于销售数量 { Response.Write("销退数量大于销售数量"); Response.End(); } else { Result row = smBll.Insert(sm); if (row == Result.添加成功)//先添加销退体 { string update = updateSellHead(); if (update == "更新成功")//后更新销退单头信息 { string stock = insertStock(); if (stock == "更新成功")//最后写入库存 { Response.Write("添加成功"); Response.End(); } else { Response.Write(stock); Response.End(); } } else { Response.Write("更新单头信息失败"); Response.End(); } } else { Response.Write("添加失败"); Response.End(); } } } else { Response.Write("销售单中暂无此数据"); Response.End(); } } }