/// <summary>
/// 根据书号查找isbn，单价，折扣
/// </summary>
/// <param name="bookNum">书号</param>
/// <returns></returns>
public BookBasicData SelectById(string bookNum)
{
MySqlHelp db = new MySqlHelp();
string comText = "select ISBN,price,bookName,supplier,remarks,author from T_BookBasicData 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)
{
string isbn = ds.Tables[0].Rows[0]["isbn"].ToString();
string price = ds.Tables[0].Rows[0]["price"].ToString();
string remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
string bookName = ds.Tables[0].Rows[0]["bookName"].ToString();
string supplier = ds.Tables[0].Rows[0]["supplier"].ToString();
string author = ds.Tables[0].Rows[0]["author"].ToString();
BookBasicData bookBasic = new BookBasicData();
bookBasic.Isbn = isbn;
bookBasic.Price = Convert.ToDouble(price);
bookBasic.Remarks = remarks;
bookBasic.BookName = bookName;
bookBasic.Publisher = supplier;
bookBasic.Author = author;
return(bookBasic);
}
else
{
return(null);
}
}
private void excelNo()
{
DataTable dataTable = addBookId();
int counts = 0;
DataRowCollection count = dataTable.Rows;
foreach (DataRow row in count)//遍历excel数据集
{
try
{
string isbn = row[2].ToString().Trim();
string bookName = ToSBC(row[3].ToString().Trim());
double price = Convert.ToDouble(row[6]);
BookBasicData basicData = new BookBasicData();
basicData.BookNum = row[0].ToString();
basicData.Isbn = isbn;
basicData.BookName = bookName;
basicData.Publisher = row[4].ToString();
basicData.Time = row[5].ToString();
//basicData.PublishTime = Convert.ToDateTime(row[5]);
basicData.Price = Convert.ToDouble(row[6]);
basicData.Catalog = row[7].ToString();
basicData.Author = row[8].ToString();
basicData.Remarks = row[9].ToString();
basicData.Dentification = row[10].ToString();
basicData.Remarks1 = row[11].ToString();
basicData.Remarks2 = row[12].ToString();
basicData.Remarks3 = row[13].ToString();
Result result = bookbll.Insert(basicData);
if (result == Result.添加失败)
{
Response.Write("导入失败，可能重复导入");
Response.End();
}
else
{
Result reg = bookbll.updateBookNum(row[0].ToString()); //更新书号
counts++;
}
}
catch (Exception ex)
{
Response.Write(ex);
Response.End();
}
}
int cf = row - counts;
if (counts == 0)
{
Response.Write("导入失败，共导入数据" + counts + "条数据，共有重复数据" + cf + "条");
Response.End();
}
else
{
Response.Write("导入成功，共导入数据" + counts + "条数据，共有重复数据" + cf + "条");
Response.End();
}
}
/// <summary>
/// 添加基础数据
/// </summary>
/// <param name="basic">基础数据实体对象</param>
/// <returns></returns>
public int Insert(BookBasicData basic)
{
string cmdText = "insert into T_BookBasicData(bookNum,ISBN,bookName,supplier,publishTime,price,catalog,author,remarks,dentification,remarksOne,remarksTwo,remarksThree) values(@bookNum,@ISBN,@bookName,@supplier,@publishTime,@price,@catalog,@author,@remarks,@dentification,@remarksOne,@remarksTwo,@remarksThree)";
String[] param = { "@bookNum", "@ISBN", "@bookName", "@supplier", "@publishTime", "@price", "@catalog", "@author", "@remarks", "@dentification", "@remarksOne", "@remarksTwo", "@remarksThree" };
object[] values = { basic.BookNum, basic.Isbn, basic.BookName, basic.Publisher, basic.PublishTime, basic.Price, basic.Catalog, basic.Author, basic.Remarks, basic.Dentification, basic.Remarks1, basic.Remarks2, basic.Remarks3 };
return(db.ExecuteNoneQuery(cmdText, param, values));
}
/// <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>
/// <returns></returns>
public BookBasicData getBookNum()
{
string sql = "select bookNum from T_NewBook";
BookBasicData bookBasic = new BookBasicData();
MySqlDataReader reader = db.ExecuteReader(sql, null, null);
while (reader.Read())
{
bookBasic.NewBookNum = reader.GetString(0);
}
reader.Close();
return(bookBasic);;
}
/// <summary>
/// 添加基础数据
/// </summary>
/// <param name="basic">基础数据实体对象</param>
/// <returns></returns>
public Result Insert(BookBasicData basic)
{
int row = basicDao.Insert(basic);
if (row > 0)
{
return(Result.添加成功);
}
else
{
return(Result.添加失败);
}
}
/// <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>
/// 根据书号查找isbn，单价，折扣
/// </summary>
/// <param name="bookNum">书号</param>
/// <returns></returns>
public BookBasicData SelectByBookNum(long bookNum, string retailHeadId)
{
MySqlHelp db = new MySqlHelp();
string comTexts = "select count(id) 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 ISBN,price,bookName,supplier,remarks from T_BookBasicData 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)
{
string isbn = ds.Tables[0].Rows[0]["isbn"].ToString();
string price = ds.Tables[0].Rows[0]["price"].ToString();
string remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
string bookName = ds.Tables[0].Rows[0]["bookName"].ToString();
string supplier = ds.Tables[0].Rows[0]["supplier"].ToString();
BookBasicData bookBasic = new BookBasicData();
bookBasic.Isbn = isbn;
bookBasic.Price = Convert.ToDouble(price);
bookBasic.Remarks = remarks;
bookBasic.BookName = bookName;
bookBasic.Publisher = supplier;
return(bookBasic);
}
else
{
return(null);
}
}
}
/// <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();
}
}
}
/// <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();
}
protected void Page_Load(object sender, EventArgs e)
{
permission();
dsSupplier = bookbll.selectSupplier();
//获取书号
BookBasicData bookId = bookbll.getBookNum();
if (!IsPostBack)
{
if (bookId.NewBookNum == "0" || bookId.NewBookNum == null || bookId.NewBookNum.Length < 8)
{
num = "0";
}
else
{
num = bookId.NewBookNum;
}
ViewState["i"] = num;
}
//getData();
string op = Request["op"];
if (op == "paging")
{
getData();
}
if (op == "del")
{
string bookNum = Request["bookNum"].ToString();
Result row = isDelete();
if (row == Result.记录不存在)
{
Result result = bookbll.Delete(bookNum);
if (result == Result.除成功)
{
Response.Write("删除成功");
Response.End();
}
else
{
Response.Write("删除失败");
Response.End();
}
}
else
{
Response.Write("此资料已有关联订单，无法删除！");
Response.End();
}
}
if (op == "check")
{
test();
}
if (op == "export")
{
excelBook();
}
string action = Request["action"];
if (action == "import")
{
differentDt();
//DataTable dtInsert = new DataTable();
//System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
//watch.Start();
//differentDt();
//except.Columns.Remove("id"); //移除匹配列
//dtInsert = except; //赋给新table
//TimeSpan ts = watch.Elapsed;
//dtInsert.TableName = "T_BookBasicData"; //导入的表名
//int a = userBll.BulkInsert(dtInsert);
//watch.Stop();
//double minute = ts.TotalMinutes; //计时
//string m = minute.ToString("0.00");
//if (a > 0)
//{
// int cf = row - a;
// BookBasicData bookNum = bookbll.getBookNum();
// Result result = bookbll.updateBookNum(last); //更新书号
// //Response.Write("导入成功，总数据有" + row + "条，共导入" + a + "条数据" + "，共用时：" + m + "分钟");
// Response.Write("导入成功，共导入数据"+a+"条数据，共有重复数据"+cf+"条");
// Response.End();
//}
//else
//{
// Response.Write("导入失败，可能重复导入");
// Response.End();
//}
}
if (op == "logout")
{
//删除身份凭证
FormsAuthentication.SignOut();
//设置Cookie的值为空
Response.Cookies[FormsAuthentication.FormsCookieName].Value = null;
//设置Cookie的过期时间为上个月今天
Response.Cookies[FormsAuthentication.FormsCookieName].Expires = DateTime.Now.AddMonths(-1);
}
}
//private void excelNo()
//{
// BookBasicBll bookBasicBll = new BookBasicBll();
// except.Columns.Add("书号", typeof(string));
// except.Columns.Add("id", typeof(string));
// except.Columns.Add("ISBN", typeof(string));
// except.Columns.Add("书名", typeof(string));
// except.Columns.Add("供应商", typeof(string));
// except.Columns.Add("出版日期", typeof(string));
// except.Columns.Add("单价", typeof(double));
// except.Columns.Add("预收数量", typeof(string));
// except.Columns.Add("进货折扣", typeof(string));
// except.Columns.Add("销售折扣", typeof(string));
// except.Columns.Add("备注", typeof(string));
// DataRowCollection count = addBookId().Rows;
// int counts = 0;
// foreach (DataRow row in count)//遍历excel数据集
// {
// try
// {
// string isbn = row[2].ToString().Trim();
// string bookName = ToSBC(row[3].ToString().Trim());
// double price = Convert.ToDouble(row[6]);
// DataRow[] rows = excelToDt().Select(string.Format("ISBN='{0}' and 书名='{1}' and 单价={2}", isbn, bookName, price));
// if (rows.Length == 1)//判断如果DataRow.Length为0，即该行excel数据不存在于表A中，就插入到dt3
// {
// //except.Rows.Add(row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10]);
// BookBasicData basicData = new BookBasicData();
// basicData.BookNum = row[0].ToString();
// basicData.Isbn = isbn;
// basicData.BookName = bookName;
// basicData.Publisher = row[4].ToString();
// basicData.Time = row[5].ToString();
// //basicData.PublishTime = Convert.ToDateTime(row[5]);
// basicData.Price = Convert.ToDouble(row[6]);
// basicData.Catalog = row[7].ToString();
// basicData.Author = row[8].ToString();
// basicData.Remarks = row[9].ToString();
// basicData.Dentification = row[10].ToString();
// Result result = bookBasicBll.Insert(basicData);
// if (result == Result.添加失败)
// {
// Response.Write("导入失败，可能重复导入");
// Response.End();
// }
// else
// {
// counts++;
// }
// }
// else
// {
// excelToDt().Rows.RemoveAt();
// }
// }
// catch (Exception ex)
// {
// Response.Write(ex);
// Response.End();
// }
// }
// int cf = row - counts;
// Response.Write("导入成功，共导入数据" + counts + "条数据，共有重复数据" + cf + "条");
// Response.End();
//}
private void differentDt()
{
BookBasicBll bookBasicBll = new BookBasicBll();
int j = bookBasicBll.SelectCount();
//数据库无数据时直接导入excel
if (j <= 0)
{
//except = addBookId();
//except= GetDistinctSelf(addBookId(), "ISBN", "书名", "单价");
excelNo();
}
else
{
//except.Columns.Add("书号", typeof(string));
//except.Columns.Add("id", typeof(string));
//except.Columns.Add("ISBN", typeof(string));
//except.Columns.Add("书名", typeof(string));
//except.Columns.Add("供应商", typeof(string));
//except.Columns.Add("出版日期", typeof(string));
//except.Columns.Add("单价", typeof(double));
//except.Columns.Add("预收数量", typeof(string));
//except.Columns.Add("进货折扣", typeof(string));
//except.Columns.Add("销售折扣", typeof(string));
//except.Columns.Add("备注", typeof(string));
BookBasicData bookId = bookbll.getBookNum();
DataRowCollection count = addBookId().Rows;
int counts = 0;
DataTable dataTable = bookBasicBll.Select();
bool isNull = false;
int rowls = 0;
int kz = 0;
foreach (DataRow row in count)//遍历excel数据集
{
try
{
string isbn = row[2].ToString().Trim();
string bookName = ToSBC(row[3].ToString().Trim());
string supplier = row[4].ToString().Trim();
string accept = row[8].ToString().Trim();
string sale = row[9].ToString().Trim();
string price = row[6].ToString().Trim();
if (price == "" || isbn == "" || bookName == "")
{
price = "0";
isNull = true;
kz++;
continue;
}
DataRow[] rows = dataTable.Select(string.Format("ISBN='{0}' and bookName='{1}' and supplier='{2}' and price='{3}' and author='{4}' and remarks='{5}'", isbn, bookName, supplier, price, accept, sale));
//DataRow[] rows = dataTable.Select(string.Format("ISBN='{0}' and bookName='{1}' and price={2}", isbn, bookName, Convert.ToDouble(price)));
if (rows.Length == 0)//判断如果DataRow.Length为0，即该行excel数据不存在于表A中，就插入到dt3
{
//except.Rows.Add(row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10]);
BookBasicData basicData = new BookBasicData();
basicData.BookNum = row[0].ToString();
basicData.Isbn = isbn;
basicData.BookName = bookName;
basicData.Publisher = row[4].ToString();
basicData.Time = row[5].ToString();
//basicData.PublishTime = Convert.ToDateTime(row[5]);
basicData.Price = Convert.ToDouble(price);
basicData.Catalog = row[7].ToString();
basicData.Author = row[8].ToString();
basicData.Remarks = row[9].ToString();
basicData.Dentification = row[10].ToString();
basicData.Remarks1 = row[11].ToString();
basicData.Remarks2 = row[12].ToString();
basicData.Remarks3 = row[13].ToString();
Result result = bookBasicBll.Insert(basicData);
if (result == Result.添加失败)
{
Response.Write("远程服务器未响应");
Response.End();
}
else
{
counts++;
}
}
rowls++;
}
catch (Exception ex)
{
Response.Write(ex);
Response.End();
}
}
string s = last;
Result reg = bookbll.updateBookNum(s); //更新书号
//bookId.NewBookNum = bookId.NewBookNum.Substring(bookId.NewBookNum.Length - 8);
//last = last.ToString().Substring(last.ToString().Length - 8);
//if (Convert.ToInt64(bookId.NewBookNum) < Convert.ToInt64(last))
//{
// Result reg = bookbll.updateBookNum(s); //更新书号
//}
Session["path"] = null; //清除路径session
int cf = row - counts;
if (counts == 0)
{
if (isNull)
{
Response.Write("导入成功，共导入数据" + counts + "条数据，共有重复数据" + cf + "条，共有错误数据" + kz.ToString());
Response.End();
}
else
{
Response.Write("导入失败，共导入数据" + counts + "条数据，共有重复数据" + cf + "条");
Response.End();
}
}
else
{
Response.Write("导入成功，共导入数据" + counts + "条数据，共有重复数据" + cf + "条");
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();
}
}
}
//某字段table去重方法
private DataTable GetDistinctSelf(DataTable SourceDt, string field1, string field2, string field3)
{
int j = SourceDt.Rows.Count;
int counts = 0;
if (j > 1)
{
int k = j - 1;
int i = 0;
while (i <= k)
{
DataRow dr = SourceDt.Rows[i];
string isbn = dr[field1].ToString();
string bookName = dr[field2].ToString();
double price = Convert.ToDouble(dr[field3]);
DataRow[] rows = SourceDt.Select(string.Format("{0}='{3}' and {1}='{4}' and {2}={5}", field1, field2, field3, isbn, ToSBC(bookName), price));
//if (rows.Length > 1)
//{
// SourceDt.Rows.RemoveAt(i);
// k = k - 1;
//}
//else
//{
// i++;
//}
if (rows.Length == 1)
{
BookBasicData basicData = new BookBasicData();
basicData.BookNum = dr[0].ToString();
basicData.Isbn = isbn;
basicData.BookName = bookName;
basicData.Publisher = dr[4].ToString();
basicData.Time = dr[5].ToString();
//basicData.PublishTime = Convert.ToDateTime(rows[5]);
basicData.Price = Convert.ToDouble(dr[6]);
basicData.Catalog = dr[7].ToString();
basicData.Author = dr[8].ToString();
basicData.Remarks = dr[9].ToString();
basicData.Dentification = dr[10].ToString();
Result result = bookbll.Insert(basicData);
if (result == Result.添加失败)
{
Response.Write("导入失败，可能重复导入");
Response.End();
}
else
{
counts++;
}
i++;
}
else
{
SourceDt.Rows.RemoveAt(i);
k = k - 1;
}
}
int cf = row - counts;
Response.Write("导入成功，共导入数据" + counts + "条数据，共有重复数据" + cf + "条");
Response.End();
}
return(SourceDt);
}
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();
}
}
/// <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();
}
}
/// <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 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();
}
}
}
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();
}
}
}
}
