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