示例#1
0
 public List <TAS_Duty> GetTAS_Dutys(TAS_Duty tAS_Duty)
 {
     logHelper.InfoLog("", "GetTAS_Dutys");
     return(DapperHelper <TAS_Duty> .Query(@"SELECT *
                                   FROM [dbo].[TAS_Duty] 
                                       where StaffNo=@StaffNo and CostCentre=@CostCentre and Hours=@Hours and Duty=@Duty", tAS_Duty));
 }
示例#2
0
    public int AddTAS_Dutys(TAS_Duty tAS_Duty)
    {
        logHelper.InfoLog("", "AddTAS_Dutys");
        return(DapperHelper <TAS_Duty> .Execute(@"INSERT INTO [dbo].[TAS_Duty]
       ([StaffNo]
       ,[CostCentre]
       ,[Hours]
       ,[Duty])
 VALUES
       (@StaffNo
       ,@CostCentre
       ,@Hours
       ,@Duty)", tAS_Duty));
    }