public static DataTable GetAllPortPD() { DataTable dataTable = new DataTable(); DBConn dBConn = null; DbCommand dbCommand = null; DbDataAdapter dbDataAdapter = null; string commandText; if (DBUrl.DB_CURRENT_TYPE.ToUpper().Equals("MYSQL") || DBUrl.SERVERMODE) { commandText = "select * from port_data_daily" + DateTime.Now.ToString("yyyyMMdd"); try { dBConn = DBConnPool.getDynaConnection(); if (dBConn != null && dBConn.con != null) { dbDataAdapter = DBConn.GetDataAdapter(dBConn.con); dbCommand = dBConn.con.CreateCommand(); dbCommand.CommandText = commandText; dbDataAdapter.SelectCommand = dbCommand; dbDataAdapter.Fill(dataTable); dbDataAdapter.Dispose(); dbCommand.Dispose(); dBConn.Close(); } return(dataTable); } catch (Exception) { try { dbDataAdapter.Dispose(); } catch { } try { dbCommand.Dispose(); } catch { } try { dBConn.Close(); } catch { } return(dataTable); } } commandText = "select * from port_data_daily "; try { dBConn = DBConnPool.getDynaConnection(DateTime.Now); if (dBConn != null && dBConn.con != null) { dbDataAdapter = new OleDbDataAdapter(); dbCommand = dBConn.con.CreateCommand(); dbCommand.CommandText = commandText; dbDataAdapter.SelectCommand = dbCommand; dbDataAdapter.Fill(dataTable); dbDataAdapter.Dispose(); dbCommand.Dispose(); dBConn.Close(); } } catch (Exception) { try { dbDataAdapter.Dispose(); } catch { } try { dbCommand.Dispose(); } catch { } try { dBConn.Close(); } catch { } } return(dataTable); }
public static int DeleteByName(string str_zonename) { DBConn dBConn = null; DbCommand dbCommand = new OleDbCommand(); try { dBConn = DBConnPool.getConnection(); if (dBConn.con != null) { string commandText = "select * from zone_info z inner join group_detail g on z.id = g.dest_id where z.zone_nm = '" + str_zonename + "' and g.grouptype = 'zone'"; dbCommand = DBConn.GetCommandObject(dBConn.con); dbCommand.CommandType = CommandType.Text; dbCommand.CommandText = commandText; DbDataAdapter dataAdapter = DBConn.GetDataAdapter(dBConn.con); dataAdapter.SelectCommand = dbCommand; DataTable dataTable = new DataTable(); dataAdapter.Fill(dataTable); if (dataTable.Rows.Count > 0) { string commandText2 = string.Concat(new object[] { "delete from group_detail where grouptype = 'zone' and group_id = ", dataTable.Rows[0]["group_id"], " and dest_id =", dataTable.Rows[0]["dest_id"] }); dbCommand.CommandText = commandText2; dbCommand.ExecuteNonQuery(); } string commandText3 = "delete from zone_info where zone_nm = '" + str_zonename + "'"; dbCommand.CommandText = commandText3; int result = dbCommand.ExecuteNonQuery(); dbCommand.Parameters.Clear(); DBCacheStatus.ZONE = true; DBCacheStatus.DBSyncEventSet(true, new string[] { "DBSyncEventName_Service_ZONE" }); return(result); } } catch (Exception ex) { DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace); } finally { try { dbCommand.Dispose(); } catch { } if (dBConn != null) { dBConn.close(); } } return(-1); }