protected void Page_Load(object sender, EventArgs e)
{
if (Session["login"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
if (Request.QueryString["ids"] == null)
{
return;
}
string ids = Request.QueryString["ids"];
ids = ids.Substring(0, ids.Length - 1);
this.Repeater1.DataSource = TradeDAL.getTradeByMIDAndBIDS(Convert.ToInt32(Session["login"]), ids);
this.Repeater1.DataBind();
double sumPrice = 0;
foreach (RepeaterItem item in Repeater1.Items)
{
Label lblprice = item.FindControl("lblPrice") as Label;
Label lblBCount = item.FindControl("lblBCount") as Label;
int price = Convert.ToInt32(lblprice.Text);
int count = Convert.ToInt32(lblBCount.Text);
sumPrice += price * count;
}
this.Label1.Text = sumPrice.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
foreach (RepeaterItem item in Repeater1.Items)
{
CheckBox ck1 = item.FindControl("CheckBox1") as CheckBox;
if (ck1.Checked)
{
LinkButton lbt1 = item.FindControl("LinkButton1") as LinkButton;
//ids += (lbt1.CommandArgument + ",");
if (TradeDAL.DeleteByTID(Convert.ToInt32(lbt1.CommandArgument)) > 0)
{
id++;
}
}
}
if (id > 0)
{
Alert("空空如也");
CheckBox2.Checked = false;
ShowDate();
}
else
{
Alert("啥也没选中");
}
}
protected void TextBox1_Changed(object sender, EventArgs args)
{
foreach (RepeaterItem item in Repeater1.Items)
{
TextBox txt = item.FindControl("TextBox1") as TextBox;
Label lblPrice = item.FindControl("lblPrice") as Label;
Label lblSum = item.FindControl("lblSum") as Label;
//检查库存
LinkButton lbt = item.FindControl("LinkButton1") as LinkButton;
//Response.Write(lbt.CommandName);
int BID = int.Parse(lbt.CommandName);
List <Book> list = BookDAL.selectByID(BID);
if (Convert.ToInt32(txt.Text) > list[0].BCount)
{
Alert("");
txt.Text = list[0].BCount.ToString();
return;
}
//根据数量改变总价lblSum
lblSum.Text = (Convert.ToDouble(lblPrice.Text) * Convert.ToInt32(txt.Text)).ToString();
//根据商品数量变动修改购物车商品数量
if (TradeDAL.UpdateByTID(BID, Convert.ToInt32(txt.Text)) > 0)
{
//Response.Write("购物车数量改变")
}
else
{
Alert("请重新操作");
}
}
}
protected void ImageButton1_Click(object sender, EventArgs e)
{
if (Session["login"] == null)
{
Alert("请先登录");
Response.Redirect("Login.aspx?url=goods.aspx&id=" + Request.QueryString["id"]);
}
int BID = int.Parse(Request.QueryString["id"]);
int MID = Convert.ToInt32(Session["login"]);
int number = 1;
//获取数量
TextBox lbl = Repeater1.Items[0].FindControl("TextBox1") as TextBox;
number = Convert.ToInt32(lbl.Text);
Trade t = new Trade()
{
BID = BID,
MID = MID,
BCount = number
};
bool ecits = TradeDAL.Exits(t);
if (ecits == true)
{
int id = TradeDAL.update_Bcount(t);
if (id > 0)
{
Alert("商品已加入购物车");
}
}
else
{
if (TradeDAL.addTrade(BID, MID, number) > 0)
{
Alert("商品已加入购物车");
int id = TradeDAL.updateBcountByid(number, BID);
if (id > 0)
{
if (Request.QueryString["id"] == null)
{
return;
}
//绑定数据
List <Book> list = BookDAL.selectByID(int.Parse(Request.QueryString["id"]));
this.Repeater1.DataSource = list;
this.Repeater1.DataBind();
}
//Response.Redirect("flow.aspx");
if (Request.QueryString["url"] != null)
{
Response.Redirect(Request.QueryString["url"]);
}
}
}
}
public string QueryTrade()
{
MMessage <ICollection <MSaleFlow> > msg = new MMessage <ICollection <MSaleFlow> >();
msg.Flag = isValid(soapHeader, out msg.Text);
if (msg.Flag)
{
msg.Flag = TradeDAL.QueryTrade(soapHeader.PosNO, out msg.Content, out msg.Text);
}
if (!msg.Flag)
{
WriteLog("QueryTrade", msg.Flag, msg.Text);
}
return(Converter.Serialize(msg));
}
protected void LinkButton_Click(object o, EventArgs e)
{
LinkButton lbu = o as LinkButton;
int TID = int.Parse(lbu.CommandArgument);
if (TradeDAL.DeleteByTID(TID) > 0)
{
Alert("删除成功");
ShowDate();
}
else
{
Alert("删除失败");
}
}
protected void Button1_Click(object o, EventArgs e)
{
//1>.构建订单表对象:
Order orders = new Order();
orders.OID = OrdersDAL.GetNewOrderID(); //订单编号
orders.MID = Convert.ToInt32(Session["login"]);
orders.ODate = Convert.ToDateTime(DateTime.Now.ToString());
orders.OConsignee = this.txtName.Text;
orders.OAddress = this.txtAddress.Text;
orders.OTelephone = this.txtTel.Text;
orders.OState = 1; //新订单
//2>.构建订单详细表集合
List <OrderDetails> listDetails = new List <OrderDetails>();
//得到购物车集合
if (Request.QueryString["ids"] == null)
{
return;
}
string ids = Request.QueryString["ids"];
ids = ids.Substring(0, ids.Length - 1);
List <Trade> listTrade = TradeDAL.getTradeByMIDAndBIDS(Convert.ToInt32(Session["login"]), ids);
foreach (Trade trade in listTrade)
{
OrderDetails details = new OrderDetails();
details.OID = orders.OID; //订单编号
details.BID = trade.BID; //书籍编号
details.BPrice = trade.BPrice; //书籍价格
details.BCount = trade.BCount; //购买数量
listDetails.Add(details);
}
orders.OSumPrice = Convert.ToInt32(this.Label1.Text); //总计;
//保存订单:
int count = OrdersDAL.SavaOrder(orders, listDetails);
//if (txtName.Text!=null && txtTel.Text!=null && txtAddress!=null)
//{
if (count > 0)
{
Response.Redirect("done.aspx?OID=" + orders.OID);
}
}
public string SaveTrade(string saleFlowJson, string payFlowJson)
{
MMessage <MCzCard> msg = new MMessage <MCzCard>();
msg.Flag = isValid(soapHeader, out msg.Text);
if (msg.Flag)
{
MSaleFlow[] saleFlowList = Converter.Deserialize <MSaleFlow[]>(saleFlowJson);
MPayFlow[] payFlowList = Converter.Deserialize <MPayFlow[]>(payFlowJson);
msg.Flag = TradeDAL.SaveTrade(saleFlowList, payFlowList, out msg.Content, out msg.Text);
}
if (!msg.Flag)
{
WriteLog("SaveTrade", msg.Flag, msg.Text);
}
return(Converter.Serialize(msg));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Name"] != null)
{
this.Label1.Text = Session["Name"].ToString();
}
if (Session["login"] != null)
{
this.Label2.Text = TradeDAL.getTradeRows(Convert.ToInt32(Session["login"])).ToString();
if (this.Label2.Text != "")
{
this.Label3.Text = TradeDAL.getTradeSumPriceByMID(Convert.ToInt32(Session["login"])).ToString();
}
}
if (!IsPostBack)
{
List <BLCategory> bllist = CategoryDAL.getBLCategoryList();
foreach (BLCategory bl in bllist)
{
//大类节点
TreeNode nodeBL = new TreeNode();
nodeBL.Text = bl.BLName;
nodeBL.Value = bl.BLID.ToString();
nodeBL.NavigateUrl = "Category.aspx?BLID=" + bl.BLID;
this.TreeView1.Nodes.Add(nodeBL);
//查询小节点
List <BSCategory> listBs = CategoryDAL.getBSCategoryList(bl.BLID);
foreach (BSCategory bs in listBs)
{
TreeNode nodeBS = new TreeNode();
nodeBS.Text = bs.BSName;
nodeBS.Value = bs.BSID.ToString();
nodeBS.NavigateUrl = "Category.aspx?BSID=" + bs.BSID;
nodeBL.ChildNodes.Add(nodeBS);
}
}
//绑定Repeater1
this.Repeater1.DataSource = CategoryDAL.getBLCategoryList();
this.Repeater1.DataBind();
}
//int id = Convert.ToInt32(Session["zhuji"].ToString());
//Response.Write(id);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
int mid = Convert.ToInt32(Session["login"]);
if ((TradeDAL.getTradeRows(mid)) > 0)
{
string ids = "";
CheckBox ck1 = null;
int id = 0;
foreach (RepeaterItem item in Repeater1.Items)
{
ck1 = item.FindControl("CheckBox1") as CheckBox;
if (ck1.Checked)
{
LinkButton lbt1 = item.FindControl("LinkButton1") as LinkButton;
ids += (lbt1.CommandArgument + ",");
id++;
}
}
if (ids != null && id > 0)
{
Response.Redirect("consignee.aspx?ids=" + ids);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请选择您要下单的商品')</script>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('购物车是空的哦，快去主页选购商品吧')</script>");
//Response.Redirect("main.aspx");
}
}
public static DataTable GetTradeByTID(string tid)
{
return(TradeDAL.GetTradeByTID(tid));
}
public static DataTable GetTop10Sales(string sellerNick)
{
return(TradeDAL.GetTop10Sales(sellerNick));
}
/// <summary>
/// 修改数量
/// </summary>
/// <returns></returns>
public static int UpdateByTID(int TID, int BCount)
{
return(TradeDAL.UpdateByTID(TID, BCount));
}
/// <summary>
/// 查询购物车的商品
/// </summary>
/// <param name="id">会员id</param>
/// <returns></returns>
public static SqlDataReader SelectTrade(int id)
{
return(TradeDAL.SelectTrade(id));
}
public static DataTable GetOrderByOID(string oid)
{
return(TradeDAL.GetOrderByOID(oid));
}
public static bool UpdateOrder(Order o, long tid)
{
return(TradeDAL.UpdateOrder(o, tid));
}
public static DataTable GetTradeDataNoSuccess(string sellerNick, string status)
{
return(TradeDAL.GetTradeDataNoSuccess(sellerNick, status));
}
/// <summary>
/// 显示购物车
/// </summary>
/// <param name="MID"></param>
/// <returns></returns>
public static List <Trade> getTradeByMID(int MID)
{
return(TradeDAL.getTradeByMID(MID));
}
/// <summary>
/// 添加到购物车
/// </summary>
/// <returns></returns>
public static int addTrade(int BID, int MID, int number)
{
return(TradeDAL.addTrade(BID, MID, number));
}
/// <summary>
/// 查询购物车内商品数量和总价钱
/// </summary>
/// <param name="mid"></param>
/// <returns></returns>
public static SqlDataReader CheckTradeCount(int mid)
{
return(TradeDAL.CheckTradeCount(mid));
}
/// <summary>
/// 检查库存
/// </summary>
/// <param name="bid"></param>
/// <returns></returns>
public static int CheckBcount(int bid)
{
return(Convert.ToInt32(TradeDAL.CheckBcount(bid)));
}
/// <summary>
/// 删除购物车内商品
/// </summary>
/// <param name="id">商品id</param>
/// <returns></returns>
public static int DeleteGoods(int id)
{
return(TradeDAL.DeleteGoods(id));
}
public static bool UpdateTrade(Trade o)
{
return(TradeDAL.UpdateTrade(o));
}
/// <summary>
/// 根据id查询购物车里面的总价
/// </summary>
/// <param name="MID"></param>
/// <returns></returns>
public static double getTradeSumPriceByMID(int MID)
{
return(TradeDAL.getTradeSumPriceByMID(MID));
}
private void ShowDate()
{
this.Repeater1.DataSource = TradeDAL.getTradeByMID(Convert.ToInt32(Session["login"]));
this.Repeater1.DataBind();
}
/// <summary>
/// 根据id删除购物车
/// </summary>
/// <param name="TID"></param>
/// <returns></returns>
public static int DeleteByTID(int TID)
{
return(TradeDAL.DeleteByTID(TID));
}
/// <summary>
/// 根据用户id和多个书籍id显示结账数据
/// </summary>
/// <param name="MID"></param>
/// <returns></returns>
public static List <Trade> getTradeByMIDAndBIDS(int MID, string ids)
{
return(TradeDAL.getTradeByMIDAndBIDS(MID, ids));
}
/// <summary>
/// 查询卖家已经确认收获，但物流未签收的买家订单
/// </summary>
/// <param name="sellerNick"></param>
/// <param name="status"></param>
/// <returns></returns>
public static DataTable GetTradeDataNosign(string sellerNick, string startDate, string endDate, string startPay, string endDPay, string status)
{
return(TradeDAL.GetTradeDataNosign(sellerNick, startDate, endDate, startPay, endDPay, status));
}
/// <summary>
/// 根据用户id查询购物车共有多小条数据
/// </summary>
/// <param name="MID"></param>
/// <returns></returns>
public static int getTradeRows(int MID)
{
return(TradeDAL.getTradeRows(MID));
}
public static Boolean CheckTradeIsExit(long tid)
{
return(TradeDAL.CheckTradeIsExit(tid));
}
