TXT BN089-BS开发框架MVC4版/source20131023/Zephyr.Web/logs/log20130927.txt

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

2013-09-27 10:08:15,827 [8500] DEBUG Sys - select name from dbo.sysobjects where id = object_id(N'[dbo].[fun_getPY]') and xtype in (N'FN', N'IF', N'TF')
2013-09-27 10:08:16,055 [8500] DEBUG Sys - select name from dbo.sysobjects where id = object_id(N'[dbo].[fun_getPY]') and xtype in (N'FN', N'IF', N'TF')
2013-09-27 10:08:16,062 [8500] DEBUG Mms - select name from dbo.sysobjects where id = object_id(N'[dbo].[fun_getPY]') and xtype in (N'FN', N'IF', N'TF')
2013-09-27 10:08:16,127 [8500] DEBUG Mms - select name from dbo.sysobjects where id = object_id(N'[dbo].[fun_getPY]') and xtype in (N'FN', N'IF', N'TF')
2013-09-27 10:08:21,488 [11532] DEBUG Servicesys_user - 获取实体对象
2013-09-27 10:08:21,507 [11532] DEBUG Sys - select sys_user.* from sys_user where  UserCode =  'lhs'and Password =  'lhs'and IsEnable =  'True'
2013-09-27 10:08:21,904 [11532] DEBUG Sys - 
update sys_user
set LoginCount = isnull(LoginCount,0) + 1
   ,LastLoginDate = getdate()
where UserCode = 'lhs' 
2013-09-27 10:08:21,966 [11532] DEBUG Sys - insert into sys_loginHistory([UserCode],[UserName],[HostName],[HostIP],[LoginCity],[LoginDate]) values('lhs','刘会胜','LHS-PC','ILData[0]/localhost','福建省厦门市','2013-09-27 10:08:21')
2013-09-27 10:08:21,972 [11532] DEBUG Servicemms_project - 获取实体对象
2013-09-27 10:08:21,973 [11532] DEBUG Mms - select mms_project.* from mms_project where  ProjectCode =  '201306030001'
2013-09-27 10:08:22,069 [3536] DEBUG Sys - select * from sys_userSetting where UserCode='lhs'
2013-09-27 10:08:24,723 [12864] DEBUG Sys - 
--角色的菜单
select distinct B.*
from sys_roleMenuMap A
inner join sys_menu  B on B.MenuCode = A.MenuCode
where B.IsEnable='1'
  and RoleCode in (
  select RoleCode from sys_userRoleMap where UserCode = 'lhs' --用户的角色
union all
  select RoleCode from sys_organizeRoleMap where OrganizeCode in  --机构的角色
  (
	select OrganizeCode from sys_userOrganizeMap where UserCode = 'lhs'
  )  
)
order by B.MenuSeq,B.MenuCode
2013-09-27 10:08:32,448 [13576] DEBUG Sys - 
select 1
from sys_roleMenuMap A
left join sys_userRoleMap B on B.RoleCode = A.RoleCode
left join sys_menu C on C.MenuCode = A.MenuCode
where B.UserCode = 'lhs'
and C.URL in ('/Mms/product/Index','/Mms/product')
2013-09-27 10:08:32,464 [13576] DEBUG Servicesys_code - 获取动态列表
2013-09-27 10:08:32,465 [13576] DEBUG Sys - select Code as value,Text as text from sys_code where  CodeType =  'MeasureUnit'
2013-09-27 10:08:34,031 [12840] DEBUG Servicemms_product - 获取动态列表
2013-09-27 10:08:34,031 [12840] DEBUG Mms - select top 20 * from mms_product order by ID
2013-09-27 10:08:34,180 [12840] DEBUG Mms - select count(*) from ( select * from mms_product ) tb_temp
2013-09-27 10:16:59,089 [12864] DEBUG Sys - 
select 1
from sys_roleMenuMap A
left join sys_userRoleMap B on B.RoleCode = A.RoleCode
left join sys_menu C on C.MenuCode = A.MenuCode
where B.UserCode = 'lhs'
and C.URL in ('/Mms/product/Index','/Mms/product')
2013-09-27 10:16:59,092 [12864] DEBUG Servicesys_code - 获取动态列表
2013-09-27 10:16:59,092 [12864] DEBUG Sys - select Code as value,Text as text from sys_code where  CodeType =  'MeasureUnit'
2013-09-27 10:16:59,845 [7484] DEBUG Servicemms_product - 获取动态列表
2013-09-27 10:16:59,850 [7484] DEBUG Mms - select top 20 * from mms_product order by ID
2013-09-27 10:16:59,851 [7484] DEBUG Mms - select count(*) from ( select * from mms_product ) tb_temp
2013-09-27 10:21:42,107 [11532] DEBUG Servicemms_product - 获取动态列表
2013-09-27 10:21:42,107 [11532] DEBUG Mms - select top 20 * from mms_product order by ID
2013-09-27 10:21:42,108 [11532] DEBUG Mms - select count(*) from ( select * from mms_product ) tb_temp
2013-09-27 10:21:44,389 [7484] DEBUG Sys - 
select 1
from sys_roleMenuMap A