public bool Update(Model.T_Manager model) { //读取配置文件中的相关节点信息:数据库连接字符串 string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString(); SqlConnection myconn = new SqlConnection(setting); myconn.Open(); SqlCommand cmd = new SqlCommand("update T_Manager set PassWord=@password where Id=@id", myconn); cmd.Parameters.AddWithValue("@password", model.PassWord); cmd.Parameters.AddWithValue("@id", model.Id); if (cmd.ExecuteNonQuery() > 0) { cmd.Dispose(); myconn.Dispose(); return(true); } else { cmd.Dispose(); myconn.Dispose(); return(false); } }
//确定修改密码 protected void UpDate_Click(object sender, EventArgs e) { //输入数据存入Model Model.T_Manager Manager = new Model.T_Manager(); Manager.Id = Convert.ToInt32(S_Id.Value); Manager.UserName = U_Name.Text.Trim(); Manager.PassWord = NewPWD2.Text.Trim(); //Singer.ClassNO = ddlClass.SelectedValue.ToString(); BLL.T_Manager ManagerBll = new BLL.T_Manager(); if (ManagerBll.Update(Manager)) { Response.Write("FAILURE"); Add.Visible = true; UpDate.Visible = false; BindDate(); } else { Response.Write("FAILURE"); } }
public bool Add(Model.T_Manager model) { //读取配置文件中的相关节点信息:数据库连接字符串 string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString(); //创建数据库对象 SqlConnection myconn = new SqlConnection(setting); //打开连接 myconn.Open(); //创建命令对象,并准备好操作数据库的SQL语句 SqlCommand cmd = new SqlCommand("insert into T_Manager([UserName],[PassWord]) values (@username,@password )", myconn); //为SQL语句匹配相关参数,并赋值 cmd.Parameters.AddWithValue("@username", model.UserName); cmd.Parameters.AddWithValue("@password", model.PassWord); //执行相关SQL语句并返回受影响的行数,若受影响行数大于0,则表示执行成功,否者,执行失败 if (cmd.ExecuteNonQuery() > 0) { cmd.Dispose(); myconn.Dispose(); return(true); } else { cmd.Dispose(); myconn.Dispose(); return(false); } }
protected void Add_Click(object sender, EventArgs e) { Model.T_Manager Manager = new Model.T_Manager(); Manager.UserName = U_Name.Text.Trim(); Manager.PassWord = NewPWD2.Text.Trim(); BLL.T_Manager ManagerBll = new BLL.T_Manager(); if (ManagerBll.Add(Manager)) { //上传成功,给出提示 Page.ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(), "DONE", true); BindDate(); //Response.Write("<script><alert>上传成功</alert></script>"); Response.Redirect("Manager.aspx"); } }
protected void GVManager_RowDeleting(object sender, GridViewDeleteEventArgs e) { Model.T_Manager model = new Model.T_Manager(); BLL.T_Manager ManagerBll = new BLL.T_Manager(); model.Id = Convert.ToInt32(ManagerBll.Select(Convert.ToInt32(GVManager.Rows[e.RowIndex].Cells[0].Text)).Tables[0].Rows[0][0].ToString()); if (ManagerBll.Delete(model.Id)) { Response.Write("FAILURE"); BindDate(); } else { Response.Write("FAILURE"); } }
protected void login_Click(object sender, ImageClickEventArgs e) { Model.T_Manager model = new Model.T_Manager(); model.UserName = username.Text; model.PassWord = password.Text; BLL.T_Manager Login = new BLL.T_Manager(); if (Login.select(model)) { Session.Add("username", model.UserName); Response.Redirect("Default.aspx"); } else { Label1.Visible = true; Label1.Text = "用户名或密码错误!"; } }
public bool select(Model.T_Manager model) { //读取配置文件中的相关节点信息:数据库连接字符串 string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString(); SqlConnection myconn = new SqlConnection(setting); myconn.Open(); string username = model.UserName; //string password = model.PassWord; string str = "SELECT [Id] FROM T_Manager WHERE UserName=@username AND PassWord=@password "; SqlCommand cmd = new SqlCommand(str, myconn); cmd.Parameters.AddWithValue("@username", model.UserName.ToString()); cmd.Parameters.AddWithValue("@password", model.PassWord); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); sda.Dispose(); myconn.Dispose(); if (ds.Tables[0].Rows.Count > 0) { return(true); } else { return(false); } }
//有参查找 public bool select(Model.T_Manager model) { return(manger.select(model)); }
//修改,更新 public bool Update(Model.T_Manager model) { return(manger.Update(model)); }
//增加 public bool Add(Model.T_Manager model) { return(manger.Add(model)); }