3.aspx.cs

图档管理系通

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;

namespace sys_3
{
	/// <summary>
	/// _3 的摘要说明。
	/// </summary>
	public class _3 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Image Image1;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Panel Panel2;
		protected System.Web.UI.WebControls.Panel Panel3;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.DropDownList DropDownList3;
		protected System.Web.UI.WebControls.LinkButton LinkButton3;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.LinkButton LinkButton2;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.Panel Panel4;
		protected System.Web.UI.WebControls.DataGrid DataGrid0;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.DataGrid DataGrid2;
		protected System.Web.UI.WebControls.DataGrid DataGrid3;
		protected System.Web.UI.WebControls.LinkButton LinkButton6;
		protected System.Web.UI.WebControls.LinkButton LinkButton5;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.Panel Panel1;
	
		//"select bp.*,jd.chinese c1,zy.chinese c2,bpup.* from  bp,bpjd jd,bpzy zy,bpup  where bp.zy=zy.dz and bp.pjd=jd.dz and bp.upID=bpup.upID ";
        //如上的查询由于库里有没有上传号的数据 所以会丢项！	
		//select bp.*,jd.chinese c1,zy.chinese c2,bpup.* from  bp,bpjd jd,bpzy zy  where bp.zy=zy.dz and bp.pjd=jd.dz and bp.bpname=xxx
		//这样做也不行，回头 可以仔细分析一下关系代数的意义
		private string sqlA="select  bp.*,jd.chinese c1,zy.chinese c2 from  bp,bpjd jd,bpzy zy where bp.zy=zy.dz and bp.pjd=jd.dz and (bp.Flag='y' or bp.Flag='a')  ";
		protected System.Web.UI.WebControls.DropDownList DropDownList4;
		protected System.Web.UI.WebControls.LinkButton LinkButton4;
		protected System.Web.UI.WebControls.CheckBox CB5;
	    private string sqlB="select * from bpdown "; 

		private void Page_Load(object sender, System.EventArgs e)
		{
			
			
			
			
			//下边这两个回头要删除！！
			//Session["user"]="张建锋";
			//Session["uA"]="2";
				
			
			
			
			
			
			
			// 在此处放置用户代码以初始化页面
			
			if(!this.IsPostBack)
			{
				string uAstr=null;
				switch(Session["uA"].ToString().Trim())
				{
					case "1":uAstr="普通用户";break;
					case "2":uAstr="专业组长";break;
					case "3":uAstr="高级管理者";break;
					case "4":uAstr="档案管理者";break;
				}
				Label1.Text="用户姓名： "+Session["user"].ToString().Trim()+"   用户身份："+uAstr;
			
			
				Session["temp1"]=new sItem(300);
				Session["temp2"]=new sItem(300);
				
				if(Session["uA"].ToString().Trim() =="0")
					Response.Redirect("1.aspx");
                //几个下拉列表
				//首次审批人  组长2 高级管理者3
				Load_dd(DropDownList2,"select * from bpuser where uA='2' or uA='3'",c.conSTR,"uName","uName");
				//查询项目   列表显示可以查询的字段名字
				Load_dd(DropDownList1,"select * from bpquery ",c.conSTR,"name","field");
				//二次审批者  只有高管可以做复审
				Load_dd(DropDownList3,"select * from bpuser where  uA='3'",c.conSTR,"uName","uName");
				
				//对管理者显示自己的审批项和自己的待审项 对于一般人员1显示自己等待审批a,s和已经审批z的项目 e类已经下载项目不显示
				displayDGD();

				Session["dataQueryStr"]=this.sqlA;
				Session["strTemp"]="";
				 
				DataGrid0.CurrentPageIndex=DataGrid3.CurrentPageIndex=DataGrid1.CurrentPageIndex=DataGrid2.CurrentPageIndex=0;
				DisplyQuery();
				
			}
            //原来想在这里设置一下页数调整为0可是如果这样做 那末翻页的功能就作废了 只有在不同的功能按钮中设置这个了！
				
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
			this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
			this.LinkButton2.Click += new System.EventHandler(this.LinkButton2_Click);
			this.LinkButton6.Click += new System.EventHandler(this.LinkButton6_Click);
			this.LinkButton3.Click += new System.EventHandler(this.LinkButton3_Click);
			this.LinkButton4.Click += new System.EventHandler(this.LinkButton4_Click);
			this.LinkButton5.Click += new System.EventHandler(this.LinkButton5_Click);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Button2.Click += new System.EventHandler(this.Button2_Click);
			this.Button4.Click += new System.EventHandler(this.Button4_Click);
			this.DataGrid0.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid0_PageIndexChanged);
			this.DataGrid0.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid0_ItemDataBound);
			this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
			this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
			this.DataGrid2.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid2_PageIndexChanged);
			this.DataGrid2.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid2_ItemDataBound);
			this.DataGrid2.SelectedIndexChanged += new System.EventHandler(this.DataGrid2_SelectedIndexChanged);
			this.DataGrid3.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid3_PageIndexChanged);
			this.DataGrid3.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid3_ItemDataBound);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button2_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("2.aspx");
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("1.aspx");
		}

		private void Button4_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("0.aspx");
		}

		

// 分页显示
		private void DataGrid0_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid0.CurrentPageIndex = e.NewPageIndex;
			//邦定数据
			DisplyQuery();
		}

		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid1.CurrentPageIndex = e.NewPageIndex;
			//邦定数据
			displayDGD();
		}

		private void DataGrid2_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid2.CurrentPageIndex=e.NewPageIndex;
			//邦定数据
			displayDGD();
		}

		private void DataGrid3_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid3.CurrentPageIndex=e.NewPageIndex;
			//邦定数据
			dislpayDGD3();
		}

//显示序号
		private void DataGrid3_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemIndex != -1)
			{
				int orderID=e.Item.ItemIndex+1;
				e.Item.Cells[1].Text=orderID.ToString();
			}
		}

		private void DataGrid0_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemIndex != -1)
			{
				int orderID=e.Item.ItemIndex+1;
				e.Item.Cells[1].Text=orderID.ToString();
			}
		}
//全选  还必须是public !!!! ？？？
		public void CheckAll_1(object sender, System.EventArgs e)
		{
			CheckBox cbAll = (CheckBox)sender;
			foreach(DataGridItem dgi in DataGrid0.Items)
				{
					CheckBox cb = (CheckBox)dgi.FindControl("CheckBox2");
					cb.Checked = cbAll.Checked;
				}			
		}
		public void CheckAll_2(object sender, System.EventArgs e)
		{
			CheckBox cbAll = (CheckBox)sender;
			foreach(DataGridItem dgi in DataGrid3.Items)
			{
				CheckBox cb = (CheckBox)dgi.FindControl("CheckBox4");
				cb.Checked = cbAll.Checked;
			}			
		}
//选择
		/// <summary>
		/// 15
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			//绑定现实
			//写入选择的序号
			int i=DataGrid1.SelectedIndex;
			string str=DataGrid1.Items[i].Cells[1].Text;//申请号
			Session["downID1"]=str.Trim();
			string strflag=DataGrid1.Items[i].Cells[8].Text;
			
			//LinkButton3.Enabled=LinkButton2.Enabled=true;this.HyperLink3.Enabled=true;
		
			//显示数据
			//Load_dgd(DataGrid3,sqlA+" and bp.downID='"+str+"'",c.conSTR);//是否会有问题 包括前边  还有如果要在结果集里查询难那末该如何做 用到数据集的查询！
			
			//防止发生空白页异常
			DataGrid3.CurrentPageIndex=0;
			Load_dgd(DataGrid3,sqlA+" and bp.fID in (select fID from bpdown_bp where downID= '"+str.Trim()+"')",c.conSTR);
			Session["sqlDisplay3"]=this.sqlA+" and bp.fID in (select fID from bpdown_bp where downID= '"+str.Trim()+"')";
			
			
			
			//开启功能键
			this.LinkButton4.Enabled=true;
			this.LinkButton5.Enabled=true;
			this.HyperLink1.Enabled=false;

			if(strflag.Trim()=="s")
			{
				this.DropDownList3.Enabled=true;
			}
			else
			{
				this.DropDownList3.Enabled=false;
			}
		}
		private void DataGrid2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			//得到选择项
			int i=DataGrid2.SelectedIndex;
			string str=DataGrid2.Items[i].Cells[1].Text;//申请号
			string flagstr=DataGrid2.Items[i].Cells[6].Text;
			Session["downID2"]=str.Trim();
			//.

			
			
			this.LinkButton4.Enabled=false;
			this.LinkButton5.Enabled=false;
			this.DropDownList3.Enabled=false;
			
			//开启功能键
			//this.LinkButton4.Enabled=true;this.HyperLink1.Enabled=true;
			
			//二审结束的可以让他下载 b表示！
			if(flagstr.Trim()=="b")
			{
				this.HyperLink1.Enabled=true;
			}
			else
			{
				this.HyperLink1.Enabled=false;
			}
			//显示数据

			//防止发生空白页异常
			DataGrid3.CurrentPageIndex=0;
			Load_dgd(DataGrid3,sqlA+" and bp.fID in (select fID from bpdown_bp where downID= '"+str.Trim()+"')",c.conSTR);
			
			//
			Session["sqlDisplay3"]=sqlA+" and bp.fID in (select fID from bpdown_bp where downID= '"+str.Trim()+"')";
		}
//绑定数据通用
		private void Load_dgd(System.Web.UI.WebControls.DataGrid DataGrid,string cmdTxt,string connStr)
		{
			DataTable data= c.exeQuery(cmdTxt,connStr);
			DataGrid.DataSource=data;
			DataGrid.DataBind();
			DataGrid.Visible=true;
		}
		private void Load_dd(System.Web.UI.WebControls.DropDownList Dd,string cmdTxt,string connStr,string tf,string vf)
		{
			Dd.DataTextField=tf;
			Dd.DataValueField=vf;
			DataTable data= c.exeQuery(cmdTxt,connStr);
			Dd.DataSource=data;
			Dd.DataBind();
			Dd.Visible=true;
		}
/// <summary>
///  提交申请
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		
		//生成下载序号 保存在 session downID
		private void LinkButton2_Click(object sender, System.EventArgs e)
		{
			Application.Lock();
			int count=c.ExecuteSql2("select downID from BpxInf");
			count+=1;
			c.ExecuteSql("update BpxInf set downID ='"+count.ToString()+"'");
			Application.UnLock();

			Session["downID"]=count;
			Response.Write(Session["downID"].ToString());
			//开启功能按钮
			LinkButton6.Enabled=true;
			LinkButton3.Enabled=true;
			LinkButton2.Enabled=false;
		}
//确定单页
		private void LinkButton6_Click(object sender, System.EventArgs e)
		{
			
			Item i;
			//得到缓存
			sItem sItemp=(sItem)Session["temp1"];
			//千万不能在这里清理缓冲！！！