using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MMDAL.Query.Store
{
    public static class StoreQB
    {
        public const string GET_SELECTLIST_STORE = @"SELECT
                                                    a.STOREID   AS Id,
                                                    a.STORECODE AS Code,
                                                    a.STORENAME AS Name
                                                FROM MSTORE a";

        public const string GET_STORE_BASED_ON_APPLICABLE_STORE_BIZTYPE = @"
SELECT
    a.STOREID   AS Id,
    a.STORECODE AS Code,
    a.STORENAME AS Name
FROM MSTORE a
INNER JOIN MBIZTRANSACTIONTYPE b
    ON b.BIZTRANSACTIONTYPEID = @BizTransactionTypeId
CROSS APPLY
(
    SELECT data
    FROM comma2row(b.APPLICABLESTOREIDS)
) c
WHERE
    (
        b.APPLICABLESTOREIDS = '-1'
        OR a.STOREID = c.data
    )
";
    }


}