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