/// <summary>
///
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public virtual object ExecSql(string sql)
{
object res;
res = OracleDBUtility.ExecuteNonQuery(oraConnStr, System.Data.CommandType.Text, sql, null);
return(res);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public object Delete()
{
object res;
string sql = " DELETE FROM " + oracleTableName + " WHERE " + oraclePriKey + "'" + l.First <BaseMode>(e => e.UfColumnName.Equals("cinvcode")).UfColumnValue + "'";
res = OracleDBUtility.ExecuteNonQuery(oraConnStr, System.Data.CommandType.Text, sql, null);
return(res);
}
public object Update()
{
object res;
string oraUpdateCols = "";
for (int i = 0; i < l.Count; i++)
{
if (!string.IsNullOrEmpty(l[i].OrColumnName))
{
oraUpdateCols += l[i].OrColumnName + "= '" + l[i].OrColumnValue + "',";
}
}
oraUpdateCols = oraUpdateCols.Substring(0, oraUpdateCols.Length - 1);
string sql = " UPDATE " + oracleTableName + " SET " + oraUpdateCols + " WHERE " + oraclePriKey + "'" + l.First <BaseMode>(e => e.UfColumnName.Equals("cinvcode")).UfColumnValue + "'";
res = OracleDBUtility.ExecuteNonQuery(oraConnStr, System.Data.CommandType.Text, sql, null);
return(res);
}
public static int NpDataManagerQuery(string SPID, string NPNumber, out string PortInNetID, out string PortOutNetID, out string HomeNetID, out string BeginDate, out string ErrMsg)
{
int Result = ErrorDefinition.BT_IError_Result_UnknowError_Code;
ErrMsg = ErrorDefinition.BT_IError_Result_UnknowError_Msg;
PortInNetID = "";
PortOutNetID = "";
HomeNetID = "";
BeginDate = "";
//ErrorDescription = "";
try
{
OracleDataReader reader = OracleDBUtility.ExecuteReader("select portinnetid,portoutnetid,homenetid, to_char(begindate,'YYYY-MM-DD') as begindate from npdata where npnumber=" + NPNumber + "");
//string importFileDate = "";
if (reader.Read())
{
PortInNetID = reader.GetString(0);
PortOutNetID = reader.GetString(1);
HomeNetID = reader.GetString(2);
BeginDate = reader.GetString(3);
}
else
{
Result = ErrorDefinition.BT_IError_Result_NPDataNull_Code;
ErrMsg = ErrorDefinition.BT_IError_Result_NPDataNullError_Msg;
return(Result);
}
}
catch (Exception e)
{
ErrMsg = ErrorDefinition.BT_IError_Result_UnknowError_Msg + e.Message.ToString();
return(Result);
}
Result = ErrorDefinition.IError_Result_Success_Code;
ErrMsg = ErrorDefinition.IError_Result_Success_Msg;
return(Result);
}
