/*******************************************************************************************************/
internal DicParam OnDic(ColumnParam cp1, ColumnParam cp2)
{
var dic = SetDicBase(DC);
dic.TbMType = cp1.TbMType;
dic.TbCol = cp1.Key;
dic.TbAlias = cp1.Alias;
dic.ColumnTwo = cp2.Key;
dic.TableAliasTwo = cp2.Alias;
return(dic);
}
/*******************************************************************************************************/
internal DicParam SelectMemberInitDic(ColumnParam cp, string colAlias)
{
var dic = SetDicBase(DC);
dic.TbMType = cp.TbMType;
dic.TbAlias = cp.Alias;
dic.TbMProp = cp.Prop;
dic.TbCol = GetCol(cp.TbMType, cp.Key); // cp.Key;
dic.TbColAlias = colAlias;
return(dic);
}
internal DicParam ColumnDic(ColumnParam cp)
{
var dic = SetDicBase(DC);
dic.TbMType = cp.TbMType;
dic.TbAlias = cp.Alias;
dic.TbCol = GetCol(cp.TbMType, cp.Key); // cp.Key;
dic.Param = cp.Key;
dic.ParamRaw = cp.Key;
dic.TbMProp = cp.Prop;
return(dic);
}
private DicParam BoolDefaultCondition(ColumnParam cp)
{
if (cp.ValType == XConfig.CSTC.Bool ||
cp.ValType == XConfig.CSTC.BoolNull)
{
DC.Option = OptionEnum.Compare;
DC.Compare = CompareXEnum.Equal;
return(DC.DPH.CompareDic(cp, new ValueInfo
{
Val = true.ToString(),
ValStr = string.Empty
}));
}
return(null);
}
internal DicParam IsNullDic(ColumnParam cp)
{
var dic = SetDicBase(DC);
dic.TbMType = cp.TbMType;
dic.TbMProp = cp.Prop;
dic.TbCol = GetCol(cp.TbMType, cp.Key); // cp.Key;
dic.TbAlias = cp.Alias;
dic.Param = cp.Key;
dic.ParamRaw = cp.Key;
dic.CsValue = null;
dic.CsValueStr = string.Empty;
dic.CsType = cp.ValType;
return(dic);
}
internal DicParam LikeDic(ColumnParam cp, ValueInfo v)
{
var dic = SetDicBase(DC);
dic.TbMType = cp.TbMType;
dic.TbMProp = cp.Prop;
dic.TbCol = GetCol(cp.TbMType, cp.Key); // cp.Key;
dic.TbAlias = cp.Alias;
dic.CsValue = v?.Val;
dic.CsValueStr = v?.ValStr;
dic.CsType = cp.ValType;
dic.Param = cp.Key;
dic.ParamRaw = cp.Key;
return(dic);
}
/*******************************************************************************************************/
internal DicParam CharLengthDic(ColumnParam cp, (object val, string valStr) value)
