/// <summary> /// /// 只显示已转换PDF的文件+文件登记的工程 /// </summary> /// <param name="pageIndex"></param> private void BindGridView(int pageIndex) { string strWhere = " SingleProjectID=" + hid_SingleProjectID.Value + " AND BH not like '%S%' "; strWhere += " AND iSignaturePdf=1 ";//需要签章 strWhere += " AND CONVERT_FLAG=1 AND exists (SELECT SingleProjectID FROM T_SingleProject where T_FileList.SingleProjectID=T_SingleProject.SingleProjectID and "; strWhere += " WorkFlow_DoStatus=" + DNTRequest.GetQueryString("WorkFlow_DoStatus") + ")"; if (PublicModel.isSignatureCompany()) { strWhere += "AND (IsFolder=0 AND OldRecID IN( "; strWhere += "SELECT b1.FileListID FROM T_FileList_SignatureTmp b1,( "; strWhere += "SELECT RoleCode from T_Role where RoleID=" + Common.Session.GetSession("RoleID") + " ) b2 WHERE b1.SignatureType=b2.RoleCode )) "; } if (txtTitle.Text.Trim().Length > 0) { strWhere += " and Title like '%" + txtTitle.Text.Trim() + "%'"; } if (txtWth.Text.Trim().Length > 0) { strWhere += " and w_t_h like '%" + txtWth.Text.Trim() + "%'"; } if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0) { pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")); ViewState["CurrentPageIndex"] = pageIndex; } else { pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]); } DataTable dt = fileBLL.GetLHSignatureFilesList(Common.Session.GetSession("UserID"), strWhere, pageSize, pageIndex, out itemCount); AspNetPager.AlwaysShow = true; AspNetPager.PageSize = pageSize; AspNetPager.RecordCount = itemCount; AspNetPager.CurrentPageIndex = pageIndex; gvData.DataSource = dt; gvData.DataBind(); }