/// <summary>
/// 根据代理商ID获取员工列表（缓存,包含已注销）
/// </summary>
/// <param name="agentid">代理商ID</param>
/// <returns></returns>
public static List<Users> GetUsers(string agentid)
{
if (string.IsNullOrEmpty(agentid))
{
return new List<Users>();
}
if (!Users.ContainsKey(agentid))
{
List<Users> list = new List<CloudSalesEntity.Users>();
DataTable dt = OrganizationDAL.BaseProvider.GetUsers(agentid);
foreach (DataRow dr in dt.Rows)
{
Users model = new Users();
model.FillData(dr);
model.Department = GetDepartmentByID(model.DepartID, agentid);
model.Role = GetRoleByIDCache(model.RoleID, agentid);
list.Add(model);
}
Users.Add(agentid, list);
return list;
}
return Users[agentid].ToList();
}
/// <summary>
/// 根据用户名密码获取会员信息（登录）
/// </summary>
/// <param name="loginname">用户名</param>
/// <param name="pwd">密码</param>
/// <param name="result">1:查询正常；2：用户名不存在；3：用户密码有误</param>
/// <returns></returns>
public static Users GetUserByUserName(string loginname, string pwd,out int result, string operateip)
{
pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, loginname);
DataSet ds = new OrganizationDAL().GetUserByUserName(loginname, pwd, out result);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
model.LogGUID = Guid.NewGuid().ToString();
model.Department = GetDepartmentByID(model.DepartID, model.AgentID);
model.Role = GetRoleByIDCache(model.RoleID, model.AgentID);
//处理缓存
if (!Users.ContainsKey(model.AgentID))
{
GetUsers(model.AgentID);
}
if (Users[model.AgentID].Where(u => u.UserID == model.UserID).Count() == 0)
{
Users[model.AgentID].Add(model);
}
else
{
var user = Users[model.AgentID].Where(u => u.UserID == model.UserID).FirstOrDefault();
user.LogGUID = model.LogGUID;
}
model.Client = Manage.ClientBusiness.GetClientDetail(model.ClientID);
//权限
if (model.Role.IsDefault == 1)
{
model.Menus = CommonBusiness.ClientMenus;
}
else
{
model.Menus = new List<Menu>();
foreach (DataRow dr in ds.Tables["Permission"].Rows)
{
Menu menu = new Menu();
menu.FillData(dr);
model.Menus.Add(menu);
}
}
}
//记录登录日志
if (model != null)
{
LogBusiness.AddLoginLog(loginname, true,Manage.ClientBusiness.GetClientDetail(model.ClientID).AgentID == model.AgentID ? CloudSalesEnum.EnumSystemType.Client : CloudSalesEnum.EnumSystemType.Agent, operateip, model.UserID, model.AgentID, model.ClientID);
}
else
{
LogBusiness.AddLoginLog(loginname, false, CloudSalesEnum.EnumSystemType.Client, operateip, "", "", "");
}
return model;
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <param name="keyWords"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="totalCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public static List<Users> GetUsers(string keyWords, string departID, string roleID, string agentid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
string whereSql = "AgentID='" + agentid + "' and Status<>9";
if (!string.IsNullOrEmpty(keyWords))
whereSql += " and ( Name like '%" + keyWords + "%' or MobilePhone like '%" + keyWords + "%' or Email like '%" + keyWords + "%')";
if (!string.IsNullOrEmpty(departID))
whereSql += " and DepartID='" + departID + "'";
if (!string.IsNullOrEmpty(roleID))
whereSql += " and RoleID='" + roleID + "'";
DataTable dt = CommonBusiness.GetPagerData("Users", "*", whereSql, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List<Users> list = new List<Users>();
Users model;
foreach (DataRow item in dt.Rows)
{
model = new Users();
model.FillData(item);
model.CreateUser = GetUserByUserID(model.CreateUserID, model.AgentID);
model.Department = GetDepartmentByID(model.DepartID, model.AgentID);
model.Role = GetRoleByIDCache(model.RoleID, model.AgentID);
list.Add(model);
}
return list;
}
/// <summary>
/// 添加员工
/// </summary>
/// <param name="loginname">登录名</param>
/// <param name="loginpwd">密码</param>
/// <param name="name">姓名</param>
/// <param name="mobile">手机</param>
/// <param name="email">邮箱</param>
/// <param name="citycode">城市</param>
/// <param name="address">地址</param>
/// <param name="jobs">职位</param>
/// <param name="roleid">角色ID</param>
/// <param name="departid">部门ID</param>
/// <param name="parentid">上级ID</param>
/// <param name="agentid">代理商ID></param>
/// <param name="clientid">客户端ID</param>
/// <param name="mduserid">明道用户ID</param>
/// <param name="mdprojectid">明道网络ID</param>
/// <param name="isAppAdmin">是否应用管理员</param>
/// <param name="operateid">操作人</param>
/// <param name="result">返回结果 0 失败 1成功 2账号已存在 3人数达到限制</param>
/// <returns></returns>
public static Users CreateUser(string loginname, string loginpwd, string name, string mobile, string email, string citycode, string address, string jobs,
string roleid, string departid, string parentid, string agentid, string clientid, string mduserid, string mdprojectid, int isAppAdmin, string operateid, out int result)
{
string userid = Guid.NewGuid().ToString();
loginpwd = CloudSalesTool.Encrypt.GetEncryptPwd(loginpwd, loginname);
Users user = null;
DataTable dt = OrganizationDAL.BaseProvider.CreateUser(userid, loginname, loginpwd, name, mobile, email, citycode, address, jobs, roleid, departid, parentid, agentid, clientid, mduserid, mdprojectid, isAppAdmin, operateid, out result);
if (dt.Rows.Count > 0)
{
user = new Users();
user.FillData(dt.Rows[0]);
var cache = GetUsers(user.AgentID).Where(m => m.UserID == user.UserID).FirstOrDefault();
if (cache == null || string.IsNullOrEmpty(cache.UserID))
{
user.Role = GetRoleByID(user.RoleID, user.AgentID);
user.Department = GetDepartmentByID(user.DepartID, user.AgentID);
Users[user.AgentID].Add(user);
}
else
{
cache.Status = 1;
}
//日志
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.User, EnumLogType.Create, "", operateid, agentid, clientid);
}
return user;
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="userid"></param>
/// <param name="agentid"></param>
/// <returns></returns>
public static Users GetUserByUserID(string userid, string agentid)
{
if (string.IsNullOrEmpty(userid) || string.IsNullOrEmpty(agentid))
{
return null;
}
var list = GetUsers(agentid);
if (list.Where(u => u.UserID == userid).Count() > 0)
{
return list.Where(u => u.UserID == userid).FirstOrDefault();
}
else
{
DataTable dt = new OrganizationDAL().GetUserByUserID(userid);
Users model = new Users();
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
model.Department = GetDepartmentByID(model.DepartID, agentid);
model.Role = GetRoleByIDCache(model.RoleID, agentid);
Users[agentid].Add(model);
}
return model;
}
}
/// <summary>
/// 获取用户信息(缓存)
/// </summary>
/// <param name="userid"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public static Users GetUserByUserID(string userid, string clientid)
{
if (!Users.ContainsKey(clientid))
{
Users.Add(clientid, new List<Users>());
}
if (Users[clientid].Where(u => u.UserID == userid).Count() > 0)
{
return Users[clientid].Where(u => u.UserID == userid).FirstOrDefault();
}
else
{
DataTable dt = new OrganizationDAL().GetUserByUserID(userid);
Users model = new Users();
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
Users[clientid].Add(model);
}
return model;
}
}
/// <summary>
/// 根据用户名密码获取会员信息（登录）
/// </summary>
/// <param name="loginname">用户名</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public static Users GetUserByUserName(string loginname, string pwd, string operateip)
{
pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, loginname);
DataSet ds = new OrganizationDAL().GetUserByUserName(loginname, pwd);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
if (CommonCache.ClientMenus.ContainsKey(model.ClientID))
{
model.Menus = CommonCache.ClientMenus[model.ClientID];
}
else if (ds.Tables.Contains("Modules"))
{
List<Menu> list = new List<Menu>();
var modules = CommonCache.Modules;
foreach (DataRow dr in ds.Tables["Modules"].Rows)
{
Modules module = new Modules();
module.FillData(dr);
if (modules.ContainsKey(module.ModulesID))
{
foreach (var item in modules[module.ModulesID])
{
if (list.Where(m => m.MenuCode == item.MenuCode).Count() == 0)
{
list.Add(item);
}
}
}
}
list = list.OrderBy(m => m.Sort).ToList();
CommonCache.ClientMenus.Add(model.ClientID, list);
model.Menus = list;
}
}
//记录登录日志
LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Client, operateip);
return model;
}
/// <summary>
/// 根据用户名密码获取会员信息（登录）
/// </summary>
/// <param name="loginname">用户名</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public static Users GetUserByUserName(string loginname, string pwd, string operateip)
{
pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, loginname);
DataSet ds = new OrganizationDAL().GetUserByUserName(loginname, pwd);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
model.Menus = CommonBusiness.ClientMenus;
}
//记录登录日志
LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Client, operateip);
return model;
}
public static Users GetUserByMDUserID(string mduserid, string mdprojectid, string operateip)
{
DataSet ds = new OrganizationDAL().GetUserByMDUserID(mduserid,mdprojectid);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
model.LogGUID = Guid.NewGuid().ToString();
model.Department = GetDepartmentByID(model.DepartID, model.AgentID);
model.Role = GetRoleByIDCache(model.RoleID, model.AgentID);
model.Agents = AgentsBusiness.GetAgentDetail(model.AgentID);
model.Client = Manage.ClientBusiness.GetClientDetail(model.ClientID);
//处理缓存
if (!Users.ContainsKey(model.AgentID))
{
GetUsers(model.AgentID);
}
if (Users[model.AgentID].Where(u => u.UserID == model.UserID).Count() == 0)
{
Users[model.AgentID].Add(model);
}
else
{
var user = Users[model.AgentID].Where(u => u.UserID == model.UserID).FirstOrDefault();
user.LogGUID = model.LogGUID;
}
//权限
if (model.Role != null && model.Role.IsDefault == 1)
{
model.Menus = CommonBusiness.ClientMenus;
}
else
{
model.Menus = new List<Menu>();
foreach (DataRow dr in ds.Tables["Permission"].Rows)
{
Menu menu = new Menu();
menu.FillData(dr);
model.Menus.Add(menu);
}
}
}
if (string.IsNullOrEmpty(operateip))
{
operateip = "";
}
//记录登录日志
if (model != null)
{
LogBusiness.AddLoginLog(mduserid, true, Manage.ClientBusiness.GetClientDetail(model.ClientID).AgentID == model.AgentID ? CloudSalesEnum.EnumSystemType.Client : CloudSalesEnum.EnumSystemType.Agent, operateip, model.UserID, model.AgentID, model.ClientID);
}
else
{
LogBusiness.AddLoginLog(mduserid, false, CloudSalesEnum.EnumSystemType.Client, operateip, "", "", "");
}
return model;
}
/// <summary>
/// 根据明道用户ID和网络ID获取云销用户信息（登录）
/// </summary>
/// <param name="mduserid"></param>
/// <param name="mdprojectid"></param>
/// <returns></returns>
public static Users GetUserByMDUserID(string mduserid, string mdprojectid, string operateip)
{
DataSet ds = new OrganizationDAL().GetUserByMDUserID(mduserid);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
model.Department = GetDepartmentByID(model.DepartID, model.AgentID);
model.Role = GetRoleByIDCache(model.RoleID, model.AgentID);
model.Menus = CommonBusiness.ClientMenus;
//处理缓存
if (!Users.ContainsKey(model.AgentID))
{
GetUsers(model.AgentID);
}
if (Users[model.AgentID].Where(u => u.MDUserID == mduserid).Count() == 0)
{
Users[model.AgentID].Add(model);
}
}
if (!string.IsNullOrEmpty(operateip))
{
//记录登录日志
LogBusiness.AddLoginLog(mduserid, model != null, CloudSalesEnum.EnumSystemType.Client, operateip);
}
return model;
}