boniu/lib/table/table_index_csi300.class.php

<?php

/**
 * 数据库表:管理员组
 *
 * @createtime	2018/03/01
 * @author		空竹
 * @copyright	芝麻开发(http://www.zhimawork.com)
 */

class Table_index_csi300 extends Table {

	protected $table_name       = 'index_csi300';//表名，不带前缀，前缀在config中定义
    protected $table_id         = 'index_csi300_id';//指定ID字段名称，必须
    protected $table_status     = '';//指定状态字段名称，如果有
    protected $table_order      = '';//指定排序字段名称，如果有
    //数据库结构
	protected function struct(){
		$attr = array();
		
		$attr['id']                = 'index_csi300_id';
		$attr['date']              = 'index_csi300_date';
		$attr['open_price']        = 'index_csi300_open_price';
		$attr['close_price']       = 'index_csi300_close_price';
        $attr['increase_price']    = 'index_csi300_increase_price';
        $attr['increase_value']    = 'index_csi300_increase_value';
        $attr['amount']            = 'index_csi300_amount';
        $attr['value']             = 'index_csi300_value';
		return $attr;
	}

    public function add($attr){
        $param = array (
            'index_csi300_date'    => array('number', $attr['date']),
            'index_csi300_open_price'    => array('number', $attr['open_price']),
            'index_csi300_close_price'    => array('number', $attr['close_price']),
            'index_csi300_hightest_price'    => array('number', $attr['hightest_price']),
            'index_csi300_lowest_price'    => array('number', $attr['lowest_price']),
            'index_csi300_increase_value'    => array('number', $attr['increase_value']),
            'index_csi300_increase_price'    => array('number', $attr['increase_price']),
            'index_csi300_amount'    => array('number', $attr['amount']),
            'index_csi300_value'    => array('number', $attr['value']),
        );
        return $this->pdo->sqlinsert($this->table_fullname, $param);
    }


    public function insert($attr){

        $param = array (
            'index_csi300_date'    => array('number', $attr['date']),
            'index_csi300_open_price'    => array('number', $attr['open_price']),
            'index_csi300_close_price'    => array('number', $attr['close_price']),
            'index_csi300_hightest_price'    => array('number', $attr['hightest_price']),
            'index_csi300_lowest_price'    => array('number', $attr['lowest_price']),
            'index_csi300_increase_value'    => array('number', $attr['increase_value']),
            'index_csi300_increase_price'    => array('number', $attr['increase_price']),
            'index_csi300_amount'    => array('number', $attr['amount']),
            'index_csi300_value'    => array('number', $attr['value']),
        );
        return $this->pdo->sqlinsert($this->table_fullname, $param);
    }


}
?>