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