public List <ProductNew> getProductByProductTypeId(string RestaurantId, string ProductTypeId) { if (string.IsNullOrEmpty(RestaurantId) || string.IsNullOrEmpty(ProductTypeId)) { Logger.Log("RestaurantId= " + RestaurantId + ",ProductTypeId= " + ProductTypeId); } List <ProductNew> list = null; try { IParameterMapper ipmapper = new getProductByProductTypeIdParameterMapper(); DataAccessor <ProductNew> tableAccessor; string strSql = @" select b.Id,b.ProductName ,b.ProductType ,b.Code ,b.PinYin ,b.Unit ,b.MinUnit ,b.MinCount ,b.Price ,b.BarCode ,b.Status ,b.RestaurantId ,b.Type ,b.MaterialId ,b.IsDiscount ,b.MemberPrice,cl.CodeTypeListName ,pf.LoveCount,pf.Count,pf.Hot,pf.Description ,pf.Popular from Product b left join ProductConfigure pf on pf.ProductId=b.Id, S_CodeList cl where 1=1 and b.Status=1 and b.IsPause=0 and cl.CodeTypeListValue=b.Unit and cl.CodeType='ProductUnit' and not exists(select 1 from productsisbook pb where b.id=pb.Productid and pb.isbook=0 ) and b.RestaurantId=@RestaurantId and b.ProductType=@ProductTypeId order by b.IsDiscount asc"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <ProductNew> . MapAllProperties().Build()); list = tableAccessor.Execute(new string[] { RestaurantId, ProductTypeId }).ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }
public List<ProductNew> getProductByProductTypeId(string RestaurantId, string ProductTypeId) { if (string.IsNullOrEmpty(RestaurantId) || string.IsNullOrEmpty(ProductTypeId)) { Logger.Log("RestaurantId= " + RestaurantId + ",ProductTypeId= " + ProductTypeId); } List<ProductNew> list = null; try { IParameterMapper ipmapper = new getProductByProductTypeIdParameterMapper(); DataAccessor<ProductNew> tableAccessor; string strSql = @" select b.Id,b.ProductName ,b.ProductType ,b.Code ,b.PinYin ,b.Unit ,b.MinUnit ,b.MinCount ,b.Price ,b.BarCode ,b.Status ,b.RestaurantId ,b.Type ,b.MaterialId ,b.IsDiscount ,b.MemberPrice,cl.CodeTypeListName ,pf.LoveCount,pf.Count,pf.Hot,pf.Description ,pf.Popular from Product b left join ProductConfigure pf on pf.ProductId=b.Id, S_CodeList cl where 1=1 and b.Status=1 and b.IsPause=0 and cl.CodeTypeListValue=b.Unit and cl.CodeType='ProductUnit' and not exists(select 1 from productsisbook pb where b.id=pb.Productid and pb.isbook=0 ) and b.RestaurantId=@RestaurantId and b.ProductType=@ProductTypeId order by b.IsDiscount asc"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<ProductNew>. MapAllProperties().Build()); list = tableAccessor.Execute(new string[] { RestaurantId, ProductTypeId }).ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }