/// <summary>
/// 带输入框的tr列表
/// </summary>
/// <returns></returns>
public String WriteBook()
{
string bookNum = "";
string ISBN = "";
double unitPrice = 0;
string isbn = Request["ISBN"];
bookNum = Request["bookNO"];
string bookName = Request["bookName"];
if (isbn != "" || isbn != null)
{
ISBN = isbn;
}
if (bookNum == "" || bookNum == null)
{
if (bookds != null)
{
bookNum = bookds.Tables[0].Rows[0]["bookNum"].ToString();//书号
BookBasicData book = new BookBasicData();
book = bookBll.SelectById(bookNum);
bookName = book.BookName;
unitPrice = book.Price;//定价
}
}
else
{
unitPrice = double.Parse(Request["price"]);
}
StringBuilder sb = new StringBuilder();
sb.Append("<tr calss='first'>");
sb.Append("<td>" + "</td>");
sb.Append("<td>" + "<input type='text' id='inputISBN' class='textareaISBN' autofocus='autofocus' value='" + ISBN + "' />" + "</td>");
sb.Append("<td>" + bookNum + "</td>");
sb.Append("<td>" + bookName + "</td>");
sb.Append("<td>" + unitPrice + "</td>");
sb.Append("<td>" + "<input type='text' id='inputCount' class='textareaCount' />" + "</td>");
sb.Append("<td>" + "</td>");
sb.Append("<td>" + "</td>");
sb.Append("<td>" + "</td>");
sb.Append("</tr>");
//Response.Write(sb.ToString());
//Response.End();
return(sb.ToString());
}
/// <summary>
/// 一号多书时选择其中一本后触发
/// </summary>
public void showBook()
{
int count = salemonbll.SelectBySaleHeadId(SaleHeadId);
if (count == 0)
{
count = 1;
}
else
{
count += 1;
}
string booknum = Request["bookNum"];
int alreadyBought = salemonbll.getBookNumberSumByBookNum(booknum, saleId);
BookBasicBll bookbll = new BookBasicBll();
BookBasicData book = bookbll.SelectById(booknum);
string remarks = book.Remarks;
if (defaultdiscount == "-1")
{
if (double.Parse(remarks) < 1)
{
remarks = (double.Parse(remarks) * 100).ToString();
}
}
//if (remarks == "" || remarks == null)
//{
// remarks = defaultdiscount;
//}
else
{
remarks = defaultdiscount;
}
string ISBN = Request["isbn"];
string bookname = Request["bookname"];
string price = Request["price"];
StringBuilder sb = new StringBuilder();
sb.Append("<tbody>");
sb.Append("<tr class='first'><td>" + count + "</td>");
sb.Append("<td>" + "<input type='text' class='isbn textareaISBN' value='" + ISBN + "' onkeyup='this.value=this.value.replace(/[^\r\n0-9]/g,'');' /></td>");
sb.Append("<td>" + booknum + "</td>");
sb.Append("<td>" + bookname + "</td>");
sb.Append("<td>" + price + "</td>");
sb.Append("<td><input class='count textareaCount' type='number' value='" + defaultCopy.ToString() + "'/></td>");
sb.Append("<td><input class='discount textareaDiscount' value='" + remarks + "' onkeyup='this.value=this.value.replace(/[^\r\n0-9]/g,'');' /></td>");
sb.Append("<td>" + "" + "</td>");
sb.Append("<td>" + alreadyBought + "</td></tr>");
sb.Append("</tbody>");
Response.Write(sb.ToString());
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>
public void backbook()
{
int count = salemonbll.SelectBySaleHeadId(SaleHeadId);
if (count == 0)
{
count = 1;
}
else
{
count += 1;
}
BookBasicBll bookbll = new BookBasicBll();
string booknum = bookds.Tables[0].Rows[0]["bookNum"].ToString();
//判断库存
DataSet stockbook = stockbll.SelectByBookNum(booknum, user.ReginId.RegionId);
if (stockbook == null)
{
Response.Write("无库存");
Response.End();
}
BookBasicData book = bookbll.SelectById(booknum);
string remarks = book.Remarks;
if (defaultdiscount == "-1")
{
if (double.Parse(remarks) < 1)
{
remarks = (double.Parse(remarks) * 100).ToString();
}
}
else
{
remarks = defaultdiscount;
}
//if (remarks == "" || remarks == null)
//{
// remarks = defaultdiscount;
//}
//else
//{
// if (double.Parse(remarks) < 1)
// {
// remarks = (double.Parse(remarks) * 100).ToString();
// }
//}
StringBuilder sb = new StringBuilder();
sb.Append("<tbody>");
int alreadyBought;
string addbooknum;
for (int i = 0; i < bookds.Tables[0].Rows.Count; i++)
{
addbooknum = bookds.Tables[0].Rows[i]["bookNum"].ToString();
alreadyBought = salemonbll.getBookNumberSumByBookNum(addbooknum, saleId);
sb.Append("<tr class='first'><td>" + count + "</td>");
sb.Append("<td>" + "<input type='text' class='isbn textareaISBN' value='" + bookds.Tables[0].Rows[i]["ISBN"].ToString() + "' onkeyup='this.value=this.value.replace(/[^\r\n0-9]/g,'');' /></td>");
sb.Append("<td>" + bookds.Tables[0].Rows[i]["bookNum"].ToString() + "</td>");
sb.Append("<td>" + bookds.Tables[0].Rows[i]["bookName"].ToString() + "</td>");
sb.Append("<td>" + bookds.Tables[0].Rows[i]["price"].ToString() + "</td>");
sb.Append("<td><input class='count textareaCount' type='number' value='" + defaultCopy.ToString() + "'/></td>");
sb.Append("<td><input class='discount textareaDiscount' value='" + remarks + "' onkeyup='this.value=this.value.replace(/[^\r\n0-9]/g,'');' /></td>");
sb.Append("<td>" + "" + "</td>");
sb.Append("<td>" + alreadyBought + "</td></tr>");
}
sb.Append("</tbody>");
Response.Write(sb.ToString());
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>
/// <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 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();
}
}
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();
}
}
}
/// <summary>
/// 单个销售单结算
/// </summary>
public void Settlement(string saleTaskid, string saleHead, int scaler)
{
int RegionId = user.ReginId.RegionId;
DataTable dt = saleheadbll.getSaleAllbyHeadIdAndStaskId(saleTaskid, saleHead);
int number = 0;
string bookNum, bookName, saleHeadId, saleTaskId, Isbn, Author, Supplier;
int saleIdMonomerId, rsMonomerId;
int allstockNum = 0;//总库存
int bhnum = 0;
BookBasicData book = new BookBasicData();
saleHeadId = dt.Rows[0]["saleHeadId"].ToString();
saleTaskId = dt.Rows[0]["saleTaskId"].ToString();
for (int i = 0; i < dt.Rows.Count; i++)
{
bookNum = dt.Rows[i]["bookNum"].ToString();
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"]);
}
number = int.Parse(dt.Rows[i]["number"].ToString());
//库存小于数量时生成补货单
if (allstockNum < number)
{
book = bookbll.SelectById(bookNum);
Isbn = book.Isbn;
Supplier = book.Publisher;
Author = book.Author;
bookName = dt.Rows[i]["bookName"].ToString();
saleIdMonomerId = int.Parse(dt.Rows[i]["saleIdMonomerId"].ToString());
bhnum = number - allstockNum;
string rsHead = replenBll.getRsHeadID(saleTaskId);
//判断该销售任务是否已有补货记录，如果没有则新增
if (rsHead == "none")
{
Result res = addrsHead(saleTaskId);
if (res == Result.添加成功)
{
int count = replenBll.countMon(saleTaskId);
if (count > 0)
{
rsMonomerId = count + 1;
}
else
{
rsMonomerId = 1;
}
respMon.BookNum = bookNum;
respMon.Count = bhnum;
respMon.Supplier = Supplier;
respMon.DateTime = DateTime.Now.ToLocalTime();
respMon.Isbn = Isbn;
respMon.SaleIdMonomerId = saleIdMonomerId;
respMon.SaleTaskId = saleTaskId;
respMon.Author = Author;
respMon.SaleHeadId = saleHeadId;
respMon.RsMonomerID = rsMonomerId;
Result addmonRes = replenBll.Insert(respMon);
if (addmonRes == Result.添加成功)
{
//更新补货单头
int rskinds = replenBll.getkinds(saleTaskId);
int rsnumber = replenBll.getsBookNumberSum(saleTaskId);
replenishMentHead upRsHead = new replenishMentHead()
{
SaleTaskId = saleTaskId,
KindsNum = rskinds,
Number = rsnumber,
};
replenBll.updateRsHead(upRsHead);
for (int t = 0; t < stockbook.Tables[0].Rows.Count; t++)
{
string goodsID = stockbook.Tables[0].Rows[t]["goodsShelvesId"].ToString();
stockbll.update(0, goodsID, bookNum);
}
}
else
{
Response.Write("添加失败");
Response.End();
}
}
else
{
Response.Write("添加单头失败");
Response.End();
}
}
else
{
int count = replenBll.countMon(saleTaskId);
if (count > 0)
{
rsMonomerId = count + 1;
}
else
{
rsMonomerId = 1;
}
respMon.BookNum = bookNum;
respMon.Count = bhnum;
respMon.Supplier = Supplier;
respMon.DateTime = DateTime.Now.ToLocalTime();
respMon.Isbn = Isbn;
respMon.SaleIdMonomerId = saleIdMonomerId;
respMon.SaleTaskId = saleTaskId;
respMon.Author = Author;
respMon.SaleHeadId = saleHeadId;
respMon.RsMonomerID = rsMonomerId;
Result addmonRes = replenBll.Insert(respMon);
if (addmonRes == Result.添加成功)
{
//更新补货单头
int rskinds = replenBll.getkinds(saleTaskId);
int rsnumber = replenBll.getsBookNumberSum(saleTaskId);
replenishMentHead upRsHead = new replenishMentHead()
{
SaleTaskId = saleTaskId,
KindsNum = rskinds,
Number = rsnumber,
};
replenBll.updateRsHead(upRsHead);
for (int t = 0; t < stockbook.Tables[0].Rows.Count; t++)
{
string goodsID = stockbook.Tables[0].Rows[t]["goodsShelvesId"].ToString();
stockbll.update(0, goodsID, bookNum);
}
}
else
{
Response.Write("添加补货单失败");
Response.End();
}
}
}
//库存足则直接减库存
else
{
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);
number = 0;
}
else
{
number = number - stockNum;
stockbll.update(0, goodsId, bookNum);
}
}
}
}
if (scaler == 0)
{
//循环完后更新销售单的状态
Result upHeadstate = salemonbll.updateHeadstate(saleTaskId, saleHeadId, 2);
if (upHeadstate == Result.更新成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("更新销售单头失败");
Response.End();
}
}
}
