/// <summary>
/// 修改用户地址
/// </summary>
/// <param name="adders"></param>
/// <returns></returns>]
public int UptdateUserAdder(User_Adders adders)
{
using (OracleConnection conn = DapperHelper.GetConnString())
{
string sql = @"update User_Adders set UserID=:UserID,UserGender=:UserGender,ProvinceID=:,ProvinceID,CityID=:CityID,DistrictID=:DistrictID,ProvinceName=:ProvinceName,Address=:Address,CreateTime=:CreateTime,EditTime=:EditTime, IsDefault=:IsDefault where Id=:Id";
int result = conn.Execute(sql, adders);
return(result);
}
}
/// <summary>
/// 添加地址
/// </summary>
/// <param name="adders"></param>
/// <returns></returns>
public int AddUserAdder(User_Adders adders)
{
using (OracleConnection conn = DapperHelper.GetConnString())
{
string sql = @"insert into User_Adders (UserName,UserGender,ProvinceName,Address,CreateTime, IsDefault,userid) values (:UserName,:UserGender,:ProvinceName,:Address,:CreateTime,:IsDefault,:userid)";
int result = conn.Execute(sql, adders);
return(result);
}
}
public int UptdateUserAdder(User_Adders user_Adders)
{
int result = User_Adders.UptdateUserAdder(user_Adders);
return(result);
}
public int AddUserAdder(User_Adders user_Adders)
{
var result = User_Adders.AddUserAdder(user_Adders);
return(result);
}
