[HttpPost]//保存new user
public string Save(string json)
{
JsonObject obj = new JsonObject(json);
var roleid = decimal.Parse(obj["roleid"].Value.ToString());
var userid1 = decimal.Parse(obj["phone"].Value.ToString());
var phone = obj["phone"].Value.ToString();
string exname1 = obj["username"].Value.ToString();
string userpwd1 = obj["loginpwd"].Value.ToString();
System.DateTime com_starttime = new System.DateTime();
com_starttime = DateTime.Now;
try
{
using (var db = new NCtecanEntities())
{
var uuser = db.dl_basic_users.FirstOrDefault(x => x.userid == userid1 && x.isDel == false);
if (uuser == null)
{
var user = new dl_basic_users()
{
userid = userid1,
exname = exname1,
userpwd = userpwd1,
jointime = com_starttime,
userphone = phone,
username = exname1,
isDel = false
};
db.dl_basic_users.Add(user);
db.SaveChanges();
var nuser = new sys_user_role()
{
userid = user.userid,
rid = roleid
};
db.sys_user_role.Add(nuser);
db.SaveChanges();
return("success");
}
else
{
return("existed");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 根据用户名获取用户角色（目前只支持单用户单角色）
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public string GetRoleByUserName(string userName)
{
string roleCode = string.Empty;
try
{
sys_user sys_user = _sysUserService.GetModels(a => a.username == userName).SingleOrDefault();
sys_user_role sys_user_role = _sysUserRoleService.GetModels(a => a.user_id == sys_user.id).SingleOrDefault();
sys_role sys_role = _baseSysRoleService.GetModels(a => a.id == sys_user_role.role_id && a.status == false).SingleOrDefault();
roleCode = sys_role.role_code;
}
catch (Exception ex)
{
throw new CustomException(500, "用户角色不存在或角色已被禁用");
}
return(roleCode);
}
public int InsertUserRoleIds(int userId, List <int> checkedIds)
{
var sysUserRoles = new List <sys_user_role>();
foreach (var item in checkedIds)
{
var sysUserRole = new sys_user_role
{
user_id = userId,
role_id = item
};
sysUserRoles.Add(sysUserRole);
}
_context.Set <sys_user_role>().AddRange(sysUserRoles);
return(checkedIds.Count);
//string sql = string.Empty;
//foreach (var checkedId in checkedIds)
//{
// sql += $"INSERT INTO sys_user_role (role_id, user_id) VALUES({checkedId}, {userId});";
//}
//return _context.Database.ExecuteSqlRaw(sql);
}
