public static bool Delete(RightLkFunctionGroup rightLKFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
DELETE FROM T_RIGHT
WHERE FUNCTION_SYSID=@FunctionSysid
AND FUNCTION_GROUP_SYSID=@GroupSysid ";
return(Dapper.Save(rightLKFunctionGroup, sql, conn, trans));
}
public static bool Insert(RightLkFunctionGroup rightLkFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
INSERT INTO T_RIGHT_LK_FUNCTION_GROUP(GROUP_SYSID,FUNCTION_SYSID,SEQUENCE)
VALUES(@GroupSysid,@FunctionSysid,@Sequence)
";
return(Dapper.Save(rightLkFunctionGroup, sql, conn, trans));
}
public static bool Update(RightLkFunctionGroup rightLkFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
UPDATE T_RIGHT_LK_FUNCTION_GROUP
SET SEQUENCE=@Sequence
WHERE GROUP_SYSID=@GroupSysid AND FUNCTION_SYSID=@FunctionSysid
";
return(Dapper.Save(rightLkFunctionGroup, sql, conn, trans));
}