protected void bt_Export_Click(object sender, EventArgs e)
{
string appcode = "";
if (ddl_State.SelectedValue != "2")
{
appcode = ddl_App.SelectedValue;
}
int organizecity = int.Parse(tr_OrganizeCity.SelectValue);
DataTable dt = PM_PromotorBLL.GetApproveList(organizecity, appcode, (int)Session["UserID"]);
CreateExcel(dt, "Export-" + DateTime.Now.ToString("yyyyMMdd-HHmmss"));
}
private void BindGrid()
{
int organizecity = int.Parse(tr_OrganizeCity.SelectValue);
DataTable dtlist = new DataTable();
if (MCSTabControl1.SelectedTabItem.Value == "2")
{
dtlist = PM_PromotorBLL.GetApproveConsult(organizecity, int.Parse(ddl_Level.SelectedValue));
if (dtlist.Rows.Count > 0)
{
DataRow dtrow = dtlist.NewRow();
dtrow["管理片区"] = "合计";
dtrow["导购人数"] = dtlist.Compute("Sum(导购人数)", "true");
dtrow["上上月实际销量"] = dtlist.Compute("Sum(上上月实际销量)", "true");
dtrow["上月实际销量"] = dtlist.Compute("Sum(上月实际销量)", "true");
dtrow["预估本月销量"] = dtlist.Compute("Sum(预估本月销量)", "true");
dtrow["导购人数"] = dtlist.Compute("Sum(导购人数)", "true");
dtrow["陈列费"] = dtlist.Compute("Sum(陈列费)", "true");
dtrow["促销员管理费"] = dtlist.Compute("Sum(促销员管理费)", "true");
dtrow["底薪"] = dtlist.Compute("Sum(底薪)", "true");
//dtrow["社保"] = dtlist.Compute("Sum(社保)", "true");
dtrow["费率B"] = dtrow["预估本月销量"].ToString() == "0" ? "0" :
((decimal.Parse(dtrow["底薪"].ToString()) + decimal.Parse(dtrow["促销员管理费"].ToString())) / decimal.Parse(dtrow["预估本月销量"].ToString()) * 100).ToString("0.00");
dtlist.Rows.Add(dtrow);
gv_Consult.DataSource = dtlist;
gv_Consult.DataBind();
}
}
else
{
string appcode = "";
if (ddl_State.SelectedValue != "2")
{
appcode = ddl_App.SelectedValue;
}
DataTable dt = PM_PromotorBLL.GetApproveList(organizecity, appcode, (int)Session["UserID"]);
gv_List.DataSource = dt;
gv_List.DataBind();
gv_List.Width = dt.Columns.Count * 60;
gv_List.Columns[0].Visible = ddl_State.SelectedValue != "2";
btn_Approve.Visible = (gv_List.Rows.Count > 0 && ddl_State.SelectedValue != "2");
btn_UnApprove.Visible = btn_Approve.Visible;
}
}
