SmartCost
/
ConstructionOperation


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691
							<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta http-equiv="x-ua-compatible" content="ie=edge">
    <title>清单规则编辑器</title>
    <link rel="stylesheet" href="/lib/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" href="/web/maintain/bills_lib/css/main.css">
    <link rel="stylesheet" href="/lib/font-awesome/font-awesome.min.css">
    <!--spread-->
    <link rel="stylesheet" href="/lib/spreadjs/sheets/css/gc.spread.sheets.excel2013lightGray.10.0.1.css">
</head>

<body>
    <div class="header">
        <nav class="navbar navbar-toggleable-lg navbar-light bg-faded p-0 ">
            <span class="header-logo px-2">清单规则编辑器</span>
            <div class="navbar-text"></div>
        </nav>
        <nav class="navbar navbar-toggleable-lg justify-content-between navbar-light p-0">

              <ul class="nav nav-tabs" role="tablist">
                  <li class="nav-item">
                      <a class="nav-link active px-3" href="javascript: void(0);">清单</a>
                  </li>
                  <li class="nav-item">
                      <a id="aStdJobs" class="nav-link px-3" href="stdJobs">工作内容</a>
                  </li>
                  <li class="nav-item">
                      <a id="aStdItems" class="nav-link px-3" href="stdItems">项目特征</a>
                  </li>
              </ul>
        </nav>
    </div>
    <div class="main">
      <div class="content" >
        <div class="container-fluid">
          <div class="row">
            <div class="main-content col-lg-7 p-0">
                <nav class="navbar sticky-top navbar-toggleable-md navbar-light bg-faded tools-bar">
                  <div class="collapse navbar-collapse" id="navbarNav">
                      <ul class="navbar-nav">
                          <li class="nav-item">
                              <a class="nav-link text-primary" doing="false" fcsOnBills="true" id="insert" href="javascript: void(0);"><i class="fa fa-share" aria-hidden="true"></i>插入</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" doin="false" fcsOnBills="true" id ="delete" href="javascript:void (0)"><i class="fa fa-remove" aria-hidden="true"></i>删除</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" doing="false" fcsOnBills="true" id="upLevel"  href="javascript: void(0);"><i class="fa fa-arrow-left" aria-hidden="true"></i>升级</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" doing="false" fcsOnBills="true" id="downLevel" href="javascript: void(0);"><i class="fa fa-arrow-right" aria-hidden="true"></i>降级</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" doing="false" fcsOnBills="true" id="upMove" href="javascript: void(0);"><i class="fa fa-arrow-up" aria-hidden="true"></i>上移</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" doing="false" fcsOnBills="true" id="downMove" href="javascript: void(0);"><i class="fa fa-arrow-down" aria-hidden="true"></i>下移</a>
                          </li>
                      </ul>
                  </div>
                </nav>
                <div class="main-data" id="spreadBills">
                </div>
            </div>
            <div class="main-side col-lg-5 p-0">
              <div class="container-fluid">
                <div class="row">
                  <div class="col" style="width:50%; height: 100%">
                      <h5>工作内容</h5>
                      <div id="spreadJobs"  style="width:97%; height: 300px;"></div>
                  </div>
                  <div class="col" style="width:50%; height: 100%">
                    <h5>项目特征</h5>
                      <div id="spreadItems" style="width: 97%; height: 300px;"></div>
                  </div>
                  <div class="w-100"></div>
                  <div class="col">
                    <div class="form-group">
                      <label for="exampleTextarea"><h5>补注：</h5></label>
                      <textarea class="form-control" id="exampleTextarea" rows="8"></textarea>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
    <!--弹出添加-->
    <div class="modal fade" id="add" data-backdrop="static" style="display: none;" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                  <h5 class="modal-title">添加定额</h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                  </button>
                </div>
                <div class="modal-body">
                  <form>
                    <div class="form-group">
                      <label>编码</label>
                      <input class="form-control" placeholder="输入编码" type="text">
                    </div>
                    <div class="form-group">
                      <label>名称</label>
                      <input class="form-control" placeholder="输入名称" type="text">
                    </div>
                    <div class="form-group">
                      <label>单位</label>
                      <select class="form-control"><option>选择单位</option><option>m3</option></select>
                    </div>
                    <div class="form-group">
                      <label>基价</label>
                      <input class="form-control" placeholder="输入基价" type="number">
                    </div>
                    <div class="form-group">
                      <label>显示名称（以%s表示参数）</label>
                      <input class="form-control" placeholder="输入显示名称" type="text">
                    </div>
                    <div class="form-group">
                      <label>默认取费专业</label>
                      <input class="form-control" placeholder="输入取费专业" type="text">
                    </div>
                  </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
                    <a href="" class="btn btn-primary">添加</a>
                </div>
            </div>
        </div>
    </div>
    <!--弹出编辑-->
    <div class="modal fade" id="edit" data-backdrop="static" style="display: none;" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                  <h5 class="modal-title">编辑定额</h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                  </button>
                </div>
                <div class="modal-body">
                  <form>
                    <div class="form-group">
                      <label>编码</label>
                      <input class="form-control" placeholder="输入编码" type="text" value="AA0001">
                    </div>
                    <div class="form-group">
                      <label>名称</label>
                      <input class="form-control" placeholder="输入名称" type="text" value="人工挖土方">
                    </div>
                    <div class="form-group">
                      <label>单位</label>
                      <select class="form-control"><option>m3</option></select>
                    </div>
                    <div class="form-group">
                      <label>基价</label>
                      <input class="form-control" placeholder="输入基价" type="number" value="880.84">
                    </div>
                    <div class="form-group">
                      <label>显示名称（以%s表示参数）</label>
                      <input class="form-control" placeholder="输入显示名称" type="text" value="人工挖土方">
                    </div>
                    <div class="form-group">
                      <label>默认取费专业</label>
                      <input class="form-control" placeholder="输入取费专业" type="text" value="1">
                    </div>
                  </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
                    <a href="" class="btn btn-primary">确定</a>
                </div>
            </div>
        </div>
    </div>

    <!--弹出删除-->
    <div class="modal fade" id="del" data-backdrop="static" style="display: none;" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                  <h5 class="modal-title">删除确认</h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                  </button>
                </div>
                <div class="modal-body">
                    <h5 class="text-danger">删除后无法恢复，确认是否删除？</h5>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
                    <a href="" class="btn btn-danger">删除</a>
                </div>
            </div>
        </div>
    </div>
    <!--弹出提示窗口-->
    <div class="modal fade" id="qAlert" style="display: none; margin: 300px auto; width: 300px; height: 200px;">
        <div id="alertText"></div>
        <div style="margin: 50px auto">
            <button id="alertBtn" class="btn btn-warning">确定</button>
        </div>
    </div>
    <!-- JS. -->
    <script src="/lib/spreadjs/sheets/gc.spread.sheets.all.10.0.1.min.js"></script>
    <script>GC.Spread.Sheets.LicenseKey = "559432293813965#A0y3iTOzEDOzkjMyMDN9UTNiojIklkI1pjIEJCLi4TPB9mM5AFNTd4cvZ7SaJUVy3CWKtWYXx4VVhjMpp7dYNGdx2ia9sEVlZGOTh7NRlTUwkWR9wEV4gmbjBDZ4ElR8N7cGdHVvEWVBtCOwIGW0ZmeYVWVr3mI0IyUiwCMzETN8kzNzYTM0IicfJye&Qf35VfiEzRwEkI0IyQiwiIwEjL6ByUKBCZhVmcwNlI0IiTis7W0ICZyBlIsIyNyMzM5ADI5ADNwcTMwIjI0ICdyNkIsIibj9SbvNmL4N7bjRnch56ciojIz5GRiwiI8+Y9sWY9QmZ0Jyp96uL9v6L0wap9biY9qiq95q197Wr9g+89iojIh94Wiqi";</script>
    <script src="/lib/jquery/jquery.min.js"></script>
    <script src="/lib/tether/tether.min.js"></script>
    <script src="/lib/bootstrap/bootstrap.min.js"></script>
    <script src="/web/maintain/bills_lib/scripts/global.js"></script>
    <script src="/web/maintain/bills_lib/scripts/set_sheets.js"></script>
    <script src="/web/maintain/bills_lib/scripts/bills_lib_ajax.js"></script>
    <!--idTree-->
    <script src="/public/web/id_tree.js"></script>
    <script src="/public/web/tree_sheet/tree_sheet_controller.js"></script>
    <script src="/public/web/tree_sheet/tree_sheet_helper.js"></script>
    <script src="/web/maintain/bills_lib/scripts/bills_lib_setting.js"></script>
    <script src="/web/maintain/bills_lib/scripts/bills_lib_tree.js"></script>
    <script src="/web/maintain/bills_lib/scripts/db_controller.js"></script>
    <script src="/web/maintain/bills_lib/scripts/tools.js"></script>
</body>
<script type="text/javascript">
    autoFlashHeight();
    let maxJobsNumber;
    let maxItemsNumber;
    let orgJobData;
    let orgItemData;
    let billsTree = billsLibTree.createBillsTree();
    let billsLibId = getQueryString("billsLibId");
    let sheetDatas;
    let sheetItemsDatas;
    let sheetBillsDatas;
    tools.redirect(billsLibId, 'stdBillsmain');
    let jobsSpread = new GC.Spread.Sheets.Workbook($("#spreadJobs")[0], {sheetCount: 1});
    let itemsSpread = new GC.Spread.Sheets.Workbook($("#spreadItems")[0], {sheetCount: 1});
    $(document).ready(function(){
        $("#aStdJobs").attr('href', function(){
            return 'stdJobs?billsLibId=' + billsLibId;
        });
        $('#aStdItems').attr('href', function(){
            return 'stdItems?billsLibId=' + billsLibId;
        });
        billsAjax.getStdBillsLibName(billsLibId);
        billsAjax.getBills(billsLibId, function(bills){
            showBillsSheet(bills, jobsSpread.getActiveSheet(), itemsSpread.getActiveSheet(), billsLibSetting)
        });
        buildJobs(jobsSpread, jobsSetting);
        buildItems(itemsSpread, itemsSetting);
    });

    function nodeOpration(controller, totalJobs, totalItems){
        let btnInsert = $('#insert');
        let btnDelete = $('#delete');
        let btnUpLevel = $('#upLevel');
        let btnDownLevel = $('#downLevel');
        let btnUpMove = $('#upMove');
        let btnDownMove = $('#downMove');
        dbController.editData(controller);
        btnInsert.click(function(){
            if(btnInsert.attr('doing') === 'false' && btnInsert.attr('fcsOnBills') === 'true'){
                dbController.insert(controller, btnInsert);
                tools.clearData(jobsSpread.getActiveSheet());
                tools.clearData(itemsSpread.getActiveSheet());
            }
        });
        btnDelete.click(function(){
            if(btnDelete.attr('doing') === 'false' && btnDelete.attr('fcsOnBills') === 'true'){
                dbController.delete(controller, btnDelete, totalJobs, totalItems);
            }
        });
        btnUpLevel.click(function(){
            if(btnUpLevel.attr('doing') === 'false' && btnUpLevel.attr('fcsOnBills') === 'true'){
                dbController.upLevel(controller, btnUpLevel);
            }
        });
        btnDownLevel.click(function(){
            if(btnDownLevel.attr('doing') === 'false' && btnDownLevel.attr('fcsOnBills') === 'true'){
                dbController.downLevel(controller, btnDownLevel);
            }
        });
        btnUpMove.click(function(){
            if(btnUpMove.attr('doing') === 'false' && btnUpMove.attr('fcsOnBills') === 'true'){
                dbController.upMove(controller, btnUpMove);
            }
        });
        btnDownMove.click(function(){
            if(btnDownMove.attr('doing') === 'false' && btnDownMove.attr('fcsOnBills') === 'true'){
                dbController.downMove(controller, btnDownMove);
            }
        });
    }


    function showBillsSheet(datas, jobsSheet, itemsSheet, setting) {
        let billsSpread = new GC.Spread.Sheets.Workbook($('#spreadBills')[0], {sheetCount: 1});
        setSheet.initSheet(billsSpread, setting, true);
        myKey.delKey(billsSpread);
        billsTree.loadDatas(datas);
        let controller = TREE_SHEET_CONTROLLER.createNew(billsTree.tree, billsSpread.getActiveSheet(), setting);
        controller.showTreeData();
        setSheet.formatter(billsSpread.getActiveSheet());
        //setTagId
        setTagID(controller, setting);
        if (!controller.tree.selected && controller.tree.findNode(controller.sheet.getTag(0, 0, GC.Spread.Sheets.SheetArea.viewport))) {
            controller.setTreeSelected(controller.tree.findNode(controller.sheet.getTag(0, 0, GC.Spread.Sheets.SheetArea.viewport)));
        }
        //刷新节点可进行操作的按钮
        refreshBtn(controller);
        controller.setTreeSelected(controller.tree.findNode(controller.sheet.getTag(0, 0)));
        //粘贴事件
        bindPasteBills(controller, billsSpread.getActiveSheet(), setting);
        //补注内容改变
        rechargeChange(controller);
        //焦点控制
        switchFcs(controller, controller.sheet, jobsSheet, itemsSheet);
        //jobs
        jobOperation(controller, jobsSheet, function(totalJobs){
            //------关联表粘贴复制
            bindPasteRel(jobsSheet, controller, totalJobs, jobsSetting);
            //items
            itemOperation(controller, itemsSheet, function(totalItems){
                bindPasteItemsRel(itemsSheet, controller, totalItems, itemsSetting);
                //节点操作
                nodeOpration(controller, totalJobs, totalItems);
            });
        });
    }

    function switchFcs(controller, billsSheet, jobsSheet, itemsSheet){
        billsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
            $('#insert').attr('fcsOnBills', 'true');
            $('#delete').attr('fcsOnBills', 'true');
            $('#upLevel').attr('fcsOnBills', 'true');
            $('#downLevel').attr('fcsOnBills', 'true');
            jobsSheet.clearSelection();
            itemsSheet.clearSelection();
        });
        jobsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
            $('#insert').attr('fcsOnBills', 'false');
            $('#delete').attr('fcsOnBills', 'false');
            $('#upLevel').attr('fcsOnBills', 'false');
            $('#downLevel').attr('fcsOnBills', 'false');
            let selected;
            if(controller.tree.selected){
                 selected = controller.tree.selected.jobs[args.row];
            }
            if(tools.canUpMove(selected, controller.tree.selected.jobs)){
            }
            itemsSheet.clearSelection();
            itemsSheet.options.isProtected = true;
            jobsSheet.options.isProtected = false;
        });
        itemsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
            $('#insert').attr('fcsOnBills', 'false');
            $('#delete').attr('fcsOnBills', 'false');
            $('#upLevel').attr('fcsOnBills', 'false');
            $('#downLevel').attr('fcsOnBills', 'false');
            if(controller.tree.selected){
                let selected = controller.tree.selected.items[args.row];
            }
            jobsSheet.clearSelection();
            jobsSheet.options.isProtected = true;
            itemsSheet.options.isProtected = false;
        })
    };

    function setTagID(controller, setting){
        if(controller.tree.items.length > 0){
            let length = controller.tree.items.length;
            for(var i=0; i<length; i++){
                setting.cols.forEach(function(col, colIdx){
                    if(controller.tree.items[i].data.ID){
                        controller.sheet.setTag(i, colIdx, controller.tree.items[i].data.ID);
                    }
                });
            }
        }
    }

    function refreshBtn(controller){
        controller.bind('refreshBaseActn', function (tree) {
            let showButton = function (show, btn) {
                tools.btnAction($('#insert'), 'focusOnBills');
                if (show) {
                    //btn.show();
                    tools.btnAction(btn, 'doing');
                    /*btn.css("opacity", "");
                    btn.removeClass("disabled");*/
                } else {
                    //btn.hide();
                    /*btn.css("opacity", "0.2");
                    btn.addClass("disabled");*/
                    tools.btnClose(btn, 'doing');
                }
            };
            showButton(tree.selected && tree.selected.canUpLevel(), $('#upLevel'));
            showButton(tree.selected && tree.selected.canDownLevel(), $('#downLevel'));
            showButton(tree.selected && tree.selected.canUpMove(), $('#upMove'));
            showButton(tree.selected && tree.selected.canDownMove(), $('#downMove'));
            showButton(tree.selected ? true : false, $('#delete'));
        });
    }

    function rechargeChange(controller){
        $('#exampleTextarea').bind('change', function(){
            let newData = $('#exampleTextarea').val();
            if(controller.tree.selected){
                rechargeController.updateRechar(controller.tree.selected, newData);
            }
        });
    }

    function jobOperation(controller, jobsSheet, callback){
        mainAjax.getMaxNumber(billsLibId, 'jobs', function(result){
            if(result.length === 0){
                maxJobsNumber = 0;
            }
            else {
                maxJobsNumber = result[0].code;
            }
            jobsAjax.getJobContent(billsLibId, function(datas){
                let totalJobs = createObj.newJobs();
                totalJobs.loadJobs(controller.tree.items, datas);
                initData(controller, jobsSheet, jobsSetting, 'jobs');
                myKey.delKey(jobsSpread, controller, totalJobs, jobsSetting, 'jobs');
                bindSheet(controller, jobsSheet, 'jobs', jobsSetting);
                jobsController.editData(controller, jobsSheet, totalJobs, jobsSetting);
                if (callback){
                    callback(totalJobs);
                }
            });
        });
    }

    function itemOperation(controller, itemsSheet, callback){
        mainAjax.getMaxNumber(billsLibId, 'items', function(result){
            if(result.length === 0){
                maxItemsNumber = 0;
            }
            else {
                maxItemsNumber = result[0].code;
            }
            itemsAjax.getItemCharacter(billsLibId, function(datas){
                let totalItems = createObj.newItems();
                totalItems.loadItems(controller.tree.items, datas);
                initData(controller, itemsSheet, itemsSetting, 'items');
                myKey.delKey(itemsSpread, controller, totalItems, itemsSetting, 'items');
                bindSheet(controller, itemsSheet, 'items', itemsSetting);
                itemsController.editData(controller, itemsSheet, totalItems, itemsSetting);
                if(callback){
                    callback(totalItems)
                }
            });
        });
    }

    //初始焦点工作表和项目表绑定数据
    function initData(controller, sheet, setting, classify){
        if(controller.tree.selected){
            let arr = controller.tree.selected[classify];
            let recharge = controller.tree.selected.data.recharge;
            let prefix = classify === 'jobs' ? 'job' : 'item';
            if(arr.length > 0){
                tools.orderReshowData(sheet, arr, setting, prefix,true);
            }
            if(recharge){
                $('#exampleTextarea').val(recharge);
            }
        }
    }

    function bindSheet(controller, sheet, field, setting){
        controller.sheet.bind(GC.Spread.Sheets.Events.SelectionChanged, function(sender, args){
            if(controller.tree.selected  && args.oldSelections[0].row !== args.newSelections[0].row|| controller.tree.selected && args.oldSelections[0].row === 0){
                //rechargeArea
                $('#exampleTextarea').val(controller.tree.selected.data.recharge);
                tools.clearData(sheet);
                if(field === 'jobs'){
                    let jobs = controller.tree.selected.jobs;
                    setSheet.setMaxRowCount(sheet, jobs);
                    if(jobs.length > 0){
                        tools.orderReshowData(sheet, jobs, setting, 'job', true);
                        orgJobData = sheet.getValue(0, 0);
                    }
                    sheetDatas = tools.getsheetDatas(sheet, 'jobs');
                }
                if(field === 'items'){
                    let items = controller.tree.selected.items;
                    setSheet.setMaxRowCount(sheet, items);
                    if(items.length > 0){
                        tools.orderReshowData(sheet, items, setting, 'item', true);
                        orgItemData = sheet.getValue(0, 0);
                    }
                    sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
                }
            }
            else {
                tools.clearData(sheet);
                $('#exampleTextarea').val('');
            }
        });
    }

    function bindPasteBills(controller, sheet, setting){
        sheetBillsDatas = tools.getsheetDatas(sheet, 'bills', controller);
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
            let datas = [], field;
            let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
            let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
            let markRow = orgRow, colLen = sheet.getColumnCount(GC.Spread.Sheets.SheetArea.viewport);
            let validDatas = tools.getValidDatas(sheet, setting, args);
            for(let i =orgRow, j=0; i<= maxRow; i++, j++){
                let id = sheet.getTag(i, 0);
                if(id && j< validDatas.length){
                    validDatas[j].ID = id;
                    for(let k =orgCol; k<= maxCol; k++){
                        setting.cols.forEach(function(col, colIdx){
                            if(colIdx === k){
                                if(validDatas[j][col.data.field]){
                                    sheet.setValue(i, k, validDatas[j][col.data.field]);
                                    sheetBillsDatas.datasIdx['rowIdx'+ i][col.data.field] = validDatas[j][col.data.field];
                                }
                                else {
                                    sheet.setValue(i, k, '');
                                    sheetBillsDatas.datasIdx['rowIdx'+ i][col.data.field] = '';
                                }
                            }
                        });
                    }
                }
                else if(i < controller.tree.items.length && j>= validDatas.length){
                    //reshow orgDatas
                    sheet.setValue(i, 0, sheetBillsDatas.datasIdx['rowIdx'+ i].code + '');
                    sheet.setValue(i, 1, sheetBillsDatas.datasIdx['rowIdx'+ i].name);
                    sheet.setValue(i, 2, sheetBillsDatas.datasIdx['rowIdx'+ i].unit);
                    sheet.setValue(i, 3, sheetBillsDatas.datasIdx['rowIdx'+ i].ruleText);
                }
                else {
                    sheet.clear(i, 0, 1, sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport,GC.Spread.Sheets.StorageType.data);
                }
            }
            billsAjax.pasteBills(billsLibId, validDatas);
            setSheet.setMaxRowCount(sheet, sheetBillsDatas);
        });
    }
    function bindPasteRel(sheet, controller, totalJobs, setting){
        sheetDatas = tools.getsheetDatas(sheet, 'jobs');
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
          //  sheet.setColumnCount(2, GC.Spread.Sheets.SheetArea.viewport);
           // sheet.setColumnCount(2, GC.Spread.Sheets.SheetArea.colHeader);
            if(controller.tree.selected){
                let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
                let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
                let pasteArr = [];
                let crossedDatas = [];
                let uncrossedDatas = [];
                const colIdx = 1;
                for(let i=orgRow; i<=maxRow; i++){
                    if(sheet.getCell(i, colIdx).value()){
                        pasteArr.push(sheet.getCell(i, colIdx).value());
                    }
                }
                let uniqPasteArr = tools.uniqArr(pasteArr);
                let serialNoUn = tools.getSerialNo(controller.tree.selected.jobs) - 1;
                for(let i =orgRow, j=0; i<=uniqPasteArr.length+orgRow-1; i++, j++ ){
                    let flag = true;
                    let crossedData;
                    sheetDatas.forEach(function(rowData){
                        if(rowData.rowIdx === i && rowData.data !== uniqPasteArr[j]){
                            flag = false;
                            let serialNo = tools.getObj(controller.tree.selected.jobs, rowData.id, 'job');
                            crossedData = {
                                orgId: rowData.id,
                                newData: uniqPasteArr[j],
                                serialNo: serialNo
                            };
                        }
                    });
                    if(flag){
                        serialNoUn++;
                        uncrossedDatas.push({data: uniqPasteArr[j], serialNo: serialNoUn});
                    }
                    else {
                        crossedDatas.push(crossedData);
                    }
                }
                let pasteDatas = tools.encapData(uncrossedDatas, crossedDatas, controller, totalJobs);
                if(pasteDatas.updateDatas.length > 0 || pasteDatas.createDatas.length > 0){
                    billsAjax.pasteRel(pasteDatas.updateDatas, pasteDatas.createDatas, 'jobs', function(datas){
                        pasteController.frontOperator(sheet, setting, controller, totalJobs, datas);
                    });
                }
                else {
                    tools.orderReshowData(sheet, controller.tree.selected.jobs, setting, 'job', true);
                }
            }
            else {
                tools.clearData(sheet);
            }
        });
    }
    function bindPasteItemsRel(sheet, controller, totalItems, setting){
        sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
            //sheet.setColumnCount(2, GC.Spread.Sheets.SheetArea.viewport);
           // sheet.setColumnCount(2, GC.Spread.Sheets.SheetArea.colHeader);
            if(controller.tree.selected){
                let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
                let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
                let pasteArr = [];
                let crossedDatas = [];
                let uncrossedDatas = [];
                const colIdx = 1;
                for(let i=orgRow; i<=maxRow; i++){
                    if(sheet.getCell(i, colIdx).value()){
                        pasteArr.push(sheet.getCell(i, colIdx).value());
                    }
                }
                let uniqPasteArr = tools.uniqArr(pasteArr);
                let serialNoUn = tools.getSerialNo(controller.tree.selected.items) - 1;
                for(let i =orgRow, j=0; i<=uniqPasteArr.length+orgRow-1; i++, j++ ){
                    let flag = true;
                    let crossedData;
                    sheetItemsDatas.forEach(function(rowData){
                        if(rowData.rowIdx === i && rowData.data !== uniqPasteArr[j]){
                            flag = false;
                            let serialNo = tools.getObj(controller.tree.selected.items, rowData.id, 'item');
                            crossedData = {
                                orgId: rowData.id,
                                newData: uniqPasteArr[j],
                                serialNo: serialNo
                            };
                        }
                    });
                    if(flag){
                        //let serialNo = tools.getSerialNo(controller.tree.selected.items);
                        serialNoUn ++;
                        console.log(serialNoUn);
                        uncrossedDatas.push({data: uniqPasteArr[j], serialNo: serialNoUn});
                    }
                    else {
                        crossedDatas.push(crossedData);
                    }
                }
                let pasteDatas = tools.encapItemsData(uncrossedDatas, crossedDatas, controller, totalItems);
                if(pasteDatas.updateDatas.length > 0 || pasteDatas.createDatas.length > 0){
                    billsAjax.pasteRel(pasteDatas.updateDatas, pasteDatas.createDatas, 'items', function(datas){
                        pasteController.frontItemsRelOperator(sheet, setting, controller, totalItems, datas);
                    });
                }
                else{
                    tools.orderReshowData(sheet, controller.tree.selected.items, setting, 'item', true);
                }
            }
            else {
                tools.clearData(sheet);
            }
        });
    }


    function buildJobs(jobsSpread, setting){
        setSheet.initSheet(jobsSpread, setting, true);
       // setSheet.setMaxRowCount(jobsSpread.getActiveSheet(), 10);
        jobsSpread.getActiveSheet().clearSelection();
        myKey.downKey(jobsSpread);
        myKey.enterKey(jobsSpread);
        TREE_SHEET_HELPER.loadSheetHeader(jobsSetting, jobsSpread.getActiveSheet());
    }

    function buildItems(itemsSpread, setting){
        setSheet.initSheet(itemsSpread, setting, true);
       // setSheet.setMaxRowCount(itemsSpread.getActiveSheet(), 10);
        itemsSpread.getActiveSheet().clearSelection();
        myKey.downKey(itemsSpread);
        myKey.enterKey(itemsSpread);
        TREE_SHEET_HELPER.loadSheetHeader(itemsSetting, itemsSpread.getActiveSheet());
    }


</script>

</html>