content.aspx.cs

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

			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();
		
		}
		private void SingledistrictSum(DateTime tGivenDate)
		{
			BusinessDAL myBusiness=new BusinessDAL();
			DataTable dt=myBusiness.thirdday1(Convert.ToDateTime(tGivenDate));
			
			
			BusinessDAL myBusiness1=new BusinessDAL();
			DataTable dt1=myBusiness1.thirdday2(Convert.ToDateTime(tGivenDate));
			
			
			BusinessDAL myBusiness2=new BusinessDAL();
			DataTable dt2=myBusiness2.thirdday3(Convert.ToDateTime(tGivenDate));
			
			
			BusinessDAL myBusiness3=new BusinessDAL();
			DataTable dt3=myBusiness3.thirdday4(Convert.ToDateTime(tGivenDate));
			
			
			BusinessDAL myBusiness4=new BusinessDAL();
			DataTable dt4=myBusiness4.thirdday5(Convert.ToDateTime(tGivenDate));
				
			
			BusinessDAL myBusiness5=new BusinessDAL();
			DataTable dt5=myBusiness5.thirdday6(Convert.ToDateTime(tGivenDate));
			
			
			BusinessDAL myBusiness6=new BusinessDAL();
			DataTable dt6=myBusiness6.thirdday7(Convert.ToDateTime(tGivenDate));
		
			
			BusinessDAL myBusiness7=new BusinessDAL();
			DataTable dt7=myBusiness7.thirdday8(Convert.ToDateTime(tGivenDate));
			
			
			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:i1\").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(\"f2\").value =\"接件\"\n");

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

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

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

			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").font.bold=true\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A2:i2\").rowheight =20\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b2:e2\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a3:a10\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").value=\"和平区\"\n");
 
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a3\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a11:a18\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").value=\"河西区\"\n");
 
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
	
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a11\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a19:a26\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").value=\"河东区\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").font.size=12\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a19\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a27:a34\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").value=\"南开区\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a27\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a35:a42\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\"). value=\"河北区\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\").font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\").VerticalAlignment=Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a35\").HorizontalAlignment=Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b3:e3\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b3\").value=\"计量标准器具核准\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b4:e4\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b4\").value=\"制造、修理计量器具许可签发\"\n");