using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using DevExpress.XtraReports.UI;

using System.Data;

         public void LoadData()

         {

             DataTable mfdt = DS.Tables["主表"];

             for (int i = ;i< mfdt.Columns.Count; i++)

             {

                 string Columnname = mfdt.Columns[i].ColumnName;

                 string ColVale = mfdt.Rows[][Columnname].ToString();

                 SetLable(Columnname, ColVale, xtraReport, "");

                 SetLable(Columnname, ColVale, xtraReport, "");

                 SetLable(Columnname, ColVale, xtraReport, "");

                 SetLable(Columnname, ColVale, xtraReport, "");

                 SetBarCode(Columnname, ColVale, xtraReport, "");

                 SetBarCode(Columnname, ColVale, xtraReport, "");

                 SetBarCode(Columnname, ColVale, xtraReport, "");

                 SetBarCode(Columnname, ColVale, xtraReport, "");

             }

             DetailBand trb = xtraReport.FindControl("detailBand1", true) as DetailBand;

             XRTable xbtb = trb.FindControl("table1", true) as XRTable;

             XRTableRow tableRow1 = xbtb.FindControl("tableRow1", true) as XRTableRow;

             XRTableCell tableCell1 = xbtb.FindControl("tableCell1", true) as XRTableCell;

             XRTableCell tableCell2 = xbtb.FindControl("tableCell2", true) as XRTableCell;

             XRTableCell tableCell3 = xbtb.FindControl("tableCell3", true) as XRTableCell;

//明细表
xtra.DataSource = ds.Tables[1];
tableCell1.DataBindings.Add("Text", ds.Tables[1], "TF_POS.OS_NO");
tableCell2.DataBindings.Add("Text", ds.Tables[1], "TF_POS.ITEM");
tableCell3.DataBindings.Add("Text", ds.Tables[1], "TF_POS.PRD_NO");

         }

         /// <suary>

         /// 设置对象Text

         /// </summary>

         /// <param name="col">字段</param>

         /// <param name="colvale">字段值</param>

         /// <param name="xtra">报表对象</param>

         public void SetLable(string col, string colvale, XtraReport xtra, string inx)

         {

             try

             {

                 XRLabel TxtColumnName1 = xtra.FindControl("txt" + col + inx, true) as XRLabel;

                 TxtColumnName1.Text = colvale;

             }

             catch (Exception)

             {

             }

         }

         /// <summary>

         /// 设置对象Text

         /// </summary>

         /// <param name="col">字段</param>

         /// <param name="colvale">字段值</param>

         /// <param name="xtra">报表对象</param>

         public void SetBarCode(string col, string colvale, XtraReport xtra, string inx)

         {

             try

             {

                 XRBarCode xrbar = xtra.FindControl("bar" + col + inx, true) as XRBarCode;

                 xrbar.AutoModule = true;

                 //xrbar.Dpi = 254F; //xrbar.Location = rpb.pint.IsEmpty ? new Point(0, 0) : rpb.pint;

                 //xrbar.Module = 5.08F;

                 //xrbar.Size = rpb.size.IsEmpty ? new Size(this.PageWidth - this.Margins.Left - this.Margins.Right, 150) : rpb.size;

                 xrbar.Text = colvale;

                 xrbar.ShowText = true;

             }

             catch (Exception)

             {

             }

         }