protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtOrderDetailID.Text.Trim().Length == 0) { strErr += "OrderDetailID不能为空!\\n"; } if (this.txtOrderID.Text.Trim().Length == 0) { strErr += "OrderID不能为空!\\n"; } if (this.txtCommodityID.Text.Trim().Length == 0) { strErr += "CommodityID不能为空!\\n"; } if (this.txtUserID.Text.Trim().Length == 0) { strErr += "UserID不能为空!\\n"; } if (!PageValidate.IsNumber(txtOrderNumber.Text)) { strErr += "OrderNumber格式错误!\\n"; } if (!PageValidate.IsNumber(txtAppraiseGrade.Text)) { strErr += "AppraiseGrade格式错误!\\n"; } if (this.txtSubtotal.Text.Trim().Length == 0) { strErr += "Subtotal不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string OrderDetailID = this.txtOrderDetailID.Text; string OrderID = this.txtOrderID.Text; string CommodityID = this.txtCommodityID.Text; string UserID = this.txtUserID.Text; int OrderNumber = int.Parse(this.txtOrderNumber.Text); int AppraiseGrade = int.Parse(this.txtAppraiseGrade.Text); string Subtotal = this.txtSubtotal.Text; Maticsoft.Model.OrderDetail model = new Maticsoft.Model.OrderDetail(); model.OrderDetailID = OrderDetailID; model.OrderID = OrderID; model.CommodityID = CommodityID; model.UserID = UserID; model.OrderNumber = OrderNumber; model.AppraiseGrade = AppraiseGrade; model.Subtotal = Subtotal; Maticsoft.BLL.OrderDetail bll = new Maticsoft.BLL.OrderDetail(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.OrderDetail model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.OrderDetailID != null) { strSql1.Append("OrderDetailID,"); strSql2.Append("'" + model.OrderDetailID + "',"); } if (model.OrderID != null) { strSql1.Append("OrderID,"); strSql2.Append("'" + model.OrderID + "',"); } if (model.CommodityID != null) { strSql1.Append("CommodityID,"); strSql2.Append("'" + model.CommodityID + "',"); } if (model.UserID != null) { strSql1.Append("UserID,"); strSql2.Append("'" + model.UserID + "',"); } if (model.OrderNumber != null) { strSql1.Append("OrderNumber,"); strSql2.Append("" + model.OrderNumber + ","); } if (model.AppraiseGrade != null) { strSql1.Append("AppraiseGrade,"); strSql2.Append("" + model.AppraiseGrade + ","); } if (model.Subtotal != null) { strSql1.Append("Subtotal,"); strSql2.Append("'" + model.Subtotal + "',"); } strSql.Append("insert into OrderDetail("); 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); } }
private void ShowInfo(string OrderDetailID) { Maticsoft.BLL.OrderDetail bll = new Maticsoft.BLL.OrderDetail(); Maticsoft.Model.OrderDetail model = bll.GetModel(OrderDetailID); this.lblOrderDetailID.Text = model.OrderDetailID; this.lblOrderID.Text = model.OrderID; this.lblCommodityID.Text = model.CommodityID; this.lblUserID.Text = model.UserID; this.lblOrderNumber.Text = model.OrderNumber.ToString(); this.lblAppraiseGrade.Text = model.AppraiseGrade.ToString(); this.lblSubtotal.Text = model.Subtotal; }
protected void Page_Load(object sender, EventArgs e) { Maticsoft.Model.Orders molOrder = Orders_Bll.GetModel(Request.QueryString["OrderID"]); Maticsoft.Model.OrderDetail molOrderDetail = OrderDetail_Bll.GetModel(Request.QueryString["OrderID"]); if (UsersInfo.UserID == "") { Response.Write("<script> alert('请先登录!'); window.location.href='../Login.aspx' </script>"); return; } if (ShoppingCart_Bll.GetRecordCount4("a.CommodityID = b.CommodityID and OrderID='" + Request.QueryString["OrderID"] + "' and a.UserID='" + UsersInfo.UserID + "'") > 2) { RadDataPager1.Visible = true; } else { RadDataPager1.Visible = false; } Lbl_OrderID.Text = molOrder.OrderID; Label1.Text = molOrder.AddresseeName; Label2.Text = molOrder.AddresseeAddress; Label3.Text = molOrder.AddresseeZipCode; Label4.Text = molOrder.AddresseePhone; if (molOrder.Delivery == "") { Label6.Text = "暂未选择送货方式"; } else { Label6.Text = molOrder.Delivery; } if (molOrder.PayType == "") { Label7.Text = "暂未选择支付方式"; } else { Label7.Text = molOrder.PayType; } Label5.Text = OrderDetail_Bll.GetList3("OrderID='" + Request.QueryString["OrderID"] + "'").Tables[0].Rows[0][0].ToString(); Label8.Text = molOrder.TotalMoney.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.OrderDetail GetModel(string OrderDetailID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" OrderDetailID,OrderID,CommodityID,UserID,OrderNumber,AppraiseGrade,Subtotal "); strSql.Append(" from OrderDetail "); strSql.Append(" where OrderDetailID='" + OrderDetailID + "' "); Maticsoft.Model.OrderDetail model = new Maticsoft.Model.OrderDetail(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.OrderDetail DataRowToModel(DataRow row) { Maticsoft.Model.OrderDetail model = new Maticsoft.Model.OrderDetail(); if (row != null) { if (row["OrderDetailID"] != null) { model.OrderDetailID = row["OrderDetailID"].ToString(); } if (row["OrderID"] != null) { model.OrderID = row["OrderID"].ToString(); } if (row["CommodityID"] != null) { model.CommodityID = row["CommodityID"].ToString(); } if (row["UserID"] != null) { model.UserID = row["UserID"].ToString(); } if (row["OrderNumber"] != null && row["OrderNumber"].ToString() != "") { model.OrderNumber = int.Parse(row["OrderNumber"].ToString()); } if (row["AppraiseGrade"] != null && row["AppraiseGrade"].ToString() != "") { model.AppraiseGrade = int.Parse(row["AppraiseGrade"].ToString()); } if (row["Subtotal"] != null) { model.Subtotal = row["Subtotal"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.OrderDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OrderDetail set "); if (model.OrderID != null) { strSql.Append("OrderID='" + model.OrderID + "',"); } else { strSql.Append("OrderID= null ,"); } if (model.CommodityID != null) { strSql.Append("CommodityID='" + model.CommodityID + "',"); } else { strSql.Append("CommodityID= null ,"); } if (model.UserID != null) { strSql.Append("UserID='" + model.UserID + "',"); } else { strSql.Append("UserID= null ,"); } if (model.OrderNumber != null) { strSql.Append("OrderNumber=" + model.OrderNumber + ","); } else { strSql.Append("OrderNumber= null ,"); } if (model.AppraiseGrade != null) { strSql.Append("AppraiseGrade=" + model.AppraiseGrade + ","); } else { strSql.Append("AppraiseGrade= null ,"); } if (model.Subtotal != null) { strSql.Append("Subtotal='" + model.Subtotal + "',"); } else { strSql.Append("Subtotal= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where OrderDetailID='" + model.OrderDetailID + "' "); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
protected void Button2_Click1(object sender, EventArgs e) { if (UsersInfo.UserID == "") { Response.Write("<script> alert('请先登录!'); window.location.href='../Login.aspx' </script>"); return; } if (OrderDetail_Bll.GetRecordCount(" CommodityID='" + Request.QueryString["ID"].ToString() + "' and UserID='" + UsersInfo.UserID + "' ") <= 0) { RadRating1.Visible = false; Button2.Visible = false; } else { try { string OrdersDetailedid = OrderDetail_Bll.GetList(" CommodityID='" + Request.QueryString["ID"].ToString() + "' and UserID='" + UsersInfo.UserID + "'and AppraiseGrade is null ").Tables[0].Rows[0]["OrderDetailID"].ToString(); Maticsoft.Model.OrderDetail molorderdetail = OrderDetail_Bll.GetModel(OrdersDetailedid); } catch (Exception) { Response.Write("<script>alert('已经评过分,请刷新后重试!')</script>"); if (OrderDetail_Bll.GetRecordCount(" CommodityID='" + Request.QueryString["ID"].ToString() + "' and UserID='" + UsersInfo.UserID + "' ") > 0) { RadRating1.Visible = false; Button2.Visible = false; } return; } string OrdersDetailedid1 = OrderDetail_Bll.GetList(" CommodityID='" + Request.QueryString["ID"].ToString() + "' and UserID='" + UsersInfo.UserID + "'and AppraiseGrade is null ").Tables[0].Rows[0]["OrderDetailID"].ToString(); Maticsoft.Model.OrderDetail molorderdetail1 = OrderDetail_Bll.GetModel(OrdersDetailedid1); if (RadRating1.Value == 0) { Response.Write("<script>alert('请评分!')</script>"); return; } if (RadRating1.Value == 1) { molorderdetail1.AppraiseGrade = 40; } if (RadRating1.Value == 2) { molorderdetail1.AppraiseGrade = 60; } if (RadRating1.Value == 3) { molorderdetail1.AppraiseGrade = 80; } if (RadRating1.Value == 4) { molorderdetail1.AppraiseGrade = 100; } OrderDetail_Bll.Update(molorderdetail1); pinfen(); RadAjaxManager1.Alert("评分成功!"); if (OrderDetail_Bll.GetRecordCount(" CommodityID='" + Request.QueryString["ID"].ToString() + "' and UserID='" + UsersInfo.UserID + "' ") > 0) { RadRating1.Visible = false; Button2.Visible = false; } } }
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>"); } }