/// <summary> /// 创建用户配送地址 /// </summary> public static int CreateShipAddress(ShipAddressInfo shipAddressInfo) { int saId = BrnMall.Core.BMAData.RDBS.CreateShipAddress(shipAddressInfo); if (_usernosql != null) _usernosql.DeleteFullShipAddressList(shipAddressInfo.Uid); return saId; }
private static IUserNOSQLStrategy _usernosql = BMAData.UserNOSQL;//用户非关系型数据库 #region 辅助方法 /// <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 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) { BrnMall.Core.BMAData.RDBS.UpdateShipAddress(shipAddressInfo); if (_usernosql != null) _usernosql.DeleteFullShipAddressList(shipAddressInfo.Uid); }
/// <summary> /// 添加配送地址 /// </summary> public ActionResult AddShipAddress() { 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.MallConfig.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 void UpdateShipAddress(ShipAddressInfo shipAddressInfo) { BrnMall.Data.ShipAddresses.UpdateShipAddress(shipAddressInfo); }
/// <summary> /// 创建用户配送地址 /// </summary> public static int CreateShipAddress(ShipAddressInfo shipAddressInfo) { return BrnMall.Data.ShipAddresses.CreateShipAddress(shipAddressInfo); }