Exemple #1
0
 public List<BusinessPartner> GetAll(string name)
 {
     BusinessPartnerService bpService = new BusinessPartnerService();
     List<BusinessPartner> list = new List<BusinessPartner>();
     List<object> parameters = new List<object>();
     string queryStr = "it.IsDeleted = false and (it.ApproveStatus = " + (int)ApproveStatus.Approved + " or it.ApproveStatus = " + (int)ApproveStatus.NoApproveNeeded + ")";
     if (!string.IsNullOrEmpty(name))
     {
         queryStr += " and it.ShortName Like @p1";
         parameters.Add("%" + name + "%");
     }
     list = bpService.Query(queryStr, parameters.Count > 0 ? parameters : null).ToList();
     return list;
 }