/// <summary>
	///Data  Implemention Object
	///By wm with codesmith. 
	///on 2010?4?4?
	/// </summary>

using da4log;
using myLlog;
using Tracen.Data.BaseObject;
using Tracen.Utils;
using System.Data.SqlClient;

namespace ZhangPu.Gov.Data.myLog
{

	#region Log_Imp
	
	class Log_Imp : BaseModel_Imp
	{


  protected override void Assem_Model(SqlDataReader reader, BaseModel obj)
        {
			
			if (reader != null && !reader.IsClosed)
			{
				  Log  tmpObj = ( Log)obj;
				if (reader.Read())
				{
					if (!reader.IsDBNull(0)) tmpObj.ID = reader.GetInt32(0);
					if (!reader.IsDBNull(1)) tmpObj._log_empid = reader.GetInt32(1); 
					if (!reader.IsDBNull(2)) tmpObj._log_sessionid = reader.GetString(2); 
					if (!reader.IsDBNull(3)) tmpObj._log_page = reader.GetString(3); 
					if (!reader.IsDBNull(4)) tmpObj._log_method = reader.GetString(4); 
					if (!reader.IsDBNull(5)) tmpObj._log_sql = reader.GetString(5); 
					if (!reader.IsDBNull(6)) tmpObj._log_parameters = reader.GetString(6); 
					if (!reader.IsDBNull(7)) tmpObj._log_exception = reader.GetString(7); 
					if (!reader.IsDBNull(8)) tmpObj._log_clientip = reader.GetString(8); 
					if (!reader.IsDBNull(9)) tmpObj._log_browseinfo = reader.GetString(9); 
					if (!reader.IsDBNull(10)) tmpObj._dr = reader.GetBoolean(10); 
					if (!reader.IsDBNull(11)) tmpObj._operater = reader.GetInt32(11); 
					if (!reader.IsDBNull(12)) tmpObj._create_time = reader.GetDateTime(12).ToString(); 
					if (!reader.IsDBNull(13)) tmpObj._lastmodified = reader.GetDateTime(13).ToString(); 
					reader.Close(); 
				}
			}
			
			
        }

        protected  override void CmdPrepare(SqlCommand oraCmd)
        {
			
            Log  tmpObj = ( Log)ModelObj;
            switch (this._op_flag)
            { 
                case (int)op_flag.add:
					 _strSql = "INSERT INTO dbo.t_Log(log_empid,log_sessionid,log_page,log_method,log_sql,log_parameters,log_exception,log_clientip,log_browseinfo,operater,lastmodified ) VALUES(@log_empid, @log_sessionid, @log_page, @log_method, @log_sql, @log_parameters, @log_exception, @log_clientip, @log_browseinfo,  @operater,   @lastmodified )";
                    break;
                case (int)op_flag.update:
                    _strSql = "UPDATE dbo.t_Log SET log_empid = @log_empid,log_sessionid = @log_sessionid,log_page = @log_page,log_method = @log_method,log_sql = @log_sql,log_parameters = @log_parameters,log_exception = @log_exception,log_clientip = @log_clientip,log_browseinfo = @log_browseinfo,dr = @dr,operater = @operater,create_time = @create_time,lastmodified = @lastmodified WHERE pk_Logid = @pk_Logid";
                    break;
                case (int)op_flag.delete:
				 _strSql = "UPDATE dbo.t_Log SET DR =0 WHERE pk_Logid = @pk_Logid";
					break;
                case (int)op_flag.getObj:
                    _strSql = "SELECT * FROM dbo.t_Log WHERE pk_Logid = @pk_Logid";
                    break;
				case (int)op_flag.queryAll:
                    _strSql = "SELECT * FROM dbo.t_Log ";
					break;
                case (int)op_flag.queryActived:
                    _strSql = "SELECT * FROM dbo.t_Log  WHERE DR =1";
					break;
				 case (int)op_flag.getPk:
                    _strSql = "SELECT MAX(pk_Logid)  FROM dbo.t_Log  WHERE DR =1";
					break;
            }          
            oraCmd.CommandText = _strSql;
            fillParameters(oraCmd,tmpObj);
        }
         

        private void fillParameters(SqlCommand oraCmd,  Log tmpObj)
        {
			switch (this._op_flag)
			{
				case (int)op_flag.getObj:
				case (int)op_flag.delete:
				case (int)op_flag.getPk:
                    oraCmd.Parameters.AddWithValue("@pk_Logid ", tmpObj.ID);
					break;
				case (int)op_flag.queryAll:
				case 0:
			    case (int)op_flag.queryActived:
               		 return;
				case (int)op_flag.update:
                    oraCmd.Parameters.AddWithValue("@pk_Logid ", tmpObj.ID);
					break;

			}
	           if ((_op_flag !=(int)op_flag.update) &&( _op_flag !=(int)op_flag.add)) return;
				 oraCmd.Parameters.AddWithValue("@log_empid",  VerifyDbnull(tmpObj._log_empid))  ;		  
				 oraCmd.Parameters.AddWithValue("@log_sessionid",  VerifyDbnull(tmpObj._log_sessionid))  ;		  
				 oraCmd.Parameters.AddWithValue("@log_page",  VerifyDbnull(tmpObj._log_page))  ;		  
				 oraCmd.Parameters.AddWithValue("@log_method",  VerifyDbnull(tmpObj._log_method))  ;		  
				 oraCmd.Parameters.AddWithValue("@log_sql",  VerifyDbnull(tmpObj._log_sql))  ;		  
				 oraCmd.Parameters.AddWithValue("@log_parameters",  VerifyDbnull(tmpObj._log_parameters))  ;		  
				 oraCmd.Parameters.AddWithValue("@log_exception",  VerifyDbnull(tmpObj._log_exception))  ;		  
				 oraCmd.Parameters.AddWithValue("@log_clientip",  VerifyDbnull(tmpObj._log_clientip))  ;		  
				 oraCmd.Parameters.AddWithValue("@log_browseinfo",  VerifyDbnull(tmpObj._log_browseinfo))  ;		  
				 oraCmd.Parameters.AddWithValue("@dr",  VerifyDbnull(tmpObj._dr))  ;		  
				 oraCmd.Parameters.AddWithValue("@operater",  VerifyDbnull(tmpObj._operater))  ;		  
				 oraCmd.Parameters.AddWithValue("@create_time",  VerifyDbnull(tmpObj._create_time))  ;		  
				 oraCmd.Parameters.AddWithValue("@lastmodified",  VerifyDbnull(tmpObj._lastmodified))  ;		  
			 
			}
 
	 
	}
	#endregion
}