public List <TirePatternConfig> QueryTirePatternConfig(TirePatternConfigQuery query)
{
try
{
return(handlerReadOnly.QueryTirePatternConfig(query));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "QueryTirePatternConfig", ex);
Logger.Log(Level.Error, exception, "QueryTirePatternConfig");
throw ex;
}
}
public List <TirePatternConfig> QueryTirePatternConfig(TirePatternConfigQuery query)
{
Func <SqlConnection, List <TirePatternConfig> > action = (connection) => DalTirePatternConfig.QueryTirePatternConfig(connection, query);
return(dbManager.Execute(action));
}
public static List <TirePatternConfig> QueryTirePatternConfig(SqlConnection conn, TirePatternConfigQuery query)
{
string countSql = @"SELECT COUNT(1)
FROM Tuhu_productcatalog.[dbo].[TirePatternConfig] WITH ( NOLOCK )
WHERE IsDelete = 0 ";
string sql = @"SELECT *
FROM Tuhu_productcatalog.[dbo].[TirePatternConfig] WITH ( NOLOCK )
WHERE IsDelete = 0 ";
string addsql = string.Empty;
if (string.IsNullOrWhiteSpace(query.PatternCriterion))
{
if (!string.IsNullOrWhiteSpace(query.BrandCriterion))
{
addsql = "and CP_Brand like N'%" + query.BrandCriterion + "%'";
}
}
else
{
if (!string.IsNullOrWhiteSpace(query.BrandCriterion))
{
addsql = "and CP_Brand like N'%" + query.BrandCriterion + "%' and Tire_Pattern like N'%" + query.PatternCriterion + "%'";
}
else
{
addsql = "and Tire_Pattern like N'%" + query.PatternCriterion + "%'";
}
}
sql = sql + addsql +
@" ORDER BY LastUpdateDateTime desc OFFSET @pagesdata ROWS FETCH NEXT @pagedataquantity ROWS ONLY";
countSql = countSql + addsql;
var sqlParam = new[]
{
new SqlParameter("@pagesdata", (query.PageIndex - 1) * query.PageDataQuantity),
new SqlParameter("@pagedataquantity", query.PageDataQuantity),
};
query.TotalCount = (int)SqlHelper.ExecuteScalar(conn, CommandType.Text, countSql, sqlParam);
return(SqlHelper.ExecuteDataTable(conn, CommandType.Text, sql, sqlParam).ConvertTo <TirePatternConfig>().ToList());
}
