public void Log(string msg)
{
EFTracingProviderConfiguration.RegisterProvider();
EFCachingProviderConfiguration.RegisterProvider();
EFTracingProviderConfiguration.LogToConsole = false;
TextWriter logFile = File.CreateText("SqlExcuteLog.txt");
ExtendedGuangZhou_GbEntities gz_gb_ex = new ExtendedGuangZhou_GbEntities();
gz_gb_ex.Log = logFile;
}
private DataTable viewTableDetail_gb()
{
EFTracingProviderConfiguration.RegisterProvider();
EFCachingProviderConfiguration.RegisterProvider();
EFTracingProviderConfiguration.LogToConsole = false;
TextWriter logFile = File.CreateText("SqlExcuteLog.txt");
ExtendedGuangZhou_GbEntities gz_gb_ex = new ExtendedGuangZhou_GbEntities();
gz_gb_ex.Log = logFile;
var cnt_t = gz_gb_ex.Gb_FlowControlx.Count();
var size_t = gz_gb_ex.Gb_FlowControlx.Sum(e => e.ip_len);
var gngi = from p in gz_gb_ex.Gb_FlowControlx
group p by p.Flow_Control_MsgType into ttt
select new
{
ttt.Key,
cnt = ttt.Count(),
cnt_total = cnt_t,
cnt_percent = 1.0 * ttt.Count() / cnt_t,
size = ttt.Sum(e => e.ip_len),
size_total = size_t,
size_percent = 1.0 * ttt.Sum(e => e.ip_len) / size_t,
};
var dborder = gngi.OrderByDescending(e => e.cnt).ToList();
return dborder.ToDataTable();
}
