/// <summary>
        /// 绑定数据
        /// </summary>
        /// <param name="pageIndex"></param>
        public void BindGrid(int pageIndex)
        {
            //工程状态必须走到了 整理接收 且没有入库 !=3722 才可以做补卷管理
            string strWhere = " AND D.WorkFlow_DoStatus >=(select WorkFlowID from T_WorkFlow where LOWER(WorkFlowCode)='" +
                              SystemSet.EumWorkFlowCode.WINRECV.ToString().ToLower() + "') and  d.Status!=3722 ";

            if (PublicModel.isSuperAdmin())  //管理员管理员获取所有工程
            {
                strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'";
            }
            else if (PublicModel.isArchiveUser())    //档案馆用户看自己的
            {
                strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'";
            }
            else
            {
                if (PublicModel.isLeader())     //建设单位只看到自己
                {
                    strWhere += " AND A.SingleProjectID in (select SingleProjectID from T_SingleProject  A,(select distinct ConstructionProjectID from T_Construction_Project ";
                    strWhere += " where CompanyID=" + Common.Session.GetSession("CompanyID") + ") B where A.ConstructionProjectID=B.ConstructionProjectID)";
                }
            }

            if (txtgcmc.Text.Trim().Length > 0)
            {
                strWhere += " AND D.gcmc LIKE '%" + txtgcmc.Text.Trim() + "%'";
            }
            if (txtgcbm.Text.Trim().Length > 0)
            {
                strWhere += " AND D.gcbm LIKE '%" + txtgcbm.Text + "%'";
            }
            if (txtajtm.Text.Trim().Length > 0)
            {
                strWhere += " AND A.ajtm like '%" + txtajtm.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 = archiveBLL.GetListPaging(strWhere, pageSize, pageIndex, out itemCount);;

            AspNetPager.AlwaysShow = true;
            AspNetPager.PageSize   = pageSize;

            AspNetPager.RecordCount      = itemCount;
            AspNetPager.CurrentPageIndex = pageIndex;

            rpData.DataSource = dt;
            rpData.DataBind();
        }
        protected void BindGrid(int pageIndex)
        {
            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"]);
            }

            Hashtable ht = new Hashtable();

            ht.Add("CompanyType", DNTRequest.GetQueryString("CompanyType"));
            if (txtCompanyName.Text.Trim().Length > 0)
            {
                ht.Add("CompanyName", txtCompanyName.Text.Trim());
            }

            if (PublicModel.isSuperAdmin())   //超级管理员
            {
                ht.Add("Area_Code", Common.Session.GetSession("AREA_CODE"));
            }
            else if (PublicModel.isArchiveUser())    //档案馆用户看自己的
            {
                ht.Add("Area_Code", Common.Session.GetSession("OLD_AREA_CODE"));
            }
            else if (PublicModel.isLeader())      //建设单位
            {
                ht.Add("Area_Code", Common.Session.GetSession("OLD_AREA_CODE"));
                if (DNTRequest.GetQueryInt("CompanyType", 0) == SystemSet._JSCOMPANYINFO)
                {
                    ht.Add("CompanyID", Common.Session.GetSession("CompanyID"));
                }
            }
            else
            {
                ht.Add("CompanyID", Common.Session.GetSession("CompanyID"));
            }

            DataTable dt = compBLL.GetListPaging(ht, pageSize, pageIndex, out itemCount);

            AspNetPager.AlwaysShow = true;
            AspNetPager.PageSize   = pageSize;

            AspNetPager.RecordCount      = itemCount;
            AspNetPager.CurrentPageIndex = pageIndex;

            rpData.DataSource = dt;
            rpData.DataBind();
        }
        int pageSize = 50;//SystemSet._PAGESIZE;

        protected void Page_Load(object sender, EventArgs e)
        {
            Ajax.Utility.RegisterTypeForAjax(typeof(Zxyys));
            singleProjectID = DNTRequest.GetQueryString("SingleProjectID");
            workFlowID      = DNTRequest.GetQueryString("WorkFlowID");

            if (!IsPostBack)
            {
                if (!PublicModel.isCompany() || PublicModel.isLeader())
                {
                    ddlCompany.DataBindEx(singleProjectID, string.Concat(SystemSet._JSCOMPANYINFO, ",",
                                                                         SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO));
                }
                else
                {
                    ddlCompany.DataBindEx(singleProjectID, Common.Session.GetSessionInt("CompanyID"));
                }
                ctrlProjectBaseInfo1.DataBindEx(singleProjectID);                     //工程信息
                rdbFileStatus.DataBindEx(true);
                ddlFileType.DataBindEx(Common.ConvertEx.ToInt(singleProjectID), "0", "BH");

                if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlCompany")))
                {
                    ddlCompany.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlCompany"));
                }
                if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlChangeFile")))
                {
                    ddlChangeFile.SelectedValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlChangeFile"));
                }
                if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlFileType")))
                {
                    ddlFileType.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlFileType")).ToUpper();
                }
                if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtTitle")))
                {
                    txtTitle.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtTitle"));
                }
                if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtMyCode")))
                {
                    txtMyCode.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtMyCode"));
                }
                if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("fileStatus")))
                {
                    rdbFileStatus.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("fileStatus"));
                }

                BindGridView(1);
            }
        }
 /// <summary>
 /// 绑定工程下所有业务单位
 /// </summary>
 protected void ddlSingleProject_MySelectChanged()
 {
     if (ddlSingleProject.SelectValue != "")
     {
         if (PublicModel.isLeader() || !PublicModel.isCompany())
         {
             ddlCompany.DataBindEx(ddlSingleProject.SelectValue, string.Concat(SystemSet._JSCOMPANYINFO, ",",
                                                                               SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO));
         }
         else
         {
             ddlCompany.DataBindEx(ddlSingleProject.SelectValue, Common.Session.GetSessionInt("CompanyID"));
         }
     }
 }
        /// <summary>
        /// 绑定数据
        /// </summary>
        /// <param name="pageIndex"></param>
        public void BindGrid(int pageIndex)
        {
            string strWhere = string.Empty;

            if (PublicModel.isLeader())     //建设单位只看到自己
            {
                strWhere += " AND A.SingleProjectID in (select SingleProjectID from T_SingleProject  A,(select distinct ConstructionProjectID from T_Construction_Project ";
                strWhere += " where CompanyID=" + Common.Session.GetSession("CompanyID") + ") B where A.ConstructionProjectID=B.ConstructionProjectID)";
            }

            if (txtgcmc.Text.Trim().Length > 0)
            {
                strWhere += " AND D.gcmc LIKE '%" + txtgcmc.Text.Trim() + "%'";
            }
            if (txtgcbm.Text.Trim().Length > 0)
            {
                strWhere += " AND D.gcbm LIKE '%" + txtgcbm.Text + "%'";
            }
            if (txtajtm.Text.Trim().Length > 0)
            {
                strWhere += " AND A.ajtm like '%" + txtajtm.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 = myArchiveBLL.GetListPaging(strWhere, pageSize, pageIndex, out itemCount);;

            AspNetPager.AlwaysShow = true;
            AspNetPager.PageSize   = pageSize;

            AspNetPager.RecordCount      = itemCount;
            AspNetPager.CurrentPageIndex = pageIndex;

            rpData.DataSource = dt;
            rpData.DataBind();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            //ddlCompany.MySelectChange += new DigiPower.Onlinecol.Standard.Web.CommonCtrl.ctrlDropDownCompanyInfo.SelectChange(ddlCompany_SelectedIndexChanged);
            Ajax.Utility.RegisterTypeForAjax(typeof(ZJList));

            singleProjectID = DNTRequest.GetQueryString("SingleProjectID");
            workFlowID      = DNTRequest.GetQueryString("WorkFlowID");
            projectType     = DNTRequest.GetQueryString("ProjectType");
            if (!this.IsPostBack)
            {
                if (!PublicModel.isCompany() || PublicModel.isLeader())
                {
                    ddlCompany.DataBindEx(singleProjectID, string.Concat(SystemSet._JSCOMPANYINFO, ",",
                                                                         SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO));
                }
                else
                {
                    ddlCompany.DataBindEx(singleProjectID, Common.Session.GetSessionInt("CompanyID"));
                }

                ctrlProjectBaseInfo1.DataBindEx(singleProjectID);                     //工程信息
                string CompanyID = Common.Session.GetSession("CompanyID");
                if (CompanyID != "")
                {
                    ddlCompany.SelectValue = CompanyID;
                    DataBindExMyCode(null);
                }
                boxType.DataBindEx();
                ajlx.DataBindEx();
                //mj.DataBindEx();
                //bgqx.DataBindEx();

                BindFileList();
                BindTreeYZJ();
            }
        }
Beispiel #7
0
        /// <summary>
        /// 绑定列表
        /// </summary>
        /// <param name="pageIndex"></param>
        private void BindGridView(int pageIndex)
        {
            StringBuilder strWhere = new StringBuilder();

            strWhere.Append(" 1=1 AND Status>=3721 AND WorkFlow_DoStatus=" + ViewState["workFlowID"].ToString());
            strWhere.Append(" AND ProjectType in (select SystemInfoCode from T_SystemInfo where SystemInfoID in(" + ProjectType + ")) ");

            if (kgsj1.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND kgsj>='" + kgsj1.Text.Trim() + " 00:00:00.00 ' ");
            }
            if (kgsj2.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND kgsj<='" + kgsj2.Text.Trim() + " 23:59:59.99' ");
            }
            if (jgsj1.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND jgsj>='" + jgsj1.Text.Trim() + " 00:00:00.00 ' ");
            }
            if (jgsj2.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND jgsj<='" + jgsj2.Text.Trim() + " 23:59:59.99' ");
            }
            if (txtGcbm.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND gcbm like '%" + txtGcbm.Text.Trim() + "%' ");
            }
            if (txtGcmc.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND gcmc like '%" + txtGcmc.Text.Trim() + "%' ");
            }
            if (txtGcdd.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND gcdd like '%" + txtGcdd.Text.Trim() + "%' ");
            }
            if (txtghxkzh.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND ghxkzh like '%" + txtghxkzh.Text.Trim() + "%' ");
            }
            if (txtsgxkzh.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND sgxkzh like '%" + txtsgxkzh.Text.Trim() + "%' ");
            }
            if (ddlChargeUserID.SelectValue != "" && ddlChargeUserID.SelectValue != "0")
            {
                strWhere.Append(" AND ChargeUserID= " + ddlChargeUserID.SelectValue);
            }

            if (PublicModel.isSuperAdmin())  //超级管理员
            {
                strWhere.Append(" AND Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%'");
            }
            else if (PublicModel.isArchiveUser())    //档案馆用户看自己的
            {
                strWhere.Append(" AND Area_Code like '" + ConvertEx.ToString(Session["OLD_AREA_CODE"]) + "%'");
            }
            else if (PublicModel.isLeader())    //工程管理员(建设单位)也看全部
            {
                strWhere.Append(" AND ConstructionProjectID in (select ConstructionProjectID from T_Construction_Project where CompanyID=" + Common.Session.GetSession("CompanyID") + ")");
            }

            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 = singleProjectBLL.GetListPaging(strWhere.ToString(), pageSize, pageIndex, out itemCount);;

            AspNetPager.AlwaysShow = true;
            AspNetPager.PageSize   = pageSize;

            AspNetPager.RecordCount      = itemCount;
            AspNetPager.CurrentPageIndex = pageIndex;

            rpData.DataSource = dt;
            rpData.DataBind();
        }
        /// <summary>
        /// 绑定签章单位相关信息
        /// </summary>
        /// <param name="pageIndex"></param>
        private void BindGridView(int pageIndex)
        {
            Hashtable ht = new Hashtable();

            if (ddlProjectType.SelectValue != "" && ddlProjectType.SelectValue != "0")
            {
                ht.Add("ProjectType", ddlProjectType.SelectValue);
            }
            if (kgsj1.Text.Trim().Length > 0)
            {
                ht.Add("kgsj", kgsj1.Text.Trim());
            }
            if (kgsj2.Text.Trim().Length > 0)
            {
                ht.Add("kgsj2", kgsj2.Text.Trim());
            }
            if (jgsj1.Text.Trim().Length > 0)
            {
                ht.Add("jgsj", jgsj1.Text.Trim());
            }
            if (jgsj2.Text.Trim().Length > 0)
            {
                ht.Add("jgsj2", jgsj2.Text.Trim());
            }
            if (txtGcbm.Text.Trim().Length > 0)
            {
                ht.Add("gcbm", txtGcbm.Text.Trim());
            }
            if (txtGcmc.Text.Trim().Length > 0)
            {
                ht.Add("gcmc", txtGcmc.Text.Trim());
            }
            if (txtGcdd.Text.Trim().Length > 0)
            {
                ht.Add("gcdd", txtGcdd.Text.Trim());
            }
            if (txtghxkzh.Text.Trim().Length > 0)
            {
                ht.Add("ghxkzh", txtghxkzh.Text.Trim());
            }
            if (txtsgxkzh.Text.Trim().Length > 0)
            {
                ht.Add("sgxkzh", txtsgxkzh.Text.Trim());
            }
            if (ddlChargeUserID.SelectValue != "" && ddlChargeUserID.SelectValue != "0")
            {
                ht.Add("ChargeUserID", ddlChargeUserID.SelectValue);
            }

            if (PublicModel.isSuperAdmin())        //超级管理员    Area_Code
            {
                ht.Add("NotInCompanyType", SystemSet._ARCHIVE);
                ht.Add("Area_Code", Common.Session.GetSession("AREA_CODE"));
            }
            else if (PublicModel.isArchiveUser())    //档案馆用户看自己的
            {
                ht.Add("NotInCompanyType", SystemSet._ARCHIVE);
                ht.Add("Area_Code", Common.Session.GetSession("OLD_AREA_CODE"));
            }
            else                                    //建设单位看自己相关的,监理,施工无权限
            {
                ht.Add("CompanyId", Common.Session.GetSession("CompanyId"));
                if (PublicModel.isLeader() || PublicModel.isSgCompany() || PublicModel.isJlCompany())
                {
                    ht.Add("InCompanyType", string.Concat(Common.Session.GetSession("CompanyType"), ",", SystemSet._SIGNATURECOMPANYINFO));
                }
            }

            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 = singleProjectBLL.GetListPaging(ht, pageSize, pageIndex, out itemCount);;

            AspNetPager.AlwaysShow = true;
            AspNetPager.PageSize   = pageSize;

            AspNetPager.RecordCount      = itemCount;
            AspNetPager.CurrentPageIndex = pageIndex;

            rpData.DataSource = dt;
            rpData.DataBind();
        }
        /// <summary>
        /// 绑定列表数据
        /// </summary>
        /// <param name="pageIndex"></param>
        private void BindGrid(int pageIndex)
        {
            StringBuilder strWhere = new StringBuilder();

            strWhere.Append(" 1=1 ");
            string CompanyID = "0";

            if (kgsj1.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND a.kgsj>='" + kgsj1.Text.Trim() + " 00:00:00.00 ' ");
            }
            if (kgsj2.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND a.kgsj<='" + kgsj2.Text.Trim() + " 23:59:59.99' ");
            }
            if (jgsj1.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND a.jgsj>='" + jgsj1.Text.Trim() + " 00:00:00.00 ' ");
            }
            if (jgsj2.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND a.jgsj<='" + jgsj2.Text.Trim() + " 23:59:59.99' ");
            }
            if (txtGcmc.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND a.gcmc like '%" + txtGcmc.Text.Trim() + "%' ");
            }
            if (txtGcdd.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND a.gcdd like '%" + txtGcdd.Text.Trim() + "%' ");
            }
            if (txtghxkzh.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND a.ghxkzh like '%" + txtghxkzh.Text.Trim() + "%' ");
            }
            if (txtsgxkzh.Text.Trim().Length > 0)
            {
                strWhere.Append(" AND a.sgxkzh like '%" + txtsgxkzh.Text.Trim() + "%' ");
            }
            if (ddlChargeUserID.SelectValue != "" && ddlChargeUserID.SelectValue != "0")
            {
                strWhere.Append(" AND a.ChargeUserID= " + ddlChargeUserID.SelectValue);
            }
            if (ddlProjectType.SelectValue != "" && ddlProjectType.SelectValue != "0")
            {
                strWhere.Append(" AND a.ProjectType=(select SystemInfoCode from T_SystemInfo where SystemInfoID=" + ddlProjectType.SelectValue + ") ");
            }
            if (ddl_WorkFlowName.SelectValue != "" && ddl_WorkFlowName.SelectValue != "0")
            {
                strWhere.Append(" AND d.WorkFlowID =" + ddl_WorkFlowName.SelectValue + " ");
            }

            if (PublicModel.isSuperAdmin())  //超级管理员看全部
            {
                strWhere.Append(" and a.Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%' ");
            }
            else if (PublicModel.isArchiveUser())    //档案馆的人看全部部分
            {
                strWhere.Append("and a.Area_Code = '" + ConvertEx.ToString(Session["OLD_AREA_CODE"]) + "' ");
            }
            else if (PublicModel.isLeader())    //工程管理员(建设单位)也看全部
            {
                CompanyID = Common.Session.GetSession("CompanyId");
            }
            else
            {
                CompanyID = "0";
                strWhere.Append(" AND EXISTS(select distinct SingleProjectID from T_SingleProjectCompany where ");
                strWhere.Append("CompanyID=" + Common.Session.GetSession("CompanyId") + " AND SingleProjectID=a.SingleProjectID )");
            }
            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 = singleProjectBLL.GetListPaging(ConvertEx.ToInt(CompanyID), strWhere.ToString(), pageSize, pageIndex, out itemCount);;

            AspNetPager.AlwaysShow = true;
            AspNetPager.PageSize   = pageSize;

            AspNetPager.RecordCount      = itemCount;
            AspNetPager.CurrentPageIndex = pageIndex;

            rpData.DataSource = dt;
            rpData.DataBind();
        }
Beispiel #10
0
        //绑定归档目录
        private void BindGridView(int pageIndex)
        {
            T_SingleProject_MDL spMDL = spBLL.GetModel(Common.ConvertEx.ToInt(singleProjectID));

            if (spMDL != null)
            {
                singleProjectNo = spMDL.gcbm;
                projecttype     = spMDL.ProjectType;

                //取当前工程的所有归档目录
                string strWhere = " SingleProjectID=" + singleProjectID;

                //不显示声像节点 //jdk 2014.11.16
                strWhere += " AND BH not like '%S%' ";

                if (PublicModel.isCompany() && !PublicModel.isLeader())   //监理或施工只能看到自己的
                {
                    strWhere += " and operateuserid=" + Common.Session.GetSession("UserID");
                }

                if (ConvertEx.ToBool(SystemSet._ISIGNATUREPDF))
                {
                    if (!string.IsNullOrWhiteSpace(ddliSignaturePdf.SelectedValue))
                    {
                        strWhere += " AND iSignaturePdf=" + ddliSignaturePdf.SelectedValue + "";   //是否需要签章
                    }
                    if (!string.IsNullOrWhiteSpace(ddlSignatureFinishFlag.SelectedValue))          //签章完成状态
                    {
                        string tempStrWhere        = " and iSignaturePdf=1 and IsFolder=0 and (SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID)>0 ";
                        int    signatureFinishFlag = ConvertEx.ToInt(ddlSignatureFinishFlag.SelectedValue); //签章是否完成标记 那已签章完成的记录跟需要签章的记录比对.
                        if (signatureFinishFlag == 1)                                                       //签章完成
                        {
                            tempStrWhere += "and (SELECT COUNT(1) from T_FileList_SignatureLog f0 where f0.FileListID=T_FileList.FileListID and f0.SignatureFinishFlag=1)";
                            tempStrWhere += ">=(SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID) ";
                            strWhere     += tempStrWhere;
                        }
                        else if (signatureFinishFlag == 0)    //签章未完成
                        {
                            tempStrWhere += "and (SELECT COUNT(1) from T_FileList_SignatureLog f0 where f0.FileListID=T_FileList.FileListID and f0.SignatureFinishFlag=1)";
                            tempStrWhere += "<(SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID) ";
                            strWhere     += tempStrWhere;
                        }
                    }
                }

                if (!String.IsNullOrWhiteSpace(txtMyCode.Text.Trim()))
                {
                    strWhere += " AND MyCode LIKE '%" + txtMyCode.Text.Trim() + "%'";
                }
                if (!String.IsNullOrWhiteSpace(txtTitle.Text.Trim()))
                {
                    strWhere += " AND TITLE LIKE '%" + txtTitle.Text.Trim() + "%'";
                }
                if (!String.IsNullOrWhiteSpace(rdbFileStatus.SelectValue) && rdbFileStatus.SelectValue != "0")
                {
                    strWhere += " AND Status=" + rdbFileStatus.SelectValue;
                }
                if (!String.IsNullOrWhiteSpace(ddlCompany.SelectValue) && ddlCompany.SelectValue != "0")
                {
                    T_Company_BLL compBLL = new T_Company_BLL();
                    T_Company_MDL compMDL = compBLL.GetModel(ConvertEx.ToInt(ddlCompany.SelectValue));
                    if (compMDL != null)
                    {
                        strWhere += " AND DefaultCompanyType=" + compMDL.CompanyType + "";
                    }
                }
                if (!String.IsNullOrWhiteSpace(ddlFileType.SelectValue) && ddlFileType.SelectValue != "0")
                {
                    strWhere += " AND BH like '" + ddlFileType.SelectValue + "%' ";
                }

                Session["FileInfostrWhere"] = strWhere;

                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 = fileListBLL.GetListPaging(strWhere, pageSize, pageIndex, out itemCount);;
                AspNetPager.AlwaysShow = true;
                AspNetPager.PageSize   = pageSize;

                AspNetPager.RecordCount      = itemCount;
                AspNetPager.CurrentPageIndex = pageIndex;

                rpData.DataSource = dt;
                rpData.DataBind();
            }
        }