public static bool CreateShippingAddress(ShippingAddressInfo shippingAddress) { if (null == shippingAddress) { return false; } Globals.EntityCoding(shippingAddress, true); return PersonalProvider.Instance().CreateUpdateDeleteShippingAddress(shippingAddress, DataProviderAction.Create); }
public static int AddShippingAddress(ShippingAddressInfo shippingAddress) { if (null == shippingAddress) { return 0; } Globals.EntityCoding(shippingAddress, true); return PersonalProvider.Instance().AddShippingAddress(shippingAddress); }
public static int AddShippingAddress(ShippingAddressInfo shippingAddress) { ShippingAddressDao dao = new ShippingAddressDao(); int shippingId = dao.AddShippingAddress(shippingAddress); if (dao.SetDefaultShippingAddress(shippingId, Globals.GetCurrentMemberUserId())) { return 1; } return 0; }
public override int AddShippingAddress(ShippingAddressInfo shippingAddress) { DbCommand sqlStringCommand = database.GetSqlStringCommand("INSERT INTO distro_ShippingAddresses(RegionId,UserId,ShipTo,Address,Zipcode,EmailAddress,TelPhone,CellPhone) VALUES(@RegionId,@UserId,@ShipTo,@Address,@Zipcode,@EmailAddress,@TelPhone,@CellPhone); SELECT @@IDENTITY"); database.AddInParameter(sqlStringCommand, "RegionId", DbType.Int32, shippingAddress.RegionId); database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, shippingAddress.UserId); database.AddInParameter(sqlStringCommand, "ShipTo", DbType.String, shippingAddress.ShipTo); database.AddInParameter(sqlStringCommand, "Address", DbType.String, shippingAddress.Address); database.AddInParameter(sqlStringCommand, "Zipcode", DbType.String, shippingAddress.Zipcode); database.AddInParameter(sqlStringCommand, "TelPhone", DbType.String, shippingAddress.TelPhone); database.AddInParameter(sqlStringCommand, "CellPhone", DbType.String, shippingAddress.CellPhone); return Convert.ToInt32(database.ExecuteScalar(sqlStringCommand)); }
public int AddShippingAddress(ShippingAddressInfo shippingAddress) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Hishop_UserShippingAddresses(RegionId,UserId,ShipTo,Address,Zipcode,TelPhone,CellPhone,IsDefault) VALUES(@RegionId,@UserId,@ShipTo,@Address,@Zipcode,@TelPhone,@CellPhone,@IsDefault); SELECT @@IDENTITY"); this.database.AddInParameter(sqlStringCommand, "RegionId", DbType.Int32, shippingAddress.RegionId); this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, shippingAddress.UserId); this.database.AddInParameter(sqlStringCommand, "ShipTo", DbType.String, shippingAddress.ShipTo); this.database.AddInParameter(sqlStringCommand, "Address", DbType.String, shippingAddress.Address); this.database.AddInParameter(sqlStringCommand, "Zipcode", DbType.String, shippingAddress.Zipcode); this.database.AddInParameter(sqlStringCommand, "TelPhone", DbType.String, shippingAddress.TelPhone); this.database.AddInParameter(sqlStringCommand, "CellPhone", DbType.String, shippingAddress.CellPhone); this.database.AddInParameter(sqlStringCommand, "IsDefault", DbType.Boolean, shippingAddress.IsDefault); return Convert.ToInt32(this.database.ExecuteScalar(sqlStringCommand)); }
public bool UpdateShippingAddress(ShippingAddressInfo shippingAddress) { StringBuilder builder = new StringBuilder(); builder.Append("update Hishop_UserShippingAddresses"); builder.Append(" set ShipTo=@ShipTo,"); builder.Append("Address=@Address,"); builder.Append("Zipcode=@Zipcode,"); builder.Append("TelPhone=@TelPhone,"); builder.Append("CellPhone=@CellPhone,"); builder.Append(" RegionId=@RegionId"); builder.Append(" where shippingId=@shippingId"); builder.Append(" and UserId=@UserId"); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString()); this.database.AddInParameter(sqlStringCommand, "RegionId", DbType.Int32, shippingAddress.RegionId); this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, shippingAddress.UserId); this.database.AddInParameter(sqlStringCommand, "ShipTo", DbType.String, shippingAddress.ShipTo); this.database.AddInParameter(sqlStringCommand, "Address", DbType.String, shippingAddress.Address); this.database.AddInParameter(sqlStringCommand, "Zipcode", DbType.String, shippingAddress.Zipcode); this.database.AddInParameter(sqlStringCommand, "TelPhone", DbType.String, shippingAddress.TelPhone); this.database.AddInParameter(sqlStringCommand, "CellPhone", DbType.String, shippingAddress.CellPhone); this.database.AddInParameter(sqlStringCommand, "shippingId", DbType.Int32, shippingAddress.ShippingId); return (this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public static ShippingAddressInfo PopulateShippingAddress(IDataRecord reader) { if (null == reader) { return null; } ShippingAddressInfo info = new ShippingAddressInfo { ShippingId = (int) reader["ShippingId"], ShipTo = (string) reader["ShipTo"], RegionId = (int) reader["RegionId"], UserId = (int) reader["UserId"], Address = (string) reader["Address"], Zipcode = (string) reader["Zipcode"], IsDefault = (bool) reader["IsDefault"] }; if (reader["TelPhone"] != DBNull.Value) { info.TelPhone = (string) reader["TelPhone"]; } if (reader["CellPhone"] != DBNull.Value) { info.CellPhone = (string) reader["CellPhone"]; } return info; }
ShippingAddressInfo GetShippingAddressInfo() { ShippingAddressInfo info = new ShippingAddressInfo(); info.UserId = HiContext.Current.User.UserId; info.ShipTo = this.txtShipTo.Text; info.RegionId = this.dropRegionsSelect.GetSelectedRegionId().Value; info.Address = this.txtAddress.Text; info.Zipcode = this.txtZipcode.Text; info.CellPhone = this.txtCellPhone.Text; info.TelPhone = this.txtTelPhone.Text; return info; }
public static ShippingAddressInfo PopulateShippingAddress(IDataRecord reader) { if (null == reader) { return null; } ShippingAddressInfo info = new ShippingAddressInfo(); info.ShippingId = (int) reader["ShippingId"]; info.ShipTo = (string) reader["ShipTo"]; info.RegionId = (int) reader["RegionId"]; info.UserId = (int) reader["UserId"]; info.Address = (string) reader["Address"]; info.Zipcode = (string) reader["Zipcode"]; if (reader["TelPhone"] != DBNull.Value) { info.TelPhone = (string) reader["TelPhone"]; } if (reader["CellPhone"] != DBNull.Value) { info.CellPhone = (string) reader["CellPhone"]; } return info; }
public static bool DeleteShippingAddress(int shippingId) { ShippingAddressInfo shippingAddress = new ShippingAddressInfo(); shippingAddress.ShippingId = shippingId; return PersonalProvider.Instance().CreateUpdateDeleteShippingAddress(shippingAddress, DataProviderAction.Delete); }
public abstract bool CreateUpdateDeleteShippingAddress(ShippingAddressInfo shippingAddress, DataProviderAction action);
public void btnCreateOrder_Click(object sender, EventArgs e) { if (ValidateCreateOrder()) { OrderInfo orderInfo = GetOrderInfo(shoppingCart); if (shoppingCart.Quantity > 1) { isSignBuy = false; } if (orderInfo == null) { ShowMessage("购物车中已经没有任何商品", false); } else if (!HiContext.Current.User.IsAnonymous && (shoppingCart.GetTotalNeedPoint() > ((Member)HiContext.Current.User).Points)) { ShowMessage("您当前的积分不够兑换所需积分!", false); } else if (isCountDown && (ProductBrowser.GetCountDownInfo(shoppingCart.LineItems[productSku].ProductId).EndDate < DateTime.Now)) { ShowMessage("此订单为抢购订单,但抢购时间已到!", false); } else { try { if (ShoppingProcessor.CreatOrder(orderInfo)) { Messenger.OrderCreated(orderInfo, HiContext.Current.User); orderInfo.OnCreated(); if (shoppingCart.GetTotalNeedPoint() > 0) { ShoppingProcessor.CutNeedPoint(shoppingCart.GetTotalNeedPoint()); } if ((!isCountDown && !isGroupBuy) && !isSignBuy) { ShoppingCartProcessor.ClearShoppingCart(); } if (!HiContext.Current.User.IsAnonymous && (PersonalHelper.GetShippingAddressCount(HiContext.Current.User.UserId) == 0)) { ShippingAddressInfo shippingAddress = new ShippingAddressInfo(); shippingAddress.UserId = HiContext.Current.User.UserId; shippingAddress.ShipTo = Globals.HtmlEncode(txtShipTo.Text); shippingAddress.RegionId = dropRegions.GetSelectedRegionId().Value; shippingAddress.Address = Globals.HtmlEncode(txtAddress.Text); shippingAddress.Zipcode = txtZipcode.Text; shippingAddress.CellPhone = txtCellPhone.Text; shippingAddress.TelPhone = txtTelPhone.Text; PersonalHelper.CreateShippingAddress(shippingAddress); } Page.Response.Redirect(Globals.GetSiteUrls().UrlData.FormatUrl("FinishOrder", new object[] { orderInfo.OrderId })); } } catch (Exception exception) { ShowMessage(exception.ToString(), false); } } } }
public static bool UpdateShippingAddress(ShippingAddressInfo shippingAddress) { return new ShippingAddressDao().UpdateShippingAddress(shippingAddress); }
public override bool CreateUpdateDeleteShippingAddress(ShippingAddressInfo shippingAddress, DataProviderAction action) { DbCommand storedProcCommand = database.GetStoredProcCommand("ac_Underling_ShippingAddress_CreateUpdateDelete"); database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action); database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4); if (action != DataProviderAction.Create) { database.AddInParameter(storedProcCommand, "ShippingId", DbType.Int32, shippingAddress.ShippingId); } if (action != DataProviderAction.Delete) { database.AddInParameter(storedProcCommand, "RegionId", DbType.Int32, shippingAddress.RegionId); database.AddInParameter(storedProcCommand, "UserId", DbType.Int32, shippingAddress.UserId); database.AddInParameter(storedProcCommand, "ShipTo", DbType.String, shippingAddress.ShipTo); database.AddInParameter(storedProcCommand, "Address", DbType.String, shippingAddress.Address); database.AddInParameter(storedProcCommand, "Zipcode", DbType.String, shippingAddress.Zipcode); database.AddInParameter(storedProcCommand, "TelPhone", DbType.String, shippingAddress.TelPhone); database.AddInParameter(storedProcCommand, "CellPhone", DbType.String, shippingAddress.CellPhone); } database.ExecuteNonQuery(storedProcCommand); return (((int)database.GetParameterValue(storedProcCommand, "Status")) == 0); }
//加载事件 protected void Page_Load(object sender, EventArgs e) { int num = 0; SortedDictionary<string, string> requestPost = GetRequestPost(); if (requestPost.Count > 0) { string openIdType = "hishop.plugins.openid.alipay.alipayservice"; OpenIdSettingsInfo openIdSettings = OpenIdHelper.GetOpenIdSettings(openIdType); if (openIdSettings == null) { Response.Write("登录失败,没有找到对应的插件配置信息。"); return; } XmlDocument document = new XmlDocument(); document.LoadXml(Cryptographer.Decrypt(openIdSettings.Settings)); AliPayNotify notify = new AliPayNotify(requestPost, Request.Form["notify_id"], document.FirstChild.SelectSingleNode("Partner").InnerText, document.FirstChild.SelectSingleNode("Key").InnerText); string responseTxt = notify.ResponseTxt; string sign = Request.Form["sign"]; string mysign = notify.Mysign; if ((responseTxt == "true") && (sign == mysign)) { string receive_address = Request.Form["receive_address"]; if (!string.IsNullOrEmpty(receive_address)) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(receive_address); ShippingAddressInfo shippingAddrInfo = new ShippingAddressInfo(); shippingAddrInfo.UserId = HiContext.Current.User.UserId; ShippingAddressInfo shippingAddress = shippingAddrInfo; if (!((xmlDoc.SelectSingleNode("/receiveAddress/address") == null) || string.IsNullOrEmpty(xmlDoc.SelectSingleNode("/receiveAddress/address").InnerText))) { shippingAddress.Address = Globals.HtmlEncode(xmlDoc.SelectSingleNode("/receiveAddress/address").InnerText); } if (!((xmlDoc.SelectSingleNode("/receiveAddress/fullname") == null) || string.IsNullOrEmpty(xmlDoc.SelectSingleNode("/receiveAddress/fullname").InnerText))) { shippingAddress.ShipTo = Globals.HtmlEncode(xmlDoc.SelectSingleNode("/receiveAddress/fullname").InnerText); } if (!((xmlDoc.SelectSingleNode("/receiveAddress/post") == null) || string.IsNullOrEmpty(xmlDoc.SelectSingleNode("/receiveAddress/post").InnerText))) { shippingAddress.Zipcode = xmlDoc.SelectSingleNode("/receiveAddress/post").InnerText; } if (!((xmlDoc.SelectSingleNode("/receiveAddress/mobile_phone") == null) || string.IsNullOrEmpty(xmlDoc.SelectSingleNode("/receiveAddress/mobile_phone").InnerText))) { shippingAddress.CellPhone = xmlDoc.SelectSingleNode("/receiveAddress/mobile_phone").InnerText; } if (!((xmlDoc.SelectSingleNode("/receiveAddress/phone") == null) || string.IsNullOrEmpty(xmlDoc.SelectSingleNode("/receiveAddress/phone").InnerText))) { shippingAddress.TelPhone = xmlDoc.SelectSingleNode("/receiveAddress/phone").InnerText; } string innerText = string.Empty; string city = string.Empty; string prov = string.Empty; if (!((xmlDoc.SelectSingleNode("/receiveAddress/area") == null) || string.IsNullOrEmpty(xmlDoc.SelectSingleNode("/receiveAddress/area").InnerText))) { innerText = xmlDoc.SelectSingleNode("/receiveAddress/area").InnerText; } if (!((xmlDoc.SelectSingleNode("/receiveAddress/city") == null) || string.IsNullOrEmpty(xmlDoc.SelectSingleNode("/receiveAddress/city").InnerText))) { city = xmlDoc.SelectSingleNode("/receiveAddress/city").InnerText; } if (!((xmlDoc.SelectSingleNode("/receiveAddress/prov") == null) || string.IsNullOrEmpty(xmlDoc.SelectSingleNode("/receiveAddress/prov").InnerText))) { prov = xmlDoc.SelectSingleNode("/receiveAddress/prov").InnerText; } if ((string.IsNullOrEmpty(innerText) && string.IsNullOrEmpty(city)) && string.IsNullOrEmpty(prov)) { shippingAddress.RegionId = 0; } else { shippingAddress.RegionId = RegionHelper.GetRegionId(innerText, city, prov); } SiteSettings siteSettings = HiContext.Current.SiteSettings; if (PersonalHelper.GetShippingAddressCount(HiContext.Current.User.UserId) < HiContext.Current.Config.ShippingAddressQuantity) { num = PersonalHelper.AddShippingAddress(shippingAddress); } } } } Page.Response.Redirect(Globals.ApplicationPath + "/SubmmitOrder.aspx?shippingId=" + num); }
private void AddShippingAddress(HttpContext context) { context.Response.ContentType = "application/json"; MemberInfo currentMember = MemberProcessor.GetCurrentMember(); if (currentMember == null) { context.Response.Write("{\"success\":false}"); } else { ShippingAddressInfo shippingAddress = new ShippingAddressInfo { Address = context.Request.Form["address"], CellPhone = context.Request.Form["cellphone"], ShipTo = context.Request.Form["shipTo"], Zipcode = "12345", IsDefault = true, UserId = currentMember.UserId, RegionId = Convert.ToInt32(context.Request.Form["regionSelectorValue"]) }; if (MemberProcessor.AddShippingAddress(shippingAddress) > 0) { context.Response.Write("{\"success\":true}"); } else { context.Response.Write("{\"success\":false}"); } } }
public abstract int AddShippingAddress(ShippingAddressInfo shippingAddress);