public ProductWithRowNoItem[] GetProjectsWithRowNumber(ProductWithRowNoItemArgs args) { List <SqlParameter> ps = new List <SqlParameter>(); StringBuilder sb = new StringBuilder(); sb.Append(@"SELECT * FROM( SELECT [pid] ,[name] ,[imagePath] ,ROW_NUMBER() OVER(order by sortNo DESC,updated DESC) rno FROM [dbo].[Product] p where 1=1 and enabled=1"); if (!String.IsNullOrWhiteSpace(args.ClassNo)) { sb.Append(" and p.classNo like @classNo"); ps.Add(new SqlParameter("classNo", args.ClassNo + "%")); } sb.Append(" ) AS tb where 1=1 "); if (args.MinRno.HasValue) { sb.Append(" and rno>=@MinRno"); ps.Add(new SqlParameter("MinRno", args.MinRno.Value)); } if (args.MaxRno.HasValue) { sb.Append(" and rno<=@MaxRno"); ps.Add(new SqlParameter("MaxRno", args.MaxRno.Value)); } if (args.Pid.HasValue) { sb.Append(" and pid=@pid"); ps.Add(new SqlParameter("pid", args.Pid.Value)); } return(Context.Database.SqlQuery <ProductWithRowNoItem>(sb.ToString(), ps.ToArray()).ToArray()); }
public Data.ProductWithRowNoItem[] GetProjectsWithRowNumber(Data.ProductWithRowNoItemArgs args) { return(_Repository.GetProjectsWithRowNumber(args)); }