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();
}
