public ActionResult Edit(string id)
{
ViewBag.RoleList = rolebll.GetAllList();
T_UserInfo model = userbll.GetById(id);
return(View(model));
}
public ActionResult CheckLogin()
{
string validateCode = Session["validateCode"] == null ? string.Empty : Session["validateCode"].ToString();
if (string.IsNullOrEmpty(validateCode))
{
return(Content("no:验证码错误!"));
}
Session["validateCode"] = null;
string requestCode = Request["vCode"];
if (!requestCode.Equals(validateCode, StringComparison.InvariantCultureIgnoreCase))
{
return(Content("no:验证码错误!!"));
}
string userName = Request["LoginCode"];
string userPwd = Request["LoginPwd"];
BLL.UserInfoService UserInfoService = new BLL.UserInfoService();
T_UserInfo userInfo = UserInfoService.GetUserInfoModel(userName, userPwd);
if (userInfo != null)
{
return(Content("ok:登录成功!!"));
}
else
{
return(Content("no:用户名密码错误"));
}
}
public async Task <LoginViewModel> RefreshToken([FromForm] string token)
{
if (string.IsNullOrEmpty(token))
{
throw new NoAuthorizeException("token无效，请重新登录！");
}
var tokenModel = JwtHelper.SerializeJwt(token);
T_UserInfo userInfo = await _userService.FindAsync(tokenModel.UserId);
if (userInfo == null)
{
throw new NoAuthorizeException("token无效，请重新登录！");
}
JwtModel jwtModel = new JwtModel
{
IsAdmin = userInfo.IsAdmin,
UserId = userInfo.Id,
NickName = userInfo.NickName,
UserName = userInfo.UserName,
Expiration = TimeSpan.FromSeconds(60 * 60),
Role = userInfo.IsAdmin ? string.Join(",", ConstInfo.ClientPolicy, ConstInfo.AdminPolicy)
: ConstInfo.ClientPolicy
};
var result = JwtHelper.BuildJwtToken(jwtModel);
result.NickName = userInfo.NickName;
result.AvatarUrl = userInfo.AvatarUrl;
result.UseMdEdit = userInfo.UseMdEdit;
return(result);
}
public ActionResult Edit(string id, string UserName, string TrueName, string Role, string Password, string Pic)
{
T_UserInfo model = userbll.GetById(id);
model.PassWord = BaseSecurity.Md5Hash(Password);
model.UserName = UserName;
model.TrueName = TrueName;
model.CreateDate = DateTime.Now;
model.Role = Role;
model.pic = Pic;
try
{
if (userbll.Update(model))
{
return(Json(new { success = true, msg = "操作成功" }));
}
else
{
return(Json(new { success = false, msg = "操作失败" }));
}
}
catch
{
return(Json(new { success = false, msg = "操作失败" }));
}
}
/// <summary>
/// 获得本用户的所有信息--查
/// </summary>
public static T_UserInfo GetSelf(int id)
{
string sql;
try
{
sql = "select * from T_UserInfo where Nid=" + id;
DataTable dt = FS.SQLHelper.GetTable(sql, System.Data.CommandType.Text, null);
if (dt.Rows.Count != 0)
{
T_UserInfo user = new T_UserInfo((int)dt.Rows[0]["Nid"], dt.Rows[0]["Account"].ToString(), dt.Rows[0]["PassWord"].ToString(), dt.Rows[0]["UserName"].ToString(), dt.Rows[0]["Gender"].ToString(), dt.Rows[0]["Phone"].ToString(), (int)dt.Rows[0]["UserLevel"], (DateTime)dt.Rows[0]["RegisterTime"]);
return(user);
}
else
{
return(null);
}
}
catch
{
return(new T_UserInfo()
{
Nid = -2
});
}
}
public async Task <LoginViewModel> Login([FromBody] LoginParam param)
{
string md5pwd = SafeHelper.MD5TwoEncrypt(param.PassWord);
T_UserInfo userInfo = await _userService.FindAsync(u => u.UserName == param.UserName && u.PassWord == md5pwd);
if (userInfo == null)
{
throw new UserFriendlyException("用户名或密码错误");
}
JwtModel jwtModel = new JwtModel
{
IsAdmin = userInfo.IsAdmin,
UserId = userInfo.Id,
NickName = userInfo.NickName,
UserName = userInfo.UserName,
Expiration = TimeSpan.FromSeconds(60 * 60),
Role = userInfo.IsAdmin ? string.Join(",", ConstInfo.ClientPolicy, ConstInfo.AdminPolicy)
: ConstInfo.ClientPolicy
};
var result = JwtHelper.BuildJwtToken(jwtModel);
result.NickName = userInfo.NickName;
result.AvatarUrl = userInfo.AvatarUrl;
result.UseMdEdit = userInfo.UseMdEdit;
return(result);
}
private T_UserInfo GetModel(HttpContext context)
{
T_UserInfo model = new T_UserInfo();
try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); }
catch { }
model.UserLogName = context.Request.Form["UserLogName"].ToString();
model.UserLogPass = context.Request.Form["UserLogPass"].ToString();
model.UserName = context.Request.Form["UserName"].ToString();
model.UserSex = context.Request.Form["UserSex"].ToString();
model.CardId = context.Request.Form["CardId"].ToString();
model.UserAddress = context.Request.Form["UserAddress"].ToString();
model.UserTel = context.Request.Form["UserTel"].ToString();
model.UserEmail = context.Request.Form["UserEmail"].ToString();
try { model.UserLogNum = int.Parse(context.Request.Form["UserLogNum"].ToString()); }
catch { }
try { model.UserState = int.Parse(context.Request.Form["UserState"].ToString()); }
catch { }
try { model.IsCheck = int.Parse(context.Request.Form["IsCheck"].ToString()); }
catch { }
try { model.CreateDate = DateTime.Parse(context.Request.Form["CreateDate"].ToString()); }
catch { }
try { model.EndDate = DateTime.Parse(context.Request.Form["EndDate"].ToString()); }
catch { }
return(model);
}
/// <summary>
/// 验证用户是否登陆
/// </summary>
/// <param name="httpContext"></param>
/// <returns></returns>
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
//检查Cookies["User"]是否存在
if (httpContext.Request.Cookies["User"] == null)
{
return(false);
}
//验证用户名密码是否正确
HttpCookie _cookie = httpContext.Request.Cookies["User"];
string _userName = _cookie["UserName"];
string _password = _cookie["Password"];
httpContext.Response.Write("用户名:" + _userName);
if (_userName == "" || _password == "")
{
return(false);
}
T_UserInfo model = bll.GetAllList().Where(m => m.UserName == _userName).Where(m => m.PassWord == BaseSecurity.Base64Encode(_password)).SingleOrDefault();
if (model == null)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult UserLogin()
{
string validateCode = Session["code"] == null ? string.Empty : Session["code"].ToString();
if (string.IsNullOrEmpty(validateCode))
{
return(Content("no:请输入验证码!"));
}
Session["code"] = null;
string txtCode = Request["vCode"];
if (!validateCode.Equals(txtCode, StringComparison.InvariantCultureIgnoreCase))
{
return(Content("no:验证码错误!"));
}
string userName = Request["LoginCode"];
string userPwd = Request["LoginPwd"];
UserInfoBLL UserInfoService = new UserInfoBLL();
T_UserInfo userInfo = UserInfoService.GetUserInfo(userName, userPwd);
if (userInfo != null)
{
Session["userInfo"] = userInfo;
return(Content("ok:登录成功"));
}
else
{
return(Content("no:登录失败!!"));
}
}
public ActionResult Index()
{
T_UserInfo userInfo = Session["User"] as T_UserInfo;
ViewBag.user = userInfo.UserName;
return(View());
}
/// <summary>
/// 获取当前登录用户的权限列表
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public List <T_Permissions> GetPermissions(string userid)
{
var list = new List <T_Permissions>();
var result = new List <T_Permissions>();
try
{
T_UserInfo user = userbll.GetById(userid);
if (user != null)
{
// T_RoleInfo usertorole = usertorolebll.GetById(user.Role);//用户拥有的角色
if (!string.IsNullOrWhiteSpace(user.Role))
{
//该角色拥有的权限
List <T_RoleToPermissions> roletoplist = roletoperbll.GetAllList().Where(m => m.RoleId == user.Role).ToList();
List <string> liststr = roletoplist.Select(m => m.Permissions).ToList();
//用户权限
list = permissionbll.GetAllList().Where(s => liststr.Contains(s.id)).ToList();
List <string> pids = list.Select(m => m.ParentId).Distinct().ToList();
result.Add(new T_Permissions {
});
}
}
}
catch
{
}
return(list);
}
/// <summary>
/// 服务端业务逻辑
/// </summary>
/// <param name="userInfo">当前会话的UserInfo实例</param>
public ServerBLBase(T_UserInfo userInfo)
{
this.InitProperty();
this.mUserInfo = userInfo;
this.AfterInitProperty();
}
public void LoadEntity(DataRow row, T_UserInfo userInfo)
{
userInfo.Id = Convert.ToInt32(row["Id"]);
userInfo.UserName = row["UserName"] != DBNull.Value ? row["UserName"].ToString() : string.Empty;
userInfo.UserPwd = row["UserPwd"] != DBNull.Value ? row["UserPwd"].ToString() : string.Empty;
userInfo.UserMail = row["UserMail"] != DBNull.Value ? row["UserMail"].ToString() : string.Empty;
userInfo.RegTime = Convert.ToDateTime(row["RegTime"]);
}
// 查 api/userinfo
public IHttpActionResult Get() //如果采用Get方式，使用复杂类型接收的话，需要在参数前面加[FromUri]
{
T_UserInfo tl = new T_UserInfo()
{
Id = 1, Sex = "女"
};
return(Json <T_UserInfo>(tl));
}
/// <summary>
/// 服务端业务逻辑
/// </summary>
/// <param name="userInfo">当前会话的UserInfo实例</param>
/// <param name="appID">AppID，应用程序标识</param>
public ServerBLBase(T_UserInfo userInfo, int appID)
{
this.InitProperty();
this.mAppID = appID;
this.mUserInfo = userInfo;
this.AfterInitProperty();
}
public MainScreen(int id)
{
InitializeComponent();
User = new T_UserInfo()
{
Nid = id
};
UploadPage4();
UploadPage1();
UploadPage2();
}
public T_UserInfo GetUserInfo(T_User User)
{
T_UserInfo model;
model = CacheManagement.Instance.Get <T_UserInfo>("T_UserInfo", User.ID);;
if (model == null)
{
model = new T_UserInfo();
List <int> t_userrolesidls = GetAllNoCache <T_UserRoles>().Where(p => p.UserID == User.ID).Select(p => p.RoleID).ToList();
List <T_RoleNavBtns> t_rolenavbtnsls = GetAllNoCache <T_RoleNavBtns>().Where(p => t_userrolesidls.Contains(p.RoleID)).ToList();
List <int> navidls = t_rolenavbtnsls.Select(p => p.NavID).Distinct().ToList();
var allbut = GetAllNoCache <T_Button>().ToList();
model.T_User = User;
model.T_Rolels = GetAllNoCache <T_Role>().Where(p => t_userrolesidls.Contains(p.ID)).ToList();
List <T_Navigation> T_Navigationls = new List <T_Navigation>();
foreach (var item in navidls)
{
var nav = GetAllNoCache <T_Navigation>().Where(p => p.ID == item && p.IsDelete != true && p.IsVisible == true).FirstOrDefault();
if (nav != null)
{
var btnidls = t_rolenavbtnsls.Where(p => p.NavID == item && p.IsDelete != true).Select(p => p.BtnID);
// var navbtnsls = GetAllNoCache<T_NavButtons>().Where(p => p.NavId == item && p.IsDelete != true).Select(p => p.ButtonId);
nav.ButtonHtmlList = allbut.Where(p => btnidls.Contains(p.ID) && p.IsDelete != true && p.ButtonTag != "browser").Select(p => p.ButtonHtml).ToList();
// nav.AllButtonHtmlList = allbut.Where(p => navbtnsls.Contains(p.ID) && p.IsDelete != true).Select(p => p.ButtonHtml).ToList();
}
T_Navigationls.Add(nav);
}
List <T_Navigation> AllT_Navigationls = GetAllNoCache <T_Navigation>().Where(p => p.IsDelete != true && p.IsVisible == true).ToList().Select(
(p) =>
{
var navbtnsls = GetAllNoCache <T_NavButtons>().Where(z => z.NavId == p.ID && z.IsDelete != true).Select(z => z.ButtonId);
T_Navigation navmodel = p;
navmodel.AllButtonHtmlList = allbut.Where(z => navbtnsls.Contains(z.ID) && z.IsDelete != true && z.ButtonTag != "browser").Select(z => z.ButtonHtml).ToList();
return(navmodel);
//return new T_Navigation { ID = p.ID, AllButtonHtmlList = allbut.Where(z => navbtnsls.Contains(z.ID) && z.IsDelete != true).Select(z => z.ButtonHtml).ToList(), Sortnum=p.Sortnum , ParentID=p.ParentID , iconUrl =p.iconUrl , Linkurl =p.Linkurl , iconCls =p.iconCls , NavTitle=p.NavTitle , BigImageUrl=p.BigImageUrl , ButtonHtmlList =p.ButtonHtmlList, IsDelete=p.IsDelete ,IsSys=p.IsSys , IsVisible=p.IsVisible , NavTag=p.NavTag , OwnedBut=p.OwnedBut , children=p.children };
}).ToList();
model.AllT_Navigationls = AllT_Navigationls;
model.T_Navigationls = T_Navigationls;
// List<int> btnsidls = t_rolenavbtnsls.Select(p => p.BtnID).ToList();
CacheManagement.Instance.Add("T_UserInfo", User.ID, model);
}
return(model);
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (GetCurrentAccount() != null)//当前用户存在
{
currentUser = GetCurrentAccount();
ViewBag.perssionList = GetPermissions();
}
else
{
filterContext.HttpContext.Response.Redirect("/Login/Index");
}
}
public static LoginUserInfo LoginUserInfo(this T_UserInfo model)
{
return(new LoginUserInfo()
{
IID = model.IID,
UserID = model.UID,
UserName = model.UserName,
NickName = model.UserName,
LoginToken = model.CreateToken(),
TokenExpire = DateTime.Now.AddDays(30),
Permissions = model.Permissions?.ToList()
});
}
public WazPrincipal(FormsAuthenticationTicket ticket)
{
if (ticket == null)
{
throw new ArgumentNullException("ticket");
}
if (!string.IsNullOrEmpty(ticket.UserData))
{
m_info = JsonConvert.DeserializeObject <T_UserInfo>(ticket.UserData);
LoadUserInfo();
}
m_Identity = new FormsIdentity(ticket);
}
public ActionResult SignIn(string name, string password)
{
T_UserInfo userinfo = WazDb.QueryUserInfoByNameAndPassword(name, password);
if (userinfo == null)
{
return(View());
}
else
{
AuthManager.SignIn(HttpContext, userinfo, 60 * 24 * 90);
return(Redirect(FormsAuthentication.GetRedirectUrl(userinfo.Name, false)));
}
}
public string Update(T_UserInfo model)
{
try
{
if (dal.Update(model))
{
return("会员信息修改成功！");
}
else
{
return("会员信息修改失败，错误代码：500 ");
}
}
catch { return("Error 500"); }
}
public string Create(T_UserInfo model)
{
try
{
if (dal.Create(model))
{
return("会员信息添加成功！");
}
else
{
return("会员信息添加失败，错误代码：500 ");
}
}
catch { return("Error 500"); }
}
public IHttpActionResult AddData(dynamic obj) //obj的值是一个Josn对象 {"Id": 4, "Name": "张三" }
{
var id = obj.Id.Value;
var name = obj.Name.Value;
if (id == 123456)
{
T_UserInfo tl = new T_UserInfo()
{
Id = 1, Sex = "成功", Message = "Api调用成功"
};
return(Json <T_UserInfo>(tl));
}
return(Json <int>(1));
}
//更新会员信息
public bool Update(T_UserInfo model)
{
try
{
object[] obj = { model.UserLogName, model.UserLogPass, model.UserName, model.UserSex, model.CardId, model.UserAddress, model.UserTel, model.UserEmail, model.UserLogNum, model.UserState, model.IsCheck, model.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), model.EndDate.ToString("yyyy-MM-dd HH:mm:ss"), model.Id };
string strSql = string.Format("update [T_UserInfo] set [UserLogName] ='{0}' ,[UserLogPass] ='{1}' ,[UserName] = '{2}',[UserSex] = '{3}',[CardId] = '{4}',[UserAddress] ='{5}',[UserTel] = '{6}',[UserEmail] = '{7}',[UserLogNum] = {8},[UserState] = {9},[IsCheck] = {10},[CreateDate] = '{11}',[EndDate] = '{12}' where Id = {13}", obj);
if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { throw; }
}
/// <summary>
/// 加载界面
/// </summary>
private void UploadPage4()
{
try
{
User = BLL.BLL_T_UserInfo.GetSelf(this.User.Nid);
}
catch (Exception ex)
{
MessageBox.Show("加载个人信息时出错：\n" + ex.Message);
System.Environment.Exit(0);
}
textBox5.Text = User.Account;
textBox3.Text = User.UserName;
textBox2.Text = User.Gender;
textBox4.Text = User.Phone;
textBox26.Text = User.RegisterTime.ToString("F");
}
public static T_UserInfo GetSelf(int id)
{
T_UserInfo user = DAL.DAL_T_UserInfo.GetSelf(id);
if (user == null)
{
throw new Exception("登录信息有误！");
}
else if (user.Nid == -2)
{
throw new Exception("数据库连接失败！");
}
else
{
return(user);
}
}
//会员注册
public bool Create(T_UserInfo model)
{
try
{
object[] obj = { model.UserLogName, model.UserLogPass, model.UserName, model.UserSex, model.CardId, model.UserAddress, model.UserTel, model.UserEmail, model.UserLogNum, model.UserState, model.IsCheck, model.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), model.EndDate.ToString("yyyy-MM-dd HH:mm:ss") };
string strSql = string.Format(" insert into [T_UserInfo]([UserLogName],[UserLogPass],[UserName],[UserSex],[CardId],[UserAddress],[UserTel],[UserEmail],[UserLogNum],[UserState],[IsCheck],[CreateDate],[EndDate])values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},{9},{10},'{11}','{12}')", obj);
if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { throw; }
}
public static List <T_UserInfo> GetUserInfo(int userlevel)
{
DataTable dt = DAL.DAL_T_UserInfo.GetUserInfo(userlevel);
List <T_UserInfo> list = new List <T_UserInfo>();
if (dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
T_UserInfo user = new T_UserInfo((int)dr["Nid"], dr["Account"].ToString(), dr["PassWord"].ToString(), dr["UserName"].ToString(), dr["Gender"].ToString(), dr["Phone"].ToString(), (int)dr["UserLevel"], (DateTime)dr["RegisterTime"]);
list.Add(user);
}
}
else
{
return(null);
}
return(list);
}
public T_UserInfo GetUserInfoModel(string userName, string userPwd)
{
string sql = "select * from T_UserInfo where UserName=@UserName and UserPwd=@UserPwd";
SqlParameter[] pars =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 32),
new SqlParameter("@UserPwd", SqlDbType.NVarChar, 32)
};
pars[0].Value = userName;
pars[1].Value = userPwd;
DataTable da = SqlHelper.GetTable(sql, CommandType.Text, pars);
T_UserInfo userInfo = null;
if (da.Rows.Count > 0)
{
userInfo = new T_UserInfo();
LoadEntity(da.Rows[0], userInfo);
}
return(userInfo);
}
