/**
* 方法功能：修改
* 说明：传递过来的$data_array必须是关联数组，例如：array('key'=>'value'),
* 其中key是要修改的表的字段名称,value是要给字段重新赋的值；$where参数是条件
* @param unknown $data_array
* @param unknown $where
* @return boolean
*/
public static function update($data_array, $where)
{
self::initDB();
if (empty($data_array) || !is_array($data_array)) {
//判断是否是数组
self::$errCode = '004';
self::$errMsg = "SuperorderAuditModel update error1";
return false;
}
$setting = '';
foreach ($data_array as $key => $value) {
$setting .= ',`' . $key . '` = \'' . $value . '\'';
//把数组内容转换为字符串格式，例如：`dept_name`='it',`dept_principal`='admin'
}
$setting = ltrim($setting, ',');
//去除最左边的逗号
$sql = 'UPDATE `' . self::$table_name . '` SET ' . $setting . ' WHERE ' . $where;
//echo $sql."\n";
return self::$dbConn->query($sql);
}
