admin_kaoqingearly.aspx.cs

前台用户可以在线留言

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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 messageboardtest.DataAccess;

namespace messageboardtest
{
	/// <summary>
	/// admin_kaoqingearly 的摘要说明。
	/// </summary>
	public class admin_kaoqingearly : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid dgshow;
		protected System.Web.UI.WebControls.Button btngo;
		protected System.Web.UI.WebControls.TextBox btadminid;
		protected System.Web.UI.WebControls.DropDownList ddlmonth;
		protected System.Web.UI.WebControls.DropDownList ddlyear;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session.Count == 0)
				Page.Response.Redirect("admin.aspx");
			else
				if (Session["adminid"].ToString() == "")
				     Page.Response.Redirect("admin.aspx");
			if(!Page.IsPostBack)
			{
				binddatagrid();
				binddate();
				ddlyear.SelectedValue = DateTime.Now.Year.ToString();
				ddlmonth.SelectedValue =  DateTime.Now.Month.ToString();
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btngo.Click += new System.EventHandler(this.btngo_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		protected void binddatagrid()
		{
			DataSet ds=DbHelper.GetSet("sp_selectallearly");
			dgshow.DataSource=ds;
			dgshow.DataBind();
			int sum=ds.Tables[0].Rows.Count;
			foreach(DataGridItem dgi in dgshow.Controls[0].Controls)
			{
				if (dgi.ItemType == ListItemType.Footer)
					dgi.Cells[5].Text = ddlmonth.SelectedValue.ToString()+"月所有员工早退次数："+sum.ToString();
			}
		}

		protected void binddate()
		{
			for (int i=2000; i<2020; i++)
			{
				ListItem item = new ListItem(Convert.ToString(i),Convert.ToString(i));
				ddlyear.Items.Add(item);
			}
			//绑定月
			for (int i = 1 ; i<13 ; i++)
			{
				ListItem item1 =  new ListItem(Convert.ToString(i),Convert.ToString(i));
				ddlmonth.Items.Add(item1);
			}
		}


		private void btngo_Click(object sender, System.EventArgs e)
		{
			SqlParameter[] para= {
									 new SqlParameter("@adminid",btadminid.Text),
									 new SqlParameter("@year",ddlyear.SelectedValue.ToString()),
									 new SqlParameter("@month",ddlmonth.SelectedValue.ToString()),
			};
			DataSet ds=DbHelper.GetSet("sp_selectadminearly",para);
			dgshow.DataSource=ds;
			dgshow.DataBind();
			//统计迟到总数
			int sum=ds.Tables[0].Rows.Count;
			foreach(DataGridItem dgi in dgshow.Controls[0].Controls)
			{
				if (dgi.ItemType == ListItemType.Footer)
					dgi.Cells[5].Text = ddlmonth.SelectedValue.ToString()+"月"+btadminid.Text+"早退到次数："+sum.ToString();
			}
		}

		private void dgshow_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			if (dgshow.CurrentPageIndex >= 0)
			{
				dgshow.CurrentPageIndex = e.NewPageIndex;
				binddatagrid();
			}
		}
	}
}