public List <TireSpecParamsModel> QueryTireSpecParamsModel(TireSpecParamsConfigQuery query)
{
try
{
return(handlerReadOnly.QueryTireSpecParamsModel(query));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "QueryTireSpecParamsModel", ex);
Logger.Log(Level.Error, exception, "QueryTireSpecParamsModel");
throw ex;
}
}
public static List <TireSpecParamsModel> QueryTireSpecParamsModel(SqlConnection conn, TireSpecParamsConfigQuery query)
{
string countSql = @"SELECT Count(1)
FROM Tuhu_productcatalog..vw_Products as vwP WITH ( NOLOCK)
left join [Configuration].dbo.tbl_TireSpecParamsConfig as tsPC with (nolock)
on vwP.PID=tsPC.PId
WHERE ";
string sql = @"SELECT vwP.PID as ProductID,DisplayName,TireSize,tsPC.*
FROM Tuhu_productcatalog..vw_Products as vwP WITH ( NOLOCK)
left join [Configuration].dbo.tbl_TireSpecParamsConfig as tsPC with (nolock)
on vwP.PID=tsPC.PId
WHERE ";
string addsql;
if (string.IsNullOrWhiteSpace(query.PIDCriterion))
{
if (string.IsNullOrWhiteSpace(query.DisplayNameCriterion))
{
addsql = @"vwP.PID like 'TR%'";
}
else
{
addsql = @"vwP.PID like 'TR%' and vwP.DisplayName like N'%" + query.DisplayNameCriterion + "%'";
}
}
else
{
if (string.IsNullOrWhiteSpace(query.DisplayNameCriterion))
{
addsql = @"vwP.PID like 'TR%' and vwP.PID like N'%" + query.PIDCriterion + "%'";
}
else
{
addsql = @"vwP.PID like 'TR%' and vwP.PID like N'%" + query.PIDCriterion + "%' and vwP.DisplayName like N'%" + query.DisplayNameCriterion + "%'";
}
}
sql = sql + addsql +
@" ORDER BY vwP.PID ASC 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 <TireSpecParamsModel>().ToList());
}
public List <TireSpecParamsModel> QueryTireSpecParamsModel(TireSpecParamsConfigQuery query)
{
Func <SqlConnection, List <TireSpecParamsModel> > action = (connection) => DalTireSpecParamsConfig.QueryTireSpecParamsModel(connection, query);
return(dbManager.Execute(action));
}
