예제 #1
0
 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));
 }
예제 #2
0
    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));
    }