/// <summary>
///Data  Implemention Object 
///BASIC CRUD CLASS FOR TABLE t_Log
///By wm with codesmith. 
///on 04/18/2017
/// </summary>
 

using System;
using DeiNiu.Utils;
using System.Data.SqlClient;


namespace DeiNiu
{
	#region Log_base_Imp	
	[Serializable]  class  Log_base_Imp: BaseModel_Imp{
     protected override void Assem_Model(SqlDataReader reader, BaseModel obj) {
			
			if (reader != null && !reader.IsClosed) {
			   Log_base  tmpObj = (Log_base)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_account = reader.GetString(2);                    
                    if (!reader.IsDBNull(3)) tmpObj._log_sessionid = reader.GetString(3);                    
                    if (!reader.IsDBNull(4)) tmpObj._log_page = reader.GetString(4);                    
                    if (!reader.IsDBNull(5)) tmpObj._log_method = reader.GetString(5);                    
                    if (!reader.IsDBNull(6)) tmpObj._log_sql = reader.GetString(6);                    
                    if (!reader.IsDBNull(7)) tmpObj._log_parameters = reader.GetString(7);                    
                    if (!reader.IsDBNull(8)) tmpObj._log_exception = reader.GetString(8);                    
                    if (!reader.IsDBNull(9)) tmpObj._log_clientip = reader.GetString(9);                    
                    if (!reader.IsDBNull(10)) tmpObj._log_browseinfo = reader.GetString(10);                    
                    if (!reader.IsDBNull(11)) tmpObj._dr = reader.GetBoolean(11);                    
                    if (!reader.IsDBNull(12)) tmpObj._operater = reader.GetInt32(12);                    
                    if (!reader.IsDBNull(13)) tmpObj._create_time = reader.GetDateTime(13).ToString() ;                    
                    if (!reader.IsDBNull(14)) tmpObj._lastmodified = reader.GetDateTime(14).ToString() ;                    
                reader.Close(); 
				}
			}
			
			
        }

        protected  override void CmdPrepare(SqlCommand oraCmd)  { 
             Log_base  tmpObj = (Log_base)modelObj;
            switch (this._op_flag) { 
                case (int)op_flag.add:
					 _strSql = "INSERT INTO dbo. T_LOG(LOG_EMPID,LOG_ACCOUNT,LOG_SESSIONID,LOG_PAGE,LOG_METHOD,LOG_SQL,LOG_PARAMETERS,LOG_EXCEPTION,LOG_CLIENTIP,LOG_BROWSEINFO,DR,OPERATER,CREATE_TIME,LASTMODIFIED) VALUES(@LOG_EMPID,@LOG_ACCOUNT,@LOG_SESSIONID,@LOG_PAGE,@LOG_METHOD,@LOG_SQL,@LOG_PARAMETERS,@LOG_EXCEPTION,@LOG_CLIENTIP,@LOG_BROWSEINFO,@DR,@OPERATER,@CREATE_TIME,@LASTMODIFIED)";
                    break;
                case (int)op_flag.update:
                    _strSql = "UPDATE dbo.T_LOG SET LOG_EMPID = @LOG_EMPID, LOG_ACCOUNT = @LOG_ACCOUNT, 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 ID = @ID";
                    break;
                case (int)op_flag.delete:
				 _strSql = "UPDATE dbo.T_LOG  SET DR =0 WHERE ID = @ID"; 
					break;
                case (int)op_flag.getObj:
                    _strSql = "SELECT * FROM dbo.T_LOG  WHERE ID = @ID";
                    break;
				case (int)op_flag.queryAll:
                    _strSql = "SELECT * FROM dbo.T_LOG  WHERE DR =1 ";
                     if (this.rownumEnd >0 )
                    {
                        _strSql = "SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ID DESC) as sortNo FROM dbo.T_LOG )AS SORTEDTB WHERE DR =1 AND sortNo BETWEEN @START AND @END";
                    }
					break;
                case (int)op_flag.queryActived:
                    _strSql = "SELECT * FROM dbo.T_LOG   WHERE DR =1";
					break;
				 case (int)op_flag.getPk:
                    _strSql = "SELECT MAX(ID)  FROM dbo.T_LOG   WHERE DR =1";
					break;
                 case (int) op_flag.getCount:
                _strSql = "SELECT COUNT(*) FROM T_LOG  WHERE DR =1";
                break;
            }          
            oraCmd.CommandText = _strSql;
            fillParameters(oraCmd,tmpObj);
        }
         

        private void fillParameters(SqlCommand oraCmd,   Log_base  tmpObj) {
			switch (this._op_flag) {
				case (int)op_flag.getObj:
				case (int)op_flag.delete:
				case (int)op_flag.getPk:
                    oraCmd.Parameters.AddWithValue("@ID", tmpObj.ID);
					break;
				case (int)op_flag.queryAll:
                 if (this.rownumEnd > 0)
                    {
                        oraCmd.Parameters.AddWithValue("@START", this._rownumStart);
                        oraCmd.Parameters.AddWithValue("@END", this._rownumEnd);
                    }
                    break;
				case 0:
			    case (int)op_flag.queryActived:
               		 return;
				case (int)op_flag.update:
                    oraCmd.Parameters.AddWithValue("@ID", tmpObj.ID);
					break;

			}
	           if ((_op_flag !=(int)op_flag.update) &&( _op_flag !=(int)op_flag.add)) return;  
                 oraCmd.Parameters.AddWithValue("@ID",  VerifyDbnull(tmpObj._id))  ; 
                 oraCmd.Parameters.AddWithValue("@LOG_EMPID",  VerifyDbnull(tmpObj._log_empid))  ; 
                 oraCmd.Parameters.AddWithValue("@LOG_ACCOUNT",  VerifyDbnull(tmpObj._log_account))  ; 
                 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
}