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