/// <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();
}
}
