internal ActionResult SaveUser(UserMTRModel model, string accountID)
{
return(DoSecurity <ActionResult, string>((result, sqlConn) =>
{
var cmd = sqlConn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "cuUserMTR_C2018";
if (string.IsNullOrEmpty(model.ID) == false)
{
cmd.Parameters.Add(GetSqlParameter("ID", model.ID));
}
cmd.Parameters.Add(GetSqlParameter("LoginAccount", model.LoginAccount));
cmd.Parameters.Add(GetSqlParameter("UserName", model.UserName));
cmd.Parameters.Add(GetSqlParameter("UploadAccount", model.UploadAccount));
cmd.Parameters.Add(GetSqlParameter("Password", EML.Util.CryptUtil.Encrypt("123456")));
cmd.Parameters.Add(GetSqlParameter("CreatorID", accountID));
cmd.Parameters.Add(GetSqlParameter("Effectiveness", model.Effectiveness));
cmd.Parameters.Add(new SqlParameter("UserRoleTable", toTable(model.Roles)));
cmd.Parameters.Add(new SqlParameter("UserLocationTable", toTable(model.Locations)));
cmd.ExecuteNonQuery();
result.Pass();
}));
}
public ActionResult SaveUser(UserMTRModel model, string accountID)
{
return(dal.SaveUser(model, accountID));
}
