public QueryByMoreResponse <TDto> Gets(QueryByMoreRequest request, ReposityEntity re)
{
QueryByMoreResponse <TDto> result = new QueryByMoreResponse <TDto>();
result.TotalRowCount = this.GetCount(request, re);
string sql = Common.GetSqlPlusSort(request, re.Items[ReposityEntity.FalgQueryMoreEntity]);
IList <SqlParams> sqlparams = Common.GetSqlParams(request);
if (!request.IsPaging)
{
result.Rows = SQLHelper.Gets <TDto>(SQLHelper.ExecuteIDataReader(re.OwnerService, sql, sqlparams));
}
else
{
if (!request.IsCachePage)
{
result.Rows = SQLHelper.Gets <TDto>(SQLHelper.ExecuteIDataReader(re.OwnerService, sql, sqlparams),
request.PageIndex,
request.PageSize);
}
else
{
result.Rows = SQLHelper.Gets <TDto>(SQLHelper.ExecuteIDataReader(re.OwnerService, sql, sqlparams),
request.PageIndex,
request.PageSize,
request.CahcePageCount);
}
}
return(result);
}
public IList <CrossCell> GetRows()
{
QueryByMoreRequest request = new QueryByMoreRequest()
{
};
QueryByMoreResponse <CrossCell> response = new QueryByMore <CrossCell>().Gets(request, ReposityEntityFactory.Items[Flag]);
return(response.Rows);
}
public IList <Project> GetProjects()
{
QueryByMoreRequest request = new QueryByMoreRequest()
{
};
QueryByMoreResponse <Project> response = new QueryByMore <Project>().Gets(request, ReposityEntityFactory.Items[Flag]);
return(response.Rows);
}
public QueryByMoreResponse <TDto> Gets(QueryByMoreRequest request)
{
if (string.IsNullOrWhiteSpace(request.Guid)
||
!ReposityEntityFactory.Items.ContainsKey(request.Guid)
)
{
throw new Exception("Error: requestGuid is null or is not exists! ");
}
return(this.Gets(request, ReposityEntityFactory.Items[request.Guid]));
}
public IList <CrossCell> GetRows(QueryByCrossGuidesCellRequest r)
{
QueryByMoreRequest request = new QueryByMoreRequest()
{
Params = new List <RequestParameter>()
{
new RequestParameter()
{
Name = "@top", Value = r.Top.ToString(), Type = "int"
},
}
};
QueryByMoreResponse <CrossCell> response = new QueryByMore <CrossCell>().Gets(request, ReposityEntityFactory.Items[Flag]);
return(response.Rows);
}
/// <summary>
/// 得到项目列表
/// </summary>
/// <param name="usercode"></param>
/// <returns></returns>
public IList <CrossProject> GetRows(string usercode)
{
QueryByMoreRequest request = new QueryByMoreRequest()
{
Params = new List <RequestParameter>()
{
new RequestParameter()
{
Name = "@usercode", Value = usercode, Type = "string"
},
}
};
QueryByMoreResponse <CrossProject> response = new QueryByMore <CrossProject>().Gets(request, ReposityEntityFactory.Items[Flag]);
return(response.Rows);
}
public IList <Answer> GetRows(string examanswerguid)
{
QueryByMoreRequest request = new QueryByMoreRequest()
{
Params = new List <RequestParameter>()
{
new RequestParameter()
{
Name = "@examanswerguid", Value = examanswerguid, Type = "string",
}
},
};
QueryByMoreResponse <Answer> response = new QueryByMore <Answer>().Gets(request, ReposityEntityFactory.Items[Flag]);
return(response.Rows);
}
public IList <ExamQuestion> GetRows(string ownertype)
{
QueryByMoreRequest request = new QueryByMoreRequest()
{
Params = new List <RequestParameter>()
{
new RequestParameter()
{
Name = "@ownertype", Value = ownertype, Type = "string",
}
},
};
QueryByMoreResponse <ExamQuestion> response = new QueryByMore <ExamQuestion>().Gets(request, ReposityEntityFactory.Items[Flag]);
return(response.Rows);
}
public IList <CrossCell> GetRows(QueryByCrossProjectNodeFilesKMExtendRequest r)
{
QueryByMoreRequest request = new QueryByMoreRequest()
{
Params = new List <RequestParameter>()
{
new RequestParameter()
{
Name = "@usercode", Value = r.UserCode, Type = "string"
},
new RequestParameter()
{
Name = "@project", Value = r.Project, Type = "string"
},
new RequestParameter()
{
Name = "@top", Value = r.Top.ToString(), Type = "int"
},
}
};
QueryByMoreResponse <CrossCell> response = new QueryByMore <CrossCell>().Gets(request, ReposityEntityFactory.Items[Flag]);
return(response.Rows);
}
public QueryByMoreResponse <User> Gets(QueryByMoreRequest request)
{
return(new QueryByMore <User>().Gets(request, SRRDBMS.ReposityEntityFactory.Items[Flag]));
}
public QueryByMoreResponse <CustomerRegister> Gets(QueryByMoreRequest request)
{
return(new QueryByMore <CustomerRegister>().Gets(request, ReposityEntityFactory.Items[Flag]));
}
public QueryByMoreResponse <Workflow> Gets(QueryByMoreRequest request)
{
return(new QueryByMore <Workflow>().Gets(request));
}
