protected void Button1_Click(object sender, EventArgs e)
{
//订单信息保存到后台
//正式下单
//获取当前用户
YF.Model.User myuser = new YF.Model.User();//获取当前用户信息
myuser = (YF.Model.User)YF.SessionHelper.GetSesstion("user");
//1.生成订单编号，上传商品封面有写过，
string dingdanbianhao = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString();
//声明空的订单对象
YF.Model.Order myorder = new YF.Model.Order(); //声明空的订单对象
//给订单对象赋值
myorder.Id = dingdanbianhao; //赋值订单编号
myorder.User = myuser; //赋值当前用户信息
myorder.Amount = int.Parse(this.zongjia.Text); //赋值总价
myorder.State = 1; //订单状态，表示未付款
myorder.Addate = DateTime.Now; //订单时间
if (YF.BLL.Order.add(myorder)) //把订单对象，调用业务层，插入数据
{
//更新购物车
YF.BLL.Shopping.updateshopping(dingdanbianhao, myuser.Id, 0);//清空购物车，通过updateshopping
YF.JsHelper.AlertAndRedirect("下单成功", "/user/order.aspx");
}
else
{
YF.JsHelper.AlertAndRedirect("下单失败", "/user/order.aspx");
}
}
public static List <YF.Model.Shopping> Dotolist(DataTable dt)
{
List <YF.Model.Shopping> list = new List <Model.Shopping>();//空的泛型对象 转换
for (int i = 0; i < dt.Rows.Count; i++)
{
YF.Model.Shopping shopping = new Model.Shopping();//空对象
shopping.Id = int.Parse(dt.Rows[i]["id"].ToString());
//当前商品
YF.Model.Goods goods = YF.DAL.Goods.GetGoods(int.Parse(dt.Rows[i]["goodsid"].ToString())); //通过id 得到商品实列对象
shopping.Goods = goods; //商品赋值=上面的goods
//当前用户
YF.Model.User user = YF.DAL.User.GetUser(int.Parse(dt.Rows[i]["userid"].ToString())); //通过id 得到用户实列对象
shopping.User = user; //商品赋值=上面的user
shopping.Num = int.Parse(dt.Rows[i]["num"].ToString());
shopping.State = int.Parse(dt.Rows[i]["state"].ToString());
shopping.Addate = DateTime.Parse(dt.Rows[i]["addate"].ToString());
list.Add(shopping); //空的泛型对象+数据
}
return(list);
}
//更新
public static bool update(YF.Model.User user)
{
bool result = false;
string strsql = "update t_user set Username='******',password='******',Name='" + user.Name + "',Adress='" + user.Adress + "',Sex=" + user.Sex + ",Mobile='" + user.Mobile + "',Email='" + user.Email + "',State=" + user.State + " where id= " + user.Id + "";
int i = YF.MsSqlHelper.YFMsSqlHelper.ExecuteSql(strsql);
if (i > 0)
{
result = true;
}
return(result);
}
/// <summary>
/// (添加用户)类
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static bool add(YF.Model.User user)
{
bool result = false;
string strsql = "insert into t_user (username, password, name, address, sex, mobile, email, qq, adddate,role) values('" + user.Username + "', '" + user.Password + "', '" + user.Name + "', '" + user.Address + "', " + user.Sex + ", '" + user.Mobile + "', '" + user.Email + "', '" + user.Qq + "', '" + user.Adddate + "', '" + user.Role + "')";
// 返回执行成功的数量，执行成功1返回1，成功2条返回2
int i = YF.MsSqlHelper.YFMsSqlHelper.ExecuteSql(strsql);
if (i > 0)
{
result = true;
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
//获取保存的对象
//声明对象
YF.Model.User myuser = new YF.Model.User();
myuser = (YF.Model.User)YF.SessionHelper.GetSesstion("user");//读取 //强制转
if (myuser != null)
{
this.username.Text = myuser.Username;
}
else
{
YF.JsHelper.AlertAndRedirect("尚未登录", "login.aspx");
}
}
/// <summary>
/// update users' data
/// </summary>
/// <returns>返回bool表示是否成功</returns>
public static bool updateData(YF.Model.User user)
{
bool res = false;
string strsql = "update t_user set password ='******', name = '" + user.Name + "', address = '" + user.Address + "', sex = " + user.Sex + ", mobile='" + user.Mobile + "', email='" + user.Email + "', qq='" + user.Qq + "' , role='" + user.Role + "'where id=" + user.Id + "";
// 执行数据库更新操作，返回值大于零说明删除成功
int i = YF.MsSqlHelper.YFMsSqlHelper.ExecuteSql(strsql);
if (i > 0)
{
res = true;
}
else
{
res = false;
}
return(res);
}
protected void Page_Load(object sender, EventArgs e) //一点击页面就加载
{
if (!IsPostBack) //刷新内存
{
//保存了用户信息，将信息拿过来
YF.Model.User myuser = new YF.Model.User(); //声明空对象
myuser = (YF.Model.User)YF.SessionHelper.GetSesstion("user"); //读取 //强制转
//将信息赋值
this.username.Text = myuser.Username;
this.password.Text = myuser.Password;
this.name.Text = myuser.Name;
this.adress.Text = myuser.Adress;
this.sex.Text = myuser.Sex.ToString();
this.mobile.Text = myuser.Mobile;
this.email.Text = myuser.Email;
this.qq.Text = myuser.Qq;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"];
YF.Model.User user = YF.BLL.User.GetUser(int.Parse(id));
this.username.Text = user.Username;
this.password.Text = user.Password;
this.name.Text = user.Name;
this.adress.Text = user.Adress;
this.sex.Text = user.Sex.ToString();
this.mobile.Text = user.Mobile;
this.email.Text = user.Email;
this.qq.Text = user.Qq;
this.state.Text = user.State.ToString();
this.id.Value = user.Id.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//声明变量 总价
int zongjia = 0;
//计算
//获取当前用户未下单的信息
YF.Model.User myuser = new YF.Model.User();
myuser = (YF.Model.User)YF.SessionHelper.GetSesstion("user"); //获取当前用户信息
List <YF.Model.Shopping> list = YF.BLL.Shopping.list(myuser.Id); //用户id/通过用户id,查询购物车信息，算出总价
//便利
for (int i = 0; i < list.Count; i++)
{
zongjia = zongjia + list[i].Goods.Price * list[i].Num;//i=i+1
}
//显示
this.zongjia.Text = zongjia.ToString(); //把总价返回到前台
}
public static List <YF.Model.Order> Dotolist(DataTable dt)
{
List <YF.Model.Order> list = new List <Model.Order>();//空的泛型对象 转换
for (int i = 0; i < dt.Rows.Count; i++)
{
YF.Model.Order order = new Model.Order();//空对象
order.Id = dt.Rows[i]["id"].ToString();
//当前用户
YF.Model.User user = YF.DAL.User.Getuser(int.Parse(dt.Rows[i]["userid"].ToString())); //通过id 得到用户实列对象
order.User = user; //商品赋值=上面的user
order.Amount = float.Parse(dt.Rows[i]["amount"].ToString());
order.State = int.Parse(dt.Rows[i]["state"].ToString());
order.Adddate = DateTime.Parse(dt.Rows[i]["adddate"].ToString());
list.Add(order); //空的泛型对象+数据
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
//向后台数据库加入记录，点击购买，购物车加
YF.Model.User myuser = new YF.Model.User();
myuser = (YF.Model.User)YF.SessionHelper.GetSesstion("user");//读取当前用户信息 //强制转
if (myuser != null)
{
YF.Model.Shopping shopping = new YF.Model.Shopping(); //1，声明空的购物车对象
int id = int.Parse(Request.QueryString["id"].ToString()); //通过id查询，传过来的，转化数字
YF.Model.Goods goods = YF.BLL.Goods.GetGoods(id); ////4，声明一个商品对象，通过id查询
//5，空对象赋值
shopping.Goods = goods;
shopping.User = myuser;//等于当前用户
shopping.Num = 1;
shopping.State = 0;
shopping.Addate = DateTime.Now;
if (YF.BLL.Shopping.list(goods.Id, myuser.Id, 0).Count > 0) //查询商品是否是第一次，，不是第一次，已经存在之前有添加，则修改数量
{
YF.BLL.Shopping.updatenum(goods.Id, myuser.Id, 0); //修改数量
YF.JsHelper.AlertAndRedirect("添加成功", "/user/shopping.aspx"); //3，添加成功返回购物车页面
}
else
{
if (YF.BLL.Shopping.add(shopping)) //2，调用业务类，判断逻辑。真，操作成功//第一次
{
YF.JsHelper.AlertAndRedirect("操作成功", "/user/shopping.aspx"); //3，返回购物车页面
}
else
{
YF.JsHelper.AlertAndRedirect("操作失败", "/user/shopping.aspx");//不成功购物，失败
}
}
}
else
{
YF.JsHelper.AlertAndRedirect("尚未登录", "/login.aspx");
}
}
protected void Button3_Click(object sender, EventArgs e)
{
//保存
//当前登录对象
YF.Model.User user = new YF.Model.User();
user = (YF.Model.User)YF.SessionHelper.GetSesstion("user");//读取 //强制转
//新的数据重新赋值赋值
user.Password = this.password.Text;
user.Name = this.name.Text;
user.Adress = this.adress.Text;
user.Sex = int.Parse(this.sex.Text);
user.Mobile = this.mobile.Text;
user.Qq = this.qq.Text;
//调后台方法更新；
if (YF.BLL.User.update(user))
{
YF.JsHelper.AlertAndRedirect("用户信息修改成功", "index.aspx");
}
else
{
YF.JsHelper.AlertAndRedirect("用户信息修改失败", "index.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
YF.Model.User user = new YF.Model.User();
user.Username = this.username.Text;
user.Password = this.password.Text;
user.Name = this.name.Text;
user.Adress = this.adress.Text;
user.Sex = int.Parse(this.sex.Text);
user.Mobile = this.mobile.Text;
user.Email = this.email.Text;
user.Qq = this.qq.Text;
user.State = int.Parse(this.state.Text);
user.Id = int.Parse(this.id.Value);
if (YF.BLL.User.update(user) == true)
{
YF.JsHelper.AlertAndRedirect("编辑成功", "user.aspx");
}
else
{
YF.JsHelper.AlertAndRedirect("编辑失败", "user.aspx");
}
}
//用户管理，删除
public static YF.Model.User GetUser(int id)
{
//通过id 查询 返回一个实体对象user
YF.Model.User user = new YF.Model.User();
string strsql = "select * from t_user where id=" + id + "";
DataTable dataTable = YF.MsSqlHelper.YFMsSqlHelper.Query(strsql).Tables[0];//一张表
if (dataTable.Rows.Count != 0)
{
user.Id = int.Parse(dataTable.Rows[0]["id"].ToString());
user.Username = dataTable.Rows[0]["Username"].ToString();
user.Password = dataTable.Rows[0]["Password"].ToString();
user.Name = dataTable.Rows[0]["Name"].ToString();
user.Adress = dataTable.Rows[0]["Adress"].ToString();
user.Sex = int.Parse(dataTable.Rows[0]["Sex"].ToString());
user.Mobile = dataTable.Rows[0]["Mobile"].ToString();
user.Email = dataTable.Rows[0]["Email"].ToString();
user.Qq = dataTable.Rows[0]["Qq"].ToString();
user.State = int.Parse(dataTable.Rows[0]["State"].ToString());
user.Addate = DateTime.Parse(dataTable.Rows[0]["Addate"].ToString());
}
return(user);
}
/// <summary>
/// 通过username查询
/// </summary>
/// <param name="username"></param>
/// <returns>返回一个用户实体对象</returns>
public static YF.Model.User GetUserbyname(string username)
{
YF.Model.User user = new YF.Model.User();
string strsql = "select * from t_user where username='******'";
DataTable dataTable = YF.MsSqlHelper.YFMsSqlHelper.Query(strsql).Tables[0];//一张表
if (dataTable.Rows.Count != 0)
{
user.Id = int.Parse(dataTable.Rows[0]["id"].ToString());
user.Username = dataTable.Rows[0]["Username"].ToString();
user.Password = dataTable.Rows[0]["Password"].ToString();
user.Name = dataTable.Rows[0]["Name"].ToString();
user.Address = dataTable.Rows[0]["Address"].ToString();
user.Sex = int.Parse(dataTable.Rows[0]["Sex"].ToString());
user.Mobile = dataTable.Rows[0]["Mobile"].ToString();
user.Email = dataTable.Rows[0]["Email"].ToString();
user.Qq = dataTable.Rows[0]["Qq"].ToString();
//user.State = int.Parse(dataTable.Rows[0]["State"].ToString()); 已经删除
user.Adddate = DateTime.Parse(dataTable.Rows[0]["Adddate"].ToString());
user.Role = dataTable.Rows[0]["Role"].ToString();
}
return(user);
}
protected void Button1_Click(object sender, EventArgs e)
{
string username = this.username.Text;
string password = this.password.Text;
if (YF.BLL.User.login(username, password) == true)
{
YF.Model.User user = YF.BLL.User.GetUser(username);
if (user.State == 1)
{
YF.SessionHelper.SetSession("user", user);//记住对象，保存当前用户登录身份信息
YF.JsHelper.AlertAndRedirect("登录成功", "/user/index.aspx");
}
else
{
YF.JsHelper.AlertAndRedirect("账号关闭", "index.aspx");
}
}
else
{
YF.JsHelper.AlertAndRedirect("登录失败", "login.aspx");
}
}
public static List <YF.Model.User> Dttolist(DataTable dt)
{
List <YF.Model.User> list = new List <YF.Model.User>(); //空的泛型对象 转换
//if (dt.Rows.Count != 0)
for (int i = 0; i < dt.Rows.Count; i++)
{
YF.Model.User user = new YF.Model.User();
//user = GetUser(int.Parse(dt.Rows[i]["id"].ToString()));
user.Id = int.Parse(dt.Rows[i]["id"].ToString());
user.Username = dt.Rows[i]["Username"].ToString();
user.Password = dt.Rows[i]["Password"].ToString();
user.Name = dt.Rows[i]["Name"].ToString();
user.Adress = dt.Rows[i]["Adress"].ToString();
user.Sex = int.Parse(dt.Rows[i]["Sex"].ToString());
user.Mobile = dt.Rows[i]["Mobile"].ToString();
user.Email = dt.Rows[i]["Email"].ToString();
user.Qq = dt.Rows[i]["Qq"].ToString();
user.State = int.Parse(dt.Rows[i]["State"].ToString());
user.Addate = DateTime.Parse(dt.Rows[i]["Addate"].ToString());
list.Add(user); //空的泛型对象+数据
}
return(list);
}
public static List <YF.Model.Cart> Dotolist(DataTable dt)
{
List <YF.Model.Cart> list = new List <Model.Cart>();//空的泛型对象 转换
for (int i = 0; i < dt.Rows.Count; i++)
{
YF.Model.Cart cart = new Model.Cart(); // 购物车空对象
cart.Id = int.Parse(dt.Rows[i]["id"].ToString());
//当前商品
YF.Model.Books books = YF.DAL.Books.GetBooks(int.Parse(dt.Rows[i]["bookid"].ToString())); //通过id 得到商品实列对象
//当前用户
YF.Model.User user = YF.DAL.User.Getuser(int.Parse(dt.Rows[i]["userid"].ToString())); //通过id 得到用户实列对象
cart.Books = books; //商品赋值=上面的books
cart.User = user; //商品赋值=上面的user
cart.Num = int.Parse(dt.Rows[i]["num"].ToString());
cart.State = int.Parse(dt.Rows[i]["state"].ToString());
cart.Adddate = DateTime.Parse(dt.Rows[i]["adddate"].ToString());
list.Add(cart); //空的泛型对象+数据
}
return(list);
}
/// <summary>
/// (添加用户)类
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static bool add(YF.Model.User user)
{
return(YF.DAL.User.add(user));
}
/// <summary>
/// update users' data
/// </summary>
/// <param name="user"></param>
/// <returns>返回bool表示是否成功</returns>
public static bool updateData(YF.Model.User user)
{
return(YF.DAL.User.updateData(user));
}