/** * Created by Tony on 2017/5/5. */ $("#drirect-dinge").click(function(){ $(this).attr('href', "/rationRepository/ration" + "?repository=" + getQueryString("repository")) }); var pageOprObj = { rationLibName : null, initPage : function(container) { var me = this, rationLibName = getQueryString("repository");//获取定额库参数 if (rationLibName) { var html = $("#rationname")[0].outerHTML; html = html.replace("XXX定额库", rationLibName); $("#rationname")[0].outerHTML = html; me.rationLibName = rationLibName; repositoryGljObj.getGljTree(rationLibName, function(repId){ repositoryGljObj.buildSheet(container); repositoryGljObj.getGljItems(repId); }); } } } repositoryGljObj = { treeObj : null, workBook: null, gljAllTypeId: -1, gljCurTypeId: -1, currentRepositoryId: -1, gljList: [], setting: { header:[ {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"}, {headerName:"名称",headerWidth:400,dataCode:"name", dataType: "String", hAlign: "left", vAlign: "center"}, {headerName:"规格",headerWidth:120,dataCode:"specs", dataType: "String", hAlign: "left", vAlign: "center"}, {headerName:"单位",headerWidth:120,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"}, {headerName:"基价单价",headerWidth:120,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"}, {headerName:"类型",headerWidth:120,dataCode:"gljType", dataType: "Number", hAlign: "center", vAlign: "center"} ], view:{ comboBox:[ {row:-1,col:3,rowCount:-1,colCount:1} ], lockedCells:[ ] } }, getGljTree: function(rationLibName, callback) { var me = this; $.ajax({ type:"POST", url:"api/getGljTree", data:{"rationLibName": rationLibName}, dataType:"json", cache:false, timeout:20000, success:function(result,textStatus,status){ if(status.status == 200) { me.createTree(result.data); //me.gljAllTypeId if (result.data && result.data.length > 0) { for (var i = 0; i < result.data.length; i++) { if (result.data[i].Name === "全部") { me.gljAllTypeId = result.data[i].ID; me.gljCurTypeId = me.gljAllTypeId; break; } } if (callback) { var repId = -1; repId = result.data[0].repositoryId; callback(repId); } } } }, error:function(err){ alert(err.responseJSON.error); } }) }, createTree : function(sourceData){ var me = repositoryGljObj, treeArr = tree_Data_Helper.buildTreeNodeDirectly(sourceData); me.treeObj = $.fn.zTree.init($("#repositoryTree"), setting, treeArr); me.treeObj.expandAll(true); }, getGljItems: function(repId) { var me = this; me.currentRepositoryId = repId; $.ajax({ type:"POST", url:"api/getGljItems", data:{"repositoryId": repId}, dataType:"json", cache:false, timeout:5000, success:function(result){ if(result.success) { me.gljList = result.data; me.showGljItems(result.data, me.gljCurTypeId); } }, error:function(err){ alert(err.responseJSON.error); } }) }, showGljItems: function(data, type) { var me = repositoryGljObj; if (me.workBook) { var cacheSection = []; for (var i = 0; i < data.length; i++) { if (type == me.gljAllTypeId || type == data[i].gljType) { cacheSection.push(data[i]); } } cacheSection.sort(function(g1, g2) { var rst = 0; if (g1.code > g2.code) rst = 1 else if (g1.code < g2.code) rst = -1; return rst; }) sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1); sheetCommonObj.showData(me.workBook.getSheet(0), me.setting, cacheSection); } }, buildSheet: function(container) { var me = repositoryGljObj; me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30); //var instance = new GC.Spread.Common.CultureInfo(); //var value; // Type: Object //value = instance.NumberFormat; //console.log(value); me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting); me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted); //me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, function (sender, args) { // console.log("Start cell editing."); //}); me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, function (sender, args) { console.log("Finish cell editing."); //if (args.col == 0) { // args.sheet.suspendPaint(); // args.sheet.suspendEvent(); // args.sheet.setValue(args.row, args.col, args.editingText, GC.Spread.Sheets.SheetArea.viewport); // args.sheet.resumeEvent(); // args.sheet.resumePaint(); //} }); }, onClipboardPasting: function(sender, args) { var me = repositoryGljObj; if (args.cellRange.colCount != me.setting.header.length) { args.cancel = true; } }, onClipboardPasted: function(e, info) { var me = repositoryGljObj; var updateArr = [], addArr = []; var items = sheetCommonObj.analyzePasteData(me.setting, info); var hasCacheItem = false; for (var i = 0; i < items.length; i++) { for (var j = 0; j < me.gljList.length; j++) { if (me.gljList[j][me.setting.header[0].dataCode] == items[i][me.setting.header[0].dataCode]) { hasCacheItem = true; items[i]["ID"] = me.gljList[j]["ID"]; break; } } if (!hasCacheItem) { addArr.push(items[i]); } else { updateArr.push(items[i]); } } if (updateArr.length > 0 || addArr.length > 0) { $.ajax({ type:"POST", url:"api/mixUpdateGljItems", data:{"repositoryId": me.currentRepositoryId, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr)}, dataType:"json", cache:false, timeout:5000, success:function(result){ if (result.err) { alert(err); me.getRationItems(me.currentRepositoryId); } else { if (addArr.length > 0) { me.gljList = me.gljList.concat(addArr); } for (var i = 0; i < updateArr.length; i++) { for (var j = 0; j < me.gljList.length; j++) { if (me.gljList[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) { me.gljList[j] = updateArr[i]; } } } me.showGljItems(me.gljList, me.gljAllTypeId); } }, error:function(){ } }) } }, onClick: function(event,treeId,treeNode) { var me = repositoryGljObj, gljTypeId = treeNode.ID; repositoryGljObj.gljCurTypeId = treeNode.ID; repositoryGljObj.showGljItems(repositoryGljObj.gljList, gljTypeId); } }