protected void Page_Load(object sender, EventArgs e)
{
type = Session["type"].ToString();
string exportOp = Request.QueryString["op"];
if (exportOp == "export")
{
export();
}
SaleTaskBll saletaskBll = new SaleTaskBll();
saletaskId = Session["saleId"].ToString();
DataSet userds = saletaskBll.getcustomerName(saletaskId);
customerName = userds.Tables[0].Rows[0]["customerName"].ToString();
//getData();
saleheadId = Session["saleheadId"].ToString();
saletaskId = Session["saleId"].ToString();
string op = Request["op"];
if (op == "paging")
{
getData();
}
getSaleHeadBasic();
print();
}
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();
}
}
}
}
private void getBook(HttpContext context)
{
string ISBN = context.Request["ISBN"];
string type = context.Request["type"];
DataSet bookds = bookbll.SelectByIsbn(ISBN);
if (bookds != null)
{
string saleId = context.Request["saletaskID"];
string customerId = saletaskbll.getCustomerId(saleId);
LibraryCollectionBll library = new LibraryCollectionBll();
Result libresult = library.Selectbook(customerId, ISBN);
if (libresult == Result.记录不存在 || type == "continue")
{
SaleTaskBll saletaskbll = new SaleTaskBll();
DataSet limtds = saletaskbll.SelectBysaleTaskId(saleId);
string copy = limtds.Tables[0].Rows[0]["defaultCopy"].ToString();
//如果有两条及两条以上
if (bookds.Tables[0].Rows.Count > 1)
{
DataTable dt = new DataTable();
dt.Columns.Add("bookNum", typeof(string));
dt.Columns.Add("rownum", typeof(int));
dt.Columns.Add("bookName", typeof(string));
dt.Columns.Add("unitPrice", typeof(double));
dt.Columns.Add("count", typeof(int));
dt.Columns.Add("color", typeof(string));
for (int i = 0; i < bookds.Tables[0].Rows.Count; i++)
{
int regionid = saletaskbll.GetregionidBysaleid(saleId);
int count = stobll.selectStockNum(bookds.Tables[0].Rows[i]["bookNum"].ToString(), regionid);
if (count == 0)
{
continue;
}
dt.Rows.Add(bookds.Tables[0].Rows[i]["bookNum"].ToString(), Convert.ToInt32((i + 1)), bookds.Tables[0].Rows[i]["bookName"].ToString(), Convert.ToDouble(bookds.Tables[0].Rows[i]["price"].ToString()), count, "");
}
if (dt.Rows.Count == 1)
{
book book = new book();
//bookNum,ISBN,price,author,bookName,supplier
int regionid = saletaskbll.GetregionidBysaleid(saleId);
int count = stobll.selectStockNum(dt.Rows[0]["bookNum"].ToString(), regionid);
if (count != 0)
{
book.BookNum = bookds.Tables[0].Rows[0]["bookNum"].ToString();
book.BookName = bookds.Tables[0].Rows[0]["bookName"].ToString();
book.Price = double.Parse(bookds.Tables[0].Rows[0]["price"].ToString());
book.count = count;
if (copy == "" || copy == null)
{
book.number = "0";
}
else
{
book.number = copy;
}
string json = JsonHelper.JsonSerializerBySingleData(book);
context.Response.Write(json);
context.Response.End();
}
else
{
context.Response.Write("无库存");
context.Response.End();
}
}
else if (dt.Rows.Count != 0)
{
Page page = new Page();
if (copy == "" || copy == null)
{
page.number = "0";
}
else
{
page.number = copy;
}
page.data = JsonHelper.ToJson(dt, "book");
page.type = "books";
string json = JsonHelper.JsonSerializerBySingleData(page);
context.Response.Write(json);
context.Response.End();
}
else
{
context.Response.Write("无库存");
context.Response.End();
}
}
//只有一条数据
else
{
book book = new book();
//bookNum,ISBN,price,author,bookName,supplier
int regionid = saletaskbll.GetregionidBysaleid(saleId);
int count = stobll.selectStockNum(bookds.Tables[0].Rows[0]["bookNum"].ToString(), regionid);
if (count != 0)
{
book.BookNum = bookds.Tables[0].Rows[0]["bookNum"].ToString();
book.BookName = bookds.Tables[0].Rows[0]["bookName"].ToString();
book.Price = double.Parse(bookds.Tables[0].Rows[0]["price"].ToString());
book.count = count;
if (copy == "" || copy == null)
{
book.number = "0";
}
else
{
book.number = copy;
}
string json = JsonHelper.JsonSerializerBySingleData(book);
context.Response.Write(json);
context.Response.End();
}
else
{
context.Response.Write("无库存");
context.Response.End();
}
}
}
else
{
context.Response.Write("馆藏存在");
context.Response.End();
}
}
else
{
context.Response.Write("无数据");
context.Response.End();
}
}
/// <summary>
/// 添加销退单头
/// </summary>
public void Insert()
{
string saleTaskId = Session["saleId"].ToString();
SaleTaskBll saleBll = new SaleTaskBll();
SaleTask sale = saleBll.selectById(saleTaskId);
User user = new User();
user.UserId = sale.UserId; //用户Id
string headId;
string sellId; //单头Id
sellOffHeadBll sellBll = new sellOffHeadBll();
DateTime nowTime = DateTime.Now;
string nowDt = nowTime.ToString("yyyy-MM-dd");
long count = 0;
//判断数据库中是否已经有记录
DataSet backds = soBll.getAllTime();
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]["makingTime"].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]["sellOffHeadID"].ToString();
string st1 = id.Substring(2);
count = long.Parse(st1);
headId = (count + 1).ToString();
//生成流水号
if (count > 0)
{
sellId = "XT" + headId;
}
else
{
count = 1;
sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
SaleTask st = new SaleTask()
{
SaleTaskId = saleTaskId
};
SellOffHead sell = new SellOffHead()
{
SellOffHeadId = sellId,
SaleTaskId = st,
MakingTime = nowTime,
User = user
};
Result row = sellBll.Insert(sell);
if (row == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
break;
}
else
{
count = 1;
sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
SaleTask st = new SaleTask()
{
SaleTaskId = saleTaskId
};
SellOffHead sell = new SellOffHead()
{
SellOffHeadId = sellId,
SaleTaskId = st,
MakingTime = nowTime,
User = user
};
Result row = sellBll.Insert(sell);
if (row == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
}
}
}
else
{
count = 1;
sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
SaleTask st = new SaleTask()
{
SaleTaskId = saleTaskId
};
SellOffHead sell = new SellOffHead()
{
SellOffHeadId = sellId,
SaleTaskId = st,
MakingTime = nowTime,
User = user
};
Result row = sellBll.Insert(sell);
if (row == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
user = (User)Session["user"];
permission();
//获取组织
dsRegion = regionBll.select();
//获取操作员
dsUser = saleheadbll.selectCzy();
string op = Request["op"];
saleTaskid = Session["saleId"].ToString();
SaleTaskBll saleBll = new SaleTaskBll();
finishTime = saleBll.getSaleTaskFinishTime(saleTaskid);
//getData();
if (op == "paging")
{
getData();
}
string saleheadId = Request["ID"];
type = Session["type"].ToString();
//添加销售单体
if (op == "addDetail")
{
if (finishTime != null && finishTime != "")
{
Response.Write("该销售计划已完成");
Response.End();
}
else
{
SaleMonomerBll salemonbll = new SaleMonomerBll();
int state = salemonbll.saleheadstate(saleTaskid, saleheadId);
if (state == 2)
{
Response.Write("失败");
Response.End();
}
else
{
Session["saleheadId"] = saleheadId;
Session["saleType"] = "addsale";
Response.Write("成功");
Response.End();
}
}
}
//if (op == "saleback")
//{
// saleback();
//}
if (op == "Settlement")
{
string salehead = Request["ID"];
string taskId = Request["taskId"];
Settlement(taskId, salehead, 0);
}
if (op == "SettlementAll")
{
SettlementAll();
}
if (op == "logout")
{
//删除身份凭证
FormsAuthentication.SignOut();
//设置Cookie的值为空
Response.Cookies[FormsAuthentication.FormsCookieName].Value = null;
//设置Cookie的过期时间为上个月今天
Response.Cookies[FormsAuthentication.FormsCookieName].Expires = DateTime.Now.AddMonths(-1);
}
//查看
if (op == "look")
{
string type = Request["type"];
Session["type"] = type;
Session["saleheadId"] = saleheadId;
Session["saleType"] = "look";
Response.Write("成功");
Response.End();
}
//完成此销售任务
if (op == "finish")
{
//判断该销售任务下是否还有未完成单据0新建单据 1未完成，2完成，3未结算
SaleTaskBll salebll = new SaleTaskBll();
DataSet saleHeadStateds = salebll.SelectHeadStateBySaleId(saleTaskid);
int count = saleHeadStateds.Tables[0].Rows.Count;
int state = 4;
for (int i = 0; i < count; i++)
{
state = Convert.ToInt32(saleHeadStateds.Tables[0].Rows[i]["state"]);
if (state == 0 || state == 1)
{
break;
}
}
if (state == 0)
{
Response.Write("失败,有新建的单据");
Response.End();
}
if (state == 1)
{
Response.Write("失败,有采集中的单据");
Response.End();
}
else
{
DateTime finishTime = DateTime.Now.ToLocalTime();
int row = salebll.updatefinishTime(finishTime, saleTaskid);
if (row > 0)
{
Response.Write("成功");
Response.End();
}
else
{
Response.Write("失败");
Response.End();
}
}
//if (state < 2)
//{
// Response.Write("未完成失败");
// Response.End();
//}
//else if (state == 2)
//{
// DateTime finishTime = DateTime.Now.ToLocalTime();
// int row = salebll.updatefinishTime(finishTime, saleTaskid);
// if (row > 0)
// {
// Response.Write("成功");
// Response.End();
// }
// else
// {
// Response.Write("失败");
// Response.End();
// }
//}
}
//添加
if (op == "add")
{
//获取销售任务的状态
SaleHeadBll saleheadbll = new SaleHeadBll();
SaleHead salehead = new SaleHead();
string remarks = Request["remarks"];
if (remarks == "" || remarks == null)
{
remarks = "";
}
string saleId = Session["saleId"].ToString();
string SaleHeadId;
int count = saleheadbll.getCount();
if (count > 0)
{
string time = saleheadbll.getSaleHeadTime();
string nowTime = DateTime.Now.ToLocalTime().ToString();
string equalsTime = DateTime.Now.ToLocalTime().ToString("yyyyMMdd");
if (time.Equals(equalsTime))
{
nowTime = DateTime.Now.ToString("yyyy-MM-dd");
string getheadId = saleheadbll.getSaleHeadIdByTime(nowTime);
if (getheadId == "" || getheadId == null)
{
count = 1;
SaleHeadId = "XS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
else
{
string js = getheadId.Remove(0, getheadId.Length - 6);
count = Convert.ToInt32(js) + 1;
SaleHeadId = "XS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
}
else
{
count = 1;
SaleHeadId = "XS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
}
else
{
count = 1;
SaleHeadId = "XS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
salehead.SaleHeadId = SaleHeadId;
salehead.SaleTaskId = saleId;
salehead.KindsNum = 0;
salehead.Number = 0;
salehead.AllTotalPrice = 0;
salehead.AllRealPrice = 0;
User user = (User)Session["user"];
salehead.UserId = user.UserId;
salehead.RegionId = user.ReginId.RegionId;
salehead.DateTime = DateTime.Now.ToLocalTime();
salehead.State = 0;
salehead.Remarks = remarks;
Result result = saleheadbll.Insert(salehead);
if (result == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
}
//删除
if (op == "del")
{
string salehead = Request["ID"];
string headstate = Request["state"];
SaleMonomerBll salemonbll = new SaleMonomerBll();
int state;
if (headstate == "预采")
{
state = salemonbll.perSaleheadstate(saleTaskid, salehead);
}
else
{
state = salemonbll.saleheadstate(saleTaskid, salehead);
}
if (state == 0)
{
Result result = salemonbll.realDelete(saleTaskid, salehead);
if (result == Result.除成功)
{
Response.Write("删除成功");
Response.End();
}
else
{
Response.Write("删除失败");
Response.End();
}
}
else if (state == 1)
{
Response.Write("单据采集中");
Response.End();
}
else if (state == 2)
{
Response.Write("单据完成");
Response.End();
}
else if (state == 3)
{
int count = salemonbll.WeChatSelectcountbyHeadID(salehead, saleTaskid);
if (count > 0)
{
Response.Write("该预采单已有数据,不能删除");
Response.End();
}
else
{
Result result = salemonbll.DeleteHead(saleTaskid, salehead, "copy");
if (result == Result.除成功)
{
Response.Write("删除成功");
Response.End();
}
else
{
Response.Write("删除失败");
Response.End();
}
}
//Result result = salemonbll.realDeleteHeadAndMon(saleTaskid, salehead);
//if (result == Result.删除成功)
//{
// Response.Write("删除成功");
// Response.End();
//}
//else
//{
// Response.Write("删除失败");
// Response.End();
//}
}
else
{
Response.Write("删除失败");
Response.End();
}
}
}
