public CommandResult AddUser(EAP_User user) { if (string.IsNullOrEmpty(user.Password)) { user.Password = DESEncrypt.Encrypt("123456"); } CommandResult result = new CommandResult(); result.Result = false; /* * string sFields = ""; * string sValues = ""; * * if (user.Items.Count <= 0) * { * return result; * } * * user.Items.ForEach(e => * { * if (e.K != "ID" && e.K != "Org_Name") * { * if (!string.IsNullOrEmpty(e.K) && e.S == EntityStatus.New && !e.K.EndsWith("_G")) * { * sFields += string.Format("[{0}],", e.K); * sValues += string.Format("'{0}',", e.V); * } * } * }); * * string sSql = string.Format( * "INSERT INTO EAP_User({0}) VALUES({1});SELECT CAST(scope_identity() AS int);", * sFields.Trim().TrimEnd(','), * sValues.Trim().TrimEnd(',')); * * int iPID = DataProvider.ExecuteScalar<int>(sSql); */ List <string> _fns = new List <string> (); _fns.Add("Org_Name"); int iPID = DataProvider.DoInsert(user, "EAP_USER", true, _fns); if (iPID > 0) { result.Result = true; result.ReturnValue.Add(new LookupDataItem() { K = "ID", V = iPID.ToString() }); result.Message = "新增成功。"; } else { result.Result = false; result.Message = "新增失败。"; } return(result); }
public CommandResult AddRoleToUser(EAP_User user, string sRoleIDs) { CommandResult result = new CommandResult(); string[] arrayRoleID = sRoleIDs.Split(','); string sSql = ""; try { for (int i = 0; i < arrayRoleID.Length; i++) { /* * sSql = string.Format("INSERT INTO EAP_UserRole([UserID],[RoleID],[AddBy],[AddOn]) values('{0}','{1}','{2}','{3}');SELECT CAST(scope_identity() AS int);", * user.ID, arrayRoleID[i], Account.User.UserName, DateTime.Now); * * DataProvider.ExecuteScalar<int>(sSql); */ SerializableData _sd = new SerializableData(); _sd.SetInt32("USERID", user.ID); _sd.SetString("ROLEID", arrayRoleID[i]); _sd.SetString("ADDBY", Account.User.UserName); int iPID = DataProvider.DoInsert(_sd, "EAP_UserRole", true, null); if (iPID <= 0) { throw new Exception("保存失败。" + _sd.ToJson()); } } result.Result = true; result.Message = "添加成功。"; return(result); } catch { result.Result = false; result.Message = "数据库操作失败,参考Sql: " + sSql; return(result); } }
public CommandResult AddRole(EAP_Role role) { CommandResult result = new CommandResult(); result.Result = false; string sFields = ""; string sValues = ""; if (role.Items.Count <= 0) { return(result); } /* * role.Items.ForEach(e => * { * if (!string.IsNullOrEmpty(e.K) && e.S == EntityStatus.New) * { * sFields += string.Format("[{0}],", e.K); * sValues += string.Format("'{0}',", e.V); * } * }); * */ string sql = string.Format("select count(*) from EAP_Role where RoleName='{0}'", role.RoleName); /* * string sSql = string.Format( * "INSERT INTO EAP_Role({0}) VALUES({1});SELECT CAST(scope_identity() AS int);", * sFields.Trim().TrimEnd(','), * sValues.Trim().TrimEnd(',')); * int count = DataProvider.ExecuteScalar<int>(sql); */ int count = (int)DataProvider.ExecuteScalar <decimal>(sql); if (count <= 0) { // int iPID = DataProvider.ExecuteScalar<int>(sSql); int iPID = DataProvider.DoInsert(role, "EAP_Role", true, null); if (iPID > 0) { result.Result = true; result.ReturnValue.Add(new LookupDataItem() { K = "ID", V = iPID.ToString() }); result.Message = "新增成功。"; } else { result.Result = false; result.Message = "新增失败。"; } } else { result.Result = false; result.IntResult = 1; result.Message = "该角色已经存在。"; } return(result); }