/// <summary>
/// 修改个人信息
/// </summary>
/// <param name="userdt"></param>
/// <returns></returns>
public ActionResult UpdataPersonal(string jsonstrt)
{
//获取登陆用户的id
int id = Convert.ToInt32(Session["userid"]);
//分割字符串
string[] strarr = jsonstrt.Split(',');
//创建数据库对象
SportsDBEntities sde = new SportsDBEntities();
//进行修改
UserInfo_detail tblist = sde.UserInfo_detail.Where(a => a.userid == id).FirstOrDefault();
tblist.username = strarr[0];
tblist.user_nickname = strarr[1];
tblist.user_sex = strarr[2];
tblist.user_idcard = strarr[3];
tblist.user_email = strarr[4];
tblist.user_telphone = strarr[5];
//保存修改数据
//UserInfo_detail ud = sde.UserInfo_detail.Add(tblist);
int count = sde.SaveChanges();
Response.Write(count);
Response.End();
return(RedirectToAction("Information"));
}
/// <summary>
/// 查询用户详情
/// </summary>
/// <returns></returns>
public JsonResult Log()
{
if (Session["name"] == null)
{
return(Json(0));
}
else
{
//获取用户id
int uid = Convert.ToInt32(Session["uid"]);
SportsDBEntities sde = new SportsDBEntities();
//查询详细
UserInfo_detail ud = sde.UserInfo_detail.Where(a => a.detailId == uid).FirstOrDefault();
//存储详细信息
Session["detail"] = ud;
if (ud != null)
{
return(Json(1));
}
else
{
return(Json(123456789));
}
}
}
/// <summary>
/// 立即购买付款
/// </summary>
/// <param name="shopId"></param>
/// <param name="num"></param>
/// <param name="GoodsMsg"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public JsonResult ShopYes(int shopId, int num, string GoodsMsg, string pwd)
{
string[] msg = GoodsMsg.Split(',');
SportsDBEntities sde = new SportsDBEntities();
//查询商品的信息
GoodsInfo gd = sde.GoodsInfo.Where(a => a.Id == shopId).FirstOrDefault();
//获取商品的价格
decimal?money = gd.Goods_price * num;
decimal?user_money = Convert.ToDecimal(Session["money"]);
if (money > user_money)
{
return(Json(0));
}
else
{
//用户id
int uid = Convert.ToInt32(Session["uid"]);
//添加订单的信息
Add_dd(msg, uid, money, num);
//余额
decimal?price = user_money - money;
//修改
UserInfo_detail detail = sde.UserInfo_detail.Where(a => a.userid == uid).FirstOrDefault();
detail.user_money = price;
//获取返回的受影响的个数
int count = sde.SaveChanges();
return(Json(count));
}
}
/// <summary>
///
/// </summary>
/// <param name="monet"></param>
/// <returns></returns>
public JsonResult getMoney(string monet)
{
SportsDBEntities sde = new SportsDBEntities();
//得到登录的用户编号
int uid = Convert.ToInt32(Session["uid"]);
Decimal money = Convert.ToDecimal(monet);
UserInfo_detail ud = sde.UserInfo_detail.Where(a => a.userid == uid).FirstOrDefault();
Decimal?gg = Convert.ToDecimal(ud.user_money) - money;
if (gg < 0)
{
return(Json(2));
}
else
{
ud.user_money = gg;
int count = sde.SaveChanges();
return(Json(count));
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public ActionResult ShopUser_Login(string user)
{
object carts = Session["url"];
string cart = "";
if (carts != null)
{
cart = carts.ToString();
}
int shopid = Convert.ToInt32(Session["shopid"]);
//将前台传来的字符串转化为数组
string[] userpass = user.Split(',');
//得到用户名
string username = userpass[0];
//得到密码
string pasaword = userpass[1];
SportsDBEntities sde = new SportsDBEntities();
//查询
UserInfo ulist = sde.UserInfo.Where(a => a.name == username && a.user_password == pasaword).FirstOrDefault();
//判断
if (ulist != null)
{
//用户基本信息
Session["UserInfo"] = ulist;
//获取用户的id
int uid = ulist.userid;
Session["uid"] = uid;
//查询当前登录用户的购物车
List <ShopManagement> shopcart = sde.ShopManagement.Where(a => a.userid == uid).ToList();
//购物车件数
Session["scart"] = shopcart.Count;
//查询获取详细信息
UserInfo_detail ud = sde.UserInfo_detail.Where(a => a.userid == uid).FirstOrDefault();
//添加或查询详细信息
select_detail(ud, ulist, uid);
if (cart == "shopcart")
{
return(Json(new { type = 2 }));
}
else if (shopid != 0)
{
return(Json(new { type = 1, data = shopid }));
}
else
{
Response.Write(2);
Response.End();
}
}
else
{
Response.Write(1);
Response.End();
}
return(View());
}
/// <summary>
/// 查询详细
/// </summary>
/// <param name="ud"></param>
/// <param name="ulist"></param>
/// <param name="uid"></param>
public void select_detail(UserInfo_detail ud, UserInfo ulist, int uid)
{
SportsDBEntities sde = new SportsDBEntities();
if (ud != null)
{
//获取用户的昵称
string name = ud.user_nickname;
//存储昵称
Session["name"] = name;
//存储用户余额
Session["money"] = ud.user_money;
//存储用户名
Session["username"] = ud.username;
//存储用户id
Session["userid"] = ud.userid;
//头像
Session["photo"] = ud.user_photo;
}
else
{
//判断手机还是邮箱登陆
if (ulist.name.Contains("@"))
{
//存入数据
UserInfo_detail udd = new UserInfo_detail();
udd.userid = uid;
udd.user_email = ulist.name;
udd.user_nickname = ulist.name;
//执行添加操作
sde.Entry(udd).State = System.Data.EntityState.Added;
sde.SaveChanges();
}
else
{
//存入数据
UserInfo_detail udd = new UserInfo_detail();
udd.userid = uid;
udd.user_photo = ulist.name;
udd.user_nickname = ulist.name;
//执行添加操作
sde.Entry(udd).State = System.Data.EntityState.Added;
sde.SaveChanges();
}
//获取用户的昵称
string name = ulist.name;
//存储昵称
Session["name"] = name;
//默认头像
Session["photo"] = "1.jpg";
}
}
