protected void TestFunction(Expression <Func <ColumnCellDictionary, object> > exp, string expected)
{
var convert = new ExpressionConvert(new[] { "One", "Two", "Three", "Four", "Five", "Six" }, 3);
var ret = convert.Convert(exp);
Assert.AreEqual(expected, ret);
}
public void Day()
{
Expression <Func <Dictionary <string, object>, object> > exp = c => DateTime.Now.Day;
var convert = new ExpressionConvert(new string[] { }, 3);
var ret = convert.Convert(exp);
Assert.AreEqual("DAY(NOW())", ret);
}
public void EDateWithColumn()
{
Expression <Func <Dictionary <string, ColumnValue>, object> > exp = c => ((DateTime)c["Date"]).AddMonths((int)c["Month"]);
var convert = new ExpressionConvert(new string[] { "Date", "Month" }, 3);
var ret = convert.Convert(exp);
Assert.AreEqual("EDATE(A4,B4)", ret);
}
public void EDate()
{
Expression <Func <Dictionary <string, object>, object> > exp = c => DateTime.Now.AddMonths(3);
var convert = new ExpressionConvert(new string[] { }, 3);
var ret = convert.Convert(exp);
Assert.AreEqual("EDATE(NOW(),3)", ret);
}
private static void SetCellValue(ExcelType excelType, ExcelColumn column, ICell cell, string val,
string[] columnTitles)
{
if (column.Type == typeof(Uri))
{
cell.Hyperlink = Switch <IHyperlink>(
excelType,
() => new HSSFHyperlink(HyperlinkType.Url)
{
Address = val
},
() => new XSSFHyperlink(HyperlinkType.Url)
{
Address = val
}
);
}
else if (column.Type == typeof(Expression))
{
var convert = new ExpressionConvert(columnTitles, cell.RowIndex);
cell.SetCellFormula(convert.Convert(column.Formula));
if (column.ResultType != null)
{
if (column.ResultType == typeof(DateTime))
{
cell.CellStyle = cell.Sheet.Workbook.CreateCellStyle();
cell.CellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("m/d/yy");
}
}
return;
}
else if (column.Type == typeof(string))
{
cell.SetCellType(CellType.String);
cell.CellStyle = cell.Sheet.Workbook.CreateCellStyle();
cell.CellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("text");
}
if (column.Font != null)
{
IFont font = cell.Sheet.Workbook.CreateFont();
font.FontName = column.Font.FontName;
font.FontHeightInPoints = column.Font.FontHeightInPoints;
font.Color = column.Font.Color;
if (column.Font.IsBold)
{
font.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;
}
cell.CellStyle.SetFont(font);
}
//cell.Hyperlink=new HSSFHyperlink
cell.SetCellValue(val);
}
private static ActivityView BuildDelayView(Delay source)
{
string activityId = ObjectIdManager.GetId(source);
string duration = ExpressionConvert.ToString(source.Duration);
var view = new DelayView(activityId)
{
ActivityName = source.DisplayName,
Duration = duration,
};
return(view);
}
private static ActivityView BuildWriteLineView(WriteLine source)
{
string activityId = ObjectIdManager.GetId(source);
string text = ExpressionConvert.ToString(source.Text);
var view = new WriteLineView(activityId)
{
ActivityName = source.DisplayName,
Text = text,
};
return(view);
}
private static ActivityView BuildWhileView(While source)
{
string activityId = ObjectIdManager.GetId(source);
string condition = ExpressionConvert.ToString(source.Condition);
var view = new WhileView(activityId)
{
ActivityName = source.DisplayName,
Condition = condition,
};
return(view);
}
private static ActivityView BuildCorrelationScopeView(CorrelationScope source)
{
string activityId = ObjectIdManager.GetId(source);
string correlatesWidth = ExpressionConvert.ToString(source.CorrelatesWith);
var view = new CorrelationScopeView(activityId)
{
ActivityName = source.DisplayName,
CorrelatesWith = correlatesWidth,
};
return(view);
}
private static ActivityView BuildAssignView <T>(Assign <T> source)
{
string activityId = ObjectIdManager.GetId(source);
string to = ExpressionConvert.ToString(source.To);
string value = ExpressionConvert.ToString(source.Value);
var view = new AssignView(activityId)
{
ActivityName = source.DisplayName,
To = to,
Value = value,
};
return(view);
}
private static void SetCellValue(ExcelType excelType, ExcelColumn column, ICell cell, string val,
string[] columnTitles)
{
if (column.Type == typeof(Uri))
{
cell.Hyperlink = Switch <IHyperlink>(
excelType,
() => new HSSFHyperlink(HyperlinkType.Url)
{
Address = val
},
() => new XSSFHyperlink(HyperlinkType.Url)
{
Address = val
}
);
}
else if (column.Type == typeof(Expression))
{
var convert = new ExpressionConvert(columnTitles, cell.RowIndex);
cell.SetCellFormula(convert.Convert(column.Formula));
if (column.ResultType != null)
{
if (column.ResultType == typeof(DateTime))
{
cell.CellStyle = cell.Sheet.Workbook.CreateCellStyle();
cell.CellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("m/d/yy");
}
}
return;
}
else if (column.Type == typeof(string))
{
cell.SetCellType(CellType.String);
cell.CellStyle = cell.Sheet.Workbook.CreateCellStyle();
cell.CellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("text");
}
//cell.Hyperlink=new HSSFHyperlink
cell.SetCellValue(val);
}
private static ActivityView BuildParallelForEachView <T>(ParallelForEach <T> source)
{
string activityId = ObjectIdManager.GetId(source);
string values = ExpressionConvert.ToString(source.Values);
string argument = string.Empty;
if (source.Body != null)
{
argument = source.Body.Argument.Name;
}
var view = new ForEachView(activityId)
{
ActivityName = source.DisplayName,
Values = values,
Argument = argument,
};
return(view);
}
