112 lines
4.7 KiB
Plaintext
112 lines
4.7 KiB
Plaintext
|
|
@{
|
|
ViewBag.Title = "tkmxbQuery";
|
|
}
|
|
|
|
@section scripts{
|
|
<script type="text/javascript" src="@Url.Content("~/Scripts/public.js")"></script>
|
|
<script type="text/javascript">
|
|
|
|
$(function () {
|
|
$("#start").ligerDateEditor();
|
|
$("#end").ligerDateEditor();
|
|
$("#start").ligerGetDateEditorManager().setValue(fun_date(-30));
|
|
$("#end").ligerGetDateEditorManager().setValue(fun_date(0));
|
|
|
|
cx();
|
|
})
|
|
|
|
function cx() {
|
|
var data = $("#searchForm").serializeArray();
|
|
$.ajax({
|
|
url: "@Url.Action("getTKMXB")", data: data, type: "post", dataType: "json",
|
|
success: function (data) {
|
|
$("#grid1").ligerGrid({
|
|
height: '98%',
|
|
width: '98%',
|
|
isScroll: true,
|
|
dataAction: "local",
|
|
selectRowButtonOnly: true,
|
|
data: data.data,
|
|
columns: [
|
|
{ name: "bm", display: "物资编码", width: 150, align: "left" },
|
|
{ name: "wzmc", display: "物资名称", width: 150, align: "left" },
|
|
{ name: "ksmc", display: "科室名称", width: 80, align: "left" },
|
|
{ name: "ggxh", display: "规格型号", width: 80, align: "left" },
|
|
{ name: "jldw", display: "计量单位", width: 80, align: "left" },
|
|
{ name: "tksj", display: "退库日期", width: 150 },
|
|
{ name: "sl", display: "数量", width: 80, align: "right" },
|
|
{ name: "dj", display: "单价", width: 80, align: "right" },
|
|
{ name: "mxzje", display: "退库金额", width: 80, align: "right", totalSummary: { type: 'sum' } },
|
|
],
|
|
alternatingRow: false,
|
|
usePager: false,
|
|
rownumbers:true,
|
|
});
|
|
liger.get("grid1").reRender();
|
|
}
|
|
});
|
|
}
|
|
function excel() {
|
|
var data = $("#searchForm").serializeArray();
|
|
|
|
$.ajax({
|
|
type: "post", cache: false, dataType: "json",
|
|
url: "@Url.Action("getTKMXBExcel")",
|
|
data: data,
|
|
success: function (result) {
|
|
$.ligerDialog.closeWaitting();
|
|
if (result.State == 1)
|
|
$("#export").attr("src", "@Url.Action("down")?file=" + result.Message);
|
|
else
|
|
$.ligerDialog.error(result.Message);
|
|
},
|
|
error: function (msg) {
|
|
$.ligerDialog.closeWaitting();
|
|
$.ligerDialog.error("操作失败，请重新操作");
|
|
return false;
|
|
},
|
|
beforeSend: function () { $.ligerDialog.waitting("正在导出，请稍候……"); }
|
|
});
|
|
}
|
|
|
|
function fun_date(days) {
|
|
var date1 = new Date(),
|
|
time1 = date1.getFullYear() + "-" + (date1.getMonth() + 1) + "-" + date1.getDate();//time1表示当前时间
|
|
var date2 = new Date(date1);
|
|
date2.setDate(date1.getDate() + days);
|
|
|
|
var y = date2.getFullYear();
|
|
var m = date2.getMonth() + 1;
|
|
m = m < 10 ? '0' + m : m;
|
|
var d = date2.getDate();
|
|
d = d < 10 ? ('0' + d) : d;
|
|
var time2 = y + "-" + m + "-" + d;
|
|
return time2;
|
|
}
|
|
</script>
|
|
}
|
|
<form id="searchForm">
|
|
<table class="t1" style="width:100%">
|
|
<tr>
|
|
<td width="70" class="ltd">退库时间</td>
|
|
<td width="150" class="rtd"><input type="text" id="start" name="start"></td>
|
|
<td width="20" class="ltd">到</td>
|
|
<td width="150" class="rtd"><input type="text" id="end" name="end"></td>
|
|
<td width="70" class="ltd">退库科室</td>
|
|
<td width="150" class="rtd">@Html.DropDownList("key", ViewData["kslist"] as SelectList, "----请选择----")</td>
|
|
<td width="70" class="ltd">物资名称</td>
|
|
<td width="150" class="rtd">@Html.TextBox("key1", "", new { @class = "l-text" })</td>
|
|
<td width="200" class="rtd">
|
|
<input type="button" value="查询" onclick="cx();" class="l-button" />
|
|
<input type="button" value="导出excel" onclick="excel();" class="l-button" />
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</form>
|
|
<div id="grid1"></div>
|
|
<div style="display:none">
|
|
<iframe id="export" src="about:blank"></iframe>
|
|
</div>
|
|
|