/// <summary>
/// 查询一个收货地址信息
/// </summary>
/// <param name="aid"></param>
/// <returns></returns>
public static YC_Address SelectOneByAId(int aid)
{
DataTable dt = DAL.AddressServer.SelectOneByAId(aid).Tables[0];
DataRow dr = dt.Rows[0];
YC_Address address = new YC_Address();
address.AID = Convert.ToInt32(dr["AID"].ToString());
address.UID = Convert.ToInt32(dr["UID"].ToString());
address.Address = dr["Address"].ToString();
address.Phone = dr["Phone"].ToString();
address.MailNumber = dr["MailNumber"].ToString();
address.Name = dr["Name"].ToString();
return(address);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnfootAdd_Click(object sender, EventArgs e)
{
//TextBox txtName = txtName as TextBox;
//TextBox txtEmail = GridView1.FooterRow.FindControl("txtEmail") as TextBox;
//TextBox txtPhone = GridView1.FooterRow.FindControl("txtPhone") as TextBox;
//TextBox txtAddress = GridView1.FooterRow.FindControl("txtAddress") as TextBox;
YC_Address address = new YC_Address();
address.Name = txtName.Text;
address.MailNumber = txtEmail.Text;
address.Phone = txtPhone.Text;
address.Address = txtAddress.Text;
address.UID = 1;//这里传入当前用户的id;
if (BLL.AddressBLL.addAddress(address) == 1)
{
bind();
}
}
/// <summary>
/// 增加收货地址
/// </summary>
/// <param name="address"></param>
/// <returns></returns>
public static int addAddress(YC_Address address)
{
return(Convert.ToInt32(DAL.AddressServer.addAddress(address)));
}
//增加一个收货地址
public static object addAddress(YC_Address address)
{
sqltext = " insert into [dbo].[YC_Address](UID,Address,Phone,MailNumber,Name)values('" + address.UID + "','" + address.Address + "','" + address.Phone + "','" + address.MailNumber + "','" + address.Name + "')";
return(SQLHELPER.ExecuteNonQuery(sqltext));
}
