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;
 }
Exemple #2
0
        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;
 }
Exemple #4
0
        public IISTable GetProductById(int id)
        {
            var data = new IISTable();

            return(data);
        }