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

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

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

2013-08-29 00:10:17,560 [12576] 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-08-29 00:10:17,591 [12576] 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-08-29 00:10:17,598 [12576] 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-08-29 00:10:17,599 [12576] 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-08-29 00:10:37,276 [11836] DEBUG Servicesys_user - 获取实体对象
2013-08-29 00:10:37,294 [11836] DEBUG Sys - select sys_user.* from sys_user where  UserCode =  'lhs'and Password =  'lhs'and IsEnable =  'True'
2013-08-29 00:10:37,396 [11836] DEBUG Sys - 
update sys_user
set LoginCount = isnull(LoginCount,0) + 1
   ,LastLoginDate = getdate()
where UserCode = 'lhs' 
2013-08-29 00:10:37,511 [11836] DEBUG Sys - insert into sys_loginHistory([UserCode],[UserName],[HostName],[HostIP],[LoginCity],[LoginDate]) values('lhs','刘会胜','LHS-PC','ILData[0]/localhost','福建省厦门市','2013-08-29 0:10:37')
2013-08-29 00:10:37,556 [11836] DEBUG Servicemms_project - 获取实体对象
2013-08-29 00:10:37,556 [11836] DEBUG Mms - select mms_project.* from mms_project where  ProjectCode =  '201306030001'
2013-08-29 00:10:37,765 [4196] DEBUG Sys - select * from sys_userSetting where UserCode='lhs'
2013-08-29 00:10:45,392 [6360] 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-08-29 00:10:45,425 [6360] 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-08-29 00:10:45,432 [6360] 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-08-29 00:10:45,433 [6360] 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-08-29 00:10:45,766 [9820] 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-08-29 00:10:51,561 [13892] 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/send/Index','/Mms/send')
2013-08-29 00:10:51,582 [13892] DEBUG Servicemms_warehouse - 获取动态列表
2013-08-29 00:10:51,599 [13892] DEBUG Mms - select WarehouseCode as value,WarehouseName as text from mms_warehouse where  ProjectCode =  '201306030001'
2013-08-29 00:10:51,600 [13892] DEBUG Servicesys_code - 获取动态列表
2013-08-29 00:10:51,600 [13892] DEBUG Sys - select Code as value,Text as text from sys_code where  CodeType =  'Pricing'
2013-08-29 00:10:51,601 [13892] DEBUG Servicesys_code - 获取动态列表
2013-08-29 00:10:51,601 [13892] DEBUG Sys - select Code as value,Text as text from sys_code where  CodeType =  'MaterialUse'
2013-08-29 00:13:19,710 [7440] DEBUG Servicemms_send - 获取动态列表
2013-08-29 00:13:19,711 [7440] DEBUG Mms - select top 20 
        A.*, B.ProjectName, C.MaterialTypeName, D.WarehouseName,E.MerchantsName as PickUnitName
     from 
        mms_send A
        left join mms_project       B on B.ProjectCode      = A.ProjectCode
        left join mms_materialType  C on C.MaterialType = A.MaterialType
        left join mms_warehouse         D on D.WarehouseCode       = A.WarehouseCode
        left join mms_merchants E on E.MerchantsCode=A.PickUnit
     where  A.ProjectCode =  '201306030001' order by A.BillNo
2013-08-29 00:13:19,787 [7440] DEBUG Mms - select count(*) from ( select 
        A.*, B.ProjectName, C.MaterialTypeName, D.WarehouseName,E.MerchantsName as PickUnitName
     from