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;
       }