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