野间あんな女主播:dbnetgrid学习笔记

来源：百度文库编辑：偶看新闻时间：2024/05/01 08:38:58

dbnetgrid学习笔记--grid中一条记录下面包含N条子记录且以grid形式显示

www.diybl.com 时间： 2007-11-29 作者：佚名编辑：本站点击： 181 [ 评论 ]

页面如下：

代码如下：
window.onload = init
var filterjyd = false
var filterjyrq = false
var tradelx
function init()
{
with(document.all.dbnettab_master)
{
   tabs = [
   ["tab_jyd","交易数据列表(按交易单)","dbnetgrid_jyd",""],
   ["tab_jyrq","交易数据列表(按执行日期)","dbnetgrid_jyrq",""]
   ]
   onPageLoaded = initgrid

   setTabProperty("tab_jyd","onshow:jydonshow")
   setTabProperty("tab_jyrq","onshow:jyrqonshow")
   loadTab()
}
}
function jydonshow()
{
tabflag = "jyd"
if(!filterjyd)
  filterFun()

filterjyd = true

}
function jyrqonshow()
{
tabflag = "jyrq"
if(!filterjyrq)
  filterFun()

filterjyrq = true

}
function initgrid()
{
with(document.all.dbnetgrid_jyd)
{
  connectionString = "jdbc/LiferayPool"
  fromPart = "v_jydata_jyd"
  primaryKeyColumn = "c_jydbh"
  orderColumn = "c_jydbh"
  orderSequence = "desc"
  pageSize = 20
  integration = "true"
  var data = document.all.dbnetgrid_jyrq.selectData("select property_name from property_code where property_code = ''"+gs_tradelx+"'' and type_name = ''交易类型配置''")
  tradelx = data.property_name
  if(tradelx == ''年度'' || tradelx == ''短期'')
  {
   selectPart = ["jymonth","c_jhbh","c_jydbh","c_sddw","c_gddw","n_dl/10 dl","n_jydl","jhjydl"]
   headings = ["月份","交易中心交易单编号","调度中心交易单编号","卖方","买方","平均电力","交易电量","计划值"]
  }
  else
  {
   selectPart = ["jymonth","c_jydbh","c_sddw","c_gddw","n_dl/10 dl","n_jydl"]
   headings = ["月份","交易单编号","卖方","买方","平均电力","交易电量"]
  }
  dataOnlyColumns = ["c_jydbh"]
  insertRow = false
  updateRow = false
  deleteRow = false
  rowDblClick = false
  filter = false
  addNestedGrid(configureDetailNestedGrid, "dested_fun" )
  onPageLoaded = masterGridLoaded
}
with(document.all.dbnetgrid_jyrq)
{
  connectionString = "jdbc/LiferayPool"
  fromPart = "jy_tradedata"
  primaryKeyColumn = "c_bh"
  orderColumn = "d_jyrq"
  orderSequence = "desc"
  pageSize = 20
  integration = "true"

  if(tradelx == ''一类'' || tradelx == ''二类'')
  {
   selectPart = ["d_jyrq","c_sddw","c_gddw","c_jysd","n_jyxs","n_dl/10 dl","n_jydl","n_wgjg","n_wsjg","c_jydbh"]
   headings = ["执行日期","卖方","买方","时段","小时数","电力","交易电量","网购价","网售价","交易单"]
   setColumnProperty("n_jyxs","transform:jyxstrans")
  }
  else
  {
   selectPart = ["d_jyrq","c_sddw","c_gddw","n_dl/10 dl","n_jydl","n_wgjg","n_wsjg","c_jydbh"]
   headings = ["执行日期","卖方","买方","电力","交易电量","网购价","网售价","交易单"]
  }

  insertRow = false
  updateRow = false
  deleteRow = false
  rowDblClick = false
  filter = false
  onPageLoaded = masterGridLoaded
}
custompagetoolbar()
inityearmonth()
}
function configureDetailNestedGrid()
{
with(window.event.srcElement.childGrid)
  {
   connectionString = "jdbc/LiferayPool"
   fromPart = "jy_tradedata"
   primaryKeyColumn = "c_bh"
   orderColumn = "d_jyrq"
   orderSequence = "desc"
   pageSize = 31
   integration = "true"
   displayNavibar = false
   if(tradelx == ''一类'' || tradelx == ''二类'')
   {
    selectPart = ["d_jyrq","c_jysd","n_jyxs","n_wgjg","n_wsjg","n_dl/10 dl","n_jydl"]
    headings = ["执行日期","时段","小时数","网购价","网售价","电力","交易电量"]
    setColumnProperty("n_jyxs","transform:jyxstrans")
   }
   else
   {
    selectPart = ["d_jyrq","n_wgjg","n_wsjg","n_dl/10 dl","n_jydl"]
    headings = ["执行日期","网购价","网售价","电力","交易电量"]
   }
   insertRow = false
   updateRow = false
   deleteRow = false

   rowDblClick = false

   filter = false
   loadData()
  }
}
function custompagetoolbar()
{
with(document.all.dbnetgrid_jyd)
{
   pagetoolbar.all.flowSendBtn.parentElement.style.display="none"
   pagetoolbar.all.functionlist.parentElement.style.display="none"
     var cell = pagetoolbar.all.toolbar.rows[0].insertCell()
    cell.innerHTML = "年月:"+
        " " +
        " "

    addPagetoolbarBtn("okButton", "确定", "okFun")
  addPagetoolbarDivider()
  addPagetoolbarBtn("reportButton", tradelx+"交易汇总报表", "reportFun")
  addPagetoolbarDivider()

}
}
function jyxstrans(cell)
{
if(cell.innerText != "")
{
  var sec = parseFloat(cell.innerText) * 60
  var sec = sec % parseInt(60)

  var arr = new Array()
  arr = cell.innerText.split(''.'')
  if (sec != 0)
  {
   cell.innerText = arr[0]+''小时''+sec+''分''
  }
  else
  {
   cell.innerText = arr[0]+''小时''
  }
}
}
function inityearmonth()
{
for (i = parseInt(gs_year) -5; i<= parseInt(gs_year);i++)
{
   var oOption = document.createElement("OPTION");
   oOption.text = i + ''年'';
   oOption.value = i;
   document.all.year.add(oOption)
   if(i == gs_year)
   {
    oOption.selected = true
   }
}

for (i = 1;i<= 12; i++)
{
  var oOption = document.createElement("OPTION");
  oOption.text = i + ''月'';
  oOption.value = i;
  document.all.month.add(oOption);
  if(i == gs_month)
  {
   oOption.selected = true
  }
}
}
function reportFun()
{

with(document.all.dbnetcell0) {
  code = ''powerTrade''
  report_no = ''trade_report''
  lsh = ''''
  readOnly = true
  reportArgs = new Object()
  onReportOpened = "reportOpened"
}
var lsh = document.all.dbnetcell0.open()
}
function reportOpened(CellWeb)
{
var grid = document.all.dbnetgrid_jyrq
var year = document.all.year.value
var month = document.all.month.value
var sj = year + ''年'' + month + ''月''
if(parseInt(month) < 10)
  month = ''0'' + month
var trademonth = year + ''.'' + month
tradedatareport(grid,CellWeb,tradelx,trademonth,sj)
}
function okFun()
{
if(tabflag == "jyd")
{
  filterjyd = true
  filterjyrq = false
}
if(tabflag == "jyrq")
{
  filterjyrq = true
  filterjyd = false
}
filterFun()
}
function filterFun()
{
var year = document.all.year.value
var month = document.all.month.value
if(parseInt(month)<10)
{
   month = ''0'' + month
}
var sj = year + ''.'' + month
var grid
if(tabflag == "jyd")
{
  grid = document.all.dbnetgrid_jyd
  grid.fixedFilterPart = "jymonth = ''"+sj+"'' and c_lx = ''"+tradelx+"''"
}
else
{
  grid = document.all.dbnetgrid_jyrq
  grid.fixedFilterPart = "to_char(d_jyrq,''yyyy.mm'') = ''"+sj+"'' and c_lx = ''"+tradelx+"''"
}
grid.loadData()
}
function dested_fun(grid)
{
var jydbh = grid.parentRow.c_jydbh
filter = "c_jydbh = ''"+jydbh+"''"
grid.fixedFilterPart = filter
}
function masterGridLoaded()
{
var grid
if(tabflag == "jyrq")
  grid = document.all.dbnetgrid_jyrq
else
  grid = document.all.dbnetgrid_jyd
if(grid.rowCount > 0)
{
   var table = grid.table
   var row = table.insertRow()
   for (var i=0; i< table.rows[1].cells.length; i++){
    row.insertCell()
   }
   var year = document.all.year.value
   var month = document.all.month.value

   if(parseInt(month)<10)
   {
     month = ''0'' + month
   }
   var sj = year + ''.'' + month
   var s_where
   if(grid.filterPart != '''')
    s_where = grid.fixedFilterPart + '' and '' + grid.filterPart
   else
    s_where = grid.fixedFilterPart
   if(tabflag == "jyrq")
   var data = grid.selectData("select sum(nvl(n_jydl,0)) as jydl from jy_tradedata where "+s_where)
   else
   var data = grid.selectData("select sum(nvl(n_jydl,0)) as jydl from v_jydata_jyd where "+s_where)
   row.style.color = ''black''
   //row.style.backgroundColor = ''lightblue''
   row.style.fontSize = ''8pt''
   row.style.fontWeight = ''bold''
   row.style.align = "right"
   row.cells[1].innerText = ''合计''
   row.cells[grid.columnIndex(''n_jydl'')].innerText = data.jydl

}

}

如何做学习笔记司法鉴定学习笔记范文学习型班组学习笔记查找先进性教育的学习笔记牛津9A学习笔记 PRO-E的学习笔记怎么写团章学习笔记？求一学习笔记软件哪里有英语学习笔记？ PRO-E的学习笔记高中怎样做学习笔记求中级物流师的学习笔记有机化学学习笔记这本书有吗？有学习好笔记写得好的重点高中学生我要买高二高三的英语课堂笔记党员开展先进性教育的学习笔记及心得的网址 Internet IntraWeb开发学习笔记（三）b.htm 哪里有PowerPoint格式的学习笔记下载? 用于学习笔记/反思日记的管理有那些？关于学习实践"三个代表"重要思想,增强团员意识的学习笔记谁知道C语言的学习笔记,和C语言的学习软件哪儿可以下载剑桥商务英语?有课堂笔记或相关的学习资料更好求教海明码和CRC循环冗余校验码的原理或课件下载或学习笔记？？想要自考<<汉语言文学>>专业专科的学习笔记和考试题. 高中学习方法讨论:笔记参考书调和与学习法阴阳调和