public static bool UpdateGatherSummaryCheckInfo(PerformanceSummaryModel model)
{
bool isSucc = false;
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine("update officedba.PerformanceSummary ");
insertSql.AppendLine(" set SignNote=@SignNote ");
insertSql.AppendLine(" , SignDate=getdate() ");
insertSql.AppendLine(" ,ModifiedUserID=@ModifiedUserID ");
insertSql.AppendLine(" ,ModifiedDate=getdate() ");
insertSql.AppendLine("where CompanyCD=@CompanyCD and TaskNo=@TaskNo and TemplateNo=@TemplateNo and EmployeeID=@EmployeeID ");
insertSql.AppendLine(" ");
#endregion
//定义插入基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo)); //类型名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TemplateNo", model.TemplateNo)); //创建人
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));
comm.Parameters.Add(SqlHelper.GetParameterFromString("@SignNote", model.SignNote )); //公司代码
//添加返回参数
// comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int));
//执行插入操作
isSucc = SqlHelper.ExecuteTransWithCommand(comm);
return isSucc;
}
public static bool UpdatePerSummaryInfobyCheck(PerformanceSummaryModel model)
{
bool isSucc = false;
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine("update officedba.PerformanceSummary ");
insertSql.AppendLine(" set AddScore=@AddScore ");
insertSql.AppendLine(" ,AdviceNote=@AdviceNote ");
insertSql.AppendLine(" ,AdviceType=@AdviceType ");
insertSql.AppendLine(" , Evaluater=@Evaluater ");
insertSql.AppendLine(" , EvaluateDate=getdate() ");
insertSql.AppendLine(" ,KillScore=@KillScore ");
insertSql.AppendLine(" ,LevelType=@LevelType ");
insertSql.AppendLine(" , Remark=@Remark ");
insertSql.AppendLine(" , RewardNote=@RewardNote ");
insertSql.AppendLine(" , SummaryNote=@SummaryNote ");
insertSql.AppendLine(" ,RealScore=@RealScore ");
insertSql.AppendLine(" ,ModifiedUserID=@ModifiedUserID ");
insertSql.AppendLine(" ,ModifiedDate=getdate() ");
insertSql.AppendLine("where CompanyCD=@CompanyCD and TaskNo=@TaskNo and TemplateNo=@TemplateNo and EmployeeID=@EmployeeID ");
#endregion
//定义插入基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo)); //类型名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TemplateNo", model.TemplateNo)); //创建人
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AddScore", model.AddScore)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdviceNote", model.AdviceNote)); //类型名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdviceType", model.AdviceType)); //创建人
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Evaluater", model.Evaluater)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@KillScore", model.KillScore)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@LevelType", model.LevelType));
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark)); //创建人
comm.Parameters.Add(SqlHelper.GetParameterFromString("@RewardNote", model.RewardNote)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@SummaryNote", model.SummaryNote)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@RealScore", model.RealScore));
//添加返回参数
// comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int));
//执行插入操作
isSucc = SqlHelper.ExecuteTransWithCommand(comm);
return isSucc;
}
public static bool GatherSummaryCheckInfo(PerformanceSummaryModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//定义返回变量
bool isSucc = false;
//操作日志
LogInfoModel logModel = InitLogInfo(model.TaskNo );
try
{
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//执行更新操作
/// isSucc = PerformanceTaskDBHelper.UpdatePerTaskInfo(model, modellist, modleSummaryList);
if (PerformanceSummaryDBHelper.UpdateGatherSummaryCheckInfo(model))
{
isSucc = true;
}
else
{
isSucc = false;
}
}
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;
}