userfunctiondb.cs

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

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

		/// <summary>
		/// 新建数据
		/// </summary>
		public int NewUserFunction(UserFunctionModel objUserFunctionModel)
		{
			try
			{
				SqlParameter[] parameters = 
					{
						new SqlParameter( "@UserFunction_ID",SqlDbType.Int),
						new SqlParameter( "@UserFunction_Name",SqlDbType.NVarChar,50),
						new SqlParameter( "@UserFunciton_Msg",SqlDbType.NVarChar,50),
						new SqlParameter( "@Function_Level",SqlDbType.Int),
						new SqlParameter( "@Del_Flag",SqlDbType.Int),
					};
				parameters[0].Direction = ParameterDirection.Output;
				parameters[1].Value = objUserFunctionModel.UserFunction_Name;
				parameters[2].Value = objUserFunctionModel.UserFunciton_Msg;
				parameters[3].Value = objUserFunctionModel.Function_Level;
				parameters[4].Value = objUserFunctionModel.Del_Flag;

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

				return returnValue;

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

		/// <summary>
		/// 修改数据
		/// </summary>
		public bool UpUserFunction(UserFunctionModel objUserFunctionModel)
		{
			try
			{
				SqlParameter[] parameters = 
					{
						new SqlParameter( "@UserFunction_ID",SqlDbType.Int),
						new SqlParameter( "@UserFunction_Name",SqlDbType.NVarChar,50),
						new SqlParameter( "@UserFunciton_Msg",SqlDbType.NVarChar,50),
						new SqlParameter( "@Function_Level",SqlDbType.Int),
						new SqlParameter( "@Del_Flag",SqlDbType.Int),
					};
				parameters[0].Value = objUserFunctionModel.UserFunction_ID;
				parameters[1].Value = objUserFunctionModel.UserFunction_Name;
				parameters[2].Value = objUserFunctionModel.UserFunciton_Msg;
				parameters[3].Value = objUserFunctionModel.Function_Level;
				parameters[4].Value = objUserFunctionModel.Del_Flag;

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

				return returnValue;

			}
			catch(Exception ex)
			{
				throw(ex);
			}
			finally
			{
				CommandDispose();
			}
		}
		
		/// <summary>
		/// 删除数据
		/// </summary>
		public bool DelUserFunction(UserFunctionModel objUserFunctionModel)
		{
			try
			{
				SqlParameter[] parameters = 
					{
						new SqlParameter( "@UserFunction_ID",SqlDbType.Int),
					};
				parameters[0].Value = objUserFunctionModel.UserFunction_ID;

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

				return returnValue;

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

	}
}