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