//得到所有的地址的信息
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);
}
