/// <summary> /// 修改角色记录 /// </summary> /// <returns>DataTable</returns> public static bool UpdateRoleInfo(RoleInfoModel model, string loginUserID, int RoleID) { //SQL拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.RoleInfo "); sql.AppendLine("SET "); sql.AppendLine(" RoleName = @RoleName, "); sql.AppendLine(" remark = @remark , "); sql.AppendLine(" ModifiedDate = @ModifiedDate "); sql.AppendLine(" ,ModifiedUserID = '" + loginUserID + "' "); sql.AppendLine("WHERE "); sql.AppendLine(" RoleID = " + RoleID + " and CompanyCD=@CompanyCD "); //设置参数 SqlParameter[] param = new SqlParameter[4]; param[0] = SqlHelper.GetParameter("@RoleName", model.RoleName); param[1] = SqlHelper.GetParameter("@remark", model.Remark); param[2] = SqlHelper.GetParameter("@CompanyCD",model.CompanyCD); param[3] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now); SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; }
/// <summary> /// 角色信息修改 /// </summary> /// <param name="model">角色信息</param> /// <returns>更新成功与否</returns> public static bool UpdateRoleInfo(RoleInfoModel model,int RoleID) { //获取登陆用户ID string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID; //带修改 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.RoleName); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = RoleInfoDBHelper.UpdateRoleInfo(model, loginUserID, RoleID); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception) { return false; throw; } }
/// <summary> /// 添加角色记录 /// </summary> /// <returns>DataTable</returns> public static bool InsertRoleInfo(RoleInfoModel model, string loginUserID, out string ID) { //SQL拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO officedba.RoleInfo"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,RoleName "); sql.AppendLine(" ,remark "); sql.AppendLine(" ,ModifiedUserID) "); sql.AppendLine("VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@RoleName "); sql.AppendLine(" ,@remark "); sql.AppendLine(" ,'" + loginUserID + "') "); sql.AppendLine("set @ID= @@IDENTITY"); //设置参数 SqlParameter[] param = new SqlParameter[4]; param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); param[1] = SqlHelper.GetParameter("@remark", model.Remark); param[2] = SqlHelper.GetParameter("@RoleName", model.RoleName); param[3] = SqlHelper.GetOutputParameter("@ID", SqlDbType.Int); SqlHelper.ExecuteTransSql(sql.ToString(), param); ID = param[3].Value.ToString(); return SqlHelper.Result.OprateCount > 0 ? true : false; }
/// <summary> /// 角色信息插入 /// </summary> /// <param name="model">角色信息</param> /// <returns>插入成功与否</returns> public static bool InsertRoleInfo(RoleInfoModel model,out string ID) { ID="0"; //获取登陆用户ID string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;// 待修改 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.RoleName); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; succ = RoleInfoDBHelper.InsertRoleInfo(model, loginUserID, out ID); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception ex) { WriteSystemLog(userInfo, ex); return false; } }