/// <summary> /// 更新一条数据 /// </summary> public bool Update(BookShop.Model.Member model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Member set "); strSql.Append("memPassword=@memPassword,"); strSql.Append("memName=@memName,"); strSql.Append("sex=@sex,"); strSql.Append("birthday=@birthday,"); strSql.Append("telephone=@telephone,"); strSql.Append("email=@email,"); strSql.Append("address=@address,"); strSql.Append("zipCode=@zipCode,"); strSql.Append("totalAmount=@totalAmount,"); strSql.Append("memLevel=@memLevel,"); strSql.Append("discount=@discount"); strSql.Append(" where memberNo=@memberNo "); SqlParameter[] parameters = { new SqlParameter("@memPassword", SqlDbType.VarChar, 10), new SqlParameter("@memName", SqlDbType.VarChar, 12), new SqlParameter("@sex", SqlDbType.Char, 1), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telephone", SqlDbType.VarChar, 15), new SqlParameter("@email", SqlDbType.VarChar, 20), new SqlParameter("@address", SqlDbType.VarChar, 40), new SqlParameter("@zipCode", SqlDbType.Char, 6), new SqlParameter("@totalAmount", SqlDbType.Decimal, 9), new SqlParameter("@memLevel", SqlDbType.Char, 1), new SqlParameter("@discount", SqlDbType.Float, 8), new SqlParameter("@memberNo", SqlDbType.Char, 9) }; parameters[0].Value = model.memPassword; parameters[1].Value = model.memName; parameters[2].Value = model.sex; parameters[3].Value = model.birthday; parameters[4].Value = model.telephone; parameters[5].Value = model.email; parameters[6].Value = model.address; parameters[7].Value = model.zipCode; parameters[8].Value = model.totalAmount; parameters[9].Value = model.memLevel; parameters[10].Value = model.discount; parameters[11].Value = model.memberNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BookShop.Model.Member DataRowToModel(DataRow row) { BookShop.Model.Member model = new BookShop.Model.Member(); if (row != null) { if (row["memberNo"] != null) { model.memberNo = row["memberNo"].ToString(); } if (row["memPassword"] != null) { model.memPassword = row["memPassword"].ToString(); } if (row["memName"] != null) { model.memName = row["memName"].ToString(); } if (row["sex"] != null) { model.sex = row["sex"].ToString(); } if (row["birthday"] != null && row["birthday"].ToString() != "") { model.birthday = DateTime.Parse(row["birthday"].ToString()); } if (row["telephone"] != null) { model.telephone = row["telephone"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["zipCode"] != null) { model.zipCode = row["zipCode"].ToString(); } if (row["totalAmount"] != null && row["totalAmount"].ToString() != "") { model.totalAmount = decimal.Parse(row["totalAmount"].ToString()); } if (row["memLevel"] != null) { model.memLevel = row["memLevel"].ToString(); } if (row["discount"] != null && row["discount"].ToString() != "") { model.discount = decimal.Parse(row["discount"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(BookShop.Model.Member model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Member("); strSql.Append("memberNo,memPassword,memName,sex,birthday,telephone,email,address,zipCode,totalAmount,memLevel,discount)"); strSql.Append(" values ("); strSql.Append("@memberNo,@memPassword,@memName,@sex,@birthday,@telephone,@email,@address,@zipCode,@totalAmount,@memLevel,@discount)"); SqlParameter[] parameters = { new SqlParameter("@memberNo", SqlDbType.Char, 9), new SqlParameter("@memPassword", SqlDbType.VarChar, 10), new SqlParameter("@memName", SqlDbType.VarChar, 12), new SqlParameter("@sex", SqlDbType.Char, 1), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telephone", SqlDbType.VarChar, 15), new SqlParameter("@email", SqlDbType.VarChar, 20), new SqlParameter("@address", SqlDbType.VarChar, 40), new SqlParameter("@zipCode", SqlDbType.Char, 6), new SqlParameter("@totalAmount", SqlDbType.Decimal, 9), new SqlParameter("@memLevel", SqlDbType.Char, 1), new SqlParameter("@discount", SqlDbType.Float, 8) }; parameters[0].Value = model.memberNo; parameters[1].Value = model.memPassword; parameters[2].Value = model.memName; parameters[3].Value = model.sex; parameters[4].Value = model.birthday; parameters[5].Value = model.telephone; parameters[6].Value = model.email; parameters[7].Value = model.address; parameters[8].Value = model.zipCode; parameters[9].Value = model.totalAmount; parameters[10].Value = model.memLevel; parameters[11].Value = model.discount; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(string memberNo) { BookShop.BLL.Member bll = new BookShop.BLL.Member(); BookShop.Model.Member model = bll.GetModel(memberNo); this.lblmemberNo.Text = model.memberNo; this.lblmemPassword.Text = model.memPassword; this.lblmemName.Text = model.memName; this.lblsex.Text = model.sex; this.lblbirthday.Text = model.birthday.ToString(); this.lbltelephone.Text = model.telephone; this.lblemail.Text = model.email; this.lbladdress.Text = model.address; this.lblzipCode.Text = model.zipCode; this.lbltotalAmount.Text = model.totalAmount.ToString(); this.lblmemLevel.Text = model.memLevel; this.lbldiscount.Text = model.discount.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public BookShop.Model.Member GetModel(string memberNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 memberNo,memPassword,memName,sex,birthday,telephone,email,address,zipCode,totalAmount,memLevel,discount from Member "); strSql.Append(" where memberNo=@memberNo "); SqlParameter[] parameters = { new SqlParameter("@memberNo", SqlDbType.Char, 9) }; parameters[0].Value = memberNo; BookShop.Model.Member model = new BookShop.Model.Member(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtmemberNo.Text.Trim().Length == 0) { strErr += "memberNo不能为空!\\n"; } if (this.txtmemPassword.Text.Trim().Length == 0) { strErr += "memPassword不能为空!\\n"; } if (this.txtmemName.Text.Trim().Length == 0) { strErr += "memName不能为空!\\n"; } if (this.txtsex.Text.Trim().Length == 0) { strErr += "sex不能为空!\\n"; } if (!PageValidate.IsDateTime(txtbirthday.Text)) { strErr += "birthday格式错误!\\n"; } if (this.txttelephone.Text.Trim().Length == 0) { strErr += "telephone不能为空!\\n"; } if (this.txtemail.Text.Trim().Length == 0) { strErr += "email不能为空!\\n"; } if (this.txtaddress.Text.Trim().Length == 0) { strErr += "address不能为空!\\n"; } if (this.txtzipCode.Text.Trim().Length == 0) { strErr += "zipCode不能为空!\\n"; } if (!PageValidate.IsDecimal(txttotalAmount.Text)) { strErr += "totalAmount格式错误!\\n"; } if (this.txtmemLevel.Text.Trim().Length == 0) { strErr += "memLevel不能为空!\\n"; } if (!PageValidate.IsDecimal(txtdiscount.Text)) { strErr += "discount格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string memberNo = this.txtmemberNo.Text; string memPassword = this.txtmemPassword.Text; string memName = this.txtmemName.Text; string sex = this.txtsex.Text; DateTime birthday = DateTime.Parse(this.txtbirthday.Text); string telephone = this.txttelephone.Text; string email = this.txtemail.Text; string address = this.txtaddress.Text; string zipCode = this.txtzipCode.Text; decimal totalAmount = decimal.Parse(this.txttotalAmount.Text); string memLevel = this.txtmemLevel.Text; decimal discount = decimal.Parse(this.txtdiscount.Text); BookShop.Model.Member model = new BookShop.Model.Member(); model.memberNo = memberNo; model.memPassword = memPassword; model.memName = memName; model.sex = sex; model.birthday = birthday; model.telephone = telephone; model.email = email; model.address = address; model.zipCode = zipCode; model.totalAmount = totalAmount; model.memLevel = memLevel; model.discount = discount; BookShop.BLL.Member bll = new BookShop.BLL.Member(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }