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;
}
