userinfos.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 UserInfos : IDisposable
	{

		private DataBaseOperate _dbo;

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

		public UserInfoData Login( string loginName, string password)
		{
			return null;
			
		}


		public UserInfoData SelectUserInfo( UserInfoQuery userInfoQuery)
		{
			SqlParameter[] Params = 
			{
				new SqlParameter( "@UserId", SqlDbType.Int ),
				new SqlParameter( "@LoginName", SqlDbType.Char, 20 ),
				new SqlParameter( "@Password", SqlDbType.Char, 20 ),
				new SqlParameter( "@UserName", SqlDbType.Char, 20 ),
				new SqlParameter( "@Gender", SqlDbType.Int ),
				new SqlParameter( "@Mobile", SqlDbType.Char, 12 )
			};

			int i = 0;
			Params[ i++ ].Value = userInfoQuery.UserId;
			Params[ i++ ].Value = userInfoQuery.LoginName;
			Params[ i++ ].Value = userInfoQuery.Password;
			Params[ i++ ].Value = userInfoQuery.UserName;
			Params[ i++ ].Value = userInfoQuery.Gender;
			Params[ i++ ].Value = userInfoQuery.Mobile;

			UserInfoData data = new UserInfoData();

			_dbo.Search( "SelectUserInfo", data.UserInfo, Params);

			return data;

			
		}

		public bool InsertUserInfo( UserInfoData userInfo )
		{

			SqlParameter[] Params = 
			{
				new SqlParameter( "@LoginName", SqlDbType.Char, 20 ),
				new SqlParameter( "@Password", SqlDbType.Char, 20 ),
				new SqlParameter( "@UserName", SqlDbType.Char, 20 ),	
				new SqlParameter( "@Gender", SqlDbType.Int ),
				new SqlParameter( "@Mobile", SqlDbType.Char, 12 ),
				new SqlParameter( "@Remark", SqlDbType.VarChar, 256 )
			};
			for(int i = 0; i < Params.Length; i ++)
			{
				Params[i].SourceColumn = Params[i].ParameterName.Remove(0, 1);
			}

			try
			{
				_dbo.Insert( userInfo.UserInfo, "InsertUserInfo", Params );
			}
			catch(Exception e)
			{
				throw new ApplicationException( "数据库访问错误。", e);
			}
			
			return true;
		}

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

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

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