You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
55 lines
1.9 KiB
55 lines
1.9 KiB
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;
|
|
}
|
|
}
|
|
}
|