nonesale post/detail-inside - Chi tiết bài viết (web-admin)

 

Tầng Puplic
Trang web , detail Post bài viết

http://saleplatform-stag.fpt.net/web-admin/post/detail?PostId=23

http://saleplatform.fpt.net/web-admin/post/detail?PostId=23

Tầng Core

{{domain}}/utility/api/v1.0/post/detail-inside

{

  "PostId": 139,

  "SaleTeamId": -1

}

{

    "Code": 200,

    "Message": {

        "Message": "Thành công.",

        "ExMessage": null

    },

    "Data": {

        "SaleTeamId": [

            ""

        ],

        "Status": 1,

        "Content": "<p>sss</p>",

        "ShortDescription": "sss",

        "CreatedDate": "11/11/2022 10:19:14",

        "CreatedBy": "thongnm12",

        "UpdatedBy": "isc.vudh",

        "UpdatedDate": "11/11/2022 15:34:59",

        "Id": 139,

        "Title": "sss123",

        "Image": "https://hi-static.fpt.vn/sys/mobisalevn/dev/images/posts/11_11_2022_10_21_47_bot.png",

        "DateAvalible": "11/02/2022 00:00:00",

        "ExpirationDate": "11/16/2030 00:00:00",

        "SortOrder": 2,

        "Type": 2

    }

}

Câu lệnh SQL C# trên Utility

SELECT p.ID,

            p.Title,

            p.Content,

            p.ShortDescription,

            p.Image,

            p.DateAvalible,

            p.ExpirationDate,

            p.SortOrder,

            p.Status,

            p.SaleTeamID,

            p.CreatedBy,

            p.CreatedDate,

            p.UpdatedBy,

            p.UpdatedDate,

            p.Type

            FROM SalePlatform..SPF_Post(nolock) p 

            WHERE p.ID = @pPostId 

            AND (

            ((',' + RTRIM(p.SaleTeamID) + ',')  LIKE '%,'+CAST(@pSaleTeamId as varchar(5))+',%' )

            OR p.SaleTeamID = ''

            OR @pSaleTeamId =-1

            )