/// <summary> /// 插入用户 /// </summary> /// <param name="db"></param> /// <param name="data"></param> /// <param name="department_id"></param> /// <returns></returns> public static async Task <int> AddUser(DBHelper db, AddUserIn data, int department_id) { t_user user = new t_user { department_id = department_id, position_id = int.Parse(data.position_id), real_name = data.name, user_name = data.user_name }; string sql = @"INSERT t_user(department_id,position_id,real_name,user_name) VALUES(@department_id,@position_id,@real_name,@user_name); SELECT LAST_INSERT_ID();"; return(await db.ExecAsync <int>(sql, user)); }
/// <summary> /// 验证添加用户数据 /// </summary> /// <param name="data"></param> /// <returns></returns> private async Task <Result> VerifyAddUser(AddUserIn data) { Result result = new Result(); if (data == null) { result.msg = "参数错误"; return(result); } if (string.IsNullOrWhiteSpace(data.name?.Trim())) { result.msg = "姓名不能为空"; return(result); } data.name = data.name?.Trim(); if (!VerifyCommon.Name(data.name)) { result.msg = "姓名只能为中文"; return(result); } if (data.name.Length < 2 || data.name.Length > 4) { result.msg = "姓名只能为2-4个字符"; return(result); } if (string.IsNullOrWhiteSpace(data.user_name?.Trim())) { result.msg = "用户名不能为空"; return(result); } data.user_name = data.user_name?.Trim(); if (!VerifyCommon.UserName(data.user_name)) { result.msg = "用户名只能由英文、数字、下划线组成"; return(result); } if (data.user_name.Length < 5 || data.user_name.Length > 12) { result.msg = "用户名只能为5-12个字符"; return(result); } if (string.IsNullOrWhiteSpace(data.password?.Trim())) { result.msg = "密码不能为空"; return(result); } data.password = data.password?.Trim(); if (!VerifyCommon.Password(data.password)) { result.msg = "密码只能由英文、数字、下划线组成"; return(result); } if (data.password.Length < 6 || data.password.Length > 18) { result.msg = "密码只能为6-18个字符"; return(result); } if (string.IsNullOrWhiteSpace(data.position_id?.Trim())) { result.msg = "请填写职位"; return(result); } if (!int.TryParse(data.position_id, out int position_id) || position_id <= 0) { result.msg = "职位信息错误"; return(result); } DBHelper db = new DBHelper(); bool position_exist_flag = await PositionDao.IsExist(db, position_id); db.Close(); if (!position_exist_flag) { result.msg = "职位不存在"; return(result); } result.result = true; return(result); }
public async Task <IActionResult> AddUser([FromBody] AddUserIn model) { return(await userApp.AddUser(await Package(model))); }