private static string ExexPDF(string[] args) { string dtb = args[1]; string qdid = ""; int index = 0; string value = ""; if (args.Length >= 6) { qdid = args[5]; } if (args.Length >= 7) { index = Convert.ToInt32(args[6]); } if (args.Length >= 8) { value = args[7]; } BUS.LIST_QDControl qdCtr = new LIST_QDControl(); DTO.LIST_QDInfo qdInfo = qdCtr.Get_LIST_QD(dtb, qdid, ref sErr); if (qdInfo.QD_ID != "") { _sqlText = qdInfo.SQL_TEXT; try { // ;General Timeout=100 LoadQD(qdInfo); if (value != "") { _sqlBuilder.Filters[index].FilterFrom = _sqlBuilder.Filters[index].FilterTo = _sqlBuilder.Filters[index].ValueTo = _sqlBuilder.Filters[index].ValueFrom = value; } BUS.DBAControl dbaCtr = new DBAControl(); DTO.DBAInfo dbaInf = dbaCtr.Get(dtb, ref sErr); __templatePath = dbaInf.REPORT_TEMPLATE_DRIVER; ReportGenerator report = new ReportGenerator(_sqlBuilder, qdInfo.QD_ID, _sqlText, _strConnectDes, __templatePath, __reportPath, __documentDirectory); return(report.ExportPDFToPath(__reportPath)); } catch (Exception ex) { sErr = ex.Message; BUS.CommonControl.AddLog("ErroLog", __documentDirectory + "\\Log", String.Format("[QDCommand]\t[{0}]:\t{1}, {2}, {3}", DateTime.Now, ex.Message, ex.Source, ex.StackTrace)); return(""); } } return(""); }
public DBAInfo(DBAInfo objEntr) { _DB = objEntr.DB; _DB1 = objEntr.DB1; _DB2 = objEntr.DB2; _DESCRIPTION = objEntr.DESCRIPTION; _DATE_FORMAT = objEntr.DATE_FORMAT; _DECIMAL_PLACES_SUNACCOUNT = objEntr.DECIMAL_PLACES_SUNACCOUNT; _DECIMAL_SEPERATOR = objEntr.DECIMAL_SEPERATOR; _THOUSAND_SEPERATOR = objEntr.THOUSAND_SEPERATOR; _PRIMARY_BUDGET = objEntr.PRIMARY_BUDGET; _DATA_ACCESS_GROUP = objEntr.DATA_ACCESS_GROUP; _DECIMAL_PLACES_SUNBUSINESS = objEntr.DECIMAL_PLACES_SUNBUSINESS; _REPORT_TEMPLATE_DRIVER = objEntr.REPORT_TEMPLATE_DRIVER; _PARAM_1 = objEntr.PARAM_1; _PARAM_2 = objEntr.PARAM_2; _PARAM_3 = objEntr.PARAM_3; _PARAM_4 = objEntr.PARAM_4; _PARAM_5 = objEntr.PARAM_5; _PARAM_6 = objEntr.PARAM_6; }
private static string ExexReport(string[] args) { string dtb = args[1]; string qdid = ""; int index = 0; string value = ""; if (args.Length >= 6) { qdid = args[5]; } if (args.Length >= 7) { index = args[6] == "ZZZ" ? 0 : Convert.ToInt32(args[6]); } if (args.Length >= 8) { value = args[7] == "ZZZ" ? "" : args[7]; } string path = ""; if (args.Length >= 9) { path = args[8] == "ZZZ" ? "" : args[8]; } path = path.Replace("%20", " "); string filename = ""; if (args.Length >= 10) { filename = args[9] == "ZZZ" ? "" : args[9]; } filename = filename.Replace("%20", " "); BUS.LIST_QDControl qdCtr = new LIST_QDControl(); DTO.LIST_QDInfo qdInfo = qdCtr.Get_LIST_QD(dtb, qdid, ref sErr); if (qdInfo.QD_ID != "") { _sqlText = qdInfo.SQL_TEXT; try { LoadQD(qdInfo); if (value != "") { _sqlBuilder.Filters[index].FilterFrom = _sqlBuilder.Filters[index].FilterTo = _sqlBuilder.Filters[index].ValueTo = _sqlBuilder.Filters[index].ValueFrom = value; } BUS.DBAControl dbaCtr = new DBAControl(); DTO.DBAInfo dbaInf = dbaCtr.Get(dtb, ref sErr); __templatePath = dbaInf.REPORT_TEMPLATE_DRIVER; ReportGenerator report = new ReportGenerator(_sqlBuilder, qdInfo.QD_ID, _sqlText, _strConnectDes, __templatePath, __reportPath, __documentDirectory); if (path == "" && filename == "") { return(report.ExportExcelToPath(__reportPath)); } else if (path != "" && filename == "") { return(report.ExportExcelToPath(path)); } else if (path == "" && filename != "") { return(report.ExportExcelToFile(__reportPath, filename)); } else { return(report.ExportExcelToFile(path, filename)); } } catch (Exception ex) { sErr = ex.Message; BUS.CommonControl.AddLog("ErroLog", __documentDirectory + "\\Log", "[QDCommand]\t[" + DateTime.Now.ToString() + "]:\t" + ex.Message + ", " + ex.Source + ", " + ex.StackTrace); return(""); } } return(""); }