/// <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);
}
/// <summary>
/// ADD薪酬级别关联体系
/// </summary>
/// <returns></returns>
public int AddSys_SortLinkGrade(Sys_SortLinkGrade model)
{
return(payGradeDB.AddSys_SortLinkGrade(model));
}