/// <summary>
/// 取得单表数据,生产csv文件
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public byte[] DataToFile(string tableName, LogedInUser CurrentUser)
{
//DateTime dt = DateTime.Now;
IDataReader dataReader;
StringBuilder csvStr = new StringBuilder();
byte[] data;
try
{
dataReader = GetSyncTableReader(tableName, CurrentUser);
string file = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, tableName + CurrentUser.UserOrg.Reg_org_id + ".csv");
////写表头
//File.WriteAllText(file, CSVUtils.CreateCSVHeader(dataReader, csvStr), Encoding.GetEncoding(936));
////写数据
//while (dataReader.Read())
//{
// //using (StreamWriter sw = File.AppendText(file))
// //{
// // sw.Write(CSVUtils.CreateCSVContextLine(dataReader, csvStr));
// //}
// File.AppendAllText(file, CSVUtils.CreateCSVContextLine(dataReader, csvStr), Encoding.GetEncoding(936));
//}
File.WriteAllText(file, CSVUtils.ToCSV(dataReader, true), Encoding.GetEncoding(936));
//TimeSpan t = DateTime.Now.Subtract(dt);
//MessageBox.Show(t.TotalSeconds.ToString(), "", MessageBoxButtons.OK, MessageBoxIcon.Information);
CompressUtil.CompressFile(file);
data = File.ReadAllBytes(file + ".cps");
File.Delete(file);
File.Delete(file + ".cps");
}
catch (Exception e)
{
throw e;
}
return(data);
}
