/// <summary>
/// 创建用户配送地址
/// </summary>
public static int CreateShipAddress(ShipAddressInfo shipAddressInfo)
{
int saId = BrnShop.Core.BSPData.RDBS.CreateShipAddress(shipAddressInfo);
if (_usernosql != null)
_usernosql.DeleteFullShipAddressList(shipAddressInfo.Uid);
return saId;
}
/// <summary>
/// 添加配送地址
/// </summary>
public ActionResult AddShipAddress()
{
if (WebHelper.IsGet())
{
ShipAddressModel model = new ShipAddressModel();
return View(model);
}
else
{
int regionId = WebHelper.GetFormInt("regionId");
string alias = WebHelper.GetFormString("alias");
string consignee = WebHelper.GetFormString("consignee");
string mobile = WebHelper.GetFormString("mobile");
string phone = WebHelper.GetFormString("phone");
string email = WebHelper.GetFormString("email");
string zipcode = WebHelper.GetFormString("zipcode");
string address = WebHelper.GetFormString("address");
int isDefault = WebHelper.GetFormInt("isDefault");
string verifyResult = VerifyShipAddress(regionId, alias, consignee, mobile, phone, email, zipcode, address);
if (verifyResult.Length == 0)
{
//检查配送地址数量是否达到系统所允许的最大值
int shipAddressCount = ShipAddresses.GetShipAddressCount(WorkContext.Uid);
if (shipAddressCount >= WorkContext.ShopConfig.MaxShipAddress)
return AjaxResult("full", "配送地址的数量已经达到系统所允许的最大值");
ShipAddressInfo shipAddressInfo = new ShipAddressInfo();
shipAddressInfo.Uid = WorkContext.Uid;
shipAddressInfo.RegionId = regionId;
shipAddressInfo.IsDefault = isDefault == 0 ? 0 : 1;
shipAddressInfo.Alias = WebHelper.HtmlEncode(alias);
shipAddressInfo.Consignee = WebHelper.HtmlEncode(consignee);
shipAddressInfo.Mobile = mobile;
shipAddressInfo.Phone = phone;
shipAddressInfo.Email = email;
shipAddressInfo.ZipCode = zipcode;
shipAddressInfo.Address = WebHelper.HtmlEncode(address);
int saId = ShipAddresses.CreateShipAddress(shipAddressInfo);
return AjaxResult("success", saId.ToString());
}
else
{
return AjaxResult("error", verifyResult, true);
}
}
}
/// <summary>
/// 构建用户配送地址信息
/// </summary>
public static ShipAddressInfo BuildShipAddressFromReader(IDataReader reader)
{
ShipAddressInfo shipAddressInfo = new ShipAddressInfo();
shipAddressInfo.SAId = TypeHelper.ObjectToInt(reader["said"]);
shipAddressInfo.Uid = TypeHelper.ObjectToInt(reader["uid"]);
shipAddressInfo.RegionId = TypeHelper.ObjectToInt(reader["regionid"]);
shipAddressInfo.IsDefault = TypeHelper.ObjectToInt(reader["isdefault"]);
shipAddressInfo.Alias = reader["alias"].ToString();
shipAddressInfo.Consignee = reader["consignee"].ToString();
shipAddressInfo.Phone = reader["phone"].ToString();
shipAddressInfo.Mobile = reader["mobile"].ToString();
shipAddressInfo.Email = reader["email"].ToString();
shipAddressInfo.ZipCode = reader["zipcode"].ToString();
shipAddressInfo.Address = reader["address"].ToString();
return shipAddressInfo;
}
/// <summary>
/// 创建用户配送地址
/// </summary>
public int CreateShipAddress(ShipAddressInfo shipAddressInfo)
{
DbParameter[] parms = {
GenerateInParam("@uid", SqlDbType.Int, 4, shipAddressInfo.Uid),
GenerateInParam("@regionid", SqlDbType.SmallInt, 2, shipAddressInfo.RegionId),
GenerateInParam("@isdefault", SqlDbType.TinyInt, 1, shipAddressInfo.IsDefault),
GenerateInParam("@alias", SqlDbType.NVarChar, 50, shipAddressInfo.Alias),
GenerateInParam("@consignee", SqlDbType.NVarChar, 20, shipAddressInfo.Consignee),
GenerateInParam("@mobile", SqlDbType.VarChar, 15, shipAddressInfo.Mobile),
GenerateInParam("@phone", SqlDbType.VarChar, 12, shipAddressInfo.Phone),
GenerateInParam("@email", SqlDbType.VarChar, 50, shipAddressInfo.Email),
GenerateInParam("@zipcode", SqlDbType.Char, 6, shipAddressInfo.ZipCode),
GenerateInParam("@address", SqlDbType.NVarChar, 150, shipAddressInfo.Address)
};
return TypeHelper.ObjectToInt(RdbsHelper.ExecuteScalar(CommandType.StoredProcedure,
string.Format("{0}createshipaddress", RdbsHelper.RdbsTablePre),
parms));
}
/// <summary>
/// 创建用户配送地址
/// </summary>
public static int CreateShipAddress(ShipAddressInfo shipAddressInfo)
{
return BrnShop.Data.ShipAddresses.CreateShipAddress(shipAddressInfo);
}
/// <summary>
/// 更新用户配送地址
/// </summary>
public static void UpdateShipAddress(ShipAddressInfo shipAddressInfo)
{
BrnShop.Data.ShipAddresses.UpdateShipAddress(shipAddressInfo);
}
/// <summary>
/// 更新用户配送地址
/// </summary>
public void UpdateShipAddress(ShipAddressInfo shipAddressInfo)
{
DbParameter[] parms = {
GenerateInParam("@uid", SqlDbType.Int, 4, shipAddressInfo.Uid),
GenerateInParam("@regionid", SqlDbType.SmallInt, 2, shipAddressInfo.RegionId),
GenerateInParam("@isdefault", SqlDbType.TinyInt, 1, shipAddressInfo.IsDefault),
GenerateInParam("@alias", SqlDbType.NVarChar, 50, shipAddressInfo.Alias),
GenerateInParam("@consignee", SqlDbType.NVarChar, 20, shipAddressInfo.Consignee),
GenerateInParam("@mobile", SqlDbType.VarChar, 15, shipAddressInfo.Mobile),
GenerateInParam("@phone", SqlDbType.VarChar, 12, shipAddressInfo.Phone),
GenerateInParam("@email", SqlDbType.VarChar, 50, shipAddressInfo.Email),
GenerateInParam("@zipcode", SqlDbType.Char, 6, shipAddressInfo.ZipCode),
GenerateInParam("@address", SqlDbType.NVarChar, 150, shipAddressInfo.Address),
GenerateInParam("@said", SqlDbType.Int, 4, shipAddressInfo.SAId)
};
RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure,
string.Format("{0}updateshipaddress", RDBSHelper.RDBSTablePre),
parms);
}
/// <summary>
/// 更新用户配送地址
/// </summary>
public static void UpdateShipAddress(ShipAddressInfo shipAddressInfo)
{
BrnShop.Core.BSPData.RDBS.UpdateShipAddress(shipAddressInfo);
if (_usernosql != null)
_usernosql.DeleteFullShipAddressList(shipAddressInfo.Uid);
}
