/// <summary>
/// 根据用户查询任务
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="pagination"></param>
/// <param name="paras"></param>
/// <returns></returns>
public IEnumerable <T> QryTask <T>(Pagination pagination, Dictionary <string, object> paras)
{
if (pagination.sidx == null || pagination.sidx == "")
{
pagination.sidx = "ProjectId";
}
bool boo = pagination.sidx.IndexOf("ProjectId", StringComparison.OrdinalIgnoreCase) >= 0;
if (!boo)
{
pagination.sidx = "ProjectId," + pagination.sidx;
}
WhereBuilder builder = new WhereBuilder();
builder.FromSql = "fun_userTask(@userName)";
builder.AddParameter("userName", paras["userName"]);
builder.AddWhereAndParameter(paras, "ProjectId");
int tag = int.Parse(paras["qryTag"].ToString());
if (tag == 1)
{
builder.AddWhere(" CreateBy = @userName");
}
if (tag == 2)
{
builder.AddWhere(" FinishBy = @userName");
}
return(SortAndPage <T>(builder, pagination));
}
/// <summary>
/// 查询用户列表
/// </summary>
/// <typeparam name="T">数据集</typeparam>
/// <param name="pagination">分页信息</param>
/// <param name="paras">查询条件参数</param>
/// <returns></returns>
public IEnumerable <T> QryUsers <T>(Pagination pagination, Dictionary <string, object> paras)
{
WhereBuilder builder = new WhereBuilder();
builder.FromSql = "v_user_list";
if (paras.ContainsKey("keyword"))
{
builder.AddWhere(" (AccountName Like '%'+@keyword+'%' OR RealName Like '%'+@keyword+'%')");
builder.AddParameter("keyword", paras["keyword"]);
}
var rows = SortAndPage <T>(builder, pagination);
return(rows);
}