/// <summary> /// Thực hiện lưu file về server và đọc file ra DataSet /// đọc xong sẽ tự đông xóa file này /// </summary> /// <param name="file">HttpPostedFile</param> /// <returns>DataSet nếu không có file thì sẽ return null</returns> public static DataSet GetData(HttpPostedFile file) { string folder = HttpContext.Current.Server.MapPath(@"..\\" + ConfigurationManager.AppSettings["importFolder"].ToString()); DataSet ds = new DataSet(); string fileName = file.FileName; if (fileName == string.Empty) { return(null); } fileName = fileName.Substring(fileName.LastIndexOf("\\") + 1); try { if (!System.IO.Directory.Exists(folder)) { System.IO.Directory.CreateDirectory(folder); } if (File.Exists(folder + "\\" + fileName)) { File.Delete(folder + "\\" + fileName); } file.SaveAs(folder + "\\" + fileName); ds = ExcelHelper.getDataSet(folder + "\\" + fileName, true); return(ds); } catch (Exception e) { if (File.Exists(folder + "\\" + fileName)) { File.Delete(folder + "\\" + fileName); } return(null); } }
/// <summary> /// Chuyen file tu data set qua xml /// </summary> /// <param name="file"></param> /// <param name="objMash"></param> /// <returns></returns> public static string SaveFileExcelToXml(HttpPostedFile file, List <ExportMash> objMash, out string TableName) { TableName = string.Empty; string filePath = string.Empty; if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["virtualImFolder"])) { filePath = ConfigurationManager.AppSettings["virtualImFolder"].TrimEnd('\\'); } else { filePath = HostingEnvironment.MapPath("~") + "Resources\\ImportFolder"; } //ConfigurationManager.AppSettings["importFolder"]; string fileName = string.Empty; if (string.IsNullOrEmpty(file.FileName)) { return(string.Empty); } else { fileName = file.FileName.Substring(file.FileName.LastIndexOf("\\") + 1); } string directoryName = filePath + "\\" + fileName; if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } if (File.Exists(directoryName)) { File.Delete(directoryName); } file.SaveAs(directoryName); DataSet ds = ExcelHelper.getDataSet(directoryName, true); if (ds != null && ds.Tables.Count > 0) { ds.Locale = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); //ds.ExtendedProperties["UTCDifference"] = TimeZone.CurrentTimeZone.StandardName; foreach (ExportMash mas in objMash) { if (ds.Tables[0].Columns.Contains(mas.MashName) && mas.IsInsert) { ds.Tables[0].Columns[mas.MashName].ColumnName = mas.ColumName; } } SetUtcDateTime(ref ds); TableName = "Table1"; filePath += "\\" + System.Guid.NewGuid() + ".xml"; ds.Tables[0].TableName = TableName; // SaveDataSet(ds, filePath); ds.WriteXml(filePath); return(filePath); } return(string.Empty); }