protected void gvAddress_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = (int)e.Keys["Id"];
var queryAddress = from address in eShop.UserShoppingAddress
where address.Id == id
select address;
eShop.UserShoppingAddress.Remove(queryAddress.FirstOrDefault());
eShop.SaveChanges();
UserAddress_DataBind();
}
//确认付款
protected void btnSurePay_Click(object sender, EventArgs e)
{
decimal realPay = Convert.ToDecimal(this.txtPayNumber.Text.ToString());
if (realPay >= Convert.ToDecimal(this.labPriceSum.Text))
{
int orderid = int.Parse(Request.QueryString["id"]);
var queryGoodState = from orderState in eShop.OrderState
where orderState.Id == orderid
select orderState;
OrderState order = queryGoodState.FirstOrDefault();
order.OrderState1 = 1;
order.RealPay = realPay;
order.PayDate = DateTime.Now;
eShop.SaveChanges();
}
}
protected void gvEditGood_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var goodsImg = eShop.GoodsImg.Where(img => img.GoodId == (int)e.Keys["Id"]);
var goodsInfo = eShop.GoodsInfo.Find((int)e.Keys["Id"]);
foreach (GoodsImg img in goodsImg)
{
eShop.GoodsImg.Remove(img);
}
eShop.GoodsInfo.Remove(goodsInfo);
eShop.SaveChanges();
}
protected void gvGoodOrder_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox textBox = this.gvGoodOrder.Rows[e.RowIndex].FindControl("txtCourierNum") as TextBox;
int key = (int)this.gvGoodOrder.DataKeys[e.RowIndex].Value;
if (textBox.Text != null)
{
var orderState = eShop.OrderState.Find(key);
orderState.CourierNum = textBox.Text.Trim();
orderState.SendDate = DateTime.Now;
orderState.OrderState1 = 2;
eShop.SaveChanges();
SellerUnsendOrder_DataBind();
}
}
protected void btnPostOrder_Click(object sender, EventArgs e)
{
if (this.rblUserAddress.SelectedValue != null)
{
//创建订单对象
OrderState order = new OrderState();
order.OrderNum = DateTime.Now.ToString("yyyyMMddhhmmss") + ((Users)Session["User"]).Id;
order.CreateDate = DateTime.Now;
order.OrderState1 = 0;
order.AddressId = int.Parse(this.rblUserAddress.SelectedValue);
//创建商品订单对象
string[] keys = Request.Cookies["ShoppingCart"].Values.AllKeys;
foreach (string item in keys)
{
GoodOrder goodOrder = new GoodOrder()
{
GoodId = int.Parse(item),
GoodsNum = int.Parse(Request.Cookies["ShoppingCart"].Values[item])
};
order.GoodOrder.Add(goodOrder);
}
//添加用户订单
int userid = ((Users)Session["User"]).Id;
var queryAddUserOrder = from user in eShop.Users
where user.Id == userid
select user;
queryAddUserOrder.FirstOrDefault().OrderState.Add(order);
eShop.SaveChanges();
//清除所有购物车cookie
Helper.CookieHelper.RemoveCookie();
//软到支付页面
Response.Redirect("/User/UserPayOrder.aspx?id=" + order.Id);
}
else
{
this.labMessege.Text = "请选择收货地址！";
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
var query = from users in eShop.Users
where users.UserNum.Equals(this.txtUserNum.Text.Trim())
select users.UserNum;
if (query.Count() == 0)
{
Users user = new Users();
user.UserNum = this.txtUserNum.Text.Trim();
string passwdMD5 = pwdMD5.PasswdMD5Locker.MD5Encrypt(this.txtUserPasswd.Text.Trim());
if (pwdMD5.PasswdMD5Locker.MD5Verify(this.txtUserPasswd.Text.Trim(), passwdMD5))
{
user.UserPasswd = passwdMD5;
}
user.UserName = this.txtUserName.Text.Trim();
if (this.radSex.SelectedValue == "1")
{
user.Gender = true;
}
else
{
user.Gender = false;
}
user.Identification = this.txtUserIdentification.Text.Trim();
user.Telephone = this.txtUserTelephone.Text.Trim();
eShop.Users.Add(user);
eShop.SaveChanges();
Response.Redirect("~/User/UserLogin.aspx");
}
else
{
this.labError.Text = "账户已存在！";
}
}
protected void btnGoodUpdate_Click(object sender, EventArgs e)
{
var goodInfo = eShop.GoodsInfo.Find(int.Parse(Request.QueryString["id"]));
goodInfo.GoodName = this.txtGoodName.Text.Trim();
goodInfo.GoodPrice = Convert.ToDecimal(this.txtGoodPrice.Text.Trim());
//如果checkbox选中则更新图片
if (this.checkUploadImg.Checked == true)
{
//上传图片前的检查
if (uploadImg.HasFile)
{
string savePath = Server.MapPath("~/Images/Goods/");
//检查文件保存路径是否存在
if (!System.IO.Directory.Exists(savePath))
{
System.IO.Directory.CreateDirectory(savePath);
}
//判断文件是否合法
//读取合法文件列表
string[] allowExtension = ConfigurationManager.AppSettings["ImgType"].ToString().Split('|');
string fileExtension = System.IO.Path.GetExtension(uploadImg.FileName).ToLower();
bool checkImg = false;
foreach (string str in allowExtension)
{
if (fileExtension == str)
{
checkImg = true;
break;
}
}
//上传文件
if (checkImg)
{
try
{
this.uploadImg.PostedFile.SaveAs(savePath + uploadImg.FileName);
this.imgGoodImg.Src = savePath + uploadImg.FileName;
this.labUploadImg.Text = "上传成功！";
//更新图片链接
goodInfo.GoodsImg.Where(img => img.ImgLevel == 0).FirstOrDefault().ImgUrl = "/Images/Goods/" + this.uploadImg.FileName;
}
catch
{
this.labUploadImg.Text = "上传失败！";
}
}
else
{
this.labUploadImg.Text = "文件扩展名不合法";
}
}
}
goodInfo.Remark = this.txtRemark.Text.Trim();
goodInfo.AddedDate = DateTime.Now;
try
{
eShop.SaveChanges();
this.labMessenge.Text = "商品数据更新成功！";
}
catch
{
this.labMessenge.Text = "更新发生错误，数据未改变！";
}
}
protected void btnGoodAdd_Click(object sender, EventArgs e)
{
//图片上传
//判断是否有文件上传
if (uploadImg.HasFile)
{
string savePath = Server.MapPath("~/Images/Goods/");
if (!System.IO.Directory.Exists(savePath))
{
System.IO.Directory.CreateDirectory(savePath);
}
//判断文件是否合法
//读取合法文件列表
string[] allowExtension = ConfigurationManager.AppSettings["ImgType"].ToString().Split('|');
string fileExtension = System.IO.Path.GetExtension(uploadImg.FileName).ToLower();
bool checkImg = false;
foreach (string str in allowExtension)
{
if (fileExtension == str)
{
checkImg = true;
break;
}
}
//上传文件
if (checkImg)
{
try
{
this.uploadImg.PostedFile.SaveAs(savePath + uploadImg.FileName);
this.labUploadImg.Text = "上传成功！";
}
catch
{
this.labUploadImg.Text = "上传失败！";
}
}
else
{
this.labUploadImg.Text = "文件扩展名不合法";
}
}
GoodsImg goodImg = new GoodsImg();
goodImg.ImgLevel = 0;
goodImg.ImgUrl = "/Images/Goods/" + this.uploadImg.FileName;
GoodsInfo good = new GoodsInfo();
good.GoodName = this.txtGoodName.Text.Trim();
good.GoodPrice = Convert.ToDecimal(this.txtGoodPrice.Text.Trim());
good.GoodsImg.Add(goodImg);
good.Remark = this.txtRemark.Text.Trim();
good.AddedDate = DateTime.Now;
good.AdderId = ((Sellers)Session["Seller"]).Id;
eShop.GoodsInfo.Add(good);
eShop.SaveChanges();
}
