## HTML
```
<div class="layui-inline layui-col-md2">
<label class="layui-form-label">材质</label>
<div class="layui-input-block">
<select name="Material" id="government-index-station-Material">
<option value="">--请选择--</option>
</select>
</div>
</div>
```
JS
```
admin.req({
url: layui.setter.apiUrl.SlopsApi + '/Execute',
data: {
path: 'government/station/detail/BasicInfo.txt',
bidID: layui.data(layui.setter.tableName).bidID
},
done: function (res) {
$.each(res.tables[2], function (idx, item) {
$("#government-index-station-Material").append("<option value='" + item.F_Key + "'>" + item.Caption + "</option>")
});
form.render(null, 'government-index-station-form');
}
});
```
## SQL
```
select
pb.ID as BidID,pb.BidCap,918 as FolderID,pb.FolderID as PreFolderID
from Slops.dbo.P_ProjectBid pb
left join Slops.dbo.S_FileSystem s on s.PreID = pb.FolderID and s.Source = 'UnifyStation'
where pb.ID = @bidID
SELECT F_Key,Caption
FROM Slops.dbo.S_DictItem
WHERE DictID = 40 ORDER BY F_Order
SELECT F_Key,Caption
FROM Slops.dbo.S_DictItem
WHERE DictID = 36 ORDER BY F_Order
select F_Key,Caption
from Slops.dbo.S_DictItem where DictID=48
order by F_Order
```
