Ejemplo n.º 1
0
        private void ShowFormElement(UniTerm.frmRepForm RepForm)
        {
            string      strForm = "";
            XmlDocument xmlDoc  = _repXMLForm;

            XmlNode appSettingsNode =
                xmlDoc.SelectSingleNode("//reports");

            //xmlDoc.SelectSingleNode("//report[@code='" + _repName + "']");
            foreach (XmlNode node in appSettingsNode.ChildNodes)
            {
                if (node.Attributes["code"].Value.ToString() == _repName)
                {
                    strForm = node.Attributes["form"].Value.ToString();
                }
            }

            if (strForm != "")
            {
                appSettingsNode =
                    xmlDoc.SelectSingleNode("//form[@name='" + strForm + "']");
                foreach (XmlNode node in appSettingsNode.ChildNodes)
                {
                    RepForm.ShowElement(node.Attributes["code"].Value.ToString());
                }
            }
        }
Ejemplo n.º 2
0
        private void SetDataReportLast()
        {
            DataSet DS = new DataSet();
            //DBAdapter DBA = new DBAdapter();
            int dMonth;

            dMonth = DateTime.Now.Month;
            // Диалоговое окно
            frmRepForm RepForm = new frmRepForm();

            //ProcParams PP = new ProcParams("month", "N", dMonth.ToString());
            //ReportDocument Report = new ReportDocument();
            //ReportMKTC Report = new ReportMKTC();

            //DBA.ProcParams = PP;
            //DBA.SetDbData(DS, _repDBProcName); //Вызов процедуры отчета

            /*.Select("month = 11")*/
            myReportDocument.SetDataSource(DS.Tables[0]);
            // @TODO добавить загрузку отчета
            //Report.Load("path");


            /*CrystalDecisions.CrystalReports.Engine.TextObject root;
             * root = (CrystalDecisions.CrystalReports.Engine.TextObject)
             * reportMKTC.ReportDefinition.ReportObjects["CurrDate"];
             * root.;
             */

            /*  Параметры отчета  */

            /*ParameterFieldDefinitions crParameterFieldDefinitions;
             * ParameterFieldDefinition crParameterFieldDefinition;
             * ParameterValues crParameterValues = new ParameterValues();
             * ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
             *
             * crParameterDiscreteValue.Value = Convert.ToInt32("2010");
             * crParameterFieldDefinitions = Report.DataDefinition.ParameterFields;
             * crParameterFieldDefinition = crParameterFieldDefinitions["Year"];
             *
             * crParameterValues = crParameterFieldDefinition.CurrentValues;
             *
             * crParameterValues.Clear();
             * crParameterValues.Add(crParameterDiscreteValue);
             * crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
             */

            //ReportViewer.ReportSource = Report;
            //ReportViewer.Refresh();
            ReportViewer.ReportSource = myReportDocument;
            //ReportViewer.Bi DataBind();
        }
Ejemplo n.º 3
0
        private void SetDataReport(string repName)
        {
            //DataSet DS = new DataSet();

            //DBAdapter DBA = new DBAdapter();
            //ProcParams PP = new ProcParams();


            // Диалоговое окно
            frmRepForm RepForm = new frmRepForm();

            try
            {
                ShowFormElement(RepForm);

                if (DialogResult.Yes == RepForm.ShowDialog(this))
                {
                    if (RepForm.DateFrom != "")
                    {
                        sReport.DateFrom = Convert.ToDateTime(RepForm.DateFrom);
                    }

                    if (RepForm.DateTo != "")
                    {
                        sReport.DateTo = Convert.ToDateTime(RepForm.DateTo);
                    }

                    //DBA.ProcParams = PP;
                    //DBA.SetDbData(DS, _repDBProcName); //Вызов процедуры отчета
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(_repName + "\n" + e.Message, "Ошибка обработки формы параметров отчета.", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 4
0
        private void SetDataReportLast()
        {
            DataSet DS = new DataSet();
            //DBAdapter DBA = new DBAdapter();
            int dMonth;
            dMonth = DateTime.Now.Month;
            // Диалоговое окно
            frmRepForm RepForm = new frmRepForm();

            //ProcParams PP = new ProcParams("month", "N", dMonth.ToString());
            //ReportDocument Report = new ReportDocument();
            //ReportMKTC Report = new ReportMKTC();

            //DBA.ProcParams = PP;
            //DBA.SetDbData(DS, _repDBProcName); //Вызов процедуры отчета

            /*.Select("month = 11")*/
            myReportDocument.SetDataSource(DS.Tables[0]);
            // @TODO добавить загрузку отчета
            //Report.Load("path");

            /*CrystalDecisions.CrystalReports.Engine.TextObject root;
            root = (CrystalDecisions.CrystalReports.Engine.TextObject)
            reportMKTC.ReportDefinition.ReportObjects["CurrDate"];
            root.;
            */

            /*  Параметры отчета  */
            /*ParameterFieldDefinitions crParameterFieldDefinitions;
            ParameterFieldDefinition crParameterFieldDefinition;
            ParameterValues crParameterValues = new ParameterValues();
            ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

            crParameterDiscreteValue.Value = Convert.ToInt32("2010");
            crParameterFieldDefinitions = Report.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["Year"];

            crParameterValues = crParameterFieldDefinition.CurrentValues;

            crParameterValues.Clear();
            crParameterValues.Add(crParameterDiscreteValue);
            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
            */

            //ReportViewer.ReportSource = Report;
            //ReportViewer.Refresh();
            ReportViewer.ReportSource = myReportDocument;
            //ReportViewer.Bi DataBind();
        }
Ejemplo n.º 5
0
        private void SetDataReport(string repName)
        {
            //DataSet DS = new DataSet();

            //DBAdapter DBA = new DBAdapter();
            //ProcParams PP = new ProcParams();

            // Диалоговое окно
            frmRepForm RepForm = new frmRepForm();

            try
            {

                ShowFormElement(RepForm);

                if (DialogResult.Yes == RepForm.ShowDialog(this))
                {

                    if (RepForm.DateFrom != "")
                    {
                        sReport.DateFrom = Convert.ToDateTime(RepForm.DateFrom);
                    }

                    if (RepForm.DateTo != "")
                    {
                        sReport.DateTo = Convert.ToDateTime(RepForm.DateTo);
                    }

                    //DBA.ProcParams = PP;
                    //DBA.SetDbData(DS, _repDBProcName); //Вызов процедуры отчета

                }
            }
            catch (Exception e)
            {
                MessageBox.Show(_repName + "\n" + e.Message, "Ошибка обработки формы параметров отчета.", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }