protected void bt_Export_Click(object sender, EventArgs e)
{
string condition = "";
if (tbx_ContractID.Text.Trim() != "")
{
int id = 0;
if (int.TryParse(tbx_ContractID.Text, out id))
{
condition = " AND CM_Contract.ID=" + id;
}
else
{
MessageBox.Show(this, "协议ID填写有问题！");
tbx_ContractID.Focus();
}
}
else
{
if (select_OrgSupplier.SelectValue != "" && select_OrgSupplier.SelectValue != "0")
{
condition = " AND CM_Contract.Client=" + select_OrgSupplier.SelectValue;
}
}
DataTable dt = CM_ContractBLL.GetApproveSummary(int.Parse(tr_OrganizeCity.SelectValue), int.Parse(ddl_State.SelectedValue), (int)Session["UserID"], int.Parse(MCSTabControl1.SelectedTabItem.Value), int.Parse(ddl_PayMode.SelectedValue), condition);;
//string name = "";
//if (MCSTabControl1.SelectedIndex == 0)
// name = "零售商导购协议导出";
//else name = "零售商返利协议导出";
// CreateExcel(dt, "Export-" + name + DateTime.Now.ToString("yyyyMMdd-HHmmss"));
getExcel(dt);
}
private void BindGrid()
{
if (ddl_State.SelectedValue != "1")
{
btn_Approve.Visible = false;
btn_UnApprove.Visible = false;
}
string condition = "";
if (tbx_ContractID.Text.Trim() != "")
{
int id = 0;
if (int.TryParse(tbx_ContractID.Text, out id))
{
condition = " AND CM_Contract.ID=" + id;
}
else
{
MessageBox.Show(this, "协议ID填写有问题！");
tbx_ContractID.Focus();
}
}
else
{
if (select_OrgSupplier.SelectValue != "" && select_OrgSupplier.SelectValue != "0")
{
condition = " AND CM_Contract.Client=" + select_OrgSupplier.SelectValue;
}
}
gv_List.DataSource = CM_ContractBLL.GetApproveSummary(int.Parse(tr_OrganizeCity.SelectValue), int.Parse(ddl_State.SelectedValue), (int)Session["UserID"], int.Parse(MCSTabControl1.SelectedTabItem.Value), int.Parse(ddl_PayMode.SelectedValue), condition);
if (ddl_State.SelectedValue != "1")
{
gv_List.Columns[1].Visible = false;
}
gv_List.BindGrid();
}