SmartCost
/
YangHuOperation


			
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463
							<!DOCTYPE html>
<html lang="zh-CN">

<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">
    <link rel="stylesheet" href="/lib/jquery-contextmenu/jquery.contextMenu.css">
    <!--spread-->
    <link rel="stylesheet" href="/lib/spreadjs/sheets/css/gc.spread.sheets.sc.css">
    <link rel="stylesheet" href="/lib/codemirror/codemirror.css">
    <link rel="stylesheet" href="/lib/codemirror/material.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>
                  <li class="nav-item">
                    <a id="aStdDesigns" class="nav-link px-3" href="stdDesigns">设计细目</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 lock-btn-control" 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">
                            <input class="lock-btn-control" style="width: 50px; height: 24px;margin-top:5px" id="insert_row" type="text" value="1" type="number" min="1"  step="1" />
                         </li>
                        <li class="nav-item">
                            <a class="nav-link text-primary lock-btn-control" doing="false" fcsOnBills="true"  href="javascript: void(0);">行</a>
                        </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary lock-btn-control" doing="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 lock-btn-control" 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 lock-btn-control" 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 lock-btn-control" doing="false" fcsOnBills="true" canMove="false" 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 lock-btn-control" doing="false" fcsOnBills="true" canMove="false" id="downMove" href="javascript: void(0);"><i class="fa fa-arrow-down" aria-hidden="true"></i>下移</a>
                          </li>
                          <li class="nav-item">
                            <div class="search-container">
                                <input type="text" placeholder="输入后按回车查找..." id="searchInput" class="icon-input">
                                <i class="fa fa-search search-icon"></i>
                            </div> 
                        </li>
                        <li class="nav-item" id="searchResult" style="display: none;">
                            搜索结果：<span id="searchCount">0</span>  
                            <a class="btn btn-primary next-btn" doing="false" canMove="false" id="search-pre" href="javascript: void(0);">上一个</a> 
                            <a class="btn btn-primary next-btn" doing="false" canMove="false" id="search-next" href="javascript: void(0);">下一个</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" style="overflow: auto; height: 100%;">
                  <div  style="width:50%; height: 330px; float: left;">
                      <h5>工作内容</h5>
                      <div id="spreadJobs" class="ovf-hidden" style="width:97%; height: 300px;"></div>
                    </div>
                    <div  style="width:50%; height: 330px; float: left;">
                        <h5>项目特征</h5>
                        <div id="spreadItems" class="ovf-hidden" style="width: 97%; height: 300px;"></div>
                    </div>
                    <div style="width:100%; height: 330px; float: left;">
                        <h5>设计细目</h5>
                        <div id="spreadDesigns" class="ovf-hidden" style="width:97%; height: 300px;"></div>
                </div>
                 <!-- <div class="form-group">
                      <a class="pull-right" href="javacript:void(0);" data-toggle="modal" data-target="#help" >html怎么写？</a>
                      <label for="exampleTextarea">补注：</label>
                      <textarea id="exampleTextarea" name="editor" class="form-control" rows="8"></textarea>
                  </div>-->
                  <div class="form-group" style="height: 330px; clear: both;">
                      <a class="pull-right" href="javacript:void(0);" data-toggle="modal" data-target="#help" >html怎么写？</a>
                      <a trigger="billsRecharge" class="pull-right mr-3 uploadImgTrigger lock-btn-control" href="javacript:void(0);" data-toggle="modal" data-target="#uploadimg" ><i class="fa fa-image"></i>上传图片</a>
                      <label for="exampleTextarea">补注：</label>
                      <textarea class="form-control" id="exampleTextarea" rows="8"></textarea>
                      <div>
                        <label for="erratumRecordText">勘误记录：</label>
                        <textarea class="form-control lock-btn-control" id="erratumRecordText" rows="8" style="height: calc(100% - 38px);"></textarea>
                    </div>
                  </div>
               <!-- <div class="row">
                  <div class="col ovf-hidden" style="width:50%; height: 100%; float: left;">
                      <h5>工作内容</h5>
                      <div id="spreadJobs"  style="width:97%; height: 300px;"></div>
                  </div>
                  <div class="col" style="width:50%; height: 100%; float: left;">
                    <h5>项目特征</h5>
                      <div id="spreadItems" class="ovf-hidden" 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>
    <!--弹出提示窗口-->
    <button id="alertBtn" class="btn btn-primary btn-lg" data-toggle="modal" data-target="#alertDiv" style="display: none"></button>
    <div class="modal fade" id="alertDiv" data-backdrop="static" style="display: none;" aria-hidden="true">
        <input type="hidden"  value="123">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">警告</h5>
                    <button type="button" id="alertCls" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <div class="modal-body">
                    <h5 class="text-danger" id="alertTxt">编号不存在，请重新输入！</h5>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-danger" id="alertCof" data-dismiss="modal">确认</button>
                </div>
            </div>
        </div>
    </div>
    <!--删除-->
    <div class="modal fade" id="delAlert" data-backdrop="static" style="display: none;" aria-hidden="true">
        <input type="hidden"  value="123">
        <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" id="delText">是否删除当前清单及其子项？</h5>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-danger" id="delConfirm">确认</button>
                    <button type="button" class="btn btn-secondary"  data-dismiss="modal">取消</button>
                </div>
            </div>
        </div>
    </div>
    <!--弹出html填写帮助-->
    <!--弹出html填写帮助-->
    <div class="modal fade" id="help" style="display: none;" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">html填写帮助</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <div class="modal-body">
                    <p class="text-primary">&lt;p&gt;这是一行文本&lt;/p&gt;</p>
                    <p class="mb-0">文本居中：text-center</p>
                    <p class="text-primary">&lt;p class="text-center" &gt;这是一行文本&lt;/p&gt;</p>
                    <p class="mb-0">文本居右：text-right</p>
                    <p class="text-primary">&lt;p class="text-right" &gt;这是一行文本&lt;/p&gt;</p>
                    <p class="mb-0">文本居左（默认已居左）：text-left</p>
                    <p class="text-primary">&lt;p class="text-left" &gt;这是一行文本&lt;/p&gt;</p>
                    <p class="mb-0">表格：table、tr、th、td</p>
                    <p class="mb-0 text-primary">&lt;table&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;th&gt;表头1&lt;/th&gt;&lt;th&gt;表头2&lt;/th&gt;&lt;th&gt;表头3&lt;/th&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容1&lt;/td&gt;&lt;td&gt;内容2&lt;/td&gt;&lt;td&gt;内容3&lt;/td&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容4&lt;/td&gt;&lt;td&gt;内容5&lt;/td&gt;&lt;td&gt;内容6&lt;/td&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;/table&gt;</p>
                    <p>
                    <table class="table table-sm table-bordered">
                        <tr><th>表头1</th><th>表头2</th><th>表头3</th></tr>
                        <tr><td>内容1</td><td>内容2</td><td>内容3</td></tr>
                        <tr><td>内容4</td><td>内容5</td><td>内容6</td></tr>
                    </table>
                    </p>
                    <p class="mb-0">合并横向单元格(2格)：colspan="2"</p>
                    <p class="mb-0 text-primary">&lt;table&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;th colspan="2"&gt;表头1表头2&lt;/th&gt;&lt;th&gt;表头3&lt;/th&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容1&lt;/td&gt;&lt;td&gt;内容2&lt;/td&gt;&lt;td&gt;内容3&lt;/td&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容4&lt;/td&gt;&lt;td&gt;内容5&lt;/td&gt;&lt;td&gt;内容6&lt;/td&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;/table&gt;</p>
                    <p>
                    <table class="table table-sm table-bordered">
                        <tr><th colspan="2">表头1表头2</th><th>表头3</th></tr>
                        <tr><td>内容1</td><td>内容2</td><td>内容3</td></tr>
                        <tr><td>内容4</td><td>内容5</td><td>内容6</td></tr>
                    </table>
                    </p>
                    <p class="mb-0">合并竖向单元格(2格)：rowspan="2"</p>
                    <p class="mb-0 text-primary">&lt;table&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;th&gt;表头1&lt;/th&gt;&lt;th&gt;表头2&lt;/th&gt;&lt;th&gt;表头3&lt;/th&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;td rowspan="2"&gt;内容1内容4&lt;/td&gt;&lt;td&gt;内容2&lt;/td&gt;&lt;td&gt;内容3&lt;/td&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容5&lt;/td&gt;&lt;td&gt;内容6&lt;/td&gt;&lt;/tr&gt;</p>
                    <p class="mb-0 text-primary">&lt;/table&gt;</p>
                    <p>
                    <table class="table table-sm table-bordered">
                        <tr><th>表头1</th><th>表头2</th><th>表头3</th></tr>
                        <tr><td rowspan="2">内容1内容4</td><td>内容2</td><td>内容3</td></tr>
                        <tr><td>内容5</td><td>内容6</td></tr>
                    </table>
                    </p>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
                </div>
            </div>
        </div>
    </div>
    <%include ../../../common/html/uploadImg.html %>
    <!-- JS. -->
    <script src = "/lib/spreadjs/sheets/gc.spread.sheets.all.11.1.2.min.js"></script>
    <script src = "/lib/localforage/localforage.min.js"></script>
    <script src="/public/common_util.js"></script>
    <script>GC.Spread.Sheets.LicenseKey =  '<%- LicenseKey %>';</script>
    <script src="/public/web/uuid.js"></script>
    <script src="/lib/jquery/jquery.min.js"></script>
    <script src="/lib/tether/tether.min.js"></script>
    <script src="/lib/jquery-contextmenu/jquery.contextMenu.min.js"></script>
    <script src="/lib/jquery-contextmenu/jquery.ui.position.js"></script>
    <script src="/lib/bootstrap/bootstrap.min.js"></script>
    <script src="/web/maintain/bills_lib/scripts/global.js"></script>
    <script src="/public/web/PerfectLoad.js"></script>
    <script src="/public/web/common_ajax.js"></script>
    <script src="/public/web/lock_util.js"></script>
    <script src="/public/web/sheet/sheet_common.js"></script>
    <script type="text/javascript" src="/public/web/sheet/sheet_data_helper.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>
    <script src="/lib/codemirror/codemirror.js"></script>
    <script src="/lib/codemirror/xml.js"></script>
    <script src="/web/common/js/uploadImg.js"></script>
</body>
<script type="text/javascript">
    const locked = lockUtil.getLocked();
    var codeEditor = CodeMirror.fromTextArea(document.getElementById("exampleTextarea"), {
        mode: "text/html",
        lineNumbers: true,
        theme:"material",
        readOnly: locked
    });
    codeEditor.setSize('auto', '350px');
    const erratumRecordEditor = CodeMirror.fromTextArea(document.getElementById("erratumRecordText"), {
        mode: "text/html",
        lineNumbers: true,
        theme:"material",
        readOnly: locked
    });
    erratumRecordEditor.setSize('auto','350px');
    autoFlashHeight();
    let BillsFixedFlagList = JSON.parse('<%- BillsFixedFlagList %>');
    let userAccount = '<%= userAccount %>';
    let maxJobsNumber;
    let maxItemsNumber;
    let orgJobData;
    let orgDesignData;
    let orgItemData;
    let billsTree = billsLibTree.createBillsTree();
    let billsLibId = getQueryString("billsLibId");
    let sheetDatas;
    let sheetDesignsDatas;
    let sheetItemsDatas;
    let sheetBillsDatas;
    tools.redirect(billsLibId, 'stdBillsmain');
    let billsSpread;
    let jobsSpread = new GC.Spread.Sheets.Workbook($("#spreadJobs")[0], {sheetCount: 1});
    jobsSpread.options.allowUserDragFill = false;
    sheetCommonObj.bindEscKey(jobsSpread, [{sheet: jobsSpread.getSheet(0), editStarting: jobsController.onEditStart, editEnded: jobsController.onEditEnded}]);
    let itemsSpread = new GC.Spread.Sheets.Workbook($("#spreadItems")[0], {sheetCount: 1});
    itemsSpread.options.allowUserDragFill = false;
    sheetCommonObj.bindEscKey(itemsSpread, [{sheet: itemsSpread.getSheet(0), editStarting: itemsController.onEditStart, editEnded: itemsController.onEditEnded}]);
    let designsSpread = new GC.Spread.Sheets.Workbook($("#spreadDesigns")[0], {sheetCount: 1});
    designsSpread.options.allowUserDragFill = false;
    sheetCommonObj.bindEscKey(designsSpread, [{sheet: designsSpread.getSheet(0), editStarting: designsController.onEditStart, editEnded: designsController.onEditEnded}]);
    const billKindComboList = [
        { name: '大项费用', value: 1 },
        { name: '项目节', value: 8 },
        { name: '清单', value: 4 },
    ];
    $(document).ready(function(){
        $("#aStdJobs").attr('href', function(){
            return `stdJobs?billsLibId=${billsLibId}&locked=${locked}`;
        });
        $('#aStdItems').attr('href', function(){
            return `stdItems?billsLibId=${billsLibId}&locked=${locked}`;
        });
        $('#aStdDesigns').attr('href', function(){
                return `stdDesigns?billsLibId=${billsLibId}&locked=${locked}`;
            });
        billsAjax.getStdBillsLibName(billsLibId);
        billsAjax.getBills(billsLibId, function(bills){
            showBillsSheet(bills, jobsSpread.getActiveSheet(), designsSpread.getActiveSheet(), itemsSpread.getActiveSheet(), billsLibSetting)
            const spreads = [billsSpread, jobsSpread, designsSpread, itemsSpread];
            const $range = $(document.body);
            lockUtil.lockSpreadsAndTools(spreads, $range, locked);
        });
        buildJobs(jobsSpread, jobsSetting);
        buildDesigns(designsSpread, designsSetting);
        buildItems(itemsSpread, itemsSetting);
    });

    function nodeOpration(controller, totalJobs, totalDesigns, totalItems){
        let btnInsert = $('#insert');
        let btnDelete = $('#delete');
        let btnUpLevel = $('#upLevel');
        let btnDownLevel = $('#downLevel');
        let btnUpMove = $('#upMove');
        let btnDownMove = $('#downMove');
        dbController.editData(controller, billsSpread);

        function onInsert(){
            if(btnInsert.attr('doing') === 'false' && btnInsert.attr('fcsOnBills') === 'true'){
                let btnInsertRow = $('#insert_row').val();
                if (isNaN(btnInsertRow) || btnInsertRow < 1) {
                    alert(`请输入正确的行数。`);
                    $('#insert_row').val('1');
                    return;
                }
                btnInsertRow = parseInt(btnInsertRow) ;
                dbController.insert(controller, btnInsert,btnInsertRow);
                tools.clearData(jobsSpread.getActiveSheet());
                tools.clearData(itemsSpread.getActiveSheet());
            }
        }

        btnInsert.click(function(){
            onInsert()
        });


        $('#insert_row').on('keypress', function(e) {
            // 检查是否按下的是 Enter 键（keyCode 13 或 which 13）
            if (e.which === 13 || e.keyCode === 13) {
                onInsert()
            }
        });
        //删除清单
        $('#delConfirm').click(function () {
            dbController.delete(controller, btnDelete, totalJobs, totalItems);
            $('#delAlert').modal('hide');
        });

        function isMatch(bill,searchInput){
            searchInput = searchInput.toLowerCase().trim()
            const billName = bill.data.name? bill.data.name.toLowerCase():''; 
            const code = bill.data.code? bill.data.code.toLowerCase():''; 
            return billName.includes(searchInput) || code.includes(searchInput);
        }


        function locateBill(bill){
            if(bill){
                controller.setTreeSelected(bill);
                controller.sheet.setSelection(bill.serialNo(), 1, 1, 1); 
                controller.sheet.showRow(bill.serialNo(), GC.Spread.Sheets.VerticalPosition.center);
            }
        }

        $('#searchInput').on('keypress', function(e) {
            // 检查是否按下的是 Enter 键（keyCode 13 或 which 13）
            if (e.which === 13 || e.keyCode === 13) {
                const searchValue = $(this).val().toLowerCase().trim();
                if(searchValue){
                    const controller = dbController.controller;
                    let select = null;
                    let count =0
                    for(const bill of controller.tree.items){
                       if(isMatch(bill,searchValue)){
                          if(select===null) select=bill   
                          count++;                    
                        }
                    }
                    locateBill(select);   
                    $('#searchCount').text(count); 
                    $('#searchResult').show();     
                }else{
                    $('#searchResult').hide();
                }    
            }
        });


        $('#search-next').click(function(){
            const searchValue = $('#searchInput').val().toLowerCase().trim();
            if(searchValue){
                const controller = dbController.controller;
                const selected = controller.tree.selected;
                if(selected){
                    const index = controller.tree.items.indexOf(selected)+1;
                    if(index>=controller.tree.items.length) return ;
                    for(let i=index ;i<controller.tree.items.length;i++){
                        if(isMatch(controller.tree.items[i],searchValue)){
                            locateBill(controller.tree.items[i]);
                            break;
                        }
                    }
                } 
            } 
        });

        $('#search-pre').click(function(){
            const searchValue = $('#searchInput').val().toLowerCase().trim();
            if(searchValue){
                const controller = dbController.controller;
                const selected = controller.tree.selected;
                if(selected){
                    const index = controller.tree.items.indexOf(selected)-1;
                    if(index<0) return ;
                    for(let i=index ;i>=0;i--){
                        if(isMatch(controller.tree.items[i],searchValue)){
                            locateBill(controller.tree.items[i]);
                            break;
                        }
                    }
                } 
            } 
        });

        btnDelete.click(function(){
            if(btnDelete.attr('doing') === 'false' && btnDelete.attr('fcsOnBills') === 'true'){
                $('#delAlert').modal('show');
            }
        });
        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);
            }
            //refSheet
            else if(btnUpMove.attr('doing') === 'false' && btnUpMove.attr('fcsOnBills') === 'false' && btnUpMove.attr('canMove') === 'true'){
                if(controller.tree.selected.field === 'job'){
                    jobsController.upMove(controller, jobsSpread.getActiveSheet());
                }
                else if(controller.tree.selected.field === 'item'){
                    itemsController.upMove(controller, itemsSpread.getActiveSheet());
                }
                else if(controller.tree.selected.field === 'design'){
                    designsController.upMove(controller, designsSpread.getActiveSheet());
                }
            }
        });
        btnDownMove.click(function(){
            if(btnDownMove.attr('doing') === 'false' && btnDownMove.attr('fcsOnBills') === 'true'){
                dbController.downMove(controller, btnDownMove);
            }
            else if(btnDownMove.attr('doing') === 'false' && btnDownMove.attr('fcsOnBills') === 'false' && btnDownMove.attr('canMove') === 'true'){
                if(controller.tree.selected.field === 'job'){
                    jobsController.downMove(controller, jobsSpread.getActiveSheet());
                }
                else if(controller.tree.selected.field === 'item'){
                    itemsController.downMove(controller, itemsSpread.getActiveSheet());
                }
                else if(controller.tree.selected.field === 'design'){
                    designsController.downMove(controller, designsSpread.getActiveSheet());
                }
            }
        });
    }
    function setCombo(sheet, col, comboDatas) {
        sheet.suspendPaint();
        sheet.suspendEvent();
        let combo = sheetCommonObj.getDynamicCombo();
        combo.items(comboDatas).itemHeight(10).editable(false);
        sheet.getRange(-1, col, -1, 1).cellType(combo);
        sheet.resumePaint();
        sheet.resumeEvent();
    }
    function showBillsSheet(datas, jobsSheet, designsSheet, itemsSheet, setting) {
        billsSpread = new GC.Spread.Sheets.Workbook($('#spreadBills')[0], {sheetCount: 1});
        let billsSheet = billsSpread.getSheet(0);
        billsSheet.frozenColumnCount(3);
        sheetCommonObj.bindEscKey(billsSpread, [{sheet: billsSpread.getSheet(0), editStarting: dbController.onEditStart, editEnded: dbController.onEditEnded}]);
        billsSpread.focus(true);
        setSheet.initSheet(billsSpread, setting, true);
        myKey.delKey(billsSpread);
        for (let data of datas) {
            if (data.fixedFlag) {
                let findData = BillsFixedFlagList.find((x) => data.fixedFlag === x.value);
                if (findData) {
                    data.fixedFlag = findData.name;
                }
            }
            if (data.kind) {
                const kindItem = billKindComboList.find(item => item.value === data.kind);
                if (kindItem) {
                    data.kind = kindItem.name;
                }
            }
        }
        billsTree.loadDatas(datas);
        for (col of setting.cols) {
            if (col.data.field === 'isBillBudget') {
                col.data.cellType = new GC.Spread.Sheets.CellTypes.CheckBox();
            }
    }
        let controller = TREE_SHEET_CONTROLLER.createNew(billsTree.tree, billsSpread.getActiveSheet(), setting);
        controller.showTreeData();
        dbController.controller = controller;
        sheetBillsDatas = tools.getsheetDatas(controller.sheet, 'bills', controller);
        setSheet.formatter(billsSpread.getActiveSheet());
        const codeCol = setting.cols.findIndex(item => item.data.field ==='code');
        billsSheet.setFormatter(-1, codeCol, '@', GC.Spread.Sheets.SheetArea.viewport);
        //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);
        bindBillsRangeChanged(controller, billsSpread.getActiveSheet(), setting);
        //补注内容改变
        rechargeChange(controller);//
        // 勘误错误改变
        erratumRecordChange(controller)
        //焦点控制
        switchFcs(controller, controller.sheet, billsSpread, jobsSheet, designsSheet, itemsSheet);
        //jobs
        jobOperation(controller, jobsSheet, function(totalJobs){
            //------关联表粘贴复制
            bindPasteRel(jobsSheet, controller, totalJobs, jobsSetting);
            //items
            itemOperation(controller, itemsSheet, function(totalItems){
                bindPasteItemsRel(itemsSheet, controller, totalItems, itemsSetting);

                designOperation(controller, designsSheet, function (totalDesigns) {
                    bindPasteDesignRel(designsSheet, controller, totalDesigns, designsSetting);
                    //节点操作
                    nodeOpration(controller, totalJobs, totalDesigns, totalItems);
                })
            });
        });
        // 设置类别下拉
        const kindCol = setting.cols.findIndex((data) => data.data.field === 'kind');
        const kindList = billKindComboList.map(item => item.name);
        setCombo(billsSheet, kindCol, kindList);
        // 设置固定清单下拉
        let nameList = BillsFixedFlagList.map((data) => data.name);
        let comboCol = setting.cols.findIndex((data) => data.data.field === 'fixedFlag');
        setCombo(billsSheet, comboCol, nameList);
        onContextmenuOpr(billsSpread, controller);
    }

    function switchFcs(controller, billsSheet, billsSpread, jobsSheet, designsSheet, itemsSheet){
        let btnInsert = $('#insert');
        let btnDelete = $('#delete');
        let btnUpMove = $('#upMove');
        let btnDownMove = $('#downMove');
        let btnUpLevel = $('#upLevel');
        let btnDownLevel = $('#downLevel');
        billsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
                jobsSheet.clearSelection();
                itemsSheet.clearSelection();
                designsSheet.clearSelection();
                billsSpread.focus(true);
                jobsSheet.options.isProtected = true;
                designsSheet.options.isProtected = true;
                itemsSheet.options.isProtected = true;
                billsSheet.options.isProtected = false;

                btnInsert.attr('fcsOnBills', 'true');
                btnDelete.attr('fcsOnBills', 'true');
                btnUpLevel.attr('fcsOnBills', 'true');
                btnDownLevel.attr('fcsOnBills', 'true');
                btnUpMove.attr('fcsOnBills', 'true');
                btnDownMove.attr('fcsOnBills', 'true');
        });
        jobsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
                itemsSheet.clearSelection();
                designsSheet.clearSelection();
                jobsSpread.focus(true);
                itemsSheet.options.isProtected = true;
                billsSheet.options.isProtected = true;
                designsSheet.options.isProtected = true;
                jobsSheet.options.isProtected = false;
                controller.tree.selected.args = args;
                controller.tree.selected.field = 'job';
                tools.btnClose(btnInsert);
                tools.btnClose(btnDelete);
                tools.btnClose(btnUpLevel);
                tools.btnClose(btnDownLevel);
                btnInsert.attr('fcsOnBills', 'false');
                btnDelete.attr('fcsOnBills', 'false');
                btnUpLevel.attr('fcsOnBills', 'false');
                btnDownLevel.attr('fcsOnBills', 'false');
                btnUpMove.attr('fcsOnBills', 'false');
                btnDownMove.attr('fcsOnBills', 'false');
                let selected;
                if(controller.tree.selected){
                    selected = controller.tree.selected.jobs[args.row];
                }
                if(tools.canUpMove(selected, controller.tree.selected.jobs)){
                    tools.btnAction(btnUpMove);
                    btnUpMove.attr('canMove', 'true');
                }
                else{
                    tools.btnClose(btnUpMove);
                    btnUpMove.attr('canMove', 'false');
                }
                if(tools.canDownMove(selected, controller.tree.selected.jobs)){
                    tools.btnAction(btnDownMove);
                    btnDownMove.attr('canMove', 'true');
                }
                else{
                    tools.btnClose(btnDownMove);
                    btnDownMove.attr('canMove', 'false');
                }
        });
        designsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
                jobsSheet.clearSelection();
                itemsSheet.clearSelection();
                designsSpread.focus(true);
                itemsSheet.options.isProtected = true;
                jobsSheet.options.isProtected = true;
                billsSheet.options.isProtected = true;
                designsSheet.options.isProtected = false;
                controller.tree.selected.args = args;
                controller.tree.selected.field = 'design';
                tools.btnClose(btnInsert);
                tools.btnClose(btnDelete);
                tools.btnClose(btnUpLevel);
                tools.btnClose(btnDownLevel);
                btnInsert.attr('fcsOnBills', 'false');
                btnDelete.attr('fcsOnBills', 'false');
                btnUpLevel.attr('fcsOnBills', 'false');
                btnDownLevel.attr('fcsOnBills', 'false');
                btnUpMove.attr('fcsOnBills', 'false');
                btnDownMove.attr('fcsOnBills', 'false');
                let selected;
                if(controller.tree.selected){
                    selected = controller.tree.selected.designs[args.row];
                }
                if(tools.canUpMove(selected, controller.tree.selected.designs)){
                    tools.btnAction(btnUpMove);
                    btnUpMove.attr('canMove', 'true');
                }
                else{
                    tools.btnClose(btnUpMove);
                    btnUpMove.attr('canMove', 'false');
                }
                if(tools.canDownMove(selected, controller.tree.selected.designs)){
                    tools.btnAction(btnDownMove);
                    btnDownMove.attr('canMove', 'true');
                }
                else{
                    tools.btnClose(btnDownMove);
                    btnDownMove.attr('canMove', 'false');
                }
        });
        itemsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
                jobsSheet.clearSelection();
                designsSheet.clearSelection();
                itemsSpread.focus(true);
                jobsSheet.options.isProtected = true;
                designsSheet.options.isProtected = true;
                billsSheet.options.isProtected = true;
                itemsSheet.options.isProtected = false;

                controller.tree.selected.args = args;
                controller.tree.selected.field = 'item';
                tools.btnClose(btnInsert);
                tools.btnClose(btnDelete);
                tools.btnClose(btnUpLevel);
                tools.btnClose(btnDownLevel);
                btnInsert.attr('fcsOnBills', 'false');
                btnDelete.attr('fcsOnBills', 'false');
                btnUpLevel.attr('fcsOnBills', 'false');
                btnDownLevel.attr('fcsOnBills', 'false');
                btnUpMove.attr('fcsOnBills', 'false');
                btnDownMove.attr('fcsOnBills', 'false');
                let selected;
                if(controller.tree.selected){
                    selected = controller.tree.selected.items[args.row];
                }
                if(tools.canUpMove(selected, controller.tree.selected.items)){
                    tools.btnAction(btnUpMove);
                    btnUpMove.attr('canMove', 'true');
                }
                else{
                    tools.btnClose(btnUpMove);
                    btnUpMove.attr('canMove', 'false');
                }
                if(tools.canDownMove(selected, controller.tree.selected.items)){
                    tools.btnAction(btnDownMove);
                    btnDownMove.attr('canMove', 'true');
                }
                else{
                    tools.btnClose(btnDownMove);
                    btnDownMove.attr('canMove', '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){
        if (locked) {
            return;
        }
        controller.bind('refreshBaseActn', function (tree) {
            let showButton = function (show, btn) {
                tools.btnAction($('#insert'), 'focusOnBills');
                if (show) {
                    tools.btnAction(btn, 'doing');
                } else {
                    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){
        codeEditor.on("change", function () {
            if(controller.tree.selected){
                let newData = codeEditor.getValue();
                if(newData !== controller.tree.selected.data.recharge){
                    rechargeController.updateRechar(controller.tree.selected, newData);
                }
            }
        });
        /*$('#exampleTextarea').bind('change', function(){
            let newData = $('#exampleTextarea').val();
            if(controller.tree.selected){
                console.log(controller.tree.selected.data.code)
                rechargeController.updateRechar(controller.tree.selected, newData);
            }
        });*/
    }

    // 勘误记录
    function erratumRecordChange(controller){
        erratumRecordEditor.on('change', async function () {
            console.log('1111');
            const node = controller.tree.selected;
            const erratumRecord = erratumRecordEditor.getValue();
            if (!node || erratumRecord === node.data.erratumRecord) {
                return;
            }
            try {
                const updateId = node.getID();
                await ajaxPost('/stdBillsEditor/updateBills', { billsLibId, updateId, field: 'erratumRecord', data: erratumRecord });
                node.data.erratumRecord = erratumRecord;
            } catch(error) {
                alert(error.message);
                erratumRecordEditor.setValue(node.data.erratumRecord || '');
            }
        });
    }

    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);
                jobsController.totalJobs = totalJobs;
                initData(controller, jobsSheet, jobsSetting, 'jobs');
                myKey.delKey(jobsSpread, controller, totalJobs, jobsSetting, 'jobs');
                bindSheet(controller, jobsSheet, 'jobs', jobsSetting);
                jobsController.editData(jobsSheet);
                if (callback){
                    callback(totalJobs);
                }
            });
        });
    }

    function designOperation(controller, designsSheet, callback){
        mainAjax.getMaxNumber(billsLibId, 'designs', function(result){
            if(result.length === 0){
                maxDesignsNumber = 0;
            }
            else {
                maxDesignsNumber = result[0].code;
            }
            designsAjax.getDesignContent(billsLibId, function(datas){
                let totalDesigns = createObj.newDesigns();
                totalDesigns.loadDesigns(controller.tree.items, datas);
                designsController.totalDesigns = totalDesigns;
                initData(controller, designsSheet, designsSetting, 'designs');
                myKey.delKey(designsSpread, controller, totalDesigns, designsSetting, 'designs');
                bindSheet(controller, designsSheet, 'designs', designsSetting);
                designsController.editData(designsSheet);
                if (callback){
                    callback(totalDesigns);
                }
            });
        });
    }

    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);
                itemsController.totalItems = totalItems;
                initData(controller, itemsSheet, itemsSetting, 'items');
                myKey.delKey(itemsSpread, controller, totalItems, itemsSetting, 'items');
                bindSheet(controller, itemsSheet, 'items', itemsSetting);
                itemsController.editData(itemsSheet);
                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;
            const prefix = classify.replace(/s$/, '');
            if(arr.length > 0){
                tools.orderReshowData(sheet, arr, setting, prefix,true);
            }
            else{
                setSheet.setMaxRowCount(sheet, []);
            }
            if(recharge){
                codeEditor.setValue(recharge);
                //$('#exampleTextarea').val(recharge);
            }
            else{
                codeEditor.setValue('');
                //$('#exampleTextarea').val('');
            }
            const erratumRecord = controller.tree.selected.data.erratumRecord || '';
            erratumRecordEditor.setValue(erratumRecord);
        }
    }

    function bindSheet(controller, sheet, field, setting){
        controller.sheet.bind(GC.Spread.Sheets.Events.SelectionChanged, function(sender, args){
            if(args.newSelections[0]){
                controller.tree.selected = controller.tree.items[args.newSelections[0].row] ? controller.tree.items[args.newSelections[0].row] : null;
            }
            if(controller.tree.selected  && args.oldSelections[0].row !== args.newSelections[0].row|| controller.tree.selected && args.oldSelections[0].row === 0){
                //rechargeArea
                const recharge = controller.tree.selected.data.recharge || '';
                codeEditor.setValue(recharge);
                const erratumRecord = controller.tree.selected.data.erratumRecord || '';
                erratumRecordEditor.setValue(erratumRecord);
                //$('#exampleTextarea').val(controller.tree.selected.data.recharge);
                if(field === 'jobs'){
                    tools.clearData(sheet);
                    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 === 'designs'){
                    tools.clearData(sheet);
                    let designs = controller.tree.selected.designs;
                    setSheet.setMaxRowCount(sheet, designs);
                    if(designs.length > 0){
                        tools.orderReshowData(sheet, designs, setting, 'design', true);
                        orgDesignData = sheet.getValue(0, 0);
                    }
                    //sheetDatas = tools.getsheetDatas(sheet, 'jobs');
                }
                if(field === 'items'){
                    tools.clearData(sheet);
                    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');
                }
            }
        });
    }

    function bindPasteBills(controller, sheet, setting){
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
            sheetBillsDatas = tools.getsheetDatas(sheet, 'bills', controller);
            let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
            let maxRow = args.cellRange.row + args.cellRange.rowCount - 1;
            //复制的列数超过正确的列数，不可复制
            if(maxCol >= billsLibSetting.cols.length || maxRow >= controller.tree.items.length){
                args.cancel = true;
            }
        });
        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);
            sheet.suspendPaint();
            for(let i =orgRow, j=0; i<= maxRow; i++, j++){
                //let id = controller.tree.items[i] ? controller.tree.items[i].getID() : null;
                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].kind);
                    sheet.setValue(i, 1, sheetBillsDatas.datasIdx['rowIdx'+ i].code + '');
                    sheet.setValue(i, 2, sheetBillsDatas.datasIdx['rowIdx'+ i].name);
                    sheet.setValue(i, 3, sheetBillsDatas.datasIdx['rowIdx'+ i].unit);
                    sheet.setValue(i, 4, sheetBillsDatas.datasIdx['rowIdx'+ i].ruleText);
                    sheet.setValue(i, 5, sheetBillsDatas.datasIdx['rowIdx'+ i].engineerContent);
                    sheet.setValue(i, 6, sheetBillsDatas.datasIdx['rowIdx'+ i].unitPrice);
                    sheet.setValue(i, 7, sheetBillsDatas.datasIdx['rowIdx'+ i].unitPrice1);
                    sheet.setValue(i, 8, sheetBillsDatas.datasIdx['rowIdx'+ i].unitPrice2);
                    sheet.setValue(i, 9, sheetBillsDatas.datasIdx['rowIdx'+ i].unitPrice3);
                    sheet.setValue(i, 10, sheetBillsDatas.datasIdx['rowIdx'+ i].unitPrice4);
                    //sheet.setValue(i, 7, sheetBillsDatas.datasIdx['rowIdx'+ i].engineering);
                    sheet.setValue(i, 11, sheetBillsDatas.datasIdx['rowIdx'+ i].fixedFlag);
                    sheet.setValue(i, 12, sheetBillsDatas.datasIdx['rowIdx'+ i].landType);
                }
                else {
                    sheet.clear(i, 0, 1, sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport,GC.Spread.Sheets.StorageType.data);
                }
            }
            sheet.resumePaint();
            billsAjax.pasteBills(userAccount, billsLibId, validDatas);
            for(let vData of validDatas){
                let node  = controller.tree.nodes['id_' + vData.ID];
                if(node){
                    Object.assign(node.data, vData);
                }
            }
            sheet.setRowCount(sheetBillsDatas.datas.length);
        });
    }

    function bindBillsRangeChanged(controller, sheet, setting) {
        sheet.bind(GC.Spread.Sheets.Events.RangeChanged, function (sender, info) {
            const postData = [];
            let curRow;
            let curData;
            info.changedCells.forEach(({ row, col }) => {
                const node = controller.tree.items[row];
                // 拖动填充的时候tag也会被覆盖，重新设置
                if (col === 0 && node) {
                    sheet.setTag(row, col, node.data.ID);
                }
                if (curRow !== row) {
                    curData = { ID: node.data.ID };
                    postData.push(curData);
                }
                curRow = row;
                const field = setting.cols[col].data.field;
                let value = sheet.getValue(row, col);
                if (field === 'fixedFlag') {
                    const findData = BillsFixedFlagList.find((x) => x.name === value);
                    if (findData) {
                        value = findData.value;
                    }
                } else if (field === 'kind') {
                    const kindItem = billKindComboList.find(item => item.name === value);
                    if (kindItem) {
                        value = kindItem.value;
                    }
                }
                curData[field] = value;
            });
            billsAjax.pasteBills(userAccount, billsLibId, postData, function () {
                info.changedCells.forEach(({ row, col }) => {
                    const node = controller.tree.items[row];
                    const field = setting.cols[col].data.field;
                    let value = sheet.getValue(row, col);
                    if (field === 'fixedFlag') {
                        const findData = BillsFixedFlagList.find((x) => x.value === value);
                        if (findData) {
                        value = findData.name;
                    }
                    } else if (field === 'kind') {
                        const kindItem = billKindComboList.find(item => item.value === value);
                        if (kindItem) {
                            value = kindItem.name;
                        }
                    }
                    node.data[field] = value;
                    sheetBillsDatas.datasIdx['rowIdx' + row][field] = value;
                    sheet.setValue(row, col, node.data[field] || '');
                });
            }, function () {
                info.changedCells.forEach(({ row, col }) => {
                    const node = controller.tree.items[row];
                    const field = setting.cols[col].data.field;
                    sheet.setValue(row, col, node.data[field] || '');
                });
            });
        });
    }
    
    function bindPasteRel(sheet, controller, totalJobs, setting){
        //sheetDatas = tools.getsheetDatas(sheet, 'jobs');
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
            let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
            sheetDatas = tools.getsheetDatas(sheet, 'jobs');
            //复制的列数超过正确的列数，不可复制
            if(maxCol >= jobsSetting.cols.length){
                args.cancel = true;
            }
        });
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
            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 codeCol = 0;
                const contentCol = 1;
                for(let i=orgRow; i<=maxRow; i++){
                    //粘贴编号列，转换成粘贴内容处理
                    let code = sheet.getCell(i, codeCol).value();
                    let content = sheet.getCell(i, contentCol).value();
                    if(code && !content){
                        let contentByCode = tools.getContentByCode(totalJobs.jobsArr, code);
                        if(contentByCode){
                            pasteArr.push(contentByCode);
                        }
                    }
                    if(content){
                        pasteArr.push(content);
                    }
                }
                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(userAccount, billsLibId, 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 bindPasteDesignRel(sheet, controller, totalDesigns, setting){
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
            let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
            sheetDesignDatas = tools.getsheetDatas(sheet, 'designs');
            //复制的列数超过正确的列数，不可复制
            if(maxCol >= designsSetting.cols.length){
                args.cancel = true;
            }
        });
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
            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 codeCol = 0;
                const nameCol = 1;
                const unitCol = 2;
                for(let i=orgRow; i<=maxRow; i++){
                    //粘贴编号列，转换成粘贴内容处理
                    let code = sheet.getCell(i, codeCol).value();
                    const name = sheet.getCell(i, nameCol).value();
                    const unit = sheet.getCell(i, unitCol).value();
                    if(code && !name && !unit){
                        const matched = totalDesigns.designsArr.find(item => item.data.code == code);
                        if(matched){
                            if (!pasteArr.find(item => item.name == matched.data.name && item.unit == matched.data.unit)) {
                                pasteArr.push({ name: matched.data.name, unit: matched.data.unit });
                            }
                        }
                    }
                    if(name || unit){
                        if (!pasteArr.find(item => item.name == name && item.unit == unit)) {
                            pasteArr.push({ name, unit });
                        }
                    }
                }
                let uniqPasteArr = pasteArr;
                let serialNoUn = tools.getSerialNo(controller.tree.selected.designs) - 1;
                for(let i =orgRow, j=0; i<=uniqPasteArr.length+orgRow-1; i++, j++ ){
                    let flag = true;
                    let crossedData;
                    sheetDesignDatas.forEach(function(rowData){
                        if(rowData.rowIdx === i && (rowData.name != uniqPasteArr[j].name || rowData.unit != uniqPasteArr[j].unit)){
                            flag = false;
                            let serialNo = tools.getObj(controller.tree.selected.designs, rowData.id, 'design');
                            crossedData = {
                                orgId: rowData.id,
                                name: uniqPasteArr[j].name,
                                unit: uniqPasteArr[j].unit,
                                serialNo: serialNo.serialNo
                            };
                        }
                    });
                    if(flag){
                        serialNoUn++;
                        uncrossedDatas.push({name: uniqPasteArr[j].name, unit: uniqPasteArr[j].unit, serialNo: serialNoUn});
                    }
                    else {
                        crossedDatas.push(crossedData);
                    }
                }
                let pasteDatas = tools.encapDesignsData(uncrossedDatas, crossedDatas, controller, totalDesigns);
                if(pasteDatas.updateDatas.length > 0 || pasteDatas.createDatas.length > 0){
                    billsAjax.pasteRel(userAccount, billsLibId, pasteDatas.updateDatas, pasteDatas.createDatas, 'designs', function(datas){
                        pasteController.frontDesignsRelOperator(sheet, setting, controller, totalDesigns, datas);
                    });
                }
                else {
                    tools.orderReshowData(sheet, controller.tree.selected.designs, setting, 'design', true);
                }
            }
            else {
                tools.clearData(sheet);
            }
        });
    }

    function bindPasteItemsRel(sheet, controller, totalItems, setting){
        //sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
            let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
            sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
            //复制的列数超过正确的列数，不可复制
            if(maxCol >= itemsSetting.cols.length){
                args.cancel = true;
            }
        });
        sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
            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 codeCol = 0;
                const contentCol = 1;
                for(let i=orgRow; i<=maxRow; i++){
                    //编号列转换成内容列处理
                    let code = sheet.getCell(i, codeCol).value();
                    let content = sheet.getCell(i, contentCol).value();
                    if(code && !content){
                        let contentByCode = tools.getContentByCode(totalItems.itemsArr, code);
                        if(contentByCode){
                            pasteArr.push(contentByCode);
                        }
                    }
                    if(content){
                        pasteArr.push(content);
                    }
                }
                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){
                        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(userAccount, billsLibId, 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);
        jobsSpread.getActiveSheet().clearSelection();
        myKey.downKey(jobsSpread);
        myKey.enterKey(jobsSpread);
        TREE_SHEET_HELPER.loadSheetHeader(jobsSetting, jobsSpread.getActiveSheet());
    }

    function buildDesigns(designsSpread, setting){
        setSheet.initSheet(designsSpread, setting, true);
        designsSpread.getActiveSheet().clearSelection();
        myKey.downKey(designsSpread);
        myKey.enterKey(designsSpread);
        TREE_SHEET_HELPER.loadSheetHeader(designsSetting, designsSpread.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>