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