public static bool DeleteByGroupSysid(RightLkUserGroup rightLkUserGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
DELETE FROM T_RIGHT_LK_USER_GROUP
WHERE GROUP_SYSID=@GroupSysid
";
return(Dapper.Save(rightLkUserGroup, sql, conn, trans));
}
public static bool Insert(RightLkUserGroup rightLkUserGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
INSERT INTO T_RIGHT_LK_USER_GROUP(GROUP_SYSID,USER_SYSID)
VALUES(@GroupSysid,@UserSysid)
";
return Dapper.Save(rightLkUserGroup, sql, conn, trans);
}
public static bool Insert(RightLkUserGroup rightLkUserGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
INSERT INTO T_RIGHT_LK_USER_GROUP(GROUP_SYSID,USER_SYSID)
VALUES(@GroupSysid,@UserSysid)
";
return(Dapper.Save(rightLkUserGroup, sql, conn, trans));
}
public static bool DeleteByUserSysid(RightLkUserGroup rightLkUserGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
DELETE FROM T_RIGHT_LK_USER_GROUP
WHERE USER_SYSID=@UserSysid
";
return Dapper.Save(rightLkUserGroup, sql, conn, trans);
}
//构造新增的数据
/// <summary>
/// 构造新增的数据
/// </summary>
private List<RightLkUserGroup> BuildInsertEntity()
{
var lstRightLkUserGroup = new List<RightLkUserGroup>();
var groupSysid = UI.GetValue(ddlUserGroup);
for (var i = 0; i < SelectedUsers.Count; i++)
{
var rightUser = SelectedUsers[i];
var findInDb = _selectedUsersInDb.FindAll(p => p.Sysid == rightUser.Sysid);
if (findInDb.Count > 0)
continue;
var rightLkUserGroup = new RightLkUserGroup
{
GroupSysid = groupSysid,
UserSysid = rightUser.Sysid
};
lstRightLkUserGroup.Add(rightLkUserGroup);
}
return lstRightLkUserGroup;
}