private void frmReport_Load(object sender, EventArgs e) { TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; string[] Account = help.GetAccount().Split(' '); crConnectionInfo.ServerName = Account[0]; crConnectionInfo.DatabaseName = Account[1]; crConnectionInfo.UserID = Account[2]; object pwd = Account[3]; crConnectionInfo.Password=(pwd.ToString()); //---------Xét account truy cập vào các table CrTables = rpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } //----------set resource--------------- rpt.SetParameterValue("tu",tu); rpt.SetParameterValue("den", den); cryRViewer.ReportSource = rpt; cryRViewer.Refresh(); }
private void bPreview_Click(object sender, EventArgs e) { //System.Data.SqlClient.SqlDataReader SqlReader = null; DataTable DT = new DataTable(); DataRow dr = DT.NewRow(); string d1,d2 ; DateTime dt1 = DateTime.Parse(dateTimePicker1.Text); int Year1 = dt1.Year; int Month1 = dt1.Month; int day1 = dt1.Day; DateTime dt2 = DateTime.Parse(dateTimePicker2.Text); int Year2 = dt2.Year; int Month2 = dt2.Month; int day2 = dt2.Day; if (Year1 > 2500) { d1 = (Year1 - 543).ToString() + "-" + Month1.ToString("00") + "-" + day1.ToString("00"); d2 = (Year2 - 543).ToString() + "-" + Month2.ToString("00") + "-" + day2.ToString("00"); } else { d1 = Year1.ToString() + "-" + Month1.ToString("00") + "-" + day1.ToString("00"); d2 = Year2.ToString() + "-" + Month2.ToString("00") + "-" + day2.ToString("00"); } string sql = "select h.staff_code as id ,p.first_name +' '+p.last_name name, sum(h.pdf_page) page, "; sql += " convert(varchar(10),h.create_on,103) date "; sql += " from scan_history h inner join personal p "; sql += " on h.staff_code =p.staff_code "; sql += " where convert(varchar(10),h.create_on,120) between '" + d1 + "' and '" + d2 + "' "; sql += " group by h.staff_code, p.first_name, p.last_name, convert(varchar(10),h.create_on,103)"; sql += " order by h.staff_code"; Func.Master.ScanHistoryFunc fnc = new Func.Master.ScanHistoryFunc(); DT = fnc.GetDataBySql(sql); if (DT.Rows.Count > 0) { TableLogOnInfo logonInfo = new TableLogOnInfo(); logonInfo.ConnectionInfo.DatabaseName = Config.DbGetDbName; logonInfo.ConnectionInfo.ServerName = Config.DbGetDataSource; logonInfo.ConnectionInfo.UserID = Config.DbGetUserID; logonInfo.ConnectionInfo.Password = Config.DbGetPwd; SummaryReport rpt = new SummaryReport(); frmPrintPreview frm = new frmPrintPreview(); rpt.SetDataSource(DT); rpt.Database.Tables[0].ApplyLogOnInfo(logonInfo); frm.crystalReportViewer1.ReportSource = rpt; frm.StartPosition = FormStartPosition.CenterScreen; frm.WindowState = FormWindowState.Maximized; frm.Show(); } }
public static TableLogOnInfos ConectaCrystal() { TableLogOnInfos Infos = new TableLogOnInfos(); TableLogOnInfo Info = new TableLogOnInfo(); ConnectionInfo cn = new ConnectionInfo(); cn.ServerName = "CCLSQL"; cn.DatabaseName = "materia_prima"; cn.UserID = "matprima"; cn.Password = "******"; cn.Type = ConnectionInfoType.SQL; cn.IntegratedSecurity = false; Info.ConnectionInfo = cn; Infos.Add(Info); return Infos; }
public Reporte(string paramServidor, string paramUsuario, string paramContraseña, string paramBaseDatos, string paramRuta, string paramNombreArchivo, string paramNombreReporte, HttpResponse paramPagina) { conexionBaseDatos = new TableLogOnInfo(); reporte = new ReportDocument(); conexionBaseDatos.ConnectionInfo.ServerName = paramServidor; conexionBaseDatos.ConnectionInfo.UserID = paramUsuario; conexionBaseDatos.ConnectionInfo.Password = paramContraseña; conexionBaseDatos.ConnectionInfo.DatabaseName = paramBaseDatos; reporte.Load(paramRuta + paramNombreArchivo); nombreReporte = paramNombreReporte; reporte.Database.Tables[0].ApplyLogOnInfo(conexionBaseDatos); pagina = paramPagina; }
protected void Page_Load(object sender, EventArgs e) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Admin/Login.aspx"); } else { //load crystal report ReportDocument Report = new ReportDocument(); Report.Load(Server.MapPath("Sales_Return.rpt ")); //this.CrystalReportSource1.Report.FileName = Server.MapPath("Sales_order.rpt"); TableLogOnInfo logOnInfo = new TableLogOnInfo(); logOnInfo.ConnectionInfo.ServerName = "USER-3924AC2E56"; logOnInfo.ConnectionInfo.DatabaseName = "MyData"; logOnInfo.ConnectionInfo.UserID = "sa"; logOnInfo.ConnectionInfo.Password = "******"; //对报表中的每个表进行循环 for (int i = 0; i < Report.Database.Tables.Count; i++) { Report.Database.Tables[i].ApplyLogOnInfo(logOnInfo); } //load param //CrystalDecisions.Web.Parameter param = new CrystalDecisions.Web.Parameter(); //param.Name = "OrderID"; //param.DefaultValue = Request.QueryString["TextBoxId"].ToString().Trim(); //add param //this.CrystalReportSource1.Report.Parameters.Add(param); ParameterValues ParamValues = new ParameterValues(); ParameterDiscreteValue ParamValue = new ParameterDiscreteValue(); ParamValue.Value = Request.QueryString["TextBoxId"].ToString().Trim(); ParamValues.Add(ParamValue); Report.DataDefinition.ParameterFields[0].ApplyCurrentValues(ParamValues); //bind this.CrystalReportViewer1.ReportSource = Report; //this.CrystalReportViewer1.ReportSourceID = this.CrystalReportSource1.ID; //關閉左邊 this.CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None; //強制安裝ActiveX CrystalReportViewer1.PrintMode = CrystalDecisions.Web.PrintMode.ActiveX; this.CrystalReportViewer1.DataBind(); } }
public static CrystalDecisions.Windows.Forms.CrystalReportViewer ViewReport(string reportName, List<KeyValuePair<string, object>> Param_Values) { ReportDocument _reportDocument = new ReportDocument(); CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables crTables; // load report _reportDocument.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Reports\\" + reportName); // set report Connection info string[] LoginData = ConfigurationManager.ConnectionStrings["Local"].ConnectionString.ToString().Split(';'); if (!string.IsNullOrEmpty(LoginData[3].ToString()) && LoginData[3].ToString() != "") crConnectionInfo.Password = LoginData[3].Split('=')[1].ToString(); crConnectionInfo.UserID = LoginData[2].Split('=')[1].ToString(); crConnectionInfo.DatabaseName = LoginData[1].Split('=')[1]; crConnectionInfo.ServerName = LoginData[0].Split('=')[1]; crTables = _reportDocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in crTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } _reportDocument.Refresh(); // set report Parameter if (Param_Values != null) { foreach (KeyValuePair<string, object> Param_Value in Param_Values) { // _reportDocument.SetParameterValue("SalesHeaderID",Param_Value.Value); _reportDocument.SetParameterValue((string)Param_Value.Key, (object)Param_Value.Value); } } crystalReportViewer1.ReportSource = _reportDocument; crystalReportViewer1.Refresh(); crystalReportViewer1.Name = "crystalReportViewer1"; return crystalReportViewer1; }
private void load_db(CrystalReportPass crystal) { TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = "127.0.0.1"; crConnectionInfo.DatabaseName = ""; crConnectionInfo.UserID = "basdat"; crConnectionInfo.Password = "******"; CrTables = crystal.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } }
public static bool Print(string reportName, int copies, List<KeyValuePair<string, object>> Param_Values) { ReportDocument _reportDocument = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; bool status = false; _reportDocument.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Reports\\" + reportName); string[] LoginData = ConfigurationManager.ConnectionStrings["Production"].ConnectionString.ToString().Split(';'); if (!string.IsNullOrEmpty(LoginData[3].ToString()) && LoginData[3].ToString() != "") crConnectionInfo.Password = LoginData[3].Split('=')[1].ToString(); crConnectionInfo.UserID = LoginData[2].Split('=')[1].ToString(); crConnectionInfo.DatabaseName = LoginData[1].Split('=')[1]; crConnectionInfo.ServerName = LoginData[0].Split('=')[1]; CrTables = _reportDocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } _reportDocument.Refresh(); // set report Parameter if (Param_Values != null) { foreach (KeyValuePair<string, object> Param_Value in Param_Values) { // _reportDocument.SetParameterValue("SalesHeaderID",Param_Value.Value); _reportDocument.SetParameterValue((string)Param_Value.Key, (object)Param_Value.Value); } } for (int i = 0; i < copies; i++) { _reportDocument.PrintToPrinter(1, true, 0, 0); status = true; } return status; }
private static void DataBaseLogIn(ReportDocument rpt) { ConnectionInfo con_info = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); Tables crTables; con_info.ServerName = Connection().DataSource; con_info.DatabaseName = Connection().InitialCatalog; con_info.UserID = Connection().UserID; con_info.Password = Connection().Password; crTables = rpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { crtableLogoninfo = crTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = con_info; crTable.ApplyLogOnInfo(crtableLogoninfo); } }
protected void Page_Load(object sender, EventArgs e) { CrystalReportViewer_DownloadFiles.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None; ReportDocument rptDoc = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); // Tables CrTables; crConnectionInfo.ServerName = objDbAccess.strServer; crConnectionInfo.DatabaseName = objDbAccess.strDbName; crConnectionInfo.UserID = objDbAccess.strUser; crConnectionInfo.Password = objDbAccess.strPassword; UserList ds = new UserList(); // .xsd file name DataTable dt = new DataTable(); // Just set the name of data table dt.TableName = "DownloadHistory"; dt = objReports.GetDownloadReports(); //This function is located below this function ds.Tables[0].Merge(dt); // Your .rpt file path will be below rptDoc.Load(Server.MapPath("~/Reports/ListDownload.rpt")); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in rptDoc.Database.Tables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } // crtableLogoninfo.ConnectionInfo = crConnectionInfo; //set dataset to the report viewer. rptDoc.SetDataSource(ds); CrystalReportViewer_DownloadFiles.ReportSource = rptDoc; }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["repname"] != null && Request.QueryString["param"] != null) { reportDoc = new ReportDocument(); reportDoc.Load(Server.MapPath(Request.QueryString["repname"])); string param = Request.QueryString["param"]; int index = -1; index = param.IndexOf("|"); if (index == -1) AssignParam(param); else { string[] temp = param.Split('|'); foreach (string prtemp in temp) { AssignParam(prtemp); } } //set connection TableLogOnInfo logonInfo = new TableLogOnInfo(); logonInfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["DB_SERVER"].ToString().Trim(); logonInfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["DB_USER"].ToString().Trim(); logonInfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["DB_PASSWORD"].ToString(); crViewer.LogOnInfo.Add(logonInfo); crViewer.EnableDatabaseLogonPrompt = false; crViewer.EnableDrillDown = false; crViewer.DisplayGroupTree = false; crViewer.HasToggleGroupTreeButton = false; crViewer.ReportSource = reportDoc; } }
private void btnSearch_Click(object sender, EventArgs e) { //==================================================================================== // GENERATE REPORT //==================================================================================== //ATM REPORT CrystalDecisions.Shared.TableLogOnInfo li; //Print Purposes using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); //SET VALUES FIRST string type, comp, stat; if (cmbLoanType.SelectedValue.ToString() == "ALL") { type = ""; } else { type = cmbLoanType.SelectedValue.ToString(); } if (cmbCompany.SelectedValue.ToString() == "ALL COMPANY") { comp = ""; } else { comp = cmbCompany.SelectedValue.ToString(); } if (cmbStatus.SelectedValue.ToString() == "ALL STATUS") { status = "('FOR APPROVAL','APPROVED','DISAPPROVED','RELEASED','FBA','CANCELLED','FOR RELEASE','FOR POSTING')"; } else { status = "('" + cmbStatus.SelectedValue.ToString() + "')"; } //===================================================================================== // STRING QUERY BUILDER //===================================================================================== str = "select * From vw_LoanReport WHERE Loan_No Like '%" + txtLoanNo.Text + "%' and Loan_Type Like '%" + type + "%' and Company Like '%" + comp + "%' and Status in " + status + " and Name like '%" + txtName.Text + "%' and [Encoded By] like '%" + txtEncodedBy.Text + "%' and [Date Encoded] Between '" + dtFrom.Text + "' and '" + dtTo.Text + "'"; SqlDataAdapter adapter = new SqlDataAdapter(str, con); DataTable checkDT = new DataTable(); adapter.Fill(checkDT); if (checkDT.Rows.Count == 0) { Alert.show("No record(s) found.", Alert.AlertType.error); return; } DataTable dt = new DataTable(); DataSet ds = new DataSet(); ReportsForms.loanReport cr = new ReportsForms.loanReport(); li = new TableLogOnInfo(); li.ConnectionInfo.IntegratedSecurity = false; adapter.Fill(ds, "vw_LoanReport"); dt = ds.Tables["vw_LoanReport"]; cr.SetDataSource(ds.Tables["vw_LoanReport"]); //cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW"); cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog); //Setup Parameters cr.SetParameterValue("from", dtFrom.Text); cr.SetParameterValue("to", dtTo.Text); cr.SetParameterValue("PrintedBy", Classes.clsUser.Username); cr.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize; crystalReportViewer1.ReportSource = cr; } }
void LoadReport() { ProjectID = "All"; BlockNo = "All"; StatusCode = -1; Type = "All"; Category = "All"; try { this.Cursor = Cursors.WaitCursor; ReportDocument cryRpt = new ReportDocument(); ReportObjects crReportObjects; SubreportObject crSubreportObject; ReportDocument crSubreportDocument; Database crDatabase; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; string s = ""; if (this.reportType == ReportType.UnitStatus) { s = Application.StartupPath + @"\Reports\UnitStatus.rpt"; } else if (this.reportType == ReportType.UnitStatusCount) { s = Application.StartupPath + @"\Reports\UnitStatusCount.rpt"; } //else if (this.reportType == ReportType.GRN) //{ s = Application.StartupPath + @"\Reports\GRNMainReport.rpt"; } //else if (this.reportType == ReportType.GIN) //{ s = Application.StartupPath + @"\Reports\GINMainReport.rpt"; } cryRpt.Load(s); ConnectionInfo connInfo = new ConnectionInfo(); SqlConnectionStringBuilder builder = new DataAccess().GetCredentials(); crConnectionInfo.ServerName = builder.DataSource; crConnectionInfo.DatabaseName = builder.InitialCatalog; crConnectionInfo.UserID = builder.UserID; crConnectionInfo.Password = builder.Password; Sections ReportSections = cryRpt.ReportDefinition.Sections; foreach (Section section in ReportSections) { crReportObjects = section.ReportObjects; foreach (ReportObject crReportObject in crReportObjects) { if (crReportObject.Kind != ReportObjectKind.SubreportObject) { continue; } crSubreportObject = (SubreportObject)crReportObject; crSubreportDocument = crSubreportObject.OpenSubreport(crSubreportObject.SubreportName); crDatabase = crSubreportDocument.Database; CrTables = crDatabase.Tables; foreach (Table CrTable in CrTables) { TableLogOnInfo crTableLogOnInfo = CrTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crTableLogOnInfo); } } } CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } if (this.reportType == ReportType.UnitStatus) { cryRpt.SetParameterValue("@ProjectID", this.ProjectID); cryRpt.SetParameterValue("@BlockNo", this.BlockNo); cryRpt.SetParameterValue("@StatusCode", this.StatusCode); cryRpt.SetParameterValue("@Category", this.Category); cryRpt.SetParameterValue("@Type", this.Type); } else if (this.reportType == ReportType.UnitStatusCount) { cryRpt.SetParameterValue("@ProjectID", this.ProjectID); } //else if (this.reportType == ReportType.GIN) //{ // cryRpt.SetParameterValue("@docnmbr", this.strDocumentNumber); //} rptViewer.ReportSource = cryRpt; rptViewer.Refresh(); } catch { } this.Cursor = Cursors.Arrow; }
//Строка входящих параметров //0-DTBeg //1-DTEnd //2-NameObj //3-RazmA //4-RazmR public InitReports(string NameReport, NodeProp nodeProp, string listPars, string notes, DBToolKit dbWork) { Notes = notes; //IdNode = nodeProp.IdParent; IdMeter= nodeProp.IdObject; IdAccount=nodeProp.IdObject; string[] ListPars = listPars.Split('#'); DTBeg = ListPars[0]; DateTimeBeg = Convert.ToDateTime(DTBeg); DTEnd = ListPars[1]; DateTimeEnd = Convert.ToDateTime(DTEnd); NameObj = ListPars[2]; typeTree = Convert.ToInt32( ListPars[3]); DecimalPoint = Convert.ToInt32( ListPars[4]); FontSize = Convert.ToInt32( ListPars[5]); try { StartHour = Convert.ToInt32(ListPars[6]); } catch { } // SetStartHour(0); //if(ListPars.Length==7) //listobject = ListPars[6]; // RazmR = ListPars[4]; crConnectionInfo = new ConnectionInfo(); crConnectionInfo.ServerName = dbWork.ReturnIDFromConnString("datasource"); crConnectionInfo.DatabaseName = dbWork.ReturnIDFromConnString("initialcatalog"); crConnectionInfo.UserID = dbWork.ReturnIDFromConnString("userid"); crConnectionInfo.Password = dbWork.ReturnIDFromConnString("password"); //DataSet ds = new DataSet(); //SqlDataAdapter da; string query = ""; string Capt; string Razm = ""; switch(NameReport) { case "График часовой": if (NameObj.ToLower().IndexOf("небаланс") != -1) { query = String.Format("select * from fGetBalanceForGroupByProfileByDeltaByOutDelta({0}, {1}, \'{2}\', \'{3}\', \'{4}\')", nodeProp.IdObject, 60, "-", DTBeg, DTEnd); Otchreport = new Simple.Reports.SumGroupFrofileDelta(); Razm = ""; } else { query = "select * from fGetSumGroup(" + nodeProp.IdObject + ", 17, " + (int)nodeProp.IdType + ", 1" + ", \'" + DTBeg + "\', " + "\'" + DTEnd + "\'" + ")"; Otchreport = new Simple.Reports.SumGroupFrofile(); SetTotalVis("true"); Razm =", кВт*ч/кВар*ч"; } if (DateTime.Parse(DTBeg).AddDays(1) == DateTime.Parse(DTEnd)) { Capt = NameObj + "\r\n" + "Часовой график" + Razm + " за " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy"); } else { Capt = NameObj + "\r\n" + "Часовой график" + Razm + " с " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy"); } SetDecimalPoint(); SetFontSize(); SetTitle(Capt); break; case "График получасовой": if(DateTime.Parse(DTBeg).AddDays(1)==DateTime.Parse(DTEnd)) { Capt = NameObj+"\r\n"+ "Получасовой график, кВт/кВар за " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy"); } else { Capt = NameObj + "\r\n" + "Получасовой график, кВт/кВар c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy"); } query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 1730, "+(int)nodeProp.IdType+", 1"+ ", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")"; Otchreport = new Simple.Reports.SumGroupFrofile(); SetTitle(Capt); SetDecimalPoint(); SetFontSize(); SetTotalVis("false"); break; case "График суточный -10 дней": DTEnd = DateTime.Parse(DTBeg).AddDays(10).ToString(); Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy"); query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 12, "+(int)nodeProp.IdType+", 1"+ ", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")"; Otchreport = new Simple.Reports.SumGroupFrofile(); SetTotalVis("true"); SetDecimalPoint(); SetFontSize(); SetTitle(Capt); break; case "График суточный -20 дней": DTEnd = DateTime.Parse(DTBeg).AddDays(20).ToString(); Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy"); query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 12, "+(int)nodeProp.IdType+", 1"+ ", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")"; Otchreport = new Simple.Reports.SumGroupFrofile(); SetTitle(Capt); SetDecimalPoint(); SetFontSize(); SetTotalVis("true"); break; case "График суточный -месяц": DTEnd = DateTime.Parse(DTBeg).AddMonths(1).ToString(); if(DateTime.Parse(DTBeg).Day>=28) Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч за " + DateTime.Parse(DTEnd).ToString("MMMM yyyy"); else Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч за " + DateTime.Parse(DTBeg).ToString("MMMM yyyy"); query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 12, "+(int)nodeProp.IdType+", 1"+ ", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")"; Otchreport = new Simple.Reports.SumGroupFrofile(); SetTotalVis("true"); SetDecimalPoint(); SetFontSize(); SetTitle(Capt); break; case "График суточный(SUM) -месяц": DTEnd = DateTime.Parse(DTBeg).AddMonths(1).ToString(); if(DateTime.Parse(DTBeg).Day>=28) Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч накопительный за " + DateTime.Parse(DTEnd).ToString("MMMM yyyy"); else Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч накопительный за " + DateTime.Parse(DTBeg).ToString("MMMM yyyy"); query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 12, "+(int)nodeProp.IdType+", 11"+ ", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")"; Otchreport = new Simple.Reports.SumGroupFrofile(); SetTitle(Capt); SetDecimalPoint(); SetFontSize(); SetTotalVis("false"); break; case "Основной-дублирующий": switch (nodeProp.IdType) { case TypeObject.account: case TypeObject.accountOV: case TypeObject.accountTech: //SetRazmA("%"); //SetRazmR("%"); query = String.Format("select * from MRDMGetVerificationTotal({0} ,\'{1}\', \'{2}\', \'{3}\')", nodeProp.IdObject, nodeProp.IdType.ToString(), DTBeg, DTEnd); break; } Otchreport = new Simple.Reports.Verification(); SetTitle(String.Format("Верификация учета {0}\r\nОсновной-Дублирующий", NameObj)); //SetNotes(Notes); SetFontSize(); SetDecimalPoint(); //SetDTBeg(); break; case"Профиль нагрузки получасовой": switch(nodeProp.IdType) { case TypeObject.account: case TypeObject.virtualAccount: case TypeObject.accountOV: case TypeObject.accountTech: case TypeObject.oik: case TypeObject.itec: case TypeObject.oppositeLine: case TypeObject.manual: SetRazmA("кВт"); SetRazmR("кВар"); query = String.Format("select * from MRDMGetAcProfileHalfHour({0} ,\'{1}\', \'{2}\', \'{3}\')", nodeProp.IdObject, nodeProp.IdType.ToString(), DateTimeBeg.AddHours(StartHour), DateTimeEnd.AddHours(StartHour)); break; case TypeObject.meter: case TypeObject.meterReserve: switch (typeTree) { case 0: SetRazmA("Вт"); SetRazmR("Вар"); query = "select *, 192 as \'quality\' from MRDMGetProfileHalfHour(" + nodeProp.IdParent + ", " + nodeProp.IdObject + ", \'" + DateTimeBeg.AddHours(StartHour) + "\', \'" + DateTimeEnd.AddHours(StartHour) + "\')"; break; case 1: SetRazmA("кВт"); SetRazmR("кВар"); query = String.Format("select * from MRDMGetAcProfileHalfHour({0} , \'{1}\', \'{2}\', \'{3}\')", nodeProp.IdObject, nodeProp.IdType.ToString(), DateTimeBeg.AddHours(StartHour), DateTimeEnd.AddHours(StartHour)); break; } break; } Otchreport = new Simple.Reports.Profnag_sut30M(); SetTitle(NameObj); SetNotes(Notes); SetStartHour(StartHour); SetFontSize(); SetDTBeg(); break; case"Профиль нагрузки часовой": switch(nodeProp.IdType) { case TypeObject.account: case TypeObject.virtualAccount: case TypeObject.accountOV: case TypeObject.accountTech: case TypeObject.oik: case TypeObject.itec: case TypeObject.oppositeLine: case TypeObject.manual: SetRazmA("кВт"); SetRazmR("кВар"); query = String.Format("select * from MRDMGetAcProfileHour({0} , \'{1}\', \'{2}\', \'{3}\')", nodeProp.IdObject, nodeProp.IdType.ToString(), DateTimeBeg.AddHours(StartHour), DateTimeEnd.AddHours(StartHour)); break; case TypeObject.meter: case TypeObject.meterReserve: switch (typeTree) { case 0: SetRazmA("Вт"); SetRazmR("Вар"); query = "select * , 192 as \'quality\' from MRDMGetProfileHour (" + nodeProp.IdParent + ", " + nodeProp.IdObject + ", \'" + DateTimeBeg.AddHours(StartHour) + "\', \'" + DateTimeEnd.AddHours(StartHour) + "\')"; break; case 1: SetRazmA("кВт"); SetRazmR("кВар"); query = String.Format("select * from MRDMGetAcProfileHour({0} , \'{1}\', \'{2}\', \'{3}\')", nodeProp.IdObject, nodeProp.IdType.ToString(), DateTimeBeg.AddHours(StartHour), DateTimeEnd.AddHours(StartHour)); break; } break; } Otchreport = new Simple.Reports.Profnag_sut60M(); SetNotes(Notes); SetTitle(NameObj); SetFontSize(); SetStartHour(StartHour); SetDTBeg(); break; case"Электроэнергия за сутки": case"Электроэнергия за 10 дней": case"Электроэнергия за 20 дней": case"Электроэнергия за месяц": switch(NameReport) { case"Электроэнергия за сутки": DTEnd = DateTime.Parse(DTBeg).AddDays(1).ToString(); break; case"Электроэнергия за 10 дней": DTEnd = DateTime.Parse(DTBeg).AddDays(10).ToString(); break; case"Электроэнергия за 20 дней": DTEnd = DateTime.Parse(DTBeg).AddDays(20).ToString(); break; case"Электроэнергия за месяц": DTEnd = DateTime.Parse(DTBeg).AddMonths(1).ToString(); break; } SetDTBeg(); SetTitle(NameObj); SetDTEnd(DTEnd); SetDecimalPoint(); SetFontSize(); switch(nodeProp.IdType) { case TypeObject.itec: throw new Exception("Данный отчет не поддерживается - Подсистема отчетности"); case TypeObject.group: switch (typeTree) { case 0: Otchreport = new Simple.Reports.PotrebEnergy(); query = String.Format ("select * from fGetEnergyByGrouping ({0},\'{1}\', \'{2}\', \'{3}\', \'{4}\')", nodeProp.IdObject, DTBeg , DTEnd , "кВт*ч", "кВар*ч"); break; case 1: Otchreport = new Simple.Reports.Potreb_account(); query = String.Format("select * from MRDMGetEnergyAccountByGrouping ({0}, \'{1}\', \'{2}\', \'{3}\', \'{4}\') order by Capt", nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч"); break; } break; case TypeObject.account: case TypeObject.virtualAccount: case TypeObject.accountOV: case TypeObject.accountTech: case TypeObject.oppositeLine: Otchreport = new Simple.Reports.Potreb_account(); query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt", "null", nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч"); break; case TypeObject.oik: Otchreport = new Simple.Reports.Potreb_account(); query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt", -1, nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч"); break; case TypeObject.manual: Otchreport = new Simple.Reports.Potreb_account(); query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt", -2, nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч"); break; case TypeObject.meter: Otchreport = new Simple.Reports.PotrebEnergy(); //query = "select * from fGetEnergy (null , null, " + nodeProp.IdObject + ", \'Meter\' " + // ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')"; switch (typeTree) { case 0: // Otchreport = new Simple.Reports.PotrebEnergy(); query = "select * from fGetEnergy (" + nodeProp.IdParent + ", " + nodeProp.IdObject + ", null, \'Meter\' " + ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')"; break; case 1: query = "select * from fGetEnergy (null , null, " + nodeProp.IdObject + ", \'Meter\' " + ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')"; //Otchreport = new Simple.Reports.Potreb_account(); //query = "select * from fGetEnergy (" + nodeProp.IdParent + ", " + nodeProp.IdObject + ", null, \'Meter\' " + // ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')"; //query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt", // (int)nodeProp.IdType * -1, nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч"); break; } break; case TypeObject.meterReserve: Otchreport = new Simple.Reports.PotrebEnergy(); query = "select * from fGetEnergy (null , null, " + nodeProp.IdObject + ", \'MeterReserve\' " + ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')"; //switch (typeTree) //{ // case 0: // Otchreport = new Simple.Reports.PotrebEnergy(); // query = "select * from fGetEnergy (" + nodeProp.IdParent + ", " + nodeProp.IdObject + ", \'Meter\' " + // ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')"; // break; // case 1: // Otchreport = new Simple.Reports.Potreb_account(); // query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt", // (int)nodeProp.IdType * -1, nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч"); // break; //} break; case TypeObject.subst: switch(typeTree) { case 0: Otchreport = new Simple.Reports.PotrebEnergy(); query = "select * from fGetEnergy ("+nodeProp.IdObject+", "+" null, null,\'Meter\' "+ ", \'"+ DTBeg+"\', \'"+DTEnd+"\', \'кВт*ч\', \'кВар*ч\')"; break; case 1:Otchreport = new Simple.Reports.Potreb_account(); query = "select * from MRDMGetEnergyAccount (" + nodeProp.IdObject + ", null, \'"+ DTBeg+"\', \'"+DTEnd+"\', \'кВт*ч\', \'кВар*ч\')"; break; } break; } break; case"Показания": switch(nodeProp.IdType) { case TypeObject.meter: case TypeObject.meterReserve: /* if(listobject!="") { query = "select * from fGetDataPokazannew (\'"+listobject +"\', \'"+ DTBeg +"\')"; }else */ query = "select * from fGetDataPokazan ("+nodeProp.IdParent+", "+nodeProp.IdObject+ ", \'"+ DTBeg +"\')"; break; case TypeObject.subst: query = "select * from fGetDataPokazan ("+nodeProp.IdObject+", null, \'"+ DTBeg +"\')"; break; case TypeObject.group: query = "select * from fGetDataPokazanByGrouping ("+nodeProp.IdObject+", \'"+ DTBeg +"\')"; break; } Otchreport = new Simple.Reports.Pokazn(); SetDTBeg(); SetDecimalPoint(); SetFontSize(); SetTitle(NameObj); SetRazmA("кВт*ч"); SetRazmR("кВар*ч"); break; case"Показания 5 минутные": switch(nodeProp.IdType) { case TypeObject.meter: query = "select * from fGetCurrentProfile ("+nodeProp.IdParent+", "+nodeProp.IdObject+ ", \'"+DTBeg+"\', 5)"; break; case TypeObject.subst: query = "select * from fGetCurrentProfile ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 5)"; break; } Otchreport = new Simple.Reports.Potochni_5(); SetTitle(NameObj); SetDTBeg(); SetDecimalPoint(); SetFontSize(); SetRazmA("кВт*ч"); SetRazmR("кВар*ч"); break; case"Показания 30 минутные": switch(nodeProp.IdType) { case TypeObject.meter: query = "select * from fGetCurrentProfile ("+nodeProp.IdParent+", "+nodeProp.IdObject+ ", \'"+DTBeg+"\', 30)"; break; case TypeObject.subst: query = "select * from fGetCurrentProfile ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 30)"; break; } Otchreport = new Simple.Reports.Potochni_5(); SetTitle(NameObj); SetDTBeg(); SetFontSize(); SetDecimalPoint(); SetRazmA("кВт*ч"); SetRazmR("кВар*ч"); break; case"Показания 60 минутные": switch(nodeProp.IdType) { case TypeObject.meter: query = "select * from fGetCurrentProfile ("+nodeProp.IdParent+", "+nodeProp.IdObject+ ", \'"+DTBeg+"\', 60)"; break; case TypeObject.subst: query = "select * from fGetCurrentProfile ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 60)"; break; } Otchreport = new Simple.Reports.Potochni_5(); SetTitle(NameObj); SetDTBeg(); SetFontSize(); SetDecimalPoint(); SetRazmA("кВт*ч"); SetRazmR("кВар*ч"); break; case"Протокол замеров- 30 мин": switch(nodeProp.IdType) { case TypeObject.meter: query = "select * from fGetProtocole ("+nodeProp.IdParent+", "+nodeProp.IdObject+ ", \'"+DTBeg+"\', 30)"; break; case TypeObject.subst: query = "select * from fGetProtocole ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 30)"; break; } Otchreport = new Simple.Reports.Potochni_5(); SetTitle(NameObj); SetDTBeg(); SetFontSize(); SetDecimalPoint(); SetRazmA("кВт*ч"); SetRazmR("кВар*ч"); break; case"Протокол замеров- час": switch(nodeProp.IdType) { case TypeObject.meter: query = "select * from fGetProtocole ("+nodeProp.IdParent+", "+nodeProp.IdObject+ ", \'"+DTBeg+"\', 60)"; break; case TypeObject.subst: query = "select * from fGetProtocole ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 60)"; break; } Otchreport = new Simple.Reports.Potochni_5(); SetTitle(NameObj); SetDTBeg(); SetDecimalPoint(); SetFontSize(); SetRazmA("кВт*ч"); SetRazmR("кВар*ч"); break; case"Детальный отчет за сутки": case"Детальный отчет за 10 дней": case"Детальный отчет за 20 дней": case"Детальный отчет за месяц": switch(NameReport) { case"Детальный отчет за сутки": DTEnd = DateTime.Parse(DTBeg).AddDays(1).ToString(); break; case"Детальный отчет за 10 дней": DTEnd = DateTime.Parse(DTBeg).AddDays(10).ToString(); break; case"Детальный отчет за 20 дней": DTEnd = DateTime.Parse(DTBeg).AddDays(20).ToString(); break; case"Детальный отчет за месяц": DTEnd = DateTime.Parse(DTBeg).AddMonths(1).ToString(); break; } Otchreport = new Simple.Reports.BalansEn(); SetDTBeg(); SetDecimalPoint(); SetFontSize(); SetDTEnd(DTEnd); SetRazmA("кВт/кВар*ч"); SetNameobj(); query = "select * from fGetBalanceGroupByEnergy("+nodeProp.IdObject+", \'"+ DTBeg+"\',"+"\'"+DTEnd+"\')"; break; case"Разница по дифтарифам за сутки": case"Разница по дифтарифам за месяц": query = String.Format("Select nfactory from meters where idnode={0} and idmeter = {1}", nodeProp.IdParent , nodeProp.IdObject); NameObj = String.Format("{0} ({1})", NameObj, dbWork.SelectScalar(query)); switch (NameReport) { case"Разница по дифтарифам за сутки": DTEnd = DateTime.Parse(DTBeg).AddDays(1).ToString(); Capt = NameObj+"\r\n"+ "Разница по дифтарифам за " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy"); break; case"Разница по дифтарифам за месяц": DateTime dtEnd = DateTime.Parse(DTBeg).AddMonths(1); if(dtEnd>DateTime.Now.Date) { dtEnd = DateTime.Now.Date; Capt = NameObj+"\r\n"+ "Разница по дифтарифам c " +DateTime.Parse(DTBeg).ToString("dd MMMM yyyy")+" по "+ dtEnd.ToString("dd MMMM yyyy"); } else { if(DateTime.Parse(DTBeg).Day==1) Capt = NameObj+"\r\n"+ "Разница по дифтарифам за " +DateTime.Parse(DTBeg).ToString("MMMM yyyy"); else Capt = NameObj + "\r\n" + "Разница по дифтарифам c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + dtEnd.ToString("dd MMMM yyyy"); } DTEnd = dtEnd.ToString(); break; default:Capt = NameObj+"\r\n"+ "Разница по дифтарифам c " +DateTime.Parse(DTBeg).ToString("dd MMMM yyyy")+" по "+ DateTime.Parse(DTEnd).ToString("dd MMMM yyyy"); break; } query = "select * from fGetPokaznByTarif ("+nodeProp.IdParent+","+ nodeProp.IdObject+", \'"+ DTBeg+"\',"+"\'"+DTEnd+"\')"; Otchreport = new Simple.Reports.PotrebTarif(); SetTitle(Capt); SetDecimalPoint(); SetFontSize(); break; case "Электроэнергия по дифтарифам за сутки": case "Электроэнергия по дифтарифам за месяц": case "Электроэнергия по дифтарифам": //query = String.Format("Select nfactory from meters where idnode={0} and idmeter = {1}", nodeProp.IdParent, nodeProp.IdObject); //NameObj = String.Format("{0} ({1})", NameObj, dbWork.SelectScalar(query)); switch (NameReport) { case "Электроэнергия по дифтарифам за сутки": DTEnd = DateTime.Parse(DTBeg).AddDays(1).ToString(); Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам за " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy"); break; case "Электроэнергия по дифтарифам за месяц": DateTime dtEnd = DateTime.Parse(DTBeg).AddMonths(1); if (dtEnd > DateTime.Now.Date) { dtEnd = DateTime.Now.Date; Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + dtEnd.ToString("dd MMMM yyyy"); } else { if (DateTime.Parse(DTBeg).Day == 1) Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам за " + DateTime.Parse(DTBeg).ToString("MMMM yyyy"); else Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + dtEnd.ToString("dd MMMM yyyy"); } DTEnd = dtEnd.ToString(); break; default: Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy HH:mm") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy HH:mm"); break; } //fGetPokaznAndEnergyByTarif (24432974, '25-07-2010', '26-07-2010') query = "select * from fGetPokaznAndEnergyByTarif (" + nodeProp.IdObject + ", \'" + DTBeg + "\'," + "\'" + DTEnd + "\')"; Otchreport = new Simple.Reports.EnergyByTarif(); SetTitle(Capt); SetDecimalPoint(); SetFontSize(); break; default: throw new Exception ("Нет такого отчета"); } dbWork.ExecuteTimeOut = 900; //da = dbWork.SelectSqlDA(query); //da.Fill(ds); DataTable dt = dbWork.SelectTable(query); Otchreport.Database.Tables[0].SetDataSource(dt); crDatabase = Otchreport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { crTableLogOnInfo = crTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo = crConnectionInfo; crTable.ApplyLogOnInfo(crTableLogOnInfo); } }
public void ShowTicketAnomaliesReport(DateTime StartDate, DateTime EndDate) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowTicketAnomaliesReport method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); TicketAnomaliesReport TicketAnomaliesReport = new TicketAnomaliesReport(); LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info); LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info); TicketAnomaliesReport.SetParameterValue("@StartDate", StartDate); TicketAnomaliesReport.SetParameterValue("@EndDate", EndDate); TicketAnomaliesReport.SetParameterValue("@Version", sVersion); TicketAnomaliesReport.SetParameterValue("@SiteCode", Settings.SiteCode); TicketAnomaliesReport.SetParameterValue("@SiteName", Settings.SiteName); TicketAnomaliesReport.SetParameterValue("@CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol()); TicketAnomaliesReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString); List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_TicketingConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(_TicketingConnectionString); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = "Ticketing"; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = TicketAnomaliesReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = TicketAnomaliesReport; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); // AuditReports(); strReportName = "Ticket Anomalies Report"; } catch (Exception ex) { ExceptionManager.Publish(ex); } }
internal void ShowAccountingWinLossReport(string p, DataSet dtDataset, int ZoneNo, int MachineCategoryNo, DateTime StartDate, DateTime EndDate, string ZoneName, string CategoryName, bool IncludeNonCashable) { try { CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); ConnectionInfo connectionInfo = new ConnectionInfo(); DbConnectionDetails.DatabaseName = "EXCHANGE"; connectionInfo.ServerName = DbConnectionDetails.ServerName; connectionInfo.UserID = DbConnectionDetails.UserName; connectionInfo.Password = DbConnectionDetails.Password; connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName; string sVersion, sSiteName; var vAccountingWinLossReport = new AccountingWinLossReport(); vAccountingWinLossReport.SetDataSource(dtDataset); vAccountingWinLossReport.SetParameterValue("@Zone", ZoneNo); vAccountingWinLossReport.SetParameterValue("@Category", MachineCategoryNo); vAccountingWinLossReport.SetParameterValue("@StartDate", StartDate); vAccountingWinLossReport.SetParameterValue("@EndDate", EndDate); vAccountingWinLossReport.SetParameterValue("@IncludeNonCashable", IncludeNonCashable); GetVersion_SiteName(out sVersion, out sSiteName); vAccountingWinLossReport.SetParameterValue("SiteName", sSiteName); vAccountingWinLossReport.SetParameterValue("ZoneName", ZoneName); vAccountingWinLossReport.SetParameterValue("CategoryName", CategoryName); vAccountingWinLossReport.SetParameterValue("Version", sVersion); vAccountingWinLossReport.SetParameterValue("Region", Settings.Region); vAccountingWinLossReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); vAccountingWinLossReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); vAccountingWinLossReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); vAccountingWinLossReport.SetParameterValue("SiteCode", Settings.SiteCode); crDatabase = vAccountingWinLossReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = connectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = vAccountingWinLossReport; AuditReports(); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public void ShowOutstandingVaultReport(bool ShowCassettes) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside Show Undeclared Vault Drop Report method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); UndeclaredVaultDrops UndecVaultDrp = new UndeclaredVaultDrops(); UndecVaultDrp.SetParameterValue("@GetCassette", ShowCassettes); UndecVaultDrp.SetParameterValue("SiteName", sSiteName); UndecVaultDrp.SetParameterValue("Version", sVersion); UndecVaultDrp.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); UndecVaultDrp.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); UndecVaultDrp.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); UndecVaultDrp.SetParameterValue("SiteCode", Settings.SiteCode); LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); IReports objReports = ReportsBusinessObject.CreateInstance(); List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = UndecVaultDrp.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = UndecVaultDrp; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "Undeclared Vault Drop Report"; } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(comboBox1.Text)) { MessageBox.Show("Please Select Extract No"); } else { //creating an object of ParameterField class ParameterField paramField = new ParameterField(); //creating an object of ParameterFields class ParameterFields paramFields = new ParameterFields(); //creating an object of ParameterDiscreteValue class ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); //set the parameter field name paramField.Name = "extractid"; //set the parameter value paramDiscreteValue.Value = x; //add the parameter value in the ParameterField object paramField.CurrentValues.Add(paramDiscreteValue); //add the parameter in the ParameterFields object paramFields.Add(paramField); //set the parameterfield information in the crystal report ReportViewer f2 = new ReportViewer(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); // Table table = default(Table); var with1 = reportConInfo; with1.ServerName = "tcp:KyotoServer,49172"; with1.DatabaseName = "BoardSecretariatDBKD"; with1.UserID = "sa"; with1.Password = "******"; ResolutionExtractReportedit cr = new ResolutionExtractReportedit(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } f2.crystalReportViewer1.ParameterFieldInfo = paramFields; //set the parameterfield information in the crystal report f2.crystalReportViewer1.ReportSource = cr; this.Visible = false; f2.ShowDialog(); this.Visible = true; } }
public string GenerateReport(Entities.Report report, ExportFormatType exportFormat) { string filePath = null; try { _tableLogOnInfo = new TableLogOnInfo(); _reportDocument = new ReportDocument(); connectionStringBuilder = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString); _dbConnectionInfo = new ConnectionInfo(); _tableLogOnInfo = new TableLogOnInfo(); //Create a folder if not exists if (Directory.Exists(report.DirectoryPath) == false) { Directory.CreateDirectory(report.DirectoryPath); } var serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/"); //File.AppendAllText(serverPath + "/log.txt", report.ReportPath); _reportDocument.Load(report.ReportPath); //Reading the db connection file string serverName = connectionStringBuilder.DataSource; string databaseName = connectionStringBuilder.InitialCatalog; string userId = connectionStringBuilder.UserID; string password = connectionStringBuilder.Password; _dbConnectionInfo.ServerName = serverName; _dbConnectionInfo.DatabaseName = databaseName; _dbConnectionInfo.UserID = userId; _dbConnectionInfo.Password = password; foreach (CrystalDecisions.CrystalReports.Engine.Table table in _reportDocument.Database.Tables) { _tableLogOnInfo = table.LogOnInfo; _tableLogOnInfo.ConnectionInfo = _dbConnectionInfo; table.ApplyLogOnInfo(_tableLogOnInfo); } if (report.Parameters != null) { if (report.Parameters.Count > 0) { for (int items = 0; items < report.Parameters.Count; items++) { _reportDocument.SetParameterValue(items, report.Parameters[items].ToString()); } } else if (report.Parameters.Count == 0) { _reportDocument.RecordSelectionFormula = report.RecordSelectionFormula; } } else { _reportDocument.RecordSelectionFormula = report.RecordSelectionFormula; } //serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/"); //File.AppendAllText(serverPath + "/log.txt", "Report Parameters"); _diskFileDestinationOptions = new DiskFileDestinationOptions(); //_exportOptions = new ExportOptions(); _reportFormatOptions = new PdfRtfWordFormatOptions(); _exportOptions = _reportDocument.ExportOptions; _diskFileDestinationOptions.DiskFileName = report.FileStoragePath; _exportOptions.ExportDestinationType = ExportDestinationType.DiskFile; _exportOptions.ExportFormatType = exportFormat; _exportOptions.ExportDestinationOptions = _diskFileDestinationOptions; _exportOptions.ExportFormatOptions = _reportFormatOptions; _reportDocument.Export(); //var serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/"); //File.AppendAllText(serverPath + "/log.txt", "File Storeage path " + report.FileStoragePath); filePath = report.FileStoragePath; } catch (Exception ex) { //var serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/"); //File.AppendAllText(serverPath + "/log.txt", ex.Message); throw new Exception("Error as " + ex.Message); //LogEntry.LogExceptions.WriteLog("ExportCrystalReportClassLibrary", ex.GetType().ToString(), ex.Message.ToString(), ex.Source.ToString(), "WEB"); } finally { _reportDocument.Close(); } return(filePath); }
private void ImprimeProrrogas() { try { Reports _Reporte = new Reports(); ReportDocument objReport = new ReportDocument(); //String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt"; String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "Prorrogas.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; // PARAMETROS DE CONEXION TableLogOnInfo logoninfo = new TableLogOnInfo(); logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"]; logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSISTMED"]; logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"]; logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; logoninfo.ConnectionInfo.IntegratedSecurity = false; Tables tables = objReport.Database.Tables; foreach (Table table in tables) { table.ApplyLogOnInfo(logoninfo); } // FIN PARAMETROS DE CONEXION ParameterFields Parametros = new ParameterFields(); ParameterField ParametroField = new ParameterField(); ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue(); Parametros.Clear(); //1er PARAMETRO ParametroField.Name = "@PACIENTE_ID"; ParametroValue.Value = Clases.Paciente.PacienteIngresado; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //2° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@Tipo"; if (this.radioProrrogas.Checked) { ParametroValue.Value = "PR"; } if (this.radioResumen.Checked) { ParametroValue.Value = "RE"; } ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //3° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@FechaDesde"; ParametroValue.Value = this.datefechaDesde.Value; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //4° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@FechaHasta"; ParametroValue.Value = this.datefechaHasta.Value; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); _Reporte.Parameters = Parametros; _Reporte.Reporte = objReport; _Reporte.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
protected void btnSubmit_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); string qry = "select * from invoice where consumer_No = '" + txtConsumerNo.Text + "'"; sda = new SqlDataAdapter(qry, conn); sda.Fill(ds, "invoice"); // rpt.Load(Server.MapPath("~/CrystalReport.rpt")); //rpt.FileName = Server.MapPath("~/CrystalReport.rpt"); //rpt.SetDatabaseLogon("sa", "123"); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); Tables CrTables; rpt.Load(Server.MapPath("~/billing.rpt")); ConnectionInfo crConnectionInfo = new ConnectionInfo(); rpt.FileName = Server.MapPath("~/billing.rpt"); crConnectionInfo.ServerName = "WIN-7V1OQFPKUAJ"; crConnectionInfo.DatabaseName = "kmc"; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; CrTables = rpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } //ConnectionInfo info = new ConnectionInfo(); //info.ServerName = "SPRINT-IT-PC"; //info.DatabaseName = "kmc"; //info.UserID = "sa"; //info.Password = "******"; //System.Web.UI.WebControls.Table inc = new System.Web.UI.WebControls.Table(); crv.DisplayToolbar = true; crv.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None; crv.Zoom(100); crv.HasExportButton = false; crv.HasPrintButton = true; crv.HasToggleGroupTreeButton = false; crv.HasToggleParameterPanelButton = false; crv.HasZoomFactorList = false; crv.HasCrystalLogo = false; crv.Font.Size = 8; crv.GroupTreeStyle.Font.Size = 8; crv.GroupTreeStyle.ShowLines = false; crv.ToolbarStyle.Width = Unit.Parse("2046px"); rpt.SetDataSource(ds); crv.ReportSource = rpt; // rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat,Response, true, "PersonDetails"); conn.Close(); //filepath = Server.MapPath("~/" + "test.pdf"); //rpt.ExportToDisk(ExportFormatType.PortableDocFormat, filepath); //System.IO.FileInfo fileinfo = new System.IO.FileInfo(filepath); //Response.AddHeader("Content-Disposition", "inline;filename=test.pdf"); //Response.ContentType = "application/pdf"; //Response.WriteFile(fileinfo.FullName); }
private void ShowReport(String _nome, Report_Data _dados, DataSet Ds, int Valor1) { crViewer.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; string _usuario = gtiCore.LastUser; switch (_nome) { case "CertidaoEndereco": Text = "Certidão de Endereço"; CertidaoEndereco rpt_endereco = new CertidaoEndereco(); rpt_endereco.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_endereco.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_endereco.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_endereco.SetParameterValue("CONTROLE", _dados.Controle); rpt_endereco.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_endereco.SetParameterValue("ENDERECO", _dados.Endereco); rpt_endereco.SetParameterValue("CADASTRO", _dados.Codigo); rpt_endereco.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_endereco.SetParameterValue("NOME", _dados.Nome); rpt_endereco.SetParameterValue("PROCESSO", _dados.Processo); rpt_endereco.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_endereco.SetParameterValue("QUADRA", _dados.Quadra_original); rpt_endereco.SetParameterValue("LOTE", _dados.Lote_original); rpt_endereco.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? ""); rpt_endereco.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_endereco; break; case "CertidaoImunidade": Text = "Certidão de Isenção"; CertidaoImunidade rpt_imunidade = new CertidaoImunidade(); rpt_imunidade.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_imunidade.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_imunidade.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_imunidade.SetParameterValue("CONTROLE", _dados.Controle); rpt_imunidade.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_imunidade.SetParameterValue("ENDERECO", _dados.Endereco); rpt_imunidade.SetParameterValue("CADASTRO", _dados.Codigo); rpt_imunidade.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_imunidade.SetParameterValue("NOME", _dados.Nome); rpt_imunidade.SetParameterValue("PROCESSO", _dados.Processo); rpt_imunidade.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_imunidade.SetParameterValue("ANO", _dados.AnoIsencao); rpt_imunidade.SetParameterValue("AREA", _dados.Area); rpt_imunidade.SetParameterValue("PERC", _dados.Perc_Isencao); rpt_imunidade.SetParameterValue("DOC", _dados.Cpf_cnpj ?? ""); rpt_imunidade.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_imunidade; break; case "CertidaoIsencaoProcesso": Text = "Certidão de Isenção"; CertidaoIsencaoProcesso rpt_isencao = new CertidaoIsencaoProcesso(); rpt_isencao.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_isencao.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_isencao.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_isencao.SetParameterValue("CONTROLE", _dados.Controle); rpt_isencao.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_isencao.SetParameterValue("ENDERECO", _dados.Endereco); rpt_isencao.SetParameterValue("CADASTRO", _dados.Codigo); rpt_isencao.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_isencao.SetParameterValue("NOME", _dados.Nome); rpt_isencao.SetParameterValue("NUMPROCESSO", _dados.Processo); rpt_isencao.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_isencao.SetParameterValue("NUMPROCESSOISENCAO", _dados.Processo_Isencao); rpt_isencao.SetParameterValue("DATAPROCESSOISENCAO", _dados.Data_Processo_Isencao); rpt_isencao.SetParameterValue("ANO", _dados.AnoIsencao); rpt_isencao.SetParameterValue("AREA", _dados.Area); rpt_isencao.SetParameterValue("PERC", _dados.Perc_Isencao); rpt_isencao.SetParameterValue("DOC", _dados.Cpf_cnpj ?? ""); rpt_isencao.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_isencao; break; case "CertidaoIsencao65": Text = "Certidão de Isenção"; CertidaoIsencao65 rpt_isencao65 = new CertidaoIsencao65(); rpt_isencao65.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_isencao65.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_isencao65.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_isencao65.SetParameterValue("CONTROLE", _dados.Controle); rpt_isencao65.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_isencao65.SetParameterValue("ENDERECO", _dados.Endereco); rpt_isencao65.SetParameterValue("CADASTRO", _dados.Codigo); rpt_isencao65.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_isencao65.SetParameterValue("NOME", _dados.Nome); rpt_isencao65.SetParameterValue("NUMPROCESSO", _dados.Processo); rpt_isencao65.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_isencao65.SetParameterValue("ANO", _dados.AnoIsencao); rpt_isencao65.SetParameterValue("AREA", _dados.Area); rpt_isencao65.SetParameterValue("PERC", _dados.Perc_Isencao); rpt_isencao65.SetParameterValue("DOC", _dados.Cpf_cnpj ?? ""); rpt_isencao65.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_isencao65; break; case "CertidaoValorVenal": Text = "Certidão de Valor Venal"; CertidaoValorVenal rpt_vvenal = new CertidaoValorVenal(); Tributario_bll tributario_Class = new Tributario_bll(_connection); SpCalculo RegCalculo = tributario_Class.Calculo_IPTU(Convert.ToInt32(_dados.Codigo), DateTime.Now.Year); rpt_vvenal.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_vvenal.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_vvenal.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_vvenal.SetParameterValue("CONTROLE", _dados.Controle); rpt_vvenal.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_vvenal.SetParameterValue("ENDERECO", _dados.Endereco); rpt_vvenal.SetParameterValue("CADASTRO", _dados.Codigo); rpt_vvenal.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_vvenal.SetParameterValue("NOME", _dados.Nome); rpt_vvenal.SetParameterValue("PROCESSO", _dados.Processo); rpt_vvenal.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_vvenal.SetParameterValue("QUADRA", _dados.Quadra_original); rpt_vvenal.SetParameterValue("LOTE", _dados.Lote_original); rpt_vvenal.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? ""); rpt_vvenal.SetParameterValue("VVT", RegCalculo.Vvt); rpt_vvenal.SetParameterValue("VVP", RegCalculo.Vvp); rpt_vvenal.SetParameterValue("VVI", RegCalculo.Vvi); rpt_vvenal.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_vvenal; break; case "CertidaoDebitoImovel": Text = "Certidão de Débito"; CertidaoDebitoImovel rpt_cdebitoimovel = new CertidaoDebitoImovel(); rpt_cdebitoimovel.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_cdebitoimovel.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_cdebitoimovel.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_cdebitoimovel.SetParameterValue("CONTROLE", _dados.Controle); rpt_cdebitoimovel.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_cdebitoimovel.SetParameterValue("ENDERECO", _dados.Endereco); rpt_cdebitoimovel.SetParameterValue("CADASTRO", _dados.Codigo); rpt_cdebitoimovel.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_cdebitoimovel.SetParameterValue("NOME", _dados.Nome); rpt_cdebitoimovel.SetParameterValue("TIPOCERTIDAO", _dados.TipoCertidao); rpt_cdebitoimovel.SetParameterValue("TRIBUTO", _dados.Tributos); rpt_cdebitoimovel.SetParameterValue("NAO", _dados.Nao); rpt_cdebitoimovel.SetParameterValue("ATIVIDADE", _dados.Atividade); rpt_cdebitoimovel.SetParameterValue("CIDADE", _dados.Nome_cidade); rpt_cdebitoimovel.SetParameterValue("PROCESSO", _dados.Processo); rpt_cdebitoimovel.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_cdebitoimovel.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? ""); rpt_cdebitoimovel.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_cdebitoimovel; break; case "CertidaoDebitoEmpresa": Text = "Certidão de Débito"; CertidaoDebitoEmpresa rpt_cdebitoempresa = new CertidaoDebitoEmpresa(); rpt_cdebitoempresa.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_cdebitoempresa.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_cdebitoempresa.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_cdebitoempresa.SetParameterValue("CONTROLE", _dados.Controle); rpt_cdebitoempresa.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_cdebitoempresa.SetParameterValue("ENDERECO", _dados.Endereco); rpt_cdebitoempresa.SetParameterValue("CADASTRO", _dados.Codigo); rpt_cdebitoempresa.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_cdebitoempresa.SetParameterValue("NOME", _dados.Nome); rpt_cdebitoempresa.SetParameterValue("TIPOCERTIDAO", _dados.TipoCertidao); rpt_cdebitoempresa.SetParameterValue("TRIBUTO", _dados.Tributos); rpt_cdebitoempresa.SetParameterValue("NAO", _dados.Nao); rpt_cdebitoempresa.SetParameterValue("ATIVIDADE", _dados.Atividade); rpt_cdebitoempresa.SetParameterValue("CIDADE", _dados.Nome_cidade); rpt_cdebitoempresa.SetParameterValue("PROCESSO", _dados.Processo); rpt_cdebitoempresa.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_cdebitoempresa.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? ""); rpt_cdebitoempresa.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_cdebitoempresa; break; case "CertidaoDebitoImovelPN": Text = "Certidão de Débito"; CertidaoDebitoImovelPN rpt_cdebitoimovelpn = new CertidaoDebitoImovelPN(); rpt_cdebitoimovelpn.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_cdebitoimovelpn.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_cdebitoimovelpn.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_cdebitoimovelpn.SetParameterValue("CONTROLE", _dados.Controle); rpt_cdebitoimovelpn.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_cdebitoimovelpn.SetParameterValue("ENDERECO", _dados.Endereco); rpt_cdebitoimovelpn.SetParameterValue("CADASTRO", _dados.Codigo); rpt_cdebitoimovelpn.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_cdebitoimovelpn.SetParameterValue("NOME", _dados.Nome); rpt_cdebitoimovelpn.SetParameterValue("TIPOCERTIDAO", _dados.TipoCertidao); rpt_cdebitoimovelpn.SetParameterValue("TRIBUTO", _dados.Tributos); rpt_cdebitoimovelpn.SetParameterValue("NAO", _dados.Nao); rpt_cdebitoimovelpn.SetParameterValue("ATIVIDADE", _dados.Atividade); rpt_cdebitoimovelpn.SetParameterValue("CIDADE", _dados.Nome_cidade); rpt_cdebitoimovelpn.SetParameterValue("PROCESSO", _dados.Processo); rpt_cdebitoimovelpn.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_cdebitoimovelpn.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? ""); rpt_cdebitoimovelpn.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_cdebitoimovelpn; break; case "CertidaoDebitoEmpresapn": Text = "Certidão de Débito"; CertidaoDebitoEmpresaPN rpt_cdebitoempresapn = new CertidaoDebitoEmpresaPN(); rpt_cdebitoempresapn.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados); rpt_cdebitoempresapn.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao); rpt_cdebitoempresapn.SetParameterValue("DATAEMISSAO", DateTime.Now); rpt_cdebitoempresapn.SetParameterValue("CONTROLE", _dados.Controle); rpt_cdebitoempresapn.SetParameterValue("BAIRRO", _dados.Nome_bairro); rpt_cdebitoempresapn.SetParameterValue("ENDERECO", _dados.Endereco); rpt_cdebitoempresapn.SetParameterValue("CADASTRO", _dados.Codigo); rpt_cdebitoempresapn.SetParameterValue("INSCRICAO", _dados.Inscricao); rpt_cdebitoempresapn.SetParameterValue("NOME", _dados.Nome); rpt_cdebitoempresapn.SetParameterValue("TIPOCERTIDAO", _dados.TipoCertidao); rpt_cdebitoempresapn.SetParameterValue("TRIBUTO", _dados.Tributos); rpt_cdebitoempresapn.SetParameterValue("NAO", _dados.Nao); rpt_cdebitoempresapn.SetParameterValue("ATIVIDADE", _dados.Atividade); rpt_cdebitoempresapn.SetParameterValue("CIDADE", _dados.Nome_cidade); rpt_cdebitoempresapn.SetParameterValue("PROCESSO", _dados.Processo); rpt_cdebitoempresapn.SetParameterValue("DATAPROCESSO", _dados.Data_Processo); rpt_cdebitoempresapn.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? ""); rpt_cdebitoempresapn.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'"; crViewer.ReportSource = rpt_cdebitoempresapn; break; case "Carta_Cobranca_Envelope": Carta_Cobranca_Envelope rpt_carta_cobranca_envelope = new Carta_Cobranca_Envelope(); CrTables = rpt_carta_cobranca_envelope.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } rpt_carta_cobranca_envelope.RecordSelectionFormula = "{Carta_Cobranca.Remessa}=" + Valor1; crViewer.ReportSource = rpt_carta_cobranca_envelope; break; case "Comunicado_Isencao": ComunicadoIsencao rpt_comunicado_Isencao = new GTI_Desktop.Report.ComunicadoIsencao(); CrTables = rpt_comunicado_Isencao.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } rpt_comunicado_Isencao.RecordSelectionFormula = "{Comunicado_isencao.Remessa}=" + Valor1; crViewer.ReportSource = rpt_comunicado_Isencao; break; default: break; } }//End showReport
private void frmRMostrarVentas_Load(object sender, EventArgs e) { try { string bandera = frmMostrarVentas.f1.lblBandera.Text; string fechaInicio = ""; string fechaFin = ""; DateTime fecIn; if (bandera == "1") { fechaInicio = frmMostrarVentas.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmMostrarVentas.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); } else { fecIn = Convert.ToDateTime(frmPrincipal.f1.lblFechaApertura.Text); fechaInicio = fecIn.ToString("yyyy-MM-dd HH:mm:ss"); fechaFin = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentas.rpt"); repdoc.Load(@"D:\Reportes\RVentas.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "BD_RESTAURANTE"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; /* * crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; * crConnectionInfo.DatabaseName = "db_restauranteAlmacen"; * crConnectionInfo.UserID = "martin"; * crConnectionInfo.Password = "******"; */ CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
internal void PrintLiquidationReportForProfitShare() { try { CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); ConnectionInfo connectionInfo = new ConnectionInfo(); DbConnectionDetails.DatabaseName = "Exchange"; connectionInfo.ServerName = DbConnectionDetails.ServerName; connectionInfo.UserID = DbConnectionDetails.UserName; connectionInfo.Password = DbConnectionDetails.Password; connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName; var rLiquidationReportForProfitShare = new LiquidationSummary_PS(); crDatabase = rLiquidationReportForProfitShare.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = connectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = rLiquidationReportForProfitShare; crystalReportViewer.Show(); crystalReportViewer.PrintReport(); AuditReports(); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public void ShowWeeklyExceptionSummary(int WeekID) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowWeeklyExceptionSummary method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); weekly_exception_summary_report WeeklyExceptionSummaryReport = new weekly_exception_summary_report(); LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info); LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info); WeeklyExceptionSummaryReport.SetParameterValue("WeekNo", WeekID); WeeklyExceptionSummaryReport.SetParameterValue("@WeekID", WeekID); WeeklyExceptionSummaryReport.SetParameterValue("@Currency", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol()); WeeklyExceptionSummaryReport.SetParameterValue("Version", sVersion); IReports objReports = ReportsBusinessObject.CreateInstance(); List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = WeeklyExceptionSummaryReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = WeeklyExceptionSummaryReport; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "Weekly Exception Summary Report"; } catch (Exception ex) { throw ex; } }
public void PDFGeneration() { MySqlConnection con1 = new MySqlConnection(); //SqlConnection con1 = new SqlConnection(); //con1.ConnectionString = ConfigurationManager.ConnectionStrings["DBconnection"].ConnectionString; //con1.ConnectionString = "Data Source = 123.176.34.15;port=4043;Integrated Security=False; Initial Catalog = survey; User ID = TestLogin; Password = ASD123!@#;"; con1.ConnectionString = _base.Decrypt(ConfigurationManager.ConnectionStrings["MysqlPath"].ConnectionString); //SqlDataAdapter da = new SqlDataAdapter("select * from question where submitted =1 AND MailStatus=0", con1); MySqlDataAdapter da = new MySqlDataAdapter("select * from question where submitted =1 AND MailStatus=0", con1); DataTable dt = new DataTable(); da.Fill(dt); Base @base = new Base(); foreach (DataRow dr in dt.Rows) { ReportDocument ss = new ReportDocument(); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.AllowCustomConnection = true; myConnectionInfo.ServerName = _base.Decrypt(ConfigurationManager.AppSettings["SERVERNAME"].ToString()); myConnectionInfo.DatabaseName = _base.Decrypt(ConfigurationManager.AppSettings["DATABASE"].ToString()); myConnectionInfo.IntegratedSecurity = Convert.ToBoolean(ConfigurationManager.AppSettings["INTEGRATEDSECURITY"].ToString()); myConnectionInfo.UserID = _base.Decrypt(ConfigurationManager.AppSettings["USERID"].ToString()); myConnectionInfo.Password = _base.Decrypt(ConfigurationManager.AppSettings["PASSWORD"].ToString()); myConnectionInfo.Type = ConnectionInfoType.SQL; string Rpt_Path = System.Web.Hosting.HostingEnvironment.MapPath(ConfigurationManager.AppSettings["rptLocation"].ToString()); string outputPath = System.Web.Hosting.HostingEnvironment.MapPath(ConfigurationManager.AppSettings["OutputPath_pdf"].ToString()); try { JavaScriptSerializer scr = new JavaScriptSerializer(); Question2 Que2 = (Question2)scr.Deserialize(dr["la_q2"].ToString().Replace("\\", ""), typeof(Question2)); Question4 Que4 = (Question4)scr.Deserialize(dr["la_q4"].ToString().Replace("\\", ""), typeof(Question4)); Question7 Que7 = (Question7)scr.Deserialize(dr["la_q7"].ToString().Replace("\\", ""), typeof(Question7)); question8 Que8 = (question8)scr.Deserialize(dr["la_q8"].ToString().Replace("\\", ""), typeof(question8)); //List<string> Que9 = (List<string>)scr.Deserialize(dr["la_q9"].ToString().Replace("\\", ""), typeof(List<string>)); Question11 Que11 = (Question11)scr.Deserialize(dr["la_q11"].ToString().Replace("\\", ""), typeof(Question11)); //Question15 Que15 = (Question15)scr.Deserialize(dr["la_q15"].ToString().Replace("\\", ""), typeof(Question15)); FQ1 fq1 = (FQ1)scr.Deserialize(dr["fq1"].ToString().Replace("\\", ""), typeof(FQ1)); FQ2 fq2 = (FQ2)scr.Deserialize(dr["fq2"].ToString().Replace("\\", ""), typeof(FQ2)); FQ3 fq3 = (FQ3)scr.Deserialize(dr["fq3"].ToString().Replace("\\", ""), typeof(FQ3)); string que1 = dr["la_q1"].ToString(); string que3 = dr["la_q3"].ToString(); string que5 = dr["la_q5"].ToString(); string que6 = dr["la_q6"].ToString(); string que9 = dr["la_q9"].ToString(); string que10 = dr["la_q10"].ToString(); string que12 = dr["la_q12"].ToString(); string que13 = dr["la_q13"].ToString(); string que14 = dr["la_q14"].ToString(); string que15 = dr["la_q15"].ToString(); String User_ID = dr["User_ID"].ToString(); con1.Open(); string q = "Select * from users WHERE User_ID = " + User_ID + " "; MySqlCommand cmd3 = new MySqlCommand(q, con1); //var a = cmd3.ExecuteScalar(); MySqlDataReader reader = cmd3.ExecuteReader(); MySqlUser u = new MySqlUser(); while (reader.Read()) { u.FirstName = reader.GetString("First_Name"); u.SecoundName = reader.GetString("Second_Name"); u.Email = reader.GetString("Email"); u.Compnay = reader.GetString("Company_Name"); u.UserName = reader.GetString("User_Name"); } con1.Close(); CrystalReport crypt = new CrystalReport(); crypt.SetParameterValue("Company_Name", u.Compnay); crypt.SetParameterValue("User", u.FirstName + " " + u.SecoundName); crypt.SetParameterValue("Promantus_POC", "Promantus"); crypt.SetParameterValue("Q4.1", Que4.la_q4_1); crypt.SetParameterValue("Q4.2", Que4.la_q4_2); crypt.SetParameterValue("Q4.3", Que4.la_q4_3); //crypt.SetParameterValue("Q4.5", Que4.la_q4_5.ToString()); crypt.SetParameterValue("Q6", que6); crypt.SetParameterValue("Q11", Que11.la_q11_1.ToString() + " , " + Que11.la_q11_2.ToString()); crypt.SetParameterValue("Q12", que12); crypt.SetParameterValue("Q13", que13); crypt.SetParameterValue("Q14", que14); //crypt.SetParameterValue("Q15", Que15.la_q15_1 + " , " + Que15.la_q15_2.ToString()); crypt.SetParameterValue("Q15", que15); crypt.SetParameterValue("f1", fq1.f1); crypt.SetParameterValue("f2", fq1.f2); crypt.SetParameterValue("f3", fq1.f3); crypt.SetParameterValue("f4", fq2.f4); crypt.SetParameterValue("f5", fq2.f5); crypt.SetParameterValue("f6", fq2.f6); crypt.SetParameterValue("f7", fq3.f7); crypt.SetParameterValue("f8", fq3.f8); if (que3 == "no") { if (Que4.la_q4_1 != "SAP ECC6.0" && Que4.la_q4_1 != "EHP") { crypt.SetParameterValue("Img_Op1", true); crypt.SetParameterValue("Img_Op2", false); } else { crypt.SetParameterValue("Img_Op2", true); crypt.SetParameterValue("Img_Op1", false); } } foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in crypt.Database.Tables) { TableLogOnInfo myTableLogonInfo = myTable.LogOnInfo; myTableLogonInfo.ConnectionInfo = myConnectionInfo; myTable.ApplyLogOnInfo(myTableLogonInfo); myTable.Location = myConnectionInfo.DatabaseName + ".dbo." + myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1); myTable.LogOnInfo.ConnectionInfo.ServerName = myConnectionInfo.ServerName; } CrystalReportViewer crb = new CrystalReportViewer(); crb.ReportSource = crypt; ss.Load(Rpt_Path); #region Q2 String Q2 = ""; if (Que2 != null) { if (Que2.la_q2_1 != "" && Que2.la_q2_1 != "undefined") { Q2 = Que2.la_q2_1 + ","; } if (Que2.la_q2_2 == "yes") { Q2 = Q2 + " Development,"; } if (Que2.la_q2_3 == "yes") { Q2 = Q2 + " Sandbox,"; } if (Que2.la_q2_4 == "yes") { Q2 = Q2 + " Quality / Test,"; } if (Que2.la_q2_5 == "yes") { Q2 = Q2 + " Production,"; } if (Que2.la_q2_6 != "") { Q2 = Q2 + Que2.la_q2_6;// " Any other System / Client in the SAP Landscape"; } #endregion Q2 ss.SetParameterValue("Q2", Q2); } ss.SetParameterValue("Q4.1", Que4.la_q4_1); ss.SetParameterValue("Q4.2", Que4.la_q4_2); ss.SetParameterValue("Q4.3", Que4.la_q4_3); //ss.SetParameterValue("Q4.5", Que4.la_q4_5.ToString()); ss.SetParameterValue("Q6", que6); if (que3 == "no") { if (Que4.la_q4_1 != "SAP ECC6.0" && Que4.la_q4_1 != "EHP") { ss.SetParameterValue("Img_Op1", true); ss.SetParameterValue("Img_Op2", false); } else { ss.SetParameterValue("Img_Op2", true); ss.SetParameterValue("Img_Op1", false); } } #region Q7 String Q7 = ""; if (Que7 != null) { if (Que7.la_q7_FI == "yes") { Q7 = Q7 + "Financials,"; } if (Que7.la_q7_CO == "yes") { Q7 = Q7 + " Controlling,"; } if (Que7.la_q7_MM == "yes") { Q7 = Q7 + " Materials Management,"; } if (Que7.la_q7_SD == "yes") { Q7 = Q7 + " Sales & Distribution,"; } if (Que7.la_q7_PP == "yes") { Q7 = Q7 + " Production Planning,"; } if (Que7.la_q7_QM == "yes") { Q7 = Q7 + " Quality Management,"; } if (Que7.la_q7_PS == "yes") { Q7 = " Project Systems,"; } if (Que7.la_q7_PM == "yes") { Q7 = Q7 + " Plant Maintenance,"; } if (Que7.la_q7_CS == "yes") { Q7 = Q7 + " Customer Service,"; } if (Que7.la_q7_HR == "yes") { Q7 = Q7 + " Human Resources,"; } if (Que7.la_q7_WM == "yes") { Q7 = Q7 + " Warehouse Management,"; } if (Que7.la_q7_LO_VC == "yes") { Q7 = Q7 + " Variant Configuration,"; } if (Que7.la_q7_LO_WTY == "yes") { Q7 = Q7 + " Warranty Management,"; } if (Que7.la_q7_LO_SPM == "yes") { Q7 = Q7 + " Spare Parts Management,"; } if (Que7.la_q7_other != "") { Q7 = Q7 + Que7.la_q7_other; } ss.SetParameterValue("Q7", Q7); } #endregion Q7 ss.SetParameterValue("Q11", Que11.la_q11_1.ToString() + " , " + Que11.la_q11_2.ToString()); ss.SetParameterValue("Q12", que12); ss.SetParameterValue("Q13", que13); ss.SetParameterValue("Q14", que14); ss.SetParameterValue("Q15", que15); //ss.SetParameterValue("Q15", Que15.la_q15_1 + " , " + Que15.la_q15_2.ToString()); ss.SetParameterValue("f1", fq1.f1); ss.SetParameterValue("f2", fq1.f2); ss.SetParameterValue("f3", fq1.f3); ss.SetParameterValue("f4", fq2.f4); ss.SetParameterValue("f5", fq2.f5); ss.SetParameterValue("f6", fq2.f6); ss.SetParameterValue("f7", fq3.f7); ss.SetParameterValue("f8", fq3.f8); ss.SetParameterValue("Company_Name", u.Compnay); ss.SetParameterValue("User", u.FirstName + " " + u.SecoundName); ss.SetParameterValue("Promantus_POC", "Promantus"); ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = outputPath + User_ID + ".pdf"; CrExportOptions = ss.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } ss.Export(); // con1.Open(); // string q = "Select Email from users WHERE User_ID = " + User_ID + " "; // MySqlCommand cmd3 = new MySqlCommand(q, con1); //var a= cmd3.ExecuteScalar(); Boolean S = @base.AddQuestionnaire_Mail(Convert.ToInt32(User_ID), u.Email); con1.Open(); string myQuery = "UPDATE question SET MailStatus = " + S + " WHERE User_ID = " + User_ID + " "; MySqlCommand cmd2 = new MySqlCommand(myQuery, con1); cmd2.ExecuteNonQuery(); con1.Close(); } catch (Exception ex) { _log.createLog(ex, "-->CrystalReportPDF-->Loop" + ex.Message.ToString()); } finally { if (ss != null) { ss.Close(); ss.Dispose(); } } } }
public void ShowVaultCurrentDropSlip(int Vault_Id, string VaultName, string Serial_No, string Manufacturer_Name, string Type_Prefix, string LoginUser, DateTime CreatedDate, bool IsWebServiceEnabled, decimal FillAmount, decimal TotalAmountOnFill, decimal CurrentBalance, bool _isfinaldrop) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside Show Vault Current Drop Slip method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); VaultDropTransactionSlip VaultBalance = new VaultDropTransactionSlip(); string DropType = string.Empty; if (_isfinaldrop) DropType = "Final Drop"; else DropType = "Standard Drop"; VaultBalance.SetParameterValue("@Vault_id", Vault_Id); VaultBalance.SetParameterValue("VaultName", VaultName); VaultBalance.SetParameterValue("SiteName", sSiteName); VaultBalance.SetParameterValue("SerialNo", Serial_No); VaultBalance.SetParameterValue("Type_Prefix", Type_Prefix); VaultBalance.SetParameterValue("Manufacturer_Name", Manufacturer_Name); VaultBalance.SetParameterValue("LoginUser", LoginUser); VaultBalance.SetParameterValue("CreatedDate", CreatedDate); VaultBalance.SetParameterValue("IsWebServiceEnabled", IsWebServiceEnabled); VaultBalance.SetParameterValue("FillAmount", FillAmount); VaultBalance.SetParameterValue("TotalAmountOnFill", TotalAmountOnFill); VaultBalance.SetParameterValue("CurrentBalance", CurrentBalance); VaultBalance.SetParameterValue("Version", sVersion); VaultBalance.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); VaultBalance.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); VaultBalance.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); VaultBalance.SetParameterValue("DropType", DropType); VaultBalance.SetParameterValue("SiteCode", Settings.SiteCode); LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); IReports objReports = ReportsBusinessObject.CreateInstance(); List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = VaultBalance.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = VaultBalance; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "Vault Drop Transaction Slip Report"; } catch (Exception ex) { throw ex; } }
private void frmRPagoTrabador_Load(object sender, EventArgs e) { try { ExcelFormatOptions objExcel = new ExcelFormatOptions(); string fechaInicio = ""; string fechaFin = ""; int idTrabajador = 0; if (frmReportePagoPorTrabajador.f1.cbTrabajador.Checked == true) { idTrabajador = Convert.ToInt32(frmReportePagoPorTrabajador.f1.cbEmpleado.SelectedValue); } else if (frmReportePagoPorTrabajador.f1.cbTrabajador.Checked == false) { idTrabajador = 0; } fechaInicio = frmReportePagoPorTrabajador.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmReportePagoPorTrabajador.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); //int idProducto = Convert.ToInt32(frmReporteVentasProducto.f1.cbProducto.SelectedValue); ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentaProducto.rpt"); repdoc.Load(@"D:\Reportes\RPagoTrabajador.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = idTrabajador; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@idTrabajador"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "BD_RESTAURANTE"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); objExcel.ExcelUseConstantColumnWidth = false; } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
public void ShowVarianceReport(int BatchNo, string ExchangeConn, string TicketingConn) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowVarianceReport method when Common CDO Enlable ", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); VarianceReport varianceReport = new VarianceReport(); LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info); LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info); try { varianceReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol()); } catch { varianceReport.SetParameterValue("CurrencySymbol", "£"); LogManager.WriteLog("Exception occurred at CurrencySymbol Set in ExceptionSummary...", LogManager.enumLogLevel.Info); } varianceReport.SetParameterValue("BatchNumber", BatchNo); varianceReport.SetParameterValue("@Batch_No", BatchNo); varianceReport.SetParameterValue("Version", sVersion); IReports objReports = ReportsBusinessObject.CreateInstance(ExchangeConn, TicketingConn); List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(ExchangeConn); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = varianceReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = varianceReport; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "Variance Report"; } catch (Exception ex) { throw ex; } }
private void crystalReportViewer1_Load(object sender, EventArgs e) { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); //connect //crConnectionInfo.ServerName = @"2300-WS0242\SQLEXPRESS"; //crConnectionInfo.DatabaseName = "CRM"; //crConnectionInfo.UserID = "sa"; //crConnectionInfo.Password = "******"; crConnectionInfo.ServerName = DAL.DataAccess.conn.DataSource; crConnectionInfo.DatabaseName = DAL.DataAccess.conn.Database; crConnectionInfo.UserID = DAL.DataAccess.builder.UserID; crConnectionInfo.Password = DAL.DataAccess.builder.Password; Tables CrTables; //In thong ke khach hang hien huu theo tinh, huyen, xa if (CRM.frmMain.manhinhin == 1) { rptTKKHHH rptTKKH = new rptTKKHHH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@loaikh", CRM.frmKH_TKKHHH.loaikh); rptTKKH.SetParameterValue("@tinh", CRM.frmKH_TKKHHH.tinh); rptTKKH.SetParameterValue("@huyen", CRM.frmKH_TKKHHH.huyen); rptTKKH.SetParameterValue("@xa", CRM.frmKH_TKKHHH.xa); rptTKKH.SetParameterValue("@tungay", CRM.frmKH_TKKHHH.tungay); rptTKKH.SetParameterValue("@tuthang", CRM.frmKH_TKKHHH.tuthang); rptTKKH.SetParameterValue("@denngay", CRM.frmKH_TKKHHH.denngay); rptTKKH.SetParameterValue("@denthang", CRM.frmKH_TKKHHH.denthang); rptTKKH.SetParameterValue("@cn", CRM.frmKH_TKKHHH.cn); rptTKKH.SetParameterValue("@nhomDT", CRM.frmKH_TKKHHH.nhomDT); rptTKKH.SetParameterValue("@doituongKH", CRM.frmKH_TKKHHH.doituongKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke tong hop xep loai khach hang if (CRM.frmMain.manhinhin == 2) { rptTKXLKH_TH rptTKXLKH = new rptTKXLKH_TH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKXLKH; CrTables = rptTKXLKH.Database.Tables; rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_TH.tungay); rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_TH.denngay); rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_TH.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke chi tiet xep loai khach hang if (CRM.frmMain.manhinhin == 3) { rptTKXLKH rptTKXLKH = new rptTKXLKH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKXLKH; CrTables = rptTKXLKH.Database.Tables; rptTKXLKH.SetParameterValue("@tungay", CRM.frmHH_TKXLKH.tungay); rptTKXLKH.SetParameterValue("@denngay", CRM.frmHH_TKXLKH.denngay); rptTKXLKH.SetParameterValue("@loaikh", CRM.frmHH_TKXLKH.loaikh); rptTKXLKH.SetParameterValue("@dinhtinh", CRM.frmHH_TKXLKH.dinhtinh); rptTKXLKH.SetParameterValue("@pheduyet", CRM.frmHH_TKXLKH.pheduyet); rptTKXLKH.SetParameterValue("@xeploai", CRM.frmHH_TKXLKH.xeploai); rptTKXLKH.SetParameterValue("@cn", CRM.frmHH_TKXLKH.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khach hang tiem nang theo tinh, huyen, xa if (CRM.frmMain.manhinhin == 4) { rptTKKHTN rptTKKH = new rptTKKHTN(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@loaikh", CRM.frmKH_TKKHTN.loaikh); rptTKKH.SetParameterValue("@tinh", CRM.frmKH_TKKHTN.tinh); rptTKKH.SetParameterValue("@huyen", CRM.frmKH_TKKHTN.huyen); rptTKKH.SetParameterValue("@xa", CRM.frmKH_TKKHTN.xa); rptTKKH.SetParameterValue("@tungay", CRM.frmKH_TKKHTN.tungay); rptTKKH.SetParameterValue("@tuthang", CRM.frmKH_TKKHTN.tuthang); rptTKKH.SetParameterValue("@denngay", CRM.frmKH_TKKHTN.denngay); rptTKKH.SetParameterValue("@denthang", CRM.frmKH_TKKHTN.denthang); rptTKKH.SetParameterValue("@cn", CRM.frmKH_TKKHTN.cn); rptTKKH.SetParameterValue("@nhomDT", CRM.frmKH_TKKHTN.nhomDT); rptTKKH.SetParameterValue("@doituongKH", CRM.frmKH_TKKHTN.doituongKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //Danh sach chi nhanh da thuc hien xep loai khach hang if (CRM.frmMain.manhinhin == 5) { rptDSCN rptTKXLKH = new rptDSCN(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKXLKH; CrTables = rptTKXLKH.Database.Tables; rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_TH.tungay); rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_TH.denngay); rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_TH.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khach hang tiem nang da chuyen thanh hien huu theo tinh, huyen, xa if (CRM.frmMain.manhinhin == 6) { rptTKKHTN_HH rptTKKH = new rptTKKHTN_HH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@loaikh", CRM.frmKH_TKKHTN_HH.loaikh); rptTKKH.SetParameterValue("@tinh", CRM.frmKH_TKKHTN_HH.tinh); rptTKKH.SetParameterValue("@huyen", CRM.frmKH_TKKHTN_HH.huyen); rptTKKH.SetParameterValue("@xa", CRM.frmKH_TKKHTN_HH.xa); rptTKKH.SetParameterValue("@cn", CRM.frmKH_TKKHTN_HH.cn); rptTKKH.SetParameterValue("@tungay", CRM.frmKH_TKKHTN_HH.tungay); rptTKKH.SetParameterValue("@tuthang", CRM.frmKH_TKKHTN_HH.tuthang); rptTKKH.SetParameterValue("@denngay", CRM.frmKH_TKKHTN_HH.denngay); rptTKKH.SetParameterValue("@denthang", CRM.frmKH_TKKHTN_HH.denthang); rptTKKH.SetParameterValue("@nhomDT", CRM.frmKH_TKKHTN_HH.nhomDT); rptTKKH.SetParameterValue("@doituongKH", CRM.frmKH_TKKHTN_HH.doituongKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khach hang tiem nang da duoc phan cong theo doi theo tinh, huyen, xa if (CRM.frmMain.manhinhin == 7) { rptTKKHTN_NV rptTKKH = new rptTKKHTN_NV(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; //rptTKKH.SetParameterValue("@loaikh", CRM.frmKH_TKKHTN_NV.loaikh); rptTKKH.SetParameterValue("@tinh", CRM.frmKH_TKKHTN_NV.tinh); rptTKKH.SetParameterValue("@huyen", CRM.frmKH_TKKHTN_NV.huyen); rptTKKH.SetParameterValue("@xa", CRM.frmKH_TKKHTN_NV.xa); rptTKKH.SetParameterValue("@canbo", CRM.frmKH_TKKHTN_NV.canbo); rptTKKH.SetParameterValue("@cn", CRM.frmKH_TKKHTN_NV.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khach hang da phan hoi ve chat luong SPDV if (CRM.frmMain.manhinhin == 8) { rptTKCLSPDV rptTKKH = new rptTKCLSPDV(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@tungay", CRM.frmTK_CLSPDV.tuthang); rptTKKH.SetParameterValue("@denngay", CRM.frmTK_CLSPDV.denthang); rptTKKH.SetParameterValue("@maHM", CRM.frmTK_CLSPDV.mahm); rptTKKH.SetParameterValue("@chitietHM", CRM.frmTK_CLSPDV.chitietHM); //rptTKKH.SetParameterValue("@cn", Thongtindangnhap.macn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khach hang da phan hoi ve SPDV dang su dung if (CRM.frmMain.manhinhin == 9) { rptTKSPDV rptTKKH = new rptTKSPDV(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@tungay", CRM.frmTK_SPDV.tuthang); rptTKKH.SetParameterValue("@denngay", CRM.frmTK_SPDV.denthang); rptTKKH.SetParameterValue("@luachon", CRM.frmTK_SPDV.luachon); rptTKKH.SetParameterValue("@chitietHM", CRM.frmTK_SPDV.chitietHM); //rptTKKH.SetParameterValue("@cn", Thongtindangnhap.macn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khach hang da phan hoi ve YTQT if (CRM.frmMain.manhinhin == 10) { rptTKYTQT rptTKKH = new rptTKYTQT(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@tungay", CRM.frmTK_YTQT.tuthang); rptTKKH.SetParameterValue("@denngay", CRM.frmTK_YTQT.denthang); rptTKKH.SetParameterValue("@maCT", CRM.frmTK_YTQT.maCT); rptTKKH.SetParameterValue("@chitietHM", CRM.frmTK_YTQT.chitietHM); //rptTKKH.SetParameterValue("@cn", Thongtindangnhap.macn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke chi tiet hoat dong khach hang hien huu if (CRM.frmMain.manhinhin == 11) { rptTKGDKH rptTKKH = new rptTKGDKH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@cn", frmKH_TKGD.cn); rptTKKH.SetParameterValue("@canbo", frmKH_TKGD.canbo); rptTKKH.SetParameterValue("@maKH", frmKH_TKGD.maKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke chi tiet nhan vien giao dich voi khach hang hien huu if (CRM.frmMain.manhinhin == 12) { rptTKGD rptTKKH = new rptTKGD(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@cn", frmKH_TKGD.cn); rptTKKH.SetParameterValue("@canbo", frmKH_TKGD.canbo); rptTKKH.SetParameterValue("@maKH", frmKH_TKGD.maKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke chi tiet hoat dong khach hang tiem nang if (CRM.frmMain.manhinhin == 13) { rptTKGDKH_TN rptTKKH = new rptTKGDKH_TN(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@cn", frmKH_TKGD.cn); rptTKKH.SetParameterValue("@canbo", frmKH_TKGD.canbo); rptTKKH.SetParameterValue("@maKH", frmKH_TKGD.maKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke chi tiet nhan vien giao dich voi khach hang tiem nang if (CRM.frmMain.manhinhin == 14) { rptTKGD_TN rptTKKH = new rptTKGD_TN(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@cn", frmKH_TKGD.cn); rptTKKH.SetParameterValue("@canbo", frmKH_TKGD.canbo); rptTKKH.SetParameterValue("@maKH", frmKH_TKGD.maKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke thong hop khach hang hien huu if (CRM.frmMain.manhinhin == 15) { rptTKKHHH_TH rptTKKH = new rptTKKHHH_TH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@cn", frmTKKHHH_TH.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke thong hop khach hang hien huu if (CRM.frmMain.manhinhin == 16) { rptTKKHTN_TH rptTKKH = new rptTKKHTN_TH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@cn", frmTKKHTN_TH.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 17) { rptCSKH_DKH rptCSKHDKH = new rptCSKH_DKH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptCSKHDKH; CrTables = rptCSKHDKH.Database.Tables; rptCSKHDKH.SetParameterValue("@cn", frmCSKH_TKDKH.cn); rptCSKHDKH.SetParameterValue("@tudiem", frmCSKH_TKDKH.FDiem); rptCSKHDKH.SetParameterValue("@dendiem", frmCSKH_TKDKH.TDiem); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke SDBQ khach hang if (CRM.frmMain.manhinhin == 18) { rptTKSDBQ rptTKKH = new rptTKSDBQ(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@cn", frmTKSDBQ.cn); rptTKKH.SetParameterValue("@tuthang", frmTKSDBQ.tuthang); rptTKKH.SetParameterValue("@denthang", frmTKSDBQ.denthang); //rptTKKH.SetParameterValue("@thang", frmTKSDBQ.thang); rptTKKH.SetParameterValue("@loaiKH", frmTKSDBQ.loaikh); rptTKKH.SetParameterValue("@tusdbq", frmTKSDBQ.tusdbq); rptTKKH.SetParameterValue("@densdbq", frmTKSDBQ.densdbq); rptTKKH.SetParameterValue("@maKH", frmTKSDBQ.maKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khach hang nhan tien WU if (CRM.frmMain.manhinhin == 19) { rptTKKHWU rptTKKH = new rptTKKHWU(); Cursor.Current = Cursors.WaitCursor; dsKHWU ds = new dsKHWU(); ds.Tables.Add(frmKHWU.dtKHWU.Copy()); rptTKKH.SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = rptTKKH; rptTKKH.SetParameterValue("cn", frmKHWU.cn); rptTKKH.SetParameterValue("tuthang", frmKHWU.tuthang); rptTKKH.SetParameterValue("denthang", frmKHWU.denthang); crystalReportViewer1.Refresh(); Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 20) { rptTKKHCS rptTKKH_CS = new rptTKKHCS(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH_CS; CrTables = rptTKKH_CS.Database.Tables; rptTKKH_CS.SetParameterValue("@cn", frmTK_KeHoach.cn); rptTKKH_CS.SetParameterValue("@thang", frmTK_KeHoach.thang); rptTKKH_CS.SetParameterValue("@xeploai", frmTK_KeHoach.xeploai); rptTKKH_CS.SetParameterValue("@sukien", frmTK_KeHoach.sukien); rptTKKH_CS.SetParameterValue("@loaikh", frmTK_KeHoach.loaikh); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 21) { rptTKTHKH rptTKTHKH = new rptTKTHKH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKTHKH; CrTables = rptTKTHKH.Database.Tables; rptTKTHKH.SetParameterValue("@cn", frmTK_THKH.cn); rptTKTHKH.SetParameterValue("@thang", frmTK_THKH.thang); rptTKTHKH.SetParameterValue("@xeploai", frmTK_THKH.xeploai); rptTKTHKH.SetParameterValue("@sukien", frmTK_THKH.sukien); rptTKTHKH.SetParameterValue("@kehoach", frmTK_THKH.kehoach); rptTKTHKH.SetParameterValue("@nhanqua", frmTK_THKH.nhanqua); rptTKTHKH.SetParameterValue("@loaikh", frmTK_THKH.loaikh); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khach hang hien huu theo tinh, huyen, xa if (CRM.frmMain.manhinhin == 22) { rptTKKHHH_DB rptTKKH = new rptTKKHHH_DB(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKKH; CrTables = rptTKKH.Database.Tables; rptTKKH.SetParameterValue("@loaikh", frmTKKHHH_DB.loaikh); rptTKKH.SetParameterValue("@tinh", frmTKKHHH_DB.tinh); rptTKKH.SetParameterValue("@huyen", frmTKKHHH_DB.huyen); rptTKKH.SetParameterValue("@xa", frmTKKHHH_DB.xa); rptTKKH.SetParameterValue("@tungay", frmTKKHHH_DB.tungay); rptTKKH.SetParameterValue("@tuthang", frmTKKHHH_DB.tuthang); rptTKKH.SetParameterValue("@denngay", frmTKKHHH_DB.denngay); rptTKKH.SetParameterValue("@denthang", frmTKKHHH_DB.denthang); rptTKKH.SetParameterValue("@nhomDT", CRM.frmTKKHHH_DB.nhomDT); rptTKKH.SetParameterValue("@doituongKH", CRM.frmTKKHHH_DB.doituongKH); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 23) { rptTK_VIPCT rptTKVIPCT = new rptTK_VIPCT(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKVIPCT; CrTables = rptTKVIPCT.Database.Tables; rptTKVIPCT.SetParameterValue("@cn", frmHH_TKVIPCT.cn); rptTKVIPCT.SetParameterValue("@tuthang", frmHH_TKVIPCT.tungay); rptTKVIPCT.SetParameterValue("@denthang", frmHH_TKVIPCT.denngay); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 24) { rptTKDKH_IN rptTKDKHI = new rptTKDKH_IN(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKDKHI; CrTables = rptTKDKHI.Database.Tables; rptTKDKHI.SetParameterValue("@cn", frmCSKH_TKD.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 25) { rptKHTK rptKHTK_IN = new rptKHTK(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptKHTK_IN; CrTables = rptKHTK_IN.Database.Tables; rptKHTK_IN.SetParameterValue("@cn", frmKHThamkhao.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 26) { rpt2890 rptTK2890 = new rpt2890(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTK2890; CrTables = rptTK2890.Database.Tables; rptTK2890.SetParameterValue("@cn", frmTK2890.cn); rptTK2890.SetParameterValue("@thang", frmTK2890.thang); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke tong hop xep loai khach hang (VIP) if (CRM.frmMain.manhinhin == 27) { rptTKXLKH_TH_VIP rptTKXLKH = new rptTKXLKH_TH_VIP(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKXLKH; CrTables = rptTKXLKH.Database.Tables; rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_TH_VIP.tungay); rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_TH_VIP.denngay); rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_TH_VIP.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke chi tiet xep loai khach hang VIP if (CRM.frmMain.manhinhin == 28) { rptTKXLKH_VIP rptTKXLKH = new rptTKXLKH_VIP(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKXLKH; CrTables = rptTKXLKH.Database.Tables; rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_VIP.tungay); rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_VIP.denngay); rptTKXLKH.SetParameterValue("@loaikh", CRM.frmTKXLKH_VIP.loaikh); rptTKXLKH.SetParameterValue("@dinhtinh", CRM.frmTKXLKH_VIP.dinhtinh); rptTKXLKH.SetParameterValue("@pheduyet", CRM.frmTKXLKH_VIP.pheduyet); rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_VIP.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //Danh sach chi nhanh da thuc hien xep loai khach hang if (CRM.frmMain.manhinhin == 29) { rptDSCN rptTKXLKH = new rptDSCN(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKXLKH; CrTables = rptTKXLKH.Database.Tables; rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_TH_VIP.tungay); rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_TH_VIP.denngay); rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_TH_VIP.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In phieu diem cua khach hang if (CRM.frmMain.manhinhin == 30) { DataSet1 ds = new DataSet1(); ds.Tables.Add(CRM.frmCSKH_TraCuuDiem.st_table); rptPhieudiem objRpt = new rptPhieudiem(); objRpt.DataDefinition.FormulaFields["tencn"].Text = Thongtindangnhap.tencn; objRpt.SetDataSource(ds.Tables[1]); crystalReportViewer1.ReportSource = objRpt; //objRpt.SetParameterValue("@tencn", Thongtindangnhap.tencn); crystalReportViewer1.Refresh(); } //In bao cao thong ke khach hang nhan qua if (CRM.frmMain.manhinhin == 31) { Cursor.Current = Cursors.WaitCursor; if (frmCSKH_TKQT.loaibc == "1") { rptTKQTTH rptQTTH = new rptTKQTTH(); crystalReportViewer1.ReportSource = rptQTTH; CrTables = rptQTTH.Database.Tables; rptQTTH.SetParameterValue("@tungay", CRM.frmCSKH_TKQT.tungay); rptQTTH.SetParameterValue("@denngay", CRM.frmCSKH_TKQT.denngay); rptQTTH.SetParameterValue("@macn", CRM.frmCSKH_TKQT.macn); rptQTTH.SetParameterValue("@loaibc", CRM.frmCSKH_TKQT.loaibc); rptQTTH.SetParameterValue("@quatang", CRM.frmCSKH_TKQT.quatang); } else { rptCSKH_TKQTCT rptTKQTCT = new rptCSKH_TKQTCT(); crystalReportViewer1.ReportSource = rptTKQTCT; CrTables = rptTKQTCT.Database.Tables; rptTKQTCT.SetParameterValue("@tungay", CRM.frmCSKH_TKQT.tungay); rptTKQTCT.SetParameterValue("@denngay", CRM.frmCSKH_TKQT.denngay); rptTKQTCT.SetParameterValue("@macn", CRM.frmCSKH_TKQT.macn); rptTKQTCT.SetParameterValue("@loaibc", CRM.frmCSKH_TKQT.loaibc); rptTKQTCT.SetParameterValue("@quatang", CRM.frmCSKH_TKQT.quatang); } foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke khách hàng chưa sử dụng SMS if (CRM.frmMain.manhinhin == 32) { rptTKSMS rptTKS = new rptTKSMS(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKS; CrTables = rptTKS.Database.Tables; rptTKS.SetParameterValue("@cn", CRM.frmTKSMS.cn); rptTKS.SetParameterValue("@loaikh", CRM.frmTKSMS.loaikh); rptTKS.SetParameterValue("@dthoai", CRM.frmTKSMS.dthoai); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 33) { rptTKThe rptTKT = new rptTKThe(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTKT; CrTables = rptTKT.Database.Tables; rptTKT.SetParameterValue("@cn", CRM.frmTKThe.cn); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 34) { //Thong ke spdv cua khach hang la doanh nghiep if (frmTKKHSPDV.loaikh == 2) { rptTKKHSPDVDN rptSPDVDN = new rptTKKHSPDVDN(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptSPDVDN; CrTables = rptSPDVDN.Database.Tables; rptSPDVDN.SetParameterValue("@cn", CRM.frmTKKHSPDV.cn); rptSPDVDN.SetParameterValue("@thang", CRM.frmTKKHSPDV.thang); rptSPDVDN.SetParameterValue("@loaikh", CRM.frmTKKHSPDV.loaikh); rptSPDVDN.SetParameterValue("@makh", CRM.frmTKKHSPDV.makh); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } } //Khach hang tien vay if (frmTKKHSPDV.loaikh == 5) { rptTKKHVAYSPDV rptSPDVVAY = new rptTKKHVAYSPDV(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptSPDVVAY; CrTables = rptSPDVVAY.Database.Tables; rptSPDVVAY.SetParameterValue("@cn", CRM.frmTKKHSPDV.cn); rptSPDVVAY.SetParameterValue("@thang", CRM.frmTKKHSPDV.thang); rptSPDVVAY.SetParameterValue("@loaikh", CRM.frmTKKHSPDV.loaikh); rptSPDVVAY.SetParameterValue("@makh", CRM.frmTKKHSPDV.makh); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } } //Thong ke spdv cua khach hang la ca nhan hoac nhan vien if ((frmTKKHSPDV.loaikh == 1) || (frmTKKHSPDV.loaikh == 3) || (frmTKKHSPDV.loaikh == 4)) { rptTKKHSPDVCN rptSPDVCN = new rptTKKHSPDVCN(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptSPDVCN; CrTables = rptSPDVCN.Database.Tables; rptSPDVCN.SetParameterValue("@cn", CRM.frmTKKHSPDV.cn); rptSPDVCN.SetParameterValue("@thang", CRM.frmTKKHSPDV.thang); rptSPDVCN.SetParameterValue("@loaikh", CRM.frmTKKHSPDV.loaikh); rptSPDVCN.SetParameterValue("@makh", CRM.frmTKKHSPDV.makh); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 35) { rptTK_DSBATD rptDSBATD = new rptTK_DSBATD(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptDSBATD; CrTables = rptDSBATD.Database.Tables; rptDSBATD.SetParameterValue("@cn", CRM.frmTK_BATD.chinhanh); rptDSBATD.SetParameterValue("@tungay", CRM.frmTK_BATD.tungay); rptDSBATD.SetParameterValue("@denngay", CRM.frmTK_BATD.denngay); rptDSBATD.SetParameterValue("@lhbh", CRM.frmTK_BATD.lhbh); rptDSBATD.SetParameterValue("@cbtd", CRM.frmTK_BATD.cbtd); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 36) { rptPHI_BATD rptP_BATD = new rptPHI_BATD(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptP_BATD; CrTables = rptP_BATD.Database.Tables; rptP_BATD.SetParameterValue("@cn", CRM.frmPHI_BATD.chinhanh); rptP_BATD.SetParameterValue("@tungay", CRM.frmPHI_BATD.tungay); rptP_BATD.SetParameterValue("@denngay", CRM.frmPHI_BATD.denngay); rptP_BATD.SetParameterValue("@lhbh", CRM.frmPHI_BATD.lhbh); rptP_BATD.SetParameterValue("@makh", CRM.frmPHI_BATD.makh); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } if (CRM.frmMain.manhinhin == 37) { rptHHBATD rptHH_BATD = new rptHHBATD(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptHH_BATD; CrTables = rptHH_BATD.Database.Tables; rptHH_BATD.SetParameterValue("@cn", CRM.frmHH_BATD.chinhanh); rptHH_BATD.SetParameterValue("@tungay", CRM.frmHH_BATD.tungay); rptHH_BATD.SetParameterValue("@denngay", CRM.frmHH_BATD.denngay); rptHH_BATD.SetParameterValue("@lhbh", CRM.frmHH_BATD.lhbh); rptHH_BATD.SetParameterValue("@cbtd", CRM.frmHH_BATD.cbtd); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In khach hang kieu hoi if (CRM.frmMain.manhinhin == 38) { rptTKKHNH rptTK_KHNH = new rptTKKHNH(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptTK_KHNH; CrTables = rptTK_KHNH.Database.Tables; rptTK_KHNH.SetParameterValue("@cn", CRM.frmTKKHNH.cn); rptTK_KHNH.SetParameterValue("@tuthang", CRM.frmTKKHNH.tungay); rptTK_KHNH.SetParameterValue("@denthang", CRM.frmTKKHNH.denngay); rptTK_KHNH.SetParameterValue("@loaibc", CRM.frmTKKHNH.loaibc); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In lich su diem cua khach hang if (CRM.frmMain.manhinhin == 39) { rptLichSuDiem rptLSD = new rptLichSuDiem(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptLSD; CrTables = rptLSD.Database.Tables; rptLSD.SetParameterValue("@makh", CRM.frmCSKH_ChiTiet.strmakh); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } //In thong ke nhan qua cua khach hang if (CRM.frmMain.manhinhin == 40) { rptLichSuQT rptLSQT = new rptLichSuQT(); Cursor.Current = Cursors.WaitCursor; crystalReportViewer1.ReportSource = rptLSQT; CrTables = rptLSQT.Database.Tables; rptLSQT.SetParameterValue("@makh", CRM.frmCSKH_TKQuaTang.strmakh); rptLSQT.SetParameterValue("@tungay", CRM.frmCSKH_TKQuaTang.tungay); rptLSQT.SetParameterValue("@denngay", CRM.frmCSKH_TKQuaTang.denngay); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); CrTable.Location = "CRM" + ".dbo." + CrTable.Name; } Cursor.Current = Cursors.Default; } }
public void ShowRptData() { try { string strReportName = System.Web.HttpContext.Current.Session["ReportName"].ToString(); string cardCode = System.Web.HttpContext.Current.Session["CardCode"].ToString(); string cardName = System.Web.HttpContext.Current.Session["CardName"].ToString(); string startDate = System.Web.HttpContext.Current.Session["StartDate"].ToString(); string endDate = System.Web.HttpContext.Current.Session["EndDate"].ToString(); ReportDocument rd = new ReportDocument(); string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Report//" + strReportName; ExceptionLog.Write(string.Format("the report path is {0}", strRptPath)); rd.Load(strRptPath); TableLogOnInfo logInfo = new TableLogOnInfo(); logInfo.ConnectionInfo.ServerName = "."; logInfo.ConnectionInfo.DatabaseName = "SBO_GS_TEST"; logInfo.ConnectionInfo.UserID = "sa"; logInfo.ConnectionInfo.Password = "******"; rd.Database.Tables[0].ApplyLogOnInfo(logInfo); if (!string.IsNullOrEmpty(cardName)) rd.SetParameterValue("cardname", cardName); if (!string.IsNullOrEmpty(startDate)) rd.SetParameterValue("Sdate", Convert.ToDateTime(startDate)); if (!string.IsNullOrEmpty(startDate)) rd.SetParameterValue("Edate", Convert.ToDateTime(endDate)); rd.ExportToHttpResponse(ExportFormatType.PortableDocFormat, System.Web.HttpContext.Current.Response, false, "crReport"); Session["ReportName"] = null; Session["CardCode"] = null; Session["CardName"] = null; Session["StartDate"] = null; Session["EndDate"] = null; } catch (Exception ex) { Response.Write(ex.ToString()); } }
private void CreateReport() { crDoc = new ReportDocument(); SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection(); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact the IT Department.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } SqlCommand sqlcmd = new SqlCommand(); SqlDataReader sqldr; Tables CrTables; ConnectionInfo crConnectionInfo = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); crConnectionInfo.Type = ConnectionInfoType.SQL; crConnectionInfo.ServerName = "172.16.4.12"; crConnectionInfo.DatabaseName = "PTS"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; string rpt = ""; if (rptName == "DraftPrepayInv") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "Prepayment.rpt"; crDoc.Load(rpt); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } sqlcmd = new SqlCommand("spPrepayments", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@CmpyCode", CmpyCode); sqlcmd.Parameters.AddWithValue("@QuoteNo", QuoteNo); sqlcmd.Parameters.AddWithValue("@RevNo", RevNo); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.Refresh(); } else if (rptName == "PrepayInvoice") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PrepayInvoice.rpt"; crDoc.Load(rpt); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } sqlcmd = new SqlCommand("spPrepayInvoice", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@CmpyCode", CmpyCode); sqlcmd.Parameters.AddWithValue("@InvNo", nInvNo); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; if (nQ == 1) //Preview { crReport.Refresh(); } else if (nQ == 2) //Direct Print { crDoc.PrintToPrinter(1, true, 0, 0); crReport.Visible = false; this.Dispose(); } else if (nQ == 3) { crReport.Refresh(); crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\Invoices\" + DateTime.Now.Year.ToString() + "\\" + nInvNo.ToString("0000000") + ".pdf"; crDoc.ExportOptions.DestinationOptions = objDiskOpt; crDoc.Export(); this.Dispose(); } } else if (rptName == "Invoice" || rptName == "InvoiceIngredion" || rptName == "DraftInvoiceMfst" || rptName == "InvoiceFHI" || rptName == "InvoiceOthers") { //decimal nPP = 0; if (rptName == "Invoice") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "Invoice.rpt"; } //else if (rptName == "InvoiceFHI") // rpt = @"\\gblnj4\GIS\Reports\" + "InvoiceFHI.rpt"; //else if (rptName == "InvoiceIngredion") // rpt = @"\\gblnj4\GIS\Reports\" + "IngredionInvMfst.rpt"; //else if (rptName == "DraftInvoiceMfst") // rpt = @"\\gblnj4\GIS\Reports\" + "IngredionInvMfstX.rpt"; else if (rptName == "InvoiceOthers") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoiceOthers.rpt"; } crDoc.Load(rpt); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } if (rptName == "DraftInvoiceMfst") { sqlcmd = new SqlCommand("spInvoiceX", sqlcnn); } else if (rptName == "InvoiceFHI") { sqlcmd = new SqlCommand("spFHITemplate", sqlcnn); } else if (rptName == "InvoiceOthers") { sqlcmd = new SqlCommand("spInvoiceOthers", sqlcnn); } else { sqlcmd = new SqlCommand("spInvoice", sqlcnn); } sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@InvNo", nInvNo); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); //if (rptName == "Invoice") //{ // crDoc.SetParameterValue("@InvNo", nInvNo, "InvOtherFees"); //} crReport.ReportSource = crDoc; if (nQ == 1) //Preview { crReport.Refresh(); } else if (nQ == 2) //Direct Print { //Open the PrintDialog this.printDialog1.Document = this.printDocument1; DialogResult dr = this.printDialog1.ShowDialog(); if (dr == DialogResult.OK) { //Get the Copy times int nCopy = this.printDocument1.PrinterSettings.Copies; //Get the number of Start Page int sPage = this.printDocument1.PrinterSettings.FromPage; //Get the number of End Page int ePage = this.printDocument1.PrinterSettings.ToPage; //Get the printer name string PrinterName = this.printDocument1.PrinterSettings.PrinterName; try { //Set the printer name to print the report to. By default the sample //report does not have a defult printer specified. This will tell the //engine to use the specified printer to print the report. Print out //a test page (from Printer properties) to get the correct value. crDoc.PrintOptions.PrinterName = PrinterName; //Start the printing process. Provide details of the print job //using the arguments. crDoc.PrintToPrinter(nCopy, false, sPage, ePage); } catch (Exception err) { MessageBox.Show(err.ToString()); } } crReport.Visible = false; this.Dispose(); } else if (nQ == 3) //email { crReport.Refresh(); crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\Invoices\" + DateTime.Now.Year.ToString() + @"\I-" + nInvNo.ToString("0000000") + ".pdf"; crDoc.ExportOptions.DestinationOptions = objDiskOpt; crDoc.Export(); objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\Invoices\" + DateTime.Now.Year.ToString() + @"\I-" + nInvNo.ToString("0000000") + "_" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString("00") + DateTime.Now.Day.ToString("00") + "_" + DateTime.Now.TimeOfDay.Hours.ToString("00") + DateTime.Now.TimeOfDay.Minutes.ToString("00") + DateTime.Now.TimeOfDay.Seconds.ToString("00") + ".pdf"; crDoc.Export(); this.Dispose(); } } else if (rptName == "InvoiceIngredion") { decimal nPP = 0; string strQ = "", strQNo = "", strRNo = ""; int nI = 0; DataTable dt = PSSClass.FinalBilling.LoadInvServiceFees(nInvNo); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { strQNo = dt.Rows[i]["QuoteNo"].ToString(); nI = strQNo.IndexOf("R"); strQ = strQNo.Substring(0, nI - 1); strRNo = strQNo.Substring(nI + 1, strQNo.Length - (nI + 1)); DataTable dtPP = PSSClass.FinalBilling.InvPrepay(dt.Rows[i]["CompanyCode"].ToString(), strQ, Convert.ToInt16(strRNo)); if (dtPP != null && dtPP.Rows.Count != 0) { for (int j = 0; j < dtPP.Rows.Count; j++) { nPP = nPP + Convert.ToDecimal(dtPP.Rows[j]["AmtDue"]); } } } } //string rpt = @"\\gblnj4\GIS\Reports\" + "Invoice.rpt"; rpt = @"\\gblnj4\GIS\Reports\" + "IngredionInvMfstX.rpt"; crDoc.Load(rpt); //crDoc.DataDefinition.FormulaFields["nPP"].Text = "'" + nPP.ToString() + "'"; crDoc.DataDefinition.FormulaFields["nPP"].Text = "'0'"; sqlcmd = new SqlCommand("spInvoiceX", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@InvNo", nInvNo); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; if (nQ == 1) //Preview { crReport.Refresh(); } else if (nQ == 2) //Direct Print { //Open the PrintDialog this.printDialog1.Document = this.printDocument1; DialogResult dr = this.printDialog1.ShowDialog(); if (dr == DialogResult.OK) { //Get the Copy times int nCopy = this.printDocument1.PrinterSettings.Copies; //Get the number of Start Page int sPage = this.printDocument1.PrinterSettings.FromPage; //Get the number of End Page int ePage = this.printDocument1.PrinterSettings.ToPage; //Get the printer name string PrinterName = this.printDocument1.PrinterSettings.PrinterName; try { //Set the printer name to print the report to. By default the sample //report does not have a defult printer specified. This will tell the //engine to use the specified printer to print the report. Print out //a test page (from Printer properties) to get the correct value. crDoc.PrintOptions.PrinterName = PrinterName; //Start the printing process. Provide details of the print job //using the arguments. crDoc.PrintToPrinter(nCopy, false, sPage, ePage); } catch (Exception err) { MessageBox.Show(err.ToString()); } } crReport.Visible = false; this.Dispose(); } } else if (rptName == "RptForInvoice.rpt") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "RptForInvoice.rpt"; crDoc.Load(rpt); sqlcmd = new SqlCommand("spRptForInvoice", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; //sqlcmd.Parameters.AddWithValue("@InvNo", nInvNo); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; if (nQ == 1) //Preview { crReport.Refresh(); } else if (nQ == 2) //Direct Print { crDoc.PrintToPrinter(1, true, 0, 0); crReport.Visible = false; this.Dispose(); } //else if (nQ == 3) //{ // crReport.Refresh(); // crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; // crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; // DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions(); // objDiskOpt.DiskFileName = @"\\gblnj4\GIS\Reports\I-" + nInvNo.ToString() + ".pdf"; // crDoc.ExportOptions.DestinationOptions = objDiskOpt; // crDoc.Export(); // this.Dispose(); //} } else if (rptName == "POBalance") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "POBalance.rpt"; crDoc.Load(rpt); sqlcmd = new SqlCommand("spPOBalance", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@SpID", nSpID); sqlcmd.Parameters.AddWithValue("@PONo", strPO); sqlcmd.Parameters.AddWithValue("@POBType", nPOBType); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.DataDefinition.FormulaFields["cPOBType"].Text = "'" + nPOBType.ToString() + "'"; crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; if (nQ == 1) //Preview { crReport.Refresh(); } else if (nQ == 2) //Direct Print { crDoc.PrintToPrinter(1, true, 0, 0); crReport.Visible = false; this.Dispose(); } //else if (nQ == 3) //{ // crReport.Refresh(); // crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; // crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; // DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions(); // objDiskOpt.DiskFileName = @"\\gblnj4\GIS\Reports\I-" + nInvNo.ToString() + ".pdf"; // crDoc.ExportOptions.DestinationOptions = objDiskOpt; // crDoc.Export(); // this.Dispose(); //} } else if (rptName == "POBalanceSum") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "POBalanceSum.rpt"; crDoc.Load(rpt); sqlcmd = new SqlCommand("spPOBalanceSum", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; if (nQ == 1) //Preview { crReport.Refresh(); } else if (nQ == 2) //Direct Print { crDoc.PrintToPrinter(1, true, 0, 0); crReport.Visible = false; this.Dispose(); } } else if (rptName == "SOA") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "SOA.rpt"; crDoc.Load(rpt); sqlcmd = new SqlCommand("spSOA", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@CustomerID", nSpID.ToString()); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; if (nQ == 1) //Preview { crReport.Refresh(); } else if (nQ == 2) //Direct Print { crDoc.PrintToPrinter(1, true, 0, 0); crReport.Visible = false; this.Dispose(); } else if (nQ == 3) { crReport.Refresh(); crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\SOA\" + DateTime.Now.Year.ToString() + @"\SOA-" + nSpID.ToString() + ".pdf"; crDoc.ExportOptions.DestinationOptions = objDiskOpt; crDoc.Export(); objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\SOA\" + DateTime.Now.Year.ToString() + @"\SOA-" + nSpID.ToString() + "-" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString("00") + DateTime.Now.Day.ToString("00") + "_" + DateTime.Now.TimeOfDay.Hours.ToString("00") + DateTime.Now.TimeOfDay.Minutes.ToString("00") + DateTime.Now.TimeOfDay.Seconds.ToString("00") + ".pdf"; crDoc.ExportOptions.DestinationOptions = objDiskOpt; crDoc.Export(); } } else if (rptName == "Comparative Revenue Report" || rptName == "Comparative Revenue Report - Grouped by Sponsor") { if (rptName == "Comparative Revenue Report") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoiceComparativeReport.rpt"; } else { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoiceComparativeReport-BySponsor.rpt"; } crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cStartDate"].Text = "'" + dteStart.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["cEndDate"].Text = "'" + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptInvoiceComparativeReport", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.ShowGroupTreeButton = false; crReport.Refresh(); } else if (rptName == "TTM") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "TTM.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE 12-MONTH PERIOD: " + dteStart.ToShortDateString() + " - " + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptMngtTTM", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.ShowGroupTreeButton = false; crReport.Refresh(); } else if (rptName == "Exceptions List") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "AdjustmentsList.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cStartDate"].Text = "'" + dteStart.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["cEndDate"].Text = "'" + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptAdjustmentsList", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.ShowGroupTreeButton = false; crReport.Refresh(); } else if (rptName == "Invoices To Be Posted" || rptName == "Invoices To Be Posted - Grouped by Sponsor" || rptName == "Invoices To Be Posted - Sorted by Sponsor ASC") { if (rptName == "Invoices To Be Posted") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoicesToBePosted.rpt"; } else if (rptName == "Invoices To Be Posted - Grouped by Sponsor") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoicesToBePosted_GrpBySponsor.rpt"; } else if (rptName == "Invoices To Be Posted - Sorted by Sponsor ASC") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoicesToBePostedBySponsorAsc.rpt"; } crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cStartDate"].Text = "'" + dteStart.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["cEndDate"].Text = "'" + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptInvoiceComparativeReport", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.ShowGroupTreeButton = false; crReport.Refresh(); dTable.Dispose(); } else if (rptName == "TemporaryInvoice") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoiceTemp.rpt"; crDoc.Load(rpt); sqlcmd = new SqlCommand("spInvoiceTemp", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@PONo", strPO); sqlcmd.Parameters.AddWithValue("@ConID", nConID); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.ShowGroupTreeButton = false; crReport.Refresh(); } this.WindowState = FormWindowState.Maximized; }
public void GenerateReport_Inside(string parameter) { try { ReportDocument objReport1 = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo ConInfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); if (File.Exists(_path + _reportName_Inside)) { objReport1.Load(_path + _reportName_Inside); } else { objReport1.Load(ClsConfig.LotCardPCSReportPath_Trial + _reportName_Inside); } crParameterDiscreteValue.Value = parameter; crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@LotCardGroupNo"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //objReport1.SetParameterValue("@LotCardGroupNo", _formNos.ToString().Trim(), objReport1.Subreports[0].Name.ToString()); string sUserID = ClsConfig.ReportUser; string sPassword = ClsConfig.ReportPassword_BarcodeDB; string sServerName = ClsConfig.ReportServer_BarcodeDB; string sDatabaseName = ClsConfig.ReportDatabase_BarcodeDB; crConnectionInfo.ServerName = sServerName; crConnectionInfo.DatabaseName = sDatabaseName; crConnectionInfo.UserID = sUserID; crConnectionInfo.Password = sPassword; CrTables = objReport1.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { ConInfo = CrTable.LogOnInfo; ConInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(ConInfo); } docB = objReport1; reportViewer2.ViewerCore.ReportSource = docB; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void Report1() { //creating an object of ParameterField class ParameterField paramField1 = new ParameterField(); // ParameterField paramField2 = new ParameterField(); //creating an object of ParameterFields class ParameterFields paramFields1 = new ParameterFields(); // ParameterFields paramFields2 = new ParameterFields(); //creating an object of ParameterDiscreteValue class ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue(); //ParameterDiscreteValue paramDiscreteValue2 = new ParameterDiscreteValue(); //set the parameter field name paramField1.Name = "id"; // paramField2.Name = "cheque no"; //set the parameter value paramDiscreteValue1.Value = x; //paramDiscreteValue2.Value = cmbAccountDNo.Text; //add the parameter value in the ParameterField object paramField1.CurrentValues.Add(paramDiscreteValue1); //paramField2.CurrentValues.Add(paramDiscreteValue2); //add the parameter in the ParameterFields object paramFields1.Add(paramField1); // paramFields2.Add(paramField2); //set the parameterfield information in the crystal report ReportViewer f2 = new ReportViewer(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); // Table table = default(Table); var with1 = reportConInfo; with1.ServerName = "tcp:KyotoServer,49172"; with1.DatabaseName = "BankReconciliationDBProNovember"; with1.UserID = "sa"; with1.Password = "******"; Reports.ChequeDestroy cr = new Reports.ChequeDestroy(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } f2.crystalReportViewer1.ParameterFieldInfo = paramFields1; // f2.crystalReportViewer1.ParameterFieldInfo = paramFields2; //set the parameterfield information in the crystal report f2.crystalReportViewer1.ReportSource = cr; this.Visible = false; f2.ShowDialog(); this.Visible = true; }
private void btnRptView_Click(object sender, EventArgs e) { // try // { // frmReportViewer objRpt = new frmReportViewer(); // ReportDocument objRptDoc = new ReportDocument(); // ConnectionInfo objConInfo = new ConnectionInfo(); // TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo(); // Tables objCrTables; // objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptVehInOutDet.rpt"); // objConInfo.ServerName = GeneralBLL.GetSqlServerPCName(); // objConInfo.DatabaseName = GeneralBLL.GetDatabaseName(); // objConInfo.UserID = GeneralBLL.GetDBUserName(); // objConInfo.Password = GeneralBLL.GetDBPwd(); // objConInfo.IntegratedSecurity = false; // objCrTables = objRptDoc.Database.Tables; // foreach (CrystalDecisions.CrystalReports.Engine.Table objCrTable in objCrTables) // { // objTableLogOnInfo = objCrTable.LogOnInfo; // objTableLogOnInfo.ConnectionInfo = objConInfo; // objCrTable.ApplyLogOnInfo(objTableLogOnInfo); // } // DateTime mFromDate = Convert.ToDateTime(dtpFromDate.Text); // DateTime mToDate = Convert.ToDateTime(dtpToDate.Text); // int tempValue; // string strSelect; // strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + mFromDate.ToString("yyyy-MM-dd") + "# And Date({VEHINOUTDETAIL.ENTRYDATE}) <= #" + mToDate.ToString("yyyy-MM-dd") + "# "; //// CONVERT(varchar, mFromDate, 23) // //if (cboType.Text == "ALL") // //{ // // //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# "; // // strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# "; // //} // if (cboType.Text == "COMPANY") // { // tempValue = 1; // //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + // // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + // // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue; // strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue; // } // else if (cboType.Text == "IN/OUT OTHER") // { // tempValue = 4; // //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + // // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + // // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue; // strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue; // } // objRptDoc.RecordSelectionFormula = strSelect; // objRpt.crystalReportViewer1.ReportSource = objRptDoc; // objRpt.MdiParent = this.MdiParent; // objRpt.WindowState = FormWindowState.Maximized; // objRpt.crystalReportViewer1.Refresh(); // objRpt.Show(); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); // } try { frmReportViewer objRpt = new frmReportViewer(); rptVehInOutDet objRptDoc = new rptVehInOutDet(); ConnectionInfo objConInfo = new ConnectionInfo(); TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo(); Tables objCrTables; if (cboType.Text == "COMPANY") { objRptDoc.SetParameterValue("@Type", 4); } else if (cboType.Text == "IN/OUT OTHER") { objRptDoc.SetParameterValue("@Type", 1); } objRptDoc.SetParameterValue("@FromDate", dtpFromDate.Value.Date); objRptDoc.SetParameterValue("@ToDate", dtpToDate.Value.Date); //objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptVehInOutDet.rpt"); objConInfo.ServerName = GeneralBLL.GetSqlServerPCName(); objConInfo.DatabaseName = GeneralBLL.GetDatabaseName(); objConInfo.UserID = GeneralBLL.GetDBUserName(); objConInfo.Password = GeneralBLL.GetDBPwd(); objConInfo.IntegratedSecurity = false; objCrTables = objRptDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table objCrTable in objCrTables) { objTableLogOnInfo = objCrTable.LogOnInfo; objTableLogOnInfo.ConnectionInfo = objConInfo; objCrTable.ApplyLogOnInfo(objTableLogOnInfo); } //DateTime mFromDate = Convert.ToDateTime(dtpFromDate.Text); //DateTime mToDate = Convert.ToDateTime(dtpToDate.Text); //int tempValue; //string strSelect; //strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + mFromDate.ToString("yyyy-MM-dd") + "# And Date({VEHINOUTDETAIL.ENTRYDATE}) <= #" + mToDate.ToString("yyyy-MM-dd") + "# "; //// CONVERT(varchar, mFromDate, 23) ////if (cboType.Text == "ALL") ////{ //// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# "; //// strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# "; ////} //if (cboType.Text == "COMPANY") //{ // tempValue = 1; // //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + // // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + // // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue; // strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue; //} //else if (cboType.Text == "IN/OUT OTHER") //{ // tempValue = 4; // //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + // // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + // // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue; // strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue; //} //objRptDoc.RecordSelectionFormula = strSelect; objRpt.crystalReportViewer1.ReportSource = objRptDoc; objRpt.MdiParent = this.MdiParent; objRpt.WindowState = FormWindowState.Maximized; objRpt.crystalReportViewer1.Refresh(); objRpt.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
public void GenerateReport(string parameter) { try { string _Report = string.Empty; if (_reportType == "Normal") { _Report = _reportName_Outside; } else if (_reportType == "Replacement") { _Report = _reportName_Outside_Replacement; } else { _Report = _reportName_Outside_Sample; } ReportDocument objReport1 = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo ConInfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); if (File.Exists(_path + _Report)) { objReport1.Load(_path + _Report); } else { objReport1.Load(ClsConfig.LotCardCantierReportPath_Trial + _Report); } crParameterDiscreteValue.Value = parameter; crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@LotCardGroupNo"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); string sUserID = ClsConfig.ReportUser; string sPassword = ClsConfig.ReportPassword; string sServerName = ClsConfig.ReportServer; string sDatabaseName = ClsConfig.ReportDatabase_LotCard; crConnectionInfo.ServerName = sServerName; crConnectionInfo.DatabaseName = sDatabaseName; crConnectionInfo.UserID = sUserID; crConnectionInfo.Password = sPassword; CrTables = objReport1.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { ConInfo = CrTable.LogOnInfo; ConInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(ConInfo); } docA = objReport1; reportViewer.ViewerCore.ReportSource = docA; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private bool genReport() { DataTable dtMap = new DataTable("GSOrder"); //*** DataTable Map DataSet.xsd ***// DataTable m_dt = (DataTable)Session["DATATABLE"]; DataRow dr = null; dtMap.Columns.Add(new DataColumn("RTVData", typeof(string))); dtMap.Columns.Add(new DataColumn("CustName", typeof(string))); dtMap.Columns.Add(new DataColumn("GSOrderNo", typeof(string))); dtMap.Columns.Add(new DataColumn("CreatedDate", typeof(string))); dtMap.Columns.Add(new DataColumn("Remark", typeof(string))); dtMap.Columns.Add(new DataColumn("Description", typeof(string))); dtMap.Columns.Add(new DataColumn("ProdName", typeof(string))); dtMap.Columns.Add(new DataColumn("Barcode", typeof(System.Byte[]))); for (int i = 0; i < (m_dt.Rows.Count); i++) { dr = dtMap.NewRow(); FileStream fiStream = new FileStream(Server.MapPath("~/Barcode/" + m_dt.Rows[i]["TransBillNo"].ToString() + ".jpeg"), FileMode.Open, FileAccess.Read); BinaryReader binReader = new BinaryReader(fiStream); byte[] pic1 = { }; pic1 = binReader.ReadBytes((int)fiStream.Length); fiStream.Close(); binReader.Close(); dr["RTVData"] = m_dt.Rows[i]["RTVData"]; dr["CustName"] = m_dt.Rows[i]["CustName"]; dr["GSOrderNo"] = m_dt.Rows[i]["GSOrderNo"]; dr["CreatedDate"] = m_dt.Rows[i]["CreatedDate"]; dr["Remark"] = m_dt.Rows[i]["Remark"]; dr["Description"] = m_dt.Rows[i]["Description"]; dr["ProdName"] = m_dt.Rows[i]["ProdName"]; dr["Barcode"] = pic1; dtMap.Rows.Add(dr); } ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("~/Report/GSOrderReport.rpt")); foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in rpt.Database.Tables) { TableLogOnInfo tableLogOnInfo = crTable.LogOnInfo; object connectionInfo = tableLogOnInfo.ConnectionInfo; crTable.ApplyLogOnInfo(tableLogOnInfo); } rpt.SetDataSource(dtMap); crVW.ReportSource = rpt; // crVw.RefreshReport(); return(true); }
private void toolStripButtonPrint_Click(object sender, EventArgs e) { try { StaCatalina.Forms.Reports _Reporte = new Reports(); ReportDocument objReport = new ReportDocument(); //String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt"; String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "InformeTesFacturasEnviadas.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; // PARAMETROS DE CONEXION TableLogOnInfo logoninfo = new TableLogOnInfo(); logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"]; logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"]; logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"]; logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; logoninfo.ConnectionInfo.IntegratedSecurity = false; Tables tables = objReport.Database.Tables; foreach (Table table in tables) { table.ApplyLogOnInfo(logoninfo); } // FIN PARAMETROS DE CONEXION ParameterFields Parametros = new ParameterFields(); ParameterField ParametroField = new ParameterField(); ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue(); Parametros.Clear(); //1er PARAMETRO ParametroField.Name = "@FechaDesde"; ParametroValue.Value = this.dateTimePickerFechaDesde.Value.ToString("yyyy-MM-dd 00:00:00"); ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //2° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@FechaHasta"; ParametroValue.Value = this.dateTimePickerFechaHasta.Value.ToString("yyyy-MM-dd 23:59:59"); ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //3° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@codEmp"; ParametroValue.Value = Clases.Usuario.EmpresaLogeada.EmpresaIngresada; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); _Reporte.Parameters = Parametros; _Reporte.Reporte = objReport; _Reporte.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void ShowLiquidationReportForRead(int? iBatchId, int? iReadId) { try { CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); var rptLiquidation = new LiquidationSummary_PS(); string sVersion, sSiteName; GetVersion_SiteName(out sVersion, out sSiteName); rptLiquidation.SetParameterValue("@CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); rptLiquidation.SetParameterValue("@BatchId", iBatchId); rptLiquidation.SetParameterValue("@ReadId", iReadId); rptLiquidation.SetParameterValue("BMCVersion", sVersion); rptLiquidation.SetParameterValue("@BatchId", iBatchId, "Liquidation_Summary_PS_Sub.rpt"); rptLiquidation.SetParameterValue("@ReadId", iReadId, "Liquidation_Summary_PS_Sub.rpt"); rptLiquidation.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); rptLiquidation.SetParameterValue("@CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol(), "Liquidation_Summary_PS_Sub.rpt"); rptLiquidation.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString); List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_ExchangeConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(_ExchangeConnectionString); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = rptLiquidation.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = rptLiquidation; AuditReports(); strReportName = "Report Liquidation Summary"; } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void toolStripButtonPrint_Click(object sender, EventArgs e) { try { StaCatalina.Forms.Reports _Reporte = new Reports(); ReportDocument objReport = new ReportDocument(); //String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt"; String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "PrecioUltimaCompraFactura.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; // PARAMETROS DE CONEXION TableLogOnInfo logoninfo = new TableLogOnInfo(); logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"]; logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"]; logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"]; logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; logoninfo.ConnectionInfo.IntegratedSecurity = false; Tables tables = objReport.Database.Tables; foreach (Table table in tables) { table.ApplyLogOnInfo(logoninfo); } // FIN PARAMETROS DE CONEXION ParameterFields Parametros = new ParameterFields(); ParameterField ParametroField = new ParameterField(); ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue(); Parametros.Clear(); //1er PARAMETRO ParametroField.Name = "@Anio"; ParametroValue.Value = this.textBoxAnio.Text; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //2° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@Mes"; ParametroValue.Value = this.textBoxMes.Text; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //3° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@codEmp"; ParametroValue.Value = (this.comboBoxEmpresa.SelectedIndex == 0) ? "EGES":"RSC"; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //4° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@TipoINF"; if (this.comboBoxTipoInf.SelectedIndex == 0) { ParametroValue.Value = "LPR"; } if (this.comboBoxTipoInf.SelectedIndex == 2) { ParametroValue.Value = "OSO"; } if (this.comboBoxTipoInf.SelectedIndex == 1) { ParametroValue.Value = "ART"; } ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //5° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@Articulo"; if (this.comboBoxTipoInf.SelectedIndex == 0) { ParametroValue.Value = "NULL"; } if (this.comboBoxTipoInf.SelectedIndex == 1) { ParametroValue.Value = this.comboBoxProductos.SelectedValue; } if (this.comboBoxTipoInf.SelectedIndex == 2) { ParametroValue.Value = "NULL"; } ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //6° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@ObraSocial"; if (this.comboBoxTipoInf.SelectedIndex == 0) { ParametroValue.Value = "NULL"; } if (this.comboBoxTipoInf.SelectedIndex == 1) { ParametroValue.Value = "NULL"; } if (this.comboBoxTipoInf.SelectedIndex == 2) { ParametroValue.Value = this.comboBoxObraSocial.SelectedValue; } ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); _Reporte.Parameters = Parametros; _Reporte.Reporte = objReport; _Reporte.Show(); if (checkBoxListaPreciosOS.Checked) { InformeListaPreciosXOS(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// public void ShowNonSGVILiquidationReport(DataSet dsReportsDataSet, DataSet dsSummaryReport, int BatchNo) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowLiquidationReport method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); NonSGVILiquidation LiquidationReport = new NonSGVILiquidation(); BMC.Presentation.POS.Reports.NonSGVILiquidationSummary LiquidationSummaryReport = new BMC.Presentation.POS.Reports.NonSGVILiquidationSummary(); LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info); LiquidationReport.SetDataSource(dsReportsDataSet); LiquidationSummaryReport.SetDataSource(dsSummaryReport); LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info); LiquidationReport.SetParameterValue("@Batch_No", BatchNo); LiquidationSummaryReport.SetParameterValue("@Batch_No", BatchNo); IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString); List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_ExchangeConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(_ExchangeConnectionString); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = LiquidationReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crDatabase = LiquidationSummaryReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } ReportDocument doc = LiquidationReport.OpenSubreport("NonSGVILiquidationSummary.rpt"); doc.SetDataSource(dsSummaryReport); LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = LiquidationReport; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "System Balancing Report"; } catch (Exception ex) { throw ex; } }
private void PurchaseRequisitionRpt_Load(object sender, EventArgs e) { SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection(); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact your administrator.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } ReportDocument crDoc = new ReportDocument(); SqlCommand sqlcmd = new SqlCommand(); SqlDataReader sqldr; Tables CrTables; ConnectionInfo crConnectionInfo = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); crConnectionInfo.Type = ConnectionInfoType.SQL; crConnectionInfo.ServerName = "172.16.4.12"; crConnectionInfo.DatabaseName = "PTS"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; if (DlvrTo == 1) { rptName = "PRForm16.rpt"; } else { rptName = "PRForm122.rpt"; } string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + rptName; crDoc.Load(rpt); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } sqlcmd = new SqlCommand("spRptPRForm", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@CmpyCode", CmpyCode); sqlcmd.Parameters.AddWithValue("@PRNo", PRNo); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.Refresh(); }
public void ShowPartCollection(int NoofRecords,string ExchangeConn, String TicketingConn) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowPartCollection method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); PartCollectionReport Partcol = new PartCollectionReport(); Partcol.SetParameterValue("@NumberofRecords", NoofRecords); Partcol.SetParameterValue("SiteName", sSiteName); Partcol.SetParameterValue("Version", sVersion); Partcol.SetParameterValue("Region", Settings.Region); Partcol.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol()); IReports objReports = ReportsBusinessObject.CreateInstance(ExchangeConn, TicketingConn); List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(ExchangeConn); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = Partcol.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = Partcol; AuditReports(); strReportName = "Part Collection Report"; } catch (Exception ex) { throw ex; } }
private void frmRComprasTrabajador_Load(object sender, EventArgs e) { try { string fechaInicio = frmReporteComprasTrabajador.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd"); string fechaFin = frmReporteComprasTrabajador.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd"); int idTrabajador = Convert.ToInt32(frmReporteComprasTrabajador.f1.cbProducto.SelectedValue); ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RComprasTrabajador.rpt"); repdoc.Load(@"D:\Reportes\RComprasTrabajador.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio + " 00:00:00"); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin + " 23:59:59"); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = idTrabajador; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@idTrabajador"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "SISVENTAS_CA"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; /* * crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; * crConnectionInfo.DatabaseName = "db_restauranteAlmacen"; * crConnectionInfo.UserID = "martin"; * crConnectionInfo.Password = "******";*/ CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
public void ShowVaultEventDetailReport(int Vault_Id, string Type, int No_Of_Records, string searchkey, DateTime StartDate, DateTime EndDate) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside Show Vault Event Details Report method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); CashDispenserTransactionDetails VaultEventDet = new CashDispenserTransactionDetails(); VaultEventDet.SetParameterValue("SiteCode", Settings.SiteCode); VaultEventDet.SetParameterValue("@EventType", Type); VaultEventDet.SetParameterValue("@No_Of_Records", No_Of_Records); VaultEventDet.SetParameterValue("@SearchKey", searchkey); VaultEventDet.SetParameterValue("@StartDate", StartDate); VaultEventDet.SetParameterValue("@EndDate", EndDate); VaultEventDet.SetParameterValue("SiteName", sSiteName); VaultEventDet.SetParameterValue("Version", sVersion); VaultEventDet.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); VaultEventDet.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); VaultEventDet.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); IReports objReports = ReportsBusinessObject.CreateInstance(); List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = VaultEventDet.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = VaultEventDet; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "Vault Event Details Report"; } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void CreateReport() { Tables CrTables; ConnectionInfo crConnectionInfo = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); crConnectionInfo.Type = ConnectionInfoType.SQL; crConnectionInfo.ServerName = "172.16.4.12"; crConnectionInfo.DatabaseName = "PTS"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection(); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact the IT Department.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } SqlCommand sqlcmd = new SqlCommand(); SqlDataReader sqldr; crDoc = new ReportDocument(); if (rptName == "InvYrTotal") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvYrTotal.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cYr"].Text = "'FY " + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spInvYrTotRpt", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); } else if (rptName == "LogYrTotal") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "LogYrTotal.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cGBL"].Text = "" + nGBL + ""; crDoc.DataDefinition.FormulaFields["cYr"].Text = "'FY " + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spLogYrTotRpt", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); sqlcmd.Parameters.AddWithValue("@GBL", nGBL); } else if (rptName == "RptYrTotal") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "RptYrTotal.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cGBL"].Text = "" + nGBL + ""; crDoc.DataDefinition.FormulaFields["cYr"].Text = "'FY " + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spRptYrTot", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); sqlcmd.Parameters.AddWithValue("@GBL", nGBL); } else if (rptName == "NewSponsors") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "NewSponsors.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE YEAR " + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spNewCustomers", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); } else if (rptName == "InactiveSponsors") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InactiveSponsors.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE YEAR " + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spInactiveCustomers", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); } else if (rptName == "MgmtGraph") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtSummary.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cYr"].Text = "'FY " + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spMgmtTotRpt", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); } else if (rptName == "MgmtQuoteRpt") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "QuotesByDept.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FY " + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spQuoteAnaDept", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); sqlcmd.Parameters.AddWithValue("@Sort", 1); } else if (rptName == "ProformaRev") { string rpt = ""; if (nMgmtRev >= 1 && nMgmtRev <= 4) { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "ProformaRev.rpt"; } else { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "ProformaRevSC.rpt"; } crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FY " + nYr.ToString() + "'"; if (nMgmtRev == 1) { crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'ALL SPONSORS'"; sqlcmd = new SqlCommand("spProformaRevAll", sqlcnn); } //else if (nMgmtRev == 2) //{ // crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'NON-INGREDION SPONSORS'"; // sqlcmd = new SqlCommand("spProformaRev", sqlcnn); //} //else if (nMgmtRev == 3) //{ // crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'INGREDION'"; // sqlcmd = new SqlCommand("spProformaRevIng", sqlcnn); //} else if (nMgmtRev == 4) { crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'STABILITY'"; sqlcmd = new SqlCommand("spProformaRevSta", sqlcnn); } //else if (nMgmtRev == 5) //{ // crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'STERILIZATION'"; // sqlcmd = new SqlCommand("spProformaRevSter", sqlcnn); //} sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Year", nYr); sqlcmd.Parameters.AddWithValue("@SpID", SpID); sqlcmd.Parameters.AddWithValue("@SC", SC); sqlcmd.CommandTimeout = 60; } else if (rptName == "IngredionRevenue") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "IngredionRevenue.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cYear"].Text = "'" + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spIngredionRevRpt", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); } else if (rptName == "IngredionProfDtls") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "IngredionProfDtls.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cYear"].Text = "'" + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spIngredionProfDtls", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); } else if (rptName == "MgmtRevenue") { string rpt = ""; if (nMgmtRev == 1 || nMgmtRev == 2) { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevenue.rpt"; } else if (nMgmtRev == 3 || nMgmtRev == 4) { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSC.rpt"; } else if (nMgmtRev >= 5 && nMgmtRev <= 8) { if (nMgmtRev == 5 || nMgmtRev == 6) { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSpSumm.rpt"; } else { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSpDtls.rpt"; } } else if (nMgmtRev >= 9 && nMgmtRev <= 12) { if (nMgmtRev == 9 || nMgmtRev == 10) { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSCSumm.rpt"; } else { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSCDtls.rpt"; } } crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FY " + nYr.ToString() + "'"; sqlcmd = new SqlCommand("spRevPivotRpt", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Year", nYr); if (nMgmtRev == 1 || nMgmtRev == 3 || nMgmtRev == 5 || nMgmtRev == 7 || nMgmtRev == 9 || nMgmtRev == 11) { sqlcmd.Parameters.AddWithValue("@SpID", 0); sqlcmd.Parameters.AddWithValue("@SC", 0); } else if (nMgmtRev == 2 || nMgmtRev == 4 || nMgmtRev == 6 || nMgmtRev == 8 || nMgmtRev == 10 || nMgmtRev == 12) { sqlcmd.Parameters.AddWithValue("@SpID", SpID); sqlcmd.Parameters.AddWithValue("@SC", SC); } } else if (rptName == "PSSFinancial") { sqlcnn.Close(); sqlcmd.Dispose(); sqlcnn = PSSClass.DBConnection.MDFConnection("172.16.4.12", "PTSFinancials", false, "sa", "Pass2018", ""); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact the IT Department.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } sqlcmd = new SqlCommand(); crConnectionInfo.DatabaseName = "PTSFinancials"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; this.Text = "FINANCIAL REPORT"; string strDay = ""; decimal nIT = PSSClass.Financials.IncomeTax(nYr); string[] strMonths = new string[] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" }; int[] nLYMonths = new int[] { 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 }; int[] nNLYMonths = new int[] { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 }; int nR = nYr % 4; if (nR == 0) { strDay = nLYMonths[nMo - 1].ToString(); } else { strDay = nNLYMonths[nMo - 1].ToString(); } string rpt = ""; if (nFSFormat == 0) { //rpt = Application.StartupPath + @"\Reports\" + "PSSFinancial.rpt"; rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancial.rpt"; } else if (nFSFormat == 1) { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFSSummary.rpt"; } else if (nFSFormat == 2) { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancialNoPer.rpt"; } else if (nFSFormat == 3) { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancialGL.rpt"; } crDoc.Load(rpt); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE PERIOD ENDED " + strMonths[nMo - 1].ToUpper() + " " + strDay + ", " + nYr.ToString() + "'"; crDoc.DataDefinition.FormulaFields["strMo"].Text = "'" + nMo.ToString() + "'"; crDoc.DataDefinition.FormulaFields["cTaxes"].Text = nIT.ToString(); sqlcmd = new SqlCommand("spLinkFinancial", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); } else if (rptName == "PSSFinancial_12Month") { sqlcnn.Close(); sqlcmd.Dispose(); sqlcnn = PSSClass.DBConnection.MDFConnection("172.16.4.12", "PTSFinancials", false, "sa", "Pass2018", ""); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact the IT Department.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } sqlcmd = new SqlCommand(); crConnectionInfo.DatabaseName = "PTSFinancials"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; this.Text = "FINANCIAL REPORT::12 MONTH OVERVIEW"; string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancial_12Month.rpt"; //string strDay = ""; //decimal nIT = PSSClass.Financials.IncomeTax(nYr); //string[] strMonths = new string[] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" }; //int[] nLYMonths = new int[] { 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 }; //int[] nNLYMonths = new int[] { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 }; //int nR = nYr % 4; //if (nR == 0) // strDay = nLYMonths[nMo - 1].ToString(); //else // strDay = nNLYMonths[nMo - 1].ToString(); //string rpt = ""; //if (nFSFormat == 0) // rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancial_12Month.rpt"; //else if (nFSFormat == 1) // rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFSSummary.rpt"; //else if (nFSFormat == 2) // rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancialNoPer.rpt"; //else if (nFSFormat == 3) // rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancialGL.rpt"; crDoc.Load(rpt); CrTables = crDoc.Database.Tables; //foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) //{ // crtableLogoninfo = CrTable.LogOnInfo; // crtableLogoninfo.ConnectionInfo = crConnectionInfo; // CrTable.ApplyLogOnInfo(crtableLogoninfo); //} //crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE PERIOD ENDED " + strMonths[nMo - 1].ToUpper() + " " + strDay + ", " + nYr.ToString() + "'"; //crDoc.DataDefinition.FormulaFields["strMo"].Text = "'" + nMo.ToString() + "'"; //crDoc.DataDefinition.FormulaFields["cTaxes"].Text = nIT.ToString(); sqlcmd = new SqlCommand("spLinkFinancial", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); } else if (rptName.IndexOf("Variance") != -1) { this.Text = "VARIANCE REPORT - BUDGET VS. ACTUAL"; string strDay = ""; string rpt = ""; decimal nIT = PSSClass.Financials.IncomeTax(nYr); string[] strMonths = new string[] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" }; int[] nLYMonths = new int[] { 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 }; int[] nNLYMonths = new int[] { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 }; int nR = nYr % 4; if (nR == 0) { strDay = nLYMonths[nMo - 1].ToString(); } else { strDay = nNLYMonths[nMo - 1].ToString(); } if (rptName == "VarianceYTD") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "Variance.rpt"; } else if (rptName == "VarianceMonthly") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "VarianceMonthly.rpt"; } else { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "VarianceQtrly.rpt"; } crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cMo"].Text = "'" + nMo.ToString() + "'"; crDoc.DataDefinition.FormulaFields["cYr"].Text = "'" + nYr.ToString() + "'"; crDoc.DataDefinition.FormulaFields["cDay"].Text = "'" + strDay + "'"; crDoc.DataDefinition.FormulaFields["cQtr"].Text = "'" + nQtr.ToString() + "'"; } else if (rptName == "TestsCompleted") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "TestsCompleted.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptTestsCompleted", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); sqlcmd.Parameters.AddWithValue("@DeptList", strDept); //nDeptID } else if (rptName == "OutstandingTests") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "OutstandingTests.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptOutstandingGBLTesting", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); sqlcmd.Parameters.AddWithValue("@DeptList", strDept); //nDeptID } else if (rptName == "TestsForCompletion") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "TestsForCompletion.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptTestsForCompletion", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); } else if (rptName == "StabilityReport") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "StabilityReport-New.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'RANGE PERIOD: " + dteStart.ToShortDateString() + " - " + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spStabilityReport", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@SDate", dteStart); sqlcmd.Parameters.AddWithValue("@EDate", dteEnd); } else if (rptName == "StudyDirReport") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "StudyDirRpt.rpt"; crDoc.Load(rpt); if (dteStart == dteEnd) { crDoc.DataDefinition.FormulaFields["strPeriod"].Text = "'FOR THE PERIOD: " + dteStart.ToShortDateString() + "'"; } else { crDoc.DataDefinition.FormulaFields["strPeriod"].Text = "'FOR THE PERIOD: " + dteStart.ToShortDateString() + " - " + dteEnd.ToShortDateString() + "'"; } sqlcmd = new SqlCommand("spStudyDirReport", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); sqlcmd.Parameters.AddWithValue("@SDID", nSDID); } else if (rptName == "UnmailedReports") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "UnmailedReports.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptUnmailedReports", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); } else if (rptName == "EqptServiceSched") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "EquipmentServiceSched.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptEqptSrvcSched", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); } else if (rptName == "SCDepartments") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "SCDepartments.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'" + dteStart.ToShortDateString() + " - " + dteEnd.ToShortDateString() + "'"; sqlcmd = new SqlCommand("spRptDeptSCSP", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", dteStart); sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd); sqlcmd.Parameters.AddWithValue("@DeptID", nDeptID); sqlcmd.Parameters.AddWithValue("@SC", SC); } else if (rptName == "DocExpiring") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "DocExpiring.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'As of " + DateTime.Now.ToString("MMMM dd, yyyy") + "'"; sqlcmd = new SqlCommand("spDocExpiringAlert", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; } else if (rptName == "SpeedResponse") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "SpeedResponse.rpt"; string strSpName = PSSClass.Sponsors.SpName(SpID); crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cYr"].Text = "'" + nYr.ToString("###0") + "'"; crDoc.DataDefinition.FormulaFields["cMo"].Text = "'" + nMo.ToString("###0") + "'"; crDoc.DataDefinition.FormulaFields["cSpID"].Text = "'" + SpID.ToString() + "'"; crDoc.DataDefinition.FormulaFields["cSpName"].Text = "'" + strSpName + "'"; } else if (rptName == "RptGBLErrors") { string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "RptGBLErrors.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["cYr"].Text = "'" + nYr.ToString() + "'"; crDoc.DataDefinition.FormulaFields["cGBL"].Text = "'" + nGBL.ToString() + "'"; sqlcmd = new SqlCommand("spRptGBLErrors", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@Yr", nYr); sqlcmd.Parameters.AddWithValue("@IncGBL", nGBL); sqlcmd.CommandTimeout = 60; } DataTable dTable = new DataTable(); if (rptName == "PSSFinancial") { dTable = PSSClass.Financials.AcctSummary(nYr); } else if (rptName == "PSSFinancial_12Month") { dTable = PSSClass.Financials.AcctSummary(nYr); } else if (rptName.IndexOf("Variance") != -1) { dTable = dtRpt; } else if (rptName == "SpeedResponse") { dTable.Columns.Add("Category", typeof(int)); dTable.Columns.Add("NoDays", typeof(int)); dTable.Columns.Add("DayCount", typeof(int)); //LogTests Start Date DataTable dtX = PSSClass.ManagementReports.SpeedResponse(1, Convert.ToInt16(nYr), Convert.ToInt16(nMo), "LT.StartDate", Convert.ToInt16(SpID)); for (int i = 0; i < dtX.Rows.Count; i++) { DataRow dR = dTable.NewRow(); dR["Category"] = dtX.Rows[i]["Category"]; dR["NoDays"] = dtX.Rows[i]["NoDays"]; dR["DayCount"] = dtX.Rows[i]["DayCount"]; dTable.Rows.Add(dR); } //FinalRptLog DateOn LogTests End Date dtX = PSSClass.ManagementReports.SpeedResponse(2, Convert.ToInt16(nYr), Convert.ToInt16(nMo), "FL.DateOn", Convert.ToInt16(SpID)); for (int i = 0; i < dtX.Rows.Count; i++) { DataRow dR = dTable.NewRow(); dR["Category"] = dtX.Rows[i]["Category"]; dR["NoDays"] = dtX.Rows[i]["NoDays"]; dR["DayCount"] = dtX.Rows[i]["DayCount"]; dTable.Rows.Add(dR); } //LogTests End Date dtX = PSSClass.ManagementReports.SpeedResponse(3, Convert.ToInt16(nYr), Convert.ToInt16(nMo), "LT.EndDate", Convert.ToInt16(SpID)); for (int i = 0; i < dtX.Rows.Count; i++) { DataRow dR = dTable.NewRow(); dR["Category"] = dtX.Rows[i]["Category"]; dR["NoDays"] = dtX.Rows[i]["NoDays"]; dR["DayCount"] = dtX.Rows[i]["DayCount"]; dTable.Rows.Add(dR); } //FinalRptLog DateOff dtX = PSSClass.ManagementReports.SpeedResponse(4, Convert.ToInt16(nYr), Convert.ToInt16(nMo), "FL.DateOff", Convert.ToInt16(SpID)); for (int i = 0; i < dtX.Rows.Count; i++) { DataRow dR = dTable.NewRow(); dR["Category"] = dtX.Rows[i]["Category"]; dR["NoDays"] = dtX.Rows[i]["NoDays"]; dR["DayCount"] = dtX.Rows[i]["DayCount"]; dTable.Rows.Add(dR); } //LogTest Start Date vs FinalRptLog DateOn dtX = PSSClass.ManagementReports.SpeedResponseSD(4, Convert.ToInt16(nYr), Convert.ToInt16(nMo), Convert.ToInt16(SpID)); for (int i = 0; i < dtX.Rows.Count; i++) { DataRow dR = dTable.NewRow(); dR["Category"] = dtX.Rows[i]["Category"]; dR["NoDays"] = dtX.Rows[i]["NoDays"]; dR["DayCount"] = dtX.Rows[i]["DayCount"]; dTable.Rows.Add(dR); } } else { sqldr = sqlcmd.ExecuteReader(); try { dTable.Load(sqldr); } catch { } } crDoc.SetDataSource(dTable); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crReport.ReportSource = crDoc; crReport.ShowGroupTreeButton = false; crReport.Refresh(); sqlcnn.Close(); sqlcnn.Dispose(); this.WindowState = FormWindowState.Maximized; }
internal void ShowCrossPropertyLiabilityTransferSummaryReport(string p, DataSet dtDataset, DateTime StartDate, DateTime EndDate) { try { CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); ConnectionInfo connectionInfo = new ConnectionInfo(); DbConnectionDetails.DatabaseName = "TICKETING"; connectionInfo.ServerName = DbConnectionDetails.ServerName; connectionInfo.UserID = DbConnectionDetails.UserName; connectionInfo.Password = DbConnectionDetails.Password; connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName; string sVersion, sSiteName; var vCrossPropertyLiabilityTransferSummaryReport = new CrossPropertyLiabilityTransferSummaryReport(); vCrossPropertyLiabilityTransferSummaryReport.SetDataSource(dtDataset); vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("@STARTDATE", StartDate); vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("@ENDDATE", EndDate); GetVersion_SiteName(out sVersion, out sSiteName); vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("SiteCode", Settings.SiteCode); vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("siteName", sSiteName); vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("BMCVersion", sVersion); vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); crDatabase = vCrossPropertyLiabilityTransferSummaryReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = connectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = vCrossPropertyLiabilityTransferSummaryReport; AuditReports(); strReportName = "Cross Property Liability Transfer Summary Report"; } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void toolStripButtonPrint_Click(object sender, EventArgs e) { try { StaCatalina.Forms.Reports _Reporte = new Reports(); ReportDocument objReport = new ReportDocument(); //String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt"; String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "InformeRequerimientosInternos.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; // PARAMETROS DE CONEXION TableLogOnInfo logoninfo = new TableLogOnInfo(); logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"]; logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"]; logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"]; logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; logoninfo.ConnectionInfo.IntegratedSecurity = false; Tables tables = objReport.Database.Tables; foreach (Table table in tables) { table.ApplyLogOnInfo(logoninfo); } // FIN PARAMETROS DE CONEXION ParameterFields Parametros = new ParameterFields(); ParameterField ParametroField = new ParameterField(); ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue(); Parametros.Clear(); //1er PARAMETRO ParametroField.Name = "@FechaDesde"; ParametroValue.Value = this.dateTimePickerFechaDesde.Value.ToString("yyyy-MM-dd 00:00:00"); ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //2° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@FechaHasta"; ParametroValue.Value = this.dateTimePickerFechaHasta.Value.ToString("yyyy-MM-dd 23:59:59"); ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //3er PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@Tipo"; if (this.radioButtonTodo.Checked) { ParametroValue.Value = "TOD"; } if (this.radioButtonAnulados.Checked) { ParametroValue.Value = "ANU"; } if (this.radioButtonRechazados.Checked) { ParametroValue.Value = "REC"; } if (this.radioButtonAutorizados.Checked) { ParametroValue.Value = "AUT"; } if (this.radioButtonPendientes.Checked) { ParametroValue.Value = "PEN"; } if (this.radioButtonSectorUnico.Checked) { ParametroValue.Value = "SEC"; } if (this.radioButtonPorNro.Checked) { ParametroValue.Value = "NRO"; } ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //4° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@codEmp"; ParametroValue.Value = Clases.Usuario.EmpresaLogeada.EmpresaIngresada.ToString(); ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //5° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@Sector"; if (this.radioButtonSectorUnico.Checked) { ParametroValue.Value = Clases.Usuario.UsuarioLogeado.Id_Sector; } else { ParametroValue.Value = null; } ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //6° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@usuario_id"; ParametroValue.Value = Clases.Usuario.UsuarioLogeado.id_usuario_Logeado; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); //7° PARAMETRO ParametroField = new ParameterField(); ParametroValue = new ParameterDiscreteValue(); ParametroField.Name = "@NroReq"; ParametroValue.Value = Convert.ToInt32(textBoxNroReq.Text == "" ? "0" : textBoxNroReq.Text); ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); _Reporte.Parameters = Parametros; _Reporte.Reporte = objReport; _Reporte.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void ShowStackerLevelDetailReport(DataSet dsStackerDetails, int StackerLevel,string siteCode) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowStackerLevelDetailReport method", LogManager.enumLogLevel.Info); StackerLevelDetailsReport stackerDetailReport = new StackerLevelDetailsReport(); GetVersion_SiteName(out sVersion, out sSiteName); LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info); stackerDetailReport.SetDataSource(dsStackerDetails); stackerDetailReport.SetParameterValue("SiteName", sSiteName); stackerDetailReport.SetParameterValue("Version", sVersion); stackerDetailReport.SetParameterValue("@StackerLevel", StackerLevel); stackerDetailReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); stackerDetailReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); stackerDetailReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol()); stackerDetailReport.SetParameterValue("SiteCode", siteCode); //stackerDetailReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture, "StackerLevelDetailsReport.rpt"); //stackerDetailReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol(), "StackerLevelDetailsReport.rpt"); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); ConnectionInfo connectionInfo = new ConnectionInfo(); DbConnectionDetails.DatabaseName = "EXCHANGE"; connectionInfo.ServerName = DbConnectionDetails.ServerName; connectionInfo.UserID = DbConnectionDetails.UserName; connectionInfo.Password = DbConnectionDetails.Password; connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName; crDatabase = stackerDetailReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = connectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } crystalReportViewer.ReportSource = stackerDetailReport; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "Stacker Level Details Report"; } catch (Exception ex) { throw ex; } }
private void btnPrint_Click(object sender, EventArgs e) { try { Reports _Reporte = new Reports(); ReportDocument objReport = new ReportDocument(); //String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt"; if (radioIM.Checked) { String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "IndicacionesMedicas.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; } else if (chckVertical.Checked) { String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "HojaEnfermeriaVertical.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; } else { String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "HojaEnfermeria.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; } // PARAMETROS DE CONEXION TableLogOnInfo logoninfo = new TableLogOnInfo(); logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"]; logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSISTMED"]; logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"]; logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; logoninfo.ConnectionInfo.IntegratedSecurity = false; Tables tables = objReport.Database.Tables; foreach (Table table in tables) { table.ApplyLogOnInfo(logoninfo); } // FIN PARAMETROS DE CONEXION ParameterFields Parametros = new ParameterFields(); ParameterField ParametroField = new ParameterField(); ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue(); Parametros.Clear(); //1er PARAMETRO ParametroField.Name = "@PACIENTE_ID"; ParametroValue.Value = Clases.Paciente.PacienteIngresado; ParametroField.CurrentValues.Add(ParametroValue); Parametros.Add(ParametroField); ////2° PARAMETRO //ParametroField = new ParameterField(); //ParametroValue = new ParameterDiscreteValue(); //ParametroField.Name = "@TODOS"; //ParametroValue.Value = this.radioTodos.Checked; //ParametroField.CurrentValues.Add(ParametroValue); //Parametros.Add(ParametroField); ////3° PARAMETRO //ParametroField = new ParameterField(); //ParametroValue = new ParameterDiscreteValue(); //ParametroField.Name = "@SEDE"; //ParametroValue.Value = Clases.Paciente.PacienteSede; //ParametroField.CurrentValues.Add(ParametroValue); //Parametros.Add(ParametroField); _Reporte.Parameters = Parametros; _Reporte.Reporte = objReport; _Reporte.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void ShowCollectionReport(int BatchNo, int WeekNo) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowBatchWinLossReport method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); CollectionReport oCollectionReport = new CollectionReport(); LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info); LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info); oCollectionReport.SetParameterValue("@BatchNo", BatchNo); oCollectionReport.SetParameterValue("@WeekCollection", WeekNo > 0 ? true : false); oCollectionReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol()); oCollectionReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); oCollectionReport.SetParameterValue("Version", sVersion); oCollectionReport.SetParameterValue("Region", Settings.Region); IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString); List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_ExchangeConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(BMC.Business.CashDeskOperator.CommonUtilities.SiteConnectionString(_ExchangeConnectionString)); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = oCollectionReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = oCollectionReport; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "batch winloss report"; } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { Response.Write("test3ed"); Response.End(); // since we are using Crystal to do everything, the web page is built here if (!IsPostBack) { Session["dtPrint"] = null; if (Session["UserName"] == null) { UserPrefix = "NoUser"; } else { UserPrefix = Session["UserName"].ToString().Trim(); } if (Request.QueryString["ShipperNo"] != null) { ShipperNo = Request.QueryString["ShipperNo"].ToString(); // clear out any previous exports first DirectoryInfo OldPages = new DirectoryInfo(Server.MapPath(@"SOEShipper")); // Get a reference to each file in that directory. FileInfo[] AllOldPages = OldPages.GetFiles(); // go through the files foreach (FileInfo OldPage in AllOldPages) { if (OldPage.Name.Substring(0, UserPrefix.Length) == UserPrefix) { OldPage.Delete(); } } // load the crystal report using the path in an app pref record DataSet dsAppPref = new DataSet(); dsAppPref = SqlHelper.ExecuteDataset(connectionString, "[UGEN_SP_Select]", new SqlParameter("@tableName", "AppPref with (NOLOCK)"), new SqlParameter("@displayColumns", "AppOptionValue"), new SqlParameter("@whereCondition", " (ApplicationCd = 'SOE') AND (AppOptionType = 'InvoiceLocation')")); CrystalPath = dsAppPref.Tables[0].Rows[0]["AppOptionValue"].ToString(); Response.Write("Windows Account which runs ASP.NET is: " + Environment.Username); Response.Write("test3"); Response.End(); try { ShipperDoc.Load(CrystalPath + "SOEShipper.rpt", OpenReportMethod.OpenReportByTempCopy); } catch (Exception ex) { throw ex; } // set the database connections for the report SqlConnectionStringBuilder ConnectBuilder = new SqlConnectionStringBuilder(); ConnectBuilder.ConnectionString = connectionString; ConnectionInfo ConnectInfo = new ConnectionInfo(); ConnectInfo.DatabaseName = ConnectBuilder["Initial Catalog"].ToString(); ConnectInfo.UserID = ConnectBuilder["User Id"].ToString(); ConnectInfo.Password = ConnectBuilder["Password"].ToString(); ConnectInfo.ServerName = ConnectBuilder["Data Source"].ToString(); // AutoDataBind="true" foreach (CrystalDecisions.CrystalReports.Engine.Table ShipperTable in ShipperDoc.Database.Tables) { TableLogOnInfo ShipperTableLogonInfo = ShipperTable.LogOnInfo; ShipperTableLogonInfo.ConnectionInfo = ConnectInfo; ShipperTable.ApplyLogOnInfo(ShipperTableLogonInfo); } ShipperDoc.RecordSelectionFormula = "{SOHeaderRel.OrderNo}=" + ShipperNo; // we are ready to go ShipperDoc.Refresh(); // Now set up the export DiskFileDestinationOptions diskOpts = ExportOptions.CreateDiskFileDestinationOptions(); ExportOptions exportOpts = new ExportOptions(); exportOpts.ExportFormatType = ExportFormatType.HTML40; exportOpts.ExportDestinationType = ExportDestinationType.DiskFile; exportOpts.ExportDestinationOptions = diskOpts; HTMLFormatOptions htmlFormatOpts = new HTMLFormatOptions(); htmlFormatOpts.FirstPageNumber = 1; htmlFormatOpts.HTMLEnableSeparatedPages = true; htmlFormatOpts.HTMLHasPageNavigator = false; htmlFormatOpts.HTMLBaseFolderName = Server.MapPath(""); htmlFormatOpts.HTMLFileName = UserPrefix + "ShipperExport.htm"; exportOpts.ExportFormatOptions = htmlFormatOpts; ShipperDoc.Export(exportOpts); ShipperDoc.Close(); // now that we have created the individual pages, make one big page DirectoryInfo PageFiles = new DirectoryInfo(Server.MapPath(@"SOEShipper")); // Get a reference to each file in that directory. FileInfo[] AllPages = PageFiles.GetFiles(); // start the HTML page Response.Write("<head>\n"); // write the styles Response.Write("<style type=\"text/css\">\n"); Response.Write(".barcode{height:30px;font-size:15pt;color:#000000;font-family:IDAutomationC39M;font-weight:normal;overflow:hidden;}\n"); Response.Write("</style>\n"); // finish the header start the body Response.Write("\n<title>Shipper Document</title>\n</head>\n<body LEFTMARGIN=31 TOPMARGIN=31 >\n"); PagePosition = (decimal)0.0; foreach (FileInfo InvPage in AllPages) { // get only the files for the current user if (InvPage.Name.Substring(0, UserPrefix.Length) == UserPrefix) { WriteOK = false; Response.Write("<DIV style=\"position:absolute; left:0px; top:" + PagePosition.ToString() + "pt; height:590px \">\n"); //Response.Write(""); using (StreamReader sr = new StreamReader(InvPage.FullName)) { String line; // Read and display lines from the file until the end of // the file is reached. while ((line = sr.ReadLine()) != null) { if (line.Contains("</BODY>")) { WriteOK = false; } if (line.Contains("<style>")) { WriteOK = true; } if (line.Contains("images/")) { line = line.Replace("images/", ConfigurationManager.AppSettings["SOESiteURL"].ToString() + "SOEShipper/images/"); } // write the line if (WriteOK) { Response.Write(line + "\n"); } if (line.Contains("</style>")) { WriteOK = false; } if (line.Contains("<BODY")) { WriteOK = true; } } } Response.Write("</DIV>\n"); if (PagePosition == (decimal)0.0) { PagePosition += (decimal)590; } } } Response.Write("</body>\n</html>\n"); } } }
private static void GetLogoninfo(TableLogOnInfo li, XmlWriter writer) { WriteAndTraceStartElement(writer, "Logoninfo"); writer.WriteAttributeString("ReportName", li.ReportName); writer.WriteAttributeString("TableName", li.TableName); GetConnectioInfo(li.ConnectionInfo, writer); writer.WriteEndElement(); }
private bool GenerarPDFOC(string _codEmp, int _NroOrdenCompra, string Email) { try { StaCatalina.Forms.Reports _Reporte = new Reports(); ReportDocument objReport = new ReportDocument(); String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "OrdenDeCompra.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; // PARAMETROS DE CONEXION TableLogOnInfo logoninfo = new TableLogOnInfo(); logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"]; logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"]; logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"]; logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; logoninfo.ConnectionInfo.IntegratedSecurity = false; Tables tables = objReport.Database.Tables; foreach (Table table in tables) { table.ApplyLogOnInfo(logoninfo); } //PAOS LOS PARAMTROS EN ORDEN objReport.SetParameterValue(0, _codEmp); objReport.SetParameterValue(1, "OC"); objReport.SetParameterValue(2, _NroOrdenCompra); objReport.SetParameterValue(3, _NroOrdenCompra); objReport.SetParameterValue(4, null); objReport.SetParameterValue(5, null); objReport.SetParameterValue(6, 1); objReport.SetParameterValue(7, ""); objReport.SetParameterValue(8, null); objReport.SetParameterValue(9, null); //GUARDO EN FORMATO PDF string _path = ConfigurationManager.AppSettings["PDF"] + "\\PDF\\" + "OrdenDeCompra.PDF"; objReport.ExportToDisk(ExportFormatType.PortableDocFormat, _path); //_codEmp = (_codEmp == "EGES") ? "EGESAC S.A." : "RSC S.A."; if (EnviarMail(_codEmp, _path, Email)) { return(true); } else { return(false); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
/// <summary> /// Thiết lập các thông tin kết nối cơ sở dữ liệu cho báo cáo /// </summary> /// <param name="reportDocument"></param> private void SetDBLogonForReport(ReportDocument reportDocument) { crConnectioninfo = new ConnectionInfo(); crConnectioninfo.ServerName = WorkingContext.Setting.Server; crConnectioninfo.DatabaseName = WorkingContext.Setting.Database; crConnectioninfo.UserID = WorkingContext.Setting.UserName; crConnectioninfo.Password = WorkingContext.Setting.Password; crTables = reportDocument.Database.Tables; crDatabase = reportDocument.Database; crTables = crDatabase.Tables; foreach (Table crTable in crTables) { try { crTableLogOnInfo = crTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo = crConnectioninfo; crTable.ApplyLogOnInfo(crTableLogOnInfo); } catch { string str = WorkingContext.LangManager.GetString("frmListReport_thongbao"); string str1 = WorkingContext.LangManager.GetString("frmListReport_thongbao_Title"); //MessageBox.Show("Không thể đăng nhập được vào cơ sở dữ liệu","Thông báo",MessageBoxButtons.OK,MessageBoxIcon.Error); MessageBox.Show(str, str1, MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
protected void Page_Load(object sender, EventArgs e) { // since we are using Crystal to do everything, the web page is built here if (!IsPostBack) { Session["dtPrint"] = null; if (Session["UserName"] == null) { UserPrefix = "NoUser"; } else { UserPrefix = Session["UserName"].ToString().Trim(); } if ((Request.QueryString["InvoiceNo"] != null) || (Request.QueryString["OrderNo"] != null)) { // clear out any previous exports first DirectoryInfo OldPages = new DirectoryInfo(Server.MapPath(DocName)); if (OldPages.Exists) { // Get a reference to each file in that directory. FileInfo[] AllOldPages = OldPages.GetFiles(); // go through the files foreach (FileInfo OldPage in AllOldPages) { if (OldPage.Name.Substring(0, UserPrefix.Length) == UserPrefix) { OldPage.Delete(); } } } // get the TEST watermark indicator DataSet dsAppPref = new DataSet(); dsAppPref = SqlHelper.ExecuteDataset(connectionString, "[UGEN_SP_Select]", new SqlParameter("@tableName", "SystemMaster with (NOLOCK)"), new SqlParameter("@displayColumns", "PrintRqst"), new SqlParameter("@whereCondition", " SystemMasterID = 0")); PrintRequest = dsAppPref.Tables[0].Rows[0]["PrintRqst"].ToString().Trim(); // load the crystal report using the path in an app pref record dsAppPref = SqlHelper.ExecuteDataset(connectionString, "[UGEN_SP_Select]", new SqlParameter("@tableName", "AppPref with (NOLOCK)"), new SqlParameter("@displayColumns", "AppOptionValue"), new SqlParameter("@whereCondition", " (ApplicationCd = 'SOE') AND (AppOptionType = 'InvoiceLocation')")); CrystalPath = dsAppPref.Tables[0].Rows[0]["AppOptionValue"].ToString(); RGRDoc.Load(CrystalPath + DocName + ".rpt", OpenReportMethod.OpenReportByTempCopy); // set the database connections for the report SqlConnectionStringBuilder ConnectBuilder = new SqlConnectionStringBuilder(); ConnectBuilder.ConnectionString = connectionString; ConnectionInfo ConnectInfo = new ConnectionInfo(); ConnectInfo.DatabaseName = ConnectBuilder["Initial Catalog"].ToString(); ConnectInfo.UserID = ConnectBuilder["User Id"].ToString(); ConnectInfo.Password = ConnectBuilder["Password"].ToString(); ConnectInfo.ServerName = ConnectBuilder["Data Source"].ToString(); // AutoDataBind="true" foreach (CrystalDecisions.CrystalReports.Engine.Table RGRTable in RGRDoc.Database.Tables) { TableLogOnInfo RGRTableLogonInfo = RGRTable.LogOnInfo; RGRTableLogonInfo.ConnectionInfo = ConnectInfo; RGRTable.ApplyLogOnInfo(RGRTableLogonInfo); } // set the selection criteria if (Request.QueryString["InvoiceNo"] != null) { RGRDoc.RecordSelectionFormula = "{SOHeaderHist.InvoiceNo}=\"" + Request.QueryString["InvoiceNo"].ToString() + "\" and isnull({SODetailHist.DeleteDt})"; } if (Request.QueryString["OrderNo"] != null) { RGRDoc.RecordSelectionFormula = "{SOHeaderHist.OrderNo}=" + Request.QueryString["OrderNo"].ToString() + " and isnull({SODetailHist.DeleteDt})"; } // we are ready to go RGRDoc.Refresh(); // Now set up the export DiskFileDestinationOptions diskOpts = ExportOptions.CreateDiskFileDestinationOptions(); ExportOptions exportOpts = new ExportOptions(); exportOpts.ExportFormatType = ExportFormatType.HTML40; exportOpts.ExportDestinationType = ExportDestinationType.DiskFile; exportOpts.ExportDestinationOptions = diskOpts; HTMLFormatOptions htmlFormatOpts = new HTMLFormatOptions(); htmlFormatOpts.FirstPageNumber = 1; htmlFormatOpts.HTMLEnableSeparatedPages = true; htmlFormatOpts.HTMLHasPageNavigator = false; htmlFormatOpts.HTMLBaseFolderName = Server.MapPath(""); htmlFormatOpts.HTMLFileName = UserPrefix + "InvoiceExport.htm"; exportOpts.ExportFormatOptions = htmlFormatOpts; // set the parameters if (PrintRequest == "T") { RGRDoc.SetParameterValue("IsTest", true); } else { RGRDoc.SetParameterValue("IsTest", false); } // Export the report to separate html files RGRDoc.Export(exportOpts); RGRDoc.Close(); // now that we have created the individual pages, make one big page DirectoryInfo PageFiles = new DirectoryInfo(Server.MapPath(DocName)); // Get a reference to each file in that directory. FileInfo[] AllPages = PageFiles.GetFiles(); // start the HTML page Response.Write("<head>\n<title>RGR Document</title>\n"); if ((Request.QueryString["ScriptX"] != null) && (Request.QueryString["ScriptX"] == "YES")) { // Embed ScriptX objects using (StreamReader sr = new StreamReader(Server.MapPath("common/include/ScriptX.inc"))) { String incline; // Read and display lines from the Spriptx include file while ((incline = sr.ReadLine()) != null) { Response.Write(incline + "\n"); } } // Load ScriptX javascript function Response.Write("<script src=\"" + ConfigurationManager.AppSettings["SOESiteURL"].ToString() + "Common/JavaScript/ScriptX.js\" type=\"text/javascript\"></script>\n"); } Response.Write("</head>\n<body style=\"margin: 0px\" >\n"); PagePosition = (decimal)0.0; foreach (FileInfo InvPage in AllPages) { // get only the files for the current user if (InvPage.Name.Substring(0, UserPrefix.Length) == UserPrefix) { WriteOK = false; Response.Write("<DIV style=\"position:absolute; top:" + PagePosition.ToString() + "pt; height:1000px \">\n"); //Response.Write(""); using (StreamReader sr = new StreamReader(InvPage.FullName)) { String line; // Read and display lines from the file until the end of // the file is reached. while ((line = sr.ReadLine()) != null) { if (line.Contains("</BODY>")) { WriteOK = false; } if (line.Contains("<style>")) { WriteOK = true; } if (line.Contains("class=\"crystalstyle\"")) { line = line.Replace("31", "0"); } if (line.Contains("images/")) { line = line.Replace("images/", ConfigurationManager.AppSettings["SOESiteURL"].ToString() + DocName + "/images/"); } if (line.Contains("<DIV style=\"position:absolute; top:")) { WriteOK = false; } if (line.Contains("</TR></TABLE></CENTER></Div>")) { WriteOK = false; } // write the line if (WriteOK) { Response.Write(line + "\n"); } if (line.Contains("</style>")) { WriteOK = false; } if (line.Contains("<BODY")) { WriteOK = true; } } } Response.Write("</DIV>\n"); if (PagePosition == (decimal)0.0) { PagePosition += (decimal)757; } } } Response.Write("</body>\n"); if ((Request.QueryString["ScriptX"] != null) && (Request.QueryString["ScriptX"] == "YES")) { Response.Write("<script language=\"javascript\">\n"); Response.Write("SetPrintSettings(true, 0.25, 0.25, 0.25, 0.25);\n"); Response.Write("</script>\n"); } Response.Write("</html>\n"); } } }
private bool genReport() { DataTable dtMap = new DataTable("job"); //*** DataTable Map DataSet.xsd ***// DataTable m_dt = (DataTable)Session["DATATABLE"]; DataRow dr = null; dtMap.Columns.Add(new DataColumn("job_id", typeof(string))); dtMap.Columns.Add(new DataColumn("job_name", typeof(string))); dtMap.Columns.Add(new DataColumn("job_date", typeof(string))); dtMap.Columns.Add(new DataColumn("place_get_job", typeof(string))); dtMap.Columns.Add(new DataColumn("container_type", typeof(string))); dtMap.Columns.Add(new DataColumn("container_dim", typeof(string))); dtMap.Columns.Add(new DataColumn("cust_dest", typeof(string))); dtMap.Columns.Add(new DataColumn("code_name", typeof(string))); dtMap.Columns.Add(new DataColumn("appointed_time", typeof(string))); dtMap.Columns.Add(new DataColumn("doc_no", typeof(string))); dtMap.Columns.Add(new DataColumn("place_send_job", typeof(string))); dtMap.Columns.Add(new DataColumn("send_company", typeof(string))); dtMap.Columns.Add(new DataColumn("remark", typeof(string))); dtMap.Columns.Add(new DataColumn("barcode", typeof(System.Byte[]))); FileStream fiStream = new FileStream(Server.MapPath("~/Barcode/" + m_dt.Rows[0]["job_id"].ToString() + ".jpeg"), FileMode.Open, FileAccess.Read); BinaryReader binReader = new BinaryReader(fiStream); byte[] pic1 = { }; pic1 = binReader.ReadBytes((int)fiStream.Length); fiStream.Close(); binReader.Close(); for (int i = 0; i < (m_dt.Rows.Count); i++) { dr = dtMap.NewRow(); dr["job_id"] = m_dt.Rows[i]["job_id"]; dr["job_name"] = m_dt.Rows[i]["job_name"]; dr["job_date"] = m_dt.Rows[i]["job_date"]; dr["place_get_job"] = m_dt.Rows[i]["place_get_job"]; dr["container_type"] = m_dt.Rows[i]["container_type"]; dr["container_dim"] = m_dt.Rows[i]["container_dim"]; dr["cust_dest"] = m_dt.Rows[i]["cust_dest"]; dr["code_name"] = m_dt.Rows[i]["code_name"]; dr["appointed_time"] = m_dt.Rows[i]["appointed_time"]; dr["doc_no"] = m_dt.Rows[i]["doc_no"]; dr["place_send_job"] = m_dt.Rows[i]["place_send_job"]; dr["send_company"] = m_dt.Rows[i]["send_company"]; dr["remark"] = m_dt.Rows[i]["remark"]; dr["Barcode"] = pic1; dtMap.Rows.Add(dr); } ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("~/Report/job.rpt")); foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in rpt.Database.Tables) { TableLogOnInfo tableLogOnInfo = crTable.LogOnInfo; object connectionInfo = tableLogOnInfo.ConnectionInfo; crTable.ApplyLogOnInfo(tableLogOnInfo); } rpt.SetDataSource(dtMap); crVw.ReportSource = rpt; // crVw.RefreshReport(); return(true); }
private void Generate_Reports() { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; cryRpt.Load(Server.MapPath("Graph.rpt")); //crConnectionInfo.ServerName = "213.171.197.149,49296"; //crConnectionInfo.DatabaseName = "DBCML"; //crConnectionInfo.UserID = "CMLT"; //crConnectionInfo.Password = "******"; crConnectionInfo.ServerName = Constants.CMLTConstants.serverName; crConnectionInfo.DatabaseName = Constants.CMLTConstants.dbName; crConnectionInfo.UserID = Constants.CMLTConstants.dbUserName; crConnectionInfo.Password = Constants.CMLTConstants.dbPassword; CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } //string _s = "MEP"; //string selectionformula = "{CAS_RPT.BZONE}='" + _s + "' and {CAS_RPT.CATE}=\"DB\""; //SelectionFormula(cryRpt, (string)Session["zone"], (string)Session["cat"], (string)Session["flvl"], (string)Session["fed"]); string _graph = ""; _graph = "Summary - " + drtype.SelectedItem.Text; if ((string)Session["zone"] == null) { Session["zone"] = "All"; } if ((string)Session["flvl"] == null) { Session["flvl"] = "All"; } if ((string)Session["cat"] == null) { Session["cat"] = "All"; } if ((string)Session["fed"] == null) { Session["fed"] = "All"; } if ((string)Session["loc"] == null) { Session["loc"] = "All"; } string _name = lblsch.Text; if (lblprj.Text == "SRH" && (lblsch.Text == "25" || lblsch.Text == "26")) { _name = lblsch.Text + "_" + lblprj.Text; } cryRpt.SetParameterValue("name", _name); cryRpt.SetParameterValue("project", get_project()); cryRpt.SetParameterValue("data_title", Get_Title()); cryRpt.SetParameterValue("graph", _graph); cryRpt.SetParameterValue("bz", (string)Session["zone"]); cryRpt.SetParameterValue("cat", (string)Session["cat"]); cryRpt.SetParameterValue("fl", (string)Session["flvl"]); cryRpt.SetParameterValue("ff", (string)Session["fed"]); cryRpt.SetParameterValue("lo", (string)Session["loc"]); CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.DataBind(); Session["Report"] = cryRpt; }
private bool PrintReport(string sql) { if (report_var.customer_cr == null) { report_var.customer_cr = new ReportDocument(); } else { report_var.customer_cr.Close(); report_var.customer_cr = null; report_var.customer_cr = new ReportDocument(); } //检测报表文件是否存在 if (File.Exists(rms_var.GetReportPath() + report_var.customer_rpt_filename)) { report_var.customer_cr = report_var.LoadReport(rms_var.GetReportPath() + report_var.customer_rpt_filename, sql, "view_customer"); TableLogOnInfo logOnInfo = new TableLogOnInfo(); int i; // 对报表中的每个表依次循环。 for (i = 0; i <= report_var.customer_cr.Database.Tables.Count - 1; i++) { // 设置当前表的连接信息。 logOnInfo.ConnectionInfo.ServerName = rms_var.ReadStrfromReg("SQLServerName", ""); logOnInfo.ConnectionInfo.DatabaseName = rms_var.ReadStrfromReg("DataBaseName", ""); logOnInfo.ConnectionInfo.UserID = rms_var.ReadStrfromReg("SQL_User", ""); logOnInfo.ConnectionInfo.Password = rms_var.ReadStrfromReg("SQL_PSW", ""); report_var.customer_cr.Database.Tables[i].ApplyLogOnInfo(logOnInfo); } report_var.customer_cr.PrintToPrinter(1, true, 1, 1); return true; } else { MessageBox.Show("报表文件不存在,请检查系统初始化中的设置是否正确。如果问题依然存在,请联系系统供应商。"); return false; } }
static void ExportToMSMail(string _codEmp, int _NroOrdenCompra) { StaCatalina.Forms.Reports _Reporte = new Reports(); ReportDocument objReport = new ReportDocument(); String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "OrdenDeCompra.rpt"; objReport.Load(reportPath); objReport.Refresh(); objReport.ReportOptions.EnableSaveDataWithReport = false; // PARAMETROS DE CONEXION TableLogOnInfo logoninfo = new TableLogOnInfo(); logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"]; logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"]; logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"]; logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; logoninfo.ConnectionInfo.IntegratedSecurity = false; Tables tables = objReport.Database.Tables; foreach (Table table in tables) { table.ApplyLogOnInfo(logoninfo); } //PAOS LOS PARAMTROS EN ORDEN objReport.SetParameterValue(0, _codEmp); objReport.SetParameterValue(1, "OC"); objReport.SetParameterValue(2, _NroOrdenCompra); objReport.SetParameterValue(3, _NroOrdenCompra); objReport.SetParameterValue(4, null); objReport.SetParameterValue(5, null); objReport.SetParameterValue(6, 1); //PdfRtfWordFormatOptions pdfOpts = ExportOptions.CreatePdfRtfWordFormatOptions(); PdfFormatOptions pdfOpts = new PdfFormatOptions(); MicrosoftMailDestinationOptions mailOpts = ExportOptions.CreateMicrosoftMailDestinationOptions(); ExportOptions exportOpts = new ExportOptions(); pdfOpts.UsePageRange = false; exportOpts.ExportFormatOptions = pdfOpts; mailOpts.MailCCList = "*****@*****.**"; mailOpts.MailMessage = "PRUEBA DE CORREO OC HECTOR"; mailOpts.MailSubject = "PRUEBA"; mailOpts.MailToList = "*****@*****.**"; mailOpts.Password = "******"; mailOpts.UserName = "******"; exportOpts.ExportDestinationOptions = mailOpts; exportOpts.ExportDestinationType = ExportDestinationType.MicrosoftMail; exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat; objReport.Export(exportOpts); }