/// <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");
}
