public static void OutExcel(Page myPage, SmartGridView gv, string name, string codetype)
{
if (codetype == "")
{
codetype = "GB2312";
}
HttpResponse response = myPage.Response;
string str = "attachment;filename=" + HttpContext.Current.Server.UrlEncode(name) + ".xls";
gv.Visible = true;
response.Clear();
response.Buffer = true;
response.Charset = codetype;
response.AppendHeader("Content-Disposition", str);
response.ContentEncoding = Encoding.GetEncoding(codetype);
response.ContentType = "application/ms-excel";
gv.EnableViewState = false;
StringWriter writer = new StringWriter();
HtmlTextWriter writer2 = new HtmlTextWriter(writer);
gv.RenderControl(writer2);
response.Write(writer.ToString());
response.End();
}
public static void setGViewColumns(DataSet ds, SmartGridView gvResult)
{
if (gvResult.Columns.Count == 0)
{
BoundField field = null;
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
field = new BoundField {
DataField = ds.Tables[0].Columns[i].ColumnName,
HeaderText = ds.Tables[0].Columns[i].ColumnName,
SortExpression = ds.Tables[0].Columns[i].ColumnName
};
field.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
if (IsEnglishStr(ds.Tables[0].Columns[i].ColumnName))
{
field.Visible = false;
}
gvResult.Columns.Add(field);
}
ButtonField field2 = new ButtonField {
CommandName = "two",
Visible = false
};
gvResult.Columns.Add(field2);
field2 = new ButtonField {
CommandName = "Select",
Visible = false
};
gvResult.Columns.Add(field2);
}
if ((ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count == 0))
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
}
}
public static void GetSelectTJ(SmartGridView gvResult, ref DataSet DataSetClo, ref DataSet DataSetTable, ArrayList NotDisplayColumn)
{
DataSetClo = new DataSet();
DataSetTable = new DataSet();
DataSetClo.Tables.Add();
DataSetTable.Tables.Add();
foreach (DataControlField field in gvResult.Columns)
{
TemplateField field3;
string name = field.GetType().Name;
if (name != null)
{
if (!(name == "BoundField"))
{
if (name == "TemplateField")
{
goto Label_0164;
}
}
else
{
BoundField field2 = (BoundField) field;
if (((field2.Visible && (field2.HeaderText != "序号")) && ((NotDisplayColumn == null) || !GetSelectTJ_pd(gvResult, field, NotDisplayColumn, field2.DataField))) && (DataSetClo.Tables[0].Columns.IndexOf(field2.DataField) == -1))
{
if (DataSetClo.Tables[0].Columns.IndexOf(field2.DataField) == -1)
{
DataSetClo.Tables[0].Columns.Add(field2.DataField);
}
if (DataSetTable.Tables[0].Columns.IndexOf(field2.HeaderText) == -1)
{
DataSetTable.Tables[0].Columns.Add(field2.HeaderText);
}
}
}
}
continue;
Label_0164:
field3 = (TemplateField) field;
if (((field3.Visible && (field3.HeaderText != "序号")) && (field3.SortExpression != "")) && ((NotDisplayColumn == null) || !GetSelectTJ_pd(gvResult, field, NotDisplayColumn, field3.SortExpression)))
{
if (DataSetClo.Tables[0].Columns.IndexOf(field3.SortExpression) == -1)
{
DataSetClo.Tables[0].Columns.Add(field3.SortExpression);
}
if (DataSetTable.Tables[0].Columns.IndexOf(field3.HeaderText) == -1)
{
DataSetTable.Tables[0].Columns.Add(field3.HeaderText);
}
}
}
}
/// <summary>
/// gridview强制不换行
/// </summary>
/// <param name="objView"></param>
public static void setGridKeepAll(SmartGridView objView)
{
objView.HeaderRow.Style.Add("word-break", "keep-all");
foreach (GridViewRow row in objView.Rows)
{
foreach (TableCell cell in row.Cells)
{
cell.Wrap = false;
cell.Style.Add("word-break", "keep-all");
}
}
}
private static bool GetSelectTJ_pd(SmartGridView gvResult, DataControlField column, ArrayList NotDisplayColumn, string BindDataName)
{
foreach (object obj2 in NotDisplayColumn)
{
if (BindDataName == obj2.ToString())
{
column.Visible = false;
return true;
}
}
return false;
}