//得到所有的地址的信息 public List<CTAddress> GetAllAddressInfo() { List<CTAddress> addressList = new List<CTAddress>(); try { using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ADDRESS, null)) { while (rdr.Read()) { CTAddress address = new CTAddress(); address.AddressID = rdr["AddressID"].ToString(); address.Province = rdr["Province"].ToString(); address.City = rdr["City"].ToString(); address.FatherID = rdr["FatherID"].ToString(); bool tempIsVisible = true; address.IsVisible = bool.TryParse(rdr["Visible"].ToString(), out tempIsVisible) ? tempIsVisible : true; addressList.Add(address); } } } catch (Exception ex) { } return addressList; }
protected void BtnAdd_Click(object sender, EventArgs e) { string province = tbProvince.Text.Trim().ToString(); string area = tbArea.Text.Trim().ToString(); string addressID = tbPostCode.Text.Trim().ToString(); CTAddress address = new CTAddress(); address.AddressID = addressID; address.Province = province; address.City = area; Address caddress = new Address(); int insertStatus=caddress.InsertAddressInfo(address); if (insertStatus != 0) { LoadData(); Response.Write("<script>alert('添加成功!')</script>"); } else { Response.Write("<script>alert('添加失败!')</script>"); } }
//根据省份获取地区名称 public List<CTAddress> GetUserInfoByProvince(string provinceName) { List<CTAddress> addressList = new List<CTAddress>(); SqlParameter param = new SqlParameter(); param.Value = provinceName; try { using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ADDRESS_BY_PROVINCE, param)) { while (rdr.Read()) { CTAddress address = new CTAddress(); address.AddressID = rdr["AddressID"].ToString(); address.Province = rdr["Province"].ToString(); address.City = rdr["City"].ToString(); address.FatherID = rdr["FatherID"].ToString(); bool tempIsVisible = true; address.IsVisible = bool.TryParse(rdr["Visible"].ToString(), out tempIsVisible) ? tempIsVisible : true; addressList.Add(address); } } } catch (Exception ex) { } return addressList; }
//更新地址信息 public int UpdateAddress(CTAddress addressInfo) { int updateStatus = 0; SqlParameter[] parms = null; parms = new SqlParameter[] { new SqlParameter("@Province",SqlDbType.NVarChar,20), new SqlParameter("@City",SqlDbType.NVarChar,20), new SqlParameter("@Visible",SqlDbType.Bit), new SqlParameter("@AddressID",SqlDbType.NVarChar,20), }; parms[0].Value = addressInfo.Province; parms[1].Value = addressInfo.City; parms[2].Value = addressInfo.IsVisible; parms[3].Value = addressInfo.AddressID; try { using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringOrderDistributedTransaction)) { updateStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_UPDATE_ADDRESS, parms); } } catch (Exception ex) { } return updateStatus; }
protected void btnSave_Click(object sender, EventArgs e) { string addressID = tbEditPostCode.Text.Trim().ToString(); string province = tbEditProvince.Text.Trim().ToString(); string city = tbEditCity.Text.Trim().ToString(); bool isVisible = bool.Parse(cbIsvisible.Checked.ToString()); CTAddress cta = new CTAddress(); cta.City = city; cta.Province = province; cta.AddressID = addressID; cta.IsVisible = isVisible; Address address = new Address(); int insertStatus= address.UpdateAddressInfo(cta); if (insertStatus != 0) { LoadData(); Response.Write("<script>alert('update成功!')</script>"); } else { Response.Write("<script>alert('update失败!')</script>"); } }
//更新地理信息 public int UpdateAddressInfo(CTAddress address) { return dal.UpdateAddress(address); }
//插入新的地理信息 public int InsertAddressInfo(CTAddress address) { return dal.InsertAddress(address); }