private void BindGrid() { DataTable dt = EWF_Task_JobBLL.GetJobToDecision(int.Parse(Session["UserID"].ToString())); string condition = " 1 = 1 "; if (ddl_App.SelectedValue != "0") { condition += " AND App = '" + ddl_App.SelectedValue + "'"; } if (tbx_MessageSubject.Text != "") { condition += " AND (Title like '%" + tbx_MessageSubject.Text + "%' OR MessageSubject like '%" + tbx_MessageSubject.Text + "%')"; } #region 判断当前可查询的范围 string orgcitys = ""; if (tr_OrganizeCity.SelectValue != "1" && tr_OrganizeCity.SelectValue != "0") { Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true); orgcitys = orgcity.GetAllChildNodeIDs(); if (orgcitys != "") { orgcitys += ","; } orgcitys += tr_OrganizeCity.SelectValue; condition += " AND OrganizeCity IN (" + orgcitys + ")"; } #endregion if (tbx_InitiatorStaffName.Text != "") { condition += " AND ApplyStaffName LIKE '%" + tbx_InitiatorStaffName.Text + "%'"; } string CantApproveAlone_EWF = ConfigHelper.GetConfigString("CantApproveAlone_EWF"); if (!string.IsNullOrEmpty(CantApproveAlone_EWF)) { condition += " AND AppCode NOT IN (" + CantApproveAlone_EWF + ")"; } dt.DefaultView.RowFilter = condition; dt.DefaultView.Sort = " TaskID desc "; gv_List.DataSource = dt.DefaultView; gv_List.TotalRecordCount = dt.DefaultView.Count; gv_List.PageIndex = (int)ViewState["PageIndex"]; gv_List.DataBind(); cb_SelectAll.Checked = false; }
private void BindDession() { GetEWFCount(); DataTable dt = EWF_Task_JobBLL.GetJobToDecision(int.Parse(Session["UserID"].ToString())); string condition = ConfigHelper.GetConfigString("Desktop_EWF_GetDessionCondition"); if (!string.IsNullOrEmpty(condition)) { dt.DefaultView.RowFilter = condition; } gv_Decission.DataSource = dt.DefaultView; gv_Decission.DataBind(); hy_ApproveFeeApplySummary.Visible = dt.Select("AppCode Like 'FNA_FeeApplyFlow%'").Length > 0; }
private string GetNeedMeApproveTaskIDs() { string taskids = ""; DataTable dt = EWF_Task_JobBLL.GetJobToDecision(int.Parse(Session["UserID"].ToString())); dt.DefaultView.RowFilter = "AppCode='FNA_FeeWriteoffFlow'"; if (dt.DefaultView.Count == 0) { return(""); } for (int i = 0; i < dt.DefaultView.Count; i++) { taskids += dt.DefaultView[i]["TaskID"].ToString() + ","; } if (taskids.EndsWith(",")) { taskids = taskids.Substring(0, taskids.Length - 1); } return(taskids); }