/// <summary>
/// 脚本执行完成， 将生成的csv文件合并成XLS文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void CurrentWorker_RunComplete(object sender, EventArgs e)
{
if (FileType != InOut.FileType.XLS)
{
return;
}
Workbook workbook = new Workbook();
foreach (string variable in filePaths.Keys)
{
Worksheet worksheet = new Worksheet(variable);
using (var csv = new CsvReader(new StreamReader(filePaths[variable], Encoding.UTF8)))
{
csv.Configuration.Delimiter = ",";
csv.Configuration.HasHeaderRecord = false;
int rowindex = 0;
while (csv.Read())
{
string[] records = csv.CurrentRecord;
for (int i = 0; i < records.Length; i++)
{
worksheet.Cells[rowindex, i] = new Cell(records[i]);
}
rowindex++;
}
}
workbook.Worksheets.Add(worksheet);
}
FileStream stream = null;
try
{
string path = Path.Combine(AppSettings.Instance.CurrentExecutePath, "data");
string file = VariableModel.Parse(FileName);
string outputFile = Path.Combine(path, file.IndexOf(".") == -1 ? (file + ".xls") : (file.Substring(0, file.IndexOf(".")) + ".xls"));
stream = new FileStream(outputFile, FileMode.Create);
workbook.SaveToStream(stream);
}
finally
{
foreach (string file in filePaths.Values)
{
try
{
File.Delete(file);
}
catch { }
}
Reset();
if (stream != null)
{
stream.Close();
}
}
}
public virtual void GoToURL()
{
string bindVal = Eval(BindName);
if (!string.IsNullOrEmpty(bindVal))
{
URL = bindVal;
}
string url = VariableModel.Parse(URL);
Goto(url);
}
public override void Perform()
{
string _fileName = VariableModel.Parse(FileName);
AutoRobo.Core.IO.DataTableReader reader = new AutoRobo.Core.IO.DataTableReader(FileType, _fileName, HasHeaderRecord);
var varObj = ActionModel.VariableActionModel.Find <ActionTableVariable>(VariableName);
try
{
varObj.Data = reader.Read();
}
catch (Exception ex) {
LogWrite(string.Format("读文件{0}失败", _fileName));
LogWrite(ex.Message);
}
}
private void InitializeFilePath()
{
if (filePaths.Count > 0)
{
return;
}
string _fileName = VariableModel.Parse(FileName);
string path = Path.Combine(AppSettings.Instance.CurrentExecutePath, "data");
_fileName = Path.Combine(path, GetFileName(_fileName));
string[] vars = VariableName.Split(",".ToCharArray());
foreach (string v in vars)
{
filePaths.Add(v, _fileName.Insert(_fileName.IndexOf("."), "_" + v));
}
}
