Beispiel #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            C1_BondItemOwner rpt = new C1_BondItemOwner();

            rpt.Site = this.Site;
            return(rpt);
        }
Beispiel #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            try
            {
                string    strRptPath     = Server.MapPath(".");
                DataTable dtbl           = new DataTable();
                DataTable dataforDisplay = new DataTable();
                dataforDisplay = (DataTable)Session["ReportData"];
                ConnectionInfo cInfo     = new ConnectionInfo();
                TableLogOnInfo logOnInfo = new TableLogOnInfo();



                //string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["elogcon"].ToString();
                //cInfo.ServerName = "elogsrv";
                //cInfo.DatabaseName = "eLog";
                //cInfo.UserID = "sa";
                //cInfo.Password = "******";


                string   connstring   = System.Configuration.ConfigurationManager.ConnectionStrings["smsconn"].ToString();
                string[] conn         = connstring.ToString().Split(';');
                string[] serverInfo   = conn[0].ToString().Split('=');
                string[] DbInfo       = conn[1].ToString().Split('=');
                string[] userInfo     = conn[2].ToString().Split('=');
                string[] passwordInfo = conn[3].ToString().Split('=');

                cInfo.ServerName   = serverInfo[1].ToString();
                cInfo.DatabaseName = DbInfo[1].ToString();
                cInfo.UserID       = userInfo[1].ToString();
                cInfo.Password     = passwordInfo[1].ToString();


                int value = Int32.Parse(Request.QueryString["ReportType"].ToString());

                switch (value)
                {
                case 1:

                    CrystalReportsFile.C1_BondItemOwner objC1_BondItemOwner = new CrystalReportsFile.C1_BondItemOwner();

                    foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objC1_BondItemOwner.Database.Tables)
                    {
                        logOnInfo = reportTable.LogOnInfo;
                        logOnInfo.ConnectionInfo = cInfo;
                        reportTable.ApplyLogOnInfo(logOnInfo);
                    }
                    objC1_BondItemOwner.SetDataSource(dataforDisplay);
                    CrystalReportViewer.ReportSource   = objC1_BondItemOwner;
                    CrystalReportViewer.DisplayToolbar = true;
                    break;


                case 2:

                    CrystalReportsFile.C1_BondItemCharter objC1_BondItemCharter = new CrystalReportsFile.C1_BondItemCharter();

                    foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objC1_BondItemCharter.Database.Tables)
                    {
                        logOnInfo = reportTable.LogOnInfo;
                        logOnInfo.ConnectionInfo = cInfo;
                        reportTable.ApplyLogOnInfo(logOnInfo);
                    }
                    objC1_BondItemCharter.SetDataSource(dataforDisplay);
                    CrystalReportViewer.ReportSource   = objC1_BondItemCharter;
                    CrystalReportViewer.DisplayToolbar = true;
                    break;


                case 3:


                    DataSet dsProvisionOwner = (DataSet)Session["ProvisionOwner"];
                    CrystalReportsFile.C1_ProvisionItemOwner objC1_ProvisionItemOwner = new CrystalReportsFile.C1_ProvisionItemOwner();
                    foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objC1_ProvisionItemOwner.Database.Tables)
                    {
                        logOnInfo = reportTable.LogOnInfo;
                        logOnInfo.ConnectionInfo = cInfo;
                        reportTable.ApplyLogOnInfo(logOnInfo);
                    }

                    if (dsProvisionOwner.Tables[1].Rows.Count != 0)
                    {
                        objC1_ProvisionItemOwner.DataDefinition.FormulaFields[0].Text = dsProvisionOwner.Tables[1].Rows[0][0].ToString();
                    }

                    objC1_ProvisionItemOwner.SetDataSource(dsProvisionOwner.Tables[0]);
                    CrystalReportViewer.ReportSource   = objC1_ProvisionItemOwner;
                    CrystalReportViewer.DisplayToolbar = true;
                    break;


                case 4:

                    DataSet dsProvisionCharter = (DataSet)Session["ProvisionCharters"];
                    CrystalReportsFile.C1_ProvisionItemCharter objC1_ProvisionItemCharter = new CrystalReportsFile.C1_ProvisionItemCharter();
                    foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objC1_ProvisionItemCharter.Database.Tables)
                    {
                        logOnInfo = reportTable.LogOnInfo;
                        logOnInfo.ConnectionInfo = cInfo;
                        reportTable.ApplyLogOnInfo(logOnInfo);
                    }

                    if (dsProvisionCharter.Tables[1].Rows.Count != 0)
                    {
                        objC1_ProvisionItemCharter.DataDefinition.FormulaFields[0].Text = dsProvisionCharter.Tables[1].Rows[0][1].ToString();
                    }

                    objC1_ProvisionItemCharter.SetDataSource(dsProvisionCharter.Tables[0]);
                    CrystalReportViewer.ReportSource   = objC1_ProvisionItemCharter;
                    CrystalReportViewer.DisplayToolbar = true;
                    break;

                case 5:

                    DataSet dsC2 = (DataSet)Session["DataSetC2"];

                    CrystalReportsFile.C2_MandaysReports objC2_MandaysReports = new CrystalReportsFile.C2_MandaysReports();
                    foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objC2_MandaysReports.Database.Tables)
                    {
                        logOnInfo = reportTable.LogOnInfo;
                        logOnInfo.ConnectionInfo = cInfo;
                        reportTable.ApplyLogOnInfo(logOnInfo);
                    }

                    // c2Report.Load(@"D:\Projects\elog_client_wcf\Technical\INV\C2_MandaysReports.rpt");

                    ReportDocument c2Report = new ReportDocument();
                    c2Report.Load(strRptPath + "\\C2_MandaysReports.rpt");

                    if (dsC2.Tables.Count > 0)
                    {
                        if (dsC2.Tables[0].Rows.Count > 0)
                        {
                            c2Report.SetDataSource(dsC2.Tables[0]);
                            decimal total_val = 0;

                            foreach (DataRow dr in dsC2.Tables[0].Rows)
                            {
                                total_val = total_val + Convert.ToDecimal(dr.ItemArray[5].ToString());
                            }

                            if (dsC2.Tables[1].Rows.Count > 0)
                            {
                                c2Report.OpenSubreport("ConsumptionReports").SetDataSource(dsC2.Tables[1]);
                                decimal Mans = 0;
                                foreach (DataRow dr in dsC2.Tables[1].Rows)
                                {
                                    Mans = Mans + Convert.ToDecimal(dr.ItemArray[3].ToString());
                                }
                                c2Report.DataDefinition.FormulaFields[1].Text = Mans.ToString();    // ds.Tables[1].Rows[0].ItemArray[3].ToString();


                                if (dsC2.Tables[2].Rows.Count > 0)
                                {
                                    decimal total_con = 0;
                                    if (dsC2.Tables[2].Rows.Count > 0)
                                    {
                                        c2Report.DataDefinition.FormulaFields[3].Text = dsC2.Tables[2].Rows[0].ItemArray[0].ToString();
                                        total_con = Convert.ToDecimal(dsC2.Tables[2].Rows[0].ItemArray[0].ToString());
                                    }
                                    else
                                    {
                                        c2Report.DataDefinition.FormulaFields[3].Text = "0";
                                    }
                                    c2Report.DataDefinition.FormulaFields[2].Text = (total_con / Convert.ToDecimal(c2Report.DataDefinition.FormulaFields[1].Text)).ToString();     //Convert.ToDecimal(ds.Tables[1].Rows[0].ItemArray[3].ToString())).ToString();

                                    ////objC2_MandaysReports.OpenSubreport("ConsumptionReports").SetDataSource(dsC2.Tables[1]);
                                    ////objC2_MandaysReports.SetDataSource(dsC2.Tables[0]);
                                    CrystalReportViewer.ReportSource = c2Report;
                                    //CrystalReportViewer.ReportSource = objC2_MandaysReports;
                                    CrystalReportViewer.DisplayToolbar = true;
                                }
                            }
                        }
                    }
                    break;


                case 6:

                    DataSet dsD11 = (DataSet)Session["DatasetD11"];

                    CrystalReportsFile.D11_Report objD11_Report = new CrystalReportsFile.D11_Report();

                    foreach (CrystalDecisions.CrystalReports.Engine.Table reportTable in objD11_Report.Database.Tables)
                    {
                        logOnInfo = reportTable.LogOnInfo;
                        logOnInfo.ConnectionInfo = cInfo;
                        reportTable.ApplyLogOnInfo(logOnInfo);
                    }
                    //objD11_Report.SetDataSource(dsD11.Tables[0]);

                    ReportDocument D11Report = new ReportDocument();


                    D11Report.Load(strRptPath + "\\D11_reports.rpt");

                    D11Report.OpenSubreport("A3Provision").SetDataSource(dsD11.Tables[1]);
                    D11Report.OpenSubreport("B3Bond").SetDataSource(dsD11.Tables[2]);
                    D11Report.OpenSubreport("LessBond").SetDataSource(dsD11.Tables[4]);
                    D11Report.OpenSubreport("LessProvision").SetDataSource(dsD11.Tables[3]);



                    //objD11_Report.Subreports[0].SetDataSource(dsD11.Tables[1]);
                    //objD11_Report.Subreports[1].SetDataSource(dsD11.Tables[2]);
                    //objD11_Report.Subreports[2].SetDataSource(dsD11.Tables[4]);
                    //objD11_Report.Subreports[3].SetDataSource(dsD11.Tables[3]);

                    if (dsD11.Tables[0].Rows.Count > 0)
                    {
                        D11Report.DataDefinition.FormulaFields[0].Text = dsD11.Tables[0].Rows[0].ItemArray[0].ToString();
                        D11Report.DataDefinition.FormulaFields[2].Text = dsD11.Tables[0].Rows[0].ItemArray[1].ToString();
                        //D11Report.DataDefinition.FormulaFields[4].Text = dsD11.Tables[0].Rows[0].ItemArray[3].ToString();
                        D11Report.DataDefinition.FormulaFields[7].Text = dsD11.Tables[0].Rows[0].ItemArray[2].ToString();
                    }

                    decimal total_amount = 0;
                    foreach (DataRow dr in dsD11.Tables[1].Rows)
                    {
                        total_amount = total_amount + Convert.ToDecimal(dr.ItemArray[4].ToString());
                    }
                    D11Report.DataDefinition.FormulaFields[2].Text = (Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[0].Text) + total_amount).ToString();
                    // D11Report.DataDefinition.FormulaFields[7].Text = (Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[2].Text) - Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[4].Text)).ToString();


                    if (dsD11.Tables[11].Rows.Count > 0)
                    {
                        D11Report.DataDefinition.FormulaFields[7].Text = dsD11.Tables[11].Rows[1].ItemArray[0].ToString();
                        D11Report.DataDefinition.FormulaFields[4].Text = dsD11.Tables[11].Rows[0].ItemArray[0].ToString();
                    }
                    else
                    {
                        D11Report.DataDefinition.FormulaFields[7].Text = "0";
                        D11Report.DataDefinition.FormulaFields[4].Text = "0";
                    }


                    if (dsD11.Tables[7].Rows.Count > 0)
                    {
                        D11Report.DataDefinition.FormulaFields[1].Text = dsD11.Tables[7].Rows[0].ItemArray[3].ToString();
                    }
                    else
                    {
                        D11Report.DataDefinition.FormulaFields[1].Text = "0";
                    }



                    if (dsD11.Tables[8].Rows.Count > 0)
                    {
                        D11Report.DataDefinition.FormulaFields[3].Text = (Convert.ToDecimal(dsD11.Tables[8].Rows[0].ItemArray[1].ToString()) + Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[1].Text)).ToString();
                    }
                    else
                    {
                        D11Report.DataDefinition.FormulaFields[3].Text = D11Report.DataDefinition.FormulaFields[1].Text;
                    }


                    if (dsD11.Tables[9].Rows.Count > 0)
                    {
                        D11Report.DataDefinition.FormulaFields[5].Text = dsD11.Tables[9].Rows[0].ItemArray[1].ToString();
                        D11Report.DataDefinition.FormulaFields[6].Text = (Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[3].Text) - Convert.ToDecimal(dsD11.Tables[9].Rows[0].ItemArray[1].ToString())).ToString();
                    }
                    else
                    {
                        D11Report.DataDefinition.FormulaFields[5].Text = "0";
                        D11Report.DataDefinition.FormulaFields[6].Text = D11Report.DataDefinition.FormulaFields[3].Text;
                    }

                    decimal mandays = 0;
                    foreach (DataRow dr in dsD11.Tables[3].Rows)
                    {
                        if (dr.ItemArray[3].ToString() != "")
                        {
                            mandays = mandays + Convert.ToDecimal(dr.ItemArray[3].ToString());
                        }
                    }
                    D11Report.DataDefinition.FormulaFields[12].Text = (Convert.ToDouble((mandays * 5))).ToString();


                    foreach (DataRow dr in dsD11.Tables[6].Rows)
                    {
                        if (dr[0].ToString() == "Charterer Account")
                        {
                            D11Report.DataDefinition.FormulaFields[9].Text = dr[1].ToString();
                        }
                        else if (dr[0].ToString() == "Owner Account")
                        {
                            D11Report.DataDefinition.FormulaFields[10].Text = dr[1].ToString();
                        }
                    }



                    //if (dsD11.Tables[6].Rows.Count > 0)
                    //{
                    //    D11Report.DataDefinition.FormulaFields[9].Text = dsD11.Tables[6].Rows[0].ItemArray[1].ToString();
                    //    if (dsD11.Tables[6].Rows.Count > 1)
                    //    {
                    //        D11Report.DataDefinition.FormulaFields[10].Text = dsD11.Tables[6].Rows[1].ItemArray[1].ToString();
                    //    }
                    //}(Convert.ToDecimal(rpt.DataDefinition.FormulaFields[4].Text) / mandays).ToString();

                    D11Report.DataDefinition.FormulaFields[8].Text  = (Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[4].Text) / mandays).ToString();
                    D11Report.DataDefinition.FormulaFields[11].Text = mandays.ToString("####0.0");



                    if (dsD11.Tables[6].Rows.Count > 1)
                    {
                        D11Report.DataDefinition.FormulaFields[12].Text = (Convert.ToDouble(mandays * 5) + Convert.ToDouble(D11Report.DataDefinition.FormulaFields[9].Text) + Convert.ToDouble(D11Report.DataDefinition.FormulaFields[10].Text)).ToString();
                    }

                    D11Report.DataDefinition.FormulaFields[13].Text = "0.00";
                    D11Report.DataDefinition.FormulaFields[14].Text = "0.00";



                    if (dsD11.Tables[10].Rows.Count > 0)
                    {
                        foreach (DataRow dr in dsD11.Tables[10].Rows)
                        {
                            if (dr[0].ToString() == "PR")
                            {
                                D11Report.DataDefinition.FormulaFields[13].Text = dr[1].ToString();
                            }
                            else if (dr[0].ToString() == "BS")
                            {
                                D11Report.DataDefinition.FormulaFields[14].Text = dr[1].ToString();
                            }
                        }
                    }

                    D11Report.DataDefinition.FormulaFields[2].Text = (Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[2].Text) + Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[13].Text)).ToString();
                    D11Report.DataDefinition.FormulaFields[3].Text = (Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[3].Text) + Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[14].Text)).ToString();
                    D11Report.DataDefinition.FormulaFields[6].Text = (Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[6].Text) + Convert.ToDecimal(D11Report.DataDefinition.FormulaFields[14].Text)).ToString();

                    D11Report.SetDataSource(dsD11.Tables[5]);
                    CrystalReportViewer.ReportSource   = D11Report;
                    CrystalReportViewer.DisplayToolbar = true;
                    break;
                }
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message.ToString());
            }
        }
    }