/// <summary>
/// 添加购物车
/// </summary>
/// <param name="orderId"></param>
/// <param name="itemId"></param>
/// <param name="count"></param>
/// <returns></returns>
public static void SetTradeList(int orderId, int itemId, int count)
{
if (count > 0 && itemId > 0 && orderId > 0)
{
ShopTradelist tradeListItem = new ShopTradelist();
tradeListItem.OrderId = orderId;
tradeListItem.ItemId = itemId;
tradeListItem.ItemCount = count;
List <ShopTradelist> list =
JaneShopGateway.JaneShopProvier.GetShopTradelistByOrderId(orderId);
if (list != null && list.Count > 0)
{
foreach (ShopTradelist st in list)
{
if (st.ItemId == itemId)
{
tradeListItem.Id = st.Id;
tradeListItem.ItemCount = st.ItemCount + count;
break;
}
}
}
// tradeListItem.Id =
JaneShopGateway.JaneShopProvier.SetShopTradelist(tradeListItem);
}
}
internal static int SetShopTradelist(ShopTradelist item)
{
if (item == null)
{
return(-1);
}
SafeProcedure.ExecuteNonQuery(
Database.GetDatabase(JaneDefine.DBInstanceName),
"dbo.Shop_tradelist_Set",
delegate(IParameterSet parameters)
{
parameters.AddWithValue("@Id", item.Id);
parameters.AddWithValue("@orderid", item.OrderId);
parameters.AddWithValue("@itemid", item.ItemId);
parameters.AddWithValue("@itemcount", item.ItemCount);
parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue);
},
delegate(IParameterSet outputParameters)
{
item.Id = Convert.ToInt32(outputParameters.GetValue("@RetVal"));
});
return(item.Id);
}
internal static void MapList(IRecord record, List <ShopTradelist> list)
{
ShopTradelist m = new ShopTradelist();
m.Id = record.GetInt32OrDefault(0, 0);
m.OrderId = record.GetInt32OrDefault(1, 0);
m.ItemId = record.GetInt32OrDefault(2, 0);
m.ItemCount = record.GetInt32OrDefault(3, 0);
list.Add(m);
}
internal static ShopTradelist GetShopTradelist(int id)
{
ShopTradelist m = new ShopTradelist(id);
if (id > 0)
{
SafeProcedure.ExecuteAndMapRecords(
Database.GetDatabase(JaneDefine.DBInstanceName),
"dbo.Shop_tradelist_Get",
delegate(IRecord record)
{
m.Id = record.GetInt32OrDefault(0, 0);
m.OrderId = record.GetInt32OrDefault(1, 0);
m.ItemId = record.GetInt32OrDefault(2, 0);
m.ItemCount = record.GetInt32OrDefault(3, 0);
},
id);
}
return(m);
}
public void ProcessRequest(HttpContext context)
{
string handlerType = context.Request.QueryString["t"];
if (!string.IsNullOrEmpty(handlerType))
{
if (D4D.Web.Helper.Helper.IsDizLogin)
{
string strOrderId = context.Request.QueryString["id"];
int orderId;
int.TryParse(strOrderId, out orderId);
if (orderId > 0)
{
int userId = D4D.Web.Helper.Helper.GetCookieUserId();
if (userId > 0)
{
ShopOrder sOrder = JaneShopGateway.JaneShopProvier.GetShopOrder(orderId);
if (sOrder != null && sOrder.UserId == userId)
{
//get returnUrl
string returnUrl = context.Request.QueryString["rurl"];
if (!string.IsNullOrEmpty(returnUrl))
{
switch (handlerType.ToLower())
{
case "cleartradelist":
if (sOrder.Ordertype == OrderType.ShopCar) //只有购物车状态才能清空
{
//get orderid
JaneShopGateway.JaneShopProvier.DeleteShopTradelistByOrderId(orderId);
}
context.Response.Redirect(returnUrl);
break;
case "delonetradelist":
if (sOrder.Ordertype == OrderType.ShopCar) //只有购物车状态才能删除
{
string strTid = context.Request.QueryString["tid"];
int tid;
int.TryParse(strTid, out tid);
if (tid > 0)
{
ShopTradelist tradeList = JaneShopGateway.JaneShopProvier.GetShopTradelist(tid);
if (tradeList != null && tradeList.OrderId == orderId)
{
JaneShopGateway.JaneShopProvier.DeleteShopTradelist(tid);
}
}
}
context.Response.Redirect(returnUrl);
break;
default:
break;
}
}
}
}
}
}
}
}
//购物清单
#region JaneShopTradelistDao
public int SetShopTradelist(ShopTradelist item)
{
return(JaneShopTradelistDao.SetShopTradelist(item));
}
