rolepopedomdb.cs

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

//************************************************************
//项目:学生学籍管理系统　　　　　　　 
//版权:Copyright(c) ,TZZ  　　　　　　　　　　　　　
//模块名:基础数据模块
//说明:RolePopedom基础类
//版本: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 RolePopedomDB : SqlDBBaseConnection
    {
        public RolePopedomDB() { }
        public RolePopedomDB(SqlConnection objCon) : base(objCon) { }
        public RolePopedomDB(SqlConnection objCon, SqlTransaction objTrans) : base(objCon, objTrans) { }

        /// <summary>
        /// 新建数据
        /// </summary>
        public int NewRolePopedom(RolePopedomModel objRolePopedomModel)
        {
            try
            {
                SqlParameter[] parameters = 
					{
						new SqlParameter( "@UserRole_Popedom_ID",SqlDbType.Int),
						new SqlParameter( "@UserRole_ID",SqlDbType.Int),
						new SqlParameter( "@UserPopedom_ID",SqlDbType.Int),
						new SqlParameter( "@UserRole_Popedom_Msg",SqlDbType.NVarChar,100),
					};
                parameters[0].Direction = ParameterDirection.Output;
                parameters[1].Value = objRolePopedomModel.UserRole_ID;
                parameters[2].Value = objRolePopedomModel.UserPopedom_ID;
                parameters[3].Value = objRolePopedomModel.UserRole_Popedom_Msg;

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

                return returnValue;

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

        /// <summary>
        /// 修改数据
        /// </summary>
        public bool UpRolePopedom(RolePopedomModel objRolePopedomModel)
        {
            try
            {
                SqlParameter[] parameters = 
					{
						new SqlParameter( "@UserRole_Popedom_ID",SqlDbType.Int),
						new SqlParameter( "@UserRole_ID",SqlDbType.Int),
						new SqlParameter( "@UserPopedom_ID",SqlDbType.Int),
						new SqlParameter( "@UserRole_Popedom_Msg",SqlDbType.NVarChar,100),
					};
                parameters[0].Value = objRolePopedomModel.UserRole_Popedom_ID;
                parameters[1].Value = objRolePopedomModel.UserRole_ID;
                parameters[2].Value = objRolePopedomModel.UserPopedom_ID;
                parameters[3].Value = objRolePopedomModel.UserRole_Popedom_Msg;

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

                return returnValue;

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

        /// <summary>
        /// 删除角色权限
        /// </summary>
        /// <param name="inValue">输入值</param>
        /// <param name="tab">需要操作的字段名</param>
        /// <returns></returns>
        public int DelRolePopedom(int inValue,string tab)
        {
            try
            {
                string sql = "";
                switch (tab)
                {
                    case "Role":
                        sql = "delete from T_UserRole_Popedom where UserRole_ID = " + inValue;
                        break;
                    case "Popedom":
                        sql = "delete from T_UserRole_Popedom where UserPopedom_ID = " + inValue;
                        break;
                    default:
                        sql = "delete from T_UserRole_Popedom where UserPopedom_ID = -1";
                        break;
                }
                int returnValue = RunSQL(sql);
                return returnValue;
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                CommandDispose();
            }
        }

    }

}