/**
 ** 送签单表 视图
 **/
IF EXISTS(SELECT 1 FROM sys.views WHERE name='View_ORDER_INORDER') 
   DROP VIEW View_ORDER_INORDER
GO 
CREATE VIEW View_ORDER_INORDER
AS

SELECT   dbo.ORDER_INORDER.CREATORID,dbo.ORDER_INORDER.ID AS id, dbo.ORDER_INORDER.INORDERCODE AS inOrderCode, 
                dbo.ORDER_INORDER.ORDERTYPE AS orderType, 
				dbo.ORDER_INORDER.ORDERSTATUS AS orderStatus, 
				dbo.ORDER_INORDER.OrderStatusId AS OrderStatusId, 
                dbo.ORDER_INORDER.TOTALNUM AS totalNum, dbo.ORDER_INORDER.DONENUM AS DoneNum, 
                dbo.ORDER_INORDER.UNLINENUM AS unLineNum, dbo.ORDER_INORDER.TOTALWEIGHT AS totalWeight, 
                dbo.ORDER_INORDER.UPDATETIME AS updateTime, dbo.ORDER_INORDER.ISFINISH AS isFinish, 
                dbo.ORDER_INORDER.DOTIME AS doTime, dbo.BASE_ITEM.ITEMNAME AS itemName, 
                dbo.BASE_ITEM.ITEMDES AS itemDes, dbo.BASE_ITEM.WEIGHT AS itemWeight, 
                dbo.BASE_ITEM.ITEMTYPE AS itemTYpe, dbo.BASE_ITEM.PRICE AS price, dbo.ORDER_INORDER.ENABLE AS enable, 
                dbo.BASE_ITEM.CREATELINE AS createLine, SYS_USER_1.USERNAME AS createName, 
                dbo.ORDER_INORDER.CLASSNO AS classNo, dbo.ORDER_INORDER.STATUS AS status, 
                dbo.SYS_USER.USERNAME AS checkerName, SYS_USER_2.USERNAME AS senderName,
				dbo.ORDER_INORDER.allFinishedNum,dbo.ORDER_INORDER.CheckTime,dbo.ORDER_INORDER.CheckResult
				,dbo.ORDER_INORDER.CheckRemark	,dbo.ORDER_INORDER.SendTime,dbo.ORDER_INORDER.CHECKERID,dbo.ORDER_INORDER.createTime,
SYS_USER_Update.USERNAME AS updateName
FROM      dbo.ORDER_INORDER LEFT JOIN
                dbo.SYS_USER AS SYS_USER_2 ON dbo.ORDER_INORDER.SENDERID = SYS_USER_2.ID LEFT JOIN
                dbo.SYS_USER ON dbo.ORDER_INORDER.CHECKERID = dbo.SYS_USER.ID LEFT OUTER JOIN
                dbo.SYS_USER AS SYS_USER_1 ON dbo.ORDER_INORDER.CREATORID = SYS_USER_1.ID LEFT OUTER JOIN
                dbo.BASE_ITEM ON dbo.ORDER_INORDER.ITEMID = dbo.BASE_ITEM.ID
							LEFT OUTER JOIN
                dbo.SYS_USER AS SYS_USER_Update ON dbo.ORDER_INORDER.UpdateUserId = SYS_USER_Update.ID 
   

GO



 /**
 ** 用户列表 视图
 **/
IF EXISTS(SELECT 1 FROM sys.views WHERE name='View_SYS_USER') 
   DROP VIEW View_SYS_USER
GO 
CREATE VIEW View_SYS_USER
AS

SELECT   dbo.SYS_USER.ID AS id, dbo.SYS_USER.USERNAME AS userName, 
                dbo.SYS_USER.USERTRUENAME AS userTrueName, dbo.SYS_USER.PASSWORD AS passWord, 
                dbo.SYS_ROLE.ROLENAME AS roleName, dbo.SYS_USER.ENABLE AS enable, 
                dbo.SYS_USER.UPDATETIME AS updateTime, dbo.SYS_DEPT.DEPTNAME AS deptName, 
                SYS_USER_1.USERNAME AS createName,dbo.SYS_USER.IsWeldingAuditGroup
FROM      dbo.SYS_DEPT RIGHT OUTER JOIN
                dbo.SYS_USER AS SYS_USER_1 RIGHT OUTER JOIN
                dbo.SYS_USER ON SYS_USER_1.ID = dbo.SYS_USER.CREATORID ON 
                dbo.SYS_DEPT.ID = dbo.SYS_USER.DEPTID LEFT OUTER JOIN
                dbo.SYS_ROLE LEFT OUTER JOIN
                dbo.SYS_USER_VS_ROLE ON dbo.SYS_ROLE.ID = dbo.SYS_USER_VS_ROLE.ROLEID ON 
                dbo.SYS_USER.ID = dbo.SYS_USER_VS_ROLE.USERID
   

GO