通达OA信创版本二次开发程序增删改查示例代码

最新推荐文章于 2024-07-15 10:13:27 发布

hai7425

最新推荐文章于 2024-07-15 10:13:27 发布

阅读量504

点赞数 1

分类专栏：通达OA

本文链接：https://blog.csdn.net/hai7425/article/details/114436741

版权

通达OA 专栏收录该内容

108 篇文章 15 订阅

订阅专栏

<?
//include_once("inc/auth.inc.php");
include_once("inc/conn.php");
include_once("inc/utility_all.php");
include_once("inc/utility_file.php");
include_once("inc/utility_sms1.php");
include_once("inc/utility_cache.php");
$HTML_PAGE_TITLE = _("猜一猜");
include_once("inc/header.inc.php");
//联系qq   874689017

echo "查询测试:"."<br>";
//查询演示
 $row = TD::DB()->select(TD::tableFix("td_user"), ["USER_NAME","DEPT_ID"], ['USER_ID' => 'admin']);
            if(is_array($row) && !empty($row))
            {
                $FROM_NAME=$row[0]["USER_NAME"];
                $DEPT_ID=$row[0]["DEPT_ID"];
				echo $FROM_NAME.$DEPT_ID."<BR>";
            }

//循环查询演示
 $row1 = TD::DB()->select(TD::tableFix("td_user"), ["USER_NAME","DEPT_ID"]);
          // print_r($row1);
          foreach($row1 as $k=>$v){
          	//print_r($v);
          	//echo $v["USER_NAME"]."<BR>";
          	//echo "<br>";
          	}
//多条件查询          	
 $row = TD::DB()->select(TD::tableFix("td_user"), ["USER_NAME","DEPT_ID"], ["AND"=>['USER_ID' => 'admin',"UID"=>'1']]);  //多条件查询  注意中括号
            if(is_array($row) && !empty($row))
            {
                $FROM_NAME=$row[0]["USER_NAME"];
                $DEPT_ID=$row[0]["DEPT_ID"];
				echo $FROM_NAME.$DEPT_ID."<BR>";
            }
//原生的连表查询            
   $query="select a.USER_NAME,b.USER_ID from td_user as a,user_ext as b where a.UID=b.UID and a.USER_ID='admin'";  //原生的连表查询
   echo $query."<br>";      
   $row2= TD::DB()->prepareQuery($query);
    foreach($row2 as $k=>$v){
          	print_r($v);
          	//echo $v["USER_NAME"]."<BR>";
          	//echo "<br>";
          	}
//新增测试
//在sys_1og表中插入一条数据
 TD::DB()->insert(TD::tableFix("sys_log"),[
"USER_ID"=>'admin',
"TIME" =>"2020-08-18 15:07:51",
"IP" =>"127.0.0.1","TYPE"=>"10",
"REMARK"=>"测试插入操作"
]);

//获取插入的id
$id = TD::DB()->id(); 
echo $id."<br>";

//修改id为1s8的数据
$res = TD::DB()->update(TD::tableFix("sys_log"),[
"user_id"=>'changbai',"remark"=>'更新操作测试'],[
"AND"=>[
"user_id"=>'admin',"log_id"=> 18
]
]);

//获取受影响的行数
 echo $res->rowcount();
echo "<hr>";
 //删除id为19的数据
$res = TD::DB()->delete(TD::tableFix("sys_log"),[
"AND"=>[
"user_id" =>'admin',"log_id"=>19]
]);

//获取受影响的行数
 echo $res->rowCount();
?>




<body>
</body>
</html>