public ActionResult EditAgent(string id, string username, string password, string email, string displayname,
string phone, string qq, string dlcs)
{
var provider = new UserLoginProvider();
if (!string.IsNullOrEmpty(id))
{
var _user = provider.GetUser(username);
if (_user != null)
{
_user.Email = email.Trim();
_user.Phone = phone.Trim();
_user.DisplayName = displayname.Trim();
_user.CreateDate = _user.CreateDate;
var i = provider.UpdateUser(_user);
if (i > 0)
{
var agentInfo = UserService.GetAgentInfoByUserId(_user.Id);
if (agentInfo != null)
{
agentInfo.AgentCityId = Convert.ToInt64(dlcs);
//agentInfo.UserId = i;
agentInfo.QQNumber = qq ?? "";
//agentInfo.IsDelete = false;
agentInfo.CreateDate = DateTime.Now;
UserService.UpdateAgentInfo(agentInfo);
}
}
}
}
else
{
var entity = new SysUser();
entity.UserName = username.Trim();
entity.Password = DEncrypt.Md5(password.Trim());
entity.Email = email.Trim();
entity.Phone = phone.Trim();
entity.Status = 1;
entity.RuleType = RuleTypeEnum.Agents.ToString();
entity.DisplayName = displayname.Trim();
entity.CreateDate = DateTime.Now;
var i = provider.InsertUser(entity);
if (i > 0)
{
var agent = new SysAgentInfo();
agent.AgentCityId = Convert.ToInt64(dlcs);
agent.UserId = i;
agent.QQNumber = qq ?? "";
agent.IsDelete = false;
agent.CreateDate = DateTime.Now;
UserService.InsertAgentInfo(agent);
}
}
return(Content("ok"));
}
//特别注意，如果是可空类型，建议以如下方式使用：
// var data = reader["field"];
// entity.stringData = data == null ? data : data.ToString();
//如需要手工映射，请反注释如下代码，并注意转换类型
/*
* /// <summary>
* /// 手工映射，建议使用1.2.0.5版本以上的VisitDataReader
* /// </summary>
* /// <returns>结果</returns>
* public SysAgentInfo OrmByHand(string sql)
* {
* try
* {
* return baseDao.VisitDataReader<SysAgentInfo>(sql, (reader) =>
* {
* SysAgentInfo entity = new SysAgentInfo();
* if(reader.Read())
* {
* entity.AgentCityId = reader["AgentCityId"];
* entity.CreateDate = reader["CreateDate"];
* entity.Id = reader["Id"];
* entity.IsDelete = reader["IsDelete"];
* entity.QQNumber = reader["QQNumber"];
* entity.UserId = reader["UserId"];
* }
* return entity;
* });
*
* //SysAgentInfo entity = new SysAgentInfo();
* //using(var reader = baseDao.SelectDataReader(sql))
* //{
* //if(reader.Read())
* //{
* //entity.AgentCityId = reader["AgentCityId"];
* //entity.CreateDate = reader["CreateDate"];
* //entity.Id = reader["Id"];
* //entity.IsDelete = reader["IsDelete"];
* //entity.QQNumber = reader["QQNumber"];
* //entity.UserId = reader["UserId"];
* //}
* //}
* //return entity;
* }
* catch (Exception ex)
* {
* throw new DalException("调用SysAgentInfoDao时，访问OrmByHand时出错", ex);
* }
* }
*/
/// <summary>
/// 插入SysAgentInfo
/// </summary>
/// <param name="sysAgentInfo">SysAgentInfo实体对象</param>
/// <returns>新增的主键,如果有多个主键则返回第一个主键</returns>
public long Insert(SysAgentInfo sysAgentInfo)
{
try
{
Object result = baseDao.Insert <SysAgentInfo>(sysAgentInfo);
long iReturn = Convert.ToInt64(result);
return(iReturn);
}
catch (Exception ex)
{
throw new DalException("调用SysAgentInfo时，访问Insert时出错", ex);
}
}
/// <summary>
/// 修改SysAgentInfo
/// </summary>
/// <param name="sysAgentInfo">SysAgentInfo实体对象</param>
/// <returns>状态代码</returns>
public int Update(SysAgentInfo sysAgentInfo)
{
try
{
Object result = baseDao.Update <SysAgentInfo>(sysAgentInfo);
int iReturn = Convert.ToInt32(result);
return(iReturn);
}
catch (Exception ex)
{
throw new DalException("调用SysAgentInfo时，访问Update时出错", ex);
}
}
/// <summary>
/// 检索SysAgentInfo，带翻页
/// </summary>
/// <param name="obj">SysAgentInfo实体对象检索条件</param>
/// <param name="pagesize">每页记录数</param>
/// <param name="pageNo">页码</param>
/// <returns>检索结果</returns>
public IList <SysAgentInfo> GetListByPage(SysAgentInfo obj, int pagesize, int pageNo)
{
try
{
StringBuilder sbSql = new StringBuilder(200);
sbSql.Append(@"select AgentCityId, CreateDate, Id, IsDelete, QQNumber, UserId from SysAgentInfo (nolock) ");
sbSql.Append(" order by Id desc ");
sbSql.Append(string.Format("OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY", (pageNo - 1) * pagesize, pagesize));
IList <SysAgentInfo> list = baseDao.SelectList <SysAgentInfo>(sbSql.ToString());
return(list);
}
catch (Exception ex)
{
throw new DalException("调用SysAgentInfoDao时，访问GetListByPage时出错", ex);
}
}
/// <summary>
/// 删除SysAgentInfo
/// </summary>
/// <param name="sysAgentInfo">SysAgentInfo实体对象</param>
/// <returns>状态代码</returns>
public int Delete(SysAgentInfo sysAgentInfo)
{
try
{
string sql = @"UPdate [SysUser] set [isdelete]=1 where Id=@uid;
Update [SysAgentInfo] set [isdelete]=1 where Id=@id";
StatementParameterCollection parameters = new StatementParameterCollection();
parameters.AddInParameter("@uid", DbType.Int64, sysAgentInfo.UserId);
parameters.AddInParameter("@id", DbType.Int64, sysAgentInfo.Id);
Object result = baseDao.ExecNonQuery(sql, parameters);
int iReturn = Convert.ToInt32(result);
return(iReturn);
}
catch (Exception ex)
{
throw new DalException("调用SysAgentInfo时，访问Delete时出错", ex);
}
}
public static int DeleteAgent(SysAgentInfo entity)
{
return(agentInfoDao.Delete(entity));
}
public static int UpdateAgentInfo(SysAgentInfo entity)
{
return(agentInfoDao.Update(entity));
}
public static long InsertAgentInfo(SysAgentInfo entity)
{
return(agentInfoDao.Insert(entity));
}
