protected override string GetFieldFunction(Irowsource qualifier, selectfield f, bool aliasthis)
{
string sx;
switch (f.Function.func)
{
case selectfunctiondef.lpad:
// LPad(field,length,'0')
sx = String.Format("LPAD({0},{1},'{2}')", GetQualifiedFieldname(qualifier, f, true), f.PaddingLength, f.PaddingChar);
break;
case selectfunctiondef.ft_rownumber:
/* introduced [dlatikay 20110922] for fulltext search */
sx = String.Format("MATCH(Chunk) AGAINST (?token)");
break;
default:
return(base.GetFieldFunction(qualifier, f, aliasthis));
}
/* finalize */
if (f.AsName != null && f.AsName.Length > 0)
{
return(sx + " AS " + QuoteFieldname(f.AsName));
}
else if (aliasthis)
{
return(sx + " AS " + QuoteFieldname(f.Fieldname));
}
else
{
return(sx);
}
}
protected override string GetFieldFunction(Irowsource qualifier, selectfield f, bool aliasthis)
{
string sx;
switch (f.Function.func)
{
case selectfunctiondef.lpad:
// RIGHT(REPLICATE(N'0',18)+field1,18)
sx = String.Format("RIGHT(REPLICATE(N'{1}',{0})+{2},{3})", f.PaddingLength, f.PaddingChar, GetQualifiedFieldname(qualifier, f, true), f.PaddingLength);
break;
case selectfunctiondef.month:
/* [dlatikay 20110613] */
sx = String.Format("DATEPART(month,{0})", GetQualifiedFieldname(qualifier, f, true));
break;
case selectfunctiondef.year:
/* [dlatikay 20161021] */
sx = String.Format("DATEPART(year,{0})", GetQualifiedFieldname(qualifier, f, true));
break;
case selectfunctiondef.hour:
/* [dlatikay 20110613] */
sx = String.Format("DATEPART(hour,{0})", GetQualifiedFieldname(qualifier, f, true));
break;
case selectfunctiondef.quarter:
/* [dlatikay 20110613] */
sx = String.Format("DATEPART(quarter,{0})", GetQualifiedFieldname(qualifier, f, true));
break;
case selectfunctiondef.dayofweek:
/* [dlatikay 20110613] */
sx = String.Format("DATEPART(dw,{0})", GetQualifiedFieldname(qualifier, f, true)); /* ranging 1-7 */
break;
case selectfunctiondef.ft_rownumber:
/* introduced [dlatikay 20110922] for fulltext search */
sx = String.Format("ROW_NUMBER() OVER (ORDER BY F1.RANK DESC)"); /* DL90384902390423942HJHJ394839 */
RegisterParameter(new selectparam(db.MakeParamName("Token"), DbType.StringFixedLength, 255)); /* DL9284293042JJHJJ9899 for reason why this is here */
break;
default:
return(base.GetFieldFunction(qualifier, f, aliasthis));
}
/* qualifier/asname logic */
if (f.AsName != null && f.AsName.Length > 0)
{
return(sx + " AS " + QuoteFieldname(f.AsName));
}
else if (aliasthis)
{
return(sx + " AS " + QuoteFieldname(f.Fieldname));
}
else
{
return(sx);
}
}
public static selectfield SortByAlreadyDefinedField(selectfield fld, sortorder order)
{
var sortfield = fld.Clone();
sortfield.Ascending = order == sortorder.so_asc;
sortfield.Descending = order == sortorder.so_desc;
return(sortfield);
}
public param(selectparam parm)
{
field = parm;
}
public param(string name)
{
field = new selectfield(selectfunctiondef.param, name);
}
public operand(string fld)
{
field = new selectfield(fld);
}
public operand(selectfield fld)
{
field = fld;
}
protected override string GetFieldFunction(Irowsource qualifier, selectfield f, bool aliasthis)
{
string sx;
switch (f.Function.func)
{
case selectfunctiondef.lpad:
// LPad(field,length,'0')
sx = String.Format("LPad({0},{1},'{2}')", GetQualifiedFieldname(qualifier, f, true), f.PaddingLength, f.PaddingChar);
break;
case selectfunctiondef.sp_hoursworked1:
/* added [dlatikay 20101124]:
* cast(sum(hw.hoursworked/(to_date('01/'|| to_char(hw.calendarmonth+1) ||'/' || hw.calendaryear,'dd/mm/yyyy')-to_date('01/'|| hw.calendarmonth ||'/' || hw.calendaryear,'dd/mm/yyyy'))) as number(9,0))
* cast(sum({0}/(to_char(LAST_DAY(to_date('01/'|| CalendarMonth ||'/' || CalendarYear,'dd/mm/yyyy')),'DD'))) as number(9,0)) AS HoursWorked */
sx = String.Format("cast(sum({0}/(to_char(LAST_DAY(to_date('01/'|| CalendarMonth ||'/' || CalendarYear,'dd/mm/yyyy')),'DD'))) as number(9,0))",
GetQualifiedFieldname(qualifier, f, true)
);
break;
case selectfunctiondef.month:
/* [dlatikay 20110613] */
sx = String.Format("to_number(to_char({0},'MM'))", GetQualifiedFieldname(qualifier, f, true)); /* ranging 1-12 */
break;
case selectfunctiondef.year:
/* [dlatikay 20161021] */
sx = String.Format("to_number(to_char({0},'YYYY'))", GetQualifiedFieldname(qualifier, f, true)); /* ranging 0000-9999 */
break;
case selectfunctiondef.hour:
/* [dlatikay 20110613] */
sx = String.Format("to_number(to_char({0},'HH24'))", GetQualifiedFieldname(qualifier, f, true)); /* ranging 0-23 */
break;
case selectfunctiondef.quarter:
/* [dlatikay 20110613] */
sx = String.Format("to_number(to_char({0},'Q'))", GetQualifiedFieldname(qualifier, f, true)); /* ranging 1-4 */
break;
case selectfunctiondef.dayofweek:
/* [dlatikay 20110613] */
sx = String.Format("to_number(to_char({0},'D'))", GetQualifiedFieldname(qualifier, f, true)); /* ranging 1-7, as opposed to "W"! */
break;
default:
return(base.GetFieldFunction(qualifier, f, aliasthis));
}
/* finalize */
if (f.AsName != null && f.AsName.Length > 0)
{
return(sx + " AS " + QuoteFieldname(f.AsName));
}
else if (aliasthis)
{
return(sx + " AS " + QuoteFieldname(f.Fieldname));
}
else
{
return(sx);
}
}
