/// <summary>
///
/// </summary>
/// <param name="sortGradeCourse"></param>
/// <param name="sys_PayGrade">薪酬级别</param>
/// <param name="sortIds">体系</param>
/// <returns></returns>
public JsonResult SubmitSys_SortGradeCourse(Sys_SortGradeCourse sortGradeCourse, string sys_PayGrade = "", string sortIds = "")
{
if (sortGradeCourse.Id == 0)
{
//添加
_sysPayGradeBL.AddSys_SortGradeCourse(sortGradeCourse);//添加课程
//
loopAddSortGradeCourse(sortGradeCourse, sys_PayGrade, sortIds);
if (sortGradeCourse.Id > 0)
{
return(Json(new
{
result = 1,
content = "保存成功！"
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new
{
result = 0,
content = "保存失败"
}, JsonRequestBehavior.AllowGet));
}
}
else
{
//修改
bool newid = _sysPayGradeBL.UpdateSys_SortGradeCourse(sortGradeCourse);
if (newid)
{
_sysPayGradeBL.DeleteSys_SortLinkGrade(sortGradeCourse.Id);//删除所有
loopAddSortGradeCourse(sortGradeCourse, sys_PayGrade, sortIds);
return(Json(new
{
result = 1,
content = "保存成功"
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new
{
result = 0,
content = "保存失败"
}, JsonRequestBehavior.AllowGet));
}
}
}
private void loopAddSortGradeCourse(Sys_SortGradeCourse sortGradeCourse, string sys_PayGrade, string sortIds)
{
string[] payGradeArray = sys_PayGrade.Split(',');
string[] sortIdsArray = sortIds.Split(',');
foreach (var item in payGradeArray)
{
foreach (var itemSort in sortIdsArray)
{
if (!string.IsNullOrEmpty(item) && !string.IsNullOrEmpty(itemSort))
{
_sysPayGradeBL.AddSys_SortLinkGrade(new Sys_SortLinkGrade()
{
GradeID = int.Parse(item),
SortID = int.Parse(itemSort),
CourseId = sortGradeCourse.Id
});
}
}
}
}
/// <summary>
/// Update 胜任力课程
/// </summary>
/// <returns></returns>
public bool UpdateSys_SortGradeCourse(Sys_SortGradeCourse model)
{
using (var conn = OpenConnection())
{
const string sqlwhere =
@"update Sys_SortGradeCourse set Name=@Name,OpenLeavel=@OpenLeavel,
Type=@Type,IsMust=@IsMust,IsDelete=@IsDelete where Id=@CourseId";
var param = new
{
CourseId = model.Id,
Name = model.Name,
OpenLeavel = model.OpenLeavel,
Type = model.Type,
IsMust = model.IsMust,
IsDelete = model.IsDelete
};
return(conn.Execute(sqlwhere, param) > 0);
}
}
/// <summary>
/// ADD 胜任力课程
/// </summary>
/// <returns></returns>
public int AddSys_SortGradeCourse(Sys_SortGradeCourse model)
{
using (IDbConnection connection = OpenConnection())
{
const string strSql =
@"insert into Sys_SortGradeCourse(Name,OpenLeavel,Type,IsMust,IsDelete) values(@Name,@OpenLeavel,@Type,@IsMust,0)
SELECT @@Identity AS ID";
var param = new
{
Name = model.Name,
OpenLeavel = model.OpenLeavel,
Type = model.Type,
IsMust = model.IsMust
};
decimal id =
connection.Query <decimal>(strSql, param)
.FirstOrDefault();
model.Id = decimal.ToInt32(id);
}
return(model.Id);
}
/// <summary>
/// ADD 胜任力课程
/// </summary>
/// <returns></returns>
public int AddSys_SortGradeCourse(Sys_SortGradeCourse model)
{
return(payGradeDB.AddSys_SortGradeCourse(model));
}
/// <summary>
/// Update 胜任力课程
/// </summary>
/// <returns></returns>
public bool UpdateSys_SortGradeCourse(Sys_SortGradeCourse model)
{
return(payGradeDB.UpdateSys_SortGradeCourse(model));
}
