public static chartData GetChartData(string date,string ip,string domain) { var param = int.Parse(date.Replace("-", string.Empty).Substring(2, 6)); var chartData = new chartData(); 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).ToList(); chartData.ErrorRequstArray=new int[list.Count]; chartData.TimeoutRequestArray=new int[list.Count]; chartData.ErrorInnerArray=new int[list.Count]; for (var i=0;i<list.Count;i++) { chartData.ErrorRequstArray[i] = list[i].ClinetErrorCount; chartData.ErrorInnerArray[i] = list[i].ServerErrorCount; chartData.TimeoutRequestArray[i] = list[i].TimeoutCount; } return chartData; }
public static chartData GetChartData(string date, string ip, string domain) { var param = int.Parse(date.Replace("-", string.Empty).Substring(2, 6)); var chartData = new chartData(); 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).ToList(); chartData.ErrorRequstArray = new int[list.Count]; chartData.TimeoutRequestArray = new int[list.Count]; chartData.ErrorInnerArray = new int[list.Count]; for (var i = 0; i < list.Count; i++) { chartData.ErrorRequstArray[i] = list[i].ClinetErrorCount; chartData.ErrorInnerArray[i] = list[i].ServerErrorCount; chartData.TimeoutRequestArray[i] = list[i].TimeoutCount; } return(chartData); }