public List<OrderEntity> SearchOrder(OrderSearchEntity searchObject) { List<OrderEntity> result = null; string sqlStatement = "SELECT " + Environment.NewLine + "[Order].OrderId," + Environment.NewLine + "[Order].OrderType," + Environment.NewLine + "[Order].BusinessId," + Environment.NewLine + "[Order].IndustryId," + Environment.NewLine + "[Order].CreatedBy," + Environment.NewLine + "[Order].ResponsibleBy," + Environment.NewLine + "[Order].OrderDate," + Environment.NewLine + "[Order].CreatedDate," + Environment.NewLine + "[Order].CompanyId," + Environment.NewLine + "[Order].LocationId," + Environment.NewLine + "[Order].CustomerCompanyId," + Environment.NewLine + "[Order].CustomerContactId," + Environment.NewLine + "[Order].OrderNumber," + Environment.NewLine + "[Order].Description," + Environment.NewLine + "[Order].OrderStatus," + Environment.NewLine + "Company.Description as CustomerCompanyName," + Environment.NewLine + "Location.Description as LocationName," + Environment.NewLine + "Business.Description as BusinessName," + Environment.NewLine + "Industry.Description as IndustryName," + Environment.NewLine + "Contact.FullName as CustomerContactName," + Environment.NewLine + "ResponsibleContact.FullName as ResponsibleContactName" + Environment.NewLine + "FROM [Order] join Company on [Order].CustomerCompanyId = Company.CompanyId " + Environment.NewLine + "left join Contact on [Order].CustomerContactId = Contact.ContactId" + Environment.NewLine + "left join Contact ResponsibleContact on [Order].ResponsibleBy = ResponsibleContact.ContactId" + Environment.NewLine + "left join Location on [Order].LocationId = Location.LocationId" + Environment.NewLine + "join Business on [Order].BusinessId = Business.BusinessId" + Environment.NewLine + "join Industry on [Order].IndustryId = Industry.IndustryId" + Environment.NewLine + "WHERE 1=1 " + Environment.NewLine; if (searchObject.SearchText != null && searchObject.SearchText.Length > 0) { sqlStatement += "AND ([Order].OrderNumber LIKE N'%" + searchObject.SearchText + "%' OR [Order].Description LIKE N'%" + searchObject.SearchText + "%')" + Environment.NewLine; } if (searchObject.BusinessId > 0) { sqlStatement += "AND [Order].BusinessId=" + searchObject.BusinessId + Environment.NewLine; } if (searchObject.IndustryId > 0) { sqlStatement += "AND [Order].IndustryId=" + searchObject.IndustryId + Environment.NewLine; } if (searchObject.OrderType > 0) { sqlStatement += "AND [Order].OrderType=" + searchObject.OrderType + Environment.NewLine; } //if (searchObject.FromOrderDate != null) //{ // sqlStatement += "AND Order.OrderDate>=" + searchObject.FromOrderDate + Environment.NewLine; //} //if (searchObject.ToOrderDate != null) //{ // sqlStatement += "AND Order.OrderDate<=" + searchObject.ToOrderDate + Environment.NewLine; //} //execute result = Connection.Query<OrderEntity>(sqlStatement).ToList(); return result; }
public List<OrderEntity> SearchOrder(OrderSearchEntity searchObject) { //execute using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance()) { try { db.OpenConnection(); return db.Resolve<IOrderDB>().SearchOrder(searchObject); } finally { db.CloseConnection(); } } }
public List<OrderEntity> SearchOrder(OrderSearchEntity searchObject) { return Factory.Resolve<IOrderBL>().SearchOrder(searchObject); }