예제 #1
0
 /// <summary>
 ///  ADD薪酬级别关联体系 并关联课程
 /// </summary>
 /// <returns></returns>
 public int AddSys_SortLinkGrade(Sys_SortLinkGrade model)
 {
     using (IDbConnection connection = OpenConnection())
     {
         const string strSql =
             @"insert into Sys_SortLinkGrade(GradeID,SortID,CourseId) values(@GradeID,@SortID,@CourseId)
         SELECT @@Identity AS ID";
         var param = new
         {
             GradeID  = model.GradeID,
             SortID   = model.SortID,
             CourseId = model.CourseId
         };
         decimal id =
             connection.Query <decimal>(strSql, param)
             .FirstOrDefault();
         model.Id = decimal.ToInt32(id);
     }
     return(model.Id);
 }
예제 #2
0
 /// <summary>
 ///  ADD薪酬级别关联体系
 /// </summary>
 /// <returns></returns>
 public int AddSys_SortLinkGrade(Sys_SortLinkGrade model)
 {
     return(payGradeDB.AddSys_SortLinkGrade(model));
 }