/**
* 插入数据
* @param string $datalist 数据集合
*/
public function Insert_Form_Data($datalist)
{
$db_form = new DbformModel();
$dbcell = new DbcellModel();
if ($datalist) {
$tables = $db_form->GetDBFormVid($datalist[0]['vid']);
//获取s_dbcell内容
$sdbcolumn_list = $dbcell->GetListForTid($tables['tid']);
$sql = "INSERT INTO " . $tables['form_table'] . "(column) VALUES (key)";
foreach ($datalist as $key => $value) {
$column .= ',' . $value['name'];
//判断是否是密码
$type = GetPWDByName($value['name'], $sdbcolumn_list);
if ($type['flx'] == 'password') {
$dtvalue .= ',\'' . md5($value['value']) . '\'';
} else {
$dtvalue .= ',\'' . $value['value'] . '\'';
}
}
$sql = str_replace('column', substr($column, 1), $sql);
$sql = str_replace('key', substr($dtvalue, 1), $sql);
return $this->execute($sql);
}
}
/**
* 通过$tid获取列名
*/
public function GetColumnFortid($tid)
{
$dbcell = new DbcellModel();
return $dbcell->GetListForTid($tid);
//通过vid获取视图信息
}
