/// <summary>
/// 用户批量添加角色
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <param name="UserId">模用户主键</param>
/// <param name="CreateUserId">操作用户主键</param>
/// <param name="CreateUserName">操作用户</param>
/// <returns></returns>
public int BatchAddUserRole(string[] KeyValue, string UserId, string CreateUserId, string CreateUserName)
{
StringBuilder[] sqls = new StringBuilder[KeyValue.Length + 1];
object[] objs = new object[KeyValue.Length + 1];
sqls[0] = DbCommon.DeleteSql("BPMS_UserRole", "UserId");
objs[0] = new SqlParam[] { new SqlParam("@UserId", UserId) };
int index = 1;
foreach (string item in KeyValue)
{
if (item.Length > 0)
{
BPMS_UserRole entity = new BPMS_UserRole();
entity.UserRoleId = CommonHelper.GetGuid;
entity.UserId = UserId;
entity.RoleId = item;
entity.CreateUserId = CreateUserId;
entity.CreateUserName = CreateUserName;
sqls[index] = DbCommon.InsertSql(entity);
objs[index] = DbCommon.GetParameter(entity);
index++;
}
}
return(DataFactory.SqlHelper().BatchExecuteBySql(sqls, objs));
}
/// <summary>
/// 批量添加角色成员
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <param name="RoleId">角色主键</param>
/// <param name="CreateUserId">操作用户主键</param>
/// <param name="CreateUserName">操作用户</param>
/// <returns></returns>
public int BatchAddMember(string[] KeyValue, string RoleId, string CreateUserId, string CreateUserName)
{
StringBuilder[] sqls = new StringBuilder[KeyValue.Length];
object[] objs = new object[KeyValue.Length];
int index = 0;
foreach (string item in KeyValue)
{
if (item.Length > 0)
{
BPMS_UserRole entity = new BPMS_UserRole();
entity.UserRoleId = CommonHelper.GetGuid;
entity.RoleId = RoleId;
entity.UserId = item;
entity.CreateUserId = CreateUserId;
entity.CreateUserName = CreateUserName;
sqls[index] = DbCommon.InsertSql(entity);
objs[index] = DbCommon.GetParameter(entity);
index++;
}
}
return(DataFactory.SqlHelper().BatchExecuteBySql(sqls, objs));
}
