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; }
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; }