public string Encry_Tel(string tel)
{
try
{
string result = "";
string strcn = System.Configuration.ConfigurationSettings.AppSettings["connstr_module"].ToString();
OracleConnection cn = new OracleConnection(strcn);
cn.Open();
OracleTransaction tr = cn.BeginTransaction();
OracleCommand cmd = cn.CreateCommand();
cmd.Transaction = tr;
cmd.CommandText = "select SYS.FN_SPLIT_PL(:p1,',') AS TTn from dual";
OracleParameter op = new OracleParameter("p1", OracleDbType.Clob);
op.Value = tel;
cmd.Parameters.Add(op);
OracleDataAdapter oracledatareader1 = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
oracledatareader1.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
result = dt.Rows[i]["TTn"].ToString();//行集合.行【号】列【名】
}
oracledatareader1.Dispose();
tr.Commit();
cn.Close();
return result;
}
catch (Exception es)
{
LogService.Write("Encry_Tel:" + es.Message);
return "";
}
}
/// <summary>
/// 解密
/// </summary>
/// <param name="tel"></param>
/// <returns></returns>
public string Descrypt_Tel(string tel)
{
try
{
string result = "";
string strcn = System.Configuration.ConfigurationSettings.AppSettings["connstr_module"].ToString();
OracleConnection cn = new OracleConnection(strcn);
cn.Open();
OracleTransaction tr = cn.BeginTransaction();
OracleCommand cmd = cn.CreateCommand();
cmd.Transaction = tr;
cmd.CommandText = "select SYS.fn_split_pl_jm(:p1,',') as TTN from dual";
OracleParameter op = new OracleParameter("p1", OracleDbType.Clob);
op.Value = tel;
cmd.Parameters.Add(op);
OracleDataAdapter oracledatareader1 = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
oracledatareader1.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
result = dt.Rows[i]["TTn"].ToString();//行集合.行【号】列【名】
}
oracledatareader1.Dispose();
tr.Commit();
cn.Close();
return result;
}
catch (Exception es)
{
LogService.Write("DESCRYPT_TEL:" + es.Message);
return "";
}
}
{
try
{
string result = "";
string strcn = System.Configuration.ConfigurationSettings.AppSettings["connstr_module"].ToString();
OracleConnection cn = new OracleConnection(strcn);
cn.Open();
OracleTransaction tr = cn.BeginTransaction();
OracleCommand cmd = cn.CreateCommand();
cmd.Transaction = tr;
cmd.CommandText = "select SYS.FN_SPLIT_PL(:p1,',') AS TTn from dual";
OracleParameter op = new OracleParameter("p1", OracleDbType.Clob);
op.Value = tel;
cmd.Parameters.Add(op);
OracleDataAdapter oracledatareader1 = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
oracledatareader1.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
result = dt.Rows[i]["TTn"].ToString();//行集合.行【号】列【名】
}
oracledatareader1.Dispose();
tr.Commit();
cn.Close();
return result;
}
catch (Exception es)
{
LogService.Write("Encry_Tel:" + es.Message);
return "";
}
}
/// <summary>
/// 解密
/// </summary>
/// <param name="tel"></param>
/// <returns></returns>
public string Descrypt_Tel(string tel)
{
try
{
string result = "";
string strcn = System.Configuration.ConfigurationSettings.AppSettings["connstr_module"].ToString();
OracleConnection cn = new OracleConnection(strcn);
cn.Open();
OracleTransaction tr = cn.BeginTransaction();
OracleCommand cmd = cn.CreateCommand();
cmd.Transaction = tr;
cmd.CommandText = "select SYS.fn_split_pl_jm(:p1,',') as TTN from dual";
OracleParameter op = new OracleParameter("p1", OracleDbType.Clob);
op.Value = tel;
cmd.Parameters.Add(op);
OracleDataAdapter oracledatareader1 = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
oracledatareader1.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
result = dt.Rows[i]["TTn"].ToString();//行集合.行【号】列【名】
}
oracledatareader1.Dispose();
tr.Commit();
cn.Close();
return result;
}
catch (Exception es)
{
LogService.Write("DESCRYPT_TEL:" + es.Message);
return "";
}
}