using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using Models; using System.Data.SqlClient; namespace DAL { public class IpInfoService { /// /// 查询所有 /// /// sql语句 /// 可变参数数组 /// 返回集合 List excuteSql(string sql, params SqlParameter[] param) { return ServiceBase.excuteSql(new IpInfo(), "IpInfo", sql, CommandType.Text, param); } /// /// 查询所有地址为中国的Ip段 /// /// public List GetAllIpInfo() { string strSql = "select * from IpInfo where country like '%中国%'"; return excuteSql(strSql); } } }