private void b_ok_Click(object sender, EventArgs e)
{
string s_region_code = te_region_code.Text;
string s_agency_code = te_agency_code.Text;
string s_agency_name = te_agency_name.Text;
string s_url = te_url.Text;
string s_appid = te_appid.Text;
string s_appkey = te_appkey.Text;
string s_bill_code = te_code.Text;
string s_batch_code = te_batch_code.Text;
string s_bill_name = te_bill_name.Text;
string s_version = te_version.Text;
OracleTransaction trans = null;
try
{
trans = SqlAssist.conn.BeginTransaction();
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_region_code + "' where sp001 = '0000000060' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_agency_code + "' where sp001 = '0000000062' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_agency_name + "' where sp001 = '0000000063' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_url + "' where sp001 = '0000000064' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_appid + "' where sp001 = '0000000065' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_appkey + "' where sp001 = '0000000066' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_bill_code + "' where sp001 = '0000000068' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_batch_code + "' where sp001 = '0000000067' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_bill_name + "' where sp001 = '0000000069' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_version + "' where sp001 = '0000000061' ");
Envior.FIN_REGION_CODE = s_region_code;
Envior.FIN_AGENCY_CODE = s_agency_code;
Envior.FIN_AGENCY_NAME = s_agency_name;
Envior.FIN_URL = s_url;
Envior.FIN_APPID = s_appid;
Envior.FIN_APPKEY = s_appkey;
Envior.FIN_CODE = s_bill_code;
Envior.FIN_BATCH_CODE = s_batch_code;
Envior.FIN_BILLNAME = s_bill_name;
Envior.FIN_VERSION = s_version;
trans.Commit();
XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ee)
{
trans.Rollback();
XtraMessageBox.Show(ee.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void b_ok_Click(object sender, EventArgs e)
{
//string s_pjlx = te_pjlx.Text;
//string s_title = te_title.Text;
//if (string.IsNullOrEmpty(s_pjlx))
//{
// te_pjlx.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
// te_pjlx.ErrorText = "票据类型不能为空!";
// return;
//}else if (string.IsNullOrEmpty(s_title))
//{
// te_title.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
// te_title.ErrorText = "题头名称不能为空!";
// return;
//}
//if (AppAction.SaveFinanceInfo(s_pjlx,s_title)> 0)
//{
// XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// Envior.FIN_INVOICE_TYPE = s_pjlx;
// Envior.FIN_INVOICE_TITLE = s_title;
// this.Close();
//}
string s_region_code = te_region_code.Text;
string s_agency_code = te_agency_code.Text;
string s_agency_name = te_agency_name.Text;
string s_url = te_url.Text;
string s_appid = te_appid.Text;
string s_appkey = te_appkey.Text;
string s_bill_code = te_code.Text;
string s_batch_code = te_batch_code.Text;
string s_bill_name = te_bill_name.Text;
string s_version = te_version.Text;
OracleTransaction trans = null;
try
{
trans = SqlAssist.conn.BeginTransaction();
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_region_code + "' where sp001 = '0000000060' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_agency_code + "' where sp001 = '0000000062' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_agency_name + "' where sp001 = '0000000063' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_url + "' where sp001 = '0000000064' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_appid + "' where sp001 = '0000000065' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_appkey + "' where sp001 = '0000000066' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_bill_code + "' where sp001 = '0000000068' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_batch_code + "' where sp001 = '0000000067' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_bill_name + "' where sp001 = '0000000069' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_version + "' where sp001 = '0000000061' ");
Envior.FIN_REGION_CODE = s_region_code;
Envior.FIN_AGENCY_CODE = s_agency_code;
Envior.FIN_AGENCY_NAME = s_agency_name;
Envior.FIN_URL = s_url;
Envior.FIN_APPID = s_appid;
Envior.FIN_APPKEY = s_appkey;
Envior.FIN_CODE = s_bill_code;
Envior.FIN_BATCH_CODE = s_batch_code;
Envior.FIN_BILLNAME = s_bill_name;
Envior.FIN_VERSION = s_version;
trans.Commit();
XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ee)
{
trans.Rollback();
XtraMessageBox.Show(ee.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}