public WF_FORMBASE GetCondObj()
    {
        WF_FORMBASE ccc = new WF_FORMBASE();
        if (txtRECNO.Value != "")
            ccc.Like(WF_FORMBASE.Attribute.RECNO, Convert.ToString(txtRECNO.Value));

        if (txtDEPT_NAME.Value != "")
            ccc.Like(WF_FORMBASE.Attribute.DEPT_NAME, Convert.ToString(txtDEPT_NAME.Value));

        if (txtSTAFF_NAME.Value != "")
            ccc.Like(WF_FORMBASE.Attribute.STAFF_NAME, Convert.ToString(txtSTAFF_NAME.Value));

        if (txtCSTAFF_NAME.Value != "")
            ccc.Like(WF_FORMBASE.Attribute.CSTAFF_NAME, Convert.ToString(txtCSTAFF_NAME.Value));

        if (txtSTATUS.Value != "")
            ccc.STATUS = Convert.ToString(txtSTATUS.Value);

        hidCondition.Value = ccc.ToJson(20);

        return ccc;
    }
Beispiel #2
0
    public WF_FORMBASE GetCondObj()
    {
        WF_FORMBASE ccc = new WF_FORMBASE();

        if (txtRECNO.Value != "")
        {
            ccc.Like(WF_FORMBASE.Attribute.RECNO, Convert.ToString(txtRECNO.Value));
        }

        if (txtDEPT_NAME.Value != "")
        {
            ccc.Like(WF_FORMBASE.Attribute.DEPT_NAME, Convert.ToString(txtDEPT_NAME.Value));
        }


        if (txtSTAFF_NAME.Value != "")
        {
            ccc.Like(WF_FORMBASE.Attribute.STAFF_NAME, Convert.ToString(txtSTAFF_NAME.Value));
        }



        if (txtCSTAFF_NAME.Value != "")
        {
            ccc.Like(WF_FORMBASE.Attribute.CSTAFF_NAME, Convert.ToString(txtCSTAFF_NAME.Value));
        }

        if (txtSTATUS.Value != "")
        {
            ccc.STATUS = Convert.ToString(txtSTATUS.Value);
        }

        hidCondition.Value = ccc.ToJson(20);

        return(ccc);
    }
Beispiel #3
0
    private void BindList(WF_FORMBASE condObj, int curPage)
    {
        staff_id = getStaffID();
        if (Request["mine"] != null)
        {
            condObj.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");
            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 = "我停止的申请列表";
        }
        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;
    }
Beispiel #5
0
    private void BindList(WF_FORMBASE condObj, int curPage)
    {
        staff_id = getStaffID();
        if (Request["mine"] != null)
        {
            condObj.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");
            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 = "��ֹͣ�������б�";
        }
        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;
    }