/// <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); }