DaTuser.auto.cs | searchcode

/EQT_V1/EQT.DAL/DaTuser.auto.cs

http://sgsoft-las.googlecode.com/ · C# · 994 lines · 812 code · 80 blank · 102 comment · 27 complexity · 401dc9fa3ba09300eadc69225176c1ac MD5 · raw file

#region DaTuser

/*----------------------------------------------------------------

// ????DaTuser.cs

// ??????Tuser??????

//

// 

// ?????2009-02-27

//

// ????? 

// ????? 

//----------------------------------------------------------------*/

using System;

using System.Collections;

using System.Collections.Generic;

using System.Data;

using System.Globalization;

using System.Text;

using System.Xml;

using System.Data.Common;

using Microsoft.Practices.EnterpriseLibrary.Data;

using Microsoft.Practices.EnterpriseLibrary.Data.Sql;

//using Microsoft.Practices.EnterpriseLibrary.Logging;

using EQT.Model; 

//using IDataLayer;



namespace EQT.Dal

{

    public	partial  class DaTuser   //?????????,ITuser 

    {   

	

		//???????????????????

		//???????????????SQL Server??????????????????ID??????entiry?

		//??????????????????

		#region SQL const

		private const  string SQL_INSERT="INSERT INTO TUser (UID ,Emp_ID ,Display_Name ,PWD ,Status ,Create_Time ,Update_Time ) VALUES "

			+"(@Uid,@Emp_Id,@Display_Name,@Pwd,@Status,@Create_Time,@Update_Time)";

		private const string SQL_UPDATE="UPDATE TUser SET Emp_ID=@Emp_ID, Display_Name=@Display_Name, PWD=@PWD, Status=@Status, Create_Time=@Create_Time, Update_Time=@Update_Time WHERE UID=@UID";

		private const string SQL_DELETE="DELETE FROM TUser WHERE UID=@UID";

		private const string SQL_SELECT="SELECT UID ,Emp_ID ,Display_Name ,PWD ,Status ,Create_Time ,Update_Time  from TUser  ";

		private const string SQL_SELECT_ONE="SELECT UID ,Emp_ID ,Display_Name ,PWD ,Status ,Create_Time ,Update_Time  from TUser  WHERE UID=@UID";                              

		#endregion

		

        private Database db;

		

		#region Constructor

	 

		/// <summary>

        /// ???????????????????????

        /// </summary>

		public DaTuser ()

		{ 

			db=DatabaseFactory.CreateDatabase();

		}

		/// <summary>

        /// ?????databaseName??????

        /// </summary>

        /// <param name="databaseName">??????????????</param>

		public DaTuser (string databaseName)

		{ 

            this.db = DatabaseFactory.CreateDatabase(databaseName);

		} 

		

		public DaTuser (Database db)

		{ 

            this.db = db;

		} 

		

		#endregion

		

		//???CRUD??????????????????



	    #region Add

		

		///build the command object.It never throw exception.

		private DbCommand ConstructAddCommand()

		{

			DbCommand dbCommand = db.GetSqlStringCommand(SQL_INSERT);

			 

			//????:Uid	

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString);

			//????:Emp_Id	

			db.AddInParameter(dbCommand,"Emp_Id",DbType.AnsiString);

			//????:Display_Name	

			db.AddInParameter(dbCommand,"Display_Name",DbType.String);

			//????:Pwd	

			db.AddInParameter(dbCommand,"Pwd",DbType.AnsiString);

			//????:Status	

			db.AddInParameter(dbCommand,"Status",DbType.Int32);

			//????:Create_Time	

			db.AddInParameter(dbCommand,"Create_Time",DbType.DateTime);

			//????:Update_Time	

			db.AddInParameter(dbCommand,"Update_Time",DbType.DateTime);

			return dbCommand;

		}		

		private DbCommand ConstructAddCommand(MoTuser entity)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_INSERT);

			 

			//????:Uid	

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,entity.Uid);

			//????:Emp_Id	

			db.AddInParameter(dbCommand,"Emp_Id",DbType.AnsiString,entity.Emp_Id);

			//????:Display_Name	

			db.AddInParameter(dbCommand,"Display_Name",DbType.String,entity.Display_Name);

			//????:Pwd	

			db.AddInParameter(dbCommand,"Pwd",DbType.AnsiString,entity.Pwd);

			//????:Status	

			db.AddInParameter(dbCommand,"Status",DbType.Int32,entity.Status);

			//????:Create_Time	

			db.AddInParameter(dbCommand,"Create_Time",DbType.DateTime,entity.Create_Time);

			//????:Update_Time	

			db.AddInParameter(dbCommand,"Update_Time",DbType.DateTime,entity.Update_Time);

			 

			return dbCommand;

		}

	

	    /// <summary>

		///????????????????commit

		/// </summary>

	    public int Add(MoTuser entity,DbTransaction trans)

	    {	try

            {

				DbCommand dbCommand=ConstructAddCommand(entity);			

				return db.ExecuteNonQuery(dbCommand,trans);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);				

			}

			return 0;

			

	    }		

	    public int Add(MoTuser entity) 

        {	

			try

            {

				DbCommand dbCommand=ConstructAddCommand(entity);			

				return db.ExecuteNonQuery(dbCommand);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);		

			}

			return 0;

	    }

		

		public int Add(List<MoTuser> entity,DbTransaction trans)

		{

			int rc=0;		

            DbCommand dbCommand=ConstructAddCommand();

			int j=0;

			try

			{

			   for(j=0;j<entity.Count;j++)

			   {	

				//????:Uid	

				db.SetParameterValue(dbCommand,"Uid",entity[j].Uid);

				//????:Emp_Id	

				db.SetParameterValue(dbCommand,"Emp_Id",entity[j].Emp_Id);

				//????:Display_Name	

				db.SetParameterValue(dbCommand,"Display_Name",entity[j].Display_Name);

				//????:Pwd	

				db.SetParameterValue(dbCommand,"Pwd",entity[j].Pwd);

				//????:Status	

				db.SetParameterValue(dbCommand,"Status",entity[j].Status);

				//????:Create_Time	

				db.SetParameterValue(dbCommand,"Create_Time",entity[j].Create_Time);

				//????:Update_Time	

				db.SetParameterValue(dbCommand,"Update_Time",entity[j].Update_Time);

				rc+=db.ExecuteNonQuery(dbCommand,trans);

			   }

			}

			catch(DbException ex)

			{

				HandleDbException(ex,entity[j]);				

			}			 

            return rc;

		}		

		public int Add(List<MoTuser> entity)

		{

			int rc = 0;			

			using (DbConnection cnn = db.CreateConnection())

            {    

				DbTransaction trans=null;

				try

				{

					cnn.Open();

					using(trans = cnn.BeginTransaction())

					{

						rc=Add(entity,trans);//This function throw customer exception.

						trans.Commit();

					}

					cnn.Close();

				}

				catch(DbException ex)

				{

					if(trans!=null)trans.Rollback();		

					HandleDbException(ex);	

				}

				///TODO:catch customer exception.

				//catch

				//{

				//	

				//}

			}

			return rc;

		}

		

        public int Add(DataTable dt, DbTransaction trans)

		{

			int rc=0;		 

            DbCommand dbCommand =ConstructAddCommand();	

			int j=0;

			try

			{

			   for(j=0;j<dt.Rows.Count;j++)

			   {	

					//????:Uid	

					db.SetParameterValue(dbCommand,"Uid",dt.Rows[j]["Uid"]);

					//????:Emp_Id	

					db.SetParameterValue(dbCommand,"Emp_Id",dt.Rows[j]["Emp_Id"]);

					//????:Display_Name	

					db.SetParameterValue(dbCommand,"Display_Name",dt.Rows[j]["Display_Name"]);

					//????:Pwd	

					db.SetParameterValue(dbCommand,"Pwd",dt.Rows[j]["Pwd"]);

					//????:Status	

					db.SetParameterValue(dbCommand,"Status",dt.Rows[j]["Status"]);

					//????:Create_Time	

					db.SetParameterValue(dbCommand,"Create_Time",dt.Rows[j]["Create_Time"]);

					//????:Update_Time	

					db.SetParameterValue(dbCommand,"Update_Time",dt.Rows[j]["Update_Time"]);

					rc+=db.ExecuteNonQuery(dbCommand,trans);

			   }

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,dt.Rows[j]);				

			}	

			 

            return rc;

		}		

		public int Add(DataTable dt)

        {

			int rc=0;

            using (DbConnection cnn = db.CreateConnection())

            { 

				DbTransaction trans=null;

				try

                {

					cnn.Open();

					using(trans = cnn.BeginTransaction())

					{

						rc = Add(dt, trans);

						trans.Commit();

						cnn.Close();

					}

				}

				catch(DbException ex)

				{	

					if(trans!=null)trans.Rollback();

					HandleDbException(ex);	

				}	

				///TODO:catch customer exception.

				//catch

				//{

				//	

				//}

            }

            return rc;

        }

		#endregion

		

		#region Update

		private DbCommand ConstructUpdateCommand()

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);

		    

			db.AddInParameter(dbCommand,"Emp_Id",DbType.AnsiString);

			db.AddInParameter(dbCommand,"Display_Name",DbType.String);

			db.AddInParameter(dbCommand,"Pwd",DbType.AnsiString);

			db.AddInParameter(dbCommand,"Status",DbType.Int32);

			db.AddInParameter(dbCommand,"Create_Time",DbType.DateTime);

			db.AddInParameter(dbCommand,"Update_Time",DbType.DateTime);

		 

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString);

			 

			return dbCommand;

		}

		private DbCommand ConstructUpdateCommand(MoTuser entity)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);

		    

			db.AddInParameter(dbCommand,"Emp_Id",DbType.AnsiString,entity.Emp_Id);

			db.AddInParameter(dbCommand,"Display_Name",DbType.String,entity.Display_Name);

			db.AddInParameter(dbCommand,"Pwd",DbType.AnsiString,entity.Pwd);

			db.AddInParameter(dbCommand,"Status",DbType.Int32,entity.Status);

			db.AddInParameter(dbCommand,"Create_Time",DbType.DateTime,entity.Create_Time);

			db.AddInParameter(dbCommand,"Update_Time",DbType.DateTime,entity.Update_Time);

		 

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,entity.Uid);

			 

			return dbCommand;

		}

		/// <summary>

		/// ???????????:??????????

		/// </summary>	

	    public int Update(MoTuser entity,DbTransaction trans)

	    {	    			

		    try

            {			

				DbCommand dbCommand=ConstructUpdateCommand(entity);

				return db.ExecuteNonQuery(dbCommand,trans);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);		

			}

			return 0;

		}		

		public int Update(MoTuser entity)

		{

			try

            {			

				DbCommand dbCommand=ConstructUpdateCommand(entity);

				return db.ExecuteNonQuery(dbCommand);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);		

			}

			return 0;			

		}		

		public int Update(List<MoTuser> entity,DbTransaction trans)

		{

			int rc=0;			 

            DbCommand dbCommand=ConstructUpdateCommand();

			int j=0;

			try

			{

			    for(j=0;j<entity.Count;j++)

				{	

					db.SetParameterValue(dbCommand,"Uid",entity[j].Uid);

					db.SetParameterValue(dbCommand,"Emp_Id",entity[j].Emp_Id);

					db.SetParameterValue(dbCommand,"Display_Name",entity[j].Display_Name);

					db.SetParameterValue(dbCommand,"Pwd",entity[j].Pwd);

					db.SetParameterValue(dbCommand,"Status",entity[j].Status);

					db.SetParameterValue(dbCommand,"Create_Time",entity[j].Create_Time);

					db.SetParameterValue(dbCommand,"Update_Time",entity[j].Update_Time);

					rc+=db.ExecuteNonQuery(dbCommand,trans);

				}

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity[j]);		

			}			 

			return rc;			

		}		

		public int Update(List<MoTuser> entity)

		{

			int rc = 0;	

			using (DbConnection cnn = db.CreateConnection())

            {   

				DbTransaction trans=null;

				try

				{          

					cnn.Open();

					using(trans = cnn.BeginTransaction())

					{

					rc=Update(entity,trans);

					trans.Commit();		

					}

					cnn.Close();

				}

				catch(DbException ex)

				{

					if(trans!=null)trans.Rollback();	

					HandleDbException(ex);	

				}				

			}

			return rc;

		}		

		public int Update(DataTable dt, DbTransaction trans)

		{

			int rc=0;			 

            DbCommand dbCommand=ConstructUpdateCommand();		

			int j=0;

		    try

		    {

			    for(j=0;j<dt.Rows.Count;j++)

				{	

					db.SetParameterValue(dbCommand,"Uid",dt.Rows[j]["Uid"]);

					db.SetParameterValue(dbCommand,"Emp_Id",dt.Rows[j]["Emp_Id"]);

					db.SetParameterValue(dbCommand,"Display_Name",dt.Rows[j]["Display_Name"]);

					db.SetParameterValue(dbCommand,"Pwd",dt.Rows[j]["Pwd"]);

					db.SetParameterValue(dbCommand,"Status",dt.Rows[j]["Status"]);

					db.SetParameterValue(dbCommand,"Create_Time",dt.Rows[j]["Create_Time"]);

					db.SetParameterValue(dbCommand,"Update_Time",dt.Rows[j]["Update_Time"]);

					rc+=db.ExecuteNonQuery(dbCommand,trans);

				}

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,dt.Rows[j]);		

			}		

            return rc;

			

		}		

		public int Update(DataTable dt)

        {

			if(dt==null ||dt.Rows.Count==0) return 0;

            int rc=0;       

            using (DbConnection cnn = db.CreateConnection())

            {

				DbTransaction trans=null;

				try

                {

					cnn.Open();

					using(trans = cnn.BeginTransaction())

					{

						rc = Add(dt, trans);

						trans.Commit();						

					}   

					cnn.Close();                  

                }

                catch(DbException ex)

				{

					if(trans!=null)trans.Rollback();	

					HandleDbException(ex);	

				}		

                

            }

            return rc;

        }

		#endregion

		

		#region Update By DataSet

		private void PrepareDataAdapterCommand(out DbCommand dbInsertCommand,

		                     out DbCommand dbUpdateCommand,out DbCommand dbDeleteCommand)

		{

			dbInsertCommand = db.GetSqlStringCommand(SQL_INSERT);

			#region set insert cmd parameters

			db.AddInParameter(dbInsertCommand, "Uid",DbType.AnsiString, "Uid", DataRowVersion.Current);

			db.AddInParameter(dbInsertCommand, "Emp_Id",DbType.AnsiString, "Emp_Id", DataRowVersion.Current);

			db.AddInParameter(dbInsertCommand, "Display_Name",DbType.String, "Display_Name", DataRowVersion.Current);

			db.AddInParameter(dbInsertCommand, "Pwd",DbType.AnsiString, "Pwd", DataRowVersion.Current);

			db.AddInParameter(dbInsertCommand, "Status",DbType.Int32, "Status", DataRowVersion.Current);

			db.AddInParameter(dbInsertCommand, "Create_Time",DbType.DateTime, "Create_Time", DataRowVersion.Current);

			db.AddInParameter(dbInsertCommand, "Update_Time",DbType.DateTime, "Update_Time", DataRowVersion.Current);

			#endregion

			dbUpdateCommand = db.GetSqlStringCommand(SQL_UPDATE);

			#region Set update cmd value parameters

			db.AddInParameter(dbUpdateCommand, "Emp_Id", DbType.AnsiString, "Emp_Id", DataRowVersion.Current);

			db.AddInParameter(dbUpdateCommand, "Display_Name", DbType.String, "Display_Name", DataRowVersion.Current);

			db.AddInParameter(dbUpdateCommand, "Pwd", DbType.AnsiString, "Pwd", DataRowVersion.Current);

			db.AddInParameter(dbUpdateCommand, "Status", DbType.Int32, "Status", DataRowVersion.Current);

			db.AddInParameter(dbUpdateCommand, "Create_Time", DbType.DateTime, "Create_Time", DataRowVersion.Current);

			db.AddInParameter(dbUpdateCommand, "Update_Time", DbType.DateTime, "Update_Time", DataRowVersion.Current);

			#endregion

			#region set update cmd pk where parameters

			db.AddInParameter(dbUpdateCommand, "Uid", DbType.AnsiString, "Uid", DataRowVersion.Current);

			#endregion			

			dbDeleteCommand = db.GetSqlStringCommand(SQL_DELETE);

			#region set delete cmd pk where parameters

			db.AddInParameter(dbDeleteCommand, "Uid", DbType.AnsiString, "Uid", DataRowVersion.Current);

			#endregion

		}

		

		

		

		/// <summary>

		/// ??DataSet??????????

		/// </summary>

		public int UpdateByDataSet(DataSet dst, string strTableName, DbTransaction trans)

		{

			DbCommand dbInsertCommand = null;			

			DbCommand dbUpdateCommand = null;

			DbCommand dbDeleteCommand = null;

			PrepareDataAdapterCommand(out dbInsertCommand,out dbUpdateCommand,out dbDeleteCommand);

			try

            {

			    return db.UpdateDataSet(dst, strTableName, dbInsertCommand, dbUpdateCommand, dbDeleteCommand, trans);

			}

			catch(DbException ex)

			{			

				trans.Rollback();

				HandleDbException(ex);				

			}

			return 0;//TODO:Should return Application Specific Error Code.

		}

		

		/// <summary>

		/// ??DataSet???????????

		/// </summary>

		public int UpdateByDataSet(DataSet dst, string strTableName)

		{

			DbCommand dbInsertCommand = null;			

			DbCommand dbUpdateCommand = null;

			DbCommand dbDeleteCommand = null;

			PrepareDataAdapterCommand(out dbInsertCommand,out dbUpdateCommand,out dbDeleteCommand);

			try

            {

			    return db.UpdateDataSet(dst, strTableName, dbInsertCommand, dbUpdateCommand, dbDeleteCommand, UpdateBehavior.Transactional);			

			}

			catch(DbException ex)

			{	

				HandleDbException(ex);				

			}

			return 0;//TODO:Should return Application Specific Error Code.			

		}

		

		

		

		#endregion 

		

		#region Delete

		

		private DbCommand ConstructDeleteCommand()

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);

			 

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString);

			 

			return dbCommand;

		}		

		private DbCommand ConstructDeleteCommand(MoTuser entity)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);

			 

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,entity.Uid);

		 

			return dbCommand;

		}

		

		/// <summary>

		/// delete by pk(entity)

		/// </summary>	

		public int Delete(MoTuser entity,DbTransaction trans)

		{	try

            {

				DbCommand dbCommand=ConstructDeleteCommand(entity);			

				return db.ExecuteNonQuery(dbCommand,trans);

			}

			catch(DbException ex)

			{			

				trans.Rollback();

				HandleDbException(ex,entity);				

			}

			return 0;

		}	

		public int Delete(MoTuser entity)

		{

			try

            {

				DbCommand dbCommand=ConstructDeleteCommand(entity);			

				return db.ExecuteNonQuery(dbCommand);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);				

			}

			return 0;

		}		

		/// <summary>

		/// mul-delete

		/// </summary>	

		public int Delete(List<MoTuser> entities,DbTransaction trans)

		{

			int rc=0;	

			int j=0;

			DbCommand dbCommand=ConstructDeleteCommand();		

			try

			{

			    for(j=0;j<entities.Count;j++)

				{	

					db.SetParameterValue(dbCommand,"Uid",entities[j].Uid);

					rc+=db.ExecuteNonQuery(dbCommand,trans);

				}

			}

			catch(DbException ex)

			{	

				if(trans!=null)trans.Rollback();

				HandleDbException(ex,entities[j]);				

			}			 

			return rc;			

		}		

		public int Delete(List<MoTuser> entities)

		{

			int rc = 0;			

			using (DbConnection cnn = db.CreateConnection())

            {      

				DbTransaction trans=null;

				try

				{

					cnn.Open();

					using(trans = cnn.BeginTransaction())

					{

						rc=Delete(entities,trans);

						trans.Commit();

					}               

					cnn.Close();

				}

				catch(DbException ex)

				{	

					if(trans!=null)trans.Rollback();

					HandleDbException(ex);				

				}	

			}

			return rc;

		}

		

		

		public int Delete(DataTable dt,DbTransaction trans)

		{

			int rc=0;			

			int j=0;

			DbCommand dbCommand=ConstructDeleteCommand();		

			try

			{

			    for(j=0;j<dt.Rows.Count;j++)

				{	

					db.SetParameterValue(dbCommand,"Uid",dt.Rows[j]["Uid"]);

					rc+=db.ExecuteNonQuery(dbCommand,trans);

				}

			}

			catch(DbException ex)

			{	

				if(trans!=null)trans.Rollback();

				HandleDbException(ex,dt.Rows[j]);				

			}			 

			return rc;			

		 	

		}		

		public int Delete(DataTable dt)

		{

			int rc=0;

		    using (DbConnection cnn = db.CreateConnection())

            {

				DbTransaction trans=null;

				try

				{

					cnn.Open();				

					using(trans = cnn.BeginTransaction())

					{

						rc = Delete(dt, trans);

						trans.Commit();

					}

					cnn.Close();

                }

                catch(DbException ex)

				{	

					if(trans!=null)trans.Rollback();

					HandleDbException(ex);				

				}

                

            }

            return rc;

		}		

		/// <summary>

		/// ??????????

		/// </summary>	

		public int Delete(string Uid,DbTransaction trans)

		{			 

			try

			{

				DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);

				 

				db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,Uid);

				 

				return db.ExecuteNonQuery(dbCommand,trans);

			}

			catch(DbException ex)

			{	

				if(trans!=null)trans.Rollback();

				HandleDbException(ex);				

			}	

			return 0;

		}	

		

		public int Delete(string Uid)

		{

			try

			{

				DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);

				 

				db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,Uid);

				 

				return db.ExecuteNonQuery(dbCommand);

			}

			catch(DbException ex)

			{			 

				HandleDbException(ex);				

			}	

			return -1;

		}

		#endregion

		

		#region Query All by condition

		/// <summary>

		/// ????WHERE????????,?condition????????

		/// </summary>		

		public DataSet Query(string condition)

		{			

			try

			{

				return db.ExecuteDataSet(CommandType.Text,String.IsNullOrEmpty(condition)?SQL_SELECT:SQL_SELECT+condition);	 

			}

			catch(DbException ex)

			{			 

				HandleDbException(ex);				

			}	

            return new DataSet();

		}		

	    public DataSet Query(string condition, DbTransaction trans)

        {   

            try

            {

                return db.ExecuteDataSet(trans, CommandType.Text, String.IsNullOrEmpty(condition) ? SQL_SELECT : SQL_SELECT + condition);

            }

            catch(DbException ex)

			{			 

				HandleDbException(ex);				

			}	

            return new DataSet();

        }

		#endregion

		

		#region GetEntity(s)

		/// <summary>

		///????????????

		/// </summary>

	    public MoTuser GetEntity(string mUid )

		{			 

			MoTuser entity = new MoTuser();

			entity.Uid=mUid;

			if(GetEntityEx(entity))

			{

				return entity;

			}

			else

			{

				return null;

			}

		}

		

		public MoTuser GetEntity(string mUid ,DbTransaction trans)

		{			 

			MoTuser entity = new MoTuser();

			entity.Uid=mUid;

			if(GetEntityEx(entity,trans))

			{

				return entity;

			}

			else

			{

				return null;

			}

		}

		

		private DbCommand ConstructSelectOneCommand(Database db,MoTuser entity)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_SELECT_ONE);

			 

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,entity.Uid);

			return dbCommand;

		}

		private DbCommand ConstructSelectOneCommand(Database db)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_SELECT_ONE);

			 

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString);

			return dbCommand;

		}

		private void PopulateEntityByDataReader(IDataReader reader,ref MoTuser entity)

		{

			if (!reader.IsDBNull(0)) entity.Uid = reader.GetString(0);

			if (!reader.IsDBNull(1)) entity.Emp_Id = reader.GetString(1);

			if (!reader.IsDBNull(2)) entity.Display_Name = reader.GetString(2);

			if (!reader.IsDBNull(3)) entity.Pwd = reader.GetString(3);

			if (!reader.IsDBNull(4)) entity.Status = reader.GetInt32(4);

			if (!reader.IsDBNull(5)) entity.Create_Time = reader.GetDateTime(5);

			if (!reader.IsDBNull(6)) entity.Update_Time = reader.GetDateTime(6);

		}

		

		/// <summary>

		///????????????????????????????????.

		///??????????????????????ref????

		/// </summary>

		public bool GetEntityEx(MoTuser entity)

		{

			DbCommand dbCommand=ConstructSelectOneCommand(db,entity);

			try

			{

				using(IDataReader reader=db.ExecuteReader(dbCommand))

				{   

					if(reader.Read()) 

					{

						PopulateEntityByDataReader(reader,ref entity);

						return true;

					}

				}

			}

			catch(DbException ex)

			{	 

				HandleDbException(ex,entity);				

			}	

			return false;

		}

		public bool GetEntityEx(MoTuser entity,DbTransaction trans)

		{		

			DbCommand dbCommand=ConstructSelectOneCommand(db,entity);

			try

			{

				using(IDataReader reader=db.ExecuteReader(dbCommand,trans))

				{   

					if(reader.Read())

					{

						PopulateEntityByDataReader(reader,ref entity);	

						return true;

					}

				}

			} 

			catch(DbException ex)

			{			 

				trans.Rollback();

				HandleDbException(ex,entity);				

			}	

			return false;

			

		}

		

		public List<MoTuser> GetEntities(string condition,DbTransaction trans)

		{

			List<MoTuser> list=new List<MoTuser>();			

			try

			{				

			    using(IDataReader reader= db.ExecuteReader(trans,CommandType.Text, String.IsNullOrEmpty(condition) ? SQL_SELECT : SQL_SELECT+ condition))

			    {

				    while(reader.Read())

					{			

						MoTuser entity=new MoTuser();

						PopulateEntityByDataReader(reader,ref entity);	

						list.Add(entity);

					}

			    }

			}

			catch(DbException ex)

			{			 

				trans.Rollback();

				HandleDbException(ex);				

			}	

			return list;

			

		}

		

		

		public List<MoTuser> GetEntities(string condition)

		{

			List<MoTuser> list=new List<MoTuser>();	

			try

			{

				using(IDataReader reader= db.ExecuteReader(CommandType.Text, String.IsNullOrEmpty(condition) ? SQL_SELECT : SQL_SELECT+" " + condition))

				{   

					while(reader.Read())

					{	

						MoTuser entity=new MoTuser();

						PopulateEntityByDataReader(reader,ref entity);	

						list.Add(entity);

					}

				}

			}

			catch(DbException ex)

			{	 

				HandleDbException(ex);				

			}	

			return list;

		}

		#endregion

		

		#region Count

		/// <summary>

		/// ????????

		/// </summary>

		public int GetCount()

		{

			return Convert.ToInt32(db.ExecuteScalar(CommandType.Text,

			"SELECT COUNT(*) FROM TUser "));

		}

		

		public int GetCount(DbTransaction trans)

		{

			try

			{

			    return Convert.ToInt32(db.ExecuteScalar(trans,CommandType.Text,

			    "SELECT COUNT(*) FROM TUser "));

		    }

		    catch(DbException ex)

			{	 

				HandleDbException(ex);				

			}	

			return -1;

		}

		

		/// <summary>

		/// ????WHERE?????

		/// </summary>

		public int GetCount(string condition)

		{

			return Convert.ToInt32(db.ExecuteScalar(CommandType.Text,String.IsNullOrEmpty(condition)?

			"SELECT COUNT(*) FROM TUser ":"SELECT COUNT(*) FROM TUser "+condition ));

		}

		

		public int GetCount(string condition,DbTransaction trans)

		{

			try

			{

			   return Convert.ToInt32(db.ExecuteScalar(trans,CommandType.Text,String.IsNullOrEmpty(condition)?

			   "SELECT COUNT(*) FROM TUser ":"SELECT COUNT(*) FROM TUser "+condition ));

		    }

			catch(DbException ex)

			{	 

				HandleDbException(ex);				

			}	

			return -1;

		}

		#endregion

		

		#region Check isExist

		/// <summary>

		/// ????????????

		/// </summary>

        public bool IsExist(string mUid )

		{

			string sql="SELECT COUNT(*) FROM TUser  WHERE UID=@Uid  ";

			

			DbCommand dbCommand=db.GetSqlStringCommand(sql);

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,mUid);

			return Convert.ToInt32(db.ExecuteScalar(dbCommand))>0;

		}

		

		public bool IsExist(string mUid ,DbTransaction trans)

		{			 

			string sql="select count(*) from TUser  where UID=@Uid  ";

			

			DbCommand dbCommand=db.GetSqlStringCommand(sql);

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,mUid);

			try

			{

			   return Convert.ToInt32(db.ExecuteScalar(dbCommand,trans))>0;

			}

			catch

			{

			    trans.Rollback();

				throw;

			}		 

		}

		

		public bool IsExist(MoTuser entity,DbTransaction trans)

		{			

			string sql="select count(*) from TUser  where UID=@Uid  ";

			

			DbCommand dbCommand=db.GetSqlStringCommand(sql);

			#region set pk where parameters

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,entity.Uid);

			#endregion

			try

			{

			   return Convert.ToInt32(db.ExecuteScalar(dbCommand,trans))>0;

			}

			catch

			{

			    trans.Rollback();

				throw;

			}		 

		}

		

		public bool IsExist(MoTuser entity)

		{

			string sql="select count(*) from TUser  where UID=@Uid  ";

			

			DbCommand dbCommand=db.GetSqlStringCommand(sql);

			#region set pk where parameters

			db.AddInParameter(dbCommand,"Uid",DbType.AnsiString,entity.Uid);

			#endregion

			 

			return Convert.ToInt32(db.ExecuteScalar(dbCommand))>0;

			 	 

		}

		#endregion

		



	}

}	

#endregion
Tech Fingerprint

.NET Base Class Library
Alerts (7)

Complexity hotspot; lines 775 to 781 (total complexity: 7)
775 776 777 778 779 780 781