content.aspx.cs

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text;
using DBClass;
using System.Data.SqlClient;

namespace AdministrationSystem
{
	/// <summary>
	/// Content 的摘要说明。
	/// </summary>
	public class Content : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlGenericControl dv;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
						
			if(!IsPostBack)
			{
	
				Select frm=(Select)Context.Handler;
				//
				//				string tGivenDateTime=frm.tGivenDate;
				//				string tEndDate=frm.tEndDate;
			   
				SelectControl(frm.URLType,Convert.ToDateTime(frm.tGivenDate),Convert.ToDateTime(frm.tEndDate));
//								string DateFormating=Convert.ToDateTime(frm.tGivenDate).Year+"年"+Convert.ToDateTime(frm.tGivenDate).Month+"月"+Convert.ToDateTime(frm.tGivenDate).Day+"日"+"统计报表";
//				
			}
		}
		private void SelectControl(int nURLType,DateTime tGivenDate,DateTime tEndDate)
		{
		
			switch(nURLType)
			{
				case 1:
					SingleSum(tGivenDate);
					break;
				case 2:SinglesortedSum(tGivenDate);
					break;
				case 3:SingledistrictSum(tGivenDate);
					break;
				case 4:RangeSum(tGivenDate,tEndDate);
					break;
				case 5:RangesortedSum(tGivenDate,tEndDate);
					break;
				case 6:RangedistrictSum(tGivenDate,tEndDate);
					break;

			

			}
		}
		private void SingleSum(DateTime tGivenDate)
		{
		

			
			BusinessDAL myBusiness=new BusinessDAL();
			DataTable dt=myBusiness.GetSingleProceeding(tGivenDate);
			
			
			BusinessDAL myBusiness1=new BusinessDAL();
			DataTable dt1=myBusiness1.GetSingleProceeding1(tGivenDate);
			
						
			BusinessDAL myBusiness2=new BusinessDAL();
			DataTable dt2=myBusiness2.GetSingleProceeding2(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:P1\").Merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"A1\").Rowheight= 30\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(\"b2:c2\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b3:c3\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b4:c4\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b5:c5\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b6:c6\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b7:c7\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"d2:g2\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"h2:k2\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"l2:o2\").merge\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a2:p7\").rowheight =20\n");  
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a2:a7\").columnwidth=5.13\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b2:b7\"). Columnwidth=3.38\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"d3:d7\"). Columnwidth=5.13\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"e3:e7\"). Columnwidth=5.13\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"f3:f7\"). Columnwidth=8.38\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"g3:g7\"). Columnwidth=8.38\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"h3:h7\").columnwidth=5.13\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"i3:i7\").columnwidth=5.13\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"j3:j7\"). Columnwidth=8.38\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"k3:k7\"). Columnwidth=8.38\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"l3:l7\"). Columnwidth=5.13\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"m3:m7\"). Columnwidth=5.13\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"n3:n7\"). Columnwidth=8.38\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"o3:o7\"). Columnwidth=8.38\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"p2:p7\"). Columnwidth=8.38\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a2:p2\"). Font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a2:p2\"). Font.bold=true\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"d3:o3\"). Font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a4:a6\"). Font.size=12\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b4:b7\"). Font.size=12\n");
//			s.Append("Spreadsheet1.ActiveSheet.Range(\"a1\").Value =\"");
//			s.Append("DateFormating\n");
//			s.Append("\"\n");

			s.Append("Spreadsheet1.ActiveSheet.Range(\"a2\").Value = \"序号\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b2\").Value = \"类型\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"d2\").Value = \"市区\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"h2\").Value = \"区县\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"l2\").Value = \"其他\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"p2\").Value = \"合计\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a4\").Value = \"1\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a5\").Value = \"2\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a6\").Value = \"3\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b4\").Value = \"行政许可\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b5\").Value = \"非行政许可\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b6\").Value = \"服务\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b7\").Value = \"合计\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"d3\").Value = \"接件\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"e3\").Value = \"受理\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"f3\").Value = \"准予许可\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"g3\").Value = \"不予许可\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"h3\").Value = \"接件\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"i3\").Value = \"受理\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"j3\").Value = \"准予许可\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"k3\").Value = \"不予许可\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"l3\").Value = \"接件\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"m3\").Value = \"受理\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"n3\").Value = \"准予许可\"\n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"o3\").Value = \"不予许可\"\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:p2\").VerticalAlignment  =  Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a2:p2\").HorizontalAlignment  = Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"d3:o3\").VerticalAlignment  =  Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"d3:o3\").HorizontalAlignment  = Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a4:a6\").VerticalAlignment  =  Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"a4:a6\").HorizontalAlignment  = Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b4:b7\").VerticalAlignment  =  Spreadsheet1.Constants.xlVAlignCenter \n");
			s.Append("Spreadsheet1.ActiveSheet.Range(\"b4:b7\").HorizontalAlignment  = Spreadsheet1.Constants.xlHAlignCenter \n");
			s.Append("Spreadsheet1.Range(\"A1:p7\").Borders.Weight = Spreadsheet1.Constants.owcLineWeightMedium \n");

			int [] nRowSum=new int[4];
			for(int i=0;i<4;i++)
			{
				nRowSum[i]=0;
			}
				
			for(int j=1;j<dt.Columns.Count;j++)
			{  
				int nSum=0;
				for(int i=0;i<dt.Rows.Count;i++)
				{
					int row=i+4;
					int col=j+3;
						
						
					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("+7+","+(j+3)+").Value="+"\""+nSum+"\""+"\n");
				nRowSum[3]+=nSum;
			}
			for(int j=1;j<dt1.Columns.Count;j++)
			{  
				int nSum=0;
				for(int i=0;i<dt1.Rows.Count;i++)
				{
					int row=i+4;
					int col=j+7;
					s.Append("Spreadsheet1.ActiveSheet.Cells("+row+","+col+").Value="+"\""+dt1.Rows[i][j]+"\""+"\n");
					if(dt1.Rows[i][j].ToString()!="")
					{
						nSum+=Convert.ToInt32(dt1.Rows[i][j]);
						nRowSum[i]+=Convert.ToInt32(dt1.Rows[i][j]);
					}

						
				}
				s.Append("Spreadsheet1.ActiveSheet.Cells("+7+","+(j+7)+").Value="+"\""+nSum+"\""+"\n");
				nRowSum[3]+=nSum;
			}
			for(int j=1;j<dt2.Columns.Count;j++)
			{  
				int nSum=0;
				for(int i=0;i<dt2.Rows.Count;i++)