예제 #1
0
        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));
        }
예제 #2
0
        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));
        }
예제 #3
0
        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));
        }