=。= 补考结束了。挂2科压力巨大啊。
刚补考完。新学期各种科目的作业就砸下来了。
话说~咱学校编程方面老师的水平真是不敢恭维啊。
这学期学的神马ASP.NET 第一节的作业就是做一个 人力资源管理。 说到底，不过是上学期 WindowsForm 程序的 网页版 罢了。
做的功能也完全一样，全是 数据的 增加，删除。 唉唉~真想免修啊。但是谁叫我之前的专业是 金融学呢。 自己自学的科目完全无法申请免修的说。 悲剧~~~~~~~~
嘛嘛，不过有个很困扰我的问题是在ASP.NET中如何制作一个类似 Message.show 的功能呢？ 又或者怎么使用JS的 alert呢？这不专业的老师完全没说啊。
坑爹啊！！！！！！！！
下面是作业记录： （源码+下载地址）
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data.SqlClient;
namespace 简易人力资源管理
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void bconn_Click(object sender, EventArgs e)
{
string con = @"server=.;initial Catalog=Renli;integrated Security=True";
string com = "SELECT * FROM info";
SqlConnection conn = new SqlConnection(con);
conn.Open();
SqlCommand comm = new SqlCommand(com, conn);
SqlDataReader dr = comm.ExecuteReader();
try
{
if (dr.Read())
{
tid.Text = dr["ID"].ToString();
tname.Text = dr["Name"].ToString();
tgender.Text = dr["Gender"].ToString();
tbirthday.Text = dr["Birthday"].ToString();
taddress.Text = dr["Address"].ToString();
tphone.Text = dr["Phone"].ToString();
tmobile.Text = dr["Mobile"].ToString();
temail.Text = dr["Email"].ToString();
teducation.Text = dr["Education"].ToString();
tdegree.Text = dr["Degree"].ToString();
}
}
catch (Exception ex)
{
lw.Text = ex.Message;
}
finally
{
dr.Close();
conn.Close();
blast.Enabled = true;
bnext.Enabled = true;
badd.Enabled = true;
bdel.Enabled = true;
}
}
protected void blast_Click(object sender, EventArgs e)
{
lw.Text = "";
string con = @"server=.;initial Catalog=Renli;integrated Security=True";
string com = "SELECT * FROM info WHERE ID<" + Convert.ToInt32(tid.Text);
SqlConnection conn = new SqlConnection(con);
conn.Open();
SqlCommand comm = new SqlCommand(com, conn);
SqlDataReader dr = comm.ExecuteReader();
try
{
if (dr.Read())
{
tid.Text = dr["ID"].ToString();
tname.Text = dr["Name"].ToString();
tgender.Text = dr["Gender"].ToString();
tbirthday.Text = dr["Birthday"].ToString();
taddress.Text = dr["Address"].ToString();
tphone.Text = dr["Phone"].ToString();
tmobile.Text = dr["Mobile"].ToString();
temail.Text = dr["Email"].ToString();
teducation.Text = dr["Education"].ToString();
tdegree.Text = dr["Degree"].ToString();
}
else
{
lw.Text = "当前是第一条记录！";
}
}
catch (Exception ex)
{
lw.Text = ex.Message;
}
finally
{
dr.Close();
conn.Close();
}
}
protected void bnext_Click(object sender, EventArgs e)
{
lw.Text = "";
string con = @"server=.;initial Catalog=Renli;integrated Security=True";
string com = "SELECT * FROM info WHERE ID>" + Convert.ToInt32(tid.Text);
SqlConnection conn = new SqlConnection(con);
conn.Open();
SqlCommand comm = new SqlCommand(com, conn);
SqlDataReader dr = comm.ExecuteReader();
try
{
if (dr.Read())
{
if (tid.Text == dr["ID"].ToString())
{
lw.Text = "当前是最后一条记录！";
}
tid.Text = dr["ID"].ToString();
tname.Text = dr["Name"].ToString();
tgender.Text = dr["Gender"].ToString();
tbirthday.Text = dr["Birthday"].ToString();
taddress.Text = dr["Address"].ToString();
tphone.Text = dr["Phone"].ToString();
tmobile.Text = dr["Mobile"].ToString();
temail.Text = dr["Email"].ToString();
teducation.Text = dr["Education"].ToString();
tdegree.Text = dr["Degree"].ToString();
}
else
{
lw.Text = "当前是最后一条记录！";
}
}
catch (Exception ex)
{
lw.Text = ex.Message;
}
finally
{
dr.Close();
conn.Close();
}
}
protected void badd_Click(object sender, EventArgs e)
{
lw.Text = "";
string con = @"server=.;initial Catalog=Renli;integrated Security=True";
string com = "INSERT INTO info([Name],[Gender],[Birthday],[Address],[Phone],[Mobile],[Email],[Education],[degree])VALUES('"+tname.Text+"','"+tgender.Text+"','"+tbirthday.Text+"','"+taddress.Text+"','"+tphone.Text+"','"+tmobile.Text+"','"+temail.Text+"','"+teducation.Text+"','"+tdegree.Text+"')";
SqlConnection conn = new SqlConnection(con);
conn.Open();
SqlCommand comm = new SqlCommand(com, conn);
try
{
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
lw.Text = ex.Message;
}
finally
{
lw.Text = "添加成功！";
conn.Close();
}
}
protected void bdel_Click(object sender, EventArgs e)
{
lw.Text = "";
string con = @"server=.;initial Catalog=Renli;integrated Security=True";
string com = "DELETE FROM info WHERE ID=" + Convert.ToInt32(tid.Text);
SqlConnection conn = new SqlConnection(con);
conn.Open();
SqlCommand comm = new SqlCommand(com, conn);
try
{
comm.ExecuteNonQuery();
tname.Text = "";
tgender.Text = "";
tbirthday.Text = "";
taddress.Text = "";
tphone.Text = "";
tmobile.Text = "";
temail.Text = "";
teducation.Text = "";
tdegree.Text = "";
}
catch (Exception ex)
{
lw.Text = ex.Message;
}
finally
{
lw.Text = "删除成功！";
conn.Close();
}
}
}
}
下载地址：点我下载