public ActionResult List()
{
ModelSysUser userInfo = this.CurrentUser; // 控制器中 获取当前用户方式
var model = this.GetData();
return(View());
}
public string VerifyUser(string userName, string userPassword, string sessionID, out string userId, out string userFullName, out string resultMsg)
{
resultMsg = string.Empty;
userId = string.Empty;
userFullName = string.Empty;
var key = string.Empty;
if ((sessionID == null) || (sessionID == string.Empty))
{
return(string.Empty);
}
userPassword = string.IsNullOrWhiteSpace(userPassword) ? string.Empty : userPassword;
userName = string.IsNullOrWhiteSpace(userName) ? string.Empty : userName;
ILogicSysUser logic = new LogicSysUser();
ModelSysUser userByName = logic.SysUserDetail(out resultMsg, userName);;
if ((userByName != null) && !string.IsNullOrWhiteSpace(userByName.Upassword) && !string.IsNullOrWhiteSpace(userByName.Uname) && userByName.Ustate != 2)
{
userPassword = Common.EncryptDecrypt.ComputeHash(userPassword, userName.ToLower());
if (userPassword.Trim() == userByName.Upassword.Trim())
{
userId = userByName.Userid;
userFullName = userByName.Fullname;
key = EncryptDecrypt.EncryptStr(userName + Convert.ToString(Convert.ToChar(1)) + userPassword, sessionID);
}
}
return(key);
}
/// <summary>
/// 查询实体
/// </summary>
/// <param name="id">ModelId </param>
/// <returns>ModelSysUser</returns>
public ModelSysUser SysUserDetail(out string resultMsg, string uname)
{
resultMsg = string.Empty;
var model = new ModelSysUser();
try
{
//存储过程名称
string sql = "SELECT * FROM [PowerSystem].[dbo].[sys_user] WHERE uname = @uname ";
//参数添加
IList <DBParameter> parm = new List <DBParameter>();
parm.Add(new DBParameter()
{
ParameterName = "uname", ParameterValue = uname, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
//查询执行
using (IDataReader dr = DBHelper.ExecuteReader(sql, false, parm))
{
IList <ModelSysUser> list = GetModel(dr);
model = list.First();
}
}
catch (Exception ex)
{
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return(model);
}
/// <summary>
/// 页面初始化函数
/// </summary>
/// <param name="requestContext">上下文</param>
protected override void Initialize(RequestContext requestContext)
{
if (requestContext.HttpContext.Session["UserInfo"] == null)
{
UrlHelper url = new UrlHelper(requestContext);
var urlPath = url.Action("LoginOut", "Login");
requestContext.HttpContext.Response.Redirect(urlPath);
}
CurrentUser = (ModelSysUser)requestContext.HttpContext.Session["UserInfo"];
base.Initialize(requestContext);
}
/// <summary>
/// Model 赋值 IDataReader
/// </summary>
private IList <ModelSysUser> GetModel(IDataReader dr)
{
var modelList = new List <ModelSysUser>();
while (dr.Read())
{
var model = new ModelSysUser();
model.Id = dr["id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["id"]);
model.Userid = dr["userid"] == DBNull.Value ? string.Empty : dr["userid"].ToString();
model.Uname = dr["uname"] == DBNull.Value ? string.Empty : dr["uname"].ToString();
model.OrderAsc = dr["order_asc"] == DBNull.Value ? 0 : Convert.ToInt32(dr["order_asc"]);
model.Upassword = dr["upassword"] == DBNull.Value ? string.Empty : dr["upassword"].ToString();
model.Fullname = dr["fullname"] == DBNull.Value ? string.Empty : dr["fullname"].ToString();
model.Ismanage = dr["ismanage"] == DBNull.Value ? false : Convert.ToBoolean(dr["ismanage"]);
model.Ustate = dr["ustate"] == DBNull.Value ? 0 : Convert.ToInt32(dr["ustate"]);
model.Email = dr["email"] == DBNull.Value ? string.Empty : dr["email"].ToString();
modelList.Add(model);
}
return(modelList);
}
public ActionResult Index(FormCollection fc, ModelSysUser model)
{
IFacadeSysUser fakSysUser = new FacadeSysUser();
var userId = string.Empty;
var userFullName = string.Empty;
var resultMsg = string.Empty;
string identity = fakSysUser.VerifyUser(model.Uname, model.Upassword, Guid.NewGuid().ToString(), out userId, out userFullName, out resultMsg); // Guid.NewGuid().ToString()
if (!string.IsNullOrWhiteSpace(identity) && string.IsNullOrWhiteSpace(resultMsg))
{
model.Userid = userId;
model.Fullname = userFullName;
Session["UserInfo"] = model;
Response.Redirect(Url.Action("Index", "Home"));
}
else
{
resultMsg = "登录失败,请重新登录,如多次登录失败请联系管理员处理!";
this.ShowMessage(resultMsg, isSuccess: false, width: 350);
}
ModelState.Clear();
return(View(model));
}
