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