4.7.2 单用户报表展示
4.7.2.1 为主表添加一个流程
1.选中主表,点击表单信息,选择流程定义
2.点击新增流程,填写状态编号,状态名称,选择状态类型调用URL,如图所示(注意:url要与你的测试文件要一致)
3.再次选中主表.点击表单信息,选择表单数据
4.选中一条数据(此处要提前添加多个数据,后面要用),即可显示出"报支打印"
4.7.2.2 改写代码
1.打开复制过来的"报支打印.cshtml",把数据库连接修改成自己的,把SQL查询语句按自己的表重新编写
@{
var gisDB = Database.OpenConnectionString("GIS");//连接OrcleDB
string SpanBegin = string.Empty;
string SpanEnd = string.Empty;
//var totaluser = 0;
//BAOZHI_BAOZHI
List<dynamic> BaoZhiList = gisDB.Query(@"select * from SUBDEL_SECOND WHERE GUID='{0}'", Params.tabledataid);
List<dynamic> BaoZhiMinXiList = gisDB.Query(@"select * from SUBDEL_SECOND_INFORMATION where SGUID='{0}'", BaoZhiList[0].GUID);
}
2.单元格内容修改
把td中的内容修改成自己表中数据,之前别人写的多余的全都删除掉,这是我写的仅供参考
```HTML
<table style="width:90%;border-bottom:#4d4d4d 2px solid;border-right:#4d4d4d 1px solid;border-top: #4d4d4d 1px solid;" border="0" cellpadding="0" cellspacing="0" class="TableSTyle">
<tr>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">填报单号 </td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiList[0].SNUMBER</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">填报人 </td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiList[0].SNAME</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">填报日期 </td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiList[0].STIME</td>
@*<td rowspan="2" class="TdStyle_Left" style="width:10%; text-align:left;background-color:#ccc;"><b>序号</b></td>*@
</tr>
<tr>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">联系电话 </td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiList[0].STEL</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">报销种类 </td>
<td colspan="3" class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiList[0].SSUBKIND</td>
</tr>
<tr>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">费用合计 </td>
<td colspan="5" class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">人民币 @BaoZhiList[0].SCOUNT 美元 0 </td>
</tr>
<tr>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">费用说明 </td>
<td colspan="5" class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiList[0].SDESCRIBE</td>
</tr>
</table>
<table style="width:90%;border-bottom:#4d4d4d 2px solid;border-right:#4d4d4d 1px solid;border-top: #4d4d4d 1px solid;margin-top:1px" border="0" cellpadding="0" cellspacing="0" class="TableSTyle">
<tr>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">项次</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">支付日期</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">会计科目</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">金额</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">替代发票</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#ccc;">费用说明</td>
</tr>
@{
for (int i = 0; i < BaoZhiMinXiList.Count; i++)
{
<tr>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@(i + 1)</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiMinXiList[i].SPAYTIME</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiMinXiList[i].STYPE</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiMinXiList[i].SMONEY</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiMinXiList[i].SINVOICENUM</td>
<td class="TdStyle_Left" style=" text-align:left;background-color:#FFFFFF;">@BaoZhiMinXiList[i].SNOTES</td>
</tr>
}
}
</table>
3.打开复制过来的"feiyong.cshtml",一上来就能看见接收一个"IsShow"参数,我们这里用不到,把他去掉,留下一个"TableId"参数就好,后面还有个Guid也用不到,也一起去掉,关键代码如下
@{
string tabledataid = Request.QueryString["tabledataid"] == null ? "" : Request.QueryString["tabledataid"];
}
<script type="text/javascript" language="javascript" charset="utf-8">
$(document).ready(function () {
InitFrameLayout();
Timer = setInterval("DoTimer()", 1000);
AjaxLabel2({ name: "报支打印", IsShow: "1", tabledataid: "@tabledataid" }, ShowReport);
});
</script>
<body>
<input type="hidden" id="hidTitle" value="费用明细清单" />
<div id="mainContent" class="ui-layout-center">
<div id="toolbar" class="header ui-widget-header ui-layout-north">
<div style="float: left;">
<button onclick="DoQuery()">查询</button>
<button onclick="DoPrint()">打印</button>
<button onclick="DoExport('费用明细清单')">导出</button>
</div>
</div>
<div id="SearchCondition" class="ui-layout-south iconlist">
<div class="content">
</div>
</div>
</div>
</body>
4.把多余的引用的js都去掉,把对"IsShow"赋值的,做判断的代码都给他去掉,不然会报错,再到复制过来的"Feiyong.js"中,将有关对"IsShow"做判断相关代码删除
5.代码写完之后点击运行,网页上右击重新加载框架,然后选中一个数据,点击报支打印,即可获得数据