/// <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; } }