第207页,共226页。 显示 2,251 条结果 (0.065 秒)
添加新行自动为单元格赋值.xml
[function main(spreadsheetReport, editingCellPosition) { var row = editingCellPosition.row;//行 var col = editingCellPosition.column;//列 //执行sql,获取序号 … } } /** * 执行SQL语句,获取结果集 */ function getSqlResult() { var util = jsloader.resolve("freequery.common.util"); var ret = util.remoteInvoke天阳migrate.xml
","dropWidth":"175","dropHeight":"200","noNull":false,"noTitle":false,"combinPara":true,"mdxUseQuotationMark":true}" componenttype="COMBOBOX" defaulttype="SQL … " isPublic="true" manual="true" multSelect="false" name="上级" roottype="SQL" rootvalue="" standbytype="SQL" standbyvalue=" select distinct表单报表.xml
<?xml version="1.0" encoding="UTF-8"?><migrates version="1.0" tag="Branch_SmartbiV10_5_20220219" buildTime="20220224144226"><SPREADSHEET_REPORT path="PUBLIC_ANALYSIS/3 wiki电子表格示例库/表格结构分类/" path2="分析报表/4 wiki电子表格示例库/表格结构分类/" type="SPREADSHEET_REPORT" id="I8a8aee97017efcfefcfe016d017f004c1f310907" name="求职申请表" alias="表单报表单报表.xml
<?xml version="1.0" encoding="UTF-8"?><migrates version="1.0" tag="Branch_SmartbiV10_5_20220219" buildTime="20220224144226"><SPREADSHEET_REPORT path="PUBLIC_ANALYSIS/3 wiki电子表格示例库/表格结构分类/" path2="分析报表/4 wiki电子表格示例库/表格结构分类/" type="SPREADSHEET_REPORT" id="I8a8aee97017efcfefcfe016d017f004c1f310907" name="求职申请表" alias="表单报migrate.xml
":true,"mdxUseQuotationMark":true}" componenttype="COMBOBOX" defaulttype="SQL" defaultvalue="select distinct shipregion from orders limit 1" desc="" display="true" id="OutputParameter.I4028818a2578cab101524427dd6d192d.销售区域_单选" isPublic="true" manual="false" multSelect="false" name="销售区域_单选" roottype="SQL" rootvaluemigrate.xml
":true,"mdxUseQuotationMark":true}" componenttype="COMBOBOX" defaulttype="SQL" defaultvalue="select distinct shipregion from orders limit 1" desc="" display="true" id="OutputParameter.I4028818a2578cab101524427dd6d192d.销售区域_单选" isPublic="true" manual="false" multSelect="false" name="销售区域_单选" roottype="SQL" rootvaluemigrate.xml
col = editingCellPosition.column; //执行sql,获取序号 var newIdValue = getSqlResult(); //为新增的一行序号单元格赋值 spreadsheetReport.spreadsheetReportWriteBack.setWriteBackCellData(row + 1, col + 0, newIdValue, newIdValue); }; /** * 执行SQL语句,获取结果集 */ function getSqlResult() { var util = jsloader.resolvemigrate.xml
col = editingCellPosition.column; //执行sql,获取序号 var newIdValue = getSqlResult(); //为新增的一行序号单元格赋值 spreadsheetReport.spreadsheetReportWriteBack.setWriteBackCellData(row + 1, col + 0, newIdValue, newIdValue); }; /** * 执行SQL语句,获取结果集 */ function getSqlResult() { var util = jsloader.resolvemigrate (23).xml
="COMBOBOX" defaulttype="SQL" defaultvalue="" desc="" display="true" id="OutputParameter.I8a8af0a60172c1a9c1a9864e0172c215d0bf02eb.产品类别" isPublic="true" manual="false" multSelect="false" name="产品类别" roottype="SQL" rootvalue="" standbytype="CONSTLIST" standbyvalue="[["饮料","饮料"],["调味品","调味品"],["点心","点心"],["日用品","日用品"],["谷类/麦片migrate (24).xml
="SQL" defaultvalue="" desc="" display="true" id="OutputParameter.I8a8af0a60172c1a9c1a9864e0172c215d0bf02eb.产品类别" isPublic="true" manual="false" multSelect="false" name="产品类别" roottype="SQL" rootvalue="" standbytype="CONSTLIST" standbyvalue="[["饮料","饮料"],["调味品","调味品"],["点心","点心"],["日用品","日用品"],["谷类/麦片","谷类/麦片"],["肉/家禽