C#酒店管理系统

最近用了几天的时间，快速学习了一下C#和C#Winform编程，感受一下C#的魅力。
下面附上几张图，系统还在完善中。。。
末尾附上插入视图后触发的触发器语句，感觉太笨重了，求赐教。

触发器：
因为员工基本信息表（EmployeeBasicInfo ）关联到很多其它表，所以创建了一个视图来提取员工的信息（而不是该表中的bit、int型变量）
EmployeeBasicInfo表中部分信息：

view_EmployeeBasicInfo视图中部分信息：

插入视图的触发器语句：

  create trigger InsertView on view_EmployeeBasicInfo 
  instead of insert
  as
  begin
    --设置变量（类别）
	declare @DefineSex nchar(2)
	declare @SexID bit
	select Sex from inserted
	select @DefineSex = Sex from inserted
	select ID from SexTypeEnum as ST where ST.Define = @DefineSex
	select @SexID = ID from SexTypeEnum 
	
	declare @DefineEdu nchar(4)
	declare @EduID int
	select Edu from inserted
	select @DefineEdu = Edu from inserted
	select ID from EducationTypeEnum as ET where ET.Define = @DefineEdu
	select @EduID = ID from EducationTypeEnum

	declare @DefineMaj nvarchar(20)
	declare @MajID int
	select Maj from inserted
	select @DefineMaj = Maj from inserted
	select ID from MajorTypeEnum as MT where MT.Define = @DefineEdu
	select @MajID = ID from MajorTypeEnum

	declare @DefineNat nvarchar(20)
	declare @NatID int
	select Nat from inserted
	select @DefineNat = Nat from inserted
	select ID from NationTypeEnum as NT where NT.Define = @DefineNat
	select @NatID = ID from NationTypeEnum

	declare @DefineMar nchar(4)
	declare @MarID int
	select Mar from inserted
	select @DefineMar = Mar from inserted
	select ID from MarriageTypeEnum as MT where MT.Define = @DefineMar
	select @MarID = ID from MarriageTypeEnum

	declare @DefinePol nchar(4)
	declare @PolID int
	select Pol from inserted
	select @DefinePol = Pol from inserted
	select ID from PoliticalOutlookTypeEnum as PT where PT.Define = @DefinePol
	select @PolID = ID from PoliticalOutlookTypeEnum

	declare @DefineSta nvarchar(20)
	declare @StaID int
	select Sta from inserted
	select @DefineSta = Sta from inserted
	select ID from StaffTypeEnum as ST where ST.Define = @DefineSta
	select @StaID = ID from StaffTypeEnum

	declare @DefineJob nvarchar(20)
	declare @JobID int
	select Job from inserted
	select @DefineJob = Job from inserted
	select ID from JobTypeEnum as JT where JT.Define = @DefineJob
	select @JobID = ID from JobTypeEnum

	declare @DefineDep nvarchar(20)
	declare @DepID int
	select Dep from inserted
	select @DefineDep = Dep from inserted
	select ID from DepartmentTypeEnum as DT where DT.Define = @DefineDep
	select @DepID = ID from DepartmentTypeEnum

	declare @DefineWag nvarchar(20)
	declare @WagID int
	select Wag from inserted
	select @DefineWag = Wag from inserted
	select ID from WageTypeEnum as WT where WT.Define = @DefineWag
	select @WagID = ID from WageTypeEnum

	declare @DefineTit nvarchar(20)
	declare @TitID int
	select Tit from inserted
	select @DefineTit = Tit from inserted
	select ID from TitleTypeEnum as TT where TT.Define = @DefineTit
	select @TitID = ID from TitleTypeEnum

	declare @DefinePro nvarchar(10)
	declare @ProID int
	select Pro from inserted
	select @DefinePro = Pro from inserted
	select ID from ProvinceTypeEnum as PT where PT.Define = @DefinePro
	select @ProID = ID from ProvinceTypeEnum

	declare @DefineCit nvarchar(20)
	declare @CitID int
	select Cit from inserted
	select @DefineCit = Cit from inserted
	select ID from CityTypeEnum as CT where CT.Define = @DefineCit
	select @CitID = ID from CityTypeEnum

	--设置变量接收信息
	declare @ID varchar(5)
	select ID from inserted
	select @ID = ID from inserted

	declare @Name nvarchar(20)
	select Name from inserted
	select @Name = Name from inserted

	declare @Age int
	select Age from inserted
	select @Age = Age from inserted

	declare @School nvarchar(50)
	select School from inserted
	select @School = School from inserted

	declare @GdTime datetime
	select GraduationTime from inserted
	select @GdTime = GraduationTime from inserted

	declare @Birthday datetime
	select Birthday from inserted
	select @Birthday = Birthday from inserted

	declare @IDNumber varchar(18)
	select IDNumber from inserted
	select @IDNumber = IDNumber from inserted

	declare @Hiredate datetime
	select Hiredate from inserted
	select @Hiredate = Hiredate from inserted

	declare @WorkAge int
	select WorkAge from inserted
	select @WorkAge = WorkAge from inserted

	declare @Telephone varchar(8)
	select Telephone from inserted
	select @Telephone = Telephone from inserted

	declare @Mobilephone varchar(11)
	select Mobilephone from inserted
	select @Mobilephone = Mobilephone from inserted

	declare @HomeAddress nvarchar(50)
	select HomeAddress from inserted
	select @HomeAddress = HomeAddress from inserted

	declare @Photo binary
	select Photo from inserted
	select @Photo = Photo from inserted

	declare @Salary int
	select Salary from inserted
	select @Salary = Salary from inserted

	declare @BankAccount varchar(20)
	select BankAccount from inserted
	select @BankAccount = BankAccount from inserted

	declare @BeginOfContract datetime
	select BeginOfContract from inserted
	select @BeginOfContract = BeginOfContract from inserted

	declare @EndofContract datetime
	select EndofContract from inserted
	select @EndofContract = EndofContract from inserted

	declare @YearOfContract int
	select YearOfContract from inserted
	select @YearOfContract = YearOfContract from inserted

	insert into EmployeeBasicInfo values(@ID, @Name, @SexID , 19, @EduID, @School, @MajID, @GdTime, @NatID, @MarID, @PolID, @Birthday, @IDNumber, @Hiredate, @WorkAge, @StaID, @JobID, @DepID, @WagID, @TitID, @Telephone, @Mobilephone, @HomeAddress, @Photo, @ProID, @CitID, @Salary, @BankAccount, @BeginOfContract, @EndofContract, @YearOfContract)
  end