public TemplateModel PrepareMainTemplate(TreeView tvSource, List <GridModelProperty> lsModelProps) { try { var body = new BodySectionModel(); var Header = new PageHeaderSection(); var Footer = new PageFooterSection(); foreach (TreeNode item in tvSource.Nodes[0].Nodes) { switch (item.Text.ToUpper()) { case "CONTENT": body.Tables = new List <TableModel>(); foreach (TreeNode tab in item.Nodes) { body.Tables.Add(PrepareMainTable(tab)); } break; case "PAGEHEADER": Header.Tables = new List <TableModel>(); foreach (TreeNode tab in item.Nodes) { body.Tables.Add(PrepareMainTable(tab)); } break; case "PAGEFOOTER": Footer = new PageFooterSection() { FooterType = "N" }; break; } } var objDocprops = (tvSource.Nodes[0].Tag as ControlPropertyModel).Properties as DocumentGridModel; var objTemplate = GetTemplate(objDocprops.Template, body, Header, Footer); objTemplate.ModelVariables = lsModelProps.Select(x => new ModelInfoModel { ModelName = x.ModelName, ModelType = x.ModelType }).Distinct().ToList(); objTemplate.bindingModelProps = lsModelProps.Select(x => new BindingModel { ModelVariable = x.ModelName, PropName = x.FieldName }).Distinct().ToList(); objTemplate.Name = objDocprops.Name; objTemplate.NameSpace = objDocprops.Namespace; objTemplate.Type = objDocprops.Template.ToUpper() == "CUSTOM"?"C":objDocprops.Template; objTemplate.Location = objDocprops.Location; return(objTemplate); } catch (Exception ex) { } return(null); }
/// <summary> /// Required method for telerik Reporting designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter4 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter5 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter6 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter7 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.DescendantSelector descendantSelector1 = new Telerik.Reporting.Drawing.DescendantSelector(); Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.DescendantSelector descendantSelector2 = new Telerik.Reporting.Drawing.DescendantSelector(); this.sqlDataSource = new Telerik.Reporting.SqlDataSource(); this.detail = new Telerik.Reporting.DetailSection(); this.txtTongTien = new Telerik.Reporting.TextBox(); this.textBox12 = new Telerik.Reporting.TextBox(); this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection(); this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection(); this.textBox1 = new Telerik.Reporting.TextBox(); this.txtNgay = new Telerik.Reporting.TextBox(); this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource(); this.table1 = new Telerik.Reporting.Table(); this.textBox2 = new Telerik.Reporting.TextBox(); this.textBox3 = new Telerik.Reporting.TextBox(); this.textBox4 = new Telerik.Reporting.TextBox(); this.textBox5 = new Telerik.Reporting.TextBox(); this.textBox6 = new Telerik.Reporting.TextBox(); this.textBox7 = new Telerik.Reporting.TextBox(); this.textBox8 = new Telerik.Reporting.TextBox(); this.textBox9 = new Telerik.Reporting.TextBox(); this.textBox10 = new Telerik.Reporting.TextBox(); this.textBox11 = new Telerik.Reporting.TextBox(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource // this.sqlDataSource.Name = "sqlDataSource"; // // detail // this.detail.Height = new Telerik.Reporting.Drawing.Unit(1.1999999284744263D, Telerik.Reporting.Drawing.UnitType.Inch); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.txtTongTien, this.textBox12, this.table1}); this.detail.Name = "detail"; // // txtTongTien // this.txtTongTien.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.8141498565673828D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtTongTien.Name = "txtTongTien"; this.txtTongTien.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535274505615234D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtTongTien.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.txtTongTien.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.txtTongTien.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.txtTongTien.Value = ""; // // textBox12 // this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.1076583862304688D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox12.Name = "textBox12"; this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.70641261339187622D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29996061325073242D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox12.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox12.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox12.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox12.Value = "Tổng tiền: "; // // pageFooterSection1 // this.pageFooterSection1.Height = new Telerik.Reporting.Drawing.Unit(0.30000004172325134D, Telerik.Reporting.Drawing.UnitType.Inch); this.pageFooterSection1.Name = "pageFooterSection1"; // // pageHeaderSection1 // this.pageHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch); this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox1, this.txtNgay}); this.pageHeaderSection1.Name = "pageHeaderSection1"; // // textBox1 // this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Name = "textBox1"; this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2676773071289062D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29996061325073242D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(15D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox1.Value = "THỐNG KÊ DOANH THU"; // // txtNgay // this.txtNgay.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30007871985435486D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtNgay.Name = "txtNgay"; this.txtNgay.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2676377296447754D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29984259605407715D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtNgay.Style.Font.Name = "Arial"; this.txtNgay.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(15D, Telerik.Reporting.Drawing.UnitType.Point); this.txtNgay.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left; this.txtNgay.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.txtNgay.Value = ""; // // sqlDataSource1 // this.sqlDataSource1.ConnectionString = "Telerik.Reporting.Properties.Settings.ttewjkqv_qlks"; this.sqlDataSource1.Name = "sqlDataSource1"; this.sqlDataSource1.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@NgayRaSo", System.Data.DbType.Int32, "20120321")}); this.sqlDataSource1.SelectCommand = "dbo.sp_HoaDon_GetItems_TheoNgay"; this.sqlDataSource1.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure; // // table1 // this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch))); this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch))); this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch))); this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch))); this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch))); this.table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch))); this.table1.Body.SetCellContent(0, 0, this.textBox7); this.table1.Body.SetCellContent(0, 1, this.textBox8); this.table1.Body.SetCellContent(0, 2, this.textBox9); this.table1.Body.SetCellContent(0, 3, this.textBox10); this.table1.Body.SetCellContent(0, 4, this.textBox11); tableGroup1.ReportItem = this.textBox2; tableGroup2.ReportItem = this.textBox3; tableGroup3.ReportItem = this.textBox4; tableGroup4.ReportItem = this.textBox5; tableGroup5.ReportItem = this.textBox6; this.table1.ColumnGroups.Add(tableGroup1); this.table1.ColumnGroups.Add(tableGroup2); this.table1.ColumnGroups.Add(tableGroup3); this.table1.ColumnGroups.Add(tableGroup4); this.table1.ColumnGroups.Add(tableGroup5); this.table1.DataSource = this.sqlDataSource; this.table1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox2, this.textBox3, this.textBox4, this.textBox5, this.textBox6, this.textBox7, this.textBox8, this.textBox9, this.textBox10, this.textBox11}); this.table1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch)); this.table1.Name = "table1"; tableGroup6.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] { new Telerik.Reporting.Data.Grouping("")}); tableGroup6.Name = "Detail"; this.table1.RowGroups.Add(tableGroup6); this.table1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2676382064819336D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.59999996423721313D, Telerik.Reporting.Drawing.UnitType.Inch)); this.table1.StyleName = "Normal.TableNormal"; // // textBox2 // this.textBox2.Name = "textBox2"; this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox2.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox2.Style.Font.Name = "Arial"; this.textBox2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox2.StyleName = "Normal.TableHeader"; this.textBox2.Value = "Ngày vào"; // // textBox3 // this.textBox3.Name = "textBox3"; this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox3.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox3.Style.Font.Name = "Arial"; this.textBox3.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox3.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox3.StyleName = "Normal.TableHeader"; this.textBox3.Value = "Ngày ra"; // // textBox4 // this.textBox4.Name = "textBox4"; this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox4.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox4.Style.Font.Name = "Arial"; this.textBox4.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox4.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox4.StyleName = "Normal.TableHeader"; this.textBox4.Value = "Loại thuê"; // // textBox5 // this.textBox5.Name = "textBox5"; this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox5.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox5.Style.Font.Name = "Arial"; this.textBox5.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox5.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox5.StyleName = "Normal.TableHeader"; this.textBox5.Value = "Ca"; // // textBox6 // this.textBox6.Name = "textBox6"; this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox6.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox6.Style.Font.Name = "Arial"; this.textBox6.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox6.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox6.StyleName = "Normal.TableHeader"; this.textBox6.Value = "Thành tiền"; // // textBox7 // this.textBox7.Name = "textBox7"; this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox7.Style.Font.Name = "Arial"; this.textBox7.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox7.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox7.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox7.StyleName = "Normal.TableBody"; this.textBox7.Value = "=Fields.NgayVao"; // // textBox8 // this.textBox8.Name = "textBox8"; this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox8.Style.Font.Name = "Arial"; this.textBox8.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox8.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox8.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox8.StyleName = "Normal.TableBody"; this.textBox8.Value = "=Fields.NgayRa"; // // textBox9 // this.textBox9.Name = "textBox9"; this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox9.Style.Font.Name = "Arial"; this.textBox9.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox9.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox9.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox9.StyleName = "Normal.TableBody"; this.textBox9.Value = "=Fields.Thue"; // // textBox10 // this.textBox10.Name = "textBox10"; this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox10.Style.Font.Name = "Arial"; this.textBox10.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox10.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox10.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox10.StyleName = "Normal.TableBody"; this.textBox10.Value = "=Fields.LoaiCa"; // // textBox11 // this.textBox11.Format = "{0:N0}"; this.textBox11.Name = "textBox11"; this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4535276889801025D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29999998211860657D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox11.Style.Font.Name = "Arial"; this.textBox11.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox11.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox11.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox11.StyleName = "Normal.TableBody"; this.textBox11.Value = "=Fields.TongTien"; // // ReportThongKeDoanhThu // this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.pageHeaderSection1, this.detail, this.pageFooterSection1}); this.PageSettings.Landscape = false; this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4; reportParameter1.Name = "Type"; reportParameter1.Text = "Type"; reportParameter2.Name = "Ngay"; reportParameter2.Text = "Ngay"; reportParameter3.Name = "Thang"; reportParameter3.Text = "Thang"; reportParameter4.Name = "Nam"; reportParameter4.Text = "Nam"; reportParameter5.Name = "TuNgay"; reportParameter5.Text = "TuNgay"; reportParameter6.Name = "DenNgay"; reportParameter6.Text = "DenNgay"; reportParameter7.Name = "TongTien"; reportParameter7.Text = "TongTien"; this.ReportParameters.Add(reportParameter1); this.ReportParameters.Add(reportParameter2); this.ReportParameters.Add(reportParameter3); this.ReportParameters.Add(reportParameter4); this.ReportParameters.Add(reportParameter5); this.ReportParameters.Add(reportParameter6); this.ReportParameters.Add(reportParameter7); this.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.Table), "Normal.TableNormal")}); styleRule1.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Style.BorderColor.Default = System.Drawing.Color.Black; styleRule1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; styleRule1.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel); styleRule1.Style.Color = System.Drawing.Color.Black; styleRule1.Style.Font.Name = "Tahoma"; styleRule1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(8D, Telerik.Reporting.Drawing.UnitType.Point); descendantSelector1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Table)), new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.ReportItem), "Normal.TableHeader")}); styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { descendantSelector1}); styleRule2.Style.BorderColor.Default = System.Drawing.Color.Black; styleRule2.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; styleRule2.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel); styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; descendantSelector2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Table)), new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.ReportItem), "Normal.TableBody")}); styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { descendantSelector2}); styleRule3.Style.BorderColor.Default = System.Drawing.Color.Black; styleRule3.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; styleRule3.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel); this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] { styleRule1, styleRule2, styleRule3}); this.Width = new Telerik.Reporting.Drawing.Unit(7.2677168846130371D, Telerik.Reporting.Drawing.UnitType.Inch); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
private TemplateModel GetTemplate(string type, BodySectionModel objBody = null, PageHeaderSection pageHdr = null, PageFooterSection pageFooter = null) { var dict = new Dictionary <string, TemplateModel> { { "HCF", new HCF_TemplateModel() { Body = objBody, PageHeader = pageHdr, PageFooter = pageFooter } }, { "HC", new HC_TemplateModel() { Body = objBody, PageHeader = pageHdr } }, { "CF", new CF_TemplateModel() { Body = objBody, PageFooter = pageFooter } }, { "CUSTOM", new C_TemplateModel() { Body = objBody } } }; return(dict[type.ToUpper()]); }
/// <summary> /// Required method for telerik Reporting designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.Crosstab crosstab2; Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter4 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter5 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter6 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter7 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.DescendantSelector descendantSelector1 = new Telerik.Reporting.Drawing.DescendantSelector(); Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.DescendantSelector descendantSelector2 = new Telerik.Reporting.Drawing.DescendantSelector(); Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.DescendantSelector descendantSelector3 = new Telerik.Reporting.Drawing.DescendantSelector(); this.textBox14 = new Telerik.Reporting.TextBox(); this.textBox23 = new Telerik.Reporting.TextBox(); this.textBox26 = new Telerik.Reporting.TextBox(); this.textBox28 = new Telerik.Reporting.TextBox(); this.textBox29 = new Telerik.Reporting.TextBox(); this.textBox5 = new Telerik.Reporting.TextBox(); this.textBox6 = new Telerik.Reporting.TextBox(); this.textBox7 = new Telerik.Reporting.TextBox(); this.textBox8 = new Telerik.Reporting.TextBox(); this.textBox9 = new Telerik.Reporting.TextBox(); this.textBox11 = new Telerik.Reporting.TextBox(); this.sqlDataSource = new Telerik.Reporting.SqlDataSource(); this.textBox10 = new Telerik.Reporting.TextBox(); this.detail = new Telerik.Reporting.DetailSection(); this.txtTongTien = new Telerik.Reporting.TextBox(); this.textBox12 = new Telerik.Reporting.TextBox(); this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource(); this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection(); this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection(); this.textBox1 = new Telerik.Reporting.TextBox(); this.txtNgay = new Telerik.Reporting.TextBox(); crosstab2 = new Telerik.Reporting.Crosstab(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // crosstab2 // crosstab2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3362662792205811D, Telerik.Reporting.Drawing.UnitType.Inch))); crosstab2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.2945994138717651D, Telerik.Reporting.Drawing.UnitType.Inch))); crosstab2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0029327869415283D, Telerik.Reporting.Drawing.UnitType.Inch))); crosstab2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.2112661600112915D, Telerik.Reporting.Drawing.UnitType.Inch))); crosstab2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.2112665176391602D, Telerik.Reporting.Drawing.UnitType.Inch))); crosstab2.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.31000000238418579D, Telerik.Reporting.Drawing.UnitType.Inch))); crosstab2.Body.SetCellContent(0, 0, this.textBox14); crosstab2.Body.SetCellContent(0, 1, this.textBox23); crosstab2.Body.SetCellContent(0, 2, this.textBox26); crosstab2.Body.SetCellContent(0, 3, this.textBox28); crosstab2.Body.SetCellContent(0, 4, this.textBox29); tableGroup1.ReportItem = this.textBox5; tableGroup2.ReportItem = this.textBox6; tableGroup3.ReportItem = this.textBox7; tableGroup4.ReportItem = this.textBox8; tableGroup5.ReportItem = this.textBox9; crosstab2.ColumnGroups.Add(tableGroup1); crosstab2.ColumnGroups.Add(tableGroup2); crosstab2.ColumnGroups.Add(tableGroup3); crosstab2.ColumnGroups.Add(tableGroup4); crosstab2.ColumnGroups.Add(tableGroup5); crosstab2.Corner.SetCellContent(0, 0, this.textBox11); crosstab2.DataSource = this.sqlDataSource; crosstab2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox14, this.textBox23, this.textBox26, this.textBox28, this.textBox29, this.textBox5, this.textBox6, this.textBox7, this.textBox8, this.textBox9, this.textBox11, this.textBox10}); crosstab2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch)); crosstab2.Name = "crosstab2"; tableGroup7.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] { new Telerik.Reporting.Data.Grouping("")}); tableGroup7.Name = "Detail"; tableGroup6.ChildGroups.Add(tableGroup7); tableGroup6.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] { new Telerik.Reporting.Data.Grouping("=Fields.PhongName")}); tableGroup6.Name = "PhongName"; tableGroup6.ReportItem = this.textBox10; tableGroup6.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] { new Telerik.Reporting.Data.Sorting("=Fields.PhongName", Telerik.Reporting.Data.SortDirection.Asc)}); crosstab2.RowGroups.Add(tableGroup6); crosstab2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2675981521606445D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.62458336353302D, Telerik.Reporting.Drawing.UnitType.Inch)); crosstab2.StyleName = "Normal.TableNormal"; // // textBox14 // this.textBox14.Name = "textBox14"; this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3362665176391602D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31000000238418579D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox14.Style.Font.Name = "Arial"; this.textBox14.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox14.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox14.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox14.StyleName = "Normal.TableBody"; this.textBox14.Value = "=Fields.DichVuName"; // // textBox23 // this.textBox23.Name = "textBox23"; this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2945996522903442D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31000000238418579D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox23.Style.Font.Name = "Arial"; this.textBox23.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox23.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox23.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox23.StyleName = "Normal.TableBody"; this.textBox23.Value = "=Fields.NgaySuDung"; // // textBox26 // this.textBox26.Name = "textBox26"; this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0029330253601074D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31000000238418579D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox26.Style.Font.Name = "Arial"; this.textBox26.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox26.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox26.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox26.StyleName = "Normal.TableBody"; this.textBox26.Value = "=Fields.SoLuong"; // // textBox28 // this.textBox28.Format = "{0:N0}"; this.textBox28.Name = "textBox28"; this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2112665176391602D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31000000238418579D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox28.Style.Font.Name = "Arial"; this.textBox28.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox28.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox28.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox28.StyleName = "Normal.TableBody"; this.textBox28.Value = "=Fields.DonGia"; // // textBox29 // this.textBox29.Format = "{0:N0}"; this.textBox29.Name = "textBox29"; this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2112665176391602D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31000000238418579D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox29.Style.Font.Name = "Arial"; this.textBox29.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox29.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox29.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox29.StyleName = "Normal.TableBody"; this.textBox29.Value = "=Fields.TongTien"; // // textBox5 // this.textBox5.Name = "textBox5"; this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3362665176391602D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31458336114883423D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox5.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox5.Style.Font.Name = "Arial"; this.textBox5.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox5.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox5.StyleName = "Normal.TableHeader"; this.textBox5.Value = "Dịch vụ"; // // textBox6 // this.textBox6.Name = "textBox6"; this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2945996522903442D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31458336114883423D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox6.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox6.Style.Font.Name = "Arial"; this.textBox6.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox6.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox6.StyleName = "Normal.TableHeader"; this.textBox6.Value = "Ngày sử dụng"; // // textBox7 // this.textBox7.Name = "textBox7"; this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0029330253601074D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31458336114883423D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox7.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox7.Style.Font.Name = "Arial"; this.textBox7.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox7.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox7.StyleName = "Normal.TableHeader"; this.textBox7.Value = "Số lượng"; // // textBox8 // this.textBox8.Name = "textBox8"; this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2112665176391602D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31458336114883423D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox8.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox8.Style.Font.Name = "Arial"; this.textBox8.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox8.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox8.StyleName = "Normal.TableHeader"; this.textBox8.Value = "Đơn giá"; // // textBox9 // this.textBox9.Name = "textBox9"; this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2112665176391602D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31458336114883423D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox9.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox9.Style.Font.Name = "Arial"; this.textBox9.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox9.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox9.StyleName = "Normal.TableHeader"; this.textBox9.Value = "Thành tiền"; // // textBox11 // this.textBox11.Name = "textBox11"; this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2112665176391602D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31458336114883423D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox11.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); this.textBox11.Style.Font.Name = "Arial"; this.textBox11.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox11.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox11.StyleName = "Normal.TableHeader"; this.textBox11.Value = "Phòng"; // // sqlDataSource // this.sqlDataSource.Name = "sqlDataSource"; // // textBox10 // this.textBox10.Name = "textBox10"; this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2112665176391602D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31000000238418579D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox10.Style.Font.Name = "Arial"; this.textBox10.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox10.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox10.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox10.StyleName = "Normal.TableGroup"; this.textBox10.Value = "=Fields.PhongName"; // // detail // this.detail.Height = new Telerik.Reporting.Drawing.Unit(1.1999999284744263D, Telerik.Reporting.Drawing.UnitType.Inch); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { crosstab2, this.txtTongTien, this.textBox12}); this.detail.Name = "detail"; // // txtTongTien // this.txtTongTien.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(6.0563702583312988D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.90003937482833862D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtTongTien.Name = "txtTongTien"; this.txtTongTien.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2112674713134766D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtTongTien.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.txtTongTien.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.txtTongTien.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.txtTongTien.Value = ""; // // textBox12 // this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.3487324714660645D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.90003937482833862D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox12.Name = "textBox12"; this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.70755892992019653D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29996061325073242D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox12.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox12.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox12.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox12.Value = "Tổng tiền: "; // // sqlDataSource1 // this.sqlDataSource1.ConnectionString = "Telerik.Reporting.Properties.Settings.ttewjkqv_qlks"; this.sqlDataSource1.Name = "sqlDataSource1"; this.sqlDataSource1.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@NgaySo", System.Data.DbType.Int32, "20120321")}); this.sqlDataSource1.SelectCommand = "dbo.sp_HoaDonDichVu_GetItems_TheoNgay"; this.sqlDataSource1.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure; // // pageFooterSection1 // this.pageFooterSection1.Height = new Telerik.Reporting.Drawing.Unit(0.30000004172325134D, Telerik.Reporting.Drawing.UnitType.Inch); this.pageFooterSection1.Name = "pageFooterSection1"; // // pageHeaderSection1 // this.pageHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch); this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox1, this.txtNgay}); this.pageHeaderSection1.Name = "pageHeaderSection1"; // // textBox1 // this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Name = "textBox1"; this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2676377296447754D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29996061325073242D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(15D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox1.Value = "THỐNG KÊ DOANH THU DỊCH VỤ"; // // txtNgay // this.txtNgay.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30007871985435486D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtNgay.Name = "txtNgay"; this.txtNgay.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2675986289978027D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29984259605407715D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtNgay.Style.Font.Name = "Arial"; this.txtNgay.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(15D, Telerik.Reporting.Drawing.UnitType.Point); this.txtNgay.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left; this.txtNgay.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.txtNgay.Value = ""; // // ReportThongKeDoanhThuDichVu // this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.pageHeaderSection1, this.detail, this.pageFooterSection1}); this.PageSettings.Landscape = false; this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4; reportParameter1.Name = "Type"; reportParameter1.Text = "Type"; reportParameter2.Name = "Ngay"; reportParameter2.Text = "Ngay"; reportParameter3.Name = "Thang"; reportParameter3.Text = "Thang"; reportParameter4.Name = "Nam"; reportParameter4.Text = "Nam"; reportParameter5.Name = "TuNgay"; reportParameter5.Text = "TuNgay"; reportParameter6.Name = "DenNgay"; reportParameter6.Text = "DenNgay"; reportParameter7.Name = "TongTien"; reportParameter7.Text = "TongTien"; this.ReportParameters.Add(reportParameter1); this.ReportParameters.Add(reportParameter2); this.ReportParameters.Add(reportParameter3); this.ReportParameters.Add(reportParameter4); this.ReportParameters.Add(reportParameter5); this.ReportParameters.Add(reportParameter6); this.ReportParameters.Add(reportParameter7); this.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.Table), "Normal.TableNormal")}); styleRule1.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Style.BorderColor.Default = System.Drawing.Color.Black; styleRule1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; styleRule1.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel); styleRule1.Style.Color = System.Drawing.Color.Black; styleRule1.Style.Font.Name = "Tahoma"; styleRule1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(8D, Telerik.Reporting.Drawing.UnitType.Point); descendantSelector1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Table)), new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.ReportItem), "Normal.TableHeader")}); styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { descendantSelector1}); styleRule2.Style.BorderColor.Default = System.Drawing.Color.Black; styleRule2.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; styleRule2.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel); styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; descendantSelector2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Table)), new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.ReportItem), "Normal.TableGroup")}); styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { descendantSelector2}); styleRule3.Style.BorderColor.Default = System.Drawing.Color.Black; styleRule3.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; styleRule3.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel); descendantSelector3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Table)), new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.ReportItem), "Normal.TableBody")}); styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { descendantSelector3}); styleRule4.Style.BorderColor.Default = System.Drawing.Color.Black; styleRule4.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; styleRule4.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel); this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] { styleRule1, styleRule2, styleRule3, styleRule4}); this.Width = new Telerik.Reporting.Drawing.Unit(7.2676773071289062D, Telerik.Reporting.Drawing.UnitType.Inch); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }