web前端|html教程
议：如何将树形菜单形式的数据转化成HTML的二维表（相同内容需合并单元格）
web前端-html教程
一般做OA类管理系统，经常涉及到“组织架构”的概念，那么像这种有上下层级关系的数据一般会做成树形菜单的方式显示，底层代码必定会用到递归算法。这篇随笔的目的就是要谈谈除了用树形菜单来显示这种上下层级关系的数据，还有其他的显示方式吗？答案是有的，例如即将要谈到的二维表显示方式，同时也是本随笔的核心内容。
diy装机 源码 php,vscode go运行不,ubuntu 安装vld,tomcat 跑不起来,cdn爬虫,php 文件插入,网页如何编辑seo标题,简单的css网站模板下载,b2b店铺模板lzw
首先来看二维表的显示效果图：
canvas 如何保存源码,vscode九九乘法表代码,ubuntu进入根目录,tomcat 9中文请求,sqlite 分组排序,手机网页设计教程,租美国服务器,企业客服插件,前端控件拖拉框架,爬虫课程表,php设置session过期时间,seo优化是干什么的,狠很橹源网站,网页响应式特效,cms系统模板ui,html div随页面滚动,商机管理系统 开源,小偷程序破解lzw
如果看到这里，你觉得这就是你想要的显示效果，或者对此比较感兴趣。请接着往下看的实现步骤：
刷单神器 带源码,魅族ubuntu包,tomcat增加访问黑名单,爬虫人和天狼星人,php入门教程讲解学习,叶勇seolzw
1.取出所有的数据临时保存到DataTable中,即内存中,拼html时直接查DataTable中的数据,不用去反复读取数据库,提高效率；
2.根据节点编号获取该节点下所有的末端子节点编号,因为末端子节点的个数就决定了
";104}105 106private string RecursionEndKpiNo(DataTable dt, object parentId)107{108 StringBuilder sbJson = new StringBuilder();109 110 DataRow[] rows = dt.Select(string.Format("KpiParentNo = \" + parentId + "\"));111 if (rows.Length > 0)112 {113 foreach (DataRow row in rows)114 {115 string str = RecursionEndKpiNo(dt, row["kpino"]);116 sbJson.Append("" + row["kpino"] + "," + str);117 }118 }119 return sbJson.ToString();120}121private bool IsChild(DataTable dt, string parentId)122{123 DataRow[] rows = dt.Select(string.Format("KpiParentNo = \" + parentId + "\"));124 if (rows.Length > 0)125 {126 return true;127 }128 else129 {130 return false;131 }132}133 134private string Recursion(DataTable dt, object parentId)135{136 StringBuilder sbJson = new StringBuilder();137 138 DataRow[] rows = dt.Select("kpino = \" + parentId + "\");139 if (rows.Length > 0)140 {141 if (rows[0]["KpiParentNo"].ToString() == "0" || rows[0]["KpiParentNo"].ToString() == "")142 {143 sbJson.Append("0,");144 }145 else146 {147 sbJson.Append(Recursion(dt, rows[0]["KpiParentNo"]));148 }149 }150 sbJson.Append(parentId.ToString() + ",");151 return sbJson.ToString();152}153private int GetMaxCount(DataRow[] drArray)154{155 int temp = 0;156 foreach (DataRow row in drArray)157 {158 int count = row["kpino"].ToString().Trim(,).Split(,).Length;159 if (count > temp)160 {161 temp = count;162 }163 }164 return temp;165}166private bool EqualUpColumnValue(int rowIndex, int colIndex, DataRow[] drArray)167{168 if (rowIndex == 0)169 {170 return false;171 }172 173 string[] kpinoArray = drArray[rowIndex - 1]["kpino"].ToString().Trim(,).Split(,);174 if (kpinoArray.Length > colIndex)175 {176 string upColumnValue = drArray[rowIndex]["kpino"].ToString().Trim(,).Split(,)[colIndex];177 if (upColumnValue == kpinoArray[colIndex])178 {179 return true;180 }181 else182 {183 return false;184 }185 }186 else187 {188 return false;189 }190}191private int GetColspan(int rowIndex, int colIndex, DataRow[] drArray)192{193 int colspan = 1;194 string[] kpinoArray = drArray[rowIndex]["kpino"].ToString().Trim(,).Split(,);195 196 while (rowIndex colIndex)200 {201 if (kpinoArray[colIndex] == kpinoArray2[colIndex])202 {203colspan++;204 }205 else206 {207break;208 }209 }210 else211 {212 break;213 }214 rowIndex++;215 }216 return colspan;217}218private double GetKpiWeight(DataTable dt, string kpino)219{220 double kpiWeight = 0;221 var drArray = dt.Select("kpino=\" + kpino + "\");222 if (drArray.Length > 0)223 {224 string kpiParentNo = drArray[0]["KpiParentNo"].ToString();225 double kpino_KpiWeight = Convert.ToDouble(drArray[0]["KpiWeight"]);226 drArray = dt.Select("KpiParentNo=\" + kpiParentNo + "\");227 if (drArray.Length > 0)228 {229 double result = 0;230 foreach (DataRow row in drArray)231 {232result += Convert.ToDouble(row["KpiWeight"]);233 }234 kpiWeight = (kpino_KpiWeight / result);235 }236 }237 return kpiWeight;238}239private double GetKpiValue(DataTable dt, string kpino)240{241 var drArray = dt.Select(string.Format("kpino={0}\",kpino));242 if (drArray.Length>0)243 {244 return Convert.ToDouble(drArray[0]["KpiValue1"]);245 }246 return 0;247}248private string GetKpiDes(DataTable dt, string kpino)249{250 string des = string.Empty;251 var drArray = dt.Select(string.Format("kpino={0}\",kpino));252 if (drArray.Length>0)253 {254 string KpiMethod = drArray[0]["KpiMethod"].ToString();255 string KpiSampleType = drArray[0]["KpiSampleType"].ToString();256 string KpiRule = drArray[0]["KpiRule"].ToString();257 string KpiCriterion = drArray[0]["KpiCriterion"].ToString();258 string KpiAreaRule = drArray[0]["KpiAreaRule"].ToString();259 string KpiSampleRule = drArray[0]["KpiSampleRule"].ToString();260 261 //表格样式262 if (!string.IsNullOrEmpty(KpiMethod))263 {264 //des += "";272 }273274 //换行样式275 //if (!string.IsNullOrEmpty(KpiMethod)) { des += "
计算方法:" + KpiMethod; }276 //if (!string.IsNullOrEmpty(KpiSampleType)) { des += "
采样类别:" + KpiSampleType; }277 //if (!string.IsNullOrEmpty(KpiRule)) { des += "
评价标准:" + KpiRule; }278 //if (!string.IsNullOrEmpty(KpiCriterion)) { des += "
规范要点:" + KpiCriterion; }279 //if (!string.IsNullOrEmpty(KpiAreaRule)) { des += "
测区规则:" + KpiAreaRule; }280 //if (!string.IsNullOrEmpty(KpiSampleRule)) { des += "
测点规则:" + KpiSampleRule; } 281 }282 return des;283}284 285 286 287288 }
以及需要用到的表（sql脚本）：
1 USE [Evaluation] 2 GO 3 /****** Object: Table [dbo].[Kpi] Script Date: /3/25 16:06:04 ******/ 4 SET ANSI_NULLS ON 5 GO 6 SET QUOTED_IDENTIFIER ON 7 GO 8 CREATE TABLE [dbo].[Kpi]( 9[KpiNo] [nvarchar](50) NOT NULL, 10[KpiName] [nvarchar](50) NULL, 11[KpiInfo] [nvarchar](100) NULL, 12[KpiParentNo] [nvarchar](50) NULL, 13[KpiMethod] [nvarchar](50) NULL, 14[KpiWeight] [decimal](18, 2) NULL, 15[KpiRule] [nvarchar](100) NULL, 16[KpiCriterion] [nvarchar](100) NULL, 17[KpiAreaRule] [nvarchar](100) NULL, 18[KpiSampleRule] [nvarchar](100) NULL, 19[KpiAreaNum] [int] NOT NULL, 20[KpiSampleNum] [int] NOT NULL, 21[KpiMinValue] [decimal](18, 2) NULL, 22[KpiMaxValue] [decimal](18, 2) NULL, 23[KpiOffset] [decimal](18, 2) NULL, 24[KpiReferenceVal] [decimal](18, 2) NULL, 25[KpiValueType] [nvarchar](50) NULL, 26[KpiFormula] [nvarchar](50) NULL, 27[KpiFormulaRule] [nvarchar](100) NULL, 28[KpiMemo] [nvarchar](100) NULL, 29[KpiGoodMinValue] [decimal](18, 2) NULL, 30[KpiGoodMaxValue] [decimal](18, 2) NULL, 31[KpiGoodMethod] [nvarchar](50) NULL, 32[KpiGoodOffset] [decimal](18, 2) NULL, 33[KpiSampleType] [nvarchar](50) NULL, 34[IsDLT] [smallint] NULL, 35[CrtDate] [datetime] NULL, 36[CrtUser] [nvarchar](50) NULL, 37[UpdDate] [datetime] NULL, 38[UpdUser] [nvarchar](50) NULL, 39 CONSTRAINT [PK_EVKpiInfo] PRIMARY KEY CLUSTERED 40 ( 41[KpiNo] ASC 42 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 43 ) ON [PRIMARY] 44 45 GO 46 /****** Object: Table [dbo].[kpi1447055501128] Script Date: /3/25 16:06:04 ******/ 47 SET ANSI_NULLS ON 48 GO 49 SET QUOTED_IDENTIFIER ON 50 GO 51 CREATE TABLE [dbo].[kpi1447055501128]( 52[KpiNo] [nvarchar](50) NOT NULL, 53[KpiName] [nvarchar](50) NULL, 54[KpiInfo] [nvarchar](100) NULL, 55[KpiParentNo] [nvarchar](50) NULL, 56[KpiMethod] [nvarchar](50) NULL, 57[KpiWeight] [decimal](18, 2) NULL, 58[KpiRule] [nvarchar](100) NULL, 59[KpiCriterion] [nvarchar](100) NULL, 60[KpiAreaRule] [nvarchar](100) NULL, 61[KpiSampleRule] [nvarchar](100) NULL, 62[KpiAreaNum] [int] NOT NULL, 63[KpiSampleNum] [int] NOT NULL, 64[KpiMinValue] [decimal](18, 2) NULL, 65[KpiMaxValue] [decimal](18, 2) NULL, 66[KpiOffset] [decimal](18, 2) NULL, 67[KpiReferenceVal] [decimal](18, 2) NULL, 68[KpiValueType] [nvarchar](50) NULL, 69[KpiFormula] [nvarchar](50) NULL, 70[KpiFormulaRule] [nvarchar](100) NULL, 71[KpiMemo] [nvarchar](100) NULL, 72[KpiGoodMinValue] [decimal](18, 2) NULL, 73[KpiGoodMaxValue] [decimal](18, 2) NULL, 74[KpiGoodMethod] [nvarchar](50) NULL, 75[KpiGoodOffset] [decimal](18, 2) NULL, 76[KpiSampleType] [nvarchar](50) NULL 77 ) ON [PRIMARY] 78 79 GO 80 /****** Object: Table [dbo].[kpi0002] Script Date: /3/25 16:06:04 ******/ 81 SET ANSI_NULLS ON 82 GO 83 SET QUOTED_IDENTIFIER ON 84 GO 85 CREATE TABLE [dbo].[kpi0002]( 86[KpiNo] [nvarchar](50) NOT NULL, 87[KpiName] [nvarchar](50) NULL, 88[KpiInfo] [nvarchar](100) NULL, 89[KpiParentNo] [nvarchar](50) NULL, 90[KpiMethod] [nvarchar](50) NULL, 91[KpiWeight] [decimal](18, 2) NULL, 92[KpiRule] [nvarchar](100) NULL, 93[KpiCriterion] [nvarchar](100) NULL, 94[KpiAreaRule] [nvarchar](100) NULL, 95[KpiSampleRule] [nvarchar](100) NULL, 96[KpiAreaNum] [int] NOT NULL, 97[KpiSampleNum] [int] NOT NULL, 98[KpiMinValue] [decimal](18, 2) NULL, 99[KpiMaxValue] [decimal](18, 2) NULL,100[KpiOffset] [decimal](18, 2) NULL,101[KpiReferenceVal] [decimal](18, 2) NULL,102[KpiValueType] [nvarchar](50) NULL,103[KpiFormula] [nvarchar](50) NULL,104[KpiFormulaRule] [nvarchar](100) NULL,105[KpiMemo] [nvarchar](100) NULL,106[KpiGoodMinValue] [decimal](18, 2) NULL,107[KpiGoodMaxValue] [decimal](18, 2) NULL,108[KpiGoodMethod] [nvarchar](50) NULL,109[KpiGoodOffset] [decimal](18, 2) NULL,110[KpiSampleType] [nvarchar](50) NULL111 ) ON [PRIMARY]112 113 GO114 /****** Object: Table [dbo].[KpiTree] Script Date: /3/25 16:06:04 ******/115 SET ANSI_NULLS ON116 GO117 SET QUOTED_IDENTIFIER ON118 GO119 CREATE TABLE [dbo].[KpiTree](120[KpiNo] [nvarchar](50) NOT NULL,121[KpiName] [nvarchar](50) NULL,122[KpiInfo] [nvarchar](50) NULL,123[KpiParentNo] [nvarchar](50) NULL,124[KpiCollectMethod] [nvarchar](50) NULL,125[KpiWeight] [decimal](18, 2) NULL,126[KpiMemo] [nvarchar](100) NULL,127[KpiIndex] [int] NULL,128[IsDLT] [smallint] NULL,129[CrtDate] [datetime] NULL,130[CrtUser] [nvarchar](50) NULL,131[UpdDate] [datetime] NULL,132[UpdUser] [nvarchar](50) NULL,133 CONSTRAINT [PK_KpiTree] PRIMARY KEY CLUSTERED 134 (135[KpiNo] ASC136 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]137 ) ON [PRIMARY]138 139 GO140 /****** Object: Table [dbo].[kpitree1447055501128] Script Date: /3/25 16:06:04 ******/141 SET ANSI_NULLS ON142 GO143 SET QUOTED_IDENTIFIER ON144 GO145 CREATE TABLE [dbo].[kpitree1447055501128](146[KpiNo] [nvarchar](50) NOT NULL,147[KpiName] [nvarchar](50) NULL,148[KpiInfo] [nvarchar](50) NULL,149[KpiParentNo] [nvarchar](50) NULL,150[KpiCollectMethod] [nvarchar](50) NULL,151[KpiWeight] [decimal](18, 2) NULL,152[KpiMemo] [nvarchar](100) NULL,153[KpiIndex] [int] NULL154 ) ON [PRIMARY]155 156 GO157 /****** Object: Table [dbo].[KpiTree0002] Script Date: /3/25 16:06:04 ******/158 SET ANSI_NULLS ON159 GO160 SET QUOTED_IDENTIFIER ON161 GO162 CREATE TABLE [dbo].[KpiTree0002](163[KpiNo] [nvarchar](50) NOT NULL,164[KpiName] [nvarchar](50) NULL,165[KpiInfo] [nvarchar](50) NULL,166[KpiParentNo] [nvarchar](50) NULL,167[KpiCollectMethod] [nvarchar](50) NULL,168[KpiWeight] [decimal](18, 2) NULL,169[KpiMemo] [nvarchar](100) NULL,170[KpiIndex] [int] NULL171 ) ON [PRIMARY]172 173 GO174 /****** Object: Table [dbo].[KpiValue] Script Date: /3/25 16:06:04 ******/175 SET ANSI_NULLS ON176 GO177 SET QUOTED_IDENTIFIER ON178 GO179 CREATE TABLE [dbo].[KpiValue](180[TenderNo] [nvarchar](50) NOT NULL,181[KpiNo] [nvarchar](50) NOT NULL,182[KpiValue1] [decimal](18, 2) NULL,183[KpiValue2] [decimal](18, 2) NULL,184[SampleNumAll] [int] NULL,185[SampleNum1] [int] NULL,186[SampleNum2] [int] NULL187 ) ON [PRIMARY]188 189 GO190 /****** Object: Table [dbo].[KpiValue1447055501128] Script Date: /3/25 16:06:04 ******/191 SET ANSI_NULLS ON192 GO193 SET QUOTED_IDENTIFIER ON194 GO195 CREATE TABLE [dbo].[KpiValue1447055501128](196[TenderNo] [nvarchar](50) NOT NULL,197[KpiNo] [nvarchar](50) NOT NULL,198[KpiValue1] [decimal](18, 2) NULL,199[KpiValue2] [decimal](18, 2) NULL,200[SampleNumAll] [int] NULL,201[SampleNum1] [int] NULL,202[SampleNum2] [int] NULL203 ) ON [PRIMARY]204 205 GO206 /****** Object: Table [dbo].[KpiValue0002] Script Date: /3/25 16:06:04 ******/207 SET ANSI_NULLS ON208 GO209 SET QUOTED_IDENTIFIER ON210 GO211 CREATE TABLE [dbo].[KpiValue0002](212[TenderNo] [nvarchar](50) NOT NULL,213[KpiNo] [nvarchar](50) NOT NULL,214[KpiValue1] [decimal](18, 2) NULL,215[KpiValue2] [decimal](18, 2) NULL,216[SampleNumAll] [int] NULL,217[SampleNum1] [int] NULL,218[SampleNum2] [int] NULL219 ) ON [PRIMARY]220 221 GO222 ALTER TABLE [dbo].[Kpi] ADD CONSTRAINT [DF_Kpi_KpiWeight] DEFAULT ((1)) FOR [KpiWeight]223 GO224 ALTER TABLE [dbo].[Kpi] ADD CONSTRAINT [DF_Kpi_KpiAreaNum] DEFAULT ((2)) FOR [KpiAreaNum]225 GO226 ALTER TABLE [dbo].[Kpi] ADD CONSTRAINT [DF_Kpi_KpiSampleNum] DEFAULT ((10)) FOR [KpiSampleNum]227 GO228 ALTER TABLE [dbo].[Kpi] ADD CONSTRAINT [DF_Kpi_IsDLT] DEFAULT ((0)) FOR [IsDLT]229 GO230 ALTER TABLE [dbo].[kpi0002] ADD CONSTRAINT [DF_kpi0002_KpiWeight] DEFAULT ((1)) FOR [KpiWeight]231 GO232 ALTER TABLE [dbo].[KpiTree] ADD CONSTRAINT [DF_KpiTree_KpiWeight] DEFAULT ((1)) FOR [KpiWeight]233 GO234 ALTER TABLE [dbo].[KpiTree] ADD CONSTRAINT [DF_KpiTree_IsDLT] DEFAULT ((0)) FOR [IsDLT]235 GO236 ALTER TABLE [dbo].[KpiTree0002] ADD CONSTRAINT [DF_KpiTree0002_KpiWeight] DEFAULT ((1)) FOR [KpiWeight]237 GO238 EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N指标编号 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NKpi, @level2type=NCOLUMN,@level2name=NKpiNo239 GO240 EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N指标名称 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NKpi, @level2type=NCOLUMN,@level2name=NKpiName241 GO242 EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N上级指标编号 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NKpi, @level2type=NCOLUMN,@level2name=NKpiParentNo243 GO244 EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N权重 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NKpi, @level2type=NCOLUMN,@level2name=NKpiWeight245 GO246 EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N上级指标编号 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NKpi, @level2type=NCOLUMN,@level2name=NKpiRule247 GO248 EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N权重 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NKpi, @level2type=NCOLUMN,@level2name=NKpiCriterion249 GO250 EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N指标配置表 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NKpi251 GO
