/// <summary>
/// 按照查询条件查询 分页
/// </summary>
/// <param name="queryProjectTask_Employee">查询值对象，用来存放查询条件</param>
/// <param name="currentPage">页号,-1不分页</param>
/// <param name="totalCount">总行数</param>
/// <param name="pageSize">每页记录数</param>
/// <returns>销售网络集合</returns>
public DataTable GetProjectTask_Employee(QueryProjectTask_Employee query, string order, int currentPage, int pageSize, out int totalCount)
{
string where = "";
if (query.Source != Constant.INT_INVALID_VALUE)
{
where += " And t.Source =" + query.Source;
}
if (query.RelationID != Constant.STRING_INVALID_VALUE)
{
where += " And t.RelationID ='" + StringHelper.SqlFilter(query.RelationID) + "'";
}
if (query.Status != Constant.INT_INVALID_VALUE)
{
where += " And te.Status =" + query.Status;
}
//if (query.PTID != Constant.STRING_INVALID_VALUE)
//{
// where += "and te.PTID='" + query.PTID + "'";
//}
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.VarChar, 8000),
new SqlParameter("@order", SqlDbType.VarChar, 200),
new SqlParameter("@page", SqlDbType.Int, 4),
new SqlParameter("@pagesize", SqlDbType.Int, 4),
new SqlParameter("@TotalRecorder", SqlDbType.Int, 4)
};
parameters[0].Value = where;
parameters[1].Value = order;
parameters[2].Value = currentPage;
parameters[3].Value = pageSize;
parameters[4].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_EMPLOYEE_SELECT, parameters);
totalCount = int.Parse(parameters[4].Value.ToString());
return(ds.Tables[0]);
}
public DataTable GetProjectTask_Employee(QueryProjectTask_Employee query, string order, int currentPage, int pageSize, out int totalCount)
{
return(Dal.ProjectTask_Employee.Instance.GetProjectTask_Employee(query, order, currentPage, pageSize, out totalCount));
}
