本文整理汇总了C#中OracleType类的典型用法代码示例。如果您正苦于以下问题：C# OracleType类的具体用法？C# OracleType怎么用？C# OracleType使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
OracleType类属于命名空间，在下文中一共展示了OracleType类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: bt_Process_Click
private void bt_Process_Click(object sender, EventArgs e)
{
string out_rc = "", out_msg_err = "";
string name = Businessbp.executedb.owner + "nab_NQH.process_af_autopayment";
string u_create = "";
u_create = Businessbp.executedb.Usrid;
string[] InParaName = new string[1] { "u_create" };
OracleType[] InParaType = new OracleType[2] { OracleType.VarChar, OracleType.VarChar };
string[] InParaValues = new string[1] { u_create };
string[] OutParaName = new string[1] { "Emsg_out" };
OracleType[] OutParaType = new OracleType[1] { OracleType.VarChar };
int[] OutParaSize = new int[1] { 200 };
OracleType reParaType = OracleType.Number;
int reParaSize = 1;
string[] OutParaValues = new string[1];
string returnValue = "";
string err = "";
Businessbp.executedb.ExecuteFunc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, reParaType, reParaSize, ref OutParaValues, ref returnValue, ref err);
if (err != "")
{
tbstatus.Text = err.ToString();
}
else
{
out_rc = OutParaValues[0].ToString();
tbstatus.Text = out_rc;
}
}
开发者ID:phongferrari，项目名称:source-code-nama，代码行数:30，代码来源:Frm_Process_af_autopayment1.cs
示例2: Process
public static void Process(string in_type, string in_parameter,
ref string Result_out, ref string Emsg_out, ref string out_parameter)
{
string err = "";
const int count_inval = 2;
const int count_outval = 3;
string name = executedb.owner + "NAB_PROCESS_QUERY.Proc_Update_VIP_Flag";
string[] InParaName = new string[count_inval] { "in_type", "in_parameter" };
OracleType[] InParaType = new OracleType[count_inval] { OracleType.VarChar, OracleType.VarChar };
string[] InParaValues = new string[count_inval] { in_type, in_parameter.ToString() };
string[] OutParaName = new string[count_outval] { "Result_out", "Emsg_out", "out_parameter" };
OracleType[] OutParaType = new OracleType[count_outval] { OracleType.VarChar, OracleType.VarChar, OracleType.VarChar };
int[] OutParaSize = new int[count_outval] { 1, 1000, 9999 };
string[] OutParaValues = new string[count_outval];
err = "";
executedb.ExecuteProc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err);
//Businessbp.executedb.ExecuteFunc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, reParaType, reParaSize, ref OutParaValues, ref returnValue, ref err);
if (err != "")
{
#region logError
Result_out = "3";
Emsg_out += "Error when call procedure:" + err;
out_parameter = "";
#endregion logError
}
else
{
Result_out = OutParaValues[0].ToString();
Emsg_out = OutParaValues[1].ToString().ToString();
out_parameter = OutParaValues[2].ToString();
}
}
开发者ID:phongferrari，项目名称:source-code-nama，代码行数:35，代码来源:Card_VIP_Flag_Update.aspx.cs
示例3: OciLobLocator
internal OciLobLocator(OracleConnection connection, OracleType lobType)
{
this._connection = connection;
this._connectionCloseCount = connection.CloseCount;
this._lobType = lobType;
this._cloneCount = 1;
switch (lobType)
{
case OracleType.BFile:
this._descriptor = new OciFileDescriptor(connection.ServiceContextHandle);
break;
case OracleType.Blob:
case OracleType.Clob:
case OracleType.NClob:
this._descriptor = new OciLobDescriptor(connection.ServiceContextHandle);
return;
case OracleType.Char:
break;
default:
return;
}
}
开发者ID:pritesh-mandowara-sp，项目名称:DecompliedDotNetLibraries，代码行数:25，代码来源:OciLobLocator.cs
示例4: button1_Click
private void button1_Click(object sender, EventArgs e)
{
//pv_InputDir IN VARCHAR2, --NAB_RECON_MC_INPUT
// pv_FileName IN VARCHAR2,
// pv_ProcDir IN VARCHAR2, --NAB_RECON_MC_PRO
// pv_user_create IN VARCHAR2,
// pv_Error_Desc OUT VARCHAR2
this.Cursor = Cursors.WaitCursor;
string[] InParaName = new string[4] { "pv_InputDir", "pv_FileName", "pv_ProcDir", "pv_user_create" };
OracleType[] InParaType = new OracleType[4] { OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar };
string[] InParaValues = new string[4] { patch, tbFileName.Text, proc, Businessbp.executedb.Usrid };
string[] OutParaName = new string[1] { "pv_Error_Desc" };
OracleType[] OutParaType = new OracleType[1] { OracleType.VarChar };
int[] OutParaSize = new int[1] { 200 };
OracleType reParaType = OracleType.Number;
int reParaSize = 1;
string[] OutParaValues = new string[1];
string returnValue = "";
string err = "";
Businessbp.executedb.ExecuteFunc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, reParaType, reParaSize, ref OutParaValues, ref returnValue, ref err);
this.Cursor = Cursors.Default;
if (err != "")
MessageBox.Show(err);
else
{
if (returnValue == "1")
tbStatus.Text = "Successfully .........";
else
tbStatus.Text = OutParaValues[0].ToString();
}
}
开发者ID:phongferrari，项目名称:banknet-domestic，代码行数:31，代码来源:Frm_MasterCard_Reconcilation_Acquirer.cs
示例5: AddOutParamToSqlCommand
public static OracleParameter AddOutParamToSqlCommand(OracleCommand comm, string pName, OracleType pType)
{
OracleParameter param = new OracleParameter(pName, pType);
param.Direction = ParameterDirection.Output;
comm.Parameters.Add(param);
return param;
}
开发者ID:eseawind，项目名称:sac-hnss，代码行数:7，代码来源:DBoracle.cs
示例6: button1_Click
private void button1_Click(object sender, EventArgs e)
{
string name = "";
this.Cursor = Cursors.WaitCursor;
name = Businessbp.executedb.owner + "MASTER_UPLOAD_BI.PROCESSING_MASTER_ISSUER_BI";
//PROCESSING_MASTER_ISSUER_BI(p_Processing_Date varchar2) RETURN NUMBER;
string date_process = "", u_create = "";
date_process = dateTimePicker1.Text;
//daily(date_process in date, u_create varchar2, Emsg_out out varchar2) return number
string[] InParaName = new string[1] { "p_Processing_Date"};
OracleType[] InParaType = new OracleType[1] { OracleType.VarChar};
string[] InParaValues = new string[1] { date_process };
string[] OutParaName = new string[0] { };
OracleType[] OutParaType = new OracleType[0] { };
int[] OutParaSize = new int[0] { };
OracleType reParaType = OracleType.Number;
int reParaSize = 1;
string[] OutParaValues = new string[0];
string returnValue = "";
string err = "";
Businessbp.executedb.ExecuteFunc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, reParaType, reParaSize, ref OutParaValues, ref returnValue, ref err);
this.Cursor = Cursors.Default;
if (err != "")
MessageBox.Show(err);
else
{
if (returnValue == "0")
MessageBox.Show("Successfully .........");
else
MessageBox.Show("Not successfull. returnValue=" + returnValue);
}
}
开发者ID:phongferrari，项目名称:source-code-nama，代码行数:32，代码来源:Frm_MC_Upload_BI.cs
示例7: AddParameter
public static void AddParameter(string name, object value, OracleType oracleType, ParameterCollection parameters)
{
Parameter p = new Parameter("p" + name, oracleType);
switch (oracleType)
{
case OracleType.DateTime:
p.ParameterValue = value == null ? DateTime.Now : value;
break;
default:
if (value == null)
{
p.ParameterValue = string.Empty;
}
else
{
if (value.ToString() == "")
{
p.ParameterValue = string.Empty;
}
else
{
p.ParameterValue = value;
}
}
break;
}
parameters.Add(p);
}
开发者ID:SaintLoong，项目名称:TMFlow，代码行数:30，代码来源:ADOHelper.cs
示例8: Transfer_P2P
//chuyển khoản từ thẻ prepaid sang prepaid
public static string Transfer_P2P(string src_card_nbr, string dst_card_nbr, string amount, string narrative, string batch_nbr, string batch_date)
{ //batch_date dd/MM/yyyy
string type = "P2P";
string result = "", msgstat = "TRUE", mcrrefnbr = "", err = "";
const int count_inval = 6;
const int count_outval = 1;
string name = "nab_CNTT."+type;
//P2P(from_card in varchar2, to_card varchar2, trn_amount number, content in varchar2, batch_number in varchar2, d_batch_dt varchar2, Emsg_out out varchar2) return number is
string[] InParaName = new string[count_inval] { "from_card", "to_card", "trn_amount", "content", "batch_number", "d_batch_dt" };
OracleType[] InParaType = new OracleType[count_inval] { OracleType.VarChar, OracleType.VarChar, OracleType.Number, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar };
string[] InParaValues = new string[count_inval] { src_card_nbr, dst_card_nbr, amount, narrative, batch_nbr, batch_date };
string[] OutParaName = new string[count_outval] { "Emsg_out" };
OracleType[] OutParaType = new OracleType[count_outval] { OracleType.VarChar };
int[] OutParaSize = new int[count_outval] { 200 };
OracleType reParaType = OracleType.Number;
int reParaSize = 1;
string[] OutParaValues = new string[1];
string returnValue = "";
err = "";
Businessbp.executedb.ExecuteFunc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, reParaType, reParaSize, ref OutParaValues, ref returnValue, ref err);
if (err != "")
{
msgstat = "FALSE";
#region logError
Businessbp.executedb.WriteLogERROR(HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"], MethodBase.GetCurrentMethod().DeclaringType.Name, System.Reflection.MethodBase.GetCurrentMethod().ToString(), "ExecuteFunc_" + type, "err --> " + err);
#endregion logError
}
else
{
if (returnValue == "1")
{
msgstat = "TRUE";
mcrrefnbr = OutParaValues[0].ToString();
}
else
{
msgstat = "FALSE";
err = OutParaValues[0].ToString();
#region logError
Businessbp.executedb.WriteLogERROR(HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"], MethodBase.GetCurrentMethod().DeclaringType.Name, System.Reflection.MethodBase.GetCurrentMethod().ToString(), "ExecuteFunc_" + type, "err --> " + err);
#endregion logError
}
}
result = "<msgstat>" + msgstat.Trim() + "</msgstat>";
result += "<err>" + err.Trim() + "</err>";
result += "<mcrrefnbr>" + mcrrefnbr.Trim() + "</mcrrefnbr>";
#region logINFO
Businessbp.executedb.WriteLogINFO(HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"], MethodBase.GetCurrentMethod().DeclaringType.Name, System.Reflection.MethodBase.GetCurrentMethod().ToString(), "Result --> " + result);
#endregion logINFO
return result;
}
开发者ID:phongferrari，项目名称:Way4-Webservice，代码行数:60，代码来源:AuthorizeCard.cs
示例9: AddParameter
public void AddParameter(OracleCommand command, string name, OracleType oracleType, int size,
ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn,
DataRowVersion sourceVersion, object value)
{
OracleParameter param = CreateParameter(name, DbType.AnsiString, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value) as OracleParameter;
param.OracleType = oracleType;
command.Parameters.Add(param);
}
开发者ID:EvanYaoPeng，项目名称:Kalman.Studio，代码行数:8，代码来源:OracleDatabase.cs
示例10: AddParameter
public void AddParameter(string StrName, OracleType objType, ParameterDirection objDirection)
{
OracleParameter l_Param = new OracleParameter(StrName,objType);
l_Param.ParameterName = StrName;
l_Param.OracleType = objType;
l_Param.Direction = objDirection;
m_Command.Parameters.Add(l_Param);
}
开发者ID:install-gentoo，项目名称:LPprototype，代码行数:8，代码来源:clsDAccess.cs
示例11: AddOutOracleCurSorPara
/// <summary>
/// 添加Oracle数据库存储过程的输出参数
/// </summary>
/// <param name="oracleType">数据类型</param>
/// <param name="parameterName">参数名称</param>
public void AddOutOracleCurSorPara(OracleType oracleType, string parameterName)
{
OutOracleCursorPara tt = new OutOracleCursorPara();
tt.ParameterName = parameterName;
tt.Oracletype = oracleType;
tt.Parameterdirection = ParameterDirection.Output;
cursorList.Add(tt);
}
开发者ID:SaintLoong，项目名称:PD，代码行数:13，代码来源:ParameterMapper.cs
示例12: button2_Click
private void button2_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
string sql = "", err1 = "";
DataTable dt;
string name = Businessbp.executedb.owner + "proc_check88";
// proc_check88(
//fromdate in varchar2,
//todate in varchar2,
//r_count out number,
//Result_out out number,
//Emsg_out out varchar2)
string FromDate = "", ToDate = "";
FromDate = dtFrom.Text + " " + tbFhh.Text + ":" + tbFmi.Text + ":" + tbFss.Text;
ToDate = dtTo.Text + " " + tbThh.Text + ":" + tbTmi.Text + ":" + tbTss.Text;
string[] InParaName = new string[2] { "fromdate", "todate" };
string[] OutParaName = new string[3] { "r_count", "Result_out", "Emsg_out" };
OracleType[] InParaType = new OracleType[2] { OracleType.VarChar, OracleType.VarChar };
OracleType[] OutParaType = new OracleType[3] { OracleType.Number, OracleType.Number, OracleType.VarChar };
string[] InParaValues = new string[2] { FromDate, ToDate };
string[] OutParaValues = new string[3];
for (int i = 0; i < 3; i++)
OutParaValues[i] = "";
int[] OutParaSize = new int[3] { 0 , 0 , 300 };
string err = "";
Businessbp.executedb.ExecuteProcELECTRA(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err);
if (err != "")
MessageBox.Show(err);
else
{
int r_count = Int32.Parse(OutParaValues[0].ToString());
int Result_out = Int32.Parse(OutParaValues[1].ToString());
string Emsg_out = OutParaValues[2].ToString();
if (Result_out != 1)
{
MessageBox.Show(Emsg_out);
return;
}
else
{
MessageBox.Show("Process successfull!!!");
LoadData();
}
}
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
开发者ID:phongferrari，项目名称:source-code-nama，代码行数:57，代码来源:Frm_Check_Accounting_Check88.cs
示例13: Process
private void Process()
{
try
{
this.Cursor = Cursors.WaitCursor;
string name = "";
const int out_para = 2;
name += "" + Businessbp.executedb.owner + "proc_nab_thucno";
//string type = "Pre_Transaction_Upload";
string in_parameter = "";
string[] InParaName = new string[1] { "user_id" };
string[] OutParaName = new string[out_para] { "Result_out", "Emsg_out" };
OracleType[] InParaType = new OracleType[2] { OracleType.VarChar, OracleType.VarChar };
OracleType[] OutParaType = new OracleType[out_para] { OracleType.Number, OracleType.VarChar};
string[] InParaValues = new string[1] { Businessbp.executedb.Usrid };
string[] OutParaValues = new string[out_para];
for (int i = 0; i < out_para; i++)
OutParaValues[i] = "";
int[] OutParaSize = new int[out_para] { 0, 500};
string err = "";
Businessbp.executedb.ExecuteProcELECTRA(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err);
if (err != "")
{
MessageBox.Show(err);
this.Cursor = Cursors.Default;
return;
}
else
{
int Result_out = Int32.Parse(OutParaValues[0].ToString());
string Emsg_out = OutParaValues[1].ToString();
if (Result_out != 1)
{
MessageBox.Show(Emsg_out);
tbStatus.Text = Emsg_out;
this.Cursor = Cursors.Default;
return;
}
else
{
//Parse out_parameter nếu cần thiết
tbStatus.Text = "Successfull!!!";
MessageBox.Show("Successfull!!!");
}
}
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.Cursor = Cursors.Default;
}
}
开发者ID:phongferrari，项目名称:source-code-nama，代码行数:55，代码来源:Frm_Credit_Process_ThucNo.cs
示例14: bt_Authorize_Click
private void bt_Authorize_Click(object sender, EventArgs e)
{
string in_parameter = "";
string err = "";
string out_rc = "", out_msg_err = "", out_other_info = "";
const int count_inval = 1;
const int count_outval = 3;
in_parameter = "";
in_parameter += "<cr_account_number>" + acc.Trim() + "</cr_account_number>";
in_parameter += "<user_id>" + Businessbp.executedb.Usrid + "</user_id>";
string name = Businessbp.executedb.owner + "nab_installment.Abort_Installment";
string[] InParaName = new string[count_inval] { "in_parameter" };
OracleType[] InParaType = new OracleType[count_inval] { OracleType.VarChar };
string[] InParaValues = new string[count_inval] { in_parameter };
string[] OutParaName = new string[count_outval] { "out_rc", "out_msg_err", "out_other_info" };
OracleType[] OutParaType = new OracleType[count_outval] { OracleType.VarChar, OracleType.VarChar, OracleType.VarChar };
int[] OutParaSize = new int[count_outval] { 2, 100, 9999 };
string[] OutParaValues = new string[count_outval];
err = "";
Businessbp.executedb.ExecuteProcELECTRA(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err);
if (err != "")
{
MessageBox.Show(err);
}
else
{
out_rc = OutParaValues[0].ToString();
out_msg_err = OutParaValues[1].ToString();
out_other_info = OutParaValues[2].ToString();
if (out_rc != "00")
{
MessageBox.Show(out_msg_err);
}
else
{
bt_Authorize.Enabled = false;
//Load_Data();
string batch_nbr = "";
batch_nbr = out_other_info.Substring(out_other_info.IndexOf("<batch_nbr>") + "<batch_nbr>".Length, out_other_info.IndexOf("</batch_nbr>") - (out_other_info.IndexOf("<batch_nbr>") + "<batch_nbr>".Length));
if (batch_nbr == "")
{
MessageBox.Show("No batch open!!");
}
else
{
Load_Data_After(batch_nbr);
lb_Success.Text = Count_Success_Fail(Int32.Parse(batch_nbr), "Y").ToString();
lb_Fail.Text = Count_Success_Fail(Int32.Parse(batch_nbr), "Z").ToString();
MessageBox.Show("Process Done!!!");
}
}
}
}
开发者ID:phongferrari，项目名称:source-code-nama，代码行数:55，代码来源:Frm_Installment_Abort_Authorize.cs
示例15: bt_Process_Click
private void bt_Process_Click(object sender, EventArgs e)
{
string in_parameter = "";
string err = "";
string out_rc = "",out_msg_err="", out_other_info = "";
const int count_inval = 1;
const int count_outval = 3;
//string transaction_amount = "", currency_code = "", billing_amount = "", periods = "", card_number = "", reference_number = "", trace = "", card_acceptor_term_id = "", user_id = "", transaction_local_date = "", content = "";
#region Get_Parameter
in_parameter = "";
in_parameter += "<microfirm_ref_number>" + tb_Micro_Ref_No.Text.Trim() + "</microfirm_ref_number>";
in_parameter += "<sequence_number>" + int.Parse(tb_Seq_No.Text.Trim()) + "</sequence_number>";
in_parameter += "<client_code>" + tb_CIF.Text.Trim() + "</client_code>";
in_parameter += "<user_id>" + user_id + "</user_id>";
in_parameter += "<content>" + tb_Note.Text.Trim() + "</content>";
in_parameter += "<periods>" + int.Parse(cb_Periods.Text.Trim()) + "</periods>";
in_parameter += "<merchant>" + cbb_merchant.SelectedValue.ToString ( ).Trim ( ) + "</merchant><disrate>"; //2015-07-09 (1)
in_parameter += tbDisrate.Text.Trim ( ) == "" ? "null" : tbDisrate.Text.Trim ( ) + "</disrate><disamt>"; //2016-07-27 (2)
in_parameter += tbDisamt.Text.Trim ( ) == "" ? "null" : tbDisamt.Text.Trim ( ) + "</disamt>"; //2016-07-27 (2)
#endregion Get_Parameter
string name = Businessbp.executedb.owner + "nab_installment.Transfer_to_installment";
string[] InParaName = new string[count_inval] { "in_parameter" };
OracleType[] InParaType = new OracleType[count_inval] { OracleType.VarChar };
string[] InParaValues = new string[count_inval] { in_parameter };
string[] OutParaName = new string[count_outval] { "out_rc", "out_msg_err", "out_other_info" };
OracleType[] OutParaType = new OracleType[count_outval] { OracleType.VarChar, OracleType.VarChar, OracleType.VarChar };
int[] OutParaSize = new int[count_outval] { 2, 100, 9999 };
string[] OutParaValues = new string[count_outval];
err = "";
Businessbp.executedb.ExecuteProcELECTRA(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err);
if (err != "")
{
MessageBox.Show(err);
}
else
{
out_rc = OutParaValues[0].ToString();
out_msg_err = OutParaValues[1].ToString();
out_other_info = OutParaValues[2].ToString();
if (out_rc != "00")
{
MessageBox.Show(out_msg_err);
}
else
{
MessageBox.Show("Process Successful!!!");
//string merchant_name = Get_Merchant_Name ( tb_Micro_Ref_No.Text.Trim ( ) );
//Send_SMS ( tb_CardNo.Text.Trim ( ), tb_AccNo.Text.Trim ( ), tb_Billing.Text.Trim ( ), merchant_name, cb_Periods.SelectedText.ToString ( ), tbDisamt.Text );
}
}
}
开发者ID:phongferrari，项目名称:source-code-nama，代码行数:54，代码来源:Frm_Installment_Transfer_To_Installment.cs
示例16: ToNetType
public static Type ToNetType(OracleType oracleType)
{
foreach (TypeMapping entry in _DbTypeMappings)
{
if (entry.OracleType == oracleType)
{
return entry.Type;
}
}
throw new ApplicationException("Referenced an unsupported OracleType {" + Enum.GetName(typeof(OracleType), oracleType) + "}");
}
开发者ID:paulweatherby，项目名称:DataAbstractionLayer，代码行数:11，代码来源:OracleTypeConverter.cs
示例17: btBlock_Click
private void btBlock_Click ( object sender, EventArgs e )
{
try
{
if (cbbMerchant.SelectedIndex != -1)
{
this.Cursor = Cursors.WaitCursor;
string name = "NAB_PCK_LOYALTY.block_installment";
string[] InParaName = new string[4] { "contract_nbr", "doc_id", "block_amount", "mer_id" };
string[] OutParaName = new string[2] { "emsg_out", "ref_out" };
OracleType[] InParaType = new OracleType[4] { OracleType.VarChar, OracleType.Number, OracleType.Number, OracleType.VarChar };
OracleType[] OutParaType = new OracleType[2] { OracleType.VarChar, OracleType.Number };
string[] InParaValues = new string[4] { lbcrd_number.Text.Trim ( ), lbdoc_id.Text.Trim ( ), tbAmount.Text.Trim ( ), cbbMerchant.SelectedValue.ToString ( ) };
string[] OutParaValues = new string[2];
for (int i = 0; i < 2; i++)
OutParaValues[i] = "";
int[] OutParaSize = new int[2] { 99999, 100 };
string err = "";
Businessbp.executedb.ExecuteProc ( name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err );
if (err != "")
MessageBox.Show ( err );
else
{
int Result_out = Int32.Parse ( OutParaValues[1].ToString ( ) );
string Emsg_out = OutParaValues[0].ToString ( );
if (Result_out == 0)
{
MessageBox.Show ( Emsg_out );
return;
}
else
{
MessageBox.Show ( "Block success!!!" );
this.Close ( );
}
}
}
else
{
MessageBox.Show ( "Pls select at least one merchant!!!" );
}
}
catch (Exception ex)
{
MessageBox.Show ( ex.Message );
}
this.Cursor = Cursors.Default;
}
开发者ID:phongferrari，项目名称:Way4-CustomerCareForm，代码行数:54，代码来源:Frm_Block_Loyalty_Action.cs
示例18: Process
private void Process()
{
try
{
this.Cursor = Cursors.WaitCursor;
string name = "";
const int out_para = 1;
name += "nab_pck_MASTERCARD_RECONS.LOAD_MC_PAYMENT";
string[] InParaName = new string[2] { "pv_processing_dt", "pv_usrid" };
string[] OutParaName = new string[out_para] { "pv_Error_Desc" };
OracleType[] InParaType = new OracleType[2] { OracleType.VarChar, OracleType.VarChar };
OracleType[] OutParaType = new OracleType[out_para] { OracleType.VarChar };
string[] InParaValues = new string[2] { dtpkPdate.Text.Trim ( ), Businessbp.executedb.Usrid };
string[] OutParaValues = new string[out_para];
for (int i = 0; i < out_para; i++)
OutParaValues[i] = "";
int[] OutParaSize = new int[out_para] { 9999 };
OracleType reParaType = OracleType.VarChar;
string returnValue = "";
int reParaSize = 1;
string err = "";
Businessbp.executedb.ExecuteFunc ( name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, reParaType, reParaSize, ref OutParaValues, ref returnValue, ref err );
if (err != "")
{
MessageBox.Show(err);
this.Cursor = Cursors.Default;
return;
}
else
{
string Emsg_out = OutParaValues[0].ToString();
if (returnValue != "1")
{
MessageBox.Show(Emsg_out);
this.Cursor = Cursors.Default;
return;
}
else
{
//Parse out_parameter nếu cần thiết
MessageBox.Show("Successfull!!!");
}
}
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.Cursor = Cursors.Default;
}
}
开发者ID:phongferrari，项目名称:Way4-CustomerCareForm，代码行数:53，代码来源:Frm_MC_ThanhToan_File.cs
示例19: button1_Click
private void button1_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
string sql = "", err1 = "";
DataTable dt;
string cycle = cbCycle.SelectedValue.ToString().Trim();
string date_process = dateTimePicker1.Text;
string name = Businessbp.executedb.owner + "nab_proc_printbillcr";
// (cycle in varchar2, indate in varchar2, Result_out out number,
//Emsg_out out varchar2) is
string[] InParaName = new string[2] { "cycle", "indate" };
string[] OutParaName = new string[2] { "Result_out", "Emsg_out" };
OracleType[] InParaType = new OracleType[2] { OracleType.VarChar, OracleType.VarChar };
OracleType[] OutParaType = new OracleType[2] { OracleType.Number, OracleType.VarChar };
string[] InParaValues = new string[2] { cycle, date_process };
string[] OutParaValues = new string[2];
for (int i = 0; i < 2; i++)
OutParaValues[i] = "";
int[] OutParaSize = new int[2] { 0, 300 };
string err = "";
Businessbp.executedb.ExecuteProcELECTRA(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err);
if (err != "")
{
MessageBox.Show(err);
this.Cursor = Cursors.Default;
}
else
{
int Result_out = Int32.Parse(OutParaValues[0].ToString());
string Emsg_out = OutParaValues[1].ToString();
if (Result_out != 1)
{
MessageBox.Show(Emsg_out);
this.Cursor = Cursors.Default;
return;
}
else
{
MessageBox.Show("Process successful");
}
}
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
开发者ID:phongferrari，项目名称:source-code-nama，代码行数:53，代码来源:Frm_Credit_Billing_Process.cs
示例20: bt_Process_Click
private void bt_Process_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
string sql = "", err1 = "";
DataTable dt;
string name = Businessbp.executedb.owner + "pro_auto_payment";
string[] InParaName = new string[1] { "u_create" };
string[] OutParaName = new string[2] { "Result_out", "Msg_out" };
OracleType[] InParaType = new OracleType[1] { OracleType.VarChar };
OracleType[] OutParaType = new OracleType[2] { OracleType.Number, OracleType.VarChar };
string[] InParaValues = new string[1] { Businessbp.executedb.Usrid};// 2015-10-20 (1)
string[] OutParaValues = new string[2];
for (int i = 0; i < 2; i++)
OutParaValues[i] = "";
int[] OutParaSize = new int[2] { 0, 300 };
string err = "";
Businessbp.executedb.ExecuteProcELECTRA(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err);
if (err != "")
{
MessageBox.Show(err);
this.Cursor = Cursors.Default;
}
else
{
int Result_out = Int32.Parse(OutParaValues[0].ToString());
string Emsg_out = OutParaValues[1].ToString();
if (Result_out != 1)//Lỗi
{
MessageBox.Show(Emsg_out);
this.Cursor = Cursors.Default;
return;
}
else
{
//Xu ly hach toan
HachToan();
LoadData();
MessageBox.Show( "Process successfull!!!");
this.Cursor = Cursors.Default;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
开发者ID:phongferrari，项目名称:Way4-CustomerCareForm，代码行数:52，代码来源:Frm_Extract_Overdue_Debt.cs
注：本文中的OracleType类示例整理自Github/MS |
客服电话
APP下载
官方微信
请发表评论