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