private void Generate_Reports()
{
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
cryRpt.Load(Server.MapPath("ServiceSummary.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);
}
cryRpt.SetParameterValue("prj", lblprj.Text);
cryRpt.SetParameterValue("BZONE", drbzone.SelectedItem.Text);
cryRpt.SetParameterValue("FLVL", drflvl.SelectedItem.Text);
CrystalReportViewer2.ReportSource = cryRpt;
CrystalReportViewer2.DataBind();
Session["Report"] = cryRpt;
}
private void Page_Init(object sender, EventArgs e)
{
_ReadCookies();
if (!Page.IsPostBack)
{
_ReadCookies();
lblprj.Text = Request.QueryString["prj"].ToString();
LoadServiceType();
txtdatefrom.Text = (DateTime.Today.AddMonths(-3)).ToString("dd/MM/yyyy");
txtdateto.Text = (DateTime.Today.AddMonths(2)).ToString("dd/MM/yyyy");
hdnpcdfrom.Value = txtdatefrom.Text;
hdnpcdto.Value = txtdateto.Text;
Generate_Project_Summary_Overall_Pcd();
Generate_Reports();
}
else
{
if (Session["Report"] != null)
{
CrystalReportViewer2.ReportSource = (ReportDocument)Session["Report"];
CrystalReportViewer2.DataBind();
}
}
}
void PrintReport()
{
try
{
string id = "";
id = Request.QueryString["ID"].ToString();
SqlConnection con = new SqlConnection(@"Data Source=AP\sqlexpress;Initial Catalog=SBAIMS;Integrated Security=True");
SqlDataAdapter ad = new SqlDataAdapter("USP_GETINVOICE", con);
ad.SelectCommand.CommandType = CommandType.StoredProcedure;
ad.SelectCommand.Parameters.Add("@T001_INVOICEOD", id);
ad.SelectCommand.Parameters.Add("@C_Id", "");
ad.SelectCommand.Parameters.Add("@T001_DATE", "");
ad.SelectCommand.Parameters.Add("@C_City", "");
DataSet ds = new DataSet();
ad.Fill(ds);
DataTable dt = ds.Tables[0];
if (dt.Columns.Count > 0)
{
ReportDocument RptDoc = new ReportDocument();
RptDoc.Load(Server.MapPath("Invoice.rpt"));
RptDoc.SetDataSource(dt);
CrystalReportViewer2.ReportSource = RptDoc;
CrystalReportViewer2.RefreshReport();
}
}
catch (Exception ex)
{
}
}
private void Page_Init(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["Report"] = null;
}
else
{
if (Session["Report"] != null)
{
CrystalReportViewer2.ReportSource = (ReportDocument)Session["Report"];
CrystalReportViewer2.DataBind();
}
}
}
private void Generate_Reports()
{
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
var todaysDate = DateTime.Today;
if (!string.IsNullOrEmpty(hdnpcdfrom.Value))
{
todaysDate = DateTime.ParseExact(hdnpcdfrom.Value, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
var todaysDate1 = DateTime.Today;
if (!string.IsNullOrEmpty(hdnpcdto.Value))
{
todaysDate1 = DateTime.ParseExact(hdnpcdto.Value, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
cryRpt.Load(Server.MapPath("Executive_Sumary_PCD.rpt"));
//C:\Users\Joseph\Documents\Visual Studio 2008\Projects\TestCML\Techniques\TestTechniques\ProjectSummary_testing.rpt
crConnectionInfo.ServerName = Constants.CMLTConstants.serverName;
crConnectionInfo.DatabaseName = Constants.CMLTConstants.dbName;
crConnectionInfo.UserID = Constants.CMLTConstants.dbUserName;
crConnectionInfo.Password = Constants.CMLTConstants.dbPassword;
cryRpt.SetDatabaseLogon(crConnectionInfo.UserID, crConnectionInfo.Password, crConnectionInfo.ServerName, crConnectionInfo.DatabaseName);
cryRpt.VerifyDatabase();
CrTables = cryRpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
CrystalReportViewer2.ReportSource = null;
cryRpt.SetParameterValue("project", (string)Session["projectname"]);
cryRpt.SetParameterValue("DateFrom", todaysDate);
cryRpt.SetParameterValue("DateTo", todaysDate1);
cryRpt.SetParameterValue("ServiceType", ddlService.SelectedValue);
CrystalReportViewer2.ReportSource = cryRpt;
CrystalReportViewer2.DataBind();
Session["Report"] = cryRpt;
}
private void Page_Init(object sender, EventArgs e)
{
if (!IsPostBack)
{
lblprj.Text = Request.QueryString[0].ToString();
lblbz.Text = Request.QueryString[1].ToString();
Session["Report"] = null;
}
else
{
if (Session["Report"] != null)
{
CrystalReportViewer2.ReportSource = (ReportDocument)Session["Report"];
CrystalReportViewer2.DataBind();
}
}
}
private void GenerateReport(string _type)
{
DataSet _ds = new DataSet();
DataTable _dt = GetRptData(_type);
//_ds.WriteXmlSchema(Server.MapPath("") + "\\bsummary.xml");
if (_type == "6")
{
//DataTable _dmain = new DataTable();
//_dmain.Merge(_dt, true);
//_dt = GetRptData("6_1");
//_dmain.Merge(_dt, true);
//_dt = GetRptData("6_2");
//_dmain.Merge(_dt, true);
//_dt = GetRptData("6_3");
//_dmain.Merge(_dt, true);
//_dt = GetRptData("6_4");
//_dmain.Merge(_dt, true);
//_ds.Tables.Add(_dmain);
_ds.Tables.Add(_dt);
cryRpt.Load(Server.MapPath("BldgSummaryASAO_.rpt"));
cryRpt.Database.Tables[0].SetDataSource(_ds.Tables[0]);
//cryRpt.Subreports[0].Database.Tables[0].SetDataSource(_ds.Tables[0]);
//cryRpt.Subreports[1].Database.Tables[0].SetDataSource(_ds.Tables[1]);
//cryRpt.Subreports[2].Database.Tables[0].SetDataSource(_ds.Tables[2]);
//cryRpt.Subreports[3].Database.Tables[0].SetDataSource(_ds.Tables[3]);
//cryRpt.Subreports[4].Database.Tables[0].SetDataSource(_ds.Tables[4]);
}
else if (_type == "0")
{
_ds.Tables.Add(_dt);
cryRpt.Load(Server.MapPath("BldgSummaryASAO_.rpt"));
cryRpt.Database.Tables[0].SetDataSource(_ds.Tables[0]);
}
//cryRpt.Database.Tables[0].SetDataSource(_ds.Tables[0]);
cryRpt.SetParameterValue(0, "6");
CrystalReportViewer2.ReportSource = cryRpt;
CrystalReportViewer2.DataBind();
Session["Report"] = cryRpt;
////cryRpt.Dispose();
}
