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

            rpt.Site = this.Site;
            return(rpt);
        }
Example #2
0
        private void PrintActVozvr()
        {
            if ((dtPrintResult != null) && (dtPrintResult.Rows.Count > 0))
            {
                rptActVozvr rptReport = new rptActVozvr();

                DataTable dtEq = new DataTable();
                if (dtEquipment != null)
                {
                    if (dtEquipment.Rows.Count > 0)
                    {
                        dtEq = dtEquipment.Copy();
                    }
                    else
                    {
                        dtEq.Columns.Add("equipment", typeof(string));
                        dtEq.Columns.Add("count", typeof(string));
                        DataRow new_dr = dtEq.NewRow();
                        new_dr["equipment"] = "__________";
                        new_dr["count"]     = "___";
                        dtEq.Rows.Add(new_dr);
                        dtEq.AcceptChanges();
                    }
                }
                else
                {
                    dtEq.Columns.Add("equipment", typeof(string));
                    dtEq.Columns.Add("count", typeof(string));
                    DataRow new_dr = dtEq.NewRow();
                    new_dr["equipment"] = "__________";
                    new_dr["count"]     = "___";
                    dtEq.Rows.Add(new_dr);
                    dtEq.AcceptChanges();
                }

                rptReport.SetDataSource((DataTable)dtEq);

                //---

                //переменные исходные

                string object_address = (dtPrintResult.DefaultView[0]["object_address"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["object_address"].ToString());
                string date_act       = (dtPrintResult.DefaultView[0]["date_doc"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["date_doc"].ToString());
                string date_con       = (dtPrintResult.DefaultView[0]["date_con"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["date_con"].ToString());

                string Landlord_post      = (dtPrintResult.DefaultView[0]["Landlord_post"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Landlord_post"].ToString());
                string Landlord_FIO       = (dtPrintResult.DefaultView[0]["Landlord_FIO"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Landlord_FIO"].ToString());
                string Landlord_type_full = (dtPrintResult.DefaultView[0]["Landlord_type_full"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Landlord_type_full"].ToString());
                string Landlord_name      = (dtPrintResult.DefaultView[0]["Landlord_name"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Landlord_name"].ToString());
                string Landlord_type      = (dtPrintResult.DefaultView[0]["Landlord_type"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Landlord_type"].ToString());

                string Tenant_type_full = (dtPrintResult.DefaultView[0]["Tenant_type_full"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Tenant_type_full"].ToString());
                string Tenant_name      = (dtPrintResult.DefaultView[0]["Tenant_name"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Tenant_name"].ToString());
                string Tenant_post      = (dtPrintResult.DefaultView[0]["Tenant_post"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Tenant_post"].ToString());
                string Tenant_FIO       = (dtPrintResult.DefaultView[0]["Tenant_FIO"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Tenant_FIO"].ToString());
                string Tenant_type      = (dtPrintResult.DefaultView[0]["Tenant_type"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Tenant_type"].ToString());

                string section     = (dtPrintResult.DefaultView[0]["section"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["section"].ToString());
                string floors      = (dtPrintResult.DefaultView[0]["floors"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["floors"].ToString());
                string object_area = (dtPrintResult.DefaultView[0]["object_area"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["object_area"].ToString());

                //переменные составные

                // -------------

                string Landlord_basement = ",";

                if (dtPrintResult.DefaultView[0]["Landlord_basement"].ToString().Trim().Length != 0)
                {
                    Landlord_basement = ", действующего на основании "
                                        + (dtPrintResult.DefaultView[0]["Landlord_basement"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Landlord_basement"].ToString());
                }

                if (dtPrintResult.DefaultView[0]["Landlord_number_base"].ToString().Trim().Length != 0)
                {
                    Landlord_basement += (dtPrintResult.DefaultView[0]["Landlord_number_base"].ToString().Trim().Length == 0 ? "" : " № " + dtPrintResult.DefaultView[0]["Landlord_number_base"].ToString());
                }
                if (dtPrintResult.DefaultView[0]["Landlord_date_base"].ToString().Trim().Length != 0)
                {
                    Landlord_basement += " от " + (dtPrintResult.DefaultView[0]["Landlord_date_base"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Landlord_date_base"].ToString());
                }

                if (Landlord_basement != ",")
                {
                    Landlord_basement += ",";
                }

                string Tenant_basement = ",";

                if (dtPrintResult.DefaultView[0]["Tenant_basement"].ToString().Trim().Length != 0)
                {
                    Tenant_basement = ", действующего на основании "
                                      + (dtPrintResult.DefaultView[0]["Tenant_basement"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Tenant_basement"].ToString());
                }

                if (dtPrintResult.DefaultView[0]["Tenant_number_base"].ToString().Trim().Length != 0)
                {
                    Tenant_basement += (dtPrintResult.DefaultView[0]["Tenant_number_base"].ToString().Trim().Length == 0 ? "" : " № " + dtPrintResult.DefaultView[0]["Tenant_number_base"].ToString());
                }
                if (dtPrintResult.DefaultView[0]["Tenant_date_base"].ToString().Trim().Length != 0)
                {
                    Tenant_basement += " от " + (dtPrintResult.DefaultView[0]["Tenant_date_base"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Tenant_date_base"].ToString());
                }

                if (Tenant_basement != ",")
                {
                    Tenant_basement += ",";
                }

                // -------------

                string arendodatel_str = Landlord_type_full + " " + Landlord_name;

                string arendodatel_str_full = "в лице "
                                              + Landlord_post
                                              + " " + Landlord_FIO + Landlord_basement
                                              + " именуемое в дальнейшем «Арендодатель», и ";

                string arendator_str = Tenant_type_full + " " + Tenant_name;

                string arendator_str_full = "в лице "
                                            + Tenant_post + " " + Tenant_FIO + Tenant_basement
                                            + " именуемое в дальнейшем «Арендатор», составили настоящий Акт о нижеследующем:";

                string punkt1 = "1. Во исполнении Договора аренды объекта нежилого фонда, расположенного по адресу: "
                                + object_address + ", № "
                                + number + " от " + date_con
                                + ", заключенного между "
                                + Landlord_type + " " + Landlord_name + " («Арендодатель») и "
                                + Tenant_type + " " + Tenant_name + " («Арендатор»), "
                                + Tenant_type + " " + Tenant_name + " произвело перед подписанием настоящего Акта возврата объекта нежилого фонда, расположенного по адресу: "
                                + object_address + ", сек. №"
                                + section + " (" + floors + ") общей площадью "
                                + object_area + " кв.м., именуемое далее «Объект».";

                string count_lamps = "          - Имущества: светильники в кол-ве        "
                                     + (dtPrintResult.DefaultView[0]["lamps_count"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["lamps_count"].ToString())
                                     + " шт.";

                string count_phone = "          - Телефонные линии в количестве         "
                                     + (dtPrintResult.DefaultView[0]["tel_count"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["tel_count"].ToString())
                                     + " шт.";

                string FIO_arendodatel = (dtPrintResult.DefaultView[0]["Landlord_FIO2"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Landlord_FIO2"].ToString());

                string FIO_arendator = (dtPrintResult.DefaultView[0]["Tenant_FIO2"].ToString().Trim().Length == 0 ? " - " : dtPrintResult.DefaultView[0]["Tenant_FIO2"].ToString());

                rptReport.DataDefinition.FormulaFields["adress"].Text = "\"" + RQuotes(object_address) + "\"";
                //rptReport.DataDefinition.FormulaFields["num"].Text = "\"" + RQuotes(num) + "\"";
                rptReport.DataDefinition.FormulaFields["date_act"].Text             = "\"" + RQuotes(date_act) + "\"";
                rptReport.DataDefinition.FormulaFields["arendodatel_str"].Text      = "\"" + RQuotes(arendodatel_str) + "\"";
                rptReport.DataDefinition.FormulaFields["arendodatel_str_full"].Text = "\"" + RQuotes(arendodatel_str_full) + "\"";
                rptReport.DataDefinition.FormulaFields["arendator_str"].Text        = "\"" + RQuotes(arendator_str) + "\"";
                rptReport.DataDefinition.FormulaFields["arendator_str_full"].Text   = "\"" + RQuotes(arendator_str_full) + "\"";
                rptReport.DataDefinition.FormulaFields["punkt1"].Text          = "\"" + RQuotes(punkt1) + "\"";
                rptReport.DataDefinition.FormulaFields["count_lamps"].Text     = "\"" + RQuotes(count_lamps) + "\"";
                rptReport.DataDefinition.FormulaFields["count_phone"].Text     = "\"" + RQuotes(count_phone) + "\"";
                rptReport.DataDefinition.FormulaFields["FIO_arendator"].Text   = "\"" + RQuotes(FIO_arendator) + "\"";
                rptReport.DataDefinition.FormulaFields["FIO_arendodatel"].Text = "\"" + RQuotes(FIO_arendodatel) + "\"";

                //rptReport.DataDefinition.FormulaFields["date"].Text = "\"" + "Дата: " + DateTime.Parse(dtHead.Rows[0]["date"].ToString()).ToString("dd.MM.yyyy") + "\"";
                //rptReport.DataDefinition.FormulaFields["credit"].Text = "\"" + dtHead.Rows[0]["credit"].ToString() + "\"";
                //rptReport.DataDefinition.FormulaFields["SummaCrPlan"].Text = "\"" + summaCrPlan.ToString("### ### ##0.00") + "\"";
                //rptReport.DataDefinition.FormulaFields["SummaCrFact"].Text = "\"" + summaCrFact.ToString("### ### ##0.00") + "\"";

                crystalReportViewer1.ReportSource = rptReport;
                crystalReportViewer1.Refresh();
            }
        }