/// <summary> /// 获取用户当前的购物车 /// </summary> /// <param name="userId"></param> /// <returns></returns> public static ShopOrder GetUserShopCar(int userId) { //查询购物车是否有 ShopOrder sOrder = JaneShopGateway.JaneShopProvier.GetUserShopCar(userId); if (sOrder != null&&sOrder.Id>0) return sOrder; else { //new shopcar sOrder = new ShopOrder(); sOrder.Ordertype = OrderType.ShopCar; sOrder.UserId = userId; sOrder.AddDate = DateTime.Now; sOrder.Id = JaneShopGateway.JaneShopProvier.SetShopOrder(sOrder); return sOrder; } }
public int SetShopOrder(ShopOrder item) { return JaneShopOrdersDao.SetShopOrder(item); }
internal static int SetShopOrder(ShopOrder item) { if (item == null) return -1; SafeProcedure.ExecuteNonQuery( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_orders_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@Id", item.Id); parameters.AddWithValue("@userid", item.UserId); parameters.AddWithValue("@addDate", item.AddDate); parameters.AddWithValue("@ordertype", (int)(item.Ordertype)); parameters.AddWithValue("@address", item.Address); parameters.AddWithValue("@email", item.Email); parameters.AddWithValue("@mobile", item.Mobile); parameters.AddWithValue("@paymoney", item.Paymoney); parameters.AddWithValue("@paytype", (int)(item.Paytype)); parameters.AddWithValue("@payresult", (int)(item.Payresult)); parameters.AddWithValue("@payremark", item.Payremark); parameters.AddWithValue("@paythirdnum", item.Paythirdnum); parameters.AddWithValue("@paydate", item.Paydate); parameters.AddWithValue("@zipcode", item.ZipCode); parameters.AddWithValue("@username", item.UserName); parameters.AddWithValue("@RegionId", item.RegionId); parameters.AddWithValue("@Freight", item.Freight); parameters.AddWithValue("@RegionStr", item.RegionStr); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { item.Id = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return item.Id; }
internal static ShopOrder GetShopOrder(int id) { ShopOrder m = new ShopOrder(id); if (id > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_orders_Get", delegate(IRecord record) { m.Id = record.GetInt32OrDefault(0, 0); m.UserId = record.GetInt32OrDefault(1,0); m.AddDate = record.GetDateTimeOrEmpty(2); m.Ordertype =(OrderType)(record.GetInt32OrDefault(3,0)); m.Address = record.GetStringOrEmpty(4); m.Email = record.GetStringOrEmpty(5); m.Mobile = record.GetStringOrEmpty(6); m.Paymoney = record.GetDouble(7); m.Paytype =(PayType)( record.GetInt32OrDefault(8,0)); m.Payresult = (PayResult)(record.GetInt32OrDefault(9, 0)); m.Payremark = record.GetStringOrEmpty(10); m.Paythirdnum = record.GetStringOrEmpty(11); m.Paydate = record.GetDateTime(12); m.ZipCode = record.GetStringOrEmpty(13); m.UserName = record.GetStringOrEmpty(14); m.RegionId = record.GetInt32OrDefault(15, 0); m.Freight = record.GetDouble(16); m.RegionStr = record.GetStringOrEmpty(17); }, id); } return m; }
internal static void MapList(IRecord record, List<ShopOrder> list) { ShopOrder m = new ShopOrder(); m.Id = record.GetInt32OrDefault(0, 0); m.UserId = record.GetInt32OrDefault(1, 0); m.AddDate = record.GetDateTimeOrEmpty(2); m.Ordertype = (OrderType)(record.GetInt32OrDefault(3, 0)); m.Address = record.GetStringOrEmpty(4); m.Email = record.GetStringOrEmpty(5); m.Mobile = record.GetStringOrEmpty(6); m.Paymoney = record.GetDouble(7); m.Paytype = (PayType)(record.GetInt32OrDefault(8, 0)); m.Payresult = (PayResult)(record.GetInt32OrDefault(9, 0)); m.Payremark = record.GetStringOrEmpty(10); m.Paythirdnum = record.GetStringOrEmpty(11); m.Paydate = record.GetDateTime(12); m.ZipCode = record.GetStringOrEmpty(13); m.UserName = record.GetStringOrEmpty(14); m.RegionId = record.GetInt32OrDefault(15, 0); m.Freight = record.GetDouble(16); m.RegionStr = record.GetStringOrEmpty(17); list.Add(m); }