Beispiel #1
0
        void InitGroupHeaders(MVCxGridViewState gridViewState)
        {
            GridViewDataColumnStateCollection groupedColumns = gridViewState.GroupedColumns;

            for (int i = groupedColumns.Count - 1; i >= 0; i--)
            {
                {
                    GridViewDataColumnState groupedColumn = groupedColumns[i];
                    GroupHeaderBand         gb            = new GroupHeaderBand();
                    gb.Height = bandHeight;
                    XRLabel l = new XRLabel
                    {
                        Text      = groupedColumn.FieldName + ": [" + groupedColumn.FieldName + "]",
                        LocationF = new PointF(initialGroupOffset + i * 10, 0),
                        BackColor = Color.Beige,
                        SizeF     = new SizeF((report.PageWidth - (report.Margins.Left + report.Margins.Right)) - (initialGroupOffset + i * subGroupOffset), bandHeight)
                    };
                    gb.Controls.Add(l);
                    gb.RepeatEveryPage = shouldRepeatGroupHeadersOnEveryPage;
                    GroupField gf = new GroupField(groupedColumn.FieldName, groupedColumn.SortOrder == ColumnSortOrder.Ascending ? XRColumnSortOrder.Ascending : XRColumnSortOrder.Descending);
                    gb.GroupFields.Add(gf);
                    report.Bands.Add(gb);
                }
            }
        }
Beispiel #2
0
        public void BindDataSum(DataTable da)
        {
            xrTable4.Visible = false;
            DataSource       = da;

            Bands.Add(GroupHeader1);
            GroupField groupField = new GroupField("Số phiếu");

            GroupHeader1.GroupFields.Add(groupField);
            xrTableCell1.DataBindings.Add("Text", DataSource, "Số phiếu");
            xrTableCell2.DataBindings.Add("Text", DataSource, "Ngày", "{0:dd-MM-yyyy}");
            xrTableCell3.DataBindings.Add("Text", DataSource, "Lý do");
            xrTableCell4.DataBindings.Add("Text", DataSource, "Nhân viên");


            XRSummary summarytotal  = new XRSummary();
            XRSummary summarytotal1 = new XRSummary();

            summarytotal.Running          = SummaryRunning.Group;
            summarytotal.IgnoreNullValues = true;
            summarytotal.FormatString     = "{0:n0}";
            xrTableCell20.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
            xrTableCell20.Summary = summarytotal;

            summarytotal1.Running          = SummaryRunning.Report;
            summarytotal1.IgnoreNullValues = true;
            summarytotal1.FormatString     = "{0:n0}";
            xrTableCell19.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
            xrTableCell19.Summary = summarytotal1;

            xrTableCell7.DataBindings.Add("Text", DataSource, "Tài khoản nợ");
            xrTableCell10.DataBindings.Add("Text", DataSource, "Tài khoản có");
            xrTableCell11.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
        }
Beispiel #3
0
        public void gettieudegau(string tungay, string denngay, string makhuyenmai)
        {
            xrLabel5.Text = "BÁO CÁO ĐỐI CHIẾU CHIẾT KHẤU GẤU ĐỎ";
            xrLabel1.Text = gen.GetString("select Top 1 CompanyName from Center");
            xrLabel2.Text = gen.GetString("select Top 1 Address from Center");
            xrLabel6.Text = "MÃ KHUYẾN MÃI - " + makhuyenmai.ToUpper();

            xrLabel4.Text = "In lúc: " + String.Format("{0:HH:mm:ss}", DateTime.Now) + " ngày: " + String.Format("{0:dd-MM-yyyy}", DateTime.Now);

            DataTable da = new DataTable();

            da = gen.GetTable("select Substring(RefNo,7,9) as 'Số phiếu',RefDate as 'Ngày lập',REPLACE(InvoiceNo,'UNI','') as 'Đơn hàng',case when FreeCode='" + makhuyenmai + "' then sotien end as 'Số tiền',case when FreeCode<>'" + makhuyenmai + "' then sotien end as 'Tiền khác', case when FreeCode<>'" + makhuyenmai + "' then FreeCode end 'Chương trình khác',tongtien as 'Tổng tiền',chietkhau as 'Chiết khấu',Case when tongtien-chietkhau<>0 then tongtien-chietkhau end as 'Chênh lệch' from (select a.InvoiceNo,FreeCode,sotien,tongtien from (select a.InvoiceNo,FreeCode,SUM(Amount) as sotien from (select * from INOutwardCheck where Amount<>0) a, (select distinct InvoiceNo  from INOutwardCheck where FreeCode='" + makhuyenmai + "') b where a.InvoiceNo=b.InvoiceNo group by a.InvoiceNo,FreeCode) a,(select a.InvoiceNo,SUM(Amount) as tongtien from (select * from INOutwardCheck where Amount<>0) a, (select distinct InvoiceNo  from INOutwardCheck where FreeCode='" + makhuyenmai + "') b where a.InvoiceNo=b.InvoiceNo group by a.InvoiceNo) b where a.InvoiceNo=b.InvoiceNo) a,(select RefNo,RefDate,JournalMemo,Round(TotalFreightAmount/1.1,0) as chietkhau from INOutward) b where a.InvoiceNo=b.JournalMemo order by RefNo,RefDate,[Số tiền] DESC");

            DataSource = da;

            XRSummary summarytotal  = new XRSummary();
            XRSummary summarytotal1 = new XRSummary();
            XRSummary summarytotal2 = new XRSummary();
            XRSummary summarytotal3 = new XRSummary();
            XRSummary summarytotal4 = new XRSummary();
            XRSummary summarytotal5 = new XRSummary();

            Bands.Add(GroupHeader1);
            GroupField groupField = new GroupField("Đơn hàng");

            GroupHeader1.GroupFields.Add(groupField);
            xrTableCell10.DataBindings.Add("Text", DataSource, "Đơn hàng");
            xrTableCell9.DataBindings.Add("Text", DataSource, "Ngày lập", "{0:dd/MM/yy}");
            xrTableCell8.DataBindings.Add("Text", DataSource, "Số phiếu");
            xrTableCell15.DataBindings.Add("Text", DataSource, "Chiết khấu", "{0:n0}");
            xrTableCell18.DataBindings.Add("Text", DataSource, "Chênh lệch", "{0:n0}");

            summarytotal.Running          = SummaryRunning.Group;
            summarytotal.IgnoreNullValues = true;
            summarytotal.FormatString     = "{0:n0}";
            xrTableCell11.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
            xrTableCell11.Summary = summarytotal;

            summarytotal1.Running          = SummaryRunning.Group;
            summarytotal1.IgnoreNullValues = true;
            summarytotal1.FormatString     = "{0:n0}";
            xrTableCell12.DataBindings.Add("Text", DataSource, "Tiền khác", "{0:n0}");
            xrTableCell12.Summary = summarytotal1;

            summarytotal4.Running          = SummaryRunning.Report;
            summarytotal4.IgnoreNullValues = true;
            summarytotal4.FormatString     = "{0:n0}";
            xrTableCell20.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
            xrTableCell20.Summary = summarytotal4;

            summarytotal5.Running          = SummaryRunning.Report;
            summarytotal5.IgnoreNullValues = true;
            summarytotal5.FormatString     = "{0:n0}";
            xrTableCell21.DataBindings.Add("Text", DataSource, "Tiền khác", "{0:n0}");
            xrTableCell21.Summary = summarytotal5;

            xrTableCell22.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
            xrTableCell24.DataBindings.Add("Text", DataSource, "Tiền khác", "{0:n0}");
            xrTableCell26.DataBindings.Add("Text", DataSource, "Chương trình khác");
        }
Beispiel #4
0
            private void ResolveColumns(List <object[]> row)
            {
                foreach (object[] cell in row)
                {
                    GroupField groupField = cell[2] as GroupField;
                    if (groupField != null && groupField.Columns.Count > 0)
                    {
                        List <object[]> subrow = new List <object[]>();
                        foreach (GridColumn column in groupField.Columns)
                        {
                            subrow.Add(new object[]
                            {
                                1,
                                1,
                                column,
                                groupField
                            });
                        }

                        ResolveColumns(subrow);
                    }
                    else
                    {
                        Columns.Add(cell[2] as GridColumn);
                    }
                }
            }
        public void Sort(string fieldName)
        {
            // Disable sorting.
            Detail.SortFields.Clear();

            // Create a new sorting criterion.
            GroupField grField = new GroupField {
                FieldName = fieldName
            };

            if (prevSortOrder == XRColumnSortOrder.Ascending)
            {
                prevSortOrder = XRColumnSortOrder.Descending;
            }
            else
            {
                prevSortOrder = XRColumnSortOrder.Ascending;
            }
            grField.SortOrder = prevSortOrder;

            // Enable sorting.
            Detail.SortFields.Add(grField);

            // Re-create the report document.
            CreateDocument(true);
        }
        public void _bindData()
        {
            // Create a label.
            xrTableCell1.DataBindings.Add("Text", null, "id");

            xrLabel4.DataBindings.Add("Text", null, "hoten");
            GroupField g = new GroupField();
            g.FieldName = "hoten";
            g.SortOrder = XRColumnSortOrder.Ascending;
            GroupHeader1.Controls.Add(xrLabel4);
            GroupHeader1.GroupFields.Add(g);

            xrTableCell3.DataBindings.Add("Text", null, "sodienthoai");
            xrLabel12.DataBindings.Add("Text", null, "sodienthoai");
            //// Add the label to the report's Detail band.
            //Detail.Controls.Add(label);

            //// Set its location and size.
            //label.Location = bounds.Location;
            //label.Size = bounds.Size;

            //// Bind it to the bindingMember data field.
            //// When the dataSource parameter is null, the report's data source is used.
            //label.DataBindings.Add("Text", null, bindingMember);
        }
Beispiel #7
0
        private void bPSUPX_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            Server2Client  sc = new Server2Client();
            ProductDetails pd = new ProductDetails();

            sc = pd.ProductListBySupplierExtended();

            rptProductBySup rpt = new rptProductBySup()
            {
                DataSource = sc.dataTable
            };

            GroupField grp = new GroupField("SupplierName");

            rpt.groupHeader.GroupFields.Add(grp);

            rpt.lbSUP.DataBindings.Add("Text", null, "SupplierName");
            rpt.lbPNM.DataBindings.Add("Text", null, "ProductName");
            rpt.lbBVL.DataBindings.Add("Text", null, "BuyingValue", "{0:C2}");
            rpt.lbSVL.DataBindings.Add("Text", null, "SellingValue", "{0:C2}");
            rpt.lbQTY.DataBindings.Add("Text", null, "Quantity");
            rpt.lbBCD.DataBindings.Add("Text", null, "BarCode");
            dv.PrintingSystem = rpt.PrintingSystem;
            rpt.CreateDocument(true);
        }
Beispiel #8
0
        public void _bindData()
        {
            // Create a label.
            xrTableCell1.DataBindings.Add("Text", null, "id");

            xrLabel4.DataBindings.Add("Text", null, "hoten");
            GroupField g = new GroupField();

            g.FieldName = "hoten";
            g.SortOrder = XRColumnSortOrder.Ascending;
            GroupHeader1.Controls.Add(xrLabel4);
            GroupHeader1.GroupFields.Add(g);

            xrTableCell3.DataBindings.Add("Text", null, "sodienthoai");
            xrLabel12.DataBindings.Add("Text", null, "sodienthoai");
            //// Add the label to the report's Detail band.
            //Detail.Controls.Add(label);

            //// Set its location and size.
            //label.Location = bounds.Location;
            //label.Size = bounds.Size;

            //// Bind it to the bindingMember data field.
            //// When the dataSource parameter is null, the report's data source is used.
            //label.DataBindings.Add("Text", null, bindingMember);
        }
        private void barButtonItemLocaleStatus_ItemClick(object sender, ItemClickEventArgs e)
        {
            DataTable dtLocaleReport = new DataTable();
            XtraReportLocaleStatus localeStatusReport = new XtraReportLocaleStatus();

            using (var adapt = new SqlDataAdapter("GET_LOCALE_REPORT", Utilities.con))
            {
                adapt.SelectCommand.CommandType = CommandType.StoredProcedure;
                adapt.Fill(dtLocaleReport);
                localeStatusReport.DataSource = dtLocaleReport;
            }

            if (dtLocaleReport.Rows.Count == 0)
            {
                MessageBox.Show("No Status found");
            }
            else
            {
                GroupField gfFlag = new GroupField(dtLocaleReport.Columns["flag"].ToString());

                localeStatusReport.GroupHeader.GroupFields.Add(gfFlag);

                localeStatusReport.xrLabelGroup.DataBindings.Add("Text", dtLocaleReport, dtLocaleReport.Columns["flag"].ToString());
                localeStatusReport.xrLabelMonth.Text = "As of " + DateTime.Now.ToString("MMMM").ToUpper();
                localeStatusReport.xrLabelUser.Text  = "Generated by: " + frmLogin.Username;

                localeStatusReport.xrTableCellStatus.DataBindings.Add("Text", dtLocaleReport, dtLocaleReport.Columns["Status"].ToString());
                localeStatusReport.xrTableCellTotal.DataBindings.Add("Text", dtLocaleReport, dtLocaleReport.Columns["Total"].ToString());
                localeStatusReport.CreateDocument();

                ReportPrintTool printTool = new ReportPrintTool(localeStatusReport);
                printTool.ShowPreview();
            }
        }
Beispiel #10
0
        public List<int> GetGroupPriceList(GroupField field, int numberOfGroup)
        {
            var result = new List<int>();

            if (numberOfGroup < 0) numberOfGroup = 1;

            var groupSize = CalculateGroupSize(_products.Count, numberOfGroup);

            var items = GetGroupByField(field);

            for (int i = 0; i < groupSize; i++)
            {
                int total;
                if (items.Count >= numberOfGroup)
                {
                    total = items.Take(numberOfGroup).Sum();
                    result.Add(total);
                }
                else
                {
                    total = items.Sum();
                    result.Add(total);
                    break;
                }

                items.RemoveRange(0, numberOfGroup);
            }

            return result;
        }
Beispiel #11
0
        void btn_Click(object sender, EventArgs e)
        {
            GroupField en = new GroupField(this.RefOID);

            en.Lab = this.Pub1.GetTBByID("TB_Lab_" + en.OID).Text;
            en.Update();

            Btn btn = sender as Btn;

            switch (btn.ID)
            {
            case "Btn_SaveAndClose":
                this.WinClose();
                break;

            case "Btn_NewField":
                this.Session["GroupField"] = this.RefOID;
                this.Response.Redirect("Do.aspx?DoType=AddF&MyPK=" + this.RefNo + "&GroupField=" + this.RefOID, true);
                break;

            case "Btn_CopyField":
                this.Response.Redirect("CopyFieldFromNode.aspx?FK_Node=" + this.RefNo + "&GroupField=" + this.RefOID, true);
                break;

            default:
                this.Response.Redirect("GroupField.aspx?RefNo=" + this.RefNo + "&RefOID=" + this.RefOID, true);
                break;
            }
        }
Beispiel #12
0
        private void barButtonItemAccept_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            BindAttendanceToReport();

            if (dtAttendance.Rows.Count == 0)
            {
                Utilities.ErrorMessage("Gathering does not exists...");
            }
            else
            {
                SetHeaders();

                GroupField gfBatch       = new GroupField(dtAttendance.Columns["batch_time"].ToString());
                GroupField gfInterlocale = new GroupField(dtAttendance.Columns["Interlocale_Status"].ToString());
                attendanceReport.GroupHeader.GroupFields.Add(gfInterlocale);
                attendanceReport.GroupHeader.GroupFields.Add(gfBatch);

                attendanceReport.xrLabelInterlocale.DataBindings.Add("Text", dtAttendance, dtAttendance.Columns["Interlocale_Status"].ToString());
                attendanceReport.xrLabelBatch.DataBindings.Add("Text", dtAttendance, dtAttendance.Columns["batch_time_lbl"].ToString());
                attendanceReport.xrTableCellChurchID.DataBindings.Add("Text", dtAttendance, dtAttendance.Columns["Church_Id"].ToString());
                attendanceReport.xrTableCellName.DataBindings.Add("Text", dtAttendance, dtAttendance.Columns["BrethrenName"].ToString());
                attendanceReport.xrTableCellTimeIn.DataBindings.Add("Text", dtAttendance, dtAttendance.Columns["time_in"].ToString());
                attendanceReport.xrTableCellStatus.DataBindings.Add("Text", dtAttendance, dtAttendance.Columns["AttendanceStatus"].ToString());
                attendanceReport.xrTableCellLocale.DataBindings.Add("Text", dtAttendance, dtAttendance.Columns["locale"].ToString());
                attendanceReport.Name = gridView1.GetFocusedRowCellValue("Gathering_Type").ToString().Replace(" ", string.Empty);
                attendanceReport.CreateDocument();
                ReportPrintTool printTool = new ReportPrintTool(attendanceReport);
                printTool.ShowPreviewDialog();
            }
        }
Beispiel #13
0
        public void BindData()
        {
            GroupField grp = new GroupField("Loai", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending);

            grpLoai.GroupFields.Add(grp);
            crGrpLoai.DataBindings.Add(new XRBinding("Text", DataSource, "Loai"));

            crNgayBan.DataBindings.Add(new XRBinding("Text", DataSource, "Ngaylap"));
            crTenKH.DataBindings.Add(new XRBinding("Text", DataSource, "Tenkh"));
            crDiaChi.DataBindings.Add(new XRBinding("Text", DataSource, "Diachi"));
            crDienthoai.DataBindings.Add(new XRBinding("Text", DataSource, "Dienthoai"));
            crThuNgan.DataBindings.Add(new XRBinding("Text", DataSource, "Thungan"));
            crGhichu.DataBindings.Add(new XRBinding("Text", DataSource, "Ghichu"));

            crSTT.DataBindings.Add(new XRBinding("Text", DataSource, "STT"));
            crTenSP.DataBindings.Add(new XRBinding("Text", DataSource, "Diengiai"));
            crSL.DataBindings.Add(new XRBinding("Text", DataSource, "Soluong", "{0:n0}"));
            crDonGia.DataBindings.Add(new XRBinding("Text", DataSource, "Dongia", "{0:n0}"));
            crThanhtien.DataBindings.Add(new XRBinding("Text", DataSource, "Nguyente", "{0:n0}"));

            crTienhang.DataBindings.Add(new XRBinding("Text", DataSource, "Tienhang", "{0:n0}"));
            crChietKhau.DataBindings.Add(new XRBinding("Text", DataSource, "TongTTCk", "{0:n0}"));
            crTongCong.DataBindings.Add(new XRBinding("Text", DataSource, "Thanhtoan", "{0:N0}"));
            crDiemtichluy.DataBindings.Add(new XRBinding("Text", DataSource, "DiemTichLuy", "{0:N0}"));
        }
        public XtraStatementOfAccountReport()
        {
            InitializeComponent();
            GroupField gf = new GroupField("用料", XRColumnSortOrder.Ascending);

            ((GroupHeaderBand)(this.DetailReportSummary.FindControl("GroupHeader2", true))).GroupFields.Add(gf);
        }
Beispiel #15
0
        public rp_masa_grubuna_gore_satislar(DateTime tarih1, DateTime tarih2)
        {
            InitializeComponent();

            lbl_tarih.Text = tarih1.Day + "." + tarih1.Month + "." + tarih1.Year + "-" + tarih2.Day + "." + tarih2.Month + "." + tarih2.Year;
            DataTable dt = SQL.get(" SELECT " +
                                   "     mk.masa_kategori, " +
                                   "     tutar = ISNULL((SELECT SUM(fh.miktar) FROM finans_hareket fh INNER JOIN adisyon a ON a.adisyon_id = fh.referans_id INNER JOIN masalar m ON m.masa_id = a.masa_id AND m.masa_kategori_id = mk.masa_kategori_id WHERE fh.silindi = 0 AND fh.hareket_tipi_parametre_id IN (25, 26, 27) AND fh.kayit_tarihi BETWEEN '" + tarih1.ToString("yyyy-MM-dd HH:mm:00.000") + "' AND DATEADD(DAY, 0, '" + tarih2.ToString("yyyy-MM-dd HH:mm:00.000") + "')), 0) " +
                                   " FROM masalar_kategori mk " +
                                   " WHERE mk.silindi = 0 " +
                                   " AND 0 != ISNULL((SELECT SUM(fh.miktar) FROM finans_hareket fh INNER JOIN adisyon a ON a.adisyon_id = fh.referans_id INNER JOIN masalar m ON m.masa_id = a.masa_id AND m.masa_kategori_id = mk.masa_kategori_id WHERE fh.silindi = 0 AND fh.hareket_tipi_parametre_id IN (25, 26, 27) AND fh.kayit_tarihi BETWEEN '" + tarih1.ToString("yyyy-MM-dd HH:mm:00.000") + "' AND DATEADD(DAY, 0, '" + tarih2.ToString("yyyy-MM-dd HH:mm:00.000") + "')), 0)");

            this.DataSource = dt;

            XRBinding binding0 = new XRBinding("Text", this.DataSource, "masa_kategori", "");

            tc_masa_grubu.DataBindings.Add(binding0);
            XRBinding binding1 = new XRBinding("Text", this.DataSource, "tutar", "{0:c2}");

            tc_tutar.DataBindings.Add(binding1);

            GroupField sortField = new GroupField("tutar");

            sortField.SortOrder = XRColumnSortOrder.Descending;
            this.Detail.SortFields.Add(sortField);
        }
        private void InsertGroupBand(GridColumn gridColumn, int i)
        {
            GroupHeaderBand gb = new GroupHeaderBand();

            gb.Height          = 25;
            gb.RepeatEveryPage = true;
            XRLabel l = new XRLabel();

            l.DataBindings.Add("Text", this.DataSource, gridColumn.Caption);
            l.Size      = new Size(300, 25);
            l.Location  = new Point(0 + i * 20, 0);
            l.BackColor = Color.Beige;
            gb.Controls.Add(l);
            GroupField gf;

            if (gridColumn.SortOrder == ColumnSortOrder.Ascending)
            {
                gf = new GroupField(gridColumn.FieldName, XRColumnSortOrder.Ascending);
            }
            else
            {
                gf = new GroupField(gridColumn.FieldName, XRColumnSortOrder.Descending);
            }
            gb.GroupFields.Add(gf);
            this.Bands.Add(gb);
        }
Beispiel #17
0
        public rp_personel_iptal(DateTime tarih1, DateTime tarih2)
        {
            InitializeComponent();

            lbl_tarih.Text = tarih1.Day + "." + tarih1.Month + "." + tarih1.Year + "-" + tarih2.Day + "." + tarih2.Month + "." + tarih2.Year;
            DataTable dt = SQL.get("SELECT ad_soyad = k.ad + ' ' + k.soyad, u.urun_adi, miktar = SUM(ak.miktar), tutar = SUM(ak.miktar * u.fiyat) FROM kullanicilar k LEFT OUTER JOIN adisyon_kalem ak ON ak.silindi = 1 AND ak.durum_parametre_id != 51 AND ak.kaydeden_kullanici_id = k.kullanici_id AND ak.kayit_tarihi BETWEEN '" + tarih1.ToString("yyyy-MM-dd HH:mm:00.000") + "' AND DATEADD(DAY, 0, '" + tarih2.ToString("yyyy-MM-dd HH:mm:00.000") + "') INNER JOIN urunler u ON u.urun_id = ak.urun_id " +
                                   " WHERE k.silindi = 0 GROUP by k.ad, k.soyad, u.urun_adi");

            this.DataSource = dt;

            XRBinding binding0 = new XRBinding("Text", this.DataSource, "ad_soyad", "");

            lbl_personel.DataBindings.Add(binding0);
            XRBinding binding2 = new XRBinding("Text", this.DataSource, "urun_adi", "");

            tc_urun.DataBindings.Add(binding2);
            XRBinding binding3 = new XRBinding("Text", this.DataSource, "miktar", "{0:n2}");

            tc_miktar.DataBindings.Add(binding3);
            XRBinding binding4 = new XRBinding("Text", this.DataSource, "tutar", "{0:c2}");

            tc_tutar.DataBindings.Add(binding4);

            GroupField sortField = new GroupField("tutar");

            sortField.SortOrder = XRColumnSortOrder.Descending;
            this.Detail.SortFields.Add(sortField);

            GroupField groupField = new GroupField("ad_soyad");

            GroupHeader1.GroupFields.Add(groupField);
        }
Beispiel #18
0
        /// <summary>
        /// 设置主从表的数据源
        /// </summary>
        /// <param name="reportData"></param>
        public void SetReportDataSource(DataSet reportData)
        {
            //因涉及到修改DataSet的内部属性,建议创建副本进行操作。
            DataSet ds = reportData.Copy();//创建副本

            //重要!!!给组(GroupHeader)绑定主键字段
            //本报表是按业务单号分组
            GroupField gf = new GroupField("SONO", XRColumnSortOrder.Ascending);

            GroupHeader1.GroupFields.Add(gf);

            //给数据集建立主外键关系
            DataColumn   parentColumn = ds.Tables["tb_SO"].Columns["SONO"];
            DataColumn   childColumn  = ds.Tables["tb_SOs"].Columns["SONO"];
            DataRelation R1           = new DataRelation("R1", parentColumn, childColumn);

            ds.Relations.Add(R1);

            //绑定主表的数据源
            this.DataMember = "tb_SO";
            this.DataSource = ds;

            //绑定明细表的数据源
            this.DetailReport.DataMember = "R1";
            this.DetailReport.DataSource = ds;

            //自动绑定明细表XRLabel的数据源
            this.BindingFields(ds, this.Detail1.Controls);

            xrLabel15.DataBindings.Add("Text", ds, "R1.Amount"); //绑定小计(当前单据的总金额)
            xrLabel23.DataBindings.Add("Text", ds, "R1.Amount"); //绑定总计(所有单据的总金额)
        }
        private void GridBoundAdd(FineUIPro.Grid grid, DataRow[] rows, DataTable table, GroupField gf)
        {
            foreach (DataRow row in rows)
            {
                DataRow[] drs = table.Select("SJCODE='" + row["CODE"].ToString() + "'");
                if (drs.Length > 0)
                {
                    GroupField gf1 = new GroupField();
                    gf1.HeaderText = row["NAME"].ToString();
                    gf1.TextAlign  = FineUIPro.TextAlign.Center;
                    GridBoundAdd(grid, drs, table, gf1);
                    gf.Columns.Add(gf1);
                }
                else
                {
                    GroupField gf2 = new GroupField();
                    gf2.HeaderText = row["NAME"].ToString();
                    gf2.TextAlign  = FineUIPro.TextAlign.Center;

                    FineUIPro.BoundField bfjs = new FineUIPro.BoundField();
                    bfjs.DataField  = row["CODE"].ToString() + "_JS";
                    bfjs.HeaderText = "入库数量";
                    bfjs.TextAlign  = FineUIPro.TextAlign.Right;
                    gf2.Columns.Add(bfjs);
                    FineUIPro.BoundField bfje = new FineUIPro.BoundField();
                    bfje.DataField  = row["CODE"].ToString() + "_JE";
                    bfje.HeaderText = "入库金额";
                    bfje.TextAlign  = FineUIPro.TextAlign.Right;
                    gf2.Columns.Add(bfje);
                    FineUIPro.BoundField bfxs = new FineUIPro.BoundField();
                    bfxs.DataField  = row["CODE"].ToString() + "_XS";
                    bfxs.HeaderText = "出库数量";
                    bfxs.TextAlign  = FineUIPro.TextAlign.Right;
                    gf2.Columns.Add(bfxs);
                    FineUIPro.BoundField bfxe = new FineUIPro.BoundField();
                    bfxe.DataField  = row["CODE"].ToString() + "_XE";
                    bfxe.HeaderText = "出库金额";
                    bfxe.TextAlign  = FineUIPro.TextAlign.Right;
                    gf2.Columns.Add(bfxe);
                    FineUIPro.BoundField bfcs = new FineUIPro.BoundField();
                    bfcs.DataField  = row["CODE"].ToString() + "_CS";
                    bfcs.HeaderText = "库存数量";
                    bfcs.TextAlign  = FineUIPro.TextAlign.Right;
                    gf2.Columns.Add(bfcs);
                    FineUIPro.BoundField bfce = new FineUIPro.BoundField();
                    bfce.DataField  = row["CODE"].ToString() + "_CE";
                    bfce.HeaderText = "库存数量";
                    bfce.TextAlign  = FineUIPro.TextAlign.Right;
                    gf2.Columns.Add(bfce);
                    gf.Columns.Add(gf2);

                    dtSource.Columns.Add(row["CODE"].ToString() + "_JS", Type.GetType("System.Decimal"));
                    dtSource.Columns.Add(row["CODE"].ToString() + "_JE", Type.GetType("System.Decimal"));
                    dtSource.Columns.Add(row["CODE"].ToString() + "_XS", Type.GetType("System.Decimal"));
                    dtSource.Columns.Add(row["CODE"].ToString() + "_XE", Type.GetType("System.Decimal"));
                    dtSource.Columns.Add(row["CODE"].ToString() + "_CS", Type.GetType("System.Decimal"));
                    dtSource.Columns.Add(row["CODE"].ToString() + "_CE", Type.GetType("System.Decimal"));
                }
            }
        }
Beispiel #20
0
        private void InsertGroupBand(GridColumn gridColumn, int i)
        {
            GroupHeaderBand ghBand = new GroupHeaderBand();

            ghBand.Height          = 25;
            ghBand.RepeatEveryPage = true;
            XRLabel lbl = new XRLabel();

            lbl.ExpressionBindings.Add(new ExpressionBinding("Text", gridColumn.Caption));
            lbl.Size      = new Size(300, 25);
            lbl.Location  = new Point(0 + i * 20, 0);
            lbl.BackColor = Color.Beige;
            ghBand.Controls.Add(lbl);
            GroupField gField;

            if (gridColumn.SortOrder == ColumnSortOrder.Ascending)
            {
                gField = new GroupField(gridColumn.FieldName, XRColumnSortOrder.Ascending);
            }
            else
            {
                gField = new GroupField(gridColumn.FieldName, XRColumnSortOrder.Descending);
            }
            ghBand.GroupFields.Add(gField);
            this.Bands.Add(ghBand);
        }
        public rp_personel_iptal_ozet(DateTime tarih1, DateTime tarih2)
        {
            InitializeComponent();
            lbl_tarih.Text = tarih1.Day + "." + tarih1.Month + "." + tarih1.Year + "-" + tarih2.Day + "." + tarih2.Month + "." + tarih2.Year;

            DataTable dt = SQL.get("SELECT * FROM(SELECT ad_soyad = k.ad + ' ' + k.soyad, tutar = (SELECT SUM(ak.miktar * u.fiyat) FROM adisyon_kalem ak INNER JOIN urunler u ON u.urun_id = ak.urun_id WHERE ak.silindi = 1 AND ak.durum_parametre_id != 51 AND ak.kaydeden_kullanici_id = k.kullanici_id AND ak.kayit_tarihi BETWEEN '" + tarih1.ToString("yyyy-MM-dd HH:mm:00.000") + "' AND DATEADD(DAY, 0, '" + tarih2.ToString("yyyy-MM-dd HH:mm:00.000") + "')) FROM kullanicilar k WHERE k.silindi = 0) tbl WHERE tbl.tutar != 0");

            this.DataSource = dt;

            XRBinding binding0 = new XRBinding("Text", this.DataSource, "ad_soyad", "");

            tc_urun.DataBindings.Add(binding0);
            XRBinding binding1 = new XRBinding("Text", this.DataSource, "tutar", "{0:n2}");

            tc_tutar.DataBindings.Add(binding1);

            XRBinding binding6 = new XRBinding("Text", this.DataSource, "tutar", "{0:c2}");

            tc_top_tutar.DataBindings.Add(binding6);
            XRSummary sum2 = new XRSummary(SummaryRunning.Page, SummaryFunc.Sum, "{0:c2}");

            tc_top_tutar.Summary = sum2;

            GroupField sortField = new GroupField("tutar");

            sortField.SortOrder = XRColumnSortOrder.Descending;
            this.Detail.SortFields.Add(sortField);
        }
Beispiel #22
0
        public void BindData()
        {
            GroupField grp = new GroupField("Masp", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending);

            grpSP.GroupFields.Add(grp);

            crTensp.DataBindings.Add(new XRBinding("Text", DataSource, "Tensp"));
            crMasp.DataBindings.Add(new XRBinding("Text", DataSource, "Masp"));
            crDvt.DataBindings.Add(new XRBinding("Text", DataSource, "Dvt"));
            crQuycach.DataBindings.Add(new XRBinding("Text", DataSource, "Quycach"));


            crNgayIn.DataBindings.Add(new XRBinding("Text", DataSource, "NgayPhieu"));

            //crGhichuCTG.DataBindings.Add(new XRBinding("Text", DataSource, "Ghichu"));

            crSTT.DataBindings.Add(new XRBinding("Text", DataSource, "STT"));
            crNgayct.DataBindings.Add(new XRBinding("Text", DataSource, "Ngayct", "{0:dd/MM/yyyy}"));
            crNgayPS.DataBindings.Add(new XRBinding("Text", DataSource, "Ngayps", "{0:dd/MM/yyyy}"));
            crSophieuN.DataBindings.Add(new XRBinding("Text", DataSource, "SophieuN"));
            crSophieuX.DataBindings.Add(new XRBinding("Text", DataSource, "SophieuX"));
            crDiengiai.DataBindings.Add(new XRBinding("Text", DataSource, "Diengiai"));

            crSLN.DataBindings.Add(new XRBinding("Text", DataSource, "SLNhap", "{0:n0}"));
            crSLX.DataBindings.Add(new XRBinding("Text", DataSource, "SLXuat", "{0:n0}"));
            crCK.DataBindings.Add(new XRBinding("Text", DataSource, "Cuoiky", "{0:n0}"));
        }
Beispiel #23
0
        public void BindData()
        {
            GroupField grp = new GroupField("Madt", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending);

            grpKH.GroupFields.Add(grp);

            //crNgayCT.DataBindings.Add(new XRBinding("Text", DataSource, "NgayPhieu"));
            xrTrangSo.DataBindings.Add(new XRBinding("Tag", DataSource, "Madt"));
            crSTT.DataBindings.Add(new XRBinding("Tag", DataSource, "Phieuid"));

            crDonvi.DataBindings.Add(new XRBinding("Text", DataSource, "Tenkh"));
            crDiachi.DataBindings.Add(new XRBinding("Text", DataSource, "Diachi"));
            crDienthoai.DataBindings.Add(new XRBinding("Text", DataSource, "Dienthoai"));
            crDaidien.DataBindings.Add(new XRBinding("Text", DataSource, "Daidien"));

            crDiengiai.DataBindings.Add(new XRBinding("Text", DataSource, "Diengiai"));
            crNgay.DataBindings.Add(new XRBinding("Text", DataSource, "Ngayct", "{0:dd/MM/yyyy}"));
            crSohoadon.DataBindings.Add(new XRBinding("Text", DataSource, "Soctgoc"));
            crSoPhieu.DataBindings.Add(new XRBinding("Text", DataSource, "Sophieu", "{0:n0}"));
            crSotienDH.DataBindings.Add(new XRBinding("Text", DataSource, "Sotien", "{0:n0}"));
            crNgaychono.DataBindings.Add(new XRBinding("Text", DataSource, "Nchono", "{0:n0}"));
            crNgayDH.DataBindings.Add(new XRBinding("Text", DataSource, "Ngaydh", "{0:dd/MM/yyyy}"));

            /*crSumTienDH.DataBindings.Add(new XRBinding("Text", DataSource, "Sotien", "{0:#,#}"));
             * crSumTienDH.Summary.Func = SummaryFunc.Sum;
             * crSumTienDH.Summary.FormatString = "{0:n0}";
             * crSumTienDH.Summary.Running = SummaryRunning.Group;
             */

            crSotienQH.DataBindings.Add(new XRBinding("Text", DataSource, "Dudau", "{0:n0}"));
            crSotienDatra.DataBindings.Add(new XRBinding("Text", DataSource, "Datra", "{0:n0}"));
            crSotienCantra.DataBindings.Add(new XRBinding("Text", DataSource, "Ducuoi", "{0:n0}"));
        }
Beispiel #24
0
        public void BindDatakm(DataTable da)
        {
            DataSource = da;

            Bands.Add(GroupHeader1);
            GroupField groupField1 = new GroupField("Mã hàng");

            GroupHeader1.GroupFields.Add(groupField1);


            xrTableCell1.DataBindings.Add("Text", DataSource, "Mã hàng");
            xrTableCell3.DataBindings.Add("Text", DataSource, "Tên hàng");

            xrTableCell4.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
            XRSummary summary = new XRSummary();

            summary.Running          = SummaryRunning.Group;
            summary.IgnoreNullValues = true;
            summary.FormatString     = "{0:n0}";
            xrTableCell4.Summary     = summary;

            xrTableCell5.DataBindings.Add("Text", DataSource, "Trọng lượng", "{0:n2}");
            XRSummary summary1 = new XRSummary();

            summary1.Running          = SummaryRunning.Group;
            summary1.IgnoreNullValues = true;
            summary1.FormatString     = "{0:n2}";
            xrTableCell5.Summary      = summary1;



            XRSummary summarytotal  = new XRSummary();
            XRSummary summarytotal1 = new XRSummary();
            XRSummary summarytotal3 = new XRSummary();
            XRSummary summarytotal4 = new XRSummary();
            XRSummary summarytotal5 = new XRSummary();
            XRSummary summarytotal6 = new XRSummary();
            XRSummary summarytotal7 = new XRSummary();
            XRSummary summarytotal8 = new XRSummary();


            summarytotal.Running          = SummaryRunning.Report;
            summarytotal.IgnoreNullValues = true;
            summarytotal.FormatString     = "{0:n0}";
            xrTableCell22.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
            xrTableCell22.Summary = summarytotal;

            summarytotal1.Running          = SummaryRunning.Report;
            summarytotal1.IgnoreNullValues = true;
            summarytotal1.FormatString     = "{0:n2}";
            xrTableCell23.DataBindings.Add("Text", DataSource, "Trọng lượng", "{0:n2}");
            xrTableCell23.Summary = summarytotal1;


            xrTableCell16.DataBindings.Add("Text", DataSource, "Ngày lập", "{0:dd-MM-yyyy}");
            xrTableCell11.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
            xrTableCell12.DataBindings.Add("Text", DataSource, "Trọng lượng", "{0:n2}");
            xrTableCell6.DataBindings.Add("Text", DataSource, "Phiếu");
            xrTableCell10.DataBindings.Add("Text", DataSource, "Tên khách");
        }
Beispiel #25
0
        void btn_del_Click(object sender, EventArgs e)
        {
            MapAttrs attrs = new MapAttrs();

            attrs.Retrieve(MapAttrAttr.GroupID, this.RefOID);
            foreach (MapAttr attr in attrs)
            {
                if (attr.HisEditType != EditType.Edit)
                {
                    continue;
                }
                if (attr.KeyOfEn == "FID")
                {
                    continue;
                }

                attr.Delete();
            }

            MapDtls dtls = new MapDtls();

            dtls.Retrieve(MapDtlAttr.GroupID, this.RefOID);
            foreach (MapDtl dtl in dtls)
            {
                dtl.Delete();
            }

            GroupField gf = new GroupField(this.RefOID);

            gf.Delete();
            this.WinClose();// ("删除成功。");
        }
Beispiel #26
0
 public ComposedGroupFieldInfo(GroupField groupField)
 {
     if (groupField == null)
     {
         throw new ArgumentNullException(nameof(groupField));
     }
     GroupField = groupField;
 }
Beispiel #27
0
        /// <summary>
        /// 删除之后.
        /// </summary>
        protected override void afterDelete()
        {
            GroupField gf = new GroupField();

            gf.Delete(GroupFieldAttr.CtrlID, this.MyPK);

            base.afterDelete();
        }
Beispiel #28
0
 /// <summary>
 /// Constructor for Label Field Definition
 /// </summary>
 /// <param name="frm">The main form</param>
 /// <param name="field">The label field</param>
 public GroupFieldDefinition(MainForm frm, GroupField field) : base(frm)
 {
     InitializeComponent();
     this.mode  = FormMode.Edit;
     this.field = field;
     this.page  = field.Page;
     LoadFormData();
 }
Beispiel #29
0
        public void BindData2(DataTable da)
        {
            GroupHeader1.Visible = true;
            xrTable10.Visible    = true;
            xrTable11.Visible    = true;
            xrTableCell18.Text   = "Ghi chú";

            DataSource = da;



            XRSummary summarytotal  = new XRSummary();
            XRSummary summarytotal1 = new XRSummary();
            XRSummary summarytotal3 = new XRSummary();


            Bands.Add(GroupHeader1);
            GroupField groupField = new GroupField("Nhóm");

            GroupHeader1.GroupFields.Add(groupField);
            xrTableCell2.DataBindings.Add("Text", DataSource, "Nhóm");

            xrTableCell4.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
            XRSummary summary = new XRSummary();

            summary.Running          = SummaryRunning.Group;
            summary.IgnoreNullValues = true;
            summary.FormatString     = "{0:n0}";
            xrTableCell4.Summary     = summary;

            xrTableCell5.DataBindings.Add("Text", DataSource, "Số lượng quy đổi", "{0:n2}");
            XRSummary summary1 = new XRSummary();

            summary1.Running          = SummaryRunning.Group;
            summary1.IgnoreNullValues = true;
            summary1.FormatString     = "{0:n2}";
            xrTableCell5.Summary      = summary1;



            summarytotal.Running          = SummaryRunning.Report;
            summarytotal.IgnoreNullValues = true;
            summarytotal.FormatString     = "{0:n0}";
            xrTableCell22.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
            xrTableCell22.Summary = summarytotal;

            summarytotal1.Running          = SummaryRunning.Report;
            summarytotal1.IgnoreNullValues = true;
            summarytotal1.FormatString     = "{0:n2}";
            xrTableCell23.DataBindings.Add("Text", DataSource, "Số lượng quy đổi", "{0:n2}");
            xrTableCell23.Summary = summarytotal1;


            xrTableCell16.DataBindings.Add("Text", DataSource, "Mã hàng");
            xrTableCell10.DataBindings.Add("Text", DataSource, "Tên hàng");
            xrTableCell11.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
            xrTableCell12.DataBindings.Add("Text", DataSource, "Số lượng quy đổi", "{0:n2}");
        }
Beispiel #30
0
        public XtraReport CreateDataGroupingReport()
        {
            // Create a report, and bind it to a data source.
            XtraReport   report = new XtraReport();
            nwindDataSet ds     = new nwindDataSet();

            new nwindDataSetTableAdapters.OrdersTableAdapter().Fill(ds.Orders);
            report.DataSource = ds;
            report.DataMember = "Orders";

            // Create a detail band and add it to the report.
            DetailBand detailBand = new DetailBand();

            detailBand.Height = 20;
            report.Bands.Add(detailBand);

            // Create a group header band and add it to the report.
            GroupHeaderBand ghBand = new GroupHeaderBand();

            ghBand.Height = 20;
            report.Bands.Add(ghBand);

            // Create a calculated field, and add it to the report's collection
            CalculatedField calcField = new CalculatedField(report.DataSource, report.DataMember);

            report.CalculatedFields.Add(calcField);

            // Define its name, field type and expression.
            // Note that numerous built-in date-time functions are supported.
            calcField.Name       = "dayOfWeek";
            calcField.FieldType  = FieldType.None;
            calcField.Expression = "GetDayOfWeek([OrderDate])";

            // Define the calculated field as
            // a grouping criteria for the group header band.
            GroupField groupField = new GroupField();

            groupField.FieldName = "dayOfWeek";
            ghBand.GroupFields.Add(groupField);

            // Create two data-bound labels, and add them to
            // the corresponding bands.
            XRLabel ghLabel = new XRLabel();

            ghLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:dddd}");
            ghLabel.BackColor = Color.Red;
            ghBand.Controls.Add(ghLabel);

            XRLabel detailLabel = new XRLabel();

            detailLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:MM/dd/yyyy}");
            detailLabel.ProcessDuplicatesTarget = ProcessDuplicatesTarget.Value;
            detailLabel.ProcessDuplicatesMode   = ProcessDuplicatesMode.Suppress;
            detailBand.Controls.Add(detailLabel);

            return(report);
        }
Beispiel #31
0
        public void BindData(DataTable da)
        {
            DataSource = da;

            Bands.Add(GroupHeader1);
            GroupField groupField = new GroupField("Đơn vị");

            GroupHeader1.GroupFields.Add(groupField);
            xrTableCell43.DataBindings.Add("Text", DataSource, "Đơn vị");

            XRSummary summarytotal  = new XRSummary();
            XRSummary summarytotal1 = new XRSummary();
            XRSummary summarytotal3 = new XRSummary();
            XRSummary summarytotal4 = new XRSummary();
            XRSummary summarytotal5 = new XRSummary();
            XRSummary summarytotal6 = new XRSummary();
            XRSummary summarytotal7 = new XRSummary();
            XRSummary summarytotal8 = new XRSummary();


            summarytotal.Running          = SummaryRunning.Report;
            summarytotal.IgnoreNullValues = true;
            summarytotal.FormatString     = "{0:n0}";
            xrTableCell32.DataBindings.Add("Text", DataSource, "Số quá hạn", "{0:n0}");
            xrTableCell32.Summary = summarytotal;

            /*summarytotal1.Running = SummaryRunning.Report;
             * summarytotal1.IgnoreNullValues = true;
             * summarytotal1.FormatString = "{0:n0}";
             * xrTableCell23.DataBindings.Add("Text", DataSource, "Có đầu kỳ", "{0:n0}");
             * xrTableCell23.Summary = summarytotal1;
             *
             * summarytotal3.Running = SummaryRunning.Report;
             * summarytotal3.IgnoreNullValues = true;
             * summarytotal3.FormatString = "{0:n0}";
             * xrTableCell24.DataBindings.Add("Text", DataSource, "Nợ phát sinh", "{0:n0}");
             * xrTableCell24.Summary = summarytotal3;
             *
             * summarytotal4.Running = SummaryRunning.Report;
             * summarytotal4.IgnoreNullValues = true;
             * summarytotal4.FormatString = "{0:n0}";
             * xrTableCell25.DataBindings.Add("Text", DataSource, "Có phát sinh", "{0:n0}");
             * xrTableCell25.Summary = summarytotal4;*/

            xrTableCell15.DataBindings.Add("Text", DataSource, "Phiếu");
            xrTableCell16.DataBindings.Add("Text", DataSource, "Hóa đơn");
            xrTableCell17.DataBindings.Add("Text", DataSource, "Hạn nợ");
            xrTableCell18.DataBindings.Add("Text", DataSource, "Số tiền nợ", "{0:0,0}");
            xrTableCell19.DataBindings.Add("Text", DataSource, "Ngày nợ", "{0:dd-MM-yyyy}");
            xrTableCell20.DataBindings.Add("Text", DataSource, "Phiếu trả");
            xrTableCell21.DataBindings.Add("Text", DataSource, "Số tiền trả", "{0:0,0}");
            xrTableCell22.DataBindings.Add("Text", DataSource, "Ngày trả", "{0:dd-MM-yyyy}");
            xrTableCell23.DataBindings.Add("Text", DataSource, "Số dư nợ", "{0:0,0}");
            xrTableCell31.DataBindings.Add("Text", DataSource, "Số quá hạn", "{0:0,0}");
            xrTableCell34.DataBindings.Add("Text", DataSource, "Số ngày", "{0:n0}");
        }
Beispiel #32
0
        protected override bool beforeUpdate()
        {
            MapDtl dtl = new MapDtl(this.No);

            //启用审核
            dtl.IsEnablePass = this.IsEnablePass;
            //超链接
            dtl.IsEnableLink = this.IsEnableLink;
            dtl.LinkLabel    = this.LinkLabel;
            dtl.LinkUrl      = this.LinkUrl;
            dtl.LinkTarget   = this.LinkTarget;
            dtl.Update();


            //获得事件实体.
            var febd = BP.Sys.Glo.GetFormDtlEventBaseByEnName(this.No);

            if (febd == null)
            {
                this.FEBD = "";
            }
            else
            {
                this.FEBD = febd.ToString();
            }


            #region 检查填充的SQL是否符合要求.
            #endregion

            //更新分组标签.  @fanleiwei. 代码有变化.
            BP.Sys.GroupField gf = new GroupField();
            int i = gf.Retrieve(GroupFieldAttr.CtrlType, "Dtl", GroupFieldAttr.CtrlID, this.No);
            if (i == 0)
            {
                gf.CtrlID   = this.No;
                gf.CtrlType = "Dtl";
                gf.FrmID    = this.FK_MapData;
                gf.Insert();
            }

            if (i > 1)
            {
                gf.Delete();
                i = gf.Retrieve(GroupFieldAttr.CtrlType, "Dtl", GroupFieldAttr.CtrlID, this.No);
            }

            if (i == 1 && gf.Lab.Equals(this.Name) == false)
            {
                gf.Lab = this.Name;
                gf.Update();
            }

            return(base.beforeUpdate());
        }
Beispiel #33
0
        public XtraReport CreateDataGroupingReport()
        {
            // Create a report, and bind it to a data source.
            XtraReport report = new XtraReport();
            DataSet1 ds = new DataSet1();
            new DataSet1TableAdapters.OrdersTableAdapter().Fill(ds.Orders);
            report.DataSource = ds;
            report.DataMember = "Orders";

            // Create a detail band and add it to the report.
            DetailBand detailBand = new DetailBand();
            detailBand.Height = 20;
            report.Bands.Add(detailBand);

            // Create a group header band and add it to the report.
            GroupHeaderBand ghBand = new GroupHeaderBand();
            ghBand.Height = 20;
            report.Bands.Add(ghBand);

            // Create a calculated field, and add it to the report's collection
            CalculatedField calcField = new CalculatedField(report.DataSource, report.DataMember);
            report.CalculatedFields.Add(calcField);

            // Define its name, field type and expression.
            // Note that numerous built-in date-time functions are supported.
            calcField.Name = "dayOfWeek";
            calcField.FieldType = FieldType.None;
            calcField.Expression = "GetDayOfWeek([OrderDate])";

            // Define the calculated field as 
            // a grouping criteria for the group header band.
            GroupField groupField = new GroupField();
            groupField.FieldName = "dayOfWeek";
            ghBand.GroupFields.Add(groupField);

            // Create two data-bound labels, and add them to 
            // the corresponding bands.
            XRLabel ghLabel = new XRLabel();
            ghLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:dddd}");
            ghLabel.BackColor = Color.Red;
            ghBand.Controls.Add(ghLabel);

            XRLabel detailLabel = new XRLabel();
            detailLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:MM/dd/yyyy}");
            detailLabel.ProcessDuplicates = ValueSuppressType.Suppress;
            detailBand.Controls.Add(detailLabel);

            return report;
        }
        private void IntGROUP()
        {
            GroupField _GroupFieldLoaiTaiSan = new GroupField("loaitaisan");
            GroupHeader_LoaiTaiSan.GroupFields.Add(_GroupFieldLoaiTaiSan);

            xrTableCell_GROUP_Name.DataBindings.Add("Text", this.DataSource, "tenloaitaisan");

            xrTableCell_GROUP_NguyenGia.DataBindings.Add("Text", this.DataSource, "dongia");
            xrTableCell_GROUP_NguyenGia.Summary.FormatString = "{0:### ### ### ### ### ###}";
            xrTableCell_GROUP_NguyenGia.Summary.IgnoreNullValues = true;
            xrTableCell_GROUP_NguyenGia.Summary.Func = SummaryFunc.Sum;
            xrTableCell_GROUP_NguyenGia.Summary.Running = SummaryRunning.Group;
            xrTableCell_GROUP_NguyenGia.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
            xrTableCell_GROUP_NguyenGia.XlsxFormatString = "### ### ### ###";

            xrTableCell_GROUP_HaoMonDauKy.DataBindings.Add("Text", this.DataSource, "haomonnamtruocchuyensang");
            xrTableCell_GROUP_HaoMonDauKy.Summary.FormatString = "{0:### ### ### ### ### ###}";
            xrTableCell_GROUP_HaoMonDauKy.Summary.IgnoreNullValues = true;
            xrTableCell_GROUP_HaoMonDauKy.Summary.Func = SummaryFunc.Sum;
            xrTableCell_GROUP_HaoMonDauKy.Summary.Running = SummaryRunning.Group;
            xrTableCell_GROUP_HaoMonDauKy.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
            xrTableCell_GROUP_HaoMonDauKy.XlsxFormatString = "### ### ### ###";

            xrTableCell_GROUP_HaoMonTrongKy.DataBindings.Add("Text", this.DataSource, "haomon_1nam");
            xrTableCell_GROUP_HaoMonTrongKy.Summary.FormatString = "{0:### ### ### ### ### ###}";
            xrTableCell_GROUP_HaoMonTrongKy.Summary.IgnoreNullValues = true;
            xrTableCell_GROUP_HaoMonTrongKy.Summary.Func = SummaryFunc.Sum;
            xrTableCell_GROUP_HaoMonTrongKy.Summary.Running = SummaryRunning.Group;
            xrTableCell_GROUP_HaoMonTrongKy.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
            xrTableCell_GROUP_HaoMonTrongKy.XlsxFormatString = "### ### ### ###";

            xrTableCell_GROUP_HaoMonLuyKe.DataBindings.Add("Text", this.DataSource, "haomonluyke");
            xrTableCell_GROUP_HaoMonLuyKe.Summary.FormatString = "{0:### ### ### ### ### ###}";
            xrTableCell_GROUP_HaoMonLuyKe.Summary.IgnoreNullValues = true;
            xrTableCell_GROUP_HaoMonLuyKe.Summary.Func = SummaryFunc.Sum;
            xrTableCell_GROUP_HaoMonLuyKe.Summary.Running = SummaryRunning.Group;
            xrTableCell_GROUP_HaoMonLuyKe.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
            xrTableCell_GROUP_HaoMonLuyKe.XlsxFormatString = "### ### ### ###";

            xrTableCell_GROUP_GiaTriConLai.DataBindings.Add("Text", this.DataSource, "giatriconlai_final");
            xrTableCell_GROUP_GiaTriConLai.Summary.FormatString = "{0:### ### ### ### ### ###}";
            xrTableCell_GROUP_GiaTriConLai.Summary.IgnoreNullValues = true;
            xrTableCell_GROUP_GiaTriConLai.Summary.Func = SummaryFunc.Sum;
            xrTableCell_GROUP_GiaTriConLai.Summary.Running = SummaryRunning.Group;
            xrTableCell_GROUP_GiaTriConLai.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
            xrTableCell_GROUP_GiaTriConLai.XlsxFormatString = "### ### ### ###";
        }
Beispiel #35
0
        private List<int> GetGroupByField(GroupField field)
        {
            List<int> result;

            switch (field)
            {
                case GroupField.Cost:
                    result = _products.Select(x => x.Cost).ToList();
                    break;
                case GroupField.Revenue:
                    result = _products.Select(x => x.Revenue).ToList();
                    break;
                default:
                    result = _products.Select(x => x.Cost).ToList();
                    break;
            }

            return result;
        }
Beispiel #36
0
        public CGSHReport(string strCGSHID)
        {
            InitializeComponent();
            OracleConnection con = new OracleConnection(FrmLogin.strDataCent);
            string sql = "select a.cgshid, a.ztmc, a.cgshdh, a.ysdh, a.sszpz, a.sszsl, a.sszmy, a.sszsy, a.shrxm, a.czyxm, a.zdrq, a.gysmc, "
                       + "a.statusmc, b.pm, b.spbh, b.dj, b.bz, b.sssl, b.ssmy, b.sssy from view_jt_g_cgsh a "
                       + "left join view_jt_g_cgshmx b on a.cgshid = b.cgshid where a.cgshid in (" + strCGSHID + ")";
            OracleDataAdapter Ada = new OracleDataAdapter(sql, con);
            DataSet ds = new DataSet();
            Ada.Fill(ds);

            this.DataAdapter = Ada;
            this.DataSource = ds;

            GroupField groupField = new GroupField("CGSHID");
            GroupHeader1.GroupFields.Add(groupField);

            this.xrTableCell1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "spbh")});

            this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "pm")});

            this.xrTableCell2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "dj", "{0:c2}")});

            this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "sssl")});

            this.xrTableCell3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "ssmy", "{0:c2}")});

            this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "sssy", "{0:c2}")});

            this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "bz")});

            this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "ztmc",  "{0} �ջ���")});

            this.xrLabel4.Text = FrmLogin.getUserName;

            this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "cgshdh", "���ţ�{0}")});

            this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "ysdh", "ԭʼ���ţ�{0}")});

            this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "sszpz", "ʵ��Ʒ�֣�{0}")});

            this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "sszsl", "ʵ��������{0}")});

            this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "sszmy", "ʵ������{0:c2}")});

            this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "sszsy", "ʵ��ʵ��{0:c2}")});

            this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "shrxm", "����ˣ�{0}")});

            this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "czyxm", "����Ա��{0}")});

            this.xrLabel13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "zdrq", "�Ƶ����ڣ�{0}")});

            this.xrLabel14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "gysmc", "��Ӧ�̣�{0}")});

            this.xrLabel15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "statusmc", "״̬��{0}")});
        }
Beispiel #37
0
        public XSHZDReport(string strXSHZDID, bool fgBranch)
        {
            string sql = "";
            InitializeComponent();
            if (fgBranch)
            {
                sql = "select a.xshzdid, a.xshzdh, a.ywbmmc, a.fxflsl1, a.fxflje1, a.fxflsl2, a.fxflje2, a.fxflsl3, a.fxflje3, "
                    + "a.fxflsl4, a.fxflje4, a.fxflsl5, a.fxflje5, a.fxflsl6, a.fxflje6, a.fxflsl7, a.fxflje7, a.fxflsl8, a.fxflje8, "
                    + "a.fxflsl9, a.fxflje9, a.fxflsl10, a.fxflje10, a.hjsl, a.hjje, a.xszksl, a.xszkje, a.jshj,"
                    + " a.czyxm, a.zdrq from VIEW_JC_C_XSHZD a where a.xshzdid in (" + strXSHZDID + ")";
            }
            else
            {
                sql = "select a.xshzdid, a.xshzdh, a.ywbmmc, a.fxflsl1, a.fxflje1, a.fxflsl2, a.fxflje2, a.fxflsl3, a.fxflje3, "
                    + "a.fxflsl4, a.fxflje4, a.fxflsl5, a.fxflje5, a.fxflsl6, a.fxflje6, a.fxflsl7, a.fxflje7, a.fxflsl8, a.fxflje8, "
                    + "a.fxflsl9, a.fxflje9, a.fxflsl10, a.fxflje10, a.hjsl, a.hjje, a.xszksl, a.xszkje, a.jshj,"
                    + " a.czyxm, a.zdrq from VIEW_JT_C_XSHZD a where a.xshzdid in (" + strXSHZDID + ")";
            }

            OracleConnection con = new OracleConnection(FrmLogin.strDataCent);
            OracleDataAdapter Ada = new OracleDataAdapter(sql, con);
            DataSet ds = new DataSet();
            Ada.Fill(ds);

            this.DataAdapter = Ada;
            this.DataSource = ds;

            GroupField groupField = new GroupField("XSHZDID");
            GroupHeader1.GroupFields.Add(groupField);

            xrTableCell1.Text = FrmLogin.getZTMC;

            xrTableCell3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "ywbmmc", "���ţ�{0}")});

            xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "zdrq", "ʱ�䣺{0}")});

            xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xshzdh")});

            xrTableCell63.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "czyxm", "�Ƶ��ˣ�{0}")});

            xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl1")});

            xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje1", "{0:c2}")});

            xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl2")});

            xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje2", "{0:c2}")});

            xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl3")});

            xrTableCell20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje3", "{0:c2}")});

            xrTableCell23.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl4")});

            xrTableCell24.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje4", "{0:c2}")});

            xrTableCell27.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl5")});

            xrTableCell28.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje5", "{0:c2}")});

            xrTableCell31.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl6")});

            xrTableCell32.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje6", "{0:c2}")});

            xrTableCell35.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl7")});

            xrTableCell36.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje7", "{0:c2}")});

            xrTableCell39.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl8")});

            xrTableCell40.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje8", "{0:c2}")});

            xrTableCell43.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl9")});

            xrTableCell44.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje9", "{0:c2}")});

            xrTableCell47.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflsl10")});

            xrTableCell48.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fxflje10", "{0:c2}")});

            xrTableCell51.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "hjsl")});

            xrTableCell52.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "hjje", "{0:c2}")});

            xrTableCell55.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xszksl")});

            xrTableCell56.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xszkje", "{0:c2}")});

            xrTableCell60.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jshj", "{0:c2}")});
        }
Beispiel #38
0
        public XSDReport(string strXSDID)
        {
            InitializeComponent();
            OracleConnection con = new OracleConnection(FrmLogin.strDataCent);
            string sql = "select a.xsdid, a.ztmc, a.xsdh, a.zdrq, a.jsfsmc, a.wlbmmc, a.xsbmmc, a.khmc, a.fhdz, a.czyxm, a.czrq, a.bz, a.pzs, "
                       + "a.xssl as xszsl, a.xssy as xszsy, a.xsmy as xszmy, b.pm, b.spbh, b.dj, b.xj, b.xz, b.xssl, b.xsmy, b.xssy from view_jt_x_xsd a "
                       + "left join view_jt_x_xsdmx b on a.xsdid = b.xsdid where a.xsdid in (" + strXSDID + ")";
            OracleDataAdapter Ada = new OracleDataAdapter(sql, con);
            DataSet ds = new DataSet();
            Ada.Fill(ds);

            this.DataAdapter = Ada;
            this.DataSource = ds;

            GroupField groupField = new GroupField("XSDID");
            GroupHeader1.GroupFields.Add(groupField);

            this.xrLabel4.Text = FrmLogin.getUserName;

            this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "ztmc",  "{0} ���۵�")});

            this.xrTableCell1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xsdh", "���ţ�{0}")});

            this.xrTableCell2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "zdrq", "�������ڣ�{0}")});

            this.xrTableCell3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jsfsmc", "���㷽ʽ��{0}")});

            this.xrTableCell4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "wlbmmc", "�������ţ�{0}")});

            this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xsbmmc", "���۲��ţ�{0}")});

            this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "khmc", "�ͻ����ƣ�{0}")});

            this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "fhdz", "������ַ��{0}")});

            this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "czyxm", "����Ա��{0}")});

            this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "czrq", "�������ڣ�{0}")});

            this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "bz", "��ע��{0}")});

            this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "pzs", "����Ʒ�֣�{0}")});

            this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xszsl", "����������{0}")});

            this.xrTableCell13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xszsy", "����ʵ��{0:c2}")});

            this.xrTableCell14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xszmy", "��������{0:c2}")});

            this.xrTableCell23.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "spbh")});

            this.xrTableCell24.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "pm")});

            this.xrTableCell25.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "dj", "{0:c2}")});

            this.xrTableCell26.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xj", "{0:c2}")});

            this.xrTableCell27.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xz")});

            this.xrTableCell28.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xssl")});

            this.xrTableCell29.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xsmy", "{0:c2}")});

            this.xrTableCell30.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "xssy", "{0:c2}")});
        }
 private void InsertGroupBand(GridColumn gridColumn, int i)
 {
     GroupHeaderBand gb = new GroupHeaderBand();
     gb.Height = 25;
     gb.RepeatEveryPage = true;
     XRLabel l = new XRLabel();
     l.DataBindings.Add("Text", this.DataSource, gridColumn.FieldName);
     l.Size = new Size(300, 25);
     l.Location = new Point(0 + i * 20, 0);
     l.BackColor = Color.Beige;
     gb.Controls.Add(l);
     GroupField gf;
     if (gridColumn.SortOrder == ColumnSortOrder.Ascending)
     {
         gf = new GroupField(gridColumn.FieldName, XRColumnSortOrder.Ascending);
         m_count_group_col += 1;
     }
     else
     {
         gf = new GroupField(gridColumn.FieldName, XRColumnSortOrder.Descending);
         m_count_group_col += 1;
     }
     l.BackColor = Color.White;
     l.Font = new Font(l.Font.FontFamily, 12, FontStyle.Bold);
     gb.GroupFields.Add(gf);
     gb.StylePriority.UseBackColor = true;
     gb.BackColor = Color.Maroon;
     this.Bands.Add(gb);
 }
Beispiel #40
0
        public JTDReport(string strJTDID)
        {
            InitializeComponent();
            OracleConnection con = new OracleConnection(FrmLogin.strDataCent);
            string sql = "select a.jtdid, a.ztmc, a.jtdh, a.zdrq, a.ywyxm, a.statusmc, a.czyxm, a.czrq, a.gysmc, a.bz, a.jtpzs, a.jtzsl, a.jtzmy, "
                       + "a.jtbmmc, b.pm, b.spbh, b.dj, b.bz, b.jtsl, b.jtmy from view_jt_g_jtd a "
                       + "left join view_jt_g_jtdmx b on a.jtdid = b.jtdid where a.jtdid in (" + strJTDID + ")";
            OracleDataAdapter Ada = new OracleDataAdapter(sql, con);
            DataSet ds = new DataSet();
            Ada.Fill(ds);

            this.DataAdapter = Ada;
            this.DataSource = ds;

            GroupField groupField = new GroupField("JTDID");
            GroupHeader1.GroupFields.Add(groupField);

            this.xrLabel4.Text = FrmLogin.getUserName;

            this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "ztmc",  "{0} ���˵�")});

            this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "dj", "{0:c2}")});

            this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jtmy", "{0:c2}")});

            this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "spbh")});

            this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "pm")});

            this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jtsl")});

            this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "bz")});

            this.xrTableCell13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jtdh", "���ţ�{0}")});

            this.xrTableCell14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "zdrq", "�������ڣ�{0}")});

            this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "ywyxm", "ҵ��Ա��{0}")});

            this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "statusmc", "״̬��{0}")});

            this.xrTableCell21.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "czyxm", "����Ա��{0}")});

            this.xrTableCell22.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "czrq", "�������ڣ�{0}")});

            this.xrTableCell23.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "gysmc", "��Ӧ�̣�{0}")});

            this.xrTableCell24.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "bz", "��ע��{0}")});

            this.xrTableCell17.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jtpzs", "����Ʒ�֣�{0}")});

            this.xrTableCell18.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jtzsl", "����������{0}")});

            this.xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jtzmy", "��������{0:c2}")});

            this.xrTableCell20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
            new DevExpress.XtraReports.UI.XRBinding("Text", null, "jtbmmc", "���˲��ţ�{0}")});
        }
        public void InitTables(List<SHARED.Libraries.ReportHelper.structColumn> ListColumns, GridView _GridView)
        {
            int colCount = ListColumns.Count;
            int pageWidth = (PageWidth - (Margins.Left + Margins.Right));
            int colWidth = pageWidth / colCount;

            if (NumberOfFieldGroup > 0)
            {
                colWidth = (pageWidth - GroupColumnLength) / colCount;

                for (int i = _GridView.GroupCount - 1; i >= 0; i--)
                {
                    XRTable XRTable_GroupHeaderBand = new XRTable();
                    XRTable_GroupHeaderBand.Styles.Style = this.myRowStyle;
                    XRTable_GroupHeaderBand.LocationF = new DevExpress.Utils.PointFloat(0 + i * WidthAdd, 0);

                    XRTableRow XRTableRow_GroupHeaderBand = new XRTableRow();

                    XRTableCell XRTableCell_GroupText = new XRTableCell();
                    if (Object.Equals(_GridView.GroupedColumns[i].ColumnType, typeof(Int32)))
                    {
                        XRTableCell_GroupText.DataBindings.Add("Text", this.DataSource, _GridView.GroupedColumns[i].Name + "_" + _GridView.GroupedColumns[i].FieldName + strTag);
                    }
                    else
                    {
                        XRTableCell_GroupText.DataBindings.Add("Text", this.DataSource, _GridView.GroupedColumns[i].Name + "_" + _GridView.GroupedColumns[i].FieldName);
                    }
                    XRTableCell_GroupText.Width = GroupColumnLength - i * WidthAdd;

                    XRTableRow_GroupHeaderBand.Cells.Add(XRTableCell_GroupText);

                    for (int j = 0; j < colCount; j++)
                    {
                        XRTableCell XRTableCell_SumColumn = new XRTableCell();
                        XRTableCell_SumColumn.Width = (int)colWidth;
                        if (ListColumns[j].IsNumber)
                        {
                            XRTableCell_SumColumn.DataBindings.Add("Text", this.DataSource, ListColumns[j].FieldName);
                            XRTableCell_SumColumn.Summary.IgnoreNullValues = true;
                            XRTableCell_SumColumn.Summary.Func = SummaryFunc.Sum;
                            XRTableCell_SumColumn.Summary.Running = SummaryRunning.Group;
                            XRTableCell_SumColumn.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
                        }
                        else
                        {
                            XRTableCell_SumColumn.Text = "";
                        }
                        XRTableRow_GroupHeaderBand.Cells.Add(XRTableCell_SumColumn);
                    }

                    XRTable_GroupHeaderBand.Rows.Add(XRTableRow_GroupHeaderBand);
                    XRTable_GroupHeaderBand.Width = pageWidth - (i * WidthAdd);

                    GroupHeaderBand _GroupHeaderBand = new GroupHeaderBand();
                    _GroupHeaderBand.Controls.Add(XRTable_GroupHeaderBand);
                    _GroupHeaderBand.Height = XRTable_GroupHeaderBand.Height;
                    GroupField _GroupField = new GroupField(_GridView.GroupedColumns[i].Name + "_" + _GridView.GroupedColumns[i].FieldName);
                    _GroupHeaderBand.GroupFields.Add(_GroupField);
                    this.Bands.Add(_GroupHeaderBand);
                }
            }

            XRTable XRTable_PageHeader = null;
            if (NumberOfFieldGroup > 0)
            {
                XRTable_PageHeader = SHARED.Libraries.ReportHelper.CreatePageHeaderTable(ListColumns, pageWidth, colWidth, true, GroupColumnLength);
            }
            else
            {
                XRTable_PageHeader = SHARED.Libraries.ReportHelper.CreatePageHeaderTable(ListColumns, pageWidth, colWidth, false, 0);
            }
            if (!Object.Equals(XRTable_PageHeader, null))
            {
                XRTable_PageHeader.Styles.Style = this.myColumnStyle;
                Bands[BandKind.PageHeader].Controls.Add(XRTable_PageHeader);
            }

            XRTable XRTable_Detail = new XRTable();
            XRTableRow XRTableRow_Detail = new XRTableRow();
            for (int i = 0; i < colCount; i++)
            {
                XRTableCell XRTableCell_Cell = new XRTableCell();
                XRTableCell_Cell.Width = (int)colWidth;
                XRTableCell_Cell.DataBindings.Add("Text", null, ListColumns[i].FieldName);
                if (ListColumns[i].IsNumber)
                    XRTableCell_Cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
                XRTableRow_Detail.Cells.Add(XRTableCell_Cell);
            }
            XRTable_Detail.Rows.Add(XRTableRow_Detail);
            if (NumberOfFieldGroup > 0)
                XRTable_Detail.LocationF = new DevExpress.Utils.PointFloat((float)(GroupColumnLength), 0F);
            XRTable_Detail.Width = pageWidth - GroupColumnLength;
            XRTable_Detail.Name = "XRTableRow_Detail";
            XRTable_Detail.Styles.Style = this.myRowStyle;
            Bands[BandKind.Detail].Controls.Add(XRTable_Detail);

            XRTable XRTable_LastSum = null;
            if (NumberOfFieldGroup > 0)
            {
                XRTable_LastSum = SHARED.Libraries.ReportHelper.CreateLastSUMTable(this, ListColumns, pageWidth, colWidth, true, GroupColumnLength);
            }
            else
            {
                XRTable_LastSum = SHARED.Libraries.ReportHelper.CreateLastSUMTable(this, ListColumns, pageWidth, colWidth, false, 0);
            }
            if (!Object.Equals(XRTable_LastSum, null))
            {
                XRTable_LastSum.Styles.Style = this.myRowStyle;
                XRTable_LastSum.Location = new Point(0, 0);
                XRTable_LastSum.Width = pageWidth;
                Bands[BandKind.ReportFooter].Controls.Add(XRTable_LastSum);
            }
        }
Beispiel #42
0
 void InitGroupHeaders(ASPxGridView aspxGridView1)
 {
     ReadOnlyCollection<GridViewDataColumn> groupedColumns = aspxGridView1.GetGroupedColumns();
     for (int i = groupedColumns.Count - 1; i >= 0; i--)
     {
         {
             GridViewDataColumn groupedColumn = groupedColumns[i];
             GroupHeaderBand gb = new GroupHeaderBand();
             gb.Height = bandHeight;
             XRLabel l = new XRLabel();
             l.Text = groupedColumn.FieldName + ": [" + groupedColumn.FieldName + "]";
             l.LocationF = new PointF(initialGroupOffset + i * 10, 0);
             l.BackColor = Color.Beige;
             l.SizeF = new SizeF((report.PageWidth - (report.Margins.Left + report.Margins.Right)) - (initialGroupOffset + i * subGroupOffset), bandHeight);
             gb.Controls.Add(l);
             gb.RepeatEveryPage = shouldRepeatGroupHeadersOnEveryPage;
             GroupField gf = new GroupField(groupedColumn.FieldName, groupedColumn.SortOrder == ColumnSortOrder.Ascending ? XRColumnSortOrder.Ascending : XRColumnSortOrder.Descending);
             gb.GroupFields.Add(gf);
             report.Bands.Add(gb);
         }
     }
 }
 public ComposedGroupFieldInfo(GroupField groupField)
 {
     if (groupField == null) throw new ArgumentNullException(nameof(groupField));
     GroupField = groupField;
 }