public List <TAS_User> GetTAS_users(TAS_User tAS_user) { logHelper.InfoLog("", "GetTAS_users"); return(DapperHelper <TAS_User> .Query(@"SELECT * FROM [dbo].[TAS_User] where UId=@UId and Fname=@Fname and @Lname=Lname and Title=@Title and StaffNo=@StaffNo and Type=@Type", tAS_user)); }
public int AddTAS_users(TAS_User tAS_user) { logHelper.InfoLog("", "AddTAS_users"); return(DapperHelper <TAS_User> .Execute(@"INSERT INTO [dbo].[TAS_User] ([UId] ,[Fname] ,[Lname] ,[Title] ,[StaffNo] ,[Type]) VALUES (@UId ,@Fname ,@Lname ,@Title ,@StaffNo ,@Type)", tAS_user)); }
public int DelectTAS_users(TAS_User tAS_user) { logHelper.InfoLog("", "DelectTAS_users"); return(DapperHelper <TAS_User> .Execute(@"DELETE FROM [dbo].[TAS_User] WHERE id=@Id", tAS_user)); }