content.aspx.cs

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

				{
					int row=i+4;
					int col=j+11;
					s.Append("Spreadsheet1.ActiveSheet.Cells("+row+","+col+").Value="+"\""+dt2.Rows[i][j]+"\""+"\n");
					if(dt2.Rows[i][j].ToString()!="")
					{
						nSum+=Convert.ToInt32(dt2.Rows[i][j]);
						nRowSum[i]+=Convert.ToInt32(dt2.Rows[i][j]);
					}
						
				}
				s.Append("Spreadsheet1.ActiveSheet.Cells("+7+","+(j+11)+").Value="+"\""+nSum+"\""+"\n");
				nRowSum[3]+=nSum;
			}
			for(int i=0;i<4;i++)
			{
				
				s.Append("Spreadsheet1.ActiveSheet.Cells("+(i+4)+","+16+").Value="+"\""+nRowSum[i]+"\""+"\n");

			}
				
			s.Append("End Sub\n");
			s.Append("</script>\n");
			dv.InnerHtml=s.ToString();
		}
	
		private void SinglesortedSum(DateTime tGivenDate)
		{
			BusinessDAL myBusiness=new BusinessDAL();
			DataTable dt=myBusiness.secondday(Convert.ToDateTime(tGivenDate));
			//			DataTable dt=myBusiness.seconddayrange(Convert.ToDateTime(tGivenDateTime),Convert.ToDateTime(tEndDate));
			
				
				
			StringBuilder s=new StringBuilder();
			s.Append("<script language=vbscript>\n");
			s.Append("Sub Window_OnLoad()\n");
			s.Append("Spreadsheet1.ActiveSheet.Cells.Clear\n");
			s.Append("Spreadsheet1.ActiveSheet.Range (\"A1:k1\").Merge\n");

			s.Append("Spreadsheet1.ActiveSheet.Range (\"A1\").rowheight=30\n");
 
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A1\").value =\"行政许可审批事项办理情况统计表\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"A1\").font.size=16\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A1\").font.bold=true\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a1\"). VerticalAlignment  = Spreadsheet1.Constants.xlVAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a1\"). HorizontalAlignment  = Spreadsheet1.Constants.xlHAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2\").value =\"序号\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"b2\").value =\"类别\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"c2\").value =\"行政许可和审批（服务）事项简称\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"h2\").value =\"接件\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"i2\").value =\"受理\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"j2\").value =\"准予许可\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"k2\").value =\"不予许可\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:k2\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:k2\").font.bold=true\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:k2\").VerticalAlignment  = Spreadsheet1.Constants.xlVAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:k2\").HorizontalAlignment  = Spreadsheet1.Constants.xlHAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:k2\").rowheight =20\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"c2:g2\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").value =\"1\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a4\").value =\"2\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a5\").value =\"3\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a6\").value =\"4\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a7\").value =\"5\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a8\").value =\"6\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a9\").value =\"7\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a10\").value =\"8\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").value =\"9\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a12\").value =\"10\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a13\").value =\"11\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a14\").value =\"12\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a15\").value =\"13\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a16\").value =\"14\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a17\").value =\"15\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a18\").value =\"16\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").value =\"17\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a20\").value =\"18\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a21\").value =\"19\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a22\").value =\"20\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a23\").value =\"21\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a24\").value =\"22\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a25\").value =\"23\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a26\").value =\"24\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").value =\"25\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a28\").value =\"26\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a29\").value =\"27\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a30\").value =\"28\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a31\").value =\"29\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a32\").value =\"30\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a33\").value =\"31\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a34\").value =\"32\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\").value =\"33\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"A3:a35\").font.size=12 \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A3:a35\").VerticalAlignment  =Spreadsheet1.Constants.xlVAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A3:a35\").HorizontalAlignment  =Spreadsheet1.Constants.xlHAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b3:b12\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b3\").value =\"质量\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"b3\").font.size=12 \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b3\").VerticalAlignment  =Spreadsheet1.Constants.xlVAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b3\").HorizontalAlignment  =Spreadsheet1.Constants.xlHAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b13:b18\").merge \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b13\").value =\"计量\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"b13\").font.size=12 \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b13\").VerticalAlignment  =Spreadsheet1.Constants.xlVAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b13\").HorizontalAlignment  =Spreadsheet1.Constants.xlHAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b19:b31\").merge \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b19\").value =\"特种设备\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"b19\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b19\").VerticalAlignment  =Spreadsheet1.Constants.xlVAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b19\").HorizontalAlignment  =Spreadsheet1.Constants.xlHAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b32:b34\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b32\").value =\"纤检\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"b32\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b32\").VerticalAlignment  =Spreadsheet1.Constants.xlVAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b32\").HorizontalAlignment  =Spreadsheet1.Constants.xlHAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b35\").value =\"代码\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"b35\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b35\").VerticalAlignment  =Spreadsheet1.Constants.xlVAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b35\").HorizontalAlignment  =Spreadsheet1.Constants.xlHAlignCenter\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"c3:g3\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"c3\").value =\"产品质量检验机构资格审批\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"c4:g4\").merge\n");
			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");