/// <summary> /// 编辑用户信息 /// </summary> /// <param name="user">修改用户名,性别,密码,地址,qq,手机</param> /// <param name="token"></param> /// <returns></returns> public RespResult EditeUserInfo(SysUser user, string token) { RespResult result = new RespResult(); try { if (!CacheManagerFactory.GetMemoryManager().Contains(token)) { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } else { int userid = Convert.ToInt32(CacheManagerFactory.GetMemoryManager().Get(token)); if (userid > 0) { //SysUser olduser = SysUserAccessor.Instance.Get(userid, string.Empty, string.Empty, StateType.Ignore); //if (olduser.UserAccount != user.UserAccount) //{ // AdvancedResult<bool> dr = CheckAccout(user.UserAccount); // if (dr.Data) // { // result.Error = AppError.ERROR_PERSON_FOUND; // return result; // } //} //olduser.UserAccount = user.UserAccount; //olduser.Sex = user.Sex; //olduser.Pwd = user.Pwd; //olduser.Province = user.Province; //olduser.City = user.City; //olduser.County = user.County; //olduser.Street = user.Street; //olduser.Mobile = user.Mobile; //olduser.Qq = user.Qq; //SysUserAccessor.Instance.Update(olduser); result.Error = AppError.ERROR_SUCCESS; } else { result.Error = AppError.ERROR_FAILED; } } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } return result; }
/// <summary> /// 修改指定的数据 /// <param name="e">修改后的数据实体对象</param> /// <para>数据对应的主键必须在实例中设置</para> /// </summary> public void Update(SysUser e) { }
public AdvancedResult<string> Register(string account, string pwd) { AdvancedResult<string> result = new AdvancedResult<string>(); try { AdvancedResult<bool> dr = CheckAccout(account); if (dr.Data) { result.Error = AppError.ERROR_PERSON_FOUND; return result; } SysUser user = new SysUser(); user.UserName = account; user.Pwd = pwd; user.Email= bool i = SysUserAccessor.Instance.Insert(user); if (i) { result.Error = AppError.ERROR_SUCCESS; result.Data = SecurityHelper.GetToken(i.ToString()); } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } return result; }
/// <summary> /// 修改指定的数据 /// <param name="e">修改后的数据实体对象</param> /// <para>数据对应的主键必须在实例中设置</para> /// </summary> public void Update(SysUser e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdUpdateSysUser = cmdUpdateSysUser.Clone() as MySqlCommand; _cmdUpdateSysUser.Connection = oc; try { if (oc.State == ConnectionState.Closed) oc.Open(); _cmdUpdateSysUser.Parameters["@UserId"].Value = e.UserId; _cmdUpdateSysUser.Parameters["@UserName"].Value = e.UserName; _cmdUpdateSysUser.Parameters["@Pwd"].Value = e.Pwd; _cmdUpdateSysUser.Parameters["@Mobile"].Value = e.Mobile; _cmdUpdateSysUser.Parameters["@Email"].Value = e.Email; _cmdUpdateSysUser.Parameters["@CreateTime"].Value = e.CreateTime; _cmdUpdateSysUser.Parameters["@EndTime"].Value = e.EndTime; _cmdUpdateSysUser.Parameters["@FatherId"].Value = e.FatherId; _cmdUpdateSysUser.ExecuteNonQuery(); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdUpdateSysUser.Dispose(); _cmdUpdateSysUser = null; GC.Collect(); } }
/// <summary> /// 添加数据 /// <param name="es">数据实体对象数组</param> /// <returns></returns> /// </summary> public bool Insert(SysUser e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdInsertSysUser = cmdInsertSysUser.Clone() as MySqlCommand; bool returnValue = false; _cmdInsertSysUser.Connection = oc; try { if (oc.State == ConnectionState.Closed) oc.Open(); _cmdInsertSysUser.Parameters["@UserId"].Value = e.UserId; _cmdInsertSysUser.Parameters["@UserName"].Value = e.UserName; _cmdInsertSysUser.Parameters["@Pwd"].Value = e.Pwd; _cmdInsertSysUser.Parameters["@Mobile"].Value = e.Mobile; _cmdInsertSysUser.Parameters["@Email"].Value = e.Email; _cmdInsertSysUser.Parameters["@CreateTime"].Value = e.CreateTime; _cmdInsertSysUser.Parameters["@EndTime"].Value = e.EndTime; _cmdInsertSysUser.Parameters["@FatherId"].Value = e.FatherId; _cmdInsertSysUser.ExecuteNonQuery(); return returnValue; } finally { oc.Close(); oc.Dispose(); oc = null; _cmdInsertSysUser.Dispose(); _cmdInsertSysUser = null; } }
/// <summary> /// 获取指定记录 /// <param name="id">Id值</param> /// </summary> public SysUser Get(int UserId) { SysUser returnValue = null; MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdGetSysUser = cmdGetSysUser.Clone() as MySqlCommand; _cmdGetSysUser.Connection = oc; try { _cmdGetSysUser.Parameters["@UserId"].Value = UserId; if (oc.State == ConnectionState.Closed) oc.Open(); MySqlDataReader reader = _cmdGetSysUser.ExecuteReader(); if (reader.HasRows) { reader.Read(); returnValue = new SysUser().BuildSampleEntity(reader); } } finally { oc.Close(); oc.Dispose(); oc = null; _cmdGetSysUser.Dispose(); _cmdGetSysUser = null; GC.Collect(); } return returnValue; }