public GetExportData GetExportData(string objectCode) { GetExportData getExportData = new GetExportData(); using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); // IDbTransaction transaction = dbConnection.BeginTransaction(); try { string sql = @"select * from V_FLC_OBJECTPROPERTY where obj_code = '" + objectCode + @"' and lan = 'zn_CN' order by obj_table ,obj_pro_using desc,obj_pro_null desc "; getExportData.v_FLC_s = AppDataBase.Query <V_FLC_OBJECTPROPERTY>(sql, null, null, dbConnection); string sql2 = @"select *from flc_objects objs left join flc_lang lan on lan.key=objs.obj_code||'.'||objs.obj_table where obj_code='" + objectCode + "' and lan='zn_CN' and is_main=0 "; getExportData.objectsUnions = AppDataBase.Query <ObjectsUnionLang>(sql2, null, null, dbConnection); } catch (Exception e) { throw e; } } return(getExportData); }
private void ExportDataToCSV(string pullPath) { try { int iyear = int.Parse(txtTargetAccYear.Text); DataTable dtResult = GetExportData.GetAccount(iyear); if (!pullPath.EndsWith(@"\")) { pullPath += "\\"; } string fileName = "kj_ztjk_.csv"; CSVHelper.SaveCSV(dtResult, pullPath + fileName); dtResult = GetExportData.GetCode(iyear); fileName = "kj_kmjk_.csv"; CSVHelper.SaveCSV(dtResult, pullPath + fileName); dtResult = GetExportData.GetVoucherSum(iyear); fileName = "kj_yejk_.csv"; CSVHelper.SaveCSV(dtResult, pullPath + fileName); dtResult = GetExportData.GetVoucher(iyear); if (dtResult.Rows.Count > 10000000)//超过1000万行,按月导 { DataRow[] drs; DataTable dtMResult; for (int iperiod = 1; iperiod < 13; iperiod++) { drs = dtResult.Select(string.Format("KJQJ={0}", iperiod)); if (drs.Length > 0) { dtMResult = drs.CopyToDataTable(); fileName = string.Format("kj_pzjk_{0}.csv", iperiod.ToString().PadLeft(2, '0')); CSVHelper.SaveCSV(dtResult, pullPath + fileName); } } } else { fileName = "kj_pzjk_.csv"; CSVHelper.SaveCSV(dtResult, pullPath + fileName); } MessageBox.Show("导出成功!", "信息", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "错误", MessageBoxButton.OK, MessageBoxImage.Error); } }