//增加地址信息 public int InsertAddress(CTAddress addressInfo) { int insertStatus = 0; SqlParameter[] parms = null; parms = new SqlParameter[] { new SqlParameter("@AddressID", SqlDbType.NVarChar, 20), new SqlParameter("@Province", SqlDbType.NVarChar, 20), new SqlParameter("@City", SqlDbType.NVarChar, 20), }; parms[0].Value = addressInfo.AddressID; parms[1].Value = addressInfo.Province; parms[2].Value = addressInfo.City; try { using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringOrderDistributedTransaction)) { insertStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_INSERT_ADDRESS, parms); } } catch (Exception ex) { } return(insertStatus); }
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 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 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 int UpdateAddressInfo(CTAddress address) { return(dal.UpdateAddress(address)); }
//插入新的地理信息 public int InsertAddressInfo(CTAddress address) { return(dal.InsertAddress(address)); }
public void SaveAddress(CTAddress address) { _entities.CTAddresses.Add(address); }