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);
