usergroupdb.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Reflection;

using QSEDUNET.MODEL.BaseInfo;
using QSEDUNET.COMMAND;

namespace QSEDUNET.DATALABLE.BaseInfo
{
    public class UserGroupDB : SqlDBBaseConnection
    {
        public UserGroupDB() { }
        public UserGroupDB(SqlConnection objCon) : base(objCon) { }
        public UserGroupDB(SqlConnection objCon, SqlTransaction objTrans) : base(objCon, objTrans) { }

        /// <summary>
        /// 新建数据
        /// </summary>
        public int NewUserGroup(UserGroupModel objUserGroupModel)
		{
			try
			{
				SqlParameter[] parameters = 
					{
						new SqlParameter( "@UserGroup_ID",SqlDbType.Int),
						new SqlParameter( "@UserGroup_Name",SqlDbType.NVarChar,50),
						new SqlParameter( "@UserGroup_Msg",SqlDbType.NVarChar,50),
					};
				parameters[0].Direction = ParameterDirection.Output;
				parameters[1].Value = objUserGroupModel.UserGroup_Name;
				parameters[2].Value = objUserGroupModel.UserGroup_Msg;

				StroedProdedure( "SP_UserGroup_Insert", parameters );
				int returnValue = Run();

				return returnValue;

			}
			catch(Exception ex)
			{
				throw(ex);
			}
			finally
			{
				CommandDispose();
			}
		}

        /// <summary>
        /// 修改数据
        /// </summary>
        public bool UpUserGroup(UserGroupModel objUserGroupModel)
		{
			try
			{
				SqlParameter[] parameters = 
					{
						new SqlParameter( "@UserGroup_ID",SqlDbType.Int),
						new SqlParameter( "@UserGroup_Name",SqlDbType.NVarChar,50),
						new SqlParameter( "@UserGroup_Msg",SqlDbType.NVarChar,50),
					};
				parameters[0].Value = objUserGroupModel.UserGroup_ID;
				parameters[1].Value = objUserGroupModel.UserGroup_Name;
				parameters[2].Value = objUserGroupModel.UserGroup_Msg;

				StroedProdedure( "SP_UserGroup_Updata", parameters );
				bool returnValue = Run("upData");				

				return returnValue;

			}
			catch(Exception ex)
			{
				throw(ex);
			}
			finally
			{
				CommandDispose();
			}
		}

        /// <summary>
        /// 删除用户组
        /// </summary>
        /// <param name="objUserGroupModel">用户实体类</param>
        /// <returns>返回标示，bool</returns>
        public bool DelUserGroup(UserGroupModel objUserGroupModel)
        {
            try
            {
                SqlParameter[] parameters = 
					{
						new SqlParameter( "@UserGroup_ID",SqlDbType.Int),
					};
                parameters[0].Value = objUserGroupModel.UserGroup_ID;

                StroedProdedure("SP_UserGroup_Del", parameters);
                bool returnValue = Run("upData");

                return returnValue;

            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                CommandDispose();
            }
        }

        public DataSet GroupListDB()
        {
            try
            {
                DataSet objds;
                string sql = "select * from T_UserGroup";
                objds = RunDS(sql, "UserGroup");
                return objds;
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                CommandDispose();
            }
        }

    }
}