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>");
}
}
