/// <summary>
/// 通过销售任务Id获取默认折扣
/// </summary>
/// <param name="saleTaskId"></param>
/// <returns></returns>
public DataSet getDisCount(string saleTaskId, string bookNum)
{
SaleTask st = new SaleTask();
DataSet ds = dao.getDisCount(saleTaskId, bookNum);
return(ds);
}
/// <summary>
/// 添加销售任务方法
/// </summary>
/// <param name="task">实体销售任务</param>
/// <returns>返回结果</returns>
public Result insert(SaleTask sale)
{
int row = saleDao.Insert(sale);
if (row > 0)
{
return(Result.添加成功);
}
else
{
return(Result.添加失败);
}
}
/// <summary>
/// 添加销售任务
/// </summary>
/// <param name="task">销售任务实体</param>
/// <returns>受影响行数</returns>
public int Insert(SaleTask sale)
{
string cmdText = "insert into T_SaleTask(saleTaskId,userId,customerId,defaultDiscount,defaultCopy,numberLimit,priceLimit,totalPriceLimit,startTime) values(@saleTaskId,@userId,@customreId,@defaultDiscount,@defaultCopy,@numberLimit,@priceLimit,@totalPriceLimit,@startTime)";
string[] param = { "@saleTaskId", "@userId", "@customreId", "@defaultDiscount", "@defaultCopy", "@numberLimit", "@priceLimit", "@totalPriceLimit", "@startTime" };
object[] values = { sale.SaleTaskId, sale.UserId, sale.Customer.CustomerId, sale.DefaultDiscount, sale.DefaultCopy, sale.NumberLimit, sale.PriceLimit, sale.TotalPiceLimit, sale.StartTime };
int row = db.ExecuteNoneQuery(cmdText, param, values);
if (row > 0)
{
return(row);
}
else
{
return(0);
}
}
public HttpResponseMessage MakeNewSale([FromBody] RequestMakeSale request)
{
var response = new APIResponse <Sale>();
try
{
var saleLogic = new SaleTask();
var newSale = saleLogic.MakeNewSale(request.SaleData, request.SaleDetailData);
response.Data = newSale;
response.Message = "Sale made correctly";
response.HttpStatusCode = HttpStatusCode.OK;
}
catch (Exception e)
{
response.HttpStatusCode = HttpStatusCode.InternalServerError;
response.Message = "Error making sale";
response.HasError = true;
}
return(Request.CreateResponse(response.HttpStatusCode, response));
}
/// <summary>
/// 根据销售任务ID获取销售任务信息
/// </summary>
/// <param name="saleTaskId">销售任务ID</param>
/// <returns></returns>
public SaleTask selectById(string saleTaskId)
{
DataSet ds = saleDao.SelectById(saleTaskId);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
double discount = double.Parse(ds.Tables[0].Rows[0]["defaultDiscount"].ToString());
int numberlimit = Convert.ToInt32(ds.Tables[0].Rows[0]["numberLimit"].ToString());
string userId = ds.Tables[0].Rows[0]["userId"].ToString();
SaleTask st = new SaleTask()
{
DefaultDiscount = discount,
NumberLimit = numberlimit,
UserId = userId
};
return(st);
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
user = (User)Session["user"];
type = Session["saleType"].ToString();
saleId = Session["saleId"].ToString();
//getData();
getlimt();
SaleTask task = saletaskbll.selectById(saleId);
defaultdiscount = task.DefaultDiscount.ToString();
SaleHeadId = Session["saleheadId"].ToString();
//更新单头
updateSalehead();
string op = Request["op"];
//isbn回车
if (op == "search")
{
string ISBN = Request["ISBN"];
bookds = bookbll.SelectByIsbn(ISBN);
if (bookds != null)
{
//如果有两条及两条以上显示表格
if (bookds.Tables[0].Rows.Count > 1)
{
getbook();
}
//只有一条数据
else
{
backbook();
}
}
else
{
Response.Write("无数据");
Response.End();
}
}
//一书多号选择后执行
if (op == "add")
{
showBook();
}
//添加销售
if (op == "addsale")
{
SaleHeadBll saleheadbll = new SaleHeadBll();
string saletaskId = saleheadbll.SelectTaskByheadId(SaleHeadId);
string customerId = saletaskbll.getCustomerId(saletaskId);
int AlreadyBought = user.ReginId.RegionId;
//判断馆藏
LibraryCollectionBll library = new LibraryCollectionBll();
bookISBN = Request["bookISBN"];
Result libresult = library.Selectbook(customerId, bookISBN);
if (libresult == Result.记录不存在)
{
bookISBN = Request["bookISBN"];
disCount = double.Parse(Request["discount"]);
number = Convert.ToInt32(Request["number"]);
bookNum = Request["bookNum"].ToString();
if (number < 0)
{
number = Math.Abs(number);
DataSet bookNumds = salemonbll.getsalemonDetail(SaleHeadId, saleId, bookNum);
if (bookNumds != null)
{
int booknumber = int.Parse(bookNumds.Tables[0].Rows[0]["number"].ToString());
if (number > booknumber)
{
msg.Messege = "输入的负数不能大于已购数量，已购数为:" + booknumber;
Response.Write(ObjectToJson(msg));
Response.End();
}
else
{
number = number * -1;
addsalemon();
}
}
else
{
msg.Messege = "该书籍没有购买过，数量不能为负数";
Response.Write(ObjectToJson(msg));
Response.End();
}
}
else
{
addsalemon();
}
}
else
{
msg.Messege = "客户馆藏已存在";
Response.Write(ObjectToJson(msg));
Response.End();
}
}
//客户馆藏已存在，继续录入
if (op == "addRsMon")
{
bookISBN = Request["bookISBN"];
disCount = double.Parse(Request["discount"]);
number = Convert.ToInt32(Request["number"]);
bookNum = Request["bookNum"].ToString();
if (number < 0)
{
number = Math.Abs(number);
DataSet bookNumds = salemonbll.getsalemonDetail(SaleHeadId, saleId, bookNum);
if (bookNumds != null)
{
int booknumber = int.Parse(bookNumds.Tables[0].Rows[0]["number"].ToString());
if (number > booknumber)
{
msg.Messege = "输入的负数不能大于已购数量，已购数为:" + booknumber;
Response.Write(ObjectToJson(msg));
Response.End();
}
else
{
number = number * -1;
addsalemon();
}
}
else
{
msg.Messege = "该书籍没有购买过，数量不能为负数";
Response.Write(ObjectToJson(msg));
Response.End();
}
}
else
{
addsalemon();
}
}
//完成单据
if (op == "success")
{
//判断是否有单体
int row = salemonbll.SelectBySaleHeadId(SaleHeadId);
if (row > 0)
{
//修改单头状态为2
Result result = salemonbll.updateHeadstate(saleId, SaleHeadId, 2);
if (result == Result.更新成功)
{
Response.Write("状态修改成功");
Response.End();
}
else
{
Response.Write("状态修改失败");
Response.End();
}
}
else
{
Response.Write("没有数据");
Response.End();
}
}
//返回按钮
if (op == "back")
{
updateSalehead();
int row = salemonbll.SelectBySaleHeadId(SaleHeadId);
if (row > 0)
{
string state = salemonbll.getsaleHeadState(SaleHeadId, saleId);
if (state == "0")
{
Result res = salemonbll.updateHeadstate(saleId, SaleHeadId, 1);
if (res == Result.更新成功)
{
Response.Write("更新成功");
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();
}
}
}
}
/// <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)
{
permission();
//getData();
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);
}
//添加销售任务
if (op == "add")
{
User user = (User)Session["user"];
int custmerID = Convert.ToInt32(Request["Custmer"]);
int regionId = user.ReginId.RegionId;
string state = saleBll.getcustomermsg(custmerID, regionId);
if (state == "1")
{
Response.Write("该客户还有未完成的销售任务，不能添加");
Response.End();
}
else
{
int count = saleBll.getCount();
if (count > 0)
{
string time = saleBll.getSaleTaskTime();
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 getsaleId = saleBll.getSaleTaskIdByTimedesc(nowTime);
if (getsaleId == "" || getsaleId == null)
{
count = 1;
saleTaskId = "XSRW" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
else
{
string js = getsaleId.Remove(0, getsaleId.Length - 5);
count = Convert.ToInt32(js) + 1;
saleTaskId = "XSRW" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
}
else
{
count = 1;
saleTaskId = "XSRW" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
}
else
{
count = 1;
saleTaskId = "XSRW" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
Customer customer = new Customer();
customer.CustomerId = custmerID;
int numberLimit = Convert.ToInt32(Request["numberLimit"]);
string strPriceLimit = Request["priceLimit"].ToString() + ".00";
double priceLimit = Convert.ToDouble(strPriceLimit);
string strTotalPriceLimit = Request["totalPriceLimit"].ToString() + ".00";
double totalPriceLimit = Convert.ToDouble(strTotalPriceLimit);
double defaultDiscount = double.Parse(Request["defaultDiscount"]);
string defaultCopy = Request["defaultCopy"].ToString();
string userId = user.UserId;
DateTime StartTime = DateTime.Now.ToLocalTime();
SaleTask saleTask = new SaleTask()
{
SaleTaskId = saleTaskId,
UserId = userId,
Customer = customer,
DefaultDiscount = defaultDiscount,
DefaultCopy = defaultCopy,
NumberLimit = numberLimit,
PriceLimit = priceLimit,
TotalPiceLimit = totalPriceLimit,
StartTime = StartTime,
};
Result result = saleBll.insert(saleTask);
if (result == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
}
}
//删除
if (op == "del")
{
string saleID = Request["ID"];
Result isDelete = saleBll.IsDelete("T_SellOffHead", "saleTaskId", saleID);
if (isDelete == Result.记录不存在)
{
isDelete = saleBll.IsDelete("T_ReplenishmentHead", "saleTaskId", saleID);
if (isDelete == Result.记录不存在)
{
isDelete = saleBll.IsDelete("T_SaleHead", "saleTaskId", saleID);
}
}
if (isDelete == Result.关联引用)
{
Response.Write("该客户已被关联到其他表，不能删除！");
}
else
{
Result result = saleBll.Delete(saleID);
if (result == Result.除成功)
{
Response.Write("删除成功");
Response.End();
}
else
{
Response.Write("删除失败");
Response.End();
}
}
}
//查看
if (op == "look")
{
string saleId = Request["ID"];
Session["saleId"] = saleId;
Session["type"] = "look";
Response.Write("成功");
Response.End();
}
//销售
if (op == "sale")
{
string saleId = Request["ID"];
Session["saleId"] = saleId;
Session["type"] = "add";
string finishState = saleBll.getSaleTaskFinishTime(saleId);
if (finishState == null || finishState == "")
{
Response.Write("可以");
Response.End();
}
else
{
Response.Write("不可以");
Response.End();
}
}
//添加销退
if (op == "saleback")
{
string saleTaskId = Request["ID"];
Session["saleId"] = saleTaskId;
string finishState = saleBll.getSaleTaskFinishTime(saleTaskId);
if (finishState == null || finishState == "")
{
Response.Write("不可以");
Response.End();
}
else
{
Response.Write("可以");
Response.End();
}
}
if (op == "isEdit")
{
string saleID = Request["saleId"];
string state = saleBll.getSaleTaskFinishTime(saleID);
if (state == "" || state == null)
{
Response.Write("可以编辑");
Response.End();
}
else
{
Response.Write("不可以编辑");
Response.End();
}
}
//编辑
if (op == "edit")
{
string saleId = Request["saleId"];
double allprice = double.Parse(Request["allpricemlimited"]);
int number = int.Parse(Request["numberlimited"]);
double price = double.Parse(Request["pricelimited"]);
double defaultDiscount = double.Parse(Request["defaultDiscounted"]);
string defaultCopyed = Request["defaultCopyed"].ToString();
int row = saleBll.update(number, price, allprice, defaultDiscount, defaultCopyed, saleId);
if (row > 0)
{
Response.Write("保存成功");
Response.End();
}
else
{
Response.Write("保存失败");
Response.End();
}
}
}
