/// <summary>
/// 收银删除
/// </summary>
public void delete()
{
int retailMonomerId = Convert.ToInt32(Request["retailId"]);
string retailHeadId = Request["headId"];
SaleMonomer monomer = retailBll.GetMonomer(retailMonomerId, retailHeadId);
Result del = retailBll.delete(retailMonomerId, retailHeadId);
if (del == Result.除成功)
{
string headId = Request["headId"];
SaleHead saleHead = retailBll.GetHead(headId);
SaleHead newHead = new SaleHead();
newHead.SaleHeadId = headId;
newHead.Number = saleHead.Number - monomer.Number;
newHead.KindsNum = saleHead.KindsNum - 1;
newHead.AllTotalPrice = saleHead.AllTotalPrice - monomer.TotalPrice;
newHead.AllRealPrice = saleHead.AllRealPrice - monomer.RealPrice;
Result head = retailBll.UpdateHeadNumber(newHead);
if (head == Result.更新成功)
{
Response.Write("删除成功|:" + newHead.Number + "|:" + newHead.AllTotalPrice + "|:" + newHead.AllRealPrice);
Response.End();
}
else
{
Response.Write("删除失败|:");
Response.End();
}
}
else
{
Response.Write("删除失败|:");
Response.End();
}
}
/// <summary>
/// 查询零售单头
/// </summary>
/// <param name="retailHeadId">零售单头ID</param>
/// <returns>数据集</returns>
public SaleHead GetHead(string retailHeadId)
{
string cmdText = "select allTotalPrice,number,allRealPrice,kindsNum,userName,retailHeadId,dateTime,regionName,payment from V_RetailHead where retailHeadId=@retailHeadId and deleteState!=1 order by dateTime";
string[] param = { "@retailHeadId" };
object[] values = { retailHeadId };
DataSet ds = db.FillDataSet(cmdText, param, values);
SaleHead sale = new SaleHead();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sale.AllRealPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["allRealPrice"]);
sale.AllTotalPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["allTotalPrice"]);
sale.Number = Convert.ToInt32(ds.Tables[0].Rows[0]["number"]);
sale.KindsNum = Convert.ToInt32(ds.Tables[0].Rows[0]["kindsNum"]);
sale.UserName = ds.Tables[0].Rows[0]["userName"].ToString();
sale.RegionName = ds.Tables[0].Rows[0]["regionName"].ToString();
sale.SaleHeadId = ds.Tables[0].Rows[0]["retailHeadId"].ToString();
sale.PayType = ds.Tables[0].Rows[0]["payment"].ToString();
sale.DateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["dateTime"]);
}
return(sale);
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
getIsbn();
if (!IsPostBack)
{
string userID = Request.QueryString["userId"].ToString();
if (userID != null && userID != "")
{
user = loginBll.getPwdByUserId(userID);
if (user.UserName == null)
{
Response.Write("无此用户信息，请检查！！！");
Response.End();
}
else
{
Session["user"] = user;
}
}
else
{
user = (User)Session["user"];
}
}
string op = Request["op"];
if (op == "add")
{
string bookNum = Request["bookNum"].ToString();
add(bookNum, "one");
}
if (op == "insert")
{
insert();
}
if (op == "delete")
{
string bookNum = Request["bookNum"].ToString();
bookNumList = (List <string>)Session["List"];
int index = bookNumList.IndexOf(bookNum);
bookNumList.RemoveAt(index);
Session["List"] = bookNumList;
}
if (op == "preRecord")
{
string headId = Request["headId"];
SaleHead sale = retailBll.GetHead(headId);
if (sale == null)
{
Response.Write("无记录:|");
Response.End();
}
else
{
Response.Write(sale.KindsNum + ":|" + sale.Number + ":|" + sale.AllTotalPrice + ":|" + sale.AllRealPrice);
Response.End();
}
}
}
/// <summary>
/// 更新单头
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public Result updateSalehead(HttpContext context)
{
string SaleHeadId = context.Request["saleheadID"];
string saleId = context.Request["saletaskID"];
int allnumber;
double alltotalprice;
double allreadprice;
DataSet ds;
int allkinds;
if (teamtype == "team")
{
allkinds = int.Parse(salemonbll.getkinds(saleId, SaleHeadId).ToString());
ds = salemonbll.calculationSaleHead(SaleHeadId, saleId);
}
else
{
allkinds = int.Parse(salemonbll.getperkinds(saleId, SaleHeadId).ToString());
ds = salemonbll.calculationPerSaleHead(SaleHeadId, saleId);
}
if (ds == null)
{
allnumber = 0;
alltotalprice = 0;
allreadprice = 0;
}
else
{
allnumber = int.Parse(ds.Tables[0].Rows[0]["数量"].ToString());
alltotalprice = double.Parse(ds.Tables[0].Rows[0]["总码洋"].ToString());
allreadprice = double.Parse(ds.Tables[0].Rows[0]["总实洋"].ToString());
}
//添加成功 更新单头
SaleHead salehead = new SaleHead();
salehead.SaleTaskId = saleId;
salehead.SaleHeadId = SaleHeadId;
salehead.KindsNum = allkinds;
salehead.Number = allnumber;
salehead.AllTotalPrice = alltotalprice;
salehead.AllRealPrice = allreadprice;
Result res;
if (teamtype == "team")
{
res = salemonbll.wechatupdateHead(salehead);
}
else
{
res = salemonbll.wechatupdatePerHead(salehead);
}
return(res);
}
/// <summary>
/// 更新零售数量
/// </summary>
/// <param name="sale">零售实体对象</param>
/// <returns>受影响行数</returns>
public int UpdateHeadNumber(SaleHead sale)
{
string cmdText = "update T_RetailHead set number=@number,allTotalPrice=@totalPrice,allRealPrice=@realPrice,kindsNum=@kindsNum where retailHeadId=@retailHeadId";
string[] param = { "@number", "totalPrice", "@realPrice", "@retailHeadId", "@kindsNum" };
object[] values = { sale.Number, sale.AllTotalPrice, sale.AllRealPrice, sale.SaleHeadId, sale.KindsNum };
int row = db.ExecuteNoneQuery(cmdText, param, values);
return(row);
}
/// <summary>
/// 小程序添加零售单头信息
/// </summary>
/// <param name="salehead"></param>
/// <returns></returns>
public int Insert(SaleHead salehead)
{
string cmdText = "insert into T_RetailHead(state,retailHeadId,userId,regionId,dateTime,kindsNum,number,allTotalPrice,allRealPrice,payment,openid) values(@state,@retailHeadId,@userId,@regionId,@dateTime,@kindsNum,@number,@allTotalPrice,@allRealPrice,@payment,@openid)";
string[] param = { "@state", "@retailHeadId", "@userId", "@regionId", "@dateTime", "@kindsNum", "@number", "@allTotalPrice", "@allRealPrice", "@payment", "@openid" };
object[] values = { salehead.State, salehead.SaleHeadId, salehead.UserId, salehead.RegionId, salehead.DateTime, salehead.KindsNum, salehead.Number, salehead.AllTotalPrice, salehead.AllRealPrice, salehead.PayType, salehead.OpenId };
int row = db.ExecuteNoneQuery(cmdText, param, values);
return(row);
}
/// <summary>
/// 添加销售单头
/// </summary>
/// <param name="task">销售单头实体</param>
/// <returns>受影响行数</returns>
public int Insert(SaleHead salehead)
{
string cmdText = "insert into T_SaleHead(saleHeadId,saleTaskId,kindsNum,number,allTotalPrice,allRealPrice,userId,regionId,dateTime,state,remarks) values(@saleHeadId,@saleTaskId,@kindsNum,@number,@allTotalPrice,@allRealPrice,@userId,@regionId,@dateTime,@state,@remarks)";
string[] param = { "@saleHeadId", "@saleTaskId", "@kindsNum", "@number", "@allTotalPrice", "@allRealPrice", "@userId", "@regionId", "@dateTime", "@state", "@remarks" };
object[] values = { salehead.SaleHeadId, salehead.SaleTaskId, salehead.KindsNum, salehead.Number, salehead.AllTotalPrice, salehead.AllRealPrice, salehead.UserId, salehead.RegionId, salehead.DateTime, salehead.State, salehead.Remarks };
int row = db.ExecuteNoneQuery(cmdText, param, values);
return(row);
}
/// <summary>
/// 查看详情页面
/// </summary>
/// <param name="context"></param>
public void checkDetail(HttpContext context)
{
string headid = context.Request["headid"];
SaleHead retail = retailBll.GetHead(headid);
if (retail == null)
{
retailM.type = "暂无订单信息";
string json = JsonHelper.JsonSerializerBySingleData(retailM);
context.Response.Write(json);
context.Response.End();
}
else
{
DataSet dsDetail = retailBll.GetRetail(headid);
if (dsDetail == null || dsDetail.Tables[0].Rows.Count <= 0)
{
retailM.type = "暂无订单信息";
string json = JsonHelper.JsonSerializerBySingleData(retailM);
context.Response.Write(json);
context.Response.End();
}
else
{
if (retail.PayType == "未支付")
{
retailM.type = "未支付";
retailM.retailHeadId = retail.SaleHeadId;
retailM.allNumber = retail.Number.ToString();
retailM.kindsNum = retail.KindsNum.ToString();
retailM.allTotalPrice = retail.AllTotalPrice.ToString();
retailM.allRealPrice = retail.AllRealPrice.ToString();
string data = JsonHelper.ToJson(dsDetail.Tables[0], "retail");
retailM.data = data;
string json = JsonHelper.JsonSerializerBySingleData(retailM);
context.Response.Write(json);
context.Response.End();
}
else
{
retailM.allNumber = retail.Number.ToString();
retailM.kindsNum = retail.KindsNum.ToString();
retailM.allTotalPrice = retail.AllTotalPrice.ToString();
retailM.allRealPrice = retail.AllRealPrice.ToString();
retailM.type = "数据";
string data = JsonHelper.ToJson(dsDetail.Tables[0], "retail");
retailM.data = data;
string json = JsonHelper.JsonSerializerBySingleData(retailM);
context.Response.Write(json);
context.Response.End();
}
}
}
}
/// <summary>
/// 更新预采单头
/// </summary>
/// <param name="salehead">单头实体</param>
/// <returns></returns>
public Result wechatupdatePerHead(SaleHead salehead)
{
int row = SaleMonomerdao.wechatupdatePerHead(salehead);
if (row > 0)
{
return(Result.更新成功);
}
else
{
return(Result.更新失败);
}
}
/// <summary>
/// 小程序零售单头添加
/// </summary>
/// <param name="salehead">销售单头实体</param>
/// <returns>返回结果</returns>
public Result Insert(SaleHead salehead)
{
int row = dao.Insert(salehead);
if (row > 0)
{
return(Result.添加成功);
}
else
{
return(Result.添加失败);
}
}
/// <summary>
/// 更新零售数量
/// </summary>
/// <param name="sale">零售实体对象</param>
/// <returns>受影响行数</returns>
public Result UpdateHeadNumber(SaleHead sale)
{
int row = dao.UpdateHeadNumber(sale);
if (row > 0)
{
return(Result.更新成功);
}
else
{
return(Result.更新失败);
}
}
protected void Page_Load(object sender, EventArgs e)
{
permission();
retailHeadId = Session["retailHeadId"].ToString();
//getData();
single = retailbll.GetHead(Session["retailHeadId"].ToString());
string op = Request["op"];
if (op == "paging")
{
getData();
}
}
protected void Page_Load(object sender, EventArgs e)
{
permission();
retailHeadId = Session["retailHeadId"].ToString();
User user = (User)Session["user"];
single = retailbll.GetHead(Session["retailHeadId"].ToString());
int regionId = user.ReginId.RegionId;
//getData();
string op = Request["op"];
if (op == "paging")
{
getData();
}
}
/// <summary>
/// 收银修改折扣
/// </summary>
public void Discount()
{
double discount = Convert.ToDouble(Request["discount"]);
string retailId = Request["retailId"];
DataSet ds = retailBll.GetRetail(retailId);
if (ds == null)
{
Response.Write("记录不存在");
Response.End();
}
else
{
double real = 0, reals = 0, allReal = 0, allReals = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string bookNum = ds.Tables[0].Rows[i]["bookNum"].ToString();
double total = Convert.ToDouble(ds.Tables[0].Rows[i]["totalPrice"]);
real = Convert.ToDouble(ds.Tables[0].Rows[i]["realPrice"]);
allReal = allReal + real;
reals = total * discount * 0.01;
allReals = allReals + reals;
Result change = retailBll.UpdateDiscount(discount, reals, retailId, bookNum);
if (change == Result.更新失败)
{
Response.Write("更新失败");
Response.End();
}
}
SaleHead head = retailBll.GetHead(retailId);
Result reales = retailBll.UpdateHeadReal(head.AllRealPrice - allReal + allReals, retailId);
if (reales == Result.更新成功)
{
Response.Write("更新成功");
Response.End();
}
else
{
Response.Write("更新失败");
Response.End();
}
}
}
/// <summary>
/// 更新销售单头
/// </summary>
/// <returns>返回结果</returns>
public Result updateSalehead()
{
//更新单头
allkinds = int.Parse(salemonbll.getkinds(saleId, SaleHeadId).ToString());
DataSet ds = salemonbll.calculationSaleHead(SaleHeadId, saleId);
if (ds == null)
{
allnumber = 0;
alltotalprice = 0;
allreadprice = 0;
}
else
{
allnumber = int.Parse(ds.Tables[0].Rows[0]["数量"].ToString());
alltotalprice = double.Parse(ds.Tables[0].Rows[0]["总码洋"].ToString());
allreadprice = double.Parse(ds.Tables[0].Rows[0]["总实洋"].ToString());
}
//DataSet allds = salemonbll.SelectMonomers(SaleHeadId);
//int j = allds.Tables[0].Rows.Count;
//for (int h = 0; h < j; h++)
//{
// allnumber += Convert.ToInt32(allds.Tables[0].Rows[h]["number"]);
// alltotalprice += Convert.ToInt32(allds.Tables[0].Rows[h]["totalPrice"]);
// allreadprice += Convert.ToInt32(allds.Tables[0].Rows[h]["realPrice"]);
//}
//添加成功 更新单头
SaleHead salehead = new SaleHead();
salehead.SaleTaskId = saleId;
salehead.SaleHeadId = SaleHeadId;
salehead.KindsNum = allkinds;
salehead.Number = allnumber;
salehead.AllTotalPrice = alltotalprice;
salehead.AllRealPrice = allreadprice;
Result res = salemonbll.updateHead(salehead);
return(res);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="context"></param>
private void addHead(HttpContext context)
{
string customeID = context.Request["customID"];
string saleId = context.Request["saletaskID"];
UserBll user = new UserBll();
DataSet userds = user.selectByUserId(customeID);
int regionId = Convert.ToInt32(userds.Tables[0].Rows[0]["regionId"]);
SaleHeadBll saleheadbll = new SaleHeadBll();
SaleHead salehead = new SaleHead();
string SaleHeadId;
int count;
string type = context.Request["type"];
if (type == "team")
{
count = saleheadbll.getCount();
}
else
{
count = saleheadbll.WeChatcountHead();
}
if (count > 0)
{
string time;
if (type == "team")
{
time = saleheadbll.getSaleHeadTime();
}
else
{
time = saleheadbll.getPerSaleHeadTime();
}
string nowTime = DateTime.Now.ToLocalTime().ToString();
string equalsTime = DateTime.Now.ToLocalTime().ToString("yyyyMMdd");
if (time.Equals(equalsTime))
{
string getheadId;
nowTime = DateTime.Now.ToString("yyyy-MM-dd");
if (type == "team")
{
getheadId = saleheadbll.getSaleHeadIdByTime(nowTime);
}
else
{
getheadId = saleheadbll.getPerSaleHeadIdByTime(nowTime);
}
if (getheadId == "" || getheadId == null)
{
count = 1;
SaleHeadId = "WXS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
else
{
string js = getheadId.Remove(0, getheadId.Length - 6);
count = Convert.ToInt32(js) + 1;
SaleHeadId = "WXS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
}
else
{
count = 1;
SaleHeadId = "WXS" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
}
else
{
count = 1;
SaleHeadId = "WXS" + 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;
salehead.UserId = customeID;
salehead.RegionId = regionId;
salehead.DateTime = DateTime.Now.ToLocalTime();
Result result;
if (type == "team")
{
salehead.State = 0;
result = saleheadbll.Insert(salehead);
}
else
{
salehead.State = 3;
result = saleheadbll.perInsert(salehead);
}
if (result == Result.添加成功)
{
context.Response.Write("添加成功");
context.Response.End();
}
else
{
context.Response.Write("添加失败");
context.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();
}
}
}
/// <summary>
/// 收银修改数量
/// </summary>
public void change()
{
string type = Request["type"];
int number = Convert.ToInt32(Request["number"]);
int retailId = Convert.ToInt32(Request["retailId"]);
string headId = Request["headId"];
SaleMonomer monomer = retailBll.GetMonomer(retailId, headId);
int oldNumber = monomer.Number;
double oldTotal = monomer.TotalPrice;
double oldReal = monomer.RealPrice;
double price = monomer.UnitPrice;
double realDiscount = monomer.RealDiscount;
double total = 0, real = 0;
SaleMonomer sale = new SaleMonomer();
sale.SaleIdMonomerId = retailId;
sale.Number = number;
sale.TotalPrice = number * price;
sale.RealPrice = number * price * realDiscount * 0.01;
sale.SaleHeadId = headId;
Result change = retailBll.UpdateNumber(sale);
if (change == Result.更新成功)
{
SaleHead head = retailBll.GetHead(headId);
SaleHead newHead = new SaleHead();
int newNumber = 0;
double newTotal = 0, newReal = 0;
if (type == "jia")
{
newNumber = head.Number + 1;
newTotal = head.AllTotalPrice + price;
newReal = head.AllRealPrice + (price * realDiscount * 0.01);
}
else if (type == "jian")
{
newNumber = head.Number - 1;
newTotal = head.AllTotalPrice - price;
newReal = head.AllRealPrice - (price * realDiscount * 0.01);
}
newHead.SaleHeadId = headId;
newHead.Number = newNumber;
newHead.AllTotalPrice = newTotal;
newHead.AllRealPrice = newReal;
newHead.KindsNum = head.KindsNum;
Result headRe = retailBll.UpdateHeadNumber(newHead);
if (headRe == Result.更新成功)
{
Response.Write("更新成功|:" + newNumber + "," + newTotal + "," + newReal + "|:" + total + "|:" + real);
Response.End();
}
else
{
Response.Write("更新失败|:");
Response.End();
}
}
else
{
Response.Write("更新失败|:");
Response.End();
}
}
/// <summary>
/// 收银扫描单据查询明细
/// </summary>
public void scann()
{
string retailId = Request["retailId"];
SaleHead sale = retailBll.GetHead(retailId);
if (sale == null)
{
Response.Write("记录不存在");
Response.End();
}
else
{
int state = retailBll.GetRetailType(retailId);
if (state == 1)
{
Response.Write("此单据已结算");
Response.End();
}
else if (state == 2)
{
Response.Write("此单据为退货单据");
Response.End();
}
else
{
DataSet ds = retailBll.GetRetail(retailId);
if (ds == null)
{
Response.Write("记录不存在");
Response.End();
}
else
{
StringBuilder sb = new StringBuilder();
int counts = ds.Tables[0].Rows.Count;
for (int i = 0; i < counts; i++)
{
DataRow dr = ds.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>");
}
allReal = sale.AllRealPrice;
allTotal = sale.AllTotalPrice;
count = sale.Number;
kind = counts;
Response.Write("number:" + allTotal + "," + allReal + "," + count + "," + kind + "|:" + 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();
}
}