/// <summary>
/// 注册
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnRegister_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtUserName.Text))
{
Response.Write("<script>alert('请输入用户名')</script>");
return;
}
if (string.IsNullOrWhiteSpace(txtUserPwd.Value))
{
Response.Write("<script>alert('请输入密码')</script>");
return;
}
int id = SimpleSqlserverHelper.ExecuteNonQuery("Insert into Users (UserName,UserPwd)Values('" + txtUserName.Text + "','" + txtUserPwd.Value + "')");
if (id > 0)
{
Response.Write("<script>alert('注册成功')</script>");
Response.Redirect("Default.aspx");
}
else
{
Response.Write("<script>alert('注册失败')</script>");
}
}
//绑定
public void dataBinds()
{
string sql = "select * from TempHumData ";
DataSet ds = SimpleSqlserverHelper.ExecuteDataset(sql);
if (ds != null)
{
gvwUsers.DataSource = ds.Tables[0];
gvwUsers.DataKeyNames = new string[] { "Id" };//主键
gvwUsers.DataBind();
}
}
/// <summary>
/// 登录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnLogin_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtUserName.Text))
{
Response.Write("<script>alert('请输入用户名')</script>");
return;
}
if (string.IsNullOrWhiteSpace(txtpwd.Value))
{
Response.Write("<script>alert('请输入密码')</script>");
return;
}
//sql查询语句
string sql = "select UserId from Users where UserName=@username and UserPwd=@userpwd";
//设置参数
SqlParameter[] paras = new SqlParameter[]
{
//记录数据ID
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@userpwd", SqlDbType.NVarChar, 50)
};
paras[0].Value = txtUserName.Text;
paras[1].Value = txtpwd.Value;
DataSet ds = SimpleSqlserverHelper.ExecuteDataset(sql, paras);
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
Response.Write("<script>alert('登录成功')</script>");
Response.Redirect("ListShow.aspx");
}
else
{
Response.Write("<script>alert('登录失败')</script>");
}
}
/// <summary>
/// 取消
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
//protected void gvwUsers_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
//{
// gvwUsers.EditIndex = -1;
// dataBinds();
//}
/// <summary>
///删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvwUsers_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
sqlWhere = "delete from TempHumData where Id='" + gvwUsers.DataKeys[e.RowIndex].Value.ToString() + "'";
SimpleSqlserverHelper.ExecuteNonQuery(sqlWhere);
dataBinds();
}
