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