/// <summary> /// 初始化窗体 /// </summary> protected override void InitializeForm() { _BLL = new bllAR();// 业务逻辑层实例 _SummaryView = new DevGridView(gvSummary); _ActiveEditor = txtReceivedDate; _DetailGroupControl = panel1; base.InitializeForm(); //这行代码放到初始化变量后最好 frmGridCustomize.RegisterGrid(gvSummary); DevStyle.SetGridControlLayout(gcSummary, false); //表格设置 DevStyle.SetGridControlLayout(gcDetail, true); //表格设置 DevStyle.SetSummaryGridViewLayout(gvSummary); DevStyle.SetDetailGridViewLayout(gvDetail); BindingSummaryNavigator(controlNavigatorSummary, gcSummary); //Summary导航条. BindingSummarySearchPanel(btnQuery, btnEmpty, gcFindGroup); gcDetail.EmbeddedNavigator.ButtonClick += new NavigatorButtonClickEventHandler(this.OnEmbeddedNavigatorButtonClick); //表格按钮事件 txt_DocDateTo.DateTime = DateTime.Today; //查询条件截止日期 DataBinder.BindingLookupEditDataSource(txtCreatedBy, DataDictCache.Cache.User, TUser.UserName, TUser.Account); DataBinder.BindingLookupEditDataSource(txtChequeBank, DataDictCache.Cache.Bank, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); DataBinder.BindingLookupEditDataSource(txtAppUser, DataDictCache.Cache.User, TUser.UserName, TUser.Account); DataBinder.BindingLookupEditDataSource((colD_Currency.ColumnEdit as RepositoryItemLookUpEdit), DataDictCache.Cache.Currency, tb_Currency.CurrencyName, tb_Currency.Currency); (colD_InvoiceNo.ColumnEdit as RepositoryItemButtonEdit).ButtonClick += new ButtonPressedEventHandler(OnInvoiceNo_ButtonClick); (colD_InvoiceNo.ColumnEdit as RepositoryItemButtonEdit).Validating += new CancelEventHandler(OnInvoiceNo_Validating); _BLL.GetBusinessByKey("-", true); //加载一个空的业务对象. ShowSummaryPage(true); //一切初始化完毕后显示SummaryPage }
private void InitializeReport_Normal() { //打印主从表数据 string file = Application.StartupPath + @"\Reports\rptAR_Normal.frx"; rptARNormal.Load(file);//加载报表模板文件 DataSet ds = new bllAR().GetReportData(txtNoFrom.Text, txtNoTo.Text, txtDateFrom.DateTime, txtDateTo.DateTime); if (ds.Tables[0].Rows.Count == 0) { throw new Exception("没有查询到报表数据!"); } ds.Tables[0].TableName = "M"; //换个短的别名 ds.Tables[1].TableName = "D"; //换个短的别名 rptARNormal.RegisterData(ds.Tables[0], "M"); //注册数据源,主表 rptARNormal.RegisterData(ds.Tables[1], "D"); //注册数据源,从表 //给DataBand(主表数据)绑定数据源 DataBand masterBand = rptARNormal.FindObject("Data1") as DataBand; masterBand.DataSource = rptARNormal.GetDataSource("M"); //主表 masterBand.BeforePrint += new EventHandler(band_BeforePrint); //自定义处理 //给DataBand(明细数据)绑定数据源 DataBand detailBand = rptARNormal.FindObject("Data2") as DataBand; detailBand.DataSource = rptARNormal.GetDataSource("D"); //明细表 //重要!!给明细表设置主外键关系! detailBand.Relation = new Relation(); detailBand.Relation.ParentColumns = new string[] { tb_AR.ARNO }; detailBand.Relation.ParentDataSource = rptARNormal.GetDataSource("M"); //主表 detailBand.Relation.ChildColumns = new string[] { tb_AR.ARNO }; detailBand.Relation.ChildDataSource = rptARNormal.GetDataSource("D"); //明细表 (rptARNormal.FindObject("Text52") as RichObject).Text = Loginer.CurrentUser.AccountName; }
private void InitializeReport_Checklist() { //打印单表数据 string file = Application.StartupPath + @"\Reports\rptAR_Checklist.frx"; rptAR_Checklist.Load(file); //加载报表模板文件 DataSet ds = new bllAR().GetReportData_Checklist(txtNoFrom.Text, txtNoTo.Text, txtDateFrom.DateTime, txtDateTo.DateTime); //取报表数据 if (ds.Tables[0].Rows.Count == 0) { throw new Exception("没有查询到报表数据!"); } rptAR_Checklist.RegisterData(ds.Tables[0], "D"); //注册数据源,别名为:D //给DataBand(明细数据)绑定数据源 DataBand band = rptAR_Checklist.FindObject("Data1") as DataBand; DataSourceBase dataSource = rptAR_Checklist.GetDataSource("D"); band.DataSource = dataSource; (rptAR_Checklist.FindObject("Text16") as RichObject).Text = Loginer.CurrentUser.AccountName; //打印人员 rptAR_Checklist.Parameters.FindByName("pRowCount").Value = ds.Tables[0].Rows.Count.ToString(); //报表参数,设置记录数 }