コード例 #1
0
 private void SetNullWhenZero(DataDynamics.ActiveReports.TextBox textBox)
 {
     if (textBox.Text == "0")
     {
         textBox.Text = "";
     }
 }
コード例 #2
0
        private void SetGroupHeader(DataDynamics.ActiveReports.TextBox txtId,
                                    DataDynamics.ActiveReports.TextBox txtName,
                                    DataDynamics.ActiveReports.TextBox txtYosan,
                                    DataDynamics.ActiveReports.TextBox txtJisseki,
                                    DataDynamics.ActiveReports.TextBox txtSagaku,
                                    DataDynamics.ActiveReports.TextBox txtHiritsu,
                                    string namePrefix,
                                    string nameSuffix)
        {
            int  kamokuKubunId = helper.Converter.ObjToInt(txtId.Text, -1);
            long yosan         = helper.Converter.AmountToLongObj(txtYosan.Text).Value;
            long jisseki       = helper.Converter.AmountToLongObj(txtJisseki.Text).Value;

            if (yosan == 0)
            {
                txtHiritsu.Text = "0.0";
            }
            else
            {
                txtHiritsu.Text = string.Format("{0:0.0}", ((double)jisseki) / ((double)yosan) * 100);
            }

            models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetRowById(kamokuKubunId);
            txtName.Text = namePrefix + kamokuKubunRow.GetStr("name") + nameSuffix;
        }
コード例 #3
0
        void rptQuickReport_FetchData(object sender, ActiveReport3.FetchEventArgs eArgs)
        {
            foreach (ARControl arCtrl in this.detail.Controls)
            {
                if (arCtrl.GetType().Name == "TextBox")
                {
                    DataDynamics.ActiveReports.TextBox txt = (DataDynamics.ActiveReports.TextBox)arCtrl;
                    string strDataField = txt.DataField;

                    //Bold
                    if (this.Fields.Contains("Bold"))
                    {
                        if ((bool)this.Fields["Bold"].Value == true)
                        {
                            txt.Font = new Font(txt.Font.FontFamily, txt.Font.Size, FontStyle.Bold);
                        }
                        else
                        {
                            txt.Font = new Font(txt.Font.FontFamily, txt.Font.Size, FontStyle.Regular);
                        }
                    }

                    if (this.Fields.Contains(strDataField) && txt.OutputFormat != null && txt.OutputFormat.Contains("#"))
                    {
                        if (Convert.ToDouble(this.Fields[strDataField].Value) == 0)
                        {
                            txt.Visible = false;
                        }
                        else
                        {
                            txt.Visible = true;
                        }
                    }

                    //DateMin
                    if (this.DataSource.GetType().Name == "DataTable")
                    {
                        DataTable dt = (DataTable)this.DataSource;

                        if (dt.Columns.Contains(strDataField) && dt.Columns[strDataField].DataType.Name == "DateTime")
                        {
                            if (this.Fields[strDataField].Value.ToString() == string.Empty || ((DateTime)this.Fields[strDataField].Value).ToString("dd/MM/yyyy") == "01/01/1900")
                            {
                                txt.Visible = false;
                            }
                            else
                            {
                                txt.Visible = true;
                            }
                        }
                    }
                }
            }
        }
コード例 #4
0
        public void InitComponents(ControlCollection pageHeaderControls,
                                   ControlCollection detailControls,
                                   ControlCollection kubunFooterControls,
                                   ControlCollection reportFooterControls,
                                   DataDynamics.ActiveReports.TextBox txtKisanbi_,
                                   DataDynamics.ActiveReports.TextBox txtKimatsubi_,
                                   DataDynamics.ActiveReports.TextBox txtHoujinMei_,
                                   DataDynamics.ActiveReports.TextBox txtKubunName_,
                                   DataDynamics.ActiveReports.TextBox txtDaikubunName_,
                                   DataDynamics.ActiveReports.TextBox txtKamokuCode_,
                                   DataDynamics.ActiveReports.TextBox txtKamoku_,
                                   DataDynamics.ActiveReports.TextBox txtKamokuId_,
                                   DataDynamics.ActiveReports.TextBox txtDaikubunId_,
                                   DataDynamics.ActiveReports.TextBox txtKubunId_,
                                   DataDynamics.ActiveReports.Label txtShisyutsuKeiCaption_,
                                   DataDynamics.ActiveReports.Label txtSyuunyuuKeiCaption_,
                                   DataDynamics.ActiveReports.Label labelTitle_,
                                   DataDynamics.ActiveReports.Label labelYoushiki_)
        {
            // コンポーネント配列の作成
            txtColCaptions   = helper.View.CreateTextboxArray(pageHeaderControls, "txtColCaption", NumCols);
            txtDetailCols    = helper.View.CreateTextboxArray(detailControls, "txtCol", NumCols);
            txtSyuunyuuCols  = helper.View.CreateTextboxArray(kubunFooterControls, "txtSyuunyuuKeiCol", NumCols);
            txtShisyutsuCols = helper.View.CreateTextboxArray(kubunFooterControls, "txtShisyutsuKeiCol", NumCols);
            //txtYobihiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtYobihiCol", NumCols);
            txtToukiCols        = helper.View.CreateTextboxArray(reportFooterControls, "txtToukiCol", NumCols);
            txtZenkiCols        = helper.View.CreateTextboxArray(reportFooterControls, "txtZenkiCol", NumCols);
            txtToukiZandakaCols = helper.View.CreateTextboxArray(reportFooterControls, "txtToukiZandakaCol", NumCols);

            txtKisanbi             = txtKisanbi_;
            txtKimatsubi           = txtKimatsubi_;
            txtHoujinMei           = txtHoujinMei_;
            txtKubunName           = txtKubunName_;
            txtDaikubunName        = txtDaikubunName_;
            txtKamokuCode          = txtKamokuCode_;
            txtKamoku              = txtKamoku_;
            txtKamokuId            = txtKamokuId_;
            txtDaikubunId          = txtDaikubunId_;
            txtKubunId             = txtKubunId_;
            txtShisyutsuKeiCaption = txtShisyutsuKeiCaption_;
            txtSyuunyuuKeiCaption  = txtSyuunyuuKeiCaption_;
            labelTitle             = labelTitle_;
            labelYoushiki          = labelYoushiki_;

            beforeSyuunyuuCols = new long[NumCols];
        }
コード例 #5
0
        public void InitComponents(ControlCollection pageHeaderControls,
                                   ControlCollection detailControls,
                                   ControlCollection kubunFooterControls,
                                   ControlCollection reportFooterControls,
                                   DataDynamics.ActiveReports.TextBox txtKisanbi_,
                                   DataDynamics.ActiveReports.TextBox txtKimatsubi_,
                                   DataDynamics.ActiveReports.TextBox txtHoujinMei_,
                                   DataDynamics.ActiveReports.TextBox txtKubunName_,
                                   DataDynamics.ActiveReports.TextBox txtDaikubunName_,
                                   DataDynamics.ActiveReports.TextBox txtKamokuCode_,
                                   DataDynamics.ActiveReports.TextBox txtKamoku_,
                                   DataDynamics.ActiveReports.TextBox txtKamokuId_,
                                   DataDynamics.ActiveReports.TextBox txtDaikubunId_,
                                   DataDynamics.ActiveReports.TextBox txtKubunId_,
                                   DataDynamics.ActiveReports.Label txtSyuunyuuKeiCaption_,
                                   DataDynamics.ActiveReports.Label labelTitle_,
                                   DataDynamics.ActiveReports.Label labelYoushiki_)
        {
            // コンポーネント配列の作成
            txtColCaptions     = helper.View.CreateTextboxArray(pageHeaderControls, "txtColCaption", NumCols);
            txtToukiCols       = helper.View.CreateTextboxArray(reportFooterControls, "txtTouki", NumCols);
            txtZenkiCols       = helper.View.CreateTextboxArray(reportFooterControls, "txtZenki", NumCols);
            txtToukimatsuCols  = helper.View.CreateTextboxArray(reportFooterControls, "txtToukimatsu", NumCols);
            txtKihonkinCols    = helper.View.CreateTextboxArray(reportFooterControls, "txtKihonkin", NumCols);
            txtTorikuzushiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtTorikuzushi", NumCols);
            txtTsumitateCols   = helper.View.CreateTextboxArray(reportFooterControls, "txtTsumitate", NumCols);
            txtJikiCols        = helper.View.CreateTextboxArray(reportFooterControls, "txtJiki", NumCols);

            txtKisanbi            = txtKisanbi_;
            txtKimatsubi          = txtKimatsubi_;
            txtHoujinMei          = txtHoujinMei_;
            txtKubunName          = txtKubunName_;
            txtDaikubunName       = txtDaikubunName_;
            txtKamokuCode         = txtKamokuCode_;
            txtKamoku             = txtKamoku_;
            txtKamokuId           = txtKamokuId_;
            txtDaikubunId         = txtDaikubunId_;
            txtKubunId            = txtKubunId_;
            txtSyuunyuuKeiCaption = txtSyuunyuuKeiCaption_;
            labelTitle            = labelTitle_;
            labelYoushiki         = labelYoushiki_;
        }
コード例 #6
0
ファイル: rptTopReport.cs プロジェクト: klimkina/CSharp
        private void rptTopReport_ReportStart(object sender, EventArgs e)
        {
            this._iRow = 0;
            if (_InputParameters["DetailsType"] != null && _InputParameters["DetailsType"].ParamValue == _TypeName)//hide subreport if ReportType is the same as ParamType
            {
                this.Cancel();
            }
            else
            {
                //Dataset to hold data
                DataTable _ChartData = new DataTable();

                string criteria = bool.Parse(_InputParameters["IsShowLbs"].ParamValue) ? "(Weight - NItems*ContainerWeight)" : "WasteCost";
                string where = " WHERE SiteID = " + _InputParameters["SiteID"].ParamValue;
                if (_InputParameters["Filter"].ParamValue != "")
                {
                    where += " AND " + _InputParameters["Filter"].ParamValue;
                }
                bool isWasteClassesUsed = false;                 // (VWA4Common.SecurityManager.GetSecurityManager().GetPermission("Allowed Waste Classes") != "-1") || (_InputParameters["WasteClasses"].ParamValue.ToString() != "");
                //if (_InputParameters["WasteClasses"].ParamValue.ToString() != "")
                //    where += (where == "" ? "" : " AND (") + _InputParameters["WasteClasses"].ParamValue.ToString() + (where == "" ? "" : " )");
                //else // if (VWA4Common.SecurityManager.GetSecurityManager().GetPermission("Allowed Waste Classes") != "-1")
                //    where = (where == "" ? VWA4Common.VWACommon.GetWasteClasses() : "(" + where + ") AND (" + VWA4Common.VWACommon.GetWasteClasses() + ")");

                string subselect = "SELECT TOP " + _TopCount + " " + _TypeName + "Type.TypeName AS Name, " + _TypeName +
                                   "TypeID as TypeID, Count(*) AS TransNum, Sum(WasteCost) AS Waste, Sum(Weight - NItems*ContainerWeight) AS Weights " +
                                   " FROM (((Weights LEFT JOIN Transfers ON Transfers.TransKey = Weights.TransKey) " +
                                   " LEFT JOIN LossType ON Weights.LossTypeID = LossType.TypeID)" +
                                   ((_TypeName == "Loss") ? "" : (" INNER JOIN " + _TypeName + "Type ON Weights." + _TypeName +
                                                                  "TypeID = " + _TypeName + "Type.TypeID")) + ")" +
                                   (isWasteClassesUsed ? " LEFT JOIN FoodType ON Weights.FoodTypeID = FoodType.TypeID " : "") +
                                   where +
                                   " GROUP BY Weights." + _TypeName + "TypeID, " + _TypeName + "Type.TypeName " +
                                   " ORDER BY Sum(" + criteria + ") DESC";
                string select =
                    @"SELECT * FROM (" + subselect + ") ORDER BY Waste " + (bool.Parse(_InputParameters["IsHorizontal"].ParamValue) ? " ASC;" : " DESC;");
                _ChartData = VWA4Common.DB.Retrieve(select);
                criteria   = bool.Parse(_InputParameters["IsShowLbs"].ParamValue) ? "Weights" : "Waste";
                if (_ChartData.Rows.Count > 0)
                {
                    double max = double.Parse(_ChartData.Compute("Max(Waste)", "").ToString());
                    int    step = 1; double temp = max;
                    for (step = 1; temp > 1; step *= 10)
                    {
                        temp = temp / 10;
                    }
                    step = step / 100 * (int)(1 + max * 10 / step);
                    this.chartControl1.ChartAreas[0].Axes["AxisY"].MajorTick.Step = step;

                    this.chartControl1.Series[0].Marker.Label.Font = new DataDynamics.ActiveReports.Chart.FontInfo(System.Drawing.Color.Black, new System.Drawing.Font("Arial", (_ChartData.Rows.Count > 20) ? 6F : 8F));


                    this.DataSource = VWA4Common.DB.Retrieve(subselect);
                    this.DataMember = _ChartData.TableName;
                    this.chartControl1.DataSource = _ChartData;
                    this.chartControl1.Series[0].ValueMembersY = criteria;
                    this.chartControl1.ColorPalette            = VWA4Common.VWACommon.GetPalette(_InputParameters["ChartColor"].ParamValue);
                    this.chartControl1.Titles["footer"].Text   = "TOP " + _TopCount + " " + _TypeName + (_TypeName == "Loss" ? "es" : "s");
                    SetWeight();
                    Set3D();
                    SetHorizontal();
                    if (_TypeName == "User")
                    {
                        DataDynamics.ActiveReports.TextBox txtTransNum = new DataDynamics.ActiveReports.TextBox();
                        detail.Controls.Add(txtTransNum);
                        txtWaste.Width        = 0.64F;
                        txtWeight.Width       = txtWaste.Width;
                        txtTransNum.Width     = 0.44F;
                        txtTransNum.Height    = txtWaste.Height;
                        txtTransNum.Top       = txtWaste.Top;
                        txtTransNum.Left      = txtWeight.Left;
                        txtWeight.Left        = txtWeight.Left + 0.44F;
                        txtWaste.Left         = txtWeight.Left + 0.64F;
                        txtTransNum.DataField = "TransNum";
                        lblName.Visible       = true;
                        lblTrans.Visible      = true;
                        lblWeight.Visible     = true;
                        lblCost.Visible       = true;
                    }
                    VWA4Common.GlobalSettings.SubReportWasPrinted = true;
                }
                else                 // don't show report if no data
                {
                    this.Cancel();
                }
                //oleDBDataSource1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + VWA4Common.AppContext.DBPathName
                //   + ";Persist Security Info=False";
                this.Document.Printer.Landscape = true;
                //this.PrintWidth = this.PageSettings.PaperHeight - (this.PageSettings.Margins.Top + this.PageSettings.Margins.Bottom);
            }
        }
コード例 #7
0
        private void CreateTextBoxes(int num)
        {
            txtDates   = new DataDynamics.ActiveReports.TextBox[num];
            hdrDates   = new DataDynamics.ActiveReports.TextBox[num];
            lineHeader = new DataDynamics.ActiveReports.Line[num];
            lineText   = new DataDynamics.ActiveReports.Line[num];

            float size = Math.Min(5F / num, 0.8F);                        //results + total
            float left = 0.875F, height = 0.1875F, line_height = 0.1875F; // 0.25F;

            for (int i = 0; i < num; i++)
            {
                txtDates[i] = new DataDynamics.ActiveReports.TextBox();
                txtDates[i].Border.BottomColor = System.Drawing.Color.Black;
                txtDates[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtDates[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtDates[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtDates[i].Border.RightColor  = System.Drawing.Color.Black;
                txtDates[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtDates[i].Border.TopColor    = System.Drawing.Color.Black;
                txtDates[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtDates[i].Height             = height;
                txtDates[i].Left      = left + i * size;
                txtDates[i].Name      = "txtDates" + i;
                txtDates[i].Style     = "font-size: 8pt; ";
                txtDates[i].Text      = null;
                txtDates[i].Top       = 0F;
                txtDates[i].Width     = size;
                txtDates[i].DataField = "result" + i;
                txtDates[i].Alignment = TextAlignment.Center;
                this.detail.Controls.Add(txtDates[i]);

                hdrDates[i] = new DataDynamics.ActiveReports.TextBox();
                hdrDates[i].Border.BottomColor = System.Drawing.Color.Black;
                hdrDates[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                hdrDates[i].Border.LeftColor   = System.Drawing.Color.Black;
                hdrDates[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                hdrDates[i].Border.RightColor  = System.Drawing.Color.Black;
                hdrDates[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                hdrDates[i].Border.TopColor    = System.Drawing.Color.Black;
                hdrDates[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                hdrDates[i].Height             = height;
                hdrDates[i].Left         = left + i * size;
                hdrDates[i].Name         = "hdrDates" + i;
                hdrDates[i].Style        = "font-weight: bold; ";
                hdrDates[i].Text         = null;
                hdrDates[i].Top          = 0F;
                hdrDates[i].Width        = size;
                hdrDates[i].OutputFormat = "d-MMM";
                hdrDates[i].Alignment    = TextAlignment.Center;
                this.gpHeader.Controls.Add(hdrDates[i]);

                //
                // lineHeader
                //
                lineHeader[i] = new Line();
                this.lineHeader[i].AnchorBottom       = true;
                this.lineHeader[i].Border.BottomColor = System.Drawing.Color.Black;
                this.lineHeader[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                this.lineHeader[i].Border.LeftColor   = System.Drawing.Color.Black;
                this.lineHeader[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                this.lineHeader[i].Border.RightColor  = System.Drawing.Color.Black;
                this.lineHeader[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                this.lineHeader[i].Border.TopColor    = System.Drawing.Color.Black;
                this.lineHeader[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                this.lineHeader[i].Height             = line_height;
                this.lineHeader[i].Left       = left + size * (i + 1);
                this.lineHeader[i].LineWeight = 1F;
                this.lineHeader[i].Name       = "lineHeader" + i;
                this.lineHeader[i].Top        = 0F;
                this.lineHeader[i].Width      = 0F;
                this.lineHeader[i].X1         = left + size * (i + 1);
                this.lineHeader[i].X2         = left + size * (i + 1);
                this.lineHeader[i].Y1         = 0F;
                this.lineHeader[i].Y2         = line_height;
                this.gpHeader.Controls.Add(lineHeader[i]);
                //
                // lineText
                //
                lineText[i] = new Line();
                this.lineText[i].AnchorBottom       = true;
                this.lineText[i].Border.BottomColor = System.Drawing.Color.Black;
                this.lineText[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                this.lineText[i].Border.LeftColor   = System.Drawing.Color.Black;
                this.lineText[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                this.lineText[i].Border.RightColor  = System.Drawing.Color.Black;
                this.lineText[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                this.lineText[i].Border.TopColor    = System.Drawing.Color.Black;
                this.lineText[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                this.lineText[i].Height             = line_height;
                this.lineText[i].Left       = left + size * (i + 1);
                this.lineText[i].LineWeight = 1F;
                this.lineText[i].Name       = "lineText" + i;
                this.lineText[i].Top        = 0F;
                this.lineText[i].Width      = 0F;
                this.lineText[i].X1         = left + size * (i + 1);
                this.lineText[i].X2         = left + size * (i + 1);
                this.lineText[i].Y1         = 0F;
                this.lineText[i].Y2         = line_height;
                this.detail.Controls.Add(lineText[i]);
            }
            hdrTotal.Left   = left + num * size;
            txtTotal.Left   = hdrTotal.Left;
            line14.X2       = hdrTotal.Left + hdrTotal.Width;
            line15.X2       = line14.X2;
            line1.X2        = line14.X2;
            line22.X1       = line14.X2;
            line27.X1       = line14.X2;
            line22.X2       = line14.X2;
            line27.X2       = line14.X2;
            lnBottom.Width  = line14.Width;
            lnBottom2.Width = line14.Width;
            //line22.BringToFront();
            //line27.BringToFront();
        }
コード例 #8
0
        private void InitCells(int numMonths)
        {
            int i;

            txtSalesBudget          = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtFoodCostBudget       = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtMealCountBudget      = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtFoodCostPointsBudget = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtSales                 = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtFoodCost              = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtMealCount             = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtFoodCostPoints        = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtFoodWasteAmount       = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtFoodWastePercentage   = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtSalesChanges          = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtFoodCostChanges       = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtMealCountChanges      = new DataDynamics.ActiveReports.TextBox[numMonths];
            txtFoodCostPointsChanges = new DataDynamics.ActiveReports.TextBox[numMonths];

            for (i = 0; i < numMonths; i++)
            {
                txtSalesBudget[i]          = new DataDynamics.ActiveReports.TextBox();
                txtFoodCostBudget[i]       = new DataDynamics.ActiveReports.TextBox();
                txtMealCountBudget[i]      = new DataDynamics.ActiveReports.TextBox();
                txtFoodCostPointsBudget[i] = new DataDynamics.ActiveReports.TextBox();
                txtSales[i]                 = new DataDynamics.ActiveReports.TextBox();
                txtFoodCost[i]              = new DataDynamics.ActiveReports.TextBox();
                txtMealCount[i]             = new DataDynamics.ActiveReports.TextBox();
                txtFoodCostPoints[i]        = new DataDynamics.ActiveReports.TextBox();
                txtFoodWasteAmount[i]       = new DataDynamics.ActiveReports.TextBox();
                txtFoodWastePercentage[i]   = new DataDynamics.ActiveReports.TextBox();
                txtSalesChanges[i]          = new DataDynamics.ActiveReports.TextBox();
                txtFoodCostChanges[i]       = new DataDynamics.ActiveReports.TextBox();
                txtMealCountChanges[i]      = new DataDynamics.ActiveReports.TextBox();
                txtFoodCostPointsChanges[i] = new DataDynamics.ActiveReports.TextBox();
            }

            //
            // txtSales
            //
            for (i = 0; i < numMonths; i++)
            {
                txtSalesBudget[i].Border.BottomColor = System.Drawing.Color.Black;
                txtSalesBudget[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSalesBudget[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtSalesBudget[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSalesBudget[i].Border.RightColor  = System.Drawing.Color.Black;
                txtSalesBudget[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSalesBudget[i].Border.TopColor    = System.Drawing.Color.Black;
                txtSalesBudget[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSalesBudget[i].Height             = 0.1875F;
                txtSalesBudget[i].Left         = 1F + i * 0.625F;
                txtSalesBudget[i].Name         = "txtSalesBudget" + i;
                txtSalesBudget[i].Style        = "font-size: 8pt; ";
                txtSalesBudget[i].Text         = null;
                txtSalesBudget[i].Top          = 0.19F;
                txtSalesBudget[i].Width        = 0.625F;
                txtSalesBudget[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtSalesBudget[i]);

                txtSales[i].Border.BottomColor = System.Drawing.Color.Black;
                txtSales[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSales[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtSales[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSales[i].Border.RightColor  = System.Drawing.Color.Black;
                txtSales[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSales[i].Border.TopColor    = System.Drawing.Color.Black;
                txtSales[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSales[i].Height             = 0.1875F;
                txtSales[i].Left         = 1F + i * 0.625F;
                txtSales[i].Name         = "txtSales" + i;
                txtSales[i].Style        = "font-size: 8pt; ";
                txtSales[i].Text         = null;
                txtSales[i].Top          = 1.13F;
                txtSales[i].Width        = 0.625F;
                txtSales[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtSales[i]);

                txtSalesChanges[i].Border.BottomColor = System.Drawing.Color.Black;
                txtSalesChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSalesChanges[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtSalesChanges[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSalesChanges[i].Border.RightColor  = System.Drawing.Color.Black;
                txtSalesChanges[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSalesChanges[i].Border.TopColor    = System.Drawing.Color.Black;
                txtSalesChanges[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtSalesChanges[i].Height             = 0.1875F;
                txtSalesChanges[i].Left         = 1F + i * 0.625F;
                txtSalesChanges[i].Name         = "txtSalesChanges" + i;
                txtSalesChanges[i].Style        = "font-size: 8pt; ";
                txtSalesChanges[i].Text         = null;
                txtSalesChanges[i].Top          = 2.44F;
                txtSalesChanges[i].Width        = 0.625F;
                txtSalesChanges[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtSalesChanges[i]);
            }

            //
            // txtFoodCost
            //
            for (i = 0; i < numMonths; i++)
            {
                txtFoodCostBudget[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCostBudget[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostBudget[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCostBudget[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostBudget[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCostBudget[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostBudget[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCostBudget[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostBudget[i].Height             = 0.1875F;
                txtFoodCostBudget[i].Left         = 1F + i * 0.625F;
                txtFoodCostBudget[i].Name         = "txtFoodCostBudget" + i;
                txtFoodCostBudget[i].Style        = "font-size: 8pt; ";
                txtFoodCostBudget[i].Text         = null;
                txtFoodCostBudget[i].Top          = 0.38F;
                txtFoodCostBudget[i].Width        = 0.625F;
                txtFoodCostBudget[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtFoodCostBudget[i]);

                txtFoodCost[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCost[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCost[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCost[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCost[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCost[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCost[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCost[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCost[i].Height             = 0.1875F;
                txtFoodCost[i].Left         = 1F + i * 0.625F;
                txtFoodCost[i].Name         = "txtFoodCost" + i;
                txtFoodCost[i].Style        = "font-size: 8pt; ";
                txtFoodCost[i].Text         = null;
                txtFoodCost[i].Top          = 1.31F;
                txtFoodCost[i].Width        = 0.625F;
                txtFoodCost[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtFoodCost[i]);

                txtFoodCostChanges[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCostChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostChanges[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCostChanges[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostChanges[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCostChanges[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostChanges[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCostChanges[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostChanges[i].Height             = 0.1875F;
                txtFoodCostChanges[i].Left         = 1F + i * 0.625F;
                txtFoodCostChanges[i].Name         = "txtFoodCostChanges" + i;
                txtFoodCostChanges[i].Style        = "font-size: 8pt; ";
                txtFoodCostChanges[i].Text         = null;
                txtFoodCostChanges[i].Top          = 2.63F;
                txtFoodCostChanges[i].Width        = 0.625F;
                txtFoodCostChanges[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtFoodCostChanges[i]);
            }

            //
            // txtMealCount
            //
            for (i = 0; i < numMonths; i++)
            {
                txtMealCountBudget[i].Border.BottomColor = System.Drawing.Color.Black;
                txtMealCountBudget[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCountBudget[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtMealCountBudget[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCountBudget[i].Border.RightColor  = System.Drawing.Color.Black;
                txtMealCountBudget[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCountBudget[i].Border.TopColor    = System.Drawing.Color.Black;
                txtMealCountBudget[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCountBudget[i].Height             = 0.1875F;
                txtMealCountBudget[i].Left         = 1F + i * 0.625F;
                txtMealCountBudget[i].Name         = "txtMealCountBudget" + i;
                txtMealCountBudget[i].Style        = "font-size: 8pt; ";
                txtMealCountBudget[i].Text         = null;
                txtMealCountBudget[i].Top          = 0.56F;
                txtMealCountBudget[i].Width        = 0.625F;
                txtMealCountBudget[i].OutputFormat = "#,##0.";
                this.detail.Controls.Add(txtMealCountBudget[i]);

                txtMealCount[i].Border.BottomColor = System.Drawing.Color.Black;
                txtMealCount[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCount[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtMealCount[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCount[i].Border.RightColor  = System.Drawing.Color.Black;
                txtMealCount[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCount[i].Border.TopColor    = System.Drawing.Color.Black;
                txtMealCount[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCount[i].Height             = 0.1875F;
                txtMealCount[i].Left         = 1F + i * 0.625F;
                txtMealCount[i].Name         = "txtMealCount" + i;
                txtMealCount[i].Style        = "font-size: 8pt; ";
                txtMealCount[i].Text         = null;
                txtMealCount[i].Top          = 1.5F;
                txtMealCount[i].Width        = 0.625F;
                txtMealCount[i].OutputFormat = "#,##0.";
                this.detail.Controls.Add(txtMealCount[i]);

                txtMealCountChanges[i].Border.BottomColor = System.Drawing.Color.Black;
                txtMealCountChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCountChanges[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtMealCountChanges[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCountChanges[i].Border.RightColor  = System.Drawing.Color.Black;
                txtMealCountChanges[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCountChanges[i].Border.TopColor    = System.Drawing.Color.Black;
                txtMealCountChanges[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtMealCountChanges[i].Height             = 0.1875F;
                txtMealCountChanges[i].Left         = 1F + i * 0.625F;
                txtMealCountChanges[i].Name         = "txtMealCountChanges" + i;
                txtMealCountChanges[i].Style        = "font-size: 8pt; ";
                txtMealCountChanges[i].Text         = null;
                txtMealCountChanges[i].Top          = 2.81F;
                txtMealCountChanges[i].Width        = 0.625F;
                txtMealCountChanges[i].OutputFormat = "#,##0.";
                this.detail.Controls.Add(txtMealCountChanges[i]);
            }

            //
            // txtFoodCostPoints
            //
            for (i = 0; i < numMonths; i++)
            {
                txtFoodCostPointsBudget[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCostPointsBudget[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsBudget[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCostPointsBudget[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsBudget[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCostPointsBudget[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsBudget[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCostPointsBudget[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsBudget[i].Height             = 0.1875F;
                txtFoodCostPointsBudget[i].Left         = 1F + i * 0.625F;
                txtFoodCostPointsBudget[i].Name         = "txtFoodCostPointsBudget" + i;
                txtFoodCostPointsBudget[i].Style        = "font-size: 8pt; ";
                txtFoodCostPointsBudget[i].Text         = null;
                txtFoodCostPointsBudget[i].Top          = 0.75F;
                txtFoodCostPointsBudget[i].Width        = 0.625F;
                txtFoodCostPointsBudget[i].OutputFormat = _InputParameters["FinancialMode"].ParamValue == "Points" ? "#,##0.##%" : "$#,##0.##";
                this.detail.Controls.Add(txtFoodCostPointsBudget[i]);

                txtFoodCostPoints[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCostPoints[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPoints[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCostPoints[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPoints[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCostPoints[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPoints[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCostPoints[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPoints[i].Height             = 0.1875F;
                txtFoodCostPoints[i].Left         = 1F + i * 0.625F;
                txtFoodCostPoints[i].Name         = "txtFoodCostPoints" + i;
                txtFoodCostPoints[i].Style        = "font-size: 8pt; ";
                txtFoodCostPoints[i].Text         = null;
                txtFoodCostPoints[i].Top          = 1.69F;
                txtFoodCostPoints[i].Width        = 0.625F;
                txtFoodCostPoints[i].OutputFormat = txtFoodCostPointsBudget[i].OutputFormat;
                this.detail.Controls.Add(txtFoodCostPoints[i]);

                txtFoodCostPointsChanges[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCostPointsChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsChanges[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCostPointsChanges[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsChanges[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCostPointsChanges[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsChanges[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCostPointsChanges[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsChanges[i].Height             = 0.1875F;
                txtFoodCostPointsChanges[i].Left         = 1F + i * 0.625F;
                txtFoodCostPointsChanges[i].Name         = "txtFoodCostPointsChanges" + i;
                txtFoodCostPointsChanges[i].Style        = "font-size: 8pt; ";
                txtFoodCostPointsChanges[i].Text         = null;
                txtFoodCostPointsChanges[i].Top          = 3F;
                txtFoodCostPointsChanges[i].Width        = 0.625F;
                txtFoodCostPointsChanges[i].OutputFormat = txtFoodCostPointsBudget[i].OutputFormat;
                this.detail.Controls.Add(txtFoodCostPointsChanges[i]);
            }

            //
            // txtFoodWasteAmount
            //
            for (i = 0; i < numMonths; i++)
            {
                txtFoodWasteAmount[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodWasteAmount[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmount[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodWasteAmount[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmount[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodWasteAmount[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmount[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodWasteAmount[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmount[i].Height             = 0.1875F;
                txtFoodWasteAmount[i].Left         = 1F + i * 0.625F;
                txtFoodWasteAmount[i].Name         = "txtFoodWasteAmount" + i;
                txtFoodWasteAmount[i].Style        = "font-size: 8pt; ";
                txtFoodWasteAmount[i].Text         = null;
                txtFoodWasteAmount[i].Top          = 1.88F;
                txtFoodWasteAmount[i].Width        = 0.625F;
                txtFoodWasteAmount[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtFoodWasteAmount[i]);
            }

            //
            // txtFoodWastePercentage
            //
            for (i = 0; i < numMonths; i++)
            {
                txtFoodWastePercentage[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodWastePercentage[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentage[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodWastePercentage[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentage[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodWastePercentage[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentage[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodWastePercentage[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentage[i].Height             = 0.1875F;
                txtFoodWastePercentage[i].Left         = 1F + i * 0.625F;
                txtFoodWastePercentage[i].Name         = "txtFoodWastePercentage" + i;
                txtFoodWastePercentage[i].Style        = "font-size: 8pt; ";
                txtFoodWastePercentage[i].Text         = null;
                txtFoodWastePercentage[i].Top          = 2.06F;
                txtFoodWastePercentage[i].Width        = 0.625F;
                txtFoodWastePercentage[i].OutputFormat = "#,##0.##%";
                this.detail.Controls.Add(txtFoodWastePercentage[i]);
            }

            line1.X2 = 0.3F + 0.625F * (numMonths + 1);
            line2.X1 = 0.3F + 0.625F * (numMonths + 1);
            line2.X2 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
            line3.X1 = 0.3F + 0.625F * (numMonths + 1);
            line3.X2 = 0.3F + 0.625F * (numMonths + 1);
            line4.X1 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
            line4.X2 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
            line7.X1 = 0.3F + 0.625F * (numMonths + 1);
            line7.X2 = 0.3F + 0.625F * (numMonths + 1);
            line8.X1 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
            line8.X2 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
            line9.X1 = 0.3F + 0.625F * (numMonths + 1);
            line9.X2 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;

            hdrTotal.Left = 0.3F + 0.625F * (numMonths + 1);

            txtTotalSalesBudget.Left          = 0.3F + 0.625F * (numMonths + 1);
            txtTotalFoodCostBudget.Left       = 0.3F + 0.625F * (numMonths + 1);
            txtTotalMealCountBudget.Left      = 0.3F + 0.625F * (numMonths + 1);
            txtTotalFoodCostPointsBudget.Left = 0.3F + 0.625F * (numMonths + 1);
            txtTotalSales.Left    = 0.3F + 0.625F * (numMonths + 1);
            txtTotalFoodCost.Left = 0.3F + 0.625F * (numMonths + 1);

            txtTotalMealCount.Left             = 0.3F + 0.625F * (numMonths + 1);
            txtTotalFoodCostPoints.Left        = 0.3F + 0.625F * (numMonths + 1);
            txtTotalFoodWastePercentage.Left   = 0.3F + 0.625F * (numMonths + 1);
            txtTotalFoodWasteAmount.Left       = 0.3F + 0.625F * (numMonths + 1);
            txtTotalSalesChanges.Left          = 0.3F + 0.625F * (numMonths + 1);
            txtTotalFoodCostChanges.Left       = 0.3F + 0.625F * (numMonths + 1);
            txtTotalMealCountChanges.Left      = 0.3F + 0.625F * (numMonths + 1);
            txtTotalFoodCostPointsChanges.Left = 0.3F + 0.625F * (numMonths + 1);
        }
コード例 #9
0
 public void InitializeReport()
 {
     this.LoadLayout(this.GetType(), "Reports.rptFDICTraining.rpx");
     this.ds           = ((DataDynamics.ActiveReports.DataSources.OleDBDataSource)(this.DataSource));
     this.PageHeader   = ((DataDynamics.ActiveReports.PageHeader)(this.Sections["PageHeader"]));
     this.GroupHeader1 = ((DataDynamics.ActiveReports.GroupHeader)(this.Sections["GroupHeader1"]));
     this.Detail       = ((DataDynamics.ActiveReports.Detail)(this.Sections["Detail"]));
     this.GroupFooter1 = ((DataDynamics.ActiveReports.GroupFooter)(this.Sections["GroupFooter1"]));
     this.PageFooter   = ((DataDynamics.ActiveReports.PageFooter)(this.Sections["PageFooter"]));
     this.Picture      = ((DataDynamics.ActiveReports.Picture)(this.PageHeader.Controls[0]));
     this.Label        = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[1]));
     this.Label1       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[2]));
     this.Label2       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[3]));
     this.lblEeName    = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[4]));
     this.lblEeNumber  = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[5]));
     this.Label3       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[6]));
     this.lblSsn       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[7]));
     this.Label5       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[8]));
     this.lblEePhone   = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[9]));
     this.Line         = ((DataDynamics.ActiveReports.Line)(this.PageHeader.Controls[10]));
     this.Label7       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[11]));
     this.Label8       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[12]));
     this.Label9       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[13]));
     this.Label10      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[14]));
     this.Label11      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[15]));
     this.Label12      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[16]));
     this.Label13      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[17]));
     this.Label14      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[18]));
     this.Label15      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[19]));
     this.Label16      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[20]));
     this.Label17      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[21]));
     this.Label18      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[22]));
     this.Label19      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[23]));
     this.Label20      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[24]));
     this.Label21      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[25]));
     this.Label22      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[26]));
     this.lblWebSite   = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[27]));
     this.Label24      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[28]));
     this.Label25      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[29]));
     this.Label26      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[30]));
     this.Label27      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[31]));
     this.Label28      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[32]));
     this.Label29      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[33]));
     this.Label30      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[34]));
     this.Label31      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[35]));
     this.Label34      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[36]));
     this.Label35      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[37]));
     this.Label36      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[38]));
     this.Label37      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[39]));
     this.Label38      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[40]));
     this.Label39      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[41]));
     this.Label40      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[42]));
     this.Label41      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[43]));
     this.Label42      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[44]));
     this.Label43      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[45]));
     this.Label44      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[46]));
     this.Label45      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[47]));
     this.TextBox7     = ((DataDynamics.ActiveReports.TextBox)(this.PageHeader.Controls[48]));
     this.TextBox8     = ((DataDynamics.ActiveReports.TextBox)(this.PageHeader.Controls[49]));
     this.Line2        = ((DataDynamics.ActiveReports.Line)(this.PageHeader.Controls[50]));
     this.Label4       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[51]));
     this.Label46      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[0]));
     this.Label47      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[1]));
     this.Label48      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[2]));
     this.Label49      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[3]));
     this.TextBox      = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[0]));
     this.TextBox1     = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[1]));
     this.TextBox2     = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[2]));
     this.TextBox3     = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[3]));
     this.Line1        = ((DataDynamics.ActiveReports.Line)(this.GroupFooter1.Controls[0]));
     this.Label50      = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[1]));
     this.TextBox4     = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[2]));
     this.TextBox5     = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[3]));
     this.TextBox6     = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[4]));
 }
コード例 #10
0
        private void InitCells()
        {
            int i;

            txtFoodCostPointsPrior        = new DataDynamics.ActiveReports.TextBox[12];
            txtFoodWasteAmountPrior       = new DataDynamics.ActiveReports.TextBox[12];
            txtFoodWastePercentagePrior   = new DataDynamics.ActiveReports.TextBox[12];
            txtFoodCostPoints             = new DataDynamics.ActiveReports.TextBox[12];
            txtFoodWasteAmount            = new DataDynamics.ActiveReports.TextBox[12];
            txtFoodWastePercentage        = new DataDynamics.ActiveReports.TextBox[12];
            txtFoodCostPointsChanges      = new DataDynamics.ActiveReports.TextBox[12];
            txtFoodWasteAmountChanges     = new DataDynamics.ActiveReports.TextBox[12];
            txtFoodWastePercentageChanges = new DataDynamics.ActiveReports.TextBox[12];
            for (i = 0; i < 12; i++)
            {
                txtFoodCostPointsPrior[i]        = new DataDynamics.ActiveReports.TextBox();
                txtFoodWasteAmountPrior[i]       = new DataDynamics.ActiveReports.TextBox();
                txtFoodWastePercentagePrior[i]   = new DataDynamics.ActiveReports.TextBox();
                txtFoodCostPoints[i]             = new DataDynamics.ActiveReports.TextBox();
                txtFoodWasteAmount[i]            = new DataDynamics.ActiveReports.TextBox();
                txtFoodWastePercentage[i]        = new DataDynamics.ActiveReports.TextBox();
                txtFoodCostPointsChanges[i]      = new DataDynamics.ActiveReports.TextBox();
                txtFoodWasteAmountChanges[i]     = new DataDynamics.ActiveReports.TextBox();
                txtFoodWastePercentageChanges[i] = new DataDynamics.ActiveReports.TextBox();
            }

            //
            // txtFoodCostPoints
            //
            for (i = 0; i < 12; i++)
            {
                txtFoodCostPointsPrior[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCostPointsPrior[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsPrior[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCostPointsPrior[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsPrior[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCostPointsPrior[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsPrior[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCostPointsPrior[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsPrior[i].Height             = 0.1875F;
                txtFoodCostPointsPrior[i].Left         = 1F + i * 0.625F;
                txtFoodCostPointsPrior[i].Name         = "txtFoodCostPointsPrior" + i;
                txtFoodCostPointsPrior[i].Style        = "font-size: 8pt; ";
                txtFoodCostPointsPrior[i].Text         = null;
                txtFoodCostPointsPrior[i].Top          = 0.19F;
                txtFoodCostPointsPrior[i].Width        = 0.625F;
                txtFoodCostPointsPrior[i].OutputFormat = _InputParameters["FinancialMode"].ParamValue == "Points" ? "#,##0.##%" : "$#,##0.##";
                this.detail.Controls.Add(txtFoodCostPointsPrior[i]);

                txtFoodCostPoints[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCostPoints[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPoints[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCostPoints[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPoints[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCostPoints[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPoints[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCostPoints[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPoints[i].Height             = 0.1875F;
                txtFoodCostPoints[i].Left         = 1F + i * 0.625F;
                txtFoodCostPoints[i].Name         = "txtFoodCostPoints" + i;
                txtFoodCostPoints[i].Style        = "font-size: 8pt; ";
                txtFoodCostPoints[i].Text         = null;
                txtFoodCostPoints[i].Top          = 0.94F;
                txtFoodCostPoints[i].Width        = 0.625F;
                txtFoodCostPoints[i].OutputFormat = txtFoodCostPointsPrior[i].OutputFormat;
                this.detail.Controls.Add(txtFoodCostPoints[i]);

                txtFoodCostPointsChanges[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodCostPointsChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsChanges[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodCostPointsChanges[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsChanges[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodCostPointsChanges[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsChanges[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodCostPointsChanges[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodCostPointsChanges[i].Height             = 0.1875F;
                txtFoodCostPointsChanges[i].Left         = 1F + i * 0.625F;
                txtFoodCostPointsChanges[i].Name         = "txtFoodCostPointsChanges" + i;
                txtFoodCostPointsChanges[i].Style        = "font-size: 8pt; ";
                txtFoodCostPointsChanges[i].Text         = null;
                txtFoodCostPointsChanges[i].Top          = 1.69F;
                txtFoodCostPointsChanges[i].Width        = 0.625F;
                txtFoodCostPointsChanges[i].OutputFormat = txtFoodCostPointsPrior[i].OutputFormat;
                this.detail.Controls.Add(txtFoodCostPointsChanges[i]);
            }

            //
            // txtFoodWasteAmount
            //
            for (i = 0; i < 12; i++)
            {
                txtFoodWasteAmountPrior[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodWasteAmountPrior[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmountPrior[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodWasteAmountPrior[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmountPrior[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodWasteAmountPrior[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmountPrior[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodWasteAmountPrior[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmountPrior[i].Height             = 0.1875F;
                txtFoodWasteAmountPrior[i].Left         = 1F + i * 0.625F;
                txtFoodWasteAmountPrior[i].Name         = "txtFoodWasteAmountPrior" + i;
                txtFoodWasteAmountPrior[i].Style        = "font-size: 8pt; ";
                txtFoodWasteAmountPrior[i].Text         = null;
                txtFoodWasteAmountPrior[i].Top          = 0.38F;
                txtFoodWasteAmountPrior[i].Width        = 0.625F;
                txtFoodWasteAmountPrior[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtFoodWasteAmountPrior[i]);

                txtFoodWasteAmount[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodWasteAmount[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmount[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodWasteAmount[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmount[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodWasteAmount[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmount[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodWasteAmount[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmount[i].Height             = 0.1875F;
                txtFoodWasteAmount[i].Left         = 1F + i * 0.625F;
                txtFoodWasteAmount[i].Name         = "txtFoodWasteAmount" + i;
                txtFoodWasteAmount[i].Style        = "font-size: 8pt; ";
                txtFoodWasteAmount[i].Text         = null;
                txtFoodWasteAmount[i].Top          = 1.13F;
                txtFoodWasteAmount[i].Width        = 0.625F;
                txtFoodWasteAmount[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtFoodWasteAmount[i]);

                txtFoodWasteAmountChanges[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodWasteAmountChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmountChanges[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodWasteAmountChanges[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmountChanges[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodWasteAmountChanges[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmountChanges[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodWasteAmountChanges[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWasteAmountChanges[i].Height             = 0.1875F;
                txtFoodWasteAmountChanges[i].Left         = 1F + i * 0.625F;
                txtFoodWasteAmountChanges[i].Name         = "txtFoodWasteAmountChanges" + i;
                txtFoodWasteAmountChanges[i].Style        = "font-size: 8pt; ";
                txtFoodWasteAmountChanges[i].Text         = null;
                txtFoodWasteAmountChanges[i].Top          = 1.88F;
                txtFoodWasteAmountChanges[i].Width        = 0.625F;
                txtFoodWasteAmountChanges[i].OutputFormat = "$#,##0";
                this.detail.Controls.Add(txtFoodWasteAmountChanges[i]);
            }

            //
            // txtFoodWastePercentage
            //
            for (i = 0; i < 12; i++)
            {
                txtFoodWastePercentagePrior[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodWastePercentagePrior[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentagePrior[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodWastePercentagePrior[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentagePrior[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodWastePercentagePrior[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentagePrior[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodWastePercentagePrior[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentagePrior[i].Height             = 0.1875F;
                txtFoodWastePercentagePrior[i].Left         = 1F + i * 0.625F;
                txtFoodWastePercentagePrior[i].Name         = "txtFoodWastePercentagePrior" + i;
                txtFoodWastePercentagePrior[i].Style        = "font-size: 8pt; ";
                txtFoodWastePercentagePrior[i].Text         = null;
                txtFoodWastePercentagePrior[i].Top          = 0.56F;
                txtFoodWastePercentagePrior[i].Width        = 0.625F;
                txtFoodWastePercentagePrior[i].OutputFormat = "#,##0.##%";
                this.detail.Controls.Add(txtFoodWastePercentagePrior[i]);

                txtFoodWastePercentage[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodWastePercentage[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentage[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodWastePercentage[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentage[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodWastePercentage[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentage[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodWastePercentage[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentage[i].Height             = 0.1875F;
                txtFoodWastePercentage[i].Left         = 1F + i * 0.625F;
                txtFoodWastePercentage[i].Name         = "txtFoodWastePercentage" + i;
                txtFoodWastePercentage[i].Style        = "font-size: 8pt; ";
                txtFoodWastePercentage[i].Text         = null;
                txtFoodWastePercentage[i].Top          = 1.31F;
                txtFoodWastePercentage[i].Width        = 0.625F;
                txtFoodWastePercentage[i].OutputFormat = "#,##0.##%";
                this.detail.Controls.Add(txtFoodWastePercentage[i]);

                txtFoodWastePercentageChanges[i].Border.BottomColor = System.Drawing.Color.Black;
                txtFoodWastePercentageChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentageChanges[i].Border.LeftColor   = System.Drawing.Color.Black;
                txtFoodWastePercentageChanges[i].Border.LeftStyle   = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentageChanges[i].Border.RightColor  = System.Drawing.Color.Black;
                txtFoodWastePercentageChanges[i].Border.RightStyle  = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentageChanges[i].Border.TopColor    = System.Drawing.Color.Black;
                txtFoodWastePercentageChanges[i].Border.TopStyle    = DataDynamics.ActiveReports.BorderLineStyle.None;
                txtFoodWastePercentageChanges[i].Height             = 0.1875F;
                txtFoodWastePercentageChanges[i].Left         = 1F + i * 0.625F;
                txtFoodWastePercentageChanges[i].Name         = "txtFoodWastePercentageChanges" + i;
                txtFoodWastePercentageChanges[i].Style        = "font-size: 8pt; ";
                txtFoodWastePercentageChanges[i].Text         = null;
                txtFoodWastePercentageChanges[i].Top          = 2.06F;
                txtFoodWastePercentageChanges[i].Width        = 0.625F;
                txtFoodWastePercentageChanges[i].OutputFormat = "#,##0.##%";
                this.detail.Controls.Add(txtFoodWastePercentageChanges[i]);
            }
        }
コード例 #11
0
        public void ApplyStyle()
        {
            int i, j;

            DataDynamics.ActiveReports.ARControl arc;

            #region Apply Style on Report

            //设置Margins.Left和Margins.Right,使报表内容居中
            if (this.PageSettings.Orientation.Equals(PageOrientation.Landscape))
            {
                this.PageSettings.Margins.Left = (this.PageSettings.PaperHeight - this.PrintWidth) / 2;
            }
            else
            {
                this.PageSettings.Margins.Left = (this.PageSettings.PaperWidth - this.PrintWidth) / 2;
            }
            this.PageSettings.Margins.Right = this.PageSettings.Margins.Left;

            for (j = 0; j < this.Sections.Count; j++)
            {
                for (i = 0; i < this.Sections[j].Controls.Count; i++)
                {
                    arc = (DataDynamics.ActiveReports.ARControl) this.Sections[j].Controls[i];
                    if (arc is DataDynamics.ActiveReports.TextBox)
                    {
                        DataDynamics.ActiveReports.TextBox tb = (DataDynamics.ActiveReports.TextBox)arc;
                        switch (tb.ClassName)
                        {
                        case "Heading1":
                            tb.Font = ftHeading1;
                            break;

                        case "Heading2":
                            tb.Font = ftHeading2;
                            break;

                        case "Heading3":
                            tb.Font = ftHeading3;
                            break;

                        case "Normal":
                            tb.Font = ftNormal;
                            break;
                        }
                    }
                    else if (arc is DataDynamics.ActiveReports.Label)
                    {
                        DataDynamics.ActiveReports.Label lb = (DataDynamics.ActiveReports.Label)arc;
                        switch (lb.ClassName)
                        {
                        case "Heading1":
                            lb.Font = ftHeading1;
                            //设置Heading1居中
                            lb.Left = 0;
                            lb.Top  = 0;
                            if (this.PageSettings.Orientation.Equals(PageOrientation.Landscape))
                            {
                                lb.Width = this.PageSettings.PaperHeight - this.PageSettings.Margins.Left - this.PageSettings.Margins.Right;
                            }
                            else
                            {
                                lb.Width = this.PageSettings.PaperWidth - this.PageSettings.Margins.Left - this.PageSettings.Margins.Right;
                            }
                            lb.Alignment = TextAlignment.Center;
                            break;

                        case "Heading2":
                            lb.Font = ftHeading2;
                            break;

                        case "Heading3":
                            lb.Font = ftHeading3;
                            break;

                        case "Normal":
                            lb.Font = ftNormal;
                            break;
                        }
                    }
                }
            }
            #endregion
        }
コード例 #12
0
 public void InitializeReport()
 {
     this.LoadLayout(this.GetType(), "Reports.rptFDICTraining.rpx");
     this.ds           = ((DataDynamics.ActiveReports.DataSources.OleDBDataSource)(this.DataSource));
     this.ReportHeader = ((DataDynamics.ActiveReports.ReportHeader)(this.Sections["ReportHeader"]));
     this.PageHeader   = ((DataDynamics.ActiveReports.PageHeader)(this.Sections["PageHeader"]));
     this.GroupHeader1 = ((DataDynamics.ActiveReports.GroupHeader)(this.Sections["GroupHeader1"]));
     this.Detail       = ((DataDynamics.ActiveReports.Detail)(this.Sections["Detail"]));
     this.GroupFooter1 = ((DataDynamics.ActiveReports.GroupFooter)(this.Sections["GroupFooter1"]));
     this.PageFooter   = ((DataDynamics.ActiveReports.PageFooter)(this.Sections["PageFooter"]));
     this.ReportFooter = ((DataDynamics.ActiveReports.ReportFooter)(this.Sections["ReportFooter"]));
     this.Label57      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[0]));
     this.Label58      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[1]));
     this.Label59      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[2]));
     this.Label60      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[3]));
     this.Label61      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[4]));
     this.Label62      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[5]));
     this.Label63      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[6]));
     this.Label64      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[7]));
     this.Line3        = ((DataDynamics.ActiveReports.Line)(this.ReportHeader.Controls[8]));
     this.Label65      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[9]));
     this.Label66      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[10]));
     this.Label67      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[11]));
     this.Label68      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[12]));
     this.Label69      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[13]));
     this.Label70      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[14]));
     this.Label71      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[15]));
     this.Label72      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[16]));
     this.Label73      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[17]));
     this.Label74      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[18]));
     this.Label75      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[19]));
     this.Label76      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[20]));
     this.Label77      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[21]));
     this.Label78      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[22]));
     this.Label79      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[23]));
     this.Label80      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[24]));
     this.Label81      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[25]));
     this.Label82      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[26]));
     this.Label83      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[27]));
     this.Label84      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[28]));
     this.Label85      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[29]));
     this.Label86      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[30]));
     this.TextBox9     = ((DataDynamics.ActiveReports.TextBox)(this.ReportHeader.Controls[31]));
     this.TextBox10    = ((DataDynamics.ActiveReports.TextBox)(this.ReportHeader.Controls[32]));
     this.Label87      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[33]));
     this.Label88      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[34]));
     this.Label89      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[35]));
     this.Label90      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[36]));
     this.Label91      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[37]));
     this.Line4        = ((DataDynamics.ActiveReports.Line)(this.ReportHeader.Controls[38]));
     this.Label92      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[39]));
     this.Label93      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[40]));
     this.Label94      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[41]));
     this.Label95      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[42]));
     this.Label96      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[43]));
     this.Label97      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[44]));
     this.Label98      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[45]));
     this.Label99      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[46]));
     this.Label100     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[47]));
     this.Label101     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[48]));
     this.Label102     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[49]));
     this.Label103     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[50]));
     this.Label104     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[51]));
     this.Label105     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[52]));
     this.Label106     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[53]));
     this.Label107     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[54]));
     this.Label108     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[55]));
     this.Label109     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[56]));
     this.Label110     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[57]));
     this.Label111     = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[58]));
     this.Label2       = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[59]));
     this.Label1       = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[60]));
     this.Label14      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[61]));
     this.Label15      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[62]));
     this.Label16      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[63]));
     this.Label17      = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[64]));
     this.Picture1     = ((DataDynamics.ActiveReports.Picture)(this.ReportHeader.Controls[65]));
     this.Picture2     = ((DataDynamics.ActiveReports.Picture)(this.ReportHeader.Controls[66]));
     this.Label4       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[0]));
     this.Label        = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[1]));
     this.Label3       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[2]));
     this.Label6       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[3]));
     this.Label7       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[4]));
     this.Label8       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[5]));
     this.Label9       = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[6]));
     this.Label10      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[7]));
     this.Label11      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[8]));
     this.Label12      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[9]));
     this.Label13      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[10]));
     this.Line         = ((DataDynamics.ActiveReports.Line)(this.PageHeader.Controls[11]));
     this.Label18      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[12]));
     this.Label19      = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[13]));
     this.Picture      = ((DataDynamics.ActiveReports.Picture)(this.PageHeader.Controls[14]));
     this.Picture3     = ((DataDynamics.ActiveReports.Picture)(this.PageHeader.Controls[15]));
     this.Label46      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[0]));
     this.Label47      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[1]));
     this.Label48      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[2]));
     this.Label49      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[3]));
     this.Label5       = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[4]));
     this.TextBox      = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[0]));
     this.TextBox1     = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[1]));
     this.TextBox2     = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[2]));
     this.TextBox3     = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[3]));
     this.TextBox7     = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[4]));
     this.Line1        = ((DataDynamics.ActiveReports.Line)(this.GroupFooter1.Controls[0]));
     this.Label50      = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[1]));
     this.TextBox4     = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[2]));
     this.TextBox5     = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[3]));
     this.TextBox6     = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[4]));
 }
コード例 #13
0
ファイル: rptInvoiceNL_CN7.cs プロジェクト: orlyjamie/JKS
 public void InitializeReport()
 {
     this.LoadLayout(this.GetType(), "CBSolutions.ETH.Web.GMGRadio.creditnotes.rptInvoiceNL_CN.rpx");
     this.PageHeader              = ((DataDynamics.ActiveReports.PageHeader)(this.Sections["PageHeader"]));
     this.GroupHeader1            = ((DataDynamics.ActiveReports.GroupHeader)(this.Sections["GroupHeader1"]));
     this.Detail                  = ((DataDynamics.ActiveReports.Detail)(this.Sections["Detail"]));
     this.GroupFooter1            = ((DataDynamics.ActiveReports.GroupFooter)(this.Sections["GroupFooter1"]));
     this.PageFooter              = ((DataDynamics.ActiveReports.PageFooter)(this.Sections["PageFooter"]));
     this.Label23                 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[0]));
     this.Shape1                  = ((DataDynamics.ActiveReports.Shape)(this.GroupHeader1.Controls[0]));
     this.TextBox1                = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[1]));
     this.TextBox2                = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[2]));
     this.TextBox3                = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[3]));
     this.Label1                  = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[4]));
     this.Label2                  = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[5]));
     this.Label3                  = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[6]));
     this.Label5                  = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[7]));
     this.Label6                  = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[8]));
     this.Label8                  = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[9]));
     this.Label9                  = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[10]));
     this.TextBox6                = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[11]));
     this.TextBox7                = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[12]));
     this.TextBox8                = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[13]));
     this.TextBox9                = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[14]));
     this.Label10                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[15]));
     this.Label11                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[16]));
     this.Label13                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[17]));
     this.Label15                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[18]));
     this.Label16                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[19]));
     this.Label17                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[20]));
     this.Label18                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[21]));
     this.Label19                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[22]));
     this.Label20                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[23]));
     this.Label21                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[24]));
     this.TextBox19               = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[25]));
     this.TextBox20               = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[26]));
     this.TextBox21               = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[27]));
     this.Label22                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[28]));
     this.Label27                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[29]));
     this.TextBox25               = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[30]));
     this.Label28                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[31]));
     this.Label29                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[32]));
     this.Label30                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[33]));
     this.Label32                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[34]));
     this.txtAssociatedInvoiceNo  = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[35]));
     this.lblSecondDisc           = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[36]));
     this.lblSettlementDay        = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[37]));
     this.txtSettlementDay        = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[38]));
     this.lblOverallDiscount      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[39]));
     this.txtOverallDiscount      = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[40]));
     this.lblBuyerCompany         = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[41]));
     this.txtBuyerCompany         = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[42]));
     this.lblSupplierCompany      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[43]));
     this.txtSupplierCompany      = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[44]));
     this.txtCustomerContact      = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[45]));
     this.lblCustomerContact      = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[46]));
     this.lblInvoiceName          = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[47]));
     this.txtInvoiceName          = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[48]));
     this.lblSecondSettlementDays = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[49]));
     this.txtSecondSettlementDays = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[50]));
     this.Label73                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[51]));
     this.txtSettlementDiscount2  = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[52]));
     this.Label74                 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[53]));
     this.lblPaymentDate          = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[54]));
     this.lblPaymentMethod        = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[55]));
     this.txtPaymentDate          = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[56]));
     this.txtPaymentMethod        = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[57]));
     this.lblDiscountGiven        = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[58]));
     this.txtDiscountGiven        = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[59]));
     this.Line3                  = ((DataDynamics.ActiveReports.Line)(this.GroupHeader1.Controls[60]));
     this.Line4                  = ((DataDynamics.ActiveReports.Line)(this.GroupHeader1.Controls[61]));
     this.Label76                = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[62]));
     this.TextBox10              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[0]));
     this.TextBox12              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[1]));
     this.TextBox13              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[2]));
     this.TextBox15              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[3]));
     this.TextBox16              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[4]));
     this.TextBox17              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[5]));
     this.TextBox18              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[6]));
     this.TextBox26              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[7]));
     this.TextBox27              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[8]));
     this.TextBox28              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[9]));
     this.txtSecondDiscount      = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[10]));
     this.TextBox29              = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[11]));
     this.txtColor               = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[12]));
     this.Label24                = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[0]));
     this.TextBox22              = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[1]));
     this.TextBox23              = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[2]));
     this.Label25                = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[3]));
     this.Label26                = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[4]));
     this.TextBox24              = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[5]));
     this.Line2                  = ((DataDynamics.ActiveReports.Line)(this.GroupFooter1.Controls[6]));
     this.lblGBPEquivalentAmount = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[7]));
     this.tblGBPEquivalentAmount = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[8]));
     this.Label71                = ((DataDynamics.ActiveReports.Label)(this.PageFooter.Controls[0]));
     // Attach Report Events
     this.DataInitialize += new System.EventHandler(this.rptInvoice_DataInitialize);
     this.FetchData      += new DataDynamics.ActiveReports.ActiveReport.FetchEventHandler(this.rptInvoice_FetchData);
 }