//增加地址信息
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);
}
