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