function GetGrid2() {
var jqdata = [
{ Encode:"20180100", FullName: "BYD", SpecType: "cpu200", UnitName: "台", SecondUnit: "", Qty: "10", UnitCode: "50000", Cost: "35000" },
{ Encode:"20180100", FullName: "BYD", SpecType: "cpu200", UnitName: "台", SecondUnit: "", Qty: "10", UnitCode: "50000", Cost: "35000" }
];
//创建jqGrid组件
var $gridTable = $('#gridTable');
       //固定列
var model = [
{ label: "商品编号", name: "Encode", width: 100, align: 'left', sortable: false },
{ label: "商品名称", name: "FullName", width: 130, align: "left", sortable: false },
{ label: "规格型号", name: "SpecType", width: 150, align: 'left', sortable: false },
{ label: "单位", name: "UnitName", width: 150, align: 'left', sortable: false },
{ label: "副单位", name: "SecondUnit", width: 150, align: 'left', sortable: false },
{ label: "基本数量", name: "Qty", width: 150, align: 'left', sortable: false },
{ label: "单位成本", name: "UnitCode", width: 150, align: 'left', sortable: false },
{ label: "成本", name: "Cost", width: 150, align: 'left', sortable: false }];
        //动态列
var addmodel = [{ label: "基本数量", name: "SHQty", width: 150, align: 'left', sortable: false }, { label: "可用库存", name: "SHRealQty", width: 150, align: 'left', sortable: false }];
$.each(addmodel, function (key, value) {
model.push({
label: value.label,
name: value.name,
index: key,
width: value.width,
align: value.align,
sortable: value.sortable
});
});
//创建jqGrid组件
$gridTable.jqGrid(
{
datatype: "json",
height: $(window).height() - 230.5,
autowidth: true,
colModel: model,
pager: false,
rownumbers: true,
shrinkToFit: false,
gridview: true,
footerrow: true,
sortname: 'ExecutionDate',
sortorder: 'desc',
beforeRequest: function () {
$("thead th").css("text-align", "center").css("font-weight", "bold");
},
gridComplete: function () {
var totalreceivable = $(this).getCol("Receivable", false, "sum");
var totalexpenses = $(this).getCol("Expenses", false, "sum");
var totalbalance = $(this).getCol("Balance", false, "sum");
//合计
$(this).footerData("set", {
"ExecutionDate": "合计:",
"Receivable": totalreceivable,
"Expenses": totalexpenses,
"Balance": totalbalance
});
$('table.ui-jqgrid-ftable td').prevUntil().css("border-right-color", "#fff");
}
});
//将jqdata的值循环添加进jqGrid
for (var i = 0; i <= jqdata.length; i++) {
$gridTable.jqGrid('addRowData', i + 1, jqdata[i]);
}
//固定表头合并
var groupHeaders = [
{ startColumnName: 'Qty', numberOfColumns: 3, titleText: '<div align="center"><b>所有仓库</b></div>' }
];
        //动态表头
if (1 == 1) {
groupHeaders.push({ startColumnName: 'SHQty', numberOfColumns: 2, titleText: '<div align="center"><b>上海仓库</b></div>' });
}
$gridTable.jqGrid('setGroupHeaders', {
useColSpanStyle: true,
groupHeaders: groupHeaders
}); }

  

最新文章

  1. 最常用的ES6特性(转)
  2. tp框架之函数调用
  3. 玩转 H5 下拉上滑动效
  4. Spring MVC 4.1.4 RESTFUL风格返回JSON数据406错误处理
  5. iOS学习之内存管理
  6. mongo(三)基本操作
  7. Java局部变量final
  8. 统计图表--第三方开源--MPAndroidChart(一)
  9. LeetCode: MergekSortedLists
  10. jQuery弹出层---artDialog 文档
  11. CodeForces 1
  12. UVa 10034 - Freckles
  13. 【转】布同:如何循序渐进学习Python语言
  14. [BZOJ1880] [Sdoi2009] Elaxia的路线 (SPFA &amp; 拓扑排序)
  15. java调用kettle的job和transfer工具类
  16. thinkphp封装方法添加跨域请求
  17. python 用正则处理日志实例
  18. python3+ selenium3开发环境搭建
  19. 后台任务hangfire
  20. MFC文档应用程序CToolBar:设置两个工具条并列停靠到同一条边上 转

热门文章

  1. 用自定义的RoundImageView来实现圆形图片(可加边框)
  2. Eclipse自定义的透视图如何删除掉?
  3. 奇怪吸引子---Arneodo
  4. 混沌分形之马丁(Martin)迭代
  5. Longest Palindromic Substring leetcode java
  6. Linux下配置nfs并远程挂载
  7. 【架构】技术-工具-平台-语言&amp;框架
  8. LSTM 文本情感分析/序列分类 Keras
  9. HTML/CSS-返回到上一页
  10. [Git] Change the commit message of my last commit