public DataTable NW_Dhcp_Ip_GetbyPoolModem_MySQL()
{
string sql = "select * from NW_Dhcp_Ip where Name like '%Modem%'";
return(MySqlConnect.ExecQuery(sql));
}
public DataTable NW_Dhcp_Ip_GetbyCPEStatic_MySQL()
{
string sql = "select * from NW_Dhcp_Ip where Name like 'CPE%' and Static=1";
return(MySqlConnect.ExecQuery(sql));
}
public DataTable NW_Dhcp_Customer_GetbyIp_MySQL()
{
string sql = "select * from NW_Dhcp_Customer where IpAddress='" + IpAddress + "'";
return(MySqlConnect.ExecQuery(sql));
}
public DataTable NW_Dhcp_Ip_GetIPbyPool_MySQL()
{
string sql = "select * from NW_Dhcp_Ip where PoolIP ='" + PoolIp + "'";
return(MySqlConnect.ExecQuery(sql));
}
public DataTable NW_Dhcp_Customer_GetbyPoolPublic_MySQL()
{
string sql = "select * from NW_Dhcp_Customer where PoolPublic='" + PoolIp + "'";
return(MySqlConnect.ExecQuery(sql));
}