protected void Button1_Click(object sender, EventArgs e)
{
string mobile = TextBox1.Text;
string password = TextBox2.Text;
string sql = "select * from studentInfo where mobile='" + mobile + "' and password='******'";
DataSet ds = OperaterBase.GetData(sql);
if (ds.Tables[0].Rows.Count > 0)
{
Label1.Text = "登录成功";
// 存入session，存入登录的手机号
Session["mobile"] = ds.Tables[0].Rows[0]["mobile"];
// 跳转页面
Response.Redirect("/WebForm1.aspx");
}
else
{
Label1.Text = "登录失败";
LinkButton1.Visible = true;
LinkButton2.Visible = true;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string studentNum = TextBox1.Text;
string mobile = TextBox2.Text;
string newPassword = TextBox3.Text;
DataSet ds = OperaterBase.GetData("select * from studentInfo where studentNum='" + studentNum +
"' and mobile='" + mobile + "'");
if (ds.Tables[0].Rows.Count == 0)
{
Label4.Text = "信息不对，请检查";
return;
}
string studentId = ds.Tables[0].Rows[0]["studentID"].ToString();
int num = OperaterBase.CommandBySql("update studentInfo set password='******' where studentID=" + studentId + "");
if (num > 0)
{
Label4.Text = "新密码设置成功，请登录";
Response.Redirect("login.aspx");
}
else
{
Label4.Text = "程序异常";
}
}
/// <summary>
/// 点击按钮上传图片
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button2_Click(object sender, EventArgs e)
{
string filename = avatatUpload();
int ID = Convert.ToInt32(Request["studentID"]);
if (Button1.CommandName == "Update")
{
OperaterBase.CommandBySql("update studentInfo set avatarUrl= '" + filename + "' where studentID=" + ID +
"");
}
}
/// <summary>
/// 获取所有省份
/// </summary>
private void GetAllProvince()
{
string sql = "select * from S_Province";
DataSet ds = OperaterBase.GetData(sql);
// 给下拉框绑定
DropDownList1.DataSource = ds;
// 绑定下拉框文字
DropDownList1.DataTextField = "ProvinceName";
//绑定下拉框value值
DropDownList1.DataValueField = "ProvinceID";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("请选择省份", "0"));
}
/// <summary>
/// 更新用户校验规则
/// </summary>
/// <param name="ID">用户id</param>
/// <param name="v3">用户学号</param>
/// <param name="v5">用户手机号</param>
/// <returns></returns>
private bool UpdateUserRules(int ID, string v1, string v3, string v5)
{
// 不能为空
//string.IsNullOrEmpty(v1) // 为null或者空 条件为true
if (string.IsNullOrEmpty(v1))
{
Label1.Text = "用户名不能为空";
return(false);
}
// 查用户是否存在
DataSet studentListByID =
OperaterBase.GetData("select * from studentInfo where studentID= '" + ID + "'");
if (studentListByID.Tables[0].Rows.Count > 0)
{
//判断学号是否相等我不是我自己我要修改一个新的学号
if (v3 != studentListByID.Tables[0].Rows[0]["studentNum"].ToString())
{
//查询数据库中是否存在这个学号
DataSet studentNumList =
OperaterBase.GetData("select * from studentInfo where studentNum='" + v3 + "'");
if (studentNumList.Tables[0].Rows.Count > 0)
{
Label3.Text = "学号已经重复";
}
else
{
//查询数据库中是否存在这个手机
DataSet mobileList =
OperaterBase.GetData("select * from studentInfo where mobile='" + v5 + "'");
if (mobileList.Tables[0].Rows.Count > 0)
{
Label2.Text = "手机号已经重复";
}
else
{
return(true);
}
}
}
}
else
{
Label1.Text = "用户信息已经被删除，请检查";
}
return(false);
}
/// <summary>
/// 获取选定城市的区县
/// </summary>
private void GetSelectedDistrict()
{
string CityID = DropDownList2.SelectedValue;
string sql = "select * from S_District where CityID=" + CityID + "";
DataSet ds = OperaterBase.GetData(sql);
// 给下拉框绑定
DropDownList3.DataSource = ds;
// 绑定下拉框文字
DropDownList3.DataTextField = "DistrictName";
//绑定下拉框value值
DropDownList3.DataValueField = "DistrictID";
DropDownList3.DataBind();
DropDownList3.Items.Insert(0, new ListItem("请选择地区", "0"));
}
/// <summary>
/// 获取班级信息
/// </summary>
private void getClassInfoData()
{
string sql = "select * from classInfo";
DataSet ds = OperaterBase.GetData(sql);
// 给上面表格绑定
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
// 给下拉框绑定
DropDownList1.DataSource = ds;
// 绑定下拉框文字
DropDownList1.DataTextField = "className";
//绑定下拉框value值
DropDownList1.DataValueField = "classID";
DropDownList1.DataBind();
}
/// <summary>
/// 默认查询
/// </summary>
public void repeaterGetData()
{
//1.修改查询sql语句 只要主表的ID
//2.查看隐藏控件中的ID是否获取到了
/*DataSet ds =
* OperaterBase.GetData(
* "select a.*,b.className from studentInfo a left join classInfo b on a.classID=b.classID where a.IsDelete=0 and b.IsDelete=0");
*/
// 利用视图查询
DataSet ds =
OperaterBase.GetData(
"select * from v_StudentInfo_ClassInfo");
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
var mobile = TextBox1.Text;
if (mobile == "")
{
repeaterGetData();
}
else
{
string sql =
"select a.*,b.className from studentInfo as a left join classInfo as b on a.classID=b.classID where a.IsDelete=0 and b.IsDelete=0 and a.mobile='" +
mobile + "'";
DataSet ds = OperaterBase.GetData(sql);
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
}
/// <summary>
/// 获取选定省份的城市
/// </summary>
private void GetSelectedCity()
{
string ProvinceID = DropDownList1.SelectedValue;
string sql = "select * from S_City where ProvinceID=" + ProvinceID + "";
DataSet ds = OperaterBase.GetData(sql);
// 给下拉框绑定
DropDownList2.DataSource = ds;
// 绑定下拉框文字
DropDownList2.DataTextField = "CityName";
//绑定下拉框value值
DropDownList2.DataValueField = "CityID";
DropDownList2.DataBind();
DropDownList2.Items.Insert(0, new ListItem("请选择城市", "0"));
// 改变省份清除区县
DropDownList3.Items.Clear();
DropDownList3.Items.Insert(0, new ListItem("请选择地区", "0"));
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int studentID = Convert.ToInt32(((HiddenField)e.Item.FindControl("hfStudentId")).Value);
if (e.CommandName == "Delete")
{
string sql = "update studentInfo set IsDelete=1 where studentID=" + studentID + "";
int flag = OperaterBase.CommandBySql(sql);
if (flag > 0)
{
Response.Write("<script type='text/javascript'>alert(成功删除：'" + flag + "'条数据);</script>");
repeaterGetData();
}
}
else if (e.CommandName == "Edit")
{
Response.Redirect("/WebForm2.aspx?studentID=" + studentID + "");
}
}
/// <summary>
/// 修改用户数据
/// </summary>
private void UpdateUser()
{
var ID = Convert.ToInt32(Request["studentID"]);
string sql = "select * from studentInfo where studentID = " + ID + "";
DataSet ds = OperaterBase.GetData(sql);
TextBox1.Text = ds.Tables[0].Rows[0]["studentName"].ToString();
// TextBox2.Text = ds.Tables[0].Rows[0]["classID"].ToString();
DropDownList1.SelectedValue = ds.Tables[0].Rows[0]["classID"].ToString();
TextBox3.Text = ds.Tables[0].Rows[0]["studentNum"].ToString();
TextBox4.Text = ds.Tables[0].Rows[0]["studentSex"].ToString();
TextBox5.Text = ds.Tables[0].Rows[0]["mobile"].ToString();
TextBox6.Text = ds.Tables[0].Rows[0]["password"].ToString();
TextBox7.Text = ds.Tables[0].Rows[0]["birthday"].ToString();
TextBox8.Text = ds.Tables[0].Rows[0]["province"].ToString();
TextBox9.Text = ds.Tables[0].Rows[0]["city"].ToString();
TextBox10.Text = ds.Tables[0].Rows[0]["district"].ToString();
TextBox11.Text = ds.Tables[0].Rows[0]["address"].ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
string DropDownList1Text = DropDownList1.SelectedItem.Text;
string DropDownList2Text = DropDownList2.SelectedItem.Text;
string DropDownList3Text = DropDownList3.SelectedItem.Text;
if (DropDownList1.SelectedValue == "0")
{
DropDownList1Text = "";
}
if (DropDownList2.SelectedValue == "0")
{
DropDownList2Text = "";
}
if (DropDownList3.SelectedValue == "0")
{
DropDownList3Text = "";
}
int num = OperaterBase.CommandBySql("insert into S_Address values (newid(),'" + DropDownList1Text + "','" +
DropDownList2Text + "','" + DropDownList3Text + "')");
}
/// <summary>
/// 提交用户
/// </summary>
private void AddUser()
{
int ID = Convert.ToInt32(Request["studentID"]);
// .Trim()去掉空格
string v1 = TextBox1.Text.Trim();
string v2 = DropDownList1.SelectedValue;
// string v2 = TextBox2.Text.Trim();
string v3 = TextBox3.Text.Trim();
string v4 = TextBox4.Text.Trim();
string v5 = TextBox5.Text.Trim();
string v6 = TextBox6.Text.Trim();
string v7 = TextBox7.Text.Trim();
string v8 = TextBox8.Text.Trim();
string v9 = TextBox9.Text.Trim();
string v10 = TextBox10.Text.Trim();
string v11 = TextBox11.Text.Trim();
if (Button1.CommandName == "Insert")
{
//string.IsNullOrEmpty(v1) // 为null或者空 条件为true
if (string.IsNullOrEmpty(v1))
{
Label1.Text = "用户名不能为空";
return;
}
DataSet isStudentRepeat =
OperaterBase.GetData("select * from studentInfo where studentNum='" + v3 + "'");
if (isStudentRepeat.Tables[0].Rows.Count > 0)
{
Label3.Text = "学号已经注册过,不能重复添加";
return;
}
DataSet isMobileRepeat = OperaterBase.GetData("select * from studentInfo where mobile='" + v5 + "'");
if (isMobileRepeat.Tables[0].Rows.Count > 0)
{
Label2.Text = "手机号码已经注册过,不能重复添加";
return;
}
string sql =
"insert into studentInfo (studentName,classID,studentNum,studentSex,mobile,password,birthday,province,city,district,address) values ('" +
v1 + "','" + v2 + "','" + v3 + "','" + v4 + "','" + v5 + "','" + v6 + "'," + v7 + ",'" + v8 +
"','" + v9 + "','" + v10 + "','" + v11 + "')";
int flag = OperaterBase.CommandBySql(sql);
if (flag > 0)
{
// 跳转页面
Response.Redirect("WebForm1.aspx");
}
}
else if (Button1.CommandName == "Update")
{
// 校验用户规则
if (!UpdateUserRules(ID, v1, v3, v5))
{
return;
}
string sql =
"update studentInfo set studentName='" + v1 + "',classID='" + v2 + "',studentNum='" + v3 +
"',studentSex='" + v4 + "',mobile='" + v5 + "',password='******',birthday='" + v7 +
"',province='" + v8 + "',city='" + v9 + "',district='" + v10 + "',address='" + v11 +
"' where studentID = " + ID + "";
int flag = OperaterBase.CommandBySql(sql);
if (flag > 0)
{
// 跳转页面
Response.Redirect("WebForm1.aspx");
}
}
}
