DaDept.auto.cs | searchcode

/EQT_V1/EQT.DAL/DaDept.auto.cs

http://sgsoft-las.googlecode.com/ · C# · 1034 lines · 815 code · 86 blank · 133 comment · 26 complexity · 746d211cab7877060fe5693518887d14 MD5 · raw file

#region DaDept

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

// ????DaDept.cs

// ??????Dept??????

//

// 

// ?????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 DaDept   //?????????,IDept 

    {   

	

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

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

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

		#region SQL const

		private const  string SQL_INSERT="INSERT INTO Dept (Dept_ID ,Parent_Dept_ID ,Dept_Name ,Dept_Tel ,Dept_Manager_Code ,Rem ) VALUES "

			+"(@Dept_Id,@Parent_Dept_ID,@Dept_Name,@Dept_Tel,@Dept_Manager_Code,@Rem)";

		private const string SQL_UPDATE="UPDATE Dept SET Parent_Dept_ID=@Parent_Dept_ID, Dept_Name=@Dept_Name, Dept_Tel=@Dept_Tel, Dept_Manager_Code=@Dept_Manager_Code, Rem=@Rem WHERE Dept_ID=@Dept_ID";

		private const string SQL_DELETE="DELETE FROM Dept WHERE Dept_ID=@Dept_ID";

		private const string SQL_SELECT="SELECT Dept_ID ,Parent_Dept_ID ,Dept_Name ,Dept_Tel ,Dept_Manager_Code ,Rem  from Dept  ";

		private const string SQL_SELECT_ONE="SELECT Dept_ID ,Parent_Dept_ID ,Dept_Name ,Dept_Tel ,Dept_Manager_Code ,Rem  from Dept  WHERE Dept_ID=@Dept_ID";                              

		#endregion

		

        private Database db;

		

		#region Constructor

	 

		/// <summary>

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

        /// </summary>

		public DaDept ()

		{ 

			db=DatabaseFactory.CreateDatabase();

		}

		/// <summary>

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

        /// </summary>

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

		public DaDept (string databaseName)

		{ 

            this.db = DatabaseFactory.CreateDatabase(databaseName);

		} 

		

		public DaDept (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);

			 

			//????:Dept_Id	

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

			//????:Parent_Dept_ID	

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

			//????:Dept_Name	

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

			//????:Dept_Tel	

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

			//????:Dept_Manager_Code	

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

			//????:Rem	

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

			return dbCommand;

		}		

		private DbCommand ConstructAddCommand(MoDept entity)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_INSERT);

			 

			//????:Dept_Id	

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

			//????:Parent_Dept_ID	

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

			//????:Dept_Name	

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

			//????:Dept_Tel	

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

			//????:Dept_Manager_Code	

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

			//????:Rem	

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

			 

			return dbCommand;

		}

	

	    /// <summary>

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

		/// </summary>

	    public int Add(MoDept entity,DbTransaction trans)

	    {	try

            {

				DbCommand dbCommand=ConstructAddCommand(entity);			

				return db.ExecuteNonQuery(dbCommand,trans);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);				

			}

			return 0;

			

	    }		

	    public int Add(MoDept entity) 

        {	

			try

            {

				DbCommand dbCommand=ConstructAddCommand(entity);			

				return db.ExecuteNonQuery(dbCommand);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);		

			}

			return 0;

	    }

		

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

		{

			int rc=0;		

            DbCommand dbCommand=ConstructAddCommand();

			int j=0;

			try

			{

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

			   {	

				//????:Dept_Id	

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

				//????:Parent_Dept_ID	

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

				//????:Dept_Name	

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

				//????:Dept_Tel	

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

				//????:Dept_Manager_Code	

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

				//????:Rem	

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

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

			   }

			}

			catch(DbException ex)

			{

				HandleDbException(ex,entity[j]);				

			}			 

            return rc;

		}		

		public int Add(List<MoDept> 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++)

			   {	

					//????:Dept_Id	

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

					//????:Parent_Dept_ID	

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

					//????:Dept_Name	

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

					//????:Dept_Tel	

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

					//????:Dept_Manager_Code	

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

					//????:Rem	

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

					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,"Parent_Dept_ID",DbType.AnsiString);

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

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

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

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

		 

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

			 

			return dbCommand;

		}

		private DbCommand ConstructUpdateCommand(MoDept entity)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);

		    

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

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

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

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

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

		 

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

			 

			return dbCommand;

		}

		/// <summary>

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

		/// </summary>	

	    public int Update(MoDept entity,DbTransaction trans)

	    {	    			

		    try

            {			

				DbCommand dbCommand=ConstructUpdateCommand(entity);

				return db.ExecuteNonQuery(dbCommand,trans);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);		

			}

			return 0;

		}		

		public int Update(MoDept entity)

		{

			try

            {			

				DbCommand dbCommand=ConstructUpdateCommand(entity);

				return db.ExecuteNonQuery(dbCommand);

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity);		

			}

			return 0;			

		}		

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

		{

			int rc=0;			 

            DbCommand dbCommand=ConstructUpdateCommand();

			int j=0;

			try

			{

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

				{	

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

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

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

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

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

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

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

				}

			}

			catch(DbException ex)

			{				

				HandleDbException(ex,entity[j]);		

			}			 

			return rc;			

		}		

		public int Update(List<MoDept> 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,"Dept_Id",dt.Rows[j]["Dept_Id"]);

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

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

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

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

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

					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, "Dept_Id",DbType.AnsiString, "Dept_Id", DataRowVersion.Current);

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

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

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

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

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

			#endregion

			dbUpdateCommand = db.GetSqlStringCommand(SQL_UPDATE);

			#region Set update cmd value parameters

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

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

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

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

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

			#endregion

			#region set update cmd pk where parameters

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

			#endregion			

			dbDeleteCommand = db.GetSqlStringCommand(SQL_DELETE);

			#region set delete cmd pk where parameters

			db.AddInParameter(dbDeleteCommand, "Dept_Id", DbType.AnsiString, "Dept_Id", 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,"Dept_Id",DbType.AnsiString);

			 

			return dbCommand;

		}		

		private DbCommand ConstructDeleteCommand(MoDept entity)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);

			 

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

		 

			return dbCommand;

		}

		

		/// <summary>

		/// delete by pk(entity)

		/// </summary>	

		public int Delete(MoDept 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(MoDept 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<MoDept> entities,DbTransaction trans)

		{

			int rc=0;	

			int j=0;

			DbCommand dbCommand=ConstructDeleteCommand();		

			try

			{

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

				{	

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

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

				}

			}

			catch(DbException ex)

			{	

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

				HandleDbException(ex,entities[j]);				

			}			 

			return rc;			

		}		

		public int Delete(List<MoDept> 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,"Dept_Id",dt.Rows[j]["Dept_Id"]);

					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 Dept_Id,DbTransaction trans)

		{			 

			try

			{

				DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);

				 

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

				 

				return db.ExecuteNonQuery(dbCommand,trans);

			}

			catch(DbException ex)

			{	

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

				HandleDbException(ex);				

			}	

			return 0;

		}	

		

		public int Delete(string Dept_Id)

		{

			try

			{

				DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);

				 

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

				 

				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 MoDept GetEntity(string mDept_Id )

		{			 

			MoDept entity = new MoDept();

			entity.Dept_Id=mDept_Id;

			if(GetEntityEx(entity))

			{

				return entity;

			}

			else

			{

				return null;

			}

		}

		

		public MoDept GetEntity(string mDept_Id ,DbTransaction trans)

		{			 

			MoDept entity = new MoDept();

			entity.Dept_Id=mDept_Id;

			if(GetEntityEx(entity,trans))

			{

				return entity;

			}

			else

			{

				return null;

			}

		}

		

		private DbCommand ConstructSelectOneCommand(Database db,MoDept entity)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_SELECT_ONE);

			 

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

			return dbCommand;

		}

		private DbCommand ConstructSelectOneCommand(Database db)

		{

			DbCommand dbCommand=db.GetSqlStringCommand(SQL_SELECT_ONE);

			 

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

			return dbCommand;

		}

		private void PopulateEntityByDataReader(IDataReader reader,ref MoDept entity)

		{

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

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

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

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

			if (!reader.IsDBNull(4)) entity.Dept_Manager_Code = reader.GetString(4);

			if (!reader.IsDBNull(5)) entity.Rem = reader.GetString(5);

		}

		

		/// <summary>

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

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

		/// </summary>

		public bool GetEntityEx(MoDept 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(MoDept 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<MoDept> GetEntities(string condition,DbTransaction trans)

		{

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

			try

			{				

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

			    {

				    while(reader.Read())

					{			

						MoDept entity=new MoDept();

						PopulateEntityByDataReader(reader,ref entity);	

						list.Add(entity);

					}

			    }

			}

			catch(DbException ex)

			{			 

				trans.Rollback();

				HandleDbException(ex);				

			}	

			return list;

			

		}

		

		

		public List<MoDept> GetEntities(string condition)

		{

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

			try

			{

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

				{   

					while(reader.Read())

					{	

						MoDept entity=new MoDept();

						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 Dept "));

		}

		

		public int GetCount(DbTransaction trans)

		{

			try

			{

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

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

		    }

		    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 Dept ":"SELECT COUNT(*) FROM Dept "+condition ));

		}

		

		public int GetCount(string condition,DbTransaction trans)

		{

			try

			{

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

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

		    }

			catch(DbException ex)

			{	 

				HandleDbException(ex);				

			}	

			return -1;

		}

		#endregion

		

		#region Check isExist

		/// <summary>

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

		/// </summary>

        public bool IsExist(string mDept_Id )

		{

			string sql="SELECT COUNT(*) FROM Dept  WHERE Dept_ID=@Dept_Id  ";

			

			DbCommand dbCommand=db.GetSqlStringCommand(sql);

			db.AddInParameter(dbCommand,"Dept_Id",DbType.AnsiString,mDept_Id);

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

		}

		

		public bool IsExist(string mDept_Id ,DbTransaction trans)

		{			 

			string sql="select count(*) from Dept  where Dept_ID=@Dept_Id  ";

			

			DbCommand dbCommand=db.GetSqlStringCommand(sql);

			db.AddInParameter(dbCommand,"Dept_Id",DbType.AnsiString,mDept_Id);

			try

			{

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

			}

			catch

			{

			    trans.Rollback();

				throw;

			}		 

		}

		

		public bool IsExist(MoDept entity,DbTransaction trans)

		{			

			string sql="select count(*) from Dept  where Dept_ID=@Dept_Id  ";

			

			DbCommand dbCommand=db.GetSqlStringCommand(sql);

			#region set pk where parameters

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

			#endregion

			try

			{

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

			}

			catch

			{

			    trans.Rollback();

				throw;

			}		 

		}

		

		public bool IsExist(MoDept entity)

		{

			string sql="select count(*) from Dept  where Dept_ID=@Dept_Id  ";

			

			DbCommand dbCommand=db.GetSqlStringCommand(sql);

			#region set pk where parameters

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

			#endregion

			 

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

			 	 

		}

		#endregion

		

		#region Handle Exception

		private void HandleDbException(DbException ex)

		{

			//TODO:handle db exception.

			//Please throw application custom exception.

			

			throw ex;

		}

		private void HandleDbException(DbException ex, MoDept entity)

		{			

			//NOTE:If you use SQL Server/Oracle/Db2... ,Please add the [internal static class ErrorCodes]

			//Use the ErrorCodes like below:

			//if (ex.Number == ErrorCodes.SqlUserRaisedError)

            //{

            //    switch (ex.State)

            //    {

            //    case ErrorCodes.ValidationError:

            //        string[] messageParts = ex.Errors[0].Message.Split(':');

            //        throw new RepositoryValidationException(

            //            mapper.MapDbParameterToBusinessEntityProperty(messageParts[0]),

            //            messageParts[1], ex);



            //    case ErrorCodes.ConcurrencyViolationError:

            //        throw new ConcurrencyViolationException(ex.Message, ex);



            //    }

            //}

			

            //TODO:Please contruct your customer Exception.

            //throw new RepositoryFailureException(ex);      

			throw ex;           

		}

		private void HandleDbException(DbException ex,DataRow entity)

		{

			//TODO:If you use SQL Server/Oracle/Db2... ,Please add the [internal static class ErrorCodes]

			//if (ex.Number == ErrorCodes.SqlUserRaisedError)

            //{

            //    switch (ex.State)

            //    {

            //    case ErrorCodes.ValidationError:

            //        string[] messageParts = ex.Errors[0].Message.Split(':');

            //        throw new RepositoryValidationException(

            //            mapper.MapDbParameterToBusinessEntityProperty(messageParts[0]),

            //            messageParts[1], ex);



            //    case ErrorCodes.ConcurrencyViolationError:

            //        throw new ConcurrencyViolationException(ex.Message, ex);



            //    }

            //}

			

            //TODO:Please contruct your customer Exception.

            //throw new RepositoryFailureException(ex);      

			throw ex;           

		}

		#endregion

	}

}	

#endregion
Tech Fingerprint

.NET Base Class Library
Alerts (6)

Complexity hotspot; lines 761 to 766 (total complexity: 6)
761 762 763 764 765 766