public int DeleteAddressInfor(MXAddress aa)
{
StringBuilder sql = new StringBuilder();
sql.Append("delete from MXAddress where UserId=@UserId");
SqlParameter[] par = { new SqlParameter("@UserId", SqlDbType.Int, 4) };
par[0].Value = aa.UserId;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//插入用户号于地址表
public int InsertAddressUserId(MXAddress aa)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into MXAddress (UserId) values(@UserId)");
SqlParameter[] par =
{
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
par[0].Value = aa.UserId;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//查看送货地址
public SqlDataReader GetAddressUserId(MXAddress aa)
{
StringBuilder sql = new StringBuilder();
sql.Append(" select * from MXAddress where UserId=@UserId ");
SqlParameter[] par =
{
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
par[0].Value = aa.UserId;
return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par));
}
public int InsertAddress(MXAddress Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into MXAddress (UserId,Address) values(@UserId,@Address)");
SqlParameter[] par =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@Address", SqlDbType.VarChar, 150)
};
par[0].Value = Model.UserId;
par[0].Value = Model.Address;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//更新地址
public int UpdateAddressInfor(MXAddress aa)
{
StringBuilder sql = new StringBuilder();
sql.Append("update MXAddress set Post=@Post,Name=@Name,Mobile=@Mobile,Tel=@Tel,Address=@Address where UserId=@UserId");
SqlParameter[] par =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@Address", SqlDbType.VarChar, 50),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@Post", SqlDbType.VarChar, 50)
};
par[0].Value = aa.UserId;
par[1].Value = aa.Tel;
par[2].Value = aa.Mobile;
par[3].Value = aa.Address;
par[4].Value = aa.Name;
par[5].Value = aa.Post;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//填写送货地址
public int InsertAddressInfor(MXAddress aa)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into MXAddress (UserId,Tel,Mobile,Address,Name,Post) values(@UserId,@Tel,@Mobile,@Address,@Name,@Post)");
SqlParameter[] par =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@Address", SqlDbType.VarChar, 50),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@Post", SqlDbType.VarChar, 50)
};
par[0].Value = aa.UserId;
par[1].Value = aa.Tel;
par[2].Value = aa.Mobile;
par[3].Value = aa.Address;
par[4].Value = aa.Name;
par[5].Value = aa.Post;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
