public List<GenericBusinessPartner> GetAll() { StringBuilder oSQL = new StringBuilder(); oSQL.Append("SELECT CardCode,CardName FROM OCRD T0 where WtLiable= 'Y'"); DbCommand myCommand = this.dataBase.GetSqlStringCommand(oSQL.ToString()); List<GenericBusinessPartner> partners = new List<GenericBusinessPartner>(); using (this.reader = this.dataBase.ExecuteReader(myCommand)) { while (this.reader.Read()) { GenericBusinessPartner partner = new GenericBusinessPartner(); partner.cardCode = this.reader.IsDBNull(0) ? "" : this.reader.GetValue(0).ToString(); partner.cardName = this.reader.IsDBNull(1) ? "" : this.reader.GetValue(1).ToString(); partners.Add(partner); } } return partners; }
public List<GenericBusinessPartner> GetList(CardType cardType) { StringBuilder oSQL = new StringBuilder(); oSQL.Append("SELECT CardCode, CardName, listNum FROM OCRD T0 "); switch (cardType) { case CardType.Customer: oSQL.Append(string.Format("where CardType = '{0}' and WtLiable= 'Y' ", "C")); break; case CardType.Supplier: oSQL.Append(string.Format("where CardType = '{0}' and WtLiable= 'Y' ", "S")); break; case CardType.Lead: oSQL.Append(string.Format("where CardType = '{0}' ", "L")); break; default: break; } DbCommand myCommand = this.dataBase.GetSqlStringCommand(oSQL.ToString()); List<GenericBusinessPartner> partners = new List<GenericBusinessPartner>(); using (this.reader = this.dataBase.ExecuteReader(myCommand)) { while (this.reader.Read()) { GenericBusinessPartner partner = new GenericBusinessPartner(); partner.cardCode = this.reader.IsDBNull(0) ? "" : this.reader.GetValue(0).ToString(); partner.cardName = this.reader.IsDBNull(1) ? "" : this.reader.GetValue(1).ToString(); partner.listNum = this.reader.IsDBNull(1) ? 1 : int.Parse(this.reader.GetValue(2).ToString()); partners.Add(partner); } } return partners; }
public List<GenericBusinessPartner> GetList(CardType cardType, string[] cardCodes) { StringBuilder oSQL = new StringBuilder(); oSQL.Append("SELECT CardCode, CardName, listNum FROM OCRD T0 "); StringBuilder cardCodeTarget = new StringBuilder(); for (int i = 0; i < cardCodes.Length; i++) { if (i.Equals(cardCodes.Length - 1)) cardCodeTarget.Append(string.Format("'{0}'", cardCodes[i])); else cardCodeTarget.Append(string.Format("'{0}', ", cardCodes[i])); } switch (cardType) { case CardType.Customer: oSQL.Append(string.Format("where CardType = '{0}' and WtLiable= 'Y' and cardcode in ({1}) ", "C", cardCodeTarget.ToString())); break; case CardType.Supplier: oSQL.Append(string.Format("where CardType = '{0}' and WtLiable= 'Y' and cardcode in ({1}) ", "S", cardCodeTarget.ToString())); break; case CardType.Lead: oSQL.Append(string.Format("where CardType = '{0}' and cardcode in ({1}) ", "L", cardCodeTarget.ToString())); break; default: break; } DbCommand myCommand = this.dataBase.GetSqlStringCommand(oSQL.ToString()); List<GenericBusinessPartner> partners = new List<GenericBusinessPartner>(); using (this.reader = this.dataBase.ExecuteReader(myCommand)) { while (this.reader.Read()) { GenericBusinessPartner partner = new GenericBusinessPartner(); partner.cardCode = this.reader.IsDBNull(0) ? "" : this.reader.GetValue(0).ToString(); partner.cardName = this.reader.IsDBNull(1) ? "" : this.reader.GetValue(1).ToString(); partner.listNum = this.reader.IsDBNull(1) ? 1 : int.Parse(this.reader.GetValue(2).ToString()); partners.Add(partner); } } return partners; }