/// <summary>
/// 编辑培训信息
/// </summary>
/// <param name="model">培训信息</param>
/// <returns></returns>
public static bool SaveTrainingPlanInfo(TrainingModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
model.ModifiedUserID = userInfo.UserID;
//定义返回变量
bool isSucc = false;
//操作日志
LogInfoModel logModel = InitLogInfo(model.TrainingNo);
//更新
if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//执行更新操作
isSucc = TrainingDBHelper.UpdateTrainingInfo(model);
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
}
//插入
else
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//执行插入操作
isSucc = TrainingDBHelper.InsertTrainingInfo(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;
}
/// <summary>
/// 更新培训以及相关信息
/// </summary>
/// <param name="model">培训信息</param>
/// <returns></returns>
public static bool UpdateTrainingInfo(TrainingModel model)
{
#region 更新SQL拼写
StringBuilder updateSql = new StringBuilder();
updateSql.AppendLine(" UPDATE officedba.EmployeeTraining ");
updateSql.AppendLine(" SET TrainingName = @TrainingName ");
updateSql.AppendLine(" ,ApplyDate = @ApplyDate ");
updateSql.AppendLine(" ,EmployeeID = @EmployeeID ");
updateSql.AppendLine(" ,ProjectNo = @ProjectNo ");
updateSql.AppendLine(" ,ProjectName = @ProjectName ");
updateSql.AppendLine(" ,TrainingOrgan = @TrainingOrgan ");
updateSql.AppendLine(" ,PlanCost = @PlanCost ");
updateSql.AppendLine(" ,TrainingCount = @TrainingCount ");
updateSql.AppendLine(" ,Goal = @Goal ");
updateSql.AppendLine(" ,TrainingPlace = @TrainingPlace ");
updateSql.AppendLine(" ,TrainingWay = @TrainingWay ");
updateSql.AppendLine(" ,TrainingTeacher = @TrainingTeacher ");
updateSql.AppendLine(" ,StartDate = @StartDate ");
updateSql.AppendLine(" ,EndDate = @EndDate ");
updateSql.AppendLine(" ,TrainingRemark = @TrainingRemark ");
updateSql.AppendLine(" ,CheckPerson = @CheckPerson ");
updateSql.AppendLine(" ,Attachment = @Attachment ");
updateSql.AppendLine(" ,AttachmentName = @AttachmentName ");
updateSql.AppendLine(" ,ModifiedDate = getdate() ");
updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID ");
updateSql.AppendLine(" WHERE ");
updateSql.AppendLine(" CompanyCD = @CompanyCD ");
updateSql.AppendLine(" AND TrainingNo = @TrainingNo ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = updateSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//定义更新列表
ArrayList lstUpdate = new ArrayList();
//添加基本信息更新命令
lstUpdate.Add(comm);
//zzzzzzzzzzzzzzz
EditJionInfo(lstUpdate, model.UserList, model.TrainingNo, model.CompanyCD, model.ModifiedUserID);
//登陆或者更新进度安排信息
EditScheduleInfo(lstUpdate, model.ScheduleList, model.TrainingNo, model.CompanyCD, model.ModifiedUserID);
//执行更新操作并返回更新结果
return SqlHelper.ExecuteTransWithArrayList(lstUpdate);
}
/// <summary>
/// 保存时基本信息参数设置
/// </summary>
/// <param name="comm">命令</param>
/// <param name="model">人员信息</param>
private static void SetSaveParameter(SqlCommand comm, TrainingModel model)
{
//设置参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingNo", model.TrainingNo));//培训编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingName", model.TrainingName));//培训名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ApplyDate", model.ApplyDate));//发起时间
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID));//发起人ID(对应员工表ID)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProjectNo", model.ProjectNo));//项目编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProjectName", model.ProjectName));//项目名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingOrgan", model.TrainingOrgan));//培训机构
comm.Parameters.Add(SqlHelper.GetParameterFromString("@PlanCost", model.PlanCost));//费用预算
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingCount", model.TrainingCount));//培训天数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Goal", model.Goal));//目的
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingPlace", model.TrainingPlace));//培训地点
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingWay", model.TrainingWay));//培训方式ID（对应分类代码表ID）
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingTeacher", model.TrainingTeacher));//培训老师
comm.Parameters.Add(SqlHelper.GetParameterFromString("@StartDate", model.StartDate));//开始时间
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndDate", model.EndDate));//结束时间
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingRemark", model.TrainingRemark));//培训备注
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CheckPerson", model.CheckPerson));//考核人
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Attachment", model.PageAttachment));//附件
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AttachmentName", model.AttachmentName));//附件
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//更新用户ID
}
/// <summary>
/// 添加培训以及相关信息
/// </summary>
/// <param name="model">培训信息</param>
/// <returns></returns>
public static bool InsertTrainingInfo(TrainingModel model)
{
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine(" INSERT INTO officedba.EmployeeTraining ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,TrainingNo ");
insertSql.AppendLine(" ,TrainingName ");
insertSql.AppendLine(" ,ApplyDate ");
insertSql.AppendLine(" ,EmployeeID ");
insertSql.AppendLine(" ,ProjectNo ");
insertSql.AppendLine(" ,ProjectName ");
insertSql.AppendLine(" ,TrainingOrgan ");
insertSql.AppendLine(" ,PlanCost ");
insertSql.AppendLine(" ,TrainingCount ");
insertSql.AppendLine(" ,Goal ");
insertSql.AppendLine(" ,TrainingPlace ");
insertSql.AppendLine(" ,TrainingWay ");
insertSql.AppendLine(" ,TrainingTeacher ");
insertSql.AppendLine(" ,StartDate ");
insertSql.AppendLine(" ,EndDate ");
insertSql.AppendLine(" ,TrainingRemark ");
insertSql.AppendLine(" ,CheckPerson ");
insertSql.AppendLine(" ,Attachment ");
insertSql.AppendLine(" ,AttachmentName ");
insertSql.AppendLine(" ,Status ");
insertSql.AppendLine(" ,ModifiedDate ");
insertSql.AppendLine(" ,ModifiedUserID) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@TrainingNo ");
insertSql.AppendLine(" ,@TrainingName ");
insertSql.AppendLine(" ,@ApplyDate ");
insertSql.AppendLine(" ,@EmployeeID ");
insertSql.AppendLine(" ,@ProjectNo ");
insertSql.AppendLine(" ,@ProjectName ");
insertSql.AppendLine(" ,@TrainingOrgan ");
insertSql.AppendLine(" ,@PlanCost ");
insertSql.AppendLine(" ,@TrainingCount ");
insertSql.AppendLine(" ,@Goal ");
insertSql.AppendLine(" ,@TrainingPlace ");
insertSql.AppendLine(" ,@TrainingWay ");
insertSql.AppendLine(" ,@TrainingTeacher ");
insertSql.AppendLine(" ,@StartDate ");
insertSql.AppendLine(" ,@EndDate ");
insertSql.AppendLine(" ,@TrainingRemark ");
insertSql.AppendLine(" ,@CheckPerson ");
insertSql.AppendLine(" ,@Attachment ");
insertSql.AppendLine(" ,@AttachmentName ");
insertSql.AppendLine(" ,'0' ");
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);
//
EditJionInfo(lstInsert, model.UserList, model.TrainingNo, model.CompanyCD, model.ModifiedUserID);
//登陆或者更新进度安排信息
EditScheduleInfo(lstInsert, model.ScheduleList, model.TrainingNo, model.CompanyCD, model.ModifiedUserID);
//执行更新操作并返回更新结果
return SqlHelper.ExecuteTransWithArrayList(lstInsert);
}
