playtime.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;
using System.Data.SqlClient;
using OfficeSys.Class;

namespace OfficeSys.ExcelFile
{
	/// <summary>
	/// playtime 的摘要说明。
	/// </summary>
	public class playtime : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.DropDownList DropDLName;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.DropDownList DropDLRight;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.DropDownList DropDLClass;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.TextBox TextBoxDay;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.TextBox TextBoxNight;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator2;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.TextBox TxtBExplain;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.HtmlControls.HtmlGenericControl FONT1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(Session["id"]==null)
			{
				Response.Redirect("../login.aspx");
			}
			if(!Page.IsPostBack)   //每一次访问页面
			{
				DataProcess dataProcess=new DataProcess();
				string strSqlTeacher="select 教师号,教师名 from 教师信息表";
				string strSqlRight="select 职称名,职称号 from 职称信息表";
				string strSqlClass="select 班级名,班级号 from 班级信息表";
				SqlDataReader reader;
				reader=dataProcess.ExecuteReader(strSqlTeacher);
				while(reader.Read())
				{   
					//初始化教师信息列表
					this.DropDLName.Items.Add(new ListItem(reader.GetString(1).ToString(),reader.GetString(0).ToString()));//初始化教师姓名下拉列表框
					
				}
				reader=dataProcess.ExecuteReader(strSqlRight);
				while(reader.Read())
				{  
					//初始化职称信息列表
					this.DropDLRight.Items.Add(new ListItem(reader.GetString(0).ToString (),reader.GetString(1).ToString()));//初始化职称下拉列表

				}
				reader=dataProcess.ExecuteReader(strSqlClass);
				while(reader.Read())
				{  
					//初始化班级信息列表
					this.DropDLClass.Items.Add(new ListItem(reader.GetString(0),reader.GetString(1).ToString()));//初始化班级下拉列表
				}      
			}
		}

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

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			DataProcess dataProcess=new DataProcess();
			string  strsql,strValues,dataStr,playtime;
			dataStr=System.DateTime.Now.Date.ToShortDateString( ).ToString();
			this.Label10.Text="";
			playtime=play().ToString();
			strsql="insert into 教师课酬表(教师号,班级号,职称号,说明,白班,夜班,日期,课酬)";
			strValues="values('"+this.DropDLName.SelectedValue.Trim()+"','"+this.DropDLClass.SelectedValue.Trim()+"','"+this.DropDLRight.SelectedValue.Trim()+"'";
			strValues=strValues+",'"+this.TxtBExplain.Text.Trim()+"',"+this.TextBoxDay.Text.Trim()+"";
			strValues=strValues+","+this.TextBoxNight.Text.Trim()+",'"+dataStr+"','"+playtime+"')";
			strsql=strsql+strValues;
			if(dataProcess.ExecuteNonQuery(strsql)!=0)
				this.Label10.Text="插入成功";
			else
				this.Label10.Text="插入失败";		
			sumKechou(dataStr);
		}
		public void sumKechou(string dataStr)
		{
			string strSql="select sum(课酬) as 总课酬 from 教师课酬表 K,教师信息表 J where J.教师号='"+this.DropDLName.SelectedValue.Trim()+"' group by J.教师号";
			string strSql1="select 教师号 from 总课酬 where 日期='"+dataStr+"'";
			DataProcess dataProcess=new DataProcess( );
			string Sum=dataProcess.ExecuteString(strSql);
			if(Sum!="")
			{
				SqlDataReader reader=dataProcess.ExecuteReader(strSql1);
				if(reader.Read())
				{
					string strSql2="update 总课酬 set 教师号='"+this.DropDLName.SelectedValue.Trim()+"',总课酬='"+Sum+"',日期='"+dataStr+"'";
					if(dataProcess.ExecuteNonQuery(strSql2)!=0)
					{  
						this.Label10.Text="成功计算总课酬";             

					}
					else
					{
						this.Label10.Text="计算总课酬失败";
					}
				}
				else
				{ 
					string strSql3="insert into 总课酬(教师号,总课酬,日期) values('"+this.DropDLName.SelectedValue.Trim()+"','"+Sum+"','"+dataStr+"')";
					if(dataProcess.ExecuteNonQuery(strSql3)!=0)
					{
						this.Label10.Text="成功计算总课酬";
					}
					else
					{
						this.Label10.Text="计算总课酬失败";
					}

				}
			}
			else
			{

			}
		}
		public float play()
		{
			string strClassNum,strDepartPosi;  //字符型的班级人数和职称系数
			int intClassNum;      //班级人数
			float fltDepartPosi,dayCoverNum,nightCoverNum;//职称系数 .白班折算系数 夜班折算系数
			float dayHour=0,nightHour=0;   //白班,夜班的课时
			string strSql1="select 班级人数 from 班级信息表 where 班级号='"+this.DropDLClass.SelectedValue.Trim()+"'";
			string strSql2="select 职称系数 from 职称信息表 where 职称号='"+this.DropDLRight.SelectedValue.Trim()+"'";
			
			DataProcess dataProcess=new DataProcess();
			strClassNum=dataProcess.ExecuteString(strSql1);
			strDepartPosi=dataProcess.ExecuteString(strSql2);
			intClassNum=int.Parse(strClassNum.Trim());
			fltDepartPosi=float.Parse(strDepartPosi.Trim()); 
            
           
			float Num=(intClassNum/10-4)*0.1f;
			dayCoverNum=Num+1.0f;
			nightCoverNum=Num+1.2f;


			if(this.TextBoxDay.Text.Trim()!="")
			{
				dayHour=float.Parse(this.TextBoxDay.Text.Trim());   //取白班课时
			}
			if(this.TextBoxNight.Text.Trim()!="")
			{
				nightHour=float.Parse(this.TextBoxNight.Text.Trim());   //职夜班课时
			}
		
			return (dayHour*dayCoverNum+nightHour*nightCoverNum)*fltDepartPosi;//课酬=白班课酬+夜班课酬
		}

		private void TextBoxDay_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void TextBox4_TextChanged(object sender, System.EventArgs e)
		{
		
		}
	}
}