private void BindDropDown()
{
if (ViewState["EWFCode"].ToString() != "")
{
ddl_App.DataSource = EWF_Flow_AppBLL.GetModelByClassify(ViewState["EWFCode"].ToString());
}
else
{
ddl_App.DataSource = EWF_Flow_AppBLL.GetModelList(" EnableFlag='Y' ");
}
ddl_App.DataBind();
ddl_App.Items.Insert(0, new ListItem("请选择...", "0"));
#region 绑定当前操作员所能查看的管理片区
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);
tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity();
if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0)
{
tr_OrganizeCity.RootValue = "0";
tr_OrganizeCity.SelectValue = "1";
}
else
{
tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString();
tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString();
}
#endregion
ddl_FinishStatus.DataSource = DictionaryBLL.GetDicCollections("EWF_Flow_FinishStatus");
ddl_FinishStatus.DataBind();
ddl_FinishStatus.Items.Insert(0, new ListItem("全部", "0"));
}
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 + "')";
}
else
if (ddl_App.Items.Count > 1 && ViewState["EWFCode"].ToString() != "")
{
string apps = "";
DataTable dt_app = EWF_Flow_AppBLL.GetModelByClassify(ViewState["EWFCode"].ToString());
foreach (DataRow app in dt_app.Rows)
{
if (apps != "")
{
apps += ",";
}
apps += "'" + app["ID"] + "'";
}
condition += " AND (App IN (" + apps + "))";
}
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);
}