📄 moas1204.aspx.cs
字号:
using System;
using System.Web;
using System.Text;
using System.Data;
using System.Web.UI;
using System.Drawing;
using System.Collections;
using System.Diagnostics;
using System.Web.Security;
using System.Data.SqlClient;
using System.ComponentModel;
using System.Web.SessionState;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Runtime.InteropServices;
using System.Text.RegularExpressions;
namespace MOAS
{
/// <summary>
/// MOAS1204 的摘要说明。
/// </summary>
public class MOAS1204 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Table Table1;
protected System.Web.UI.WebControls.Table Table2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.Calendar Calendar1;
protected System.Web.UI.WebControls.Calendar Calendar2;
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.DropDownList DropDownList3;
protected System.Web.UI.WebControls.DropDownList DropDownList4;
protected System.Web.UI.WebControls.DropDownList DropDownList5;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
//让主页面静止
this.Page.SmartNavigation = false;
//获取Login登陆的ID
if(((string[])Session["strArrayLoginInfo"]).GetValue(0).ToString()!="")
{
TextBox1.Text=((string[])Session["strArrayLoginInfo"]).GetValue(0).ToString();
}
//读取数据库,下拉框获取CODEMASTER表里的值
if(!Page.IsPostBack)
{
string sql="select * from CODEMASTER where ID='C008'";
CCoSearchFromDatabase a=new CCoSearchFromDatabase();
DropDownList5.DataSource=a.getDataSet(sql);
if(a.getDataSet(sql)!=null)
{
DropDownList5.DataTextField="VALUE";
DropDownList5.DataValueField="NO";
DropDownList5.DataBind();
}
//a.getDataSet(sql)为空处理信息
else
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message=a.getDataSet(sql)为空");
}
}
//保存TextBox2里的值
if(Cache["Pass"]!=null)
Cache.Remove("Pass");
Cache.Insert("Pass",this.TextBox2.Text);
TextBox2.Attributes["Value"] = Cache["Pass"].ToString();
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Calendar1.SelectionChanged += new System.EventHandler(this.Calendar1_SelectionChanged);
this.Calendar2.SelectionChanged += new System.EventHandler(this.Calendar2_SelectionChanged);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
//确定按钮事件
private void Button1_Click(object sender, System.EventArgs e)
{
//定义字符串变量
string StartTime,EndTime,NowTime,m1,m2,n1,n2,n3,n4;
//给开始时间赋年月日
m1=TextBox3.Text;
//给结束时间赋年月日
m2=TextBox4.Text;
//给开始时间赋 时
n1=DropDownList1.SelectedItem.Text;
//给开始时间赋 分
n2=DropDownList2.SelectedItem.Text;
//给结束时间赋 时
n3=DropDownList3.SelectedItem.Text;
//给结束时间赋 分
n4=DropDownList4.SelectedItem.Text;
//给开始时间赋年月日 时 分
StartTime=m1+n1+n2;
//给结束时间赋年月日 时 分
EndTime=m2+n3+n4;
//获得系统的现在日期
string ss=DateTime.Now.ToString();
NowTime=DateTime.Parse(ss).ToString("yyyyMMddHHmm");
//字符串变量类型转换
long StartTime1,EndTime1,NowTime1;
StartTime1=Convert.ToInt64(StartTime);
EndTime1=Convert.ToInt64(EndTime);
NowTime1=Convert.ToInt64(NowTime);
//判断输入的密码是否为空
if(TextBox2.Text=="")
{
//密码为空提示信息
Page.RegisterStartupScript("startup","<script language='javascript'>alert('密码为空!请输入密码!');</script>");
//TextBox2获取焦点
Page.RegisterStartupScript("focus", "<script language=javascript>document.getElementById('TextBox2').focus();</script>");
}
else
{
//判断输入密码的正确性.
string aa=((string[])Session["strArrayLoginInfo"]).GetValue(2).ToString();
if(TextBox2.Text.Equals(aa))
{
//判断输入的开始时间是否为空
if(TextBox3.Text=="")
{
//没有输入开始时间提示信息
Page.RegisterStartupScript("startup","<script language='javascript'>alert('开始时间为空!请输入开始时间!');</script>");
//TextBox3获取焦点
Page.RegisterStartupScript("focus", "<script language=javascript>document.getElementById('TextBox3').focus();</script>");
}
else
{
//日期有效性判断
if(StartTime1>=NowTime1)
{
//判断输入的结束时间是否为空
if(TextBox4.Text=="")
{
//没有输入结束时间提示信息
Page.RegisterStartupScript("startup","<script language='javascript'>alert('终止时间为空!请输入终止时间!');</script>");
//TextBox4获取焦点
Page.RegisterStartupScript("focus", "<script language=javascript>document.getElementById('TextBox4').focus();</script>");
}
else
{
if(EndTime1>StartTime1)
{
//调用InsertDateBase()函数
InsertDateBase();
//调用UpdateDateBase()函数
UpdateDateBase();
//返回上一页
Response.Redirect("MOAS1203.aspx");
}
else
{
//输入时间不符提示信息
Page.RegisterStartupScript("startup","<script language='javascript'>alert('终止时间小于开始时间!请重新输入!');</script>");
//TextBox4获取焦点
Page.RegisterStartupScript("focus", "<script language=javascript>document.getElementById('TextBox4').focus();</script>");
//日历2文本框清空
TextBox4.Text="";
}
}
}
else
{
//输入时间不符提示信息
Page.RegisterStartupScript("startup","<script language='javascript'>alert('开始时间低于现在时间!请重新输入!');</script>");
//TextBox3获取焦点
Page.RegisterStartupScript("focus", "<script language=javascript>document.getElementById('TextBox3').focus();</script>");
//日历1文本框清空
TextBox3.Text="";
}
}
}
else
{
//输入的密码不正确提示信息
Page.RegisterStartupScript("startup","<script language='javascript'>alert('输入的密码不正确!请重新输入!');</script>");
//TextBox2获取焦点
Page.RegisterStartupScript("focus", "<script language=javascript>document.getElementById('TextBox2').focus();</script>");
//密码文本框清空
TextBox2.Text="";
}
}
}
//插入数据库函数
private void InsertDateBase()
{
//职员缺席详细信息插入数据库.
try
{
string[] sql1={"select * from UKISAKI","UKISAKI"};
CCoSearchFromDatabase a1=new CCoSearchFromDatabase();
DataSet ds=a1.getDataSet(sql1);
int count=ds.Tables["UKISAKI"].Rows.Count+1;
string count1="'"+count+"'";
string ID=TextBox1.Text;
string TYPE=DropDownList5.SelectedItem.Value;
string TimeStart1=""+TextBox3.Text+""+" "+""+DropDownList1.SelectedItem.Text+""+":"+""+DropDownList2.SelectedItem.Text+""+":00";
string TimeEnd1=""+TextBox4.Text+""+" "+""+DropDownList3.SelectedItem.Text+""+":"+""+DropDownList4.SelectedItem.Text+""+":00";
string zoko=TextBox5.Text;
string ID1="'"+ID+"'";
string TYPE1="'"+TYPE+"'";
string TimeStart11="'"+TimeStart1+"'";
string TimeEnd11="'"+TimeEnd1+"'";
string zoko1="'"+zoko+"'";
string insertText="("+count1+","+ID1+","+TYPE1+","+TimeStart11+","+TimeEnd11+","+zoko1+")";
string insert="INSERT INTO UKISAKI(NO,USER_ID,TYPE,START_DATE,END_DATE,BIKOU) VALUES "+insertText+"";
//插入结果传给数据库连接公共类
CCoSearchFromDatabase c1=new CCoSearchFromDatabase();
c1.Execute(insert);
}
//异常处理
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+"");
}
}
//修改数据库函数
private void UpdateDateBase()
{
//修改数据库
try
{
string id=((string[])Session["strArrayLoginInfo"]).GetValue(0).ToString();
string id1="'"+id+"'";
string update="UPDATE USERS SET STATUS='2' WHERE ID="+id1+"";
//修改结果传给数据库连接公共类
CCoSearchFromDatabase c2=new CCoSearchFromDatabase();
c2.Execute(update);
}
//异常处理
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+"");
}
}
private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
}
//日历1
private void Calendar1_SelectionChanged(object sender, System.EventArgs e)
{
//获取选定日期给datestr变量
string datestr=Calendar1.SelectedDate.ToLongDateString();
//文本框接收简易性日期
TextBox3.Text=DateTime.Parse(datestr).ToString("yyyyMMdd");
Calendar1.TodaysDate.ToUniversalTime();
Calendar1.SelectedDates.Clear();
Calendar1.Visible=false;
}
//日历2
private void Calendar2_SelectionChanged(object sender, System.EventArgs e)//日历2
{
//获取选定日期给datestr变量
string datestr=Calendar2.SelectedDate.ToLongDateString();
//文本框接收简易性日期
TextBox4.Text=DateTime.Parse(datestr).ToString("yyyyMMdd");
Calendar2.TodaysDate.ToUniversalTime();
Calendar2.SelectedDates.Clear();
Calendar2.Visible=false;
}
private void Button2_Click(object sender, System.EventArgs e)
{
//返回上一级画面
Response.Redirect("MOAS1203.aspx");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -