namespace CounsellorBL.PRD.ConstDefinition
{
    using OT.COM.ArsenalDB;
    using OT.COM.ArsenalDB.SQL;
    using SoldierData.EnterprizeV4;


    internal class PrdSQLLib : DirectSQLLibBase
    {
        public PrdSQLLib(ADirectSQLHelper i_sqlLibBase) : base(i_sqlLibBase) { }

        public virtual string GetArticleProduct(string i_sArticleUid, out Command o_cResult)
        {
            ADirectCmdParameter cp = GetParamter();

            string sSQL = $@"SELECT a.{tb_prd_product.CN_UID}
                , a.{tb_prd_product.CN_NAME}
                , a.{tb_prd_product.CN_MEMO}
                , b.{tb_prd_article2product.CN_WHOLESALE_PRICE}
                , b.{tb_prd_article2product.CN_PRICE}
                , b.{tb_prd_article2product.CN_SEQ}
                , b.{tb_prd_article2product.CN_SPECIFICATION}
                FROM {GetFormalTableName<tb_prd_product>()} a
                LEFT JOIN {GetFormalTableName<tb_prd_article2product>()} b
                on a.{tb_prd_product.CN_UID} = b.{tb_prd_article2product.CN_PRD_UID}
                where b.{tb_prd_article2product.CN_ARTICLE_UID} = {cp.Add(i_sArticleUid)} 
                order by b.{tb_prd_article2product.CN_SEQ}";

            return GenerateCommand<tb_prd_product>(sSQL, cp, out o_cResult);
        }
    }
}