/// <summary>
/// 导入数据
/// </summary>
/// <param name="tmplCode">模板编码</param>
/// <param name="fileFullName"></param>
public static void ImportDataByTemplateCode(string tmplCode, string fileFullName)
{
SysDataImportTemplate tmplEnt = SysDataImportTemplate.FindFirstByProperties("Code", tmplCode);
ImportTemplateStructure its = ImportTemplateStructure.GetFromConfig(tmplEnt.Config);
string filePath = FileService.GetFilePathByFullID(fileFullName);
ImportData(its, filePath);
}
/// <summary>
/// 获取EasyDictionary数据
/// </summary>
/// <param name="tmplCode">模版编码</param>
/// <param name="filePath">文件路径</param>
/// <returns></returns>
public static DataTable GetDataTableByTemplateCode(string tmplCode, string fileFullName)
{
SysDataImportTemplate tmplEnt = SysDataImportTemplate.FindFirstByProperties("Code", tmplCode);
ImportTemplateStructure struc = ImportTemplateStructure.GetFromConfig(tmplEnt.Config);
string filePath = FileService.GetFilePathByFullID(fileFullName);
DataTable dt = GetDataTable(struc, filePath);
return(dt);
}
string code = String.Empty; // 对象编码
#endregion
#region ASP.NET 事件
protected void Page_Load(object sender, EventArgs e)
{
op = RequestData.Get <string>("op");
code = RequestData.Get <string>("code");
SysDataImportTemplate ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Custom:
if (RequestActionString == "import")
{
code = FormData.Get <string>("Code");
if (!String.IsNullOrEmpty(code))
{
ent = SysDataImportTemplate.FindFirstByProperties("Code", code);
string fileFullName = FormData.Get <string>("DataFileID");
if (!String.IsNullOrEmpty(fileFullName))
{
DataImportService.ImportData(ent.Config, fileFullName);
// 导入完成后删除原文件
FileService.DeleteFileByFullID(fileFullName);
}
}
}
else if (RequestActionString == "gettmplid")
{
// 下载文件模板时用于获取模板文件id(异步)
if (IsAsyncRequest && !String.IsNullOrEmpty(code))
{
ent = SysDataImportTemplate.FindFirstByProperties("Code", code);
// 返回模板文件ID
PageState.Add("id", FileService.GetFileIDByFullID(ent.TemplateFileID));
}
}
break;
case RequestActionEnum.Default:
if (!String.IsNullOrEmpty(code))
{
ent = SysDataImportTemplate.FindFirstByProperties("Code", code);
this.SetFormData(ent);
}
break;
}
}
