「ERP php程式碼」:修訂間差異
跳至導覽
跳至搜尋
| 第5行: | 第5行: | ||
$q_where->set_q_title('TD002',array('訂單號','2')); | $q_where->set_q_title('TD002',array('訂單號','2')); | ||
$cond= $q_where->display(); | $cond= $q_where->display(); | ||
</php> | |||
==繼承用程式碼== | |||
<php> | |||
//利用exC_DataGrid以及exset_col_title,可繼承ADMMD中之欄位 | |||
$sg1 = new exC_DataGrid("SELECT TD001,TD002,TD003,TD004,COPTD.UDF01,TC093 FROM COPTD JOIN COPTC ON TC001=TD001 AND TC002=TD002",array("TD001","TD002","TD003"),"COPTD"); | |||
$sg1 ->exset_col_title("TD001,TD002,TD003,TD004,COPTD.UDF01","COPTD"); | |||
$sg1 ->exset_col_title("TC093","COPTC"); | |||
$sg1 -> display(); | |||
</php> | </php> | ||
於 2015年12月29日 (二) 08:29 的修訂
搜尋用程式碼
<php> $q_where=new Wherequery(); $q_where->set_q_title('TD001',array('訂單別')); $q_where->set_q_title('TD002',array('訂單號','2')); $cond= $q_where->display(); </php>
繼承用程式碼
<php> //利用exC_DataGrid以及exset_col_title,可繼承ADMMD中之欄位 $sg1 = new exC_DataGrid("SELECT TD001,TD002,TD003,TD004,COPTD.UDF01,TC093 FROM COPTD JOIN COPTC ON TC001=TD001 AND TC002=TD002",array("TD001","TD002","TD003"),"COPTD"); $sg1 ->exset_col_title("TD001,TD002,TD003,TD004,COPTD.UDF01","COPTD"); $sg1 ->exset_col_title("TC093","COPTC"); $sg1 -> display(); </php>