public static void AddTaxcfg(taxcfg entity)
{
var sqlstr = $"delete taxconfig where sort_typ='{ entity.sortTyp }'";
ExecSql(sqlstr);
var flg = entity.flg ? "1" : "0";
sqlstr = $"insert taxconfig (sort_typ, tax_per, flg, trn_cd) values('{entity.sortTyp}',{entity.taxPer},'{ flg }', '{ entity.trnCd }')";
ExecSql(sqlstr);
}
private void saveButton_Click(object sender, EventArgs e)
{
var taxcfg = new taxcfg()
{
sortTyp = sortTypComboBox.SelectedValue.ToString(),
flg = flgCheckBox.Checked,
taxPer = taxPerNumber.Value,
trnCd = trnCdTextBox.Text,
};
DbHelper.AddTaxcfg(taxcfg);
UpdateData();
}
