internal List <string> Columns(ColumnsType type)
{
List <string> list = new List <string>();
for (int i = 1; i <= this.Column; i++)
{
list.Add((type == ColumnsType.String) ? GetColumnName(i) : i.ToString());
}
return(list);
}
public static string GetTypeID(ColumnsType col, out int boFieldTypes, out int boFldSubTypes)
{
boFldSubTypes = 0; //None
switch (col)
{
case SAPTables.ColumnsType.Special_MD5:
case SAPTables.ColumnsType.Special_YesOrNo:
case SAPTables.ColumnsType.Special_StatusQueue:
case ColumnsType.AlphaNumeric_Regular:
boFieldTypes = 0;
return("A");
case ColumnsType.AlphaNumeric_Address:
boFieldTypes = 0;
boFldSubTypes = 63;
return("A?");
case ColumnsType.AlphaNumeric_Phone:
boFieldTypes = 0;
boFldSubTypes = 35;
return("A#");
case ColumnsType.AlphaNumeric_Text:
boFieldTypes = 1;
return("M");
case ColumnsType.Numeric:
boFieldTypes = 2;
return("N");
case ColumnsType.DateTime_Date:
boFieldTypes = 3;
return("D");
case ColumnsType.DateTime_Hour:
boFieldTypes = 3;
boFldSubTypes = 84;
return("NT");
//case ColumnsType.UnitsAndTotals_Rate: return "BR";
//case ColumnsType.UnitsAndTotals_Amount: return "BS";
//case ColumnsType.UnitsAndTotals_Price: return "BP";
//case ColumnsType.UnitsAndTotals_Quantity: return "BQ";
//case ColumnsType.UnitsAndTotals_Percents: return "B%";
//case ColumnsType.UnitsAndTotals_Measure: return "BM";
//case ColumnsType.General_Link: return "MB";
//case ColumnsType.General_Image: return "AI";
//case ColumnsType.Special_MD5: return "A#";
//case ColumnsType.Special_YesOrNo: return "A";
//case ColumnsType.Special_StatusQueue: return "A";
default: throw new NotImplementedException(col.ToString());
}
}
public List <ReportColumn> GetColumnList()
{
var list = new List <ReportColumn>();
if (!ColumnList.Any())
{
return(list);
}
IDictionary <string, PropertyItem> propertyItems = null;
IDictionary <string, PropertyInfo> propertyInfos = null;
Row basedOnRow = null;
if (ColumnsType != null)
{
propertyItems = LocalCache.Get("DynamicDataReport:Columns:" + ColumnsType.FullName, TimeSpan.Zero,
() => PropertyItemHelper.GetPropertyItemsFor(ColumnsType).ToDictionary(x => x.Name));
propertyInfos = ColumnsType.GetProperties().ToDictionary(x => x.Name);
var basedOnAttr = ColumnsType.GetCustomAttribute <BasedOnRowAttribute>();
if (basedOnAttr != null &&
basedOnAttr.RowType != null &&
typeof(Row).IsAssignableFrom(basedOnAttr.RowType))
{
basedOnRow = (Row)Activator.CreateInstance(basedOnAttr.RowType);
}
}
foreach (var columnName in ColumnList)
{
PropertyItem item;
if (!propertyItems.TryGetValue(columnName, out item))
{
continue;
}
var basedOnField = basedOnRow == null ? (Field)null :
(basedOnRow.FindField(columnName) ?? basedOnRow.FindFieldByPropertyName(columnName));
PropertyInfo p;
if (propertyInfos == null || !propertyInfos.TryGetValue(columnName, out p))
{
p = null;
}
list.Add(FromPropertyItem(item, basedOnField, p));
}
return(list);
}
public GridColumn(string data, ColumnsType type = ColumnsType.None)
{
this.data = data;
this.type = type;
var align = ColumnsTextAlign.None;
string vRender = null;
if ((type == ColumnsType.Date || type == ColumnsType.DateTime) && string.IsNullOrEmpty(vRender))
{
vRender = "function (data, type, full, meta) {return $.jsonDateToFormat(data";
if (type == ColumnsType.DateTime)
{
render += ",'DD/MM/YYYY HH:mm:ss'";
}
vRender += ");}";
align = ColumnsTextAlign.Center;
}
if ((type == ColumnsType.Number ||
type == ColumnsType.NumberFormat ||
type == ColumnsType.NumberFormat2 ||
type == ColumnsType.NumberFormat3 ||
type == ColumnsType.NumberFormat4 ||
type == ColumnsType.NumberFormat6 ||
type == ColumnsType.NumberFormat8 ||
type == ColumnsType.NumberFormat10
) && string.IsNullOrEmpty(vRender))
{
align = ColumnsTextAlign.Right;
if (type != ColumnsType.Number)
{
var digitLength = 0;
if (type == ColumnsType.NumberFormat2)
{
digitLength = 2;
}
else if (type == ColumnsType.NumberFormat3)
{
digitLength = 3;
}
else if (type == ColumnsType.NumberFormat4)
{
digitLength = 4;
}
else if (type == ColumnsType.NumberFormat6)
{
digitLength = 6;
}
else if (type == ColumnsType.NumberFormat8)
{
digitLength = 8;
}
else if (type == ColumnsType.NumberFormat10)
{
digitLength = 10;
}
if (digitLength > 0)
{
vRender = "function (data, type, full, meta) {return digitsFormat(toNumberFormat(data)," + digitLength + ");}";
}
else
{
vRender = "function (data, type, full, meta) {return toNumberFormat(data);}";
}
}
}
if (type == ColumnsType.File ||
type == ColumnsType.FileMultiple)
{
vRender = "function (data, type, full, meta) {return '<table id=\"Grid|tplName|";
vRender += data;
vRender += "\" class=\"table table-striped table-bordered table-hover gridInGrid\"></table>';}";
}
this.render = vRender;
this.className = align != ColumnsTextAlign.None ? align.GetDescription() : null;
}
public GridColumn(string data, string title, int?width, ColumnsType type = ColumnsType.None, ColumnsTextAlign align = ColumnsTextAlign.None, string render = null)
{
this.data = data;
this.title = title;
this.width = width != null?Convert.ToString(width) : null;
this.type = type;
if ((type == ColumnsType.Date ||
type == ColumnsType.DateTime) && string.IsNullOrEmpty(render))
{
render = "function (data, type, full, meta) {return $.jsonDateToFormat(data";
if (type == ColumnsType.DateTime)
{
render += ",'DD/MM/YYYY HH:mm:ss'";
}
render += ");}";
if (align == ColumnsTextAlign.None)
{
align = ColumnsTextAlign.Center;
}
}
if (type == ColumnsType.Time && string.IsNullOrEmpty(render))
{
render = "function (data, type, full, meta) {return $.jsonDateToFormat(data";
if (type == ColumnsType.Time)
{
render += ",'HH:mm:ss'";
}
render += ");}";
if (align == ColumnsTextAlign.None)
{
align = ColumnsTextAlign.Center;
}
}
if ((type == ColumnsType.NumberFormat ||
type == ColumnsType.NumberFormat2 ||
type == ColumnsType.NumberFormat3 ||
type == ColumnsType.NumberFormat4 ||
type == ColumnsType.NumberFormat6 ||
type == ColumnsType.NumberFormat8 ||
type == ColumnsType.NumberFormat10
) && string.IsNullOrEmpty(render))
{
if (align == ColumnsTextAlign.None)
{
align = ColumnsTextAlign.Right;
}
var digitLength = 0;
if (type == ColumnsType.NumberFormat2)
{
digitLength = 2;
}
else if (type == ColumnsType.NumberFormat3)
{
digitLength = 3;
}
else if (type == ColumnsType.NumberFormat4)
{
digitLength = 4;
}
else if (type == ColumnsType.NumberFormat6)
{
digitLength = 6;
}
else if (type == ColumnsType.NumberFormat8)
{
digitLength = 8;
}
else if (type == ColumnsType.NumberFormat10)
{
digitLength = 10;
}
if (digitLength > 0)
{
render = "function (data, type, full, meta) {return digitsFormat(toNumberFormat(data)," + digitLength + ");}";
}
else
{
render = "function (data, type, full, meta) {return toNumberFormat(data);}";
}
}
if (type == ColumnsType.Checkbox)
{
if (align == ColumnsTextAlign.None)
{
align = ColumnsTextAlign.Center;
}
render = "function (data, type, full, meta) {";
render += "var tag = '<i class=\"ace-icon fa fa-square-o\"></i>';";
render += "if(data == 'Y'){";
render += "tag = '<i class=\"ace-icon fa fa-check-square-o\"></i>';}";
render += "return tag;}";
}
this.render = render;
this.className = align != ColumnsTextAlign.None ? align.GetDescription() : null;
}
