public List <TAS_Staff> GetTAS_Staffs(TAS_Staff tAS_Staff) { logHelper.InfoLog("", "GetTAS_Staffs"); return(DapperHelper <TAS_Staff> .Query(@"SELECT * FROM [dbo].[TAS_Staff] where No=@No and CostCentre=@CostCentre and Dept=@Dept and Role=@Role", tAS_Staff)); }
public int AddTAS_Staff(TAS_Staff tAS_Staff) { logHelper.InfoLog("", "tAS_Staff"); return(DapperHelper <TAS_Staff> .Execute(@"INSERT INTO [dbo].[TAS_Staff] ([No] ,[CostCentre] ,[Dept] ,[Role]) VALUES (@No ,@CostCentre ,@Dept ,@Role)", tAS_Staff)); }