예제 #1
0
        /// <summary>
        /// 编辑考试记录信息
        /// </summary>
        /// <param name="model">保存信息</param>
        /// <returns></returns>
        public static bool SaveTestInfo(EmployeeTestModel model)
        {
            //获取登陆用户信息
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
            //设置公司代码
            model.CompanyCD = userInfo.CompanyCD;
            model.ModifiedUserID = userInfo.UserID;
            //定义返回变量
            bool isSucc = false;
            //操作日志
            LogInfoModel logModel = InitLogInfo(model.TestNo);

            //更新
            if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
            {
                try
                {
                    logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
                    //执行更新操作
                    isSucc = EmployeeTestDBHelper.UpdateEmployeeTestInfo(model);
                }
                catch (Exception ex)
                {
                    //输出系统日志
                    WriteSystemLog(userInfo, ex);
                }
            }
            //插入
            else
            {
                try
                {
                    logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
                    //执行插入操作
                    isSucc = EmployeeTestDBHelper.InsertEmployeeTestInfo(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 InsertEmployeeTestInfo(EmployeeTestModel model)
        {

            #region 插入SQL拼写
            StringBuilder insertSql = new StringBuilder();
            insertSql.AppendLine(" INSERT INTO officedba.EmployeeTest ");
            insertSql.AppendLine(" 	(CompanyCD                        ");
            insertSql.AppendLine(" 	,TestNo                           ");
            insertSql.AppendLine(" 	,Title                            ");
            insertSql.AppendLine(" 	,Teacher                          ");
            insertSql.AppendLine(" 	,StartDate                        ");
            insertSql.AppendLine(" 	,EndDate                          ");
            insertSql.AppendLine(" 	,Addr                             ");
            insertSql.AppendLine(" 	,TestContent                      ");
            insertSql.AppendLine(" 	,TestResult                       ");
            insertSql.AppendLine(" 	,Remark                           ");
            insertSql.AppendLine(" 	,Status                           ");
            insertSql.AppendLine(" 	,Attachment                       ");
            insertSql.AppendLine(" 	,AttachmentName                   ");
            insertSql.AppendLine(" 	,AbsenceCount                     ");
            insertSql.AppendLine(" 	,ModifiedDate                     ");
            insertSql.AppendLine(" 	,ModifiedUserID)                  ");
            insertSql.AppendLine(" VALUES                             ");
            insertSql.AppendLine(" 	(@CompanyCD                       ");
            insertSql.AppendLine(" 	,@TestNo                          ");
            insertSql.AppendLine(" 	,@Title                           ");
            insertSql.AppendLine(" 	,@Teacher                         ");
            insertSql.AppendLine(" 	,@StartDate                       ");
            insertSql.AppendLine(" 	,@EndDate                         ");
            insertSql.AppendLine(" 	,@Addr                            ");
            insertSql.AppendLine(" 	,@TestContent                     ");
            insertSql.AppendLine(" 	,@TestResult                      ");
            insertSql.AppendLine(" 	,@Remark                          ");
            insertSql.AppendLine(" 	,@Status                          ");
            insertSql.AppendLine(" 	,@Attachment                      ");
            insertSql.AppendLine(" 	,@AttachmentName                  ");
            insertSql.AppendLine(" 	,@AbsenceCount                    ");
            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.ScoreList, model.TestNo, model.CompanyCD, model.ModifiedUserID);

            //执行更新操作并返回更新结果
            return SqlHelper.ExecuteTransWithArrayList(lstInsert);

        }
        /// <summary>
        /// 更新考试记录信息
        /// </summary>
        /// <param name="model">保存信息</param>
        /// <returns></returns>
        public static bool UpdateEmployeeTestInfo(EmployeeTestModel model)
        {

            #region 更新SQL拼写
            StringBuilder updateSql = new StringBuilder();
            updateSql.AppendLine(" UPDATE officedba.EmployeeTest      ");
            updateSql.AppendLine(" SET                                ");
            updateSql.AppendLine(" 	Title = @Title                    ");
            updateSql.AppendLine(" 	,Teacher = @Teacher               ");
            updateSql.AppendLine(" 	,StartDate = @StartDate           ");
            updateSql.AppendLine(" 	,EndDate = @EndDate               ");
            updateSql.AppendLine(" 	,Addr = @Addr                     ");
            updateSql.AppendLine(" 	,TestContent = @TestContent       ");
            updateSql.AppendLine(" 	,TestResult = @TestResult         ");
            updateSql.AppendLine(" 	,Remark = @Remark                 ");
            updateSql.AppendLine(" 	,Status = @Status                 ");
            updateSql.AppendLine(" 	,Attachment = @Attachment         ");
            updateSql.AppendLine(" 	,AttachmentName = @AttachmentName ");
            updateSql.AppendLine(" 	,AbsenceCount = @AbsenceCount     ");
            updateSql.AppendLine(" 	,ModifiedDate = getdate()         ");
            updateSql.AppendLine(" 	,ModifiedUserID = @ModifiedUserID ");
            updateSql.AppendLine(" WHERE                              ");
            updateSql.AppendLine(" 	CompanyCD = @CompanyCD            ");
            updateSql.AppendLine(" 	AND TestNo = @TestNo              ");
            #endregion

            //定义更新基本信息的命令
            SqlCommand comm = new SqlCommand();
            comm.CommandText = updateSql.ToString();
            //设置保存的参数
            SetSaveParameter(comm, model);
            //定义更新列表
            ArrayList lstUpdate = new ArrayList();
            //添加基本信息更新命令
            lstUpdate.Add(comm);
            //登陆或者更新进度安排信息
            EditResultInfo(lstUpdate, model.ScoreList, model.TestNo, model.CompanyCD, model.ModifiedUserID);

            //执行更新操作并返回更新结果
            return SqlHelper.ExecuteTransWithArrayList(lstUpdate);
        }
 /// <summary>
 /// 保存时基本信息参数设置
 /// </summary>
 /// <param name="comm">命令</param>
 /// <param name="model">保存信息</param>
 private static void SetSaveParameter(SqlCommand comm, EmployeeTestModel model)
 {
     //设置参数
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@TestNo", model.TestNo));//考试编号
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Title", model.Title));//主题
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Teacher", model.Teacher));//考试负责人ID(对应员工表ID)
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@StartDate", model.StartDate));//开始时间
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndDate", model.EndDate));//结束时间
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Addr", model.Addr));//考试地点
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@TestContent", model.TestContent));//考试内容摘要
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@TestResult", model.TestResult));//考试结果
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));//备注
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Status", model.Status));//考试状态(0未开始,1已结束)
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Attachment", model.PageAttachment));//附件
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@AttachmentName", model.AttachmentName));//附件名称
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@AbsenceCount", model.AbsenceCount));//缺考人数
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//更新用户ID
 }