/// <summary>
/// 新增维护信息
/// </summary>
public JsonResult InsertTrainGrade(int userID, string oldgrade, string newgrade, string reason = "", int status = 1)
{
try
{
var model = new Sys_TrainGrade()
{
CreateUserID = CurrentUser.UserId,
UserID = userID,
OldGrade = oldgrade,
NewGrade = newgrade,
Reason = reason,
Status = status,
SubmitFlag = status == 0 ? 1 : 0//当为status的时候，即没有更新成功，就是提交申请的，此时，设为1
};
trainBL.InsertTrainGrade(model);
if (status == 1)
{
trainBL.UpdateTrainGrade(userID, newgrade);
}
return(Json(new
{
result = 1,
content = "维护级别成功"
}, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new
{
result = 0,
content = "维护级别失败"
}, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 新增维护信息
/// </summary>
/// <param name="model"></param>
public void InsertTrainGrade(Sys_TrainGrade model)
{
using (IDbConnection conn = OpenConnection())
{
const string sql = @"INSERT INTO dbo.Sys_TrainGrade
(
UserID,
CreateUserID,
OldGrade,
NewGrade,
Reason,
UpdateTime,
Status,
SubmitFlag
)
VALUES
(
@userid,
@createuserid,
@oldgrade,
@newgrade,
@reason,
getdate(),
@status,
@submitFlag
);SELECT @@IDENTITY AS ID" ;
var param = new
{
userid = model.UserID,
createuserid = model.CreateUserID,
oldgrade = model.OldGrade,
newgrade = model.NewGrade,
reason = model.Reason,
status = model.Status,
submitFlag = model.SubmitFlag
};
dynamic list = conn.Query <dynamic>(sql, param).FirstOrDefault();
model.ID = decimal.ToInt32(list.ID);
}
}
/// <summary>
/// 批量新增维护信息
/// </summary>
public JsonResult InsertAllTrainGrade()
{
try
{
var data = Request.Form["gradeList"];
dynamic traindata = Newtonsoft.Json.JsonConvert.DeserializeObject(data);
for (int i = 0; i < traindata.Count; i++)
{
var model = new Sys_TrainGrade()
{
UserID = traindata[i].userID,
CreateUserID = CurrentUser.UserId,
OldGrade = traindata[i].oldgrade,
NewGrade = traindata[i].newgrade,
Reason = traindata[i].reason,
Status = traindata[i].status,
SubmitFlag = traindata[i].status == 0 ? 1 : 0//当为status的时候，即没有更新成功，就是提交申请的，此时，设为1
};
trainBL.InsertTrainGrade(model);
if (model.Status == 1)
{
trainBL.UpdateTrainGrade(model.UserID, model.NewGrade);
}
}
return(Json(new
{
result = 1,
content = "维护级别成功"
}, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new
{
result = 0,
content = "维护级别失败"
}, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 新增维护信息
/// </summary>
/// <param name="model"></param>
public void InsertTrainGrade(Sys_TrainGrade model)
{
trainDB.InsertTrainGrade(model);
}
