sqlserver门户设置

------ insert by wandz 20180918 门户模板表 start ------
set identity_insert oa_portal_template on;
begin
declare @reallybigtextstring varchar(4000);
set @reallybigtextstring = '<table style="TABLE-LAYOUT: fixed" id="portalMain" border="0" cellpadding="0" cellspacing="0" align="center" width="100%">
<tbody>
<tr>
<td class="portal-column-td" zone="A" colspan="2" width="100%">
<div class="dm"></div>
</td>
</tr>
<tr>
<td class="portal-column-td" zone="B" width="50%">
<div class="dm"></div>
</td>
<td class="portal-column-td" zone="C" width="50%">
<div class="dm"></div>
</td>
</tr>
</tbody>
</table>';
insert into oa_portal_template (template_id,name, content, image_, sys_flag, description, sort_no, create_user_id, create_date, create_org_id, del_flag, domain_id, cols_)
values ((select case when max(template_id) is null then 1 else max(template_id)+1 end from oa_portal_template ),'督查督办_1列_2列', @reallybigtextstring, null, 1, null, 1, 0, convert(datetime,getdate(),120), 0, '0', 0, 9);
end;
go
------ insert by wandz 20180918 门户模板表 end ------

转载于:https://www.cnblogs.com/wandezhi/p/10104335.html