create view tb_sys_user as
SELECT loginname AS userno, loginname, username, SUBSTRING(sys.fn_sqlvarbasetostr(HashBytes('MD5', pwd)), 3, 32)
AS pwd, sex, old, deptno, phone, mobile, EMAIL, CREDENTIALSTYPE, CREDENTIALSNO, UPDATETIME, remark,
userstate AS state, 'boy5.jpg' AS avatar
FROM MIS_workflow.dbo.tb_sys_user
UNION
select userno, loginname, username, pwd, sex, old, deptno, phone, mobile, EMAIL, CREDENTIALSTYPE, CREDENTIALSNO, UPDATETIME, remark,
state, 'boy5.jpg' AS avatar from tb_sys_user_bak;
create view tb_sys_dept as
SELECT CONVERT(varchar(32),deptno) deptno, deptname, CONVERT(varchar(32),parentno) as parentno, updatetime, state, CONVERT(varchar(32),deptno) AS seq
FROM MIS_workflow.dbo.tb_sys_dept
UNION
select deptno, deptname, CONVERT(varchar(32),parentno), updatetime, state, CONVERT(varchar(32),seq) as seq from tb_sys_dept_bak;