31 lines
2.2 KiB
Transact-SQL
31 lines
2.2 KiB
Transact-SQL
insert into SGGLDB.dbo.t_d_department([NewID],DepartmentID,DepartmentName,ProjectId,ParentID,IsDel,IsDown,ParentDepartmentName,IsEnable)
|
|
select NEWID(), DepartmentID,DepartmentName,'e0356a29-984a-4bb3-a515-e69d5c0f7c78',ParentID,IsDel,IsDown,ParentDepartmentName,IsEnable
|
|
from SUBHSSEDB.dbo.t_d_department
|
|
go
|
|
|
|
insert into SGGLDB.dbo.t_d_employinfo([NewID],EmployID,WxEmployID,EmployNO,EmployName,CardNO,GroupID,IsAttend,IsDoor,BeginDateTime,EndDateTime,
|
|
InPassWord,DepartmentName,Mailbox,Mobilephone,WeiXinNO,PostName,Gender,IsDown,IsWxDown,IDCardNo,PlayCardNumber,
|
|
PlayCardSum,UpdataCloud,Birthday,Police,Nation,Address,UpdateState,UpdateDateTime,IsSubmarineBack,OnSiteState,
|
|
TimeNumber,CardTimeRecord,ReservedFieldsOne,ReservedFieldsTwo,ReservedFieldsThree,ReservedFieldsFour,ReservedFieldsFive,ProjectId)
|
|
select NEWID(),EmployID,WxEmployID,EmployNO,EmployName,CardNO,GroupID,IsAttend,IsDoor,BeginDateTime,EndDateTime,
|
|
InPassWord,DepartmentName,Mailbox,Mobilephone,WeiXinNO,PostName,Gender,IsDown,IsWxDown,IDCardNo,PlayCardNumber,
|
|
PlayCardSum,UpdataCloud,Birthday,Police,Nation,Address,UpdateState,UpdateDateTime,IsSubmarineBack,OnSiteState,
|
|
TimeNumber,CardTimeRecord,ReservedFieldsOne,ReservedFieldsTwo,ReservedFieldsThree,ReservedFieldsFour,ReservedFieldsFive
|
|
,'e0356a29-984a-4bb3-a515-e69d5c0f7c78'
|
|
from SUBHSSEDB.dbo.t_d_employinfo
|
|
go
|
|
|
|
insert into SGGLDB.dbo.t_d_EmployInOutRecord([NewID],EmployInOutRecordId,InstallationId,InstallationName,UnitId,UnitName,EmployNO,EmployName
|
|
,RecordDate,IDCardNo,Nation,PostName,WorkIn1,OffDuty1,WorkIn2,OffDuty2,WorkIn3,OffDuty3,ManHours,ProjectId)
|
|
select NEWID(),EmployInOutRecordId,InstallationId,InstallationName,UnitId,UnitName,EmployNO,EmployName
|
|
,RecordDate,IDCardNo,Nation,PostName,WorkIn1,OffDuty1,WorkIn2,OffDuty2,WorkIn3,OffDuty3,ManHours,'e0356a29-984a-4bb3-a515-e69d5c0f7c78'
|
|
from SUBHSSEDB.dbo.t_d_EmployInOutRecord
|
|
go
|
|
|
|
insert into SGGLDB.dbo.t_d_facerecord([NewID],ID,EmployName,DepartmentID,DepartName,AreaID,AreaName,EmployNO
|
|
,CardID,RoleID,DateTimeRecord,RecordDes,FaceIP,InOrOut,Des1,Des2,Des3,Des4,ProjectId)
|
|
select NEWID(),ID,EmployName,DepartmentID,DepartName,AreaID,AreaName,EmployNO
|
|
,CardID,RoleID,DateTimeRecord,RecordDes,FaceIP,InOrOut,Des1,Des2,Des3,Des4,'e0356a29-984a-4bb3-a515-e69d5c0f7c78'
|
|
from SUBHSSEDB.dbo.t_d_facerecord
|
|
go
|