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