protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtusername.Text.Trim().Length == 0) { strErr += "username不能为空!\\n"; } if (this.txtuserpass.Text.Trim().Length == 0) { strErr += "userpass不能为空!\\n"; } if (this.txtemail.Text.Trim().Length == 0) { strErr += "email不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string username = this.txtusername.Text; string userpass = this.txtuserpass.Text; string email = this.txtemail.Text; Auction.Model.auction_user model = new Auction.Model.auction_user(); model.username = username; model.userpass = userpass; model.email = email; Auction.BLL.auction_user bll = new Auction.BLL.auction_user(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Auction.Model.auction_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update auction_user set "); strSql.Append("username=@username,"); strSql.Append("userpass=@userpass,"); strSql.Append("email=@email"); strSql.Append(" where user_id=@user_id"); MySqlParameter[] parameters = { new MySqlParameter("@username", MySqlDbType.VarChar, 50), new MySqlParameter("@userpass", MySqlDbType.VarChar, 50), new MySqlParameter("@email", MySqlDbType.VarChar, 100), new MySqlParameter("@user_id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.username; parameters[1].Value = model.userpass; parameters[2].Value = model.email; parameters[3].Value = model.user_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Auction.Model.auction_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into auction_user("); strSql.Append("username,userpass,email)"); strSql.Append(" values ("); strSql.Append("@username,@userpass,@email)"); MySqlParameter[] parameters = { new MySqlParameter("@username", MySqlDbType.VarChar, 50), new MySqlParameter("@userpass", MySqlDbType.VarChar, 50), new MySqlParameter("@email", MySqlDbType.VarChar, 100) }; parameters[0].Value = model.username; parameters[1].Value = model.userpass; parameters[2].Value = model.email; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int user_id) { Auction.BLL.auction_user bll = new Auction.BLL.auction_user(); Auction.Model.auction_user model = bll.GetModel(user_id); this.lbluser_id.Text = model.user_id.ToString(); this.lblusername.Text = model.username; this.lbluserpass.Text = model.userpass; this.lblemail.Text = model.email; }
/// <summary> /// 得到一个对象实体 /// </summary> public Auction.Model.auction_user DataRowToModel(DataRow row) { Auction.Model.auction_user model = new Auction.Model.auction_user(); if (row != null) { if (row["user_id"] != null && row["user_id"].ToString() != "") { model.user_id = int.Parse(row["user_id"].ToString()); } if (row["username"] != null) { model.username = row["username"].ToString(); } if (row["userpass"] != null) { model.userpass = row["userpass"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Auction.Model.auction_user GetModel(int user_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select user_id,username,userpass,email from auction_user "); strSql.Append(" where user_id=@user_id"); MySqlParameter[] parameters = { new MySqlParameter("@user_id", MySqlDbType.Int32) }; parameters[0].Value = user_id; Auction.Model.auction_user model = new Auction.Model.auction_user(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }