secondday.aspx.cs

天津行政许可管理中心管理系统. VISUAL STUDIO .NET 2003 ASP.NET 实现 已获得验收,投入使用

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c4\").value =\"产品质量检测机构计量考核认证\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c5:g5\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c5\").value =\"设备监理单位乙级资格证书核发\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c6:g6\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c6\").value =\"设立认证咨询机构审批\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c7:g7\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c7\").value =\"重要工业产品许可证核发\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c8:g8\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c8\").value =\"食品生产许可证核发\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c9:g9\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c9\").value =\"农药生产许可证\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c10:g10\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c10\").value =\"特殊用途产品免于强制性认证审批\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c11:g11\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c11\").value =\"棉花质量检验师执业资格注册\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c12:g12\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c12\").value =\"珠宝玉石质量检验师执业资格证书核发\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c13:g13\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c13\").value =\"建立社会公正计量行（站）审批\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c14:g14\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c14\").value =\"计量器具型式批准（样机试验）\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c15:g15\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c15\").value =\"计量标准器具核准（申请复查考核）\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c16:g16\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c16\").value =\"计量检定员资格核准\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c17:g17\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c17\").value =\"承担国家法定计量检定机构任务的授权\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c18:g18\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c18\").value =\"制造、修理计量器具许可证签发\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c19:g19\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c19\").value =\"特种设备安装改造单位资格许可\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c20:g20\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c20\").value =\"特种设备维修单位资格许可\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c21:g21\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c21\").value =\"气瓶充装站资格许可\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c22:g22\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c22\").value =\"罐车充装单位资格许可\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c23:g23\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c23\").value =\"特种设备作业人员考核\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c24:g24\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c24\").value =\"压力管道的设计、安装、使用、检验单位和人员资格认定\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c25:g25\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c25\").value =\"场（厂）内机动车辆的制造、安装、改造、维修、使用、检验许可\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c26:g26\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c26\").value =\"特种设备设计单位及设计文件许可\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c27:g27\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c27\").value =\"特种设备制造单位资格许可\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c28:g28\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c28\").value =\"特种设备检验检测单位资格许可\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c29:g29\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c29\").value =\"特种设备检验检测人员考核\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c30:g30\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c30\").value =\"特种设备制造安装改造维修监督及定期检验\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c31:g31\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c31\").value =\"特种设备使用登记\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c32:g32\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c32\").value =\"棉花收购加工单位质量保证能力资格认定（联审）\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c33:g33\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c33\").value =\"国储棉出入库强制性公证检验\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c34:g34\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c34\").value =\"棉花质量公证检验\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c35:g35\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c35\").value =\"组织机构代码核发\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c36:g36\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c36\").value =\"联审合计\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c37:g37\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c37\").value =\"单审合计\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c38:g38\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c38\").value =\"中心办理合计\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c39:g39\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c39\").value =\"计量器具检定（未进中心事项）\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c40:g40\").merge\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c40\").value =\"总计\"\n");

				s.Append("Spreadsheet1.ActiveSheet.Range(\"c3:c23\").font.size=12\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c24\").font.size=10\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c25\").font.size=8\n");
				s.Append("Spreadsheet1.ActiveSheet.Range(\"c26:c40\").font.size=12\n");
				s.Append("Spreadsheet1.Range(\"A1:k40\").Borders.Weight = Spreadsheet1.Constants.owcLineWeightMedium \n");


				
				for(int j=1;j<dt.Columns.Count;j++)
				{  
					int nSum=0;
					for(int i=0;i<dt.Rows.Count;i++)
					{
						int row=i+3;
						int col=j+7;
						
						
						s.Append("Spreadsheet1.ActiveSheet.Cells("+row+","+col+").Value="+"\""+dt.Rows[i][j]+"\""+"\n");
						
//						
						
						if(dt.Rows[i][j].ToString()!="")
//						{
							nSum+=Convert.ToInt32(dt.Rows[i][j]);
//							nRowSum[i]+=Convert.ToInt32(dt.Rows[i][j]);
//						}
						
					}
					s.Append("Spreadsheet1.ActiveSheet.Cells("+40+","+(j+7)+").Value="+"\""+nSum+"\""+"\n");
//					nRowSum[3]+=nSum;
				}

				
				s.Append("End Sub\n");
				s.Append("</script>\n");
				dv.InnerHtml=s.ToString();
			}
		}
        

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}