/// <summary>
/// 添加单头信息
/// </summary>
/// <param name="single">单头实体对象</param>
/// <returns></returns>
public int insertHead(SingleHead single)
{
string cmdText = "insert into T_SingleHead(singleHeadId,time,regionId,userId,type,remarks) values(@singleHeadId,@time,@regionId,@userId,@type,@remarks)";
string[] param = { "@singleHeadId", "@time", "@regionId", "@userId", "@type", "@remarks" };
object[] values = { single.SingleHeadId, single.Time, single.Region.RegionId, single.User.UserId, single.Type, single.Remarks };
int row = db.ExecuteNoneQuery(cmdText, param, values);
return(row);
}
/// <summary>
/// 更新单头数量，码洋，实洋
/// </summary>
/// <param name="single"></param>
/// <returns></returns>
public int updateHead(SingleHead single)
{
string cmdTexts = "update T_SingleHead set allBillCount=@allBillCount,allTotalPrice=@allTotalPrice,allRealPrice=@allRealPrice where singleHeadId=@singleHeadId";
string[] parames = { "@singleHeadId", "@allBillCount", "@allTotalPrice", "@allRealPrice" };
object[] value = { single.SingleHeadId, single.AllBillCount, single.AllTotalPrice, single.AllRealPrice };
int row = db.ExecuteNoneQuery(cmdTexts, parames, value);
return(row);
}
/// <summary>
/// 更新单头数量，码洋，实洋
/// </summary>
/// <param name="single"></param>
/// <returns></returns>
public Result updateHead(SingleHead single)
{
int row = monoDao.updateHead(single);
if (row > 0)
{
return(Result.更新成功);
}
else
{
return(Result.更新失败);
}
}
/// <summary>
/// 添加单头信息
/// </summary>
/// <param name="single">单头实体对象</param>
/// <returns></returns>
public Result insertHead(SingleHead single)
{
int row = monoDao.insertHead(single);
if (row > 0)
{
return(Result.添加成功);
}
else
{
return(Result.添加失败);
}
}
protected void Page_Load(object sender, EventArgs e)
{
permission();
//getData();
User user = (User)Session["user"];
regionId = user.ReginId.RegionId;
roleName = user.RoleId.RoleName;
//获取组织
dsRegion = regionBll.select();
//获取操作员
dsUser = regionBll.selectUser();
string op = Request["op"];
if (op == "paging")
{
getData();
}
if (op == "logout")
{
//删除身份凭证
FormsAuthentication.SignOut();
//设置Cookie的值为空
Response.Cookies[FormsAuthentication.FormsCookieName].Value = null;
//设置Cookie的过期时间为上个月今天
Response.Cookies[FormsAuthentication.FormsCookieName].Expires = DateTime.Now.AddMonths(-1);
}
else if (op == "add")
{
DateTime nowTime = DateTime.Now;
string nowDt = nowTime.ToString("yyyy-MM-dd");
long count = 0;
//判断数据库中是否已经有记录
DataSet backds = wareBll.getAllTime(1);
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]["time"].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]["singleHeadId"].ToString();
string st1 = id.Substring(10);
long rowes = long.Parse(st1) + 1;
count = rowes;
break;
}
else
{
count = 1;
break;
}
}
if (count == 0)
{
count = 1;
}
}
else
{
count = 1;
}
string source = Request["source"];
string remarks = Request["remarks"];
if (remarks == "" || remarks == null)
{
remarks = "";
}
SingleHead single = new SingleHead();
Region region = new Region();
region.RegionId = Convert.ToInt32(source);
single.Region = region;
single.SingleHeadId = "RK" + DateTime.Now.Date.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
single.Time = DateTime.Now;
single.Type = 1;
single.User = user;
single.Remarks = remarks;
Result row = wareBll.insertHead(single);
if (row == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
}
else if (op == "del")
{
string Id = Request["account"];
Result row = wareBll.deleteHead(Id, 1);
if (row == Result.除成功)
{
Response.Write("删除成功");
Response.End();
}
else
{
Response.Write("删除失败");
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();
}
}
}
