public int GetSpecificWordRow(string manufacturer, string keywords) { using (DefaultConnection db = new DefaultConnection()) { SQLWhereString whereString = new SQLWhereString(); string where = whereString.SearchKeyWhere <ReadableProduct>(db, keywords); int openManufacturer_Id = ManufacturerData.NameToId(db, manufacturer)[0]; int closeManufacturer_Id = ManufacturerData.NameToId(db, manufacturer)[1]; if (!String.IsNullOrEmpty(keywords)) { var anonymous = db.Database .SqlQuery <ReadableProduct>(where) .ToList(); return(anonymous .Where(a => a.Manufacturer_Id >= openManufacturer_Id && a.Manufacturer_Id <= closeManufacturer_Id) .Count()); } else { return(db.ReadableProducts .Where(rp => rp.Manufacturer_Id >= openManufacturer_Id && rp.Manufacturer_Id <= closeManufacturer_Id) .Count()); } } }
public List <ReadableProductAttribute> GetSpecificWordGroup(string businessPartner, string manufacturer, string keywords) { using (DefaultConnection db = new DefaultConnection()) { SQLWhereString whereString = new SQLWhereString(); string where = whereString.SearchKeyWhere <ReadableProductAttribute>(db, keywords); int openManufacturer_Id = ManufacturerData.NameToId(db, manufacturer)[0]; int closeManufacturer_Id = ManufacturerData.NameToId(db, manufacturer)[1]; int openBusinessPertner_Id = BusinessPartnerData.NameToId(db, businessPartner)[0]; int closeBusinessPertner_Id = BusinessPartnerData.NameToId(db, businessPartner)[1]; if (!String.IsNullOrEmpty(keywords)) { var anonymous = db.Database .SqlQuery <ReadableProductAttribute>(where) .ToList(); return(anonymous .Where(a => a.Manufacturer_Id >= openManufacturer_Id && a.Manufacturer_Id <= closeManufacturer_Id && a.BusinessPartner_Id >= openBusinessPertner_Id && a.BusinessPartner_Id <= closeBusinessPertner_Id) .ToList()); } else { return(db.ReadableProductAttributes .Where(ra => ra.Manufacturer_Id >= openManufacturer_Id && ra.Manufacturer_Id <= closeManufacturer_Id && ra.BusinessPartner_Id >= openBusinessPertner_Id && ra.BusinessPartner_Id <= closeBusinessPertner_Id) .ToList()); } } }