public void REMOVE(DOMESTICRATE item) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete from DOMESTIC_RATE where prefix={0}", item.prefix); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} REMOVE ERR : {1}", this.GetType(), fex.Message)); return; } } _list.Remove(item); //INIT(); }
public void MODIFY(DOMESTICRATE item) { StringBuilder sb = new StringBuilder(); sb.Append("update DOMESTIC_RATE set"); sb.AppendFormat(" type='{0}', rate={1}, sec={2} where prefix='{3}'", item.type, item.rate, item.sec, item.prefix); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} MODIFY ERR : {1}", this.GetType(), fex.Message)); return; } } //INIT(); }
public void ADD(DOMESTICRATE item) { StringBuilder sb = new StringBuilder(); sb.Append("insert into DOMESTIC_RATE"); sb.Append(" ( prefix, type, rate, sec )"); sb.Append(" values "); sb.AppendFormat("( '{0}', '{1}', {2}, {3} )", item.prefix, item.type, item.rate, item.sec); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} ADD ERR : {1}", this.GetType(), fex.Message)); return; } } //INIT(); _list.Add(item); }
private void btnOk_Click(object sender, RoutedEventArgs e) { // 값 filter if (string.IsNullOrEmpty(txtPrefix.Text.Trim())) { MessageBox.Show("구분 번호를 입력해 주세요."); txtPrefix.Focus(); return; } if (string.IsNullOrEmpty(txtType.Text.Trim())) { MessageBox.Show("구분명을 입력해 주세요."); txtType.Focus(); return; } if (string.IsNullOrEmpty(txtRate.Text.Trim())) { MessageBox.Show("요율(원)을 입력해 주세요."); txtRate.Focus(); return; } if (string.IsNullOrEmpty(txtSec.Text.Trim())) { MessageBox.Show("요율(초)을 입력해 주세요."); txtSec.Focus(); return; } if (_mode == AddPrefixStates.Add) { _domesticrate = new DOMESTICRATE() { prefix = txtPrefix.Text.Trim() , type = txtType.Text.Trim() , rate = float.Parse(txtRate.Text.Trim()) , sec = int.Parse(txtSec.Text.Trim()) }; _parentWin.domestics.ADD(_domesticrate); txtPrefix.Text = string.Empty; txtType.Text = string.Empty; txtRate.Text = "1"; txtSec.Text = "1"; } else if (_mode == AddPrefixStates.Modify) { _domesticrate.prefix = txtPrefix.Text.Trim(); _domesticrate.type = txtType.Text.Trim(); _domesticrate.rate = float.Parse(txtRate.Text.Trim()); _domesticrate.sec = int.Parse(txtSec.Text.Trim()); _parentWin.domestics.MODIFY(_domesticrate); this.Close(); } }