secondday.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>
	/// secondday 的摘要说明。
	/// </summary>
	public class secondday : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlGenericControl dv;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
			{
			
				string tGivenDateTime=Request["GivenDate"];
				string tEndDate=Request["EndDate"];

				string DateFormating=Convert.ToDateTime(tGivenDateTime).Year+"年"+Convert.ToDateTime(tGivenDateTime).Month+"月"+Convert.ToDateTime(tGivenDateTime).Day+"日";
			
				BusinessDAL myBusiness=new BusinessDAL();
//				DataTable dt=myBusiness.secondday(Convert.ToDateTime(tGivenDateTime));
				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");