//提交专业
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataReader read = db.ExceRead("select * from Major where Name='" + this.TextBox1.Text + "'");
read.Read();
if (read.HasRows)
{
if (this.TextBox1.Text == read["Name"].ToString())
{
Response.Write("<script>alert('该专业已存在！')</script>");
Response.Write("<script>window.location.href='Major_add.aspx'</script>");
}
}
else if (TextBox1.Text == "")
{
Response.Write("<script>alert('请填写完整信息！')</script>");
Response.Write("<script>window.location.href='Major_add.aspx'</script>");
}
else
{
db.eccom("insert into Major(Name) values ('" + this.TextBox1.Text + "')");
Response.Write("<script>alert('添加成功！')</script>");
Response.Write("<script>window.location.href='Major_add.aspx'</script>");
}
read.Close();
}
protected void ImageButton1_Click(object sender, EventArgs e)
{
SqlDataReader read = db.ExceRead("select *from Teacher where id='" + this.TextBox1.Text + "'");
read.Read();
if (read.HasRows)
{
if (this.TextBox1.Text == read["id"].ToString())
{
Response.Write("<script>alert('该用户已存在！')</script>");
Response.Write("<script>window.location.href='Teacher_add.aspx'</script>");
}
}
else if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "")
{
Response.Write("<script>alert('请填写完整信息！')</script>");
Response.Write("<script>window.location.href='Teacher_add.aspx'</script>");
}
else
{
db.eccom("insert into Teacher(id,name,pwd,JoinTime,degree) values ('" + this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + this.TextBox3.Text + "' ,'" + DateTime.Now.ToString() + "','" + DropDownList1.SelectedItem + "')");
Response.Write("<script>alert('添加成功！')</script>");
Response.Write("<script>window.location.href='Teacher_add.aspx'</script>");
}
read.Close();
}
protected void ImageButton1_Click(object sender, EventArgs e)
{
SqlDataReader read = db.ExceRead("select * from Admin where ID='" + this.TextBox1.Text + "'");
read.Read();
if (read.HasRows)
{
if (this.TextBox1.Text == read["ID"].ToString())
{
Response.Write("<script>alert('该用户已存在！')</script>");
Response.Write("<script>window.location.href='admin_add.aspx'</script>");
}
}
else if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "")
{
Response.Write("<script>alert('请填写完整信息！')</script>");
Response.Write("<script>window.location.href='admin_add.aspx'</script>");
}
else
{
db.eccom("insert into Admin(ID,Name,PWD,JoinTime) values ('" + this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + this.TextBox3.Text + "' ,'" + DateTime.Now.ToString() + "')");
Response.Write("<script>alert('添加成功！')</script>");
Response.Write("<script>window.location.href='admin_add.aspx'</script>");
}
read.Close();
}
protected void Button3_Click(object sender, EventArgs e)
{
Label8.Visible = false;
Label7.Visible = false;
if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "")
{
Label8.Visible = true;
}
else
{
MySqlDataReader read = dataconn.ExceRead("select max(store_id) from store");
read.Read();
int a, c;
c = int.Parse(TextBox2.Text);
bool b;
a = (int)read["max(store_id)"];
b = dataconn.eccom("insert into store(store_id,street,postcode,name,c_id)values("
+ (a + 1) + ",'" + this.TextBox1.Text + "',"
+ c + ",'" + this.TextBox3.Text + "','"
+ DropDownList2.SelectedValue + "')");
if (b)
{
Label7.Visible = true;
}
Label7.Text = "Successful! The store ID is:" + (a + 1);
}
}
//检测账号是否存在按钮
protected void Button1_Click1(object sender, EventArgs e)
{
SqlDataReader read = dataconn.ExceRead("select * from tb_Student where ID='" + this.txtStuID.Text + "'");
read.Read();
if (read.HasRows)
{
if (this.txtStuID.Text == read["ID"].ToString())
{
Label2.Visible = true;
}
}
else
{
Label3.Visible = true;
}
read.Close();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SqlDataReader read = db.ExceRead("select * from Course where c_name='" + this.TextBox2.Text + "'");
read.Read();
if (read.HasRows)
{
if (this.TextBox2.Text == read["c_name"].ToString())
{
Response.Write("<script>alert('该用户已存在！')</script>");
Response.Write("<script>window.location.href='AddCourse.aspx'</script>");
}
}
else
{
db.eccom("insert into Course(c_name,c_date,teacher_id) values ('" + this.TextBox2.Text + "','" + DateTime.Now.ToString() + "','" + Session["ID"].ToString() + "')");
Response.Write("<script>alert('添加成功！')</script>");
Response.Write("<script>window.location.href='AddCourse.aspx'</script>");
}
read.Close();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SqlDataReader read = dataconn.ExceRead("select *from Student where ID='" + this.txtStuID.Text + "'");
read.Read();
if (read.HasRows)
{
if (this.txtStuID.Text == read["ID"].ToString())
{
Response.Write("<script>alert('该用户已存在！')</script>");
Response.Write("<script>window.location.href='AddStudent.aspx'</script>");
}
}
else
{
dataconn.eccom("insert into Student(ID,Name,PWD,Sex,JoinTime,Question,Answer,profession) values ('" + this.txtStuID.Text + "','" + this.txtStuName.Text + "','" + this.txtStuPwd.Text + "' ,'" + Request["DropDownList1"] + "','" + DateTime.Now.ToString() + "','" + Request["DropDownList3"] + "','" + this.txtAnsPwd.Text + "','" + Request["ddlProfession"] + "')");
Session["ID"] = txtStuID.Text;
Session["PWD"] = txtStuPwd.Text;
Response.Write("<script>alert('添加成功！')</script>");
Response.Write("<script>window.location.href='AddStudent.aspx'</script>");
}
read.Close();
}
//导入
protected void Button1_Click(object sender, EventArgs e)
{
int A = 0;//导入成功数
string cunzai = "";
try
{
string fileName1 = fileName;
//根据路径打开一个Excel文件并将数据填充到DataSet中
//string strConn = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'", excelFilePath);
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = " + fileName1 + ";Extended Properties ='Excel 8.0;HDR=NO;IMEX=1'";//导入时包含Excel中的第一行数据，并且将数字和字符混合的单元格视为文本进行导入
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "select * from [sheet1$]";
OleDbDataAdapter comm = new OleDbDataAdapter(strExcel, strConn);
DataSet ds = new DataSet();
for (int i = 1; i < GridView1.Rows.Count; i++)
{
try
{
SqlDataReader read = db.ExceRead("select * from Admin where ID='" + GridView1.Rows[i].Cells[0].Text.ToString() + "'");
read.Read();
if (read.HasRows)
{
if (GridView1.Rows[i].Cells[0].Text.ToString() == read["ID"].ToString())
{
//Response.Write("<script>alert('" + "ID：" + GridView1.Rows[i].Cells[0].Text.ToString() + "已存在！')</script>");
cunzai += GridView1.Rows[i].Cells[0].Text.ToString() + "、";
}
}
else if (GridView1.Rows[i].Cells[0].Text.ToString() == "" || GridView1.Rows[i].Cells[1].Text.ToString() == "" || GridView1.Rows[i].Cells[2].Text.ToString() == "")
{
Response.Write("<script>alert('" + "ID：" + GridView1.Rows[i].Cells[0].Text.ToString() + "信息不完整！" + "')</script>");
}
else
{
db.eccom("insert into Admin(ID,Name,PWD,JoinTime) values ('" + GridView1.Rows[i].Cells[0].Text.ToString() + "','" + GridView1.Rows[i].Cells[1].Text.ToString() + "','" + GridView1.Rows[i].Cells[2].Text.ToString() + "' ,'" + DateTime.Now.ToString() + "')");
A++;//导入成功
}
}
catch (Exception) {
Response.Write("<script>alert('" + "ID：" + GridView1.Rows[i].Cells[0].Text.ToString() + " 失败！" + "');</script>");
}
}
conn.Close();
}
catch
{
Response.Write("<script>alert('失败');</script>");
}
Response.Write("<script>alert('成功导入:" + A + " 失败：" + (GridView1.Rows.Count - A - 1) + "');</script>");
if (cunzai.Length > 1)
{
Response.Write("<script>alert('添加失败 ID：" + cunzai.Substring(0, cunzai.Length - 1) + "');</script>");
}
//删除导入文件
DeleteFile(fileName);
}
