usergroup.cs

高校 学籍管理、成绩、收费、网上教学

//************************************************************
//项目:学生学籍管理系统　　　　　　　 
//版权:Copyright(c) ,TZZ  　　　　　　　　　　　　　
//模块名:基础数据模块
//说明:UserGroup基础类
//版本:1.0
//修改历史：
//	2006-6-7 BY Gawain
//			初始版本
//*****************************************************************
using System;
using System.Collections.Generic;
using System.Text;

using QSEDUNET.COMMAND;
using QSEDUNET.DATALABLE.BaseInfo;
using QSEDUNET.MODEL.BaseInfo;
using System.Data;

namespace QSEDUNET.BL.BaseInfo
{
    public class UserGroup:SqlDBBaseConnection
    {
        public UserGroup()
        { 
            
        }

        /// <summary>
        /// 新增加用户组
        /// </summary>
        /// <param name="userGroupModel">用户组实体类</param>
        /// <returns></returns>
        public bool CreateGroup(UserGroupModel userGroupModel)
        {
            try
            {
                Connection();
                BeginTranse();
                bool groupValue = false;
                UserGroupDB objUserGroup = new UserGroupDB(conn, objTranse);
                if (objUserGroup.NewUserGroup(userGroupModel) < 1)
                    groupValue = true;
                CommitTranse();
                return groupValue;
            }
            catch (Exception ex)
            {
                RollbackTranse();
                throw ex;
            }
            finally
            {
                CloseConnection();
            }
        }

        /// <summary>
        /// 修改用户组
        /// </summary>
        /// <param name="userGroupModel">用户组实体类</param>
        /// <returns></returns>
        public bool UpGroup(UserGroupModel userGroupModel)
        {
            try
            {
                bool reValue = false;
                Connection();
                BeginTranse();
                UserGroupDB objUserGroup = new UserGroupDB(conn, objTranse);
                reValue = objUserGroup.UpUserGroup(userGroupModel);
                CommitTranse();
                return reValue;
            }
            catch (Exception ex)
            {
                RollbackTranse();
                throw ex;
            }
            finally
            {
                
                CloseConnection();
            }
        }

        /// <summary>
        /// 删除用户组
        /// </summary>
        /// <param name="userGroupModel">用户组实体类</param>
        /// <returns></returns>
        public bool DelGroup(UserGroupModel userGroupModel)
        {
            try
            {
                bool reValue = false;
                Connection();
                BeginTranse();
                UserGroupDB objUserGroup = new UserGroupDB(conn, objTranse);
                UserGroupRoleDB objGroupRole = new UserGroupRoleDB(conn, objTranse);

                objGroupRole.DelUserGroupRole(userGroupModel.UserGroup_ID,"Group");
                reValue = objUserGroup.DelUserGroup(userGroupModel);
                CommitTranse();
                return reValue;
            }
            catch (Exception ex)
            {
                RollbackTranse();
                throw ex;
            }
            finally
            {
                CloseConnection();
            }
        }

        public DataSet GroupList()
        {
            try
            {
                DataSet objds;
                Connection();

                UserGroupDB objuserGroup = new UserGroupDB(conn);
                objds = objuserGroup.GroupListDB();

                return objds;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                CloseConnection();
            }
        }
    }
}