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