protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { if (UsersInfo.UserID == "") { Response.Write("<script> alert('请先登录!'); window.location.href='../Login.aspx' </script>"); return; } else { Maticsoft.Model.Commodity modelnew = Commodity_Bll.GetModel(Request.QueryString["ID"].ToString()); Appraise_Mol.AppriseID = DateTime.Now.ToString("yyyyMMddhhmmss"); Appraise_Mol.CommodityID = modelnew.CommodityID; Appraise_Mol.UserID = UsersInfo.UserID; if (Appraise_Bll.GetRecordCount(" CommodityID='" + Request.QueryString["ID"] + "' and UserID='" + UsersInfo.UserID + "' ") > 0) { Appraise_Bll.Delete(Appraise_Bll.GetList(" CommodityID='" + Request.QueryString["ID"] + "' and UserID='" + UsersInfo.UserID + "' ").Tables[0].Rows[0]["AppriseID"].ToString()); ImageButton1.ImageUrl = "~/image/kstar.png"; } else { Appraise_Bll.Add(Appraise_Mol); ImageButton1.ImageUrl = "~/image/star.png"; } } }
protected void RadListView1_ItemCommand(object sender, Telerik.Web.UI.RadListViewCommandEventArgs e) { string OrderID; OrderID = e.CommandArgument.ToString(); Maticsoft.Model.Users molUsers = Users_Bll.GetModel(UsersInfo.UserID); if (e.CommandName == "Pay") { Response.Write("<script>window.location.href='/ForeManagement/ForeOrdersDetail.aspx?OrderID=" + OrderID + "'</script>"); } if (e.CommandName == "Cancel") { Maticsoft.Model.Orders molOrders = Orders_Bll.GetModel(OrderID); molOrders.OrderState = "订单取消"; Orders_Bll.Update(molOrders); } if (e.CommandName == "Hurry") { Response.Write("<script> alert('催单成功!')</script>"); } if (e.CommandName == "Check") { Orders_Mol = Orders_Bll.GetModel(OrderID);//引用 DataSet ds = new DataSet(); ds = Orders_Bll.GetList2(0, " a.OrderID='" + OrderID + "' ", " OrderDate"); Users_Mol = Users_Bll.GetModel(UsersInfo.UserID);//引用 foreach (DataRow dr in ds.Tables[0].Rows) { //增加销售数量 Commodity_Mol = Commodity_Bll.GetModel(dr["CommodityID"].ToString()); Commodity_Mol.CommoditySaled = Commodity_Mol.CommoditySaled + Convert.ToInt32(dr["OrderNumber"]); Commodity_Bll.Update(Commodity_Mol);//更新 //增加积分点数 string str = dr["BuyScore"].ToString(); string shu = dr["OrderNumber"].ToString(); Users_Mol.UserScore += Convert.ToInt32(str) * Convert.ToInt32(shu); } Users_Mol.UserGrade = "VIP"; Orders_Mol.OrderState = "完成"; Orders_Bll.Update(Orders_Mol); //更新 Users_Bll.Update(Users_Mol); //更新 RadListView1.Rebind(); Maticsoft.Model.Orders molOrders = Orders_Bll.GetModel(OrderID); //Maticsoft.Model.Commodity molCommodity = Commodity_Bll.GetModel(OrderID); //int total = Orders_Bll.GetTotal(OrderID); //molUsers.UserScore += total; //molOrders.OrderState = "完成"; Orders_Bll.Update(molOrders); } if (e.CommandName == "Score") { } }
protected void RadLV_splb_ItemCommand(object sender, Telerik.Web.UI.RadListViewCommandEventArgs e) { string Collectid = e.CommandArgument.ToString(); if (e.CommandName == "Delete") { string AppriseID1; AppriseID1 = e.CommandArgument.ToString(); Appraise_Bll.DeleteList(e.CommandArgument.ToString()); RadLV_splb.Rebind();//删除 } if (e.CommandName == "Join") { string CommodityID1; CommodityID1 = e.CommandArgument.ToString(); Maticsoft.Model.Commodity modelCommodity = Commodity_Bll.GetModel(CommodityID1.ToString()); if (ShoppingCart_Bll.GetRecordCount(" CommodityID='" + CommodityID1 + "' and UserID='" + UsersInfo.UserID + "' ") > 0) { Maticsoft.Model.ShoppingCart modelShoppingCart = ShoppingCart_Bll.GetModel(CommodityID1.ToString()); string id = ShoppingCart_Bll.GetList(" CommodityID='" + CommodityID1 + "' and UserID='" + UsersInfo.UserID + "' ").Tables[0].Rows[0]["ShoppingCartID"].ToString(); modelShoppingCart = ShoppingCart_Bll.GetModel(id); modelShoppingCart.ShoppingCartID = modelShoppingCart.ShoppingCartID; modelShoppingCart.UserID = UsersInfo.UserID; modelShoppingCart.CommodityID = modelCommodity.CommodityID; modelShoppingCart.OrderNumber = modelShoppingCart.OrderNumber + 1; if (modelShoppingCart.OrderNumber > modelCommodity.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } ShoppingCart_Bll.Update(modelShoppingCart); } else { Maticsoft.Model.Users modelusers = Users_Bll.GetModel(UsersInfo.UserID); decimal discount1; if (modelusers.UserGrade == "VIP") { discount1 = Convert.ToDecimal(0.95); } else { discount1 = Convert.ToDecimal(1); } ShoppingCart_Mol.ShoppingCartID = DateTime.Now.ToString("yyyyMMddhhmmss"); ShoppingCart_Mol.UserID = UsersInfo.UserID; ShoppingCart_Mol.CommodityID = CommodityID1; ShoppingCart_Mol.OrderNumber = 1; ShoppingCart_Mol.Subtotal = ((ShoppingCart_Mol.OrderNumber * modelCommodity.VIPPrice) * discount1).ToString(); ShoppingCart_Bll.Add(ShoppingCart_Mol); } RadAjaxManager1.Alert("已添加到购物车!"); } }
protected void RadLV_splb_ItemDataBound(object sender, Telerik.Web.UI.RadListViewItemEventArgs e) { string id = e.Item.OwnerListView.DataKeyValues[e.Item.OwnerListView.DataKeyValues.Count - 1]["AppriseID"].ToString(); LinkButton LinkButton1 = e.Item.FindControl("LinkButton1") as LinkButton; if (LinkButton1 != null) { Appraise_Mol = Appraise_Bll.GetModel(id); Commodity_Mol = Commodity_Bll.GetModel(Appraise_Mol.CommodityID); if (Commodity_Mol.Stock == 0 || Commodity_Mol.CommodityState == "下架") { LinkButton1.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { num = 1; Commoditynum.Text = num.ToString(); if (!String.IsNullOrEmpty(Request.QueryString["ID"])) { Maticsoft.Model.Commodity modelnew = Commodity_Bll.GetModel(Request.QueryString["ID"].ToString());//引用id所在行的数据 Image1.ImageUrl = modelnew.CommodityImage; Label1.Text = modelnew.CommodityName; Label2.Text = modelnew.CommodityType; Label3.Text = modelnew.MarketPrice.ToString(); Label4.Text = modelnew.VIPPrice.ToString(); Label6.Text = modelnew.CommoditySaled.ToString(); Label7.Text = modelnew.Stock.ToString(); Label8.Text = modelnew.Introduce; Label5.Text = modelnew.CommodityState; pinfen(); if (Appraise_Bll.GetRecordCount(" CommodityID='" + Request.QueryString["ID"] + "' and UserID='" + UsersInfo.UserID + "' ") > 0) { ImageButton1.ImageUrl = "~/image/star.png"; } else { ImageButton1.ImageUrl = "~/image/kstar.png"; } if (Label8.Text != "") { Label8.Visible = true; } if (modelnew.Stock == 0) { Commoditynum.Visible = false; Button1.Visible = false; Btn_add.Visible = false; Btn_jian.Visible = false; } } else { Response.Redirect("Foresplb.aspx"); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Commodity GetModel(string CommodityID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" CommodityID,CommodityFatherID,CommoditySonID,CommodityName,CommodityPrice,MarketPrice,VIPPrice,Stock,BuyScore,CommodityImage,CommodityType,CommoditySaled,Introduce,CommodityTime,Recommend,CommodityState,Score,ScoreTimes "); strSql.Append(" from Commodity "); strSql.Append(" where CommodityID='" + CommodityID + "' "); Maticsoft.Model.Commodity model = new Maticsoft.Model.Commodity(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void ShowInfo(string CommodityID) { Maticsoft.BLL.Commodity bll = new Maticsoft.BLL.Commodity(); Maticsoft.Model.Commodity model = bll.GetModel(CommodityID); this.lblCommodityID.Text = model.CommodityID; this.lblCommodityFatherID.Text = model.CommodityFatherID; this.lblCommoditySonID.Text = model.CommoditySonID; this.lblCommodityName.Text = model.CommodityName; this.lblCommodityPrice.Text = model.CommodityPrice; this.lblMarketPrice.Text = model.MarketPrice.ToString(); this.lblVIPPrice.Text = model.VIPPrice.ToString(); this.lblStock.Text = model.Stock.ToString(); this.lblBuyScore.Text = model.BuyScore; this.lblCommodityImage.Text = model.CommodityImage; this.lblCommodityType.Text = model.CommodityType; this.lblCommoditySaled.Text = model.CommoditySaled.ToString(); this.lblIntroduce.Text = model.Introduce; this.lblCommodityTime.Text = model.CommodityTime.ToString(); this.lblRecommend.Text = model.Recommend; this.lblCommodityState.Text = model.CommodityState; this.lblScore.Text = model.Score; this.lblScoreTimes.Text = model.ScoreTimes; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.Commodity model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.CommodityID != null) { strSql1.Append("CommodityID,"); strSql2.Append("'" + model.CommodityID + "',"); } if (model.CommodityFatherID != null) { strSql1.Append("CommodityFatherID,"); strSql2.Append("'" + model.CommodityFatherID + "',"); } if (model.CommoditySonID != null) { strSql1.Append("CommoditySonID,"); strSql2.Append("'" + model.CommoditySonID + "',"); } if (model.CommodityName != null) { strSql1.Append("CommodityName,"); strSql2.Append("'" + model.CommodityName + "',"); } if (model.CommodityPrice != null) { strSql1.Append("CommodityPrice,"); strSql2.Append("'" + model.CommodityPrice + "',"); } if (model.MarketPrice != null) { strSql1.Append("MarketPrice,"); strSql2.Append("" + model.MarketPrice + ","); } if (model.VIPPrice != null) { strSql1.Append("VIPPrice,"); strSql2.Append("" + model.VIPPrice + ","); } if (model.Stock != null) { strSql1.Append("Stock,"); strSql2.Append("" + model.Stock + ","); } if (model.BuyScore != null) { strSql1.Append("BuyScore,"); strSql2.Append("'" + model.BuyScore + "',"); } if (model.CommodityImage != null) { strSql1.Append("CommodityImage,"); strSql2.Append("'" + model.CommodityImage + "',"); } if (model.CommodityType != null) { strSql1.Append("CommodityType,"); strSql2.Append("'" + model.CommodityType + "',"); } if (model.CommoditySaled != null) { strSql1.Append("CommoditySaled,"); strSql2.Append("" + model.CommoditySaled + ","); } if (model.Introduce != null) { strSql1.Append("Introduce,"); strSql2.Append("'" + model.Introduce + "',"); } if (model.CommodityTime != null) { strSql1.Append("CommodityTime,"); strSql2.Append("'" + model.CommodityTime + "',"); } if (model.Recommend != null) { strSql1.Append("Recommend,"); strSql2.Append("'" + model.Recommend + "',"); } if (model.CommodityState != null) { strSql1.Append("CommodityState,"); strSql2.Append("'" + model.CommodityState + "',"); } if (model.Score != null) { strSql1.Append("Score,"); strSql2.Append("'" + model.Score + "',"); } if (model.ScoreTimes != null) { strSql1.Append("ScoreTimes,"); strSql2.Append("'" + model.ScoreTimes + "',"); } strSql.Append("insert into Commodity("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); int rows = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Commodity DataRowToModel(DataRow row) { Maticsoft.Model.Commodity model = new Maticsoft.Model.Commodity(); if (row != null) { if (row["CommodityID"] != null) { model.CommodityID = row["CommodityID"].ToString(); } if (row["CommodityFatherID"] != null) { model.CommodityFatherID = row["CommodityFatherID"].ToString(); } if (row["CommoditySonID"] != null) { model.CommoditySonID = row["CommoditySonID"].ToString(); } if (row["CommodityName"] != null) { model.CommodityName = row["CommodityName"].ToString(); } if (row["CommodityPrice"] != null) { model.CommodityPrice = row["CommodityPrice"].ToString(); } if (row["MarketPrice"] != null && row["MarketPrice"].ToString() != "") { model.MarketPrice = decimal.Parse(row["MarketPrice"].ToString()); } if (row["VIPPrice"] != null && row["VIPPrice"].ToString() != "") { model.VIPPrice = decimal.Parse(row["VIPPrice"].ToString()); } if (row["Stock"] != null && row["Stock"].ToString() != "") { model.Stock = int.Parse(row["Stock"].ToString()); } if (row["BuyScore"] != null) { model.BuyScore = row["BuyScore"].ToString(); } if (row["CommodityImage"] != null) { model.CommodityImage = row["CommodityImage"].ToString(); } if (row["CommodityType"] != null) { model.CommodityType = row["CommodityType"].ToString(); } if (row["CommoditySaled"] != null && row["CommoditySaled"].ToString() != "") { model.CommoditySaled = int.Parse(row["CommoditySaled"].ToString()); } if (row["Introduce"] != null) { model.Introduce = row["Introduce"].ToString(); } if (row["CommodityTime"] != null && row["CommodityTime"].ToString() != "") { model.CommodityTime = DateTime.Parse(row["CommodityTime"].ToString()); } if (row["Recommend"] != null) { model.Recommend = row["Recommend"].ToString(); } if (row["CommodityState"] != null) { model.CommodityState = row["CommodityState"].ToString(); } if (row["Score"] != null) { model.Score = row["Score"].ToString(); } if (row["ScoreTimes"] != null) { model.ScoreTimes = row["ScoreTimes"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Commodity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Commodity set "); if (model.CommodityFatherID != null) { strSql.Append("CommodityFatherID='" + model.CommodityFatherID + "',"); } else { strSql.Append("CommodityFatherID= null ,"); } if (model.CommoditySonID != null) { strSql.Append("CommoditySonID='" + model.CommoditySonID + "',"); } else { strSql.Append("CommoditySonID= null ,"); } if (model.CommodityName != null) { strSql.Append("CommodityName='" + model.CommodityName + "',"); } else { strSql.Append("CommodityName= null ,"); } if (model.CommodityPrice != null) { strSql.Append("CommodityPrice='" + model.CommodityPrice + "',"); } else { strSql.Append("CommodityPrice= null ,"); } if (model.MarketPrice != null) { strSql.Append("MarketPrice=" + model.MarketPrice + ","); } else { strSql.Append("MarketPrice= null ,"); } if (model.VIPPrice != null) { strSql.Append("VIPPrice=" + model.VIPPrice + ","); } else { strSql.Append("VIPPrice= null ,"); } if (model.Stock != null) { strSql.Append("Stock=" + model.Stock + ","); } else { strSql.Append("Stock= null ,"); } if (model.BuyScore != null) { strSql.Append("BuyScore='" + model.BuyScore + "',"); } else { strSql.Append("BuyScore= null ,"); } if (model.CommodityImage != null) { strSql.Append("CommodityImage='" + model.CommodityImage + "',"); } else { strSql.Append("CommodityImage= null ,"); } if (model.CommodityType != null) { strSql.Append("CommodityType='" + model.CommodityType + "',"); } else { strSql.Append("CommodityType= null ,"); } if (model.CommoditySaled != null) { strSql.Append("CommoditySaled=" + model.CommoditySaled + ","); } else { strSql.Append("CommoditySaled= null ,"); } if (model.Introduce != null) { strSql.Append("Introduce='" + model.Introduce + "',"); } else { strSql.Append("Introduce= null ,"); } if (model.CommodityTime != null) { strSql.Append("CommodityTime='" + model.CommodityTime + "',"); } else { strSql.Append("CommodityTime= null ,"); } if (model.Recommend != null) { strSql.Append("Recommend='" + model.Recommend + "',"); } else { strSql.Append("Recommend= null ,"); } if (model.CommodityState != null) { strSql.Append("CommodityState='" + model.CommodityState + "',"); } else { strSql.Append("CommodityState= null ,"); } if (model.Score != null) { strSql.Append("Score='" + model.Score + "',"); } else { strSql.Append("Score= null ,"); } if (model.ScoreTimes != null) { strSql.Append("ScoreTimes='" + model.ScoreTimes + "',"); } else { strSql.Append("ScoreTimes= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where CommodityID='" + model.CommodityID + "' "); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
protected void Button1_Click(object sender, EventArgs e) { //if (UsersInfo.UserID == "") //{ // Response.Write("<script> alert('请先登录!'); window.location.href='../Login.aspx' </script>"); // return; //} decimal discount; Commodity_Mol = Commodity_Bll.GetModel(Request.QueryString["ID"].ToString()); if (UsersInfo.UserID == "") { discount = Convert.ToDecimal(1); ShoppingItem ShoppingItem = new ShoppingItem(); if (ShoppingCar.ShoppingList.Where(x => x.CommodityID == Request.QueryString["ID"].ToString()).Count() > 0) //判断是否购买商品 { ShoppingItem = ShoppingCar.ShoppingList.Where(x => x.CommodityID == Request.QueryString["ID"].ToString()).SingleOrDefault(); //获取ID if (Commoditynum.Text == "") { RadAjaxManager1.Alert("请输入数量!"); return; } int goodsnum = ShoppingItem.OrderNumber + Convert.ToInt32(Commoditynum.Text);//数量 if (goodsnum > Commodity_Mol.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } ShoppingItem.CommodityID = Request.QueryString["ID"].ToString(); //商品ID ShoppingItem.CommodityImage = Commodity_Mol.CommodityImage; //商品图片 ShoppingItem.CommodityName = Commodity_Mol.CommodityName; //商品名称 ShoppingItem.VIPPrice = Convert.ToDecimal(Commodity_Mol.VIPPrice); //商品会员价 ShoppingItem.Subtotal = goodsnum * Convert.ToDecimal(Commodity_Mol.VIPPrice) * discount; //商品小计 //ShoppingCar.ShoppingList.Remove(ShoppingCar.ShoppingList.Where(x => x.CommodityID == Request.QueryString["ID"].ToString()).SingleOrDefault());//移除 //ShoppingCar.ShoppingList.Add(ShoppingItem); RadAjaxManager1.Alert("已加入购物车!"); } else { discount = Convert.ToDecimal(1); ShoppingItem.ShoppingCartID = DateTime.Now.ToString("yyyyMMddHHmmssms");//购物车ID if (Commoditynum.Text == "") { RadAjaxManager1.Alert("请输入数量!"); return; } ShoppingItem.OrderNumber = Convert.ToInt32(Commoditynum.Text);//购物车数量 if (ShoppingItem.OrderNumber > Commodity_Mol.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } ShoppingItem.CommodityID = Request.QueryString["ID"].ToString(); //商品ID ShoppingItem.CommodityImage = Commodity_Mol.CommodityImage; //商品图片 ShoppingItem.CommodityName = Commodity_Mol.CommodityName; //商品名称 ShoppingItem.VIPPrice = Convert.ToDecimal(Commodity_Mol.VIPPrice); //商品会员价 ShoppingItem.Subtotal = Convert.ToDecimal(Commoditynum.Text) * Convert.ToDecimal(Commodity_Mol.VIPPrice) * discount; //商品小计 ShoppingCar.ShoppingList.Add(ShoppingItem); //添加 RadAjaxManager1.Alert("添加成功!"); return; } } else { Maticsoft.Model.Users modelusers = Users_Bll.GetModel(UsersInfo.UserID); decimal discount1; if (modelusers.UserGrade == "VIP") { discount1 = Convert.ToDecimal(0.95); } else { discount1 = Convert.ToDecimal(1); } if (num > Convert.ToInt32(Label7.Text)) { RadAjaxManager1.Alert("数量不能超过库存!"); return; } if (ShoppingCart_Bll.GetRecordCount(" CommodityID='" + Request.QueryString["ID"] + "' and UserID='" + UsersInfo.UserID + "' ") > 0) { Maticsoft.Model.Commodity modelCommodity = Commodity_Bll.GetModel(Request.QueryString["ID"].ToString()); Maticsoft.Model.ShoppingCart modelShoppingCart = ShoppingCart_Bll.GetModel(Request.QueryString["ID"].ToString()); string id = ShoppingCart_Bll.GetList(" CommodityID='" + Request.QueryString["ID"] + "' and UserID='" + UsersInfo.UserID + "' ").Tables[0].Rows[0]["ShoppingCartID"].ToString(); ShoppingCart_Mol = ShoppingCart_Bll.GetModel(id); ShoppingCart_Mol.ShoppingCartID = ShoppingCart_Mol.ShoppingCartID; ShoppingCart_Mol.UserID = UsersInfo.UserID; ShoppingCart_Mol.CommodityID = modelCommodity.CommodityID; if (Commoditynum.Text == "") { RadAjaxManager1.Alert("请输入数量!"); return; } ShoppingCart_Mol.OrderNumber = Convert.ToInt32(Commoditynum.Text) + ShoppingCart_Mol.OrderNumber; if (ShoppingCart_Mol.OrderNumber > modelCommodity.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } ShoppingCart_Mol.Subtotal = (ShoppingCart_Mol.OrderNumber * Convert.ToInt32(modelCommodity.VIPPrice) * discount1).ToString();//商品小计 ShoppingCart_Bll.Update(ShoppingCart_Mol); } else { Maticsoft.Model.Commodity modelCommodity = Commodity_Bll.GetModel(Request.QueryString["ID"].ToString()); ShoppingCart_Mol.ShoppingCartID = DateTime.Now.ToString("yyyyMMddhhmmss"); ShoppingCart_Mol.UserID = UsersInfo.UserID; ShoppingCart_Mol.CommodityID = Request.QueryString["ID"]; ShoppingCart_Mol.OrderNumber = Convert.ToInt32(Commoditynum.Text); ShoppingCart_Mol.Subtotal = (Convert.ToInt32(Commoditynum.Text) * Convert.ToInt32(modelCommodity.VIPPrice) * discount1).ToString();//商品小计 ShoppingCart_Mol.OrderNumber = Convert.ToInt32(Commoditynum.Text); if (ShoppingCart_Mol.OrderNumber > modelCommodity.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } ShoppingCart_Bll.Add(ShoppingCart_Mol); } RadAjaxManager1.Alert("已添加到购物车!"); } }
protected void RadListView1_ItemCommand(object sender, Telerik.Web.UI.RadListViewCommandEventArgs e) { string ShoppingCartID1; ShoppingCartID1 = e.CommandArgument.ToString(); Telerik.Web.UI.RadNumericTextBox Commoditynum = e.ListViewItem.FindControl("Commoditynum") as Telerik.Web.UI.RadNumericTextBox; Maticsoft.Model.ShoppingCart modelShoppingCart = ShoppingCart_Bll.GetModel(ShoppingCartID1); Maticsoft.Model.Users modelUsers = Users_Bll.GetModel(UsersInfo.UserID); if (e.CommandName == "Delete") { if (UsersInfo.UserID != "") { ShoppingCart_Bll.DeleteList(e.CommandArgument.ToString()); RadListView1.Rebind();//删除 if (ShoppingCart_Bll.GetRecordCount3("a.CommodityID = b.CommodityID and a.UserID='" + UsersInfo.UserID + "'") == 0) { content_buy.Visible = false; } } else { string id = e.CommandArgument.ToString(); ShoppingItem si = new ShoppingItem(); si = ShoppingCar.ShoppingList.Where(x => x.CommodityID == id).SingleOrDefault(); ShoppingCar.ShoppingList.Remove(ShoppingCar.ShoppingList.Where(x => x.ShoppingCartID == id).SingleOrDefault()); ShoppingItem jsnum = new ShoppingItem(); decimal zongji = 0; foreach (var item in ShoppingCar.ShoppingList) { zongji += item.Subtotal; Lbl_totalprice.Text = zongji.ToString(); } hidden(); RadListView1.Rebind();//刷新 } } if (e.CommandName == "Add") { string CommodityID1; CommodityID1 = e.CommandArgument.ToString(); Maticsoft.Model.Commodity modelCommodity = Commodity_Bll.GetModel(CommodityID1); num = Convert.ToInt32(Commoditynum.Text); if (num < Convert.ToInt32(modelCommodity.Stock)) { num++; Commoditynum.Text = num.ToString(); } else { Commoditynum.Text = num.ToString(); } if (UsersInfo.UserID != "") { string CommodityID2; CommodityID2 = e.CommandArgument.ToString(); string ShoppingCartID2 = ShoppingCart_Bll.GetList(" CommodityID='" + CommodityID2 + "' and UserID='" + UsersInfo.UserID + "' ").Tables[0].Rows[0]["ShoppingCartID"].ToString(); Maticsoft.Model.Commodity modelCommodity2 = Commodity_Bll.GetModel(CommodityID2); modelCommodity2 = Commodity_Bll.GetModel(CommodityID2); modelUsers = Users_Bll.GetModel(UsersInfo.UserID); decimal discount1; if (modelUsers.UserGrade == "VIP") { discount1 = Convert.ToDecimal(0.95); } else { discount1 = Convert.ToDecimal(1); } modelShoppingCart = ShoppingCart_Bll.GetModel(ShoppingCartID2); //获取id所在行数据 modelShoppingCart.OrderNumber = Convert.ToInt32(Commoditynum.Text); //商品数量 modelShoppingCart.Subtotal = (Convert.ToInt32(Commoditynum.Text) * Convert.ToInt32(modelCommodity2.VIPPrice) * discount1).ToString(); //商品小计 ShoppingCart_Bll.Update(modelShoppingCart); RadListView1.Rebind(); } else { string CommodityID3; CommodityID3 = e.CommandArgument.ToString(); ShoppingItem si = new ShoppingItem(); si = ShoppingCar.ShoppingList.Where(x => x.CommodityID == CommodityID3).First(); Commodity_Mol = Commodity_Bll.GetModel(si.CommodityID); if (si.OrderNumber + 1 <= Commodity_Mol.Stock) { int num1 = si.OrderNumber + 1; si.OrderNumber = num1; Decimal b = num * Convert.ToDecimal(Commodity_Mol.VIPPrice) * 1; si.Subtotal = b; ShoppingCar.ShoppingList.Remove(ShoppingCar.ShoppingList.Where(x => x.CommodityID == CommodityID3).SingleOrDefault()); ShoppingCar.ShoppingList.Add(si); ShoppingItem jsnum = new ShoppingItem(); decimal zongji = 0; foreach (var item in ShoppingCar.ShoppingList) { zongji += item.Subtotal; Lbl_totalprice.Text = zongji.ToString(); } RadListView1.Rebind(); } else { RadAjaxManager1.Alert("已经最大了"); } } } if (e.CommandName == "Jian") { num = Convert.ToInt32(Commoditynum.Text); if (num <= 0) { num = 1; } else { num--; } Commoditynum.Text = num.ToString(); if (UsersInfo.UserID != "") { string CommodityID2; CommodityID2 = e.CommandArgument.ToString(); string ShoppingCartID2 = ShoppingCart_Bll.GetList(" CommodityID='" + CommodityID2 + "' and UserID='" + UsersInfo.UserID + "' ").Tables[0].Rows[0]["ShoppingCartID"].ToString(); Maticsoft.Model.Commodity modelCommodity2 = Commodity_Bll.GetModel(CommodityID2); modelCommodity2 = Commodity_Bll.GetModel(CommodityID2); modelUsers = Users_Bll.GetModel(UsersInfo.UserID); decimal discount1; if (modelUsers.UserGrade == "VIP") { discount1 = Convert.ToDecimal(0.95); } else { discount1 = Convert.ToDecimal(1); } modelShoppingCart = ShoppingCart_Bll.GetModel(ShoppingCartID2); //获取id所在行数据 modelShoppingCart.OrderNumber = Convert.ToInt32(Commoditynum.Text); //商品数量 modelShoppingCart.Subtotal = (Convert.ToInt32(Commoditynum.Text) * Convert.ToInt32(modelCommodity2.VIPPrice) * discount1).ToString(); //商品小计 ShoppingCart_Bll.Update(modelShoppingCart); RadListView1.Rebind(); } else { string id = e.CommandArgument.ToString(); ShoppingItem si = new ShoppingItem(); si = ShoppingCar.ShoppingList.Where(x => x.CommodityID == id).First(); if (si.OrderNumber > 1) { int num1 = si.OrderNumber - 1; si.OrderNumber = num1; Commodity_Mol = Commodity_Bll.GetModel(si.CommodityID); Decimal b = num * Convert.ToDecimal(Commodity_Mol.VIPPrice) * 1; si.Subtotal = b; ShoppingCar.ShoppingList.Remove(ShoppingCar.ShoppingList.Where(x => x.CommodityID == id).SingleOrDefault()); ShoppingCar.ShoppingList.Add(si); ShoppingItem jsnum = new ShoppingItem(); decimal zongji = 0; foreach (var item in ShoppingCar.ShoppingList) { zongji += item.Subtotal; Lbl_totalprice.Text = zongji.ToString(); } RadListView1.Rebind(); } else { RadAjaxManager1.Alert("已经最小了"); } } } }
protected void Button1_Click(object sender, EventArgs e) { string username = "******"; Regex rxusername = new Regex(username); Label1.Text = ""; Label2.Text = ""; Label3.Text = ""; if (RadTextBox1.Text == "") { Label1.Text = "账户不能为空"; Label1.Visible = true; return; } if (RadTextBox3.Text == "") { Label2.Text = "密码不能为空"; Label2.Visible = true; return; } if (RadTextBox2.Text == "") { Label3.Text = "验证码不能为空"; Label3.Visible = true; return; } if (!rxusername.IsMatch(RadTextBox1.Text)) { Label1.Text = "账户格式错误"; Label1.Visible = true; return; } if (User_Bll.GetRecordCount(" Username='******' ") == 0) { Label1.Text = "该账户不存在"; Label1.Visible = true; return; } if (!rxusername.IsMatch(RadTextBox3.Text)) { Label1.Text = "密码格式错误"; Label1.Visible = true; return; } if (User_Bll.GetRecordCount(" Username='******' and UserPassword='******'") == 0) { Label2.Text = "密码错误"; Label2.Visible = true; return; } if (Session["CheckCode"].ToString().ToLower() != RadTextBox2.Text.ToLower()) { Label3.Text = "验证码错误"; Label3.Visible = true; return; } DataSet ds = User_Bll.GetList(" Username='******' "); UsersInfo.UserID = ds.Tables[0].Rows[0]["UserID"].ToString(); UsersInfo.UserRole = ds.Tables[0].Rows[0]["UserIdentity"].ToString(); UsersInfo.UserName = ds.Tables[0].Rows[0]["Username"].ToString(); if (ds.Tables[0].Rows[0]["UserIdentity"].ToString() == "管理员") { RadAjaxManager1.Alert("该账户无效!"); RadTextBox1.Text = ""; RadTextBox2.Text = ""; RadTextBox3.Text = ""; return; } if (ShoppingCar.ShoppingList.Count != 0) { Users_Mol = User_Bll.GetModel(UsersInfo.UserID); decimal discount1; if (Users_Mol.UserGrade == "VIP") { discount1 = Convert.ToDecimal(0.95); } else { discount1 = Convert.ToDecimal(1); } if (ShoppingCar.ShoppingList.Count != 0) //泛型中有数据 { int i = 0; foreach (var item in ShoppingCar.ShoppingList) { Commodity_Mol = Commodity_Bll.GetModel(item.CommodityID); if (ShoppingCart_Bll.GetRecordCount(" UserID ='" + UsersInfo.UserID + "' and CommodityID ='" + item.CommodityID + "' ") != 0) { string basketid = ShoppingCart_Bll.GetList(" UserID ='" + UsersInfo.UserID + "' and CommodityID ='" + item.CommodityID + "' ").Tables[0].Rows[0]["ShoppingCartID"].ToString(); ShoppingCart_Mol = ShoppingCart_Bll.GetModel(basketid); ShoppingCart_Mol.OrderNumber = ShoppingCart_Mol.OrderNumber + item.OrderNumber; if (ShoppingCart_Mol.OrderNumber > Commodity_Mol.Stock) { ShoppingCart_Mol.OrderNumber = Commodity_Mol.Stock; } ShoppingCart_Mol.Subtotal = (Convert.ToDecimal(ShoppingCart_Mol.OrderNumber) * Convert.ToDecimal(item.VIPPrice) * discount1).ToString("F2"); ShoppingCart_Bll.Update(ShoppingCart_Mol); } else { ShoppingCart_Mol.ShoppingCartID = DateTime.Now.ToString("yyyyMMddHHmmss") + i.ToString(); i++; ShoppingCart_Mol.UserID = UsersInfo.UserID; ShoppingCart_Mol.CommodityID = item.CommodityID; ShoppingCart_Mol.OrderNumber = item.OrderNumber; if (ShoppingCart_Mol.OrderNumber > Commodity_Mol.Stock) { ShoppingCart_Mol.OrderNumber = Commodity_Mol.Stock; } ShoppingCart_Mol.Subtotal = (item.Subtotal * discount1).ToString("F2"); ShoppingCart_Bll.Add(ShoppingCart_Mol); } } ShoppingCar.ShoppingList.Clear(); } } Response.Redirect("HomePage.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { Maticsoft.Model.Commodity modelgoods = Commodity_Bll.GetModel(Session["GoodsID"].ToString()); string name = "^[a-zA-Z0-9\u4e00-\u9fa5]{1,}$";//字母数字汉字 Regex rxname = new Regex(name); if (RadTextBox1.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入商品名称!"); return; } else if (!rxname.IsMatch(RadTextBox1.Text)) { RadAjaxManager1.Alert("不能输入特殊字符!"); return; } else if (RadTextBox2.Text == "") { RadAjaxManager1.Alert("请输入商品品牌!"); return; } else if (!rxname.IsMatch(RadTextBox2.Text)) { RadAjaxManager1.Alert("不能输入特殊字符!"); return; } else if (imgPic.ImageUrl == "") //判断是否为空 { RadAjaxManager1.Alert("请插入图片!"); return; } if (RadNumericTextBox1.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入市场价!"); return; } else if (RadNumericTextBox2.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入会员价!"); return; } else if (RadDropDownListFather.SelectedItem.Text == "请选择") { RadAjaxManager1.Alert("请输入父类别!"); return; } else if (RadDropDownListSon.SelectedItem.Text == "请选择") { RadAjaxManager1.Alert("请输入子类别!"); return; } else if (RadNumericTextBox3.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入购买积分!"); return; } else if (RadNumericTextBox4.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入库存!"); return; } else if (myEditor.Value == "")//判断是否为空 { RadAjaxManager1.Alert("请输入简介!"); return; } else { Commodity_Mol = Commodity_Bll.GetModel(Request.QueryString["ID"].ToString()); Commodity_Mol.CommodityName = RadTextBox1.Text; Commodity_Mol.CommodityType = RadTextBox2.Text; Commodity_Mol.CommodityImage = imgPic.ImageUrl; Commodity_Mol.MarketPrice = Convert.ToDecimal(RadNumericTextBox1.Text); Commodity_Mol.VIPPrice = Convert.ToDecimal(RadNumericTextBox2.Text); Commodity_Mol.CommodityFatherID = RadDropDownListFather.SelectedValue; Commodity_Mol.CommoditySonID = RadDropDownListSon.SelectedValue; Commodity_Mol.BuyScore = RadNumericTextBox3.Text; Commodity_Mol.Stock = Convert.ToInt32(RadNumericTextBox4.Text); Commodity_Mol.Introduce = myEditor.Value; Commodity_Mol.CommodityTime = Convert.ToDateTime(DateTime.Now.ToString()); if (RadioButton1.Checked == true) { Commodity_Mol.Recommend = "推荐"; } if (RadioButton4.Checked == true) { Commodity_Mol.Recommend = "不推荐"; } if (RadioButton2.Checked == true && Convert.ToInt32(RadNumericTextBox4.Text) > 0)//状态为上架 { Commodity_Mol.CommodityState = "上架"; } if (RadioButton2.Checked == true && Convert.ToInt32(RadNumericTextBox4.Text) <= 0) { RadAjaxManager1.Alert("库存为零,无法上架!"); return; } if (RadioButton3.Checked == true) { Commodity_Mol.CommodityState = "下架"; } if (RadioButton1.Checked == true && Commodity_Bll.GetList(" Recommend ='推荐' ").Tables[0].Rows.Count >= 10) { RadAjaxManager1.Alert("推荐商品已满10个,不能添加!"); } else { Commodity_Bll.Update(Commodity_Mol); Response.Write("<script>alert('修改成功!');window.location.href='Backspxxgl.aspx'</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (UsersInfo.UserID == "") { Response.Write("<script> alert('请先登录!'); window.location.href='/BackLogin.aspx' </script>"); return; } if (!IsPostBack) { if (Request.QueryString["ID"] != null) { Session["GoodsID"] = Request.QueryString["ID"].ToString(); Maticsoft.Model.Commodity modelgoods = Commodity_Bll.GetModel(Session["GoodsID"].ToString()); if (modelgoods == null) { Response.Write("<script>window.location.href='Backspxxgl.aspx'</script>"); } RadTextBox1.Text = modelgoods.CommodityName; RadTextBox2.Text = modelgoods.CommodityType; imgPic.ImageUrl = modelgoods.CommodityImage; RadNumericTextBox1.Text = modelgoods.MarketPrice.ToString(); RadNumericTextBox2.Text = modelgoods.VIPPrice.ToString(); RadNumericTextBox3.Text = modelgoods.BuyScore; RadNumericTextBox4.Text = modelgoods.Stock.ToString(); if (modelgoods.Recommend == "推荐") { RadioButton1.Checked = true; } if (modelgoods.Recommend == "不推荐") { RadioButton4.Checked = true; } if (modelgoods.CommodityState == "上架") { RadioButton2.Checked = true; } if (modelgoods.CommodityState == "下架") { RadioButton3.Checked = true; } myEditor.Value = modelgoods.Introduce; RadDropDownListFather.Items.Clear(); RadDropDownListSon.Items.Clear(); RadDropDownListFather.Items.Add(new DropDownListItem("请选择", "")); RadDropDownListSon.Items.Add(new DropDownListItem("请选择", "")); RadDropDownListFather.DataSource = CommodityFather_BLL.GetList(""); RadDropDownListFather.DataTextField = "CommodityFatherName"; RadDropDownListFather.DataValueField = "CommodityFatherID"; RadDropDownListFather.DataBind(); RadDropDownListFather.SelectedValue = modelgoods.CommodityFatherID; RadDropDownListSon.DataSource = CommoditySon_Bll.GetList(" CommodityFatherID ='" + RadDropDownListFather.SelectedValue + "' "); RadDropDownListSon.DataTextField = "CommoditySonName"; RadDropDownListSon.DataValueField = "CommoditySonID"; RadDropDownListSon.DataBind(); RadDropDownListSon.SelectedValue = modelgoods.CommoditySonID; } else { Response.Write("<script>window.location.href='Backspxxgl.aspx'</script>"); } } }
protected void RadLV_splb_ItemCommand(object sender, Telerik.Web.UI.RadListViewCommandEventArgs e) { if (e.CommandName == "buy") { string CommodityID1; CommodityID1 = e.CommandArgument.ToString(); decimal discount1 = Convert.ToDecimal(1); Maticsoft.Model.Users modelusers = Users_Bll.GetModel(UsersInfo.UserID); Maticsoft.Model.Commodity Commoditymol = Commodity_Bll.GetModel(CommodityID1); if (UsersInfo.UserID == "") { ShoppingItem ShoppingItem = new ShoppingItem(); if (ShoppingCar.ShoppingList.Where(x => x.CommodityID == CommodityID1).Count() > 0) //判断是否购买商品 { ShoppingItem = ShoppingCar.ShoppingList.Where(x => x.CommodityID == CommodityID1).SingleOrDefault(); //获取ID ShoppingItem.CommodityID = CommodityID1; //商品ID ShoppingItem.CommodityImage = Commoditymol.CommodityImage; //商品图片 ShoppingItem.CommodityName = Commoditymol.CommodityName; //商品名称 ShoppingItem.VIPPrice = Convert.ToDecimal(Commoditymol.VIPPrice); //商品会员价 ShoppingItem.OrderNumber = ShoppingItem.OrderNumber + 1; //数量 if (ShoppingItem.OrderNumber > Commoditymol.Stock) { ShoppingItem.OrderNumber = Convert.ToInt32(Commoditymol.Stock); RadAjaxManager1.Alert("库存不足!"); return; } ShoppingItem.Subtotal = ShoppingItem.OrderNumber * Convert.ToDecimal(Commoditymol.VIPPrice) * discount1; //商品小计 ShoppingCar.ShoppingList.Remove(ShoppingCar.ShoppingList.Where(x => x.CommodityID == CommodityID1).SingleOrDefault()); //移除 ShoppingCar.ShoppingList.Add(ShoppingItem); RadAjaxManager1.Alert("已加入购物车!"); } else { ShoppingItem.ShoppingCartID = DateTime.Now.ToString("yyyyMMddHHmmssms"); //购物车ID ShoppingItem.CommodityID = CommodityID1; //商品ID ShoppingItem.CommodityImage = Commoditymol.CommodityImage; //商品图片 ShoppingItem.CommodityName = Commoditymol.CommodityName; //商品名称 ShoppingItem.VIPPrice = Convert.ToDecimal(Commoditymol.VIPPrice); //商品会员价 ShoppingItem.OrderNumber = 1; //商品数量 if (ShoppingItem.OrderNumber > Commoditymol.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } ShoppingItem.Subtotal = Convert.ToDecimal(Commoditymol.VIPPrice) * discount1; //商品小计 ShoppingCar.ShoppingList.Add(ShoppingItem); //添加 RadAjaxManager1.Alert("添加成功!"); return; } } else if (ShoppingCart_Bll.GetRecordCount(" CommodityID='" + CommodityID1 + "' and UserID='" + UsersInfo.UserID + "' ") > 0) { if (modelusers.UserGrade == "VIP") { discount1 = Convert.ToDecimal(0.95); } else { discount1 = Convert.ToDecimal(1); } Maticsoft.Model.Commodity modelCommodity = Commodity_Bll.GetModel(CommodityID1); string id = ShoppingCart_Bll.GetList(" CommodityID='" + CommodityID1 + "' and UserID='" + UsersInfo.UserID + "' ").Tables[0].Rows[0]["ShoppingCartID"].ToString(); ShoppingCart_Mol = ShoppingCart_Bll.GetModel(id); ShoppingCart_Mol.ShoppingCartID = ShoppingCart_Mol.ShoppingCartID; ShoppingCart_Mol.UserID = UsersInfo.UserID; ShoppingCart_Mol.CommodityID = modelCommodity.CommodityID; ShoppingCart_Mol.OrderNumber = ShoppingCart_Mol.OrderNumber + 1; ShoppingCart_Mol.Subtotal = (Convert.ToInt32(modelCommodity.VIPPrice) * discount1).ToString();//商品小计 if (ShoppingCart_Mol.OrderNumber > modelCommodity.Stock) { Response.Write("<script>alert('库存不足!')</script>"); return; } ShoppingCart_Bll.Update(ShoppingCart_Mol); Response.Write("<script>alert('已添加到购物车!')</script>"); } else { Maticsoft.Model.Commodity modelCommodity = Commodity_Bll.GetModel(CommodityID1); ShoppingCart_Mol.ShoppingCartID = DateTime.Now.ToString("yyyyMMddhhmmss"); ShoppingCart_Mol.UserID = UsersInfo.UserID; ShoppingCart_Mol.CommodityID = e.CommandArgument.ToString(); ShoppingCart_Mol.OrderNumber = 1; ShoppingCart_Mol.Subtotal = (1 * Convert.ToInt32(modelCommodity.VIPPrice) * discount1).ToString();//商品小计 ShoppingCart_Bll.Add(ShoppingCart_Mol); Response.Write("<script>alert('已添加到购物车!')</script>"); } } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtCommodityID.Text.Trim().Length == 0) { strErr += "CommodityID不能为空!\\n"; } if (this.txtCommodityFatherID.Text.Trim().Length == 0) { strErr += "CommodityFatherID不能为空!\\n"; } if (this.txtCommoditySonID.Text.Trim().Length == 0) { strErr += "CommoditySonID不能为空!\\n"; } if (this.txtCommodityName.Text.Trim().Length == 0) { strErr += "CommodityName不能为空!\\n"; } if (this.txtCommodityPrice.Text.Trim().Length == 0) { strErr += "CommodityPrice不能为空!\\n"; } if (!PageValidate.IsDecimal(txtMarketPrice.Text)) { strErr += "MarketPrice格式错误!\\n"; } if (!PageValidate.IsDecimal(txtVIPPrice.Text)) { strErr += "VIPPrice格式错误!\\n"; } if (!PageValidate.IsNumber(txtStock.Text)) { strErr += "Stock格式错误!\\n"; } if (this.txtBuyScore.Text.Trim().Length == 0) { strErr += "BuyScore不能为空!\\n"; } if (this.txtCommodityImage.Text.Trim().Length == 0) { strErr += "CommodityImage不能为空!\\n"; } if (this.txtCommodityType.Text.Trim().Length == 0) { strErr += "CommodityType不能为空!\\n"; } if (!PageValidate.IsNumber(txtCommoditySaled.Text)) { strErr += "CommoditySaled格式错误!\\n"; } if (this.txtIntroduce.Text.Trim().Length == 0) { strErr += "Introduce不能为空!\\n"; } if (!PageValidate.IsDateTime(txtCommodityTime.Text)) { strErr += "CommodityTime格式错误!\\n"; } if (this.txtRecommend.Text.Trim().Length == 0) { strErr += "Recommend不能为空!\\n"; } if (this.txtCommodityState.Text.Trim().Length == 0) { strErr += "CommodityState不能为空!\\n"; } if (this.txtScore.Text.Trim().Length == 0) { strErr += "Score不能为空!\\n"; } if (this.txtScoreTimes.Text.Trim().Length == 0) { strErr += "ScoreTimes不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string CommodityID = this.txtCommodityID.Text; string CommodityFatherID = this.txtCommodityFatherID.Text; string CommoditySonID = this.txtCommoditySonID.Text; string CommodityName = this.txtCommodityName.Text; string CommodityPrice = this.txtCommodityPrice.Text; decimal MarketPrice = decimal.Parse(this.txtMarketPrice.Text); decimal VIPPrice = decimal.Parse(this.txtVIPPrice.Text); int Stock = int.Parse(this.txtStock.Text); string BuyScore = this.txtBuyScore.Text; string CommodityImage = this.txtCommodityImage.Text; string CommodityType = this.txtCommodityType.Text; int CommoditySaled = int.Parse(this.txtCommoditySaled.Text); string Introduce = this.txtIntroduce.Text; DateTime CommodityTime = DateTime.Parse(this.txtCommodityTime.Text); string Recommend = this.txtRecommend.Text; string CommodityState = this.txtCommodityState.Text; string Score = this.txtScore.Text; string ScoreTimes = this.txtScoreTimes.Text; Maticsoft.Model.Commodity model = new Maticsoft.Model.Commodity(); model.CommodityID = CommodityID; model.CommodityFatherID = CommodityFatherID; model.CommoditySonID = CommoditySonID; model.CommodityName = CommodityName; model.CommodityPrice = CommodityPrice; model.MarketPrice = MarketPrice; model.VIPPrice = VIPPrice; model.Stock = Stock; model.BuyScore = BuyScore; model.CommodityImage = CommodityImage; model.CommodityType = CommodityType; model.CommoditySaled = CommoditySaled; model.Introduce = Introduce; model.CommodityTime = CommodityTime; model.Recommend = Recommend; model.CommodityState = CommodityState; model.Score = Score; model.ScoreTimes = ScoreTimes; Maticsoft.BLL.Commodity bll = new Maticsoft.BLL.Commodity(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
protected void Linkbtn_buyall_word_Click(object sender, EventArgs e) { Maticsoft.Model.Users modelUsers = Users_Bll.GetModel(UsersInfo.UserID); Maticsoft.Model.Orders modelOrders = new Maticsoft.Model.Orders(); Maticsoft.Model.OrderDetail modelOrderDetail = new Maticsoft.Model.OrderDetail(); if (UsersInfo.UserID != "") { DataSet dsbasket = new DataSet(); dsbasket = ShoppingCart_Bll.GetList(" UserID ='" + UsersInfo.UserID + "' "); foreach (DataRow drbasket in dsbasket.Tables[0].Rows) { Commodity_Mol = Commodity_Bll.GetModel(drbasket["CommodityID"].ToString()); if (Convert.ToInt32(drbasket["OrderNumber"]) >= Commodity_Mol.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } } if (modelUsers.UserRealName == "" && modelUsers.Address1 == "") { Response.Write("<script> alert('请完善个人信息!'); window.location.href='ForeVIP.aspx' </script>"); } else { modelOrders.OrderID = DateTime.Now.ToString("yyyyMMddHHmmss"); //订单号 modelOrders.UserID = UsersInfo.UserID; //用户ID modelOrders.OrderDate = DateTime.Now; //下单时间 modelOrders.OrderState = "待付款"; modelOrders.TotalMoney = Convert.ToDecimal(Lbl_totalprice.Text); //总金额 modelOrders.AddresseeName = modelUsers.UserRealName; modelOrders.AddresseePhone = modelUsers.Phone; modelOrders.AddresseeAddress = modelUsers.Province + modelUsers.City + modelUsers.Address1; Orders_Bll.Add(modelOrders); //订单表 DataSet ds = new DataSet(); ds = ShoppingCart_Bll.GetList(" UserID='" + UsersInfo.UserID + "' "); string id = DateTime.Now.ToString("yyyyMMddHHmmss"); int i = 0; foreach (DataRow dr in ds.Tables[0].Rows) { i++; modelOrderDetail.OrderDetailID = id + i.ToString(); modelOrderDetail.OrderID = modelOrders.OrderID; modelOrderDetail.UserID = UsersInfo.UserID; modelOrderDetail.CommodityID = dr["CommodityID"].ToString(); modelOrderDetail.OrderNumber = Convert.ToInt32(dr["OrderNumber"]); modelOrderDetail.Subtotal = dr["Subtotal"].ToString(); OrderDetail_Bll.Add(modelOrderDetail); Commodity_Mol = Commodity_Bll.GetModel(dr["CommodityID"].ToString()); if (ShoppingCart_Mol.OrderNumber > Commodity_Mol.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } Commodity_Mol.Stock = Commodity_Mol.Stock - Convert.ToInt32(dr["OrderNumber"]); if (Commodity_Mol.Stock <= 0) { Commodity_Mol.CommodityState = "下架"; } Commodity_Bll.Update(Commodity_Mol); } ShoppingCart_Bll.DeleteList2(UsersInfo.UserID); hidden(); RadListView1.Rebind(); Response.Write("<script> alert('下单成功!'); window.location.href='ForeOrdersDetail.aspx?OrderID=" + modelOrders.OrderID + "' </script>"); } } else { Response.Write("<script> alert('请先登陆!'); window.location.href='/Login.aspx' </script>"); } }