/// <summary> /// 更新一条数据 /// </summary> public bool Update(WalleProject.Model.t_address model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_address set "); strSql.Append("add_u_ID=@add_u_ID,"); strSql.Append("add_contactName=@add_contactName,"); strSql.Append("add_contactPhone=@add_contactPhone,"); strSql.Append("add_date=@add_date,"); strSql.Append("add_postcode=@add_postcode,"); strSql.Append("add_default=@add_default,"); strSql.Append("add_address=@add_address,"); strSql.Append("add_counties=@add_counties,"); strSql.Append("add_city=@add_city,"); strSql.Append("add_province=@add_province"); strSql.Append(" where add_ID=@add_ID"); MySqlParameter[] parameters = { new MySqlParameter("@add_u_ID", MySqlDbType.Int32, 10), new MySqlParameter("@add_contactName", MySqlDbType.VarChar, 10), new MySqlParameter("@add_contactPhone", MySqlDbType.VarChar, 20), new MySqlParameter("@add_date", MySqlDbType.DateTime), new MySqlParameter("@add_postcode", MySqlDbType.Int32, 10), new MySqlParameter("@add_default", MySqlDbType.VarChar, 2), new MySqlParameter("@add_address", MySqlDbType.VarChar, 20), new MySqlParameter("@add_counties", MySqlDbType.VarChar, 10), new MySqlParameter("@add_city", MySqlDbType.VarChar, 10), new MySqlParameter("@add_province", MySqlDbType.VarChar, 10), new MySqlParameter("@add_ID", MySqlDbType.Int32, 10) }; parameters[0].Value = model.add_u_ID; parameters[1].Value = model.add_contactName; parameters[2].Value = model.add_contactPhone; parameters[3].Value = model.add_date; parameters[4].Value = model.add_postcode; parameters[5].Value = model.add_default; parameters[6].Value = model.add_address; parameters[7].Value = model.add_counties; parameters[8].Value = model.add_city; parameters[9].Value = model.add_province; parameters[10].Value = model.add_ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_address DataRowToModel(DataRow row) { WalleProject.Model.t_address model = new WalleProject.Model.t_address(); if (row != null) { if (row["add_u_ID"] != null && row["add_u_ID"].ToString() != "") { model.add_u_ID = int.Parse(row["add_u_ID"].ToString()); } if (row["add_contactName"] != null) { model.add_contactName = row["add_contactName"].ToString(); } if (row["add_contactPhone"] != null) { model.add_contactPhone = row["add_contactPhone"].ToString(); } if (row["add_date"] != null && row["add_date"].ToString() != "") { model.add_date = DateTime.Parse(row["add_date"].ToString()); } if (row["add_postcode"] != null && row["add_postcode"].ToString() != "") { model.add_postcode = int.Parse(row["add_postcode"].ToString()); } if (row["add_default"] != null) { model.add_default = row["add_default"].ToString(); } if (row["add_address"] != null) { model.add_address = row["add_address"].ToString(); } if (row["add_counties"] != null) { model.add_counties = row["add_counties"].ToString(); } if (row["add_city"] != null) { model.add_city = row["add_city"].ToString(); } if (row["add_province"] != null) { model.add_province = row["add_province"].ToString(); } if (row["add_ID"] != null && row["add_ID"].ToString() != "") { model.add_ID = int.Parse(row["add_ID"].ToString()); } } return(model); }
private void ShowInfo(int add_ID) { WalleProject.BLL.t_address bll = new WalleProject.BLL.t_address(); WalleProject.Model.t_address model = bll.GetModel(add_ID); this.txtadd_u_ID.Text = model.add_u_ID.ToString(); this.txtadd_contactName.Text = model.add_contactName; this.txtadd_contactPhone.Text = model.add_contactPhone; this.txtadd_date.Text = model.add_date.ToString(); this.txtadd_postcode.Text = model.add_postcode.ToString(); this.txtadd_default.Text = model.add_default; this.txtadd_address.Text = model.add_address; this.txtadd_counties.Text = model.add_counties; this.txtadd_city.Text = model.add_city; this.txtadd_province.Text = model.add_province; this.lbladd_ID.Text = model.add_ID.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_address GetModel(int add_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select add_u_ID,add_contactName,add_contactPhone,add_date,add_postcode,add_default,add_address,add_counties,add_city,add_province,add_ID from t_address "); strSql.Append(" where add_ID=@add_ID"); MySqlParameter[] parameters = { new MySqlParameter("@add_ID", MySqlDbType.Int32) }; parameters[0].Value = add_ID; WalleProject.Model.t_address model = new WalleProject.Model.t_address(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtadd_u_ID.Text)) { strErr += "用户编号格式错误!\\n"; } if (this.txtadd_contactName.Text.Trim().Length == 0) { strErr += "联系人不能为空!\\n"; } if (this.txtadd_contactPhone.Text.Trim().Length == 0) { strErr += "联系电话不能为空!\\n"; } if (this.txtadd_address.Text.Trim().Length == 0) { strErr += "地址不能为空!\\n"; } if (this.txtadd_counties.Text.Trim().Length == 0) { strErr += "县区不能为空!\\n"; } if (this.txtadd_city.Text.Trim().Length == 0) { strErr += "市不能为空!\\n"; } if (this.txtadd_province.Text.Trim().Length == 0) { strErr += "省不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int add_u_ID = int.Parse(this.txtadd_u_ID.Text); string add_contactName = this.txtadd_contactName.Text; string add_contactPhone = this.txtadd_contactPhone.Text; DateTime add_date = DateTime.Parse(this.txtadd_date.Text); int add_postcode = int.Parse(this.txtadd_postcode.Text); string add_default = this.txtadd_default.Text; string add_address = this.txtadd_address.Text; string add_counties = this.txtadd_counties.Text; string add_city = this.txtadd_city.Text; string add_province = this.txtadd_province.Text; int add_ID = int.Parse(this.lbladd_ID.Text); WalleProject.Model.t_address model = new WalleProject.Model.t_address(); model.add_u_ID = add_u_ID; model.add_contactName = add_contactName; model.add_contactPhone = add_contactPhone; model.add_date = add_date; model.add_postcode = add_postcode; model.add_default = add_default; model.add_address = add_address; model.add_counties = add_counties; model.add_city = add_city; model.add_province = add_province; model.add_ID = add_ID; WalleProject.BLL.t_address bll = new WalleProject.BLL.t_address(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }