private void BindGrid()
{
string condition = "(StartTime BETWEEN '" + tbx_begin.Text + "' AND '" + tbx_end.Text + " 23:59:59')";
condition += " AND Status=" + MCSTabControl1.SelectedTabItem.Value.ToString();
if (ddl_App.SelectedValue != "0")
{
condition += " AND (App = '" + ddl_App.SelectedValue + "')";
}
if (select_Staff.SelectValue != "" && select_Staff.SelectValue != "0")
{
condition += " AND Initiator = " + select_Staff.SelectValue;
}
else
{
#region 判断当前可查询的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND Initiator IN (SELECT ID FROM MCS_SYS.dbo.Org_Staff WHERE OrganizeCity IN (" + orgcitys + "))";
}
#endregion
}
if (tbx_KeyWords.Text != "")
{
condition += " AND (Title like '%" + tbx_KeyWords.Text +
"%' OR CAST (ID AS VARCHAR)='" + tbx_KeyWords.Text + "')";
}
if (ddl_FinishStatus.SelectedValue != "0")
{
condition += " AND FinishStatus = " + ddl_FinishStatus.SelectedValue;
}
//condition += " ORDER BY ID desc";
gv_List.PageIndex = (int)ViewState["PageIndex"];
IList <EWF_Task> tasks = EWF_TaskBLL.GetModelList(condition);
gv_List.BindGrid <EWF_Task>(tasks);
}
