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