public int GetCount(QueryBySingleRequest request, ReposityEntity re)
{
string sql = Common.GetSqlPlusSort(request, re.Items[ReposityEntity.FalgQueryCountEntity]);
IList<SqlParams> sqlparams = Common.GetSqlParams(request);
object obj = SQLHelper.ExecuteScalar(re.OwnerService, sql, sqlparams);
return int.Parse(obj.ToString());
}
public CommandResponse Execute(CommandRequest request, ReposityEntity re, string itemKey = null)
{
if (string.IsNullOrWhiteSpace(itemKey))
itemKey = ReposityEntity.FalgQuerySingleEntity;
string sql = re.Items[itemKey];
IList<SqlParams> sqlparams = Common.GetSqlParams(request);
CommandResponse response = new CommandResponse();
if (request.TrueScalar_FalseIntByResult)
response.ResultValue = SQLHelper.ExecuteScalar(re.OwnerService, sql, sqlparams);
else
response.ResultValue = SQLHelper.ExecuteNonQuery(re.OwnerService, sql, sqlparams);
return response;
}
