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)); }