private void BindGrid() { int organizecity = int.Parse(tr_OrganizeCity.SelectValue); int level = int.Parse(ddl_Level.SelectedValue); int state = int.Parse(ddl_State.SelectedValue); int rtchannel = int.Parse(ddl_RTChannel.SelectedValue); gv_List.Visible = (MCSTabControl1.SelectedIndex == 0); gv_ListDetail.Visible = (MCSTabControl1.SelectedIndex == 1); bt_Approved.Visible = (MCSTabControl1.SelectedIndex == 0); bt_UnApproved.Visible = (MCSTabControl1.SelectedIndex == 1); switch (MCSTabControl1.SelectedTabItem.Value) { case "0": { #region 显示统计分析 DataTable dtSummary = CM_ContractBLL.GetPMSummary(organizecity, level, state, (int)Session["UserID"], rtchannel); if (dtSummary.Rows.Count == 0) { gv_List.DataBind(); } gv_List.DataSource = dtSummary; gv_List.DataBind(); MatrixTable.GridViewMatric(gv_List); #endregion } break; case "1": { DataTable dtList = CM_ContractBLL.GetPMListDetail(organizecity, level, state, (int)Session["UserID"], rtchannel); gv_ListDetail.DataSource = dtList; gv_ListDetail.BindGrid(); } break; } #region 是否可以批量审批 if (state != 1) { bt_Approved.Visible = false; bt_UnApproved.Visible = false; if (gv_ListDetail.Visible) { gv_ListDetail.Columns[0].Visible = false; gv_ListDetail.Columns[1].Visible = false; } } #endregion }
protected void bt_Export_Click(object sender, EventArgs e) { switch (MCSTabControl1.SelectedTabItem.Value) { case "0": { gv_List.AllowPaging = false; BindGrid(); Response.Clear(); string filename = HttpUtility.UrlEncode("预付导购管理费用汇总单导出_" + DateTime.Now.ToString("yyyyMMddHHmmss")); Response.Charset = "UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ContentType = "application/vnd.ms-excel"; Response.BufferOutput = true; Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls"); Page.EnableViewState = false; StringWriter tw = new System.IO.StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); gv_List.RenderControl(hw); StringBuilder outhtml = new StringBuilder(tw.ToString()); outhtml = outhtml.Replace(" ", ""); Response.Write(outhtml.ToString()); Response.End(); Page.EnableViewState = true; gv_List.AllowPaging = true; break; } case "1": { int organizecity = int.Parse(tr_OrganizeCity.SelectValue); int level = int.Parse(ddl_Level.SelectedValue); int state = int.Parse(ddl_State.SelectedValue); int rtchannel = int.Parse(ddl_RTChannel.SelectedValue); DataTable dtList = CM_ContractBLL.GetPMListDetail(organizecity, level, state, (int)Session["UserID"], rtchannel); dtList.Columns["ApproveTask"].ColumnName = "流程ID"; string filename = HttpUtility.UrlEncode("预付导购管理费用明细导出_" + DateTime.Now.ToString("yyyyMMddHHmmss")); DataTableToExcel(dtList, filename); break; } } BindGrid(); }