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