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