/// <summary> /// 返回我的单据实体列表[longkc] /// </summary> /// <param name="pageIndex"></param> /// <param name="strOrderBy"></param> /// <param name="checkstate"></param> /// <param name="filterString"></param> /// <param name="ownerid"></param> /// <param name="Isforward"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="pageCount"></param> /// <returns></returns> public List<T_PF_PERSONALRECORD> GetPersonalRecordListNew(int pageIndex, string strOrderBy, string checkstate, string filterString, string ownerid, string Isforward, string BeginDate, string EndDate, ref int pageCount) { PersonalRecordDAL dal = new PersonalRecordDAL(); string filter = ""; if (!string.IsNullOrEmpty(checkstate)) { filter += " AND CHECKSTATE=" + checkstate + ""; } if (!string.IsNullOrEmpty(ownerid)) { filter += " AND OWNERID='" + ownerid + "'"; } if (!string.IsNullOrEmpty(Isforward)) { filter += " AND ISFORWARD=" + Isforward + ""; } if (!string.IsNullOrEmpty(BeginDate)) { filter += " AND createdate>=to_date('" + BeginDate + "','yyyy-MM-dd')"; } if (!string.IsNullOrEmpty(EndDate)) { filter += " AND createdate<=to_date('" + EndDate + "','yyyy-MM-dd')"; } if (!string.IsNullOrEmpty(filterString)) { filter += filterString; } return dal.GetPersonalRecordList(Config.pageSize, filter, pageIndex, strOrderBy, ref pageCount); }
/// <summary> /// 返回我的单据实体列表(未提交,转发两种状态的) /// </summary> /// <param name="pageIndex"></param> /// <param name="strOrderBy"></param> /// <param name="checkstate"></param> /// <param name="filterString"></param> /// <param name="strCreateID"></param> /// <param name="Isforward"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="pageCount"></param> /// <returns></returns> public List<T_PF_PERSONALRECORD> GetPersonalRecordList(int pageIndex, string strOrderBy, string checkstate, string filterString, string strCreateID, string Isforward, string BeginDate, string EndDate, ref int pageCount) { PersonalRecordDAL dal = new PersonalRecordDAL(); string filter = ""; if (!string.IsNullOrEmpty(checkstate)) { filter += " AND CHECKSTATE=" + checkstate + ""; } if (!string.IsNullOrEmpty(strCreateID)) { filter += " AND OWNERID='" + strCreateID + "'"; } if (!string.IsNullOrEmpty(Isforward)) { filter += " AND ISFORWARD=" + Isforward + ""; } if (!string.IsNullOrEmpty(filterString)) { filter += filterString; } return dal.GetPersonalRecordList(Config.pageSize, filter, pageIndex, strOrderBy, ref pageCount); }