原生YII2 增删改查的一些操作（非ActiveRecord）

1.添加数据

如下，使用insert方法：t_admin_user为数据表名。。其他的是属性。。

$num = Yii::$app->db->createCommand()->insert('t_admin_user', [

            'username' => $this->username,

            'origin_pwd' => trim($info['password']),

            'password' => $this->passwordHash($info['password']),

            'roleid' => $this->roleid,

            'role' => $this->role,

            'ctime' => $this->ctime,

            'salt' => $this->salt,

            'status' => $this->status,

        ])->execute();

2.修改数据

如下，使用update方法：t_admin_use为数据表名，'origin_pwd' =>$origin_pwd,'password'=>$password,'salt'=>$salt是要修改的属性，'uid = '.$uid是条件。

 $modNum = Yii::$app->db->createCommand()->update('t_admin_user', ['origin_pwd' =>$origin_pwd,'password'=>$password,'salt'=>$salt], 'uid = '.$uid)->execute();

3.批量添加

如下，Message为数据表名。

 if($userInfo){

            foreach($userInfo as $v){

                $rows[] = array(

                    'uid' => trim($v['uid']),

                    'content' => trim($info['content']),

                    'type' => trim($info['type']),

                    'create_time' => $time,

                    'update_time' => $time,

                    'status' => 0

                    );

            }

            return Yii::$app->db->createCommand()->batchInsert(Message::tableName(), ['uid', 'content','type','create_time','update_time','status'], $rows)->execute();

        }

4.批量修改

如下，Message为数据表，'create_time'=>trim($info['create_time'])是条件。。

$model = new Message();

$result = $model->updateAll(['content'=>trim($info['content']),'update_time'=>time()],['create_time'=>trim($info['create_time'])]);

5.插入数据成功后，新增的id

$post->save();

//得到上次插入的Insert id

$id = $post->attributes['id'];

如此很简单 

例子：

 public function doGetCreateSalesInfo($info){

        $this->name = trim($info['name']);

        $this->company_id = 58;

        $this->ctime = date('Y-m-d H:i:s',time());

        $this->password = md5(trim($info['password']));

        $this->phone = trim($info['phone']);

        $this->email = trim($info['email']);

        $this->admin_id = trim($info['admin_id']);

        if($this->save()){

            $id = $this->attributes['id'];

            $model = self::find()->where(['id'=>$id])->one();

            $model->code = 'BLM'.sprintf("%07d",$id);

            if($model->save()){

                return 1;

            }else{

                return -1;

            }

        }

    }

6.查找数据信息

    $goodsTypes = Yii::app()->getDb()->createCommand()

                ->select('type_id, type_name')

                ->from('goods_type')

                ->where('status=1')->queryAll();

7.连表查询

$goods = Yii::app()->getDb()->createCommand()->from('goods g')

        ->select('g.good_id, g.good_name, gt.type_name, g.price, g.buy_nums, g.commit_nums, g.create_time')

        ->join('goods_type gt', 'g.good_type=gt.type_id')

        ->where('g.`status`=1 and gt.`status`=1')

        ->order('g.create_time desc')

        ->queryAll();

8.删除

$row = Yii::app()->getDb()->createCommand()

        ->delete('goods', "good_id=:good_id", array(

            ':good_id' => $goods_id,

        ));