C# WebControls.TableItemStyle类代码示例

            /// <summary>
            /// constructor
            /// </summary>
            /// <param name="dt">To export DataTable</param>
            /// <param name="tableStyle">Styling for entire table</param>
            /// <param name="headerStyle">Styling for header</param>
            /// <param name="itemStyle">Styling for the individual cells</param>
            public ExcelFileResult(DataTable dt, TableStyle tableStyle, TableItemStyle headerStyle, TableItemStyle itemStyle)
                : base("application/ms-excel")
            {
                this.dt = dt;
                Title = "Attendance Report ";
                Footer = "Powered By: Hasib, IT Department";
                TitleExportDate = "Export Date: {0}";
                this.tableStyle = tableStyle;
                this.headerStyle = headerStyle;
                this.itemStyle = itemStyle;
                ExcelPackage EXPackage = new ExcelPackage();

                // provide defaults
                if (this.tableStyle == null)
                {
                    this.tableStyle = new TableStyle();
                    this.tableStyle.BorderStyle = BorderStyle.Solid;
                    this.tableStyle.BorderColor = Color.Black;
                    this.tableStyle.BorderWidth = Unit.Parse("2px");
                    //this.tableStyle.BackColor = Color.LightGray;
                    this.tableStyle.BackColor = Color.Azure;
                    //this.tableStyle.BackImageUrl = Path.GetFullPath("D:/HOP/BOK.jpg");
                    //exPackage.Workbook.Properties.Author = "Hasib";
                    //exPackage.Workbook.Properties.Comments = "HopLunIT";
                    //exPackage.Workbook.Properties.Title = "HopLun (Bangladesh) Ltd. Reports";
                }
                if (this.headerStyle == null)
                {
                    this.headerStyle = new TableItemStyle();
                    this.headerStyle.BackColor = Color.LightGray;
                }
            }

        public ExcelResult( 
            IQueryable rows, string fileName, 
            string[] headers,
            TableStyle tableStyle, TableItemStyle headerStyle, TableItemStyle itemStyle)
        {
            //_Mapping = mapping;
            _Rows = rows;
            _FileName = fileName;
            _Headers = headers;
            _TableStyle = tableStyle;
            _HeaderStyle = headerStyle;
            _ItemStyle = itemStyle;

            // provide defaults
            if (_TableStyle == null)
                _TableStyle = new TableStyle();

            if (_HeaderStyle == null)
                _HeaderStyle = new TableItemStyle
                {
                    BackColor = Color.LightGray,
                };

            if (_ItemStyle == null)
                _ItemStyle = new TableItemStyle
                {
                    BorderStyle = BorderStyle.Solid,
                    BorderWidth = new Unit("1px"),
                    BorderColor = Color.LightGray
                };
        }

        private void save(DataTable dt,string filename)
        {
            DataGrid excel = new DataGrid();
            System.Web.UI.WebControls.TableItemStyle AlternatingStyle = new TableItemStyle();
            System.Web.UI.WebControls.TableItemStyle headerStyle = new TableItemStyle();
            System.Web.UI.WebControls.TableItemStyle itemStyle = new TableItemStyle();
            AlternatingStyle.BackColor = System.Drawing.Color.LightGray;
            headerStyle.BackColor = System.Drawing.Color.LightGray;
            headerStyle.Font.Bold = true;
            headerStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
            itemStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; ;

            excel.AlternatingItemStyle.MergeWith(AlternatingStyle);
            excel.HeaderStyle.MergeWith(headerStyle);
            excel.ItemStyle.MergeWith(itemStyle);
            excel.GridLines = GridLines.Both;
            excel.HeaderStyle.Font.Bold = true;
            DataSet ds = new DataSet();
            ds.Tables.Add(dt);
            excel.DataSource = ds;   //输出DataTable的内容
            excel.DataBind();

            System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
            excel.RenderControl(oHtmlTextWriter);

            Response.AddHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".xls");
            Response.ContentType = "application/ms-excel";
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.Write(oHtmlTextWriter.InnerWriter.ToString());
            Response.End();
        }

		private void Page_Load(object sender, System.EventArgs e) 
		{
			//Put user code to initialize the page here
			base.GHTTestBegin((HtmlForm)this.FindControl("Form1"));
			System.Web.UI.WebControls.TableItemStyle myStyle = new System.Web.UI.WebControls.TableItemStyle();
			try 
			{
				base.GHTSubTestBegin("TableItemStyle - Wrap");
				base.GHTActiveSubTest.Controls.Add(Table1);

				myStyle.Wrap = false;
				base.GHTSubTestAddResult(myStyle.Wrap.ToString());
				Table1.Rows[0].Cells[0].ApplyStyle(myStyle);
				Table1.Rows[0].ApplyStyle(myStyle);

				myStyle.Wrap = true;
				base.GHTSubTestAddResult(myStyle.Wrap.ToString());
				Table1.Rows[0].Cells[1].ApplyStyle(myStyle);
				Table1.Rows[1].ApplyStyle(myStyle);
			}
			catch (Exception ex) 
			{
				base.GHTSubTestUnexpectedExceptionCaught(ex);
			}
			base.GHTSubTestEnd();
			base.GHTTestEnd();
		}

        /// <summary>
        /// Creates and returns a new <see cref="System.Web.UI.WebControls.TableItemStyle"/> with 
        /// the specified CSS Class.
        /// </summary>
        /// <param name="cssclass">The CSS Class name which is set as the CSS Class of the 
        /// newly created <see cref="System.Web.UI.WebControls.TableItemStyle"/>.</param>
        /// <returns>
        /// The newly created <see cref="System.Web.UI.WebControls.TableItemStyle"/>.
        /// </returns>
        public static TableItemStyle New(string cssclass)
        {
            TableItemStyle style = new TableItemStyle();

            style.CssClass = cssclass;

            return style;
        }

		private void Page_Load(object sender, System.EventArgs e) 
		{
			//Put user code to initialize the page here
			base.GHTTestBegin((HtmlForm)this.FindControl("Form1"));
			System.Web.UI.WebControls.TableItemStyle tableStyle = new System.Web.UI.WebControls.TableItemStyle();
			tableStyle.CopyFrom(Table2.Rows[0].Cells[0].ControlStyle);
			Table1.Rows[0].Cells[0].ApplyStyle(tableStyle);

			tableStyle.CopyFrom(Table2.Rows[1].ControlStyle);
			Table1.Rows[1].ApplyStyle(tableStyle);

			base.GHTTestEnd();
		}

 public static ActionResult Excel(
     this Controller controller, 
     DataContext dataContext,
     IQueryable rows, 
     string fileName, 
     string[] headers, 
     TableStyle tableStyle, 
     TableItemStyle headerStyle,
     TableItemStyle itemStyle
 )
 {
     return new ExcelResult(dataContext, rows, fileName, headers, tableStyle, headerStyle, itemStyle);
 }

        static private void DoInitialization()
        {
            mcStyle = new TableItemStyle();
            mcStyle.HorizontalAlign = HorizontalAlign.Center;
            mcStyle.BackColor = teColors.eeRowBg;
            mcStyle.BorderColor = Color.Black;
            mcStyle.BorderStyle = BorderStyle.None;
            mcStyle.BorderWidth = 0;
            mcStyle.ForeColor = teColors.eeText;

            mcStyle.Font.Name = "Arial";
            mcStyle.Font.Size = 10;
            mcStyle.HorizontalAlign = HorizontalAlign.Left;
        }

        public static string Export(System.Data.DataTable dt, string fileName)
        {
            System.Web.UI.Page page = System.Web.HttpContext.Current.Handler as System.Web.UI.Page;

            StringWriter stringWriter = new StringWriter();
            HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
            DataGrid dGrid = new DataGrid();

            TableItemStyle alternatingStyle = new TableItemStyle();
            TableItemStyle headerStyle = new TableItemStyle();
            TableItemStyle itemStyle = new TableItemStyle();

            alternatingStyle.BackColor = Color.LightGray;

            headerStyle.BackColor = Color.LightGray;
            headerStyle.Font.Bold = true;
            headerStyle.HorizontalAlign = HorizontalAlign.Center;

            itemStyle.HorizontalAlign = HorizontalAlign.Center;

            dGrid.GridLines = GridLines.Both;

            dGrid.HeaderStyle.MergeWith(headerStyle);
            dGrid.HeaderStyle.Font.Bold = true;

            dGrid.AlternatingItemStyle.MergeWith(alternatingStyle);
            dGrid.ItemStyle.MergeWith(itemStyle);

            dGrid.DataSource = dt.DefaultView;
            dGrid.DataBind();
            dGrid.RenderControl(htmlWriter);

            string filePath = Path.Combine(excelFullFolder, fileName + ext);
            if (System.IO.File.Exists(filePath))
            {
                System.IO.File.Delete(filePath);
            }
            StreamWriter sw = new StreamWriter(filePath, false, System.Text.Encoding.UTF8);
            sw.Write(stringWriter.ToString());
            sw.Close();

            int pos = page.Request.Url.ToString().LastIndexOf(page.Request.Path);

            string fileUrl = page.Request.Url.ToString().Substring(0, pos);
            fileUrl += page.Request.ApplicationPath + excelFolder.Replace("\\", "/") + fileName + ext;
            HttpContext.Current.Response.Redirect(fileUrl);

            return fileUrl;
        }

		private void Page_Load(object sender, System.EventArgs e) 
		{
			//Put user code to initialize the page here

			base.GHTTestBegin((HtmlForm)this.FindControl("Form1"));
			System.Web.UI.WebControls.TableItemStyle myStyle = new System.Web.UI.WebControls.TableItemStyle();
				try 
				{
					base.GHTSubTestBegin("TableItemStyle - HorizontalAlign");
					base.GHTActiveSubTest.Controls.Add(Table1);

					myStyle.HorizontalAlign = HorizontalAlign.Center;
					base.GHTSubTestAddResult(myStyle.HorizontalAlign.ToString());
					Table1.Rows[0].Cells[0].ApplyStyle(myStyle);
					Table1.Rows[0].ApplyStyle(myStyle);

					myStyle.HorizontalAlign = HorizontalAlign.Justify;
					base.GHTSubTestAddResult(myStyle.HorizontalAlign.ToString());
					Table1.Rows[0].Cells[1].ApplyStyle(myStyle);
					Table1.Rows[1].ApplyStyle(myStyle);

					myStyle.HorizontalAlign = HorizontalAlign.Left;
					base.GHTSubTestAddResult(myStyle.HorizontalAlign.ToString());
					Table1.Rows[0].Cells[2].ApplyStyle(myStyle);
					Table1.Rows[2].ApplyStyle(myStyle);

					myStyle.HorizontalAlign = HorizontalAlign.NotSet;
					base.GHTSubTestAddResult(myStyle.HorizontalAlign.ToString());
					Table1.Rows[0].Cells[3].ApplyStyle(myStyle);
					Table1.Rows[3].ApplyStyle(myStyle);

					myStyle.HorizontalAlign = HorizontalAlign.Right;
					base.GHTSubTestAddResult(myStyle.HorizontalAlign.ToString());
					Table1.Rows[0].Cells[4].ApplyStyle(myStyle);
					Table1.Rows[4].ApplyStyle(myStyle);
				}
				catch (Exception ex) 
				{
					base.GHTSubTestUnexpectedExceptionCaught(ex);
				}
			base.GHTSubTestEnd();
			base.GHTTestEnd();
		}

		private void Page_Load(object sender, System.EventArgs e) 
		{
			//Put user code to initialize the page here
			// System.Web.UI.StateBag
			base.GHTTestBegin((HtmlForm)this.FindControl("Form1"));
			try 
			{
				base.GHTSubTestBegin("TableItemStyle_ctor_S");
				System.Web.UI.WebControls.TableItemStyle myStyle;
				myStyle = new System.Web.UI.WebControls.TableItemStyle(new System.Web.UI.StateBag(true));

				base.GHTSubTestAddResult("is (object = null)? " + ((myStyle == null) ? "True" : "False"));
			}
			catch (Exception ex) 
			{
				base.GHTSubTestUnexpectedExceptionCaught(ex);
			}
			base.GHTSubTestEnd();
			base.GHTTestEnd();
		}

 public ExcelFeedGenerator()
 {
     _tableStyle = new TableStyle
     {
         BorderStyle = BorderStyle.Solid,
         BorderColor = Color.Black,
         BorderWidth = Unit.Parse("1px"),
     };
     _headerStyle = new TableItemStyle
     {
         VerticalAlign = VerticalAlign.Top,
         BackColor = Color.DimGray,
     };
     _itemStyle = new TableItemStyle
     {
         VerticalAlign = VerticalAlign.Top,
         BorderStyle = BorderStyle.Solid,
         BorderColor = Color.DimGray,
     };
 }

        public ExcelResult(IQueryable rows, string fileName, Dictionary<string, string> headers, TableStyle tableStyle, TableItemStyle headerStyle, TableItemStyle itemStyle)
        {
            _rows = rows;
            _fileName = fileName;
            _headers = headers;
            _tableStyle = tableStyle;
            _headerStyle = headerStyle;
            _itemStyle = itemStyle;

            // provide defaults
            if (_tableStyle == null)
            {
                _tableStyle = new TableStyle();
                _tableStyle.BorderStyle = BorderStyle.Solid;
                _tableStyle.BorderColor = Color.Black;
                _tableStyle.BorderWidth = Unit.Parse("1px");
            }
            if (_headerStyle == null)
            {
                _headerStyle = new TableItemStyle();
                _headerStyle.BackColor = Color.LightGray;
            }
        }

        /// <summary>
        /// Konstruktor
        /// </summary>
        /// <param name="dt">Die zu exportierende DataTable</param>
        /// <param name="tableStyle">Styling für gesamgte Tabelle</param>
        /// <param name="headerStyle">Styling für Kopfzeile</param>
        /// <param name="itemStyle">Styling für die einzelnen Zellen</param>
        public ExcelFileResult(DataTable dt, TableStyle tableStyle, TableItemStyle headerStyle, TableItemStyle itemStyle)
            : base("application/ms-excel")
        {
            this.dt = dt;
            TitleExportDate = "Exportdatum: {0}";
            this.tableStyle = tableStyle;
            this.headerStyle = headerStyle;
            this.itemStyle = itemStyle;

            // provide defaults
            if (this.tableStyle == null)
            {
                this.tableStyle = new TableStyle();
                this.tableStyle.BorderStyle = BorderStyle.Solid;
                this.tableStyle.BorderColor = Color.Black;
                this.tableStyle.BorderWidth = Unit.Parse("2px");
            }
            if (this.headerStyle == null)
            {
                this.headerStyle = new TableItemStyle();
                this.headerStyle.BackColor = Color.LightGray;
            }
        }

        public ExcelResult(DbContext dataContext, IQueryable rows, string fileName, string[] headers, TableStyle tableStyle, TableItemStyle headerStyle, TableItemStyle itemStyle)
        {
            _dataContext = dataContext;
             _rows = rows;
             _fileName = fileName;
             _headers = headers;
             _tableStyle = tableStyle;
             _headerStyle = headerStyle;
             _itemStyle = itemStyle;

             // provide defaults
             if (_tableStyle == null)
             {
                 _tableStyle = new TableStyle();
                 _tableStyle.BorderStyle = BorderStyle.Solid;
                 _tableStyle.BorderColor = Color.Black;
                 _tableStyle.BorderWidth = Unit.Parse("2px");
             }
             if (_headerStyle == null)
             {
                 _headerStyle = new TableItemStyle();
                 _headerStyle.BackColor = Color.LightGray;
             }
        }