예제 #1
0
        protected void bSave_Click(object sender, EventArgs e)
        {
            GridShowColumnWWE gsc = new GridShowColumnWWE();
            gsc.HeaderText = TBHeaderText.Text.Trim();
            gsc.ColumnData = TBColumnData.Text.Trim();
            gsc.ColumnType = ddlColumnType.SelectedValue.Trim();
            gsc.ExcelType = ddlExcelType.SelectedValue.Trim();
            gsc.ColumnShow = tbColumnShow.Text.Trim();

            gsc.ShowDisplay = ddlShowDisplay.SelectedValue.Trim();
            gsc.OrderType = ddlOrderType.SelectedValue.Trim();

            List<string> listStyle = new List<string>();
            if (!string.IsNullOrEmpty(tbStyle_Width.Text.Trim()))  listStyle.Add("width:"+tbStyle_Width.Text.Trim());
            if (!string.IsNullOrEmpty(ddlStyle_TextAlign.SelectedValue)) listStyle.Add("text-align:" + ddlStyle_TextAlign.SelectedValue.Trim());

            gsc.Style = string.Join(";",listStyle.ToArray());

            if (string.IsNullOrEmpty(sColumnGuid))
            {

                gsc.Guid = Guid.NewGuid().ToString();

                GSEntity.ColumnList.Add(gsc);
            }
            else
            {
                gsc.Guid = sColumnGuid;

                GSEntity.ColumnList[GSEntity.ColumnList.IndexOf(GSEntity.ColumnList.Single(t => t.Guid == sColumnGuid))]= gsc;

            }

            strFlag = "ok";
        }
예제 #2
0
        protected void DataTableToExcel(DataTable dt, string sFileName)
        {
            HttpResponse resp;
            resp = System.Web.HttpContext.Current.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + sFileName);

            StringBuilder sb = new StringBuilder();

            int iColumnLength = dt.Columns.Count;

            List<string> strList = new List<string>();

            for (int i = 0; i < iColumnLength; i++)
            {
                strList.Add(dt.Columns[i].ColumnName);

            }
            sb.Append(string.Join("\t", strList.ToArray()) + "\n");

            for (int i = 0, j = dt.Rows.Count; i < j; i++)
            {

                strList = new List<string>();
                for (int n = 0; n < iColumnLength; n++)
                {
                    strList.Add(dt.Rows[i][n].ToString());

                }

                sb.Append(string.Join("\t", strList.ToArray()) + "\n");
            }

            resp.Write(sb.ToString());

            //写缓冲区中的数据到HTTP头文件中
            resp.End();
        }