inboxes.cs

手机串口编程 手机串口编程 手机串口编程

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

namespace JB.GraduateDesign.ESM.DataAccess
{
	using JB.GraduateDesign.ESM.Entity;
	using JB.GraduateDesign.ESM.Common;

	public class InBoxes:IDisposable
	{
		private DataBaseOperate _dbo;

		public InBoxes()
		{
			_dbo = new DataBaseOperate();
		}

		public bool DeleteInBox ( int[] inBoxIds )
		{
			SqlParameter[] sqlParams =
			{
				new SqlParameter ( "@InBoxId", SqlDbType.Int ),
			};
			try
			{
				_dbo.StartTransation();
				for( int i = 0; i < inBoxIds.Length; i ++ )
				{
					sqlParams[0].Value = inBoxIds[i];
					_dbo.Execute ( "DeleteInBox", sqlParams );
				}
				_dbo.Commit();
			}
			catch ( Exception e )
			{
				throw new ApplicationException ( "访问数据库发生错误。", e );
			}

			return true;
		}

		public bool UpdateInBoxStatus ( int inBoxId, int status )
		{
			SqlParameter[] sqlParams =
			{
				new SqlParameter ( "@InBoxId", SqlDbType.Int ),
				new SqlParameter ( "@Status", SqlDbType.Int )
			};
			int i = 0;
			sqlParams[ i++ ].Value = inBoxId;
			sqlParams[ i++ ].Value = status;
			
			try
			{
				_dbo.Execute ( "UpdateInBoxStatus", sqlParams );
			}
			catch ( Exception e )
			{
				throw new ApplicationException ( "访问数据库发生错误。", e );
			}

			return true;
		}
	
		public InBoxData SelectInBox ( int receiveUserId, int status )
		{
			SqlParameter[] sqlParams = 
			{
				new SqlParameter ( "@ReceiveUserId", SqlDbType.Int ),
				new SqlParameter ( "@Status", SqlDbType.Int )
			};

			int i = 0;
			sqlParams[ i++ ].Value = receiveUserId;
			sqlParams[ i++ ].Value = status;

			InBoxData data = new InBoxData();

			try
			{
				_dbo.Search ( "SelectInBox", data.InBox, sqlParams );
			}
			catch ( Exception e )
			{
				throw new ApplicationException ( "访问数据库发生错误。", e );
			}

			return data;

		}

	
		#region IDisposable 成员

		public void Dispose()
		{
			Dispose(true);
			GC.SuppressFinalize(true); 
		}

		protected virtual void Dispose(bool disposing)
		{
			if (! disposing)
				return;

			if ( _dbo != null)
			{
				_dbo.Dispose();
				_dbo = null;
			}
		}

		#endregion
	}
}