/// <summary> /// 更新面试评测要素信息 /// </summary> /// <param name="model">保存信息</param> /// <returns></returns> public static bool UpdateCheckElemInfo(RectCheckElemModel model) { #region 更新SQL拼写 StringBuilder updateSql = new StringBuilder(); updateSql.AppendLine(" UPDATE officedba.RectCheckElem "); updateSql.AppendLine(" SET CompanyCD = @CompanyCD "); updateSql.AppendLine(" ,ElemName = @ElemName "); updateSql.AppendLine(" ,Standard = @Standard "); updateSql.AppendLine(" ,Remark = @Remark "); updateSql.AppendLine(" ,UsedStatus = @UsedStatus "); updateSql.AppendLine(" ,ModifiedDate = getdate() "); updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); updateSql.AppendLine(" WHERE "); updateSql.AppendLine(" ID = @ElemID "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = updateSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //执行插入操作并返回更新结果 return SqlHelper.ExecuteTransWithCommand(comm); }
/// <summary> /// 添加面试评测要素信息 /// </summary> /// <param name="model">面试评测要素信息</param> /// <returns></returns> public static bool InsertCheckElemInfo(RectCheckElemModel model) { #region 插入SQL拼写 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine(" INSERT INTO officedba.RectCheckElem "); insertSql.AppendLine(" (CompanyCD "); insertSql.AppendLine(" ,ElemName "); insertSql.AppendLine(" ,Standard "); insertSql.AppendLine(" ,Remark "); insertSql.AppendLine(" ,UsedStatus "); insertSql.AppendLine(" ,ModifiedDate "); insertSql.AppendLine(" ,ModifiedUserID) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@CompanyCD "); insertSql.AppendLine(" ,@ElemName "); insertSql.AppendLine(" ,@Standard "); insertSql.AppendLine(" ,@Remark "); insertSql.AppendLine(" ,@UsedStatus "); insertSql.AppendLine(" ,getdate() "); insertSql.AppendLine(" ,@ModifiedUserID) "); insertSql.AppendLine(" set @ElemID= @@IDENTITY "); #endregion //定义插入基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = insertSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //添加返回参数 comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int)); //执行插入操作 bool isSucc = SqlHelper.ExecuteTransWithCommand(comm); //设置ID model.ID = comm.Parameters["@ElemID"].Value.ToString(); //返回更新结果 return isSucc; }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { RectCheckElemModel searchModel = new RectCheckElemModel(); //设置查询条件 //要素名称 searchModel.ElemName = txtSearchElemName.Value.Trim(); //启用状态 searchModel.UsedStatus = Request.Form["sltSearchUsedStatus"].ToString(); if (searchModel.ElemName != null) { int bbb = searchModel.ElemName.IndexOf('%');///过滤字符串 if (bbb != -1) { searchModel.ElemName = searchModel.ElemName.Replace('%', ' '); } } //查询数据 DataTable dtData = RectCheckElemBus.SearchRectCheckElemInfo(searchModel); //导出标题 string headerTitle = "要素名称|启用状态"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "ElemName|UsedStatusName"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "面试评测要素设置"); }
/// <summary> /// 查询面试评测要素信息 /// </summary> /// <param name="model">查询条件</param> /// <returns></returns> public static DataTable SearchCheckElemInfo(RectCheckElemModel model) { #region 查询语句 //查询SQL拼写 StringBuilder searchSql = new StringBuilder(); searchSql.AppendLine(" SELECT "); searchSql.AppendLine(" ID "); searchSql.AppendLine(" ,ISNULL(ElemName, '') AS ElemName "); searchSql.AppendLine(" ,ISNULL(Standard, '') AS Standard "); searchSql.AppendLine(" ,ISNULL(Remark, '') AS Remark "); searchSql.AppendLine(" ,CASE UsedStatus "); searchSql.AppendLine(" WHEN '0' THEN '停用' "); searchSql.AppendLine(" WHEN '1' THEN '启用' "); searchSql.AppendLine(" ELSE '' "); searchSql.AppendLine(" END AS UsedStatusName ,isnull( Convert(varchar(100),ModifiedDate,23),'') AS ModifiedDate "); searchSql.AppendLine(" FROM "); searchSql.AppendLine(" officedba.RectCheckElem "); searchSql.AppendLine(" WHERE "); searchSql.AppendLine(" CompanyCD = @CompanyCD "); #endregion //定义查询的命令 SqlCommand comm = new SqlCommand(); //添加公司代码参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //要素名称 if (!string.IsNullOrEmpty(model.ElemName)) { searchSql.AppendLine(" AND ElemName LIKE '%' + @ElemName + '%' "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ElemName", model.ElemName)); } //启用状态 if (!string.IsNullOrEmpty(model.UsedStatus)) { searchSql.AppendLine(" AND UsedStatus = @UsedStatus "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus)); } //指定命令的SQL文 comm.CommandText = searchSql.ToString(); //执行查询 return SqlHelper.ExecuteSearch(comm); }
/// <summary> /// 保存时基本信息参数设置 /// </summary> /// <param name="comm">命令</param> /// <param name="model">保存信息</param> private static void SetSaveParameter(SqlCommand comm, RectCheckElemModel model) { //设置参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ElemName", model.ElemName));//要素名称 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Standard", model.Standard));//评分标准 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));//备注 comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用状态(0停用,1启用) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//最后更新用户ID if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag)) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@ElemID", model.ID));//ID } }
/// <summary> /// 编辑面试评测要素信息 /// </summary> /// <param name="model">保存信息</param> /// <returns></returns> public static bool SaveRectCheckElemInfo(RectCheckElemModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; //设置最后修改者 model.ModifiedUserID = userInfo.UserID; //定义返回变量 bool isSucc = false; //操作日志 LogInfoModel logModel = InitLogInfo(model.ID); //更新 if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag)) { try { logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //执行更新操作 isSucc = RectCheckElemDBHelper.UpdateCheckElemInfo(model); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } } //插入 else { try { logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //执行插入操作 isSucc = RectCheckElemDBHelper.InsertCheckElemInfo(model); logModel.ObjectID = model.ID; } 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="deptID">组织机构ID</param> /// <returns></returns> public static DataTable SearchRectCheckElemInfo(RectCheckElemModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //获取公司代码 model.CompanyCD = userInfo.CompanyCD; //执行查询 return RectCheckElemDBHelper.SearchCheckElemInfo(model); }