public SalesTaxCode GetSingleTaxCode(string taxCode) { StringBuilder oSQL = new StringBuilder(); oSQL.Append(string.Format("SELECT code, name, rate FROM OSTC T0 where code = '{0}'", taxCode)); DbCommand dbCommand = this.dataBase.GetSqlStringCommand(oSQL.ToString()); SalesTaxCode tax = new SalesTaxCode(); using (this.reader = this.dataBase.ExecuteReader(dbCommand)) { while (this.reader.Read()) { tax.code = this.reader.IsDBNull(0) ? "" : this.reader.GetValue(0).ToString(); tax.name = this.reader.IsDBNull(1) ? "" : this.reader.GetValue(1).ToString(); tax.rate = this.reader.IsDBNull(2) ? 0 : double.Parse(this.reader.GetValue(2).ToString()); } } return tax; }
public List<SalesTaxCode> GetSalesTaxCodeList() { StringBuilder oSQL = new StringBuilder(); oSQL.Append("SELECT code, name FROM OSTC T0 where lock = 'N'"); DbCommand dbCommand = this.dataBase.GetSqlStringCommand(oSQL.ToString()); List<SalesTaxCode> taxCodes = new List<SalesTaxCode>(); using (this.reader = this.dataBase.ExecuteReader(dbCommand)) { while (this.reader.Read()) { SalesTaxCode item = new SalesTaxCode(); item.code = this.reader.IsDBNull(0) ? "" : this.reader.GetValue(0).ToString(); item.name = this.reader.IsDBNull(1) ? "" : this.reader.GetValue(1).ToString(); taxCodes.Add(item); } } return taxCodes; }