private void BindList(WF_FORMBASE condObj, int curPage)
    {
        staff_id = getStaffID();
        if (wfid > 0)
        {
            condObj.WFID = wfid;
        }

        if (!string.IsNullOrEmpty(Request["TypeID"]))
        {
            List <WF_INFO> wflist = BLLTable <WF_INFO> .Factory(conn).Select(WF_INFO.Attribute.TYPE_ID, Request["TypeID"]);

            if (wflist != null)
            {
                string ids = "";
                for (int i = 0; i < wflist.Count; i++)
                {
                    ids += ids == "" ? wflist[i].WFID.ToString() : "," + wflist[i].WFID;
                }
                if (ids != "")
                {
                    condObj.In(WF_FORMBASE.Attribute.WFID, ids);
                }
            }
        }
        valObj.af_PageBy(WF_FORMBASE.Attribute.RECID, Order.Desc);

        listObj = BLLTable <WF_FORMBASE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);

        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
    }
    private void BindList(WF_FORMBASE condObj, int curPage)
    {
        staff_id = getStaffID();
        if (Request["mine"] != null||Request["mime"]!=null)
        {
            condObj.Where(" (CSTAFF_ID='" + staff_id + "' or STAFF_ID='" + staff_id + "')");
        }
        if (wfid > 0)
        {
            condObj.WFID = wfid;
        }
        if (Request["getType"] == "-1")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":");
            title = "�Ҳ���������б�";
        }
        if (Request["getType"] == "0")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":0");
            condObj.Where("STATUS='"+WFEnum.RecStatus.Checking.ToString("d")+"'");
            title = "���Ҵ���������б�";
        }
        else if (Request["getType"] == "1")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":1");
            title = "��ͨ���������б�";
        }
        else if (Request["getType"] == "2")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":2");
            title = "���˻ص������б�";
        }
        else if (Request["getType"] == "3")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":3");
            title = "��ֹͣ�������б�";
        }
        else if (Request["getType"] == "CK")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, staff_id + ":CK");
            title = "����˹��������б�";
        }

        if (!string.IsNullOrEmpty(Request["TypeID"]))
        {
            List<WF_INFO> wflist = BLLTable<WF_INFO>.Factory(conn).Select(WF_INFO.Attribute.TYPE_ID, Request["TypeID"]);
            if (wflist != null)
            {
                string ids = "";
                for (int i = 0; i < wflist.Count; i++)
                {
                    ids += ids == "" ? wflist[i].WFID.ToString() : "," + wflist[i].WFID;
                }
                if (ids != "")
                {
                    condObj.In(WF_FORMBASE.Attribute.WFID, ids);
                }
            }
        }
        valObj.af_PageBy(WF_FORMBASE.Attribute.RECID, Order.Desc);

        listObj = BLLTable<WF_FORMBASE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);

        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
    }
Example #3
0
    private void BindList(WF_FORMBASE condObj, int curPage)
    {
        staff_id = getStaffID();
        if (Request["mine"] != null || Request["mime"] != null)
        {
            condObj.Where(" (CSTAFF_ID='" + staff_id + "' or STAFF_ID='" + staff_id + "')");
        }
        if (wfid > 0)
        {
            condObj.WFID = wfid;
        }
        if (Request["getType"] == "-1")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":");
            title = "我参与的申请列表";
        }
        if (Request["getType"] == "0")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":0");
            condObj.Where("STATUS='" + WFEnum.RecStatus.Checking.ToString("d") + "'");
            title = "待我处理的申请列表";
        }
        else if (Request["getType"] == "1")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":1");
            title = "我通过的申请列表";
        }
        else if (Request["getType"] == "2")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":2");
            title = "我退回的申请列表";
        }
        else if (Request["getType"] == "3")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, ":" + staff_id + ":3");
            title = "我停止的申请列表";
        }
        else if (Request["getType"] == "CK")
        {
            condObj.Like(WF_FORMBASE.Attribute.CHECKERS, staff_id + ":CK");
            title = "我审核过的申请列表";
        }

        if (!string.IsNullOrEmpty(Request["TypeID"]))
        {
            List <WF_INFO> wflist = BLLTable <WF_INFO> .Factory(conn).Select(WF_INFO.Attribute.TYPE_ID, Request["TypeID"]);

            if (wflist != null)
            {
                string ids = "";
                for (int i = 0; i < wflist.Count; i++)
                {
                    ids += ids == "" ? wflist[i].WFID.ToString() : "," + wflist[i].WFID;
                }
                if (ids != "")
                {
                    condObj.In(WF_FORMBASE.Attribute.WFID, ids);
                }
            }
        }
        valObj.af_PageBy(WF_FORMBASE.Attribute.RECID, Order.Desc);

        listObj = BLLTable <WF_FORMBASE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);

        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
    }
    private void BindList(WF_FORMBASE condObj, int curPage)
    {
        staff_id = getStaffID();
        if (wfid > 0)
        {
            condObj.WFID = wfid;
        }

        if (!string.IsNullOrEmpty(Request["TypeID"]))
        {
            List<WF_INFO> wflist = BLLTable<WF_INFO>.Factory(conn).Select(WF_INFO.Attribute.TYPE_ID, Request["TypeID"]);
            if (wflist != null)
            {
                string ids = "";
                for (int i = 0; i < wflist.Count; i++)
                {
                    ids += ids == "" ? wflist[i].WFID.ToString() : "," + wflist[i].WFID;
                }
                if (ids != "")
                {
                    condObj.In(WF_FORMBASE.Attribute.WFID, ids);
                }
            }
        }
        valObj.af_PageBy(WF_FORMBASE.Attribute.RECID, Order.Desc);

        listObj = BLLTable<WF_FORMBASE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);

        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
    }