/// <summary>
/// 添加培训考核信息
/// </summary>
/// <param name="model">培训考核信息</param>
/// <returns></returns>
public static bool InsertTrainingAsseInfo(TrainingAsseModel model)
{
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine(" INSERT INTO officedba.TrainingAsse ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,AsseNo ");
insertSql.AppendLine(" ,TrainingNo ");
insertSql.AppendLine(" ,CheckPerson ");
insertSql.AppendLine(" ,TrainingPlan ");
insertSql.AppendLine(" ,FillUser ");
insertSql.AppendLine(" ,LeadViews ");
insertSql.AppendLine(" ,Description ");
insertSql.AppendLine(" ,CheckWay ");
insertSql.AppendLine(" ,CheckDate ");
insertSql.AppendLine(" ,GeneralComment ");
insertSql.AppendLine(" ,CheckRemark ");
insertSql.AppendLine(" ,ModifiedDate ");
insertSql.AppendLine(" ,ModifiedUserID) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@AsseNo ");
insertSql.AppendLine(" ,@TrainingNo ");
insertSql.AppendLine(" ,@CheckPerson ");
insertSql.AppendLine(" ,@TrainingPlan ");
insertSql.AppendLine(" ,@FillUser ");
insertSql.AppendLine(" ,@LeadViews ");
insertSql.AppendLine(" ,@Description ");
insertSql.AppendLine(" ,@CheckWay ");
insertSql.AppendLine(" ,@CheckDate ");
insertSql.AppendLine(" ,@GeneralComment ");
insertSql.AppendLine(" ,@CheckRemark ");
insertSql.AppendLine(" ,getdate() ");
insertSql.AppendLine(" ,@ModifiedUserID) ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//定义更新列表
ArrayList lstInsert = new ArrayList();
//添加基本信息更新命令
lstInsert.Add(comm);
//考核结果
EditResultInfo(lstInsert, model.ResultList, model.AsseNo, model.CompanyCD, model.ModifiedUserID);
//执行更新操作并返回更新结果
return(SqlHelper.ExecuteTransWithArrayList(lstInsert));
}
/// <summary>
/// 保存时基本信息参数设置
/// </summary>
/// <param name="comm">命令</param>
/// <param name="model">人员信息</param>
private static void SetSaveParameter(SqlCommand comm, TrainingAsseModel model)
{
//设置参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AsseNo", model.AsseNo)); //考核编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingNo", model.TrainingNo)); //培训编号（对应培训表中的培训编号）
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CheckPerson", model.CheckPerson)); //考核人
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingPlan", model.TrainingPlan)); //培训规划
comm.Parameters.Add(SqlHelper.GetParameterFromString("@LeadViews", model.LeadViews)); //领导意见
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Description", model.Description)); //说明
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CheckWay", model.CheckWay)); //考核方式
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CheckDate", model.CheckDate)); //考核时间
comm.Parameters.Add(SqlHelper.GetParameterFromString("@GeneralComment", model.GeneralComment)); //考核总评
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CheckRemark", model.CheckRemark)); //考核备注
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID)); //更新用户ID
//插入时，添加填写人参数
if (ConstUtil.EDIT_FLAG_INSERT == model.EditFlag)
{
comm.Parameters.Add(SqlHelper.GetParameterFromString("@FillUser", model.FillUser));//填写人
}
}
/// <summary>
/// 更新考核信息
/// </summary>
/// <param name="model">考核信息</param>
/// <returns></returns>
public static bool UpdateTrainingAsseInfo(TrainingAsseModel model)
{
#region 更新SQL拼写
StringBuilder updateSql = new StringBuilder();
updateSql.AppendLine(" UPDATE officedba.TrainingAsse ");
updateSql.AppendLine(" SET ");
updateSql.AppendLine(" TrainingNo = @TrainingNo ");
updateSql.AppendLine(" ,CheckPerson = @CheckPerson ");
updateSql.AppendLine(" ,TrainingPlan = @TrainingPlan ");
updateSql.AppendLine(" ,LeadViews = @LeadViews ");
updateSql.AppendLine(" ,Description = @Description ");
updateSql.AppendLine(" ,CheckWay = @CheckWay ");
updateSql.AppendLine(" ,CheckDate = @CheckDate ");
updateSql.AppendLine(" ,GeneralComment = @GeneralComment ");
updateSql.AppendLine(" ,CheckRemark = @CheckRemark ");
updateSql.AppendLine(" ,ModifiedDate = getdate() ");
updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID ");
updateSql.AppendLine(" WHERE ");
updateSql.AppendLine(" CompanyCD = @CompanyCD ");
updateSql.AppendLine(" AND AsseNo = @AsseNo ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = updateSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//定义更新列表
ArrayList lstUpdate = new ArrayList();
//添加基本信息更新命令
lstUpdate.Add(comm);
//登陆或者更新进度安排信息
EditResultInfo(lstUpdate, model.ResultList, model.AsseNo, model.CompanyCD, model.ModifiedUserID);
//执行更新操作并返回更新结果
return(SqlHelper.ExecuteTransWithArrayList(lstUpdate));
}
/// <summary>
/// 编辑培训考核信息
/// </summary>
/// <param name="model">考聘信息</param>
/// <returns></returns>
public static bool SaveTrainingAsseInfo(TrainingAsseModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
model.ModifiedUserID = userInfo.UserID;
//定义返回变量
bool isSucc = false;
//操作日志
LogInfoModel logModel = InitLogInfo(model.AsseNo);
//更新
if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//执行更新操作
isSucc = TrainingAsseDBHelper.UpdateTrainingAsseInfo(model);
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
}
//插入
else
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//执行插入操作
isSucc = TrainingAsseDBHelper.InsertTrainingAsseInfo(model);
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
}
//更新成功时
if (isSucc)
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
//更新不成功
else
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
