//object.cfc
<cfcomponent displayname="Object">
  <!--- struct to contain object/db mapping --->
  <!--- dbMap.objectAttribute.column = 'dbColumnName'; --->
  <!--- dbMap.objectAttribute.type = '[number|string|date]'; --->
  <!--- 建立一个对象和数据间的影射 --->
  <cfset dbMap = structNew()>
  <!--- 构造一个对象根据ID --->
  <!--- constructor() --->
  <cffunction name="init" returntype="void" output="false">
    <cfargument name="objId" type="numeric" required="yes"/>
    <cfset var _get = "">
    <cfset var _column = "">
    <cfset var _value = "">
    <cfquery name="_get" datasource="#request.dsn#">
    SELECT * FROM #this.tableName# WHERE #this.pk# = #arguments.objId#
    </cfquery>
    <cfloop collection="#dbMap#" item="attr">
      <cfset _column = dbMap[attr].column>
      <cfset _value = _get[_column]>
      <cfif dbMap[attr].type IS "date">
        <cfset _value = _get[_column]>
        <cfset "this.#attr#" = dateFormat(_value, 'mm/dd/yyyy')>
        <cfelse>
        <cfset "this.#attr#" = trim(_value)>
      </cfif>
    </cfloop>
  </cffunction>
  <!--- 根据传过来的ID DELETE记录 --->
  <!--- delete() --->
  <cffunction name="delete" returntype="void" output="false">
    <cfargument name="pk" required="true" type="numeric" />
	<cfloop collection="#dbMap#" item="attr">
      <cfset _column = evaluate("dbMap." & attr & ".column")>
      <cfset _type ="cf_sql_"&evaluate("dbMap." & attr & ".type")>
      <cfif _column IS this.pk>
    <cfquery name="delete" datasource="#request.dsn#">
    DELETE FROM #this.tableName# WHERE #this.pk# =<cfqueryparam value="#arguments.pk#" cfsqltype="#_type#">
    </cfquery>
	  </cfif>
	  </cfloop>
  </cffunction>
  <!--- 获取所有的记录 --->
  <!--- getAll() --->
  <cffunction name="getAll" returntype="query" output="false">
    <cfset var _getAll = "">
    <cfquery name="_getAll" datasource="#request.dsn#">
    SELECT * FROM #this.tableName#
    <cfif len(this.orderby)>
      ORDER BY #this.orderBy#
    </cfif>
    <cfif len(this.groupby)>
      group by #this.groupby#
    </cfif>
    </cfquery>
    <cfreturn _getAll />
  </cffunction>
  <cffunction name="getBy" returntype="query" output="false">
    <cfargument name="_getby" required="yes">
	<cfargument name="_value" required="yes">
    <cfloop collection="#dbMap#" item="attr">
      <cfset _column = evaluate("dbMap." & attr & ".column")>
      <cfset _type ="cf_sql_"&evaluate("dbMap." & attr & ".type")>
      <cfif _column IS _getBy>
        <cfquery name="_getAll" datasource="#request.dsn#">
        SELECT * FROM #this.tableName# where #_getby#=<cfqueryparam value="#_value#" cfsqltype="#_type#">
        <cfif len(this.orderby)>
          ORDER BY #this.orderBy#
        </cfif>
        <cfif len(this.groupby)>
          group by #this.groupby#
        </cfif>
        </cfquery>
      </cfif>
    </cfloop>
    <cfreturn _getAll />
  </cffunction>
  <!--- 获取最大的ID --->
  <!--- getSequenceCurrent() --->
  <cffunction name="getSequenceCurrent" returntype="numeric">
    <cfset var _Max = "">
    <cfquery name="_Max" datasource="#request.dsn#">
    SELECT LAST_INSERT_ID() AS id FROM #this.tableName#
    </cfquery>
    <cfreturn _Max.id />
  </cffunction>
  <!--- 插入记录 --->
  <!--- insertRecord() --->
  <cffunction name="insertRecord" returntype="void">
    <cfset var _column = "">
    <cfset var _columns = "">
    <cfset var _value = "">
    <cfset var _values = "">
    <cfset var _type = "">
    <cfloop collection="#dbMap#" item="attr">
      <cfset _column = evaluate("dbMap." & attr & ".column")>
      <cfset _value = evaluate("this." & attr)>
      <cfset _type = evaluate("dbMap." & attr & ".type")>
      <cfif _column NEQ this.pk>
        <cfswitch expression="#_type#">
          <cfcase value="date">
          <cfif isDate(_value)>
            <cfset _value = dateFormat(_value)>
            <cfset _value = "'" & _value & "'">
            <cfelse>
            <cfset _value = 'null'>
          </cfif>
          </cfcase>
          <cfdefaultcase>
          <cfset _value = replace(_value, "'", "''", "ALL")>
          <cfset _value = "'" & _value & "'">
          </cfdefaultcase>
        </cfswitch>
        <cfset _columns = listAppend(_columns, _column)>
        <cfset _values = listAppend(_values, _value)>
      </cfif>
    </cfloop>
    <cfquery name="insert" datasource="#request.dsn#">
    INSERT INTO #this.tableName# (#_columns#) valueS (#preserveSingleQuotes(_values)#)
    </cfquery>
  </cffunction>
  <!--- passport() --->
  <cffunction name="passport" returntype="string" output="false">
    <cfargument name="privilege" type="string" required="yes" />
    <cfreturn StructFind(session.passport, privilege) />
  </cffunction>
  <!--- save() --->
  <cffunction name="save" returntype="void">
    <cfif evaluate("this." & this.objId) EQ 0>
      <cftransaction>
        <cfset nothing = insertRecord()>
        <cfset "this.#this.objId#" = getSequenceCurrent()>
      </cftransaction>
      <cfelse>
      <cfset nothing = updateRecord()>
    </cfif>
  </cffunction>
  <!--- set() --->
  <!--- loops thru in struct and finds matching varnames in this. --->
  <cffunction name="set" returntype="void" output="false">
    <cfargument name="obj" type="struct" required="yes" />
    <cfloop collection="#arguments.obj#" item="attr">
      <cfif StructKeyExists(this, attr)>
        <cfset "this.#attr#" = arguments.obj[attr]>
      </cfif>
    </cfloop>
  </cffunction>
  <cffunction name="get" returntype="any" output="false">
    <cfargument name="attr" type="string" required="yes">
    <cfif structKeyExists(this,attr)>
      <cfreturn "#evaluate('this.'&attr)#">
    </cfif>
  </cffunction>
  <cffunction name="checkSame">
    <cfquery name="check" datasource="#request.dsn#">
    <cfoutput>
	select #this.pk# 
	from #this.tableName#
	where #arguments[2]#='#arguments[3]#'
    and   #this.pk#!=#arguments[1]#
	</cfoutput>
    </cfquery>
    <cfreturn check.recordcount>
  </cffunction>
  <!--- updateRecord() --->
  <!--- overwrites Object.updateRecord() --->
  <cffunction name="updateRecord" returntype="void">
    <cfset var _column = "">
    <cfset var _value = "">
    <cfset var _type = "">
    <cfset var _phrase = "">
    <cfset var _sql = "">
    <cfset var _pk = "">
    <cfloop collection="#dbMap#" item="attr">
      <cfset _column = evaluate("dbMap." & attr & ".column")>
      <cfset _value = evaluate("this." & attr)>
      <cfset _type = evaluate("dbMap." & attr & ".type")>
      <cfif _column IS this.pk>
        <cfset _pk = _value>
        <cfelse>
        <cfswitch expression="#_type#">
          <cfcase value="date">
          <cfif isDate(_value)>
            <cfset _value = dateFormat(_value)>
            <cfset _value = "'" & _value & "'">
            <cfelse>
            <cfset _value = 'null'>
          </cfif>
          </cfcase>
          <cfdefaultcase>
          <cfset _value = replace(_value, "'", "''", "ALL")>
          <cfset _value = "'" & _value & "'">
          </cfdefaultcase>
        </cfswitch>
      </cfif>
      <cfset _phrase = _column & " = " & _value>
      <cfset _sql = listAppend(_sql, _phrase)>
    </cfloop>
    <cfquery name="update" datasource="#request.dsn#">
    UPDATE #this.tableName# SET #preserveSingleQuotes(_sql)# WHERE #this.pk#
    = #_pk#
    </cfquery>
  </cffunction>
  <cffunction name="showMsg">
    <cfoutput>
      <script language="javascript">
   alert("#arguments[1]#");
   window.location="#arguments[2]#";
  </script>
    </cfoutput>
  </cffunction>
  <cffunction name="include">
    <cfargument name="template">
    <cfinclude template="#template#">
  </cffunction>
</cfcomponent>