public static IISTable GetIisData(string date,string ip,string domain)
{
var param = int.Parse(date.Replace("-", string.Empty).Substring(2,6));
var connectionStr = JsonOperater.GetAppSetting().Connection;
var connection = new SqlConnection(connectionStr);
var sql = string.Format("select * from IISLogger with(nolock) where hour like '{0}%' order by hour", param);
var list = connection.Query<HourModel>(sql).Where(s => s.Domain == domain && s.IP == ip).OrderByDescending(s => s.Hour).ToList();
var item = new IISTable();
item.List = list;
item.Count = 1;
return item;
}
public static IISTable GetIisData(string date, string ip, string domain)
{
var param = int.Parse(date.Replace("-", string.Empty).Substring(2, 6));
var connectionStr = JsonOperater.GetAppSetting().Connection;
var connection = new SqlConnection(connectionStr);
var sql = string.Format("select * from IISLogger with(nolock) where hour like '{0}%' order by hour", param);
var list = connection.Query <HourModel>(sql).Where(s => s.Domain == domain && s.IP == ip).OrderByDescending(s => s.Hour).ToList();
var item = new IISTable();
item.List = list;
item.Count = 1;
return(item);
}
public IISTable GetProductById(int id)
{
var data = new IISTable();
return data;
}
public IISTable GetProductById(int id)
{
var data = new IISTable();
return(data);
}