namespace CounsellorBL.Helper
{
    using MonumentDefine;
    using OT.COM.ArsenalDB;
    using SoldierData.EnterprizeV4;
    using System.Collections.Generic;

    public class ParameterHelper : DBService
    {
        public override string MainTable => typeof(tb_sys_param).Name;

        public static string FetchByParamcatalog(string i_sParamCatelog, out List<tb_sys_param> o_lp)
        {
            string sMsg = null;

            List<tb_sys_param> lp = null;

            do
            {

                QueryJsonElementCollection lBlocks = new QueryJsonElementCollection();
                QueryJsonElement qjeA = lBlocks.GetInst();
                qjeA.table = tb_sys_paramcatalog.TABLENAME;
                qjeA.wherecols = WhereNode.GenNode<tb_sys_paramcatalog>(f => f.name == i_sParamCatelog && f.status_flag == BLWording.STATUS_FLAG_ON);
                lBlocks.Add(qjeA);

                QueryJsonElement qjeB = lBlocks.GetInst();
                qjeB.table = tb_sys_param.TABLENAME;
                qjeB.displaycols = EntityBase.GetAllColumnName(typeof(tb_sys_param));
                qjeB.wherecols = WhereNode.GenNode<tb_sys_param>(f => f.status_flag == BLWording.STATUS_FLAG_ON);
                qjeB.jointype = QueryJsonElement.LEFT_JOIN;
                qjeB.jointable = qjeA;
                qjeB.joincols = new Dictionary<string, string>() {
                        {tb_sys_param.CN_PARAMCATALOG,tb_sys_paramcatalog.CN_UID }
                    };
                lBlocks.Add(qjeB);

                sMsg = MakeSelectJoinByBlocks(lBlocks, out Command cSelect);

                ArsenalInterface ai = ArsenalDBMgr.GetInst(cSelect);

                lp = ai.RunQueryList<tb_sys_param>(cSelect);

                if (!cSelect.IsSuccess)
                {
                    sMsg = cSelect.LastErrorCode;
                }
            }
            while (false);

            o_lp = lp;
            return sMsg;
        }
    }
}