//读取礼品列表
protected void ReadingGifts()
{
List <FavorableActivityGiftInfo> giftList = new List <FavorableActivityGiftInfo>();
List <FavorableActivityGiftInfo> dataList = new List <FavorableActivityGiftInfo>();
int favorId = RequestHelper.GetQueryString <int>("favorId");
if (favorId > 0)
{
var theFavor = FavorableActivityBLL.Read(favorId);
if (!String.IsNullOrEmpty(theFavor.GiftId))
{
FavorableActivityGiftSearchInfo giftSearch = new FavorableActivityGiftSearchInfo();
giftSearch.InGiftIds = Array.ConvertAll <string, int>(theFavor.GiftId.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), k => Convert.ToInt32(k));
giftList = FavorableActivityGiftBLL.SearchList(giftSearch);
if (giftList.Count > 0)
{
foreach (var tmp in giftList)
{
tmp.Photo = tmp.Photo.Replace("Original", "100-100");
dataList.Add(tmp);
}
}
}
}
Response.Clear();
ResponseHelper.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { count = giftList.Count, dataList = dataList }));
ResponseHelper.End();
}
public MssqlCondition PrepareCondition(FavorableActivityGiftSearchInfo searchInfo)
{
MssqlCondition mssqlCondition = new MssqlCondition();
mssqlCondition.Add("[Name]", searchInfo.Name, ConditionType.Like);
mssqlCondition.Add("[Id]", string.Join(",", searchInfo.InGiftIds), ConditionType.In);
return(mssqlCondition);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckAdminPower("ReadGift", PowerCheckType.Single);
var searchInfo = new FavorableActivityGiftSearchInfo();
searchInfo.Name = RequestHelper.GetQueryString <string>("Name");
BindControl(FavorableActivityGiftBLL.SearchList(CurrentPage, PageSize, searchInfo, ref Count), RecordList, MyPager);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
UserGrade.DataSource = UserGradeBLL.ReadList();
UserGrade.DataTextField = "Name";
UserGrade.DataValueField = "Id";
UserGrade.DataBind();
RegionID.DataSource = RegionBLL.ReadRegionUnlimitClass();
ProductClass.DataSource = ProductClassBLL.ReadUnlimitClassList();
favorableActivityID = RequestHelper.GetQueryString <int>("ID");
if (favorableActivityID != int.MinValue)
{
CheckAdminPower("ReadFavorableActivity", PowerCheckType.Single);
favorableActivity = FavorableActivityBLL.Read(favorableActivityID);
Photo.Text = favorableActivity.Photo;
Name.Text = favorableActivity.Name;
Content.Text = favorableActivity.Content;
StartDate.Text = favorableActivity.StartDate.ToString("yyyy-MM-dd");
EndDate.Text = favorableActivity.EndDate.ToString("yyyy-MM-dd");
ControlHelper.SetCheckBoxListValue(UserGrade, favorableActivity.UserGrade);
OrderProductMoney.Text = favorableActivity.OrderProductMoney.ToString();
RegionID.ClassIDList = favorableActivity.RegionId ?? "";
ReduceMoney.Text = favorableActivity.ReduceMoney.ToString();
ReduceDiscount.Text = favorableActivity.ReduceDiscount.ToString();
favorableType = favorableActivity.Type;
ProductClass.ClassIDList = favorableActivity.ClassIds ?? "";
if (!string.IsNullOrEmpty(favorableActivity.GiftId))
{
var giftSearch = new FavorableActivityGiftSearchInfo();
giftSearch.InGiftIds = Array.ConvertAll <string, int>(favorableActivity.GiftId.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), k => Convert.ToInt32(k));
giftList = FavorableActivityGiftBLL.SearchList(giftSearch);
}
}
else
{//新增:默认所有会员等级全部选中
foreach (ListItem item in UserGrade.Items)
{
item.Selected = true;
}
}
}
}
public List <FavorableActivityGiftInfo> SearchList(FavorableActivityGiftSearchInfo searchInfo)
{
using (var conn = new SqlConnection(connectString))
{
string sql = "select * from FavorableActivityGift where 1=1 ";
var para = new DynamicParameters();
if (searchInfo.InGiftIds.Length > 0)
{
sql += " and Id in @ids";
para.Add("ids", searchInfo.InGiftIds);
}
if (!string.IsNullOrEmpty(searchInfo.Name))
{
sql += " and Name like @name";
para.Add("name", "%" + searchInfo.Name + "%");
}
return(conn.Query <FavorableActivityGiftInfo>(sql, para).ToList());
}
}
protected override void PageLoad()
{
base.PageLoad();
//登录验证
if (base.UserId <= 0)
{
string redirectUrl = "/Mobile/login.html?RedirectUrl=/mobile/CheckOut.html";
ResponseHelper.Redirect(redirectUrl);
ResponseHelper.End();
}
//购物车验证
checkCart = HttpUtility.UrlDecode(CookiesHelper.ReadCookieValue("CheckCart"));
int[] cartIds = Array.ConvertAll <string, int>(checkCart.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), k => Convert.ToInt32(k));
if (string.IsNullOrEmpty(checkCart) || cartIds.Length < 1)
{
ResponseHelper.Redirect("/Mobile/cart.html");
ResponseHelper.End();
}
//cart list
#region cart list
//商品清单
cartList = CartBLL.ReadList(base.UserId);
cartList = cartList.Where(k => cartIds.Contains(k.Id)).ToList();
if (cartList.Count < 1)
{
ResponseHelper.Redirect("/Mobile/cart.html");
ResponseHelper.End();
}
//关联的商品
int count = 0;
int[] ids = cartList.Select(k => k.ProductId).ToArray();
var products = ProductBLL.SearchList(1, ids.Length, new ProductSearchInfo {
InProductId = string.Join(",", ids)
}, ref count);
//规格
foreach (var cart in cartList)
{
cart.Product = products.FirstOrDefault(k => k.Id == cart.ProductId) ?? new ProductInfo();
if (cart.Product.StandardType == 1)
{
//使用规格的价格和库存
var standardRecord = ProductTypeStandardRecordBLL.Read(cart.ProductId, cart.StandardValueList);
cart.Price = standardRecord.SalePrice;
cart.LeftStorageCount = standardRecord.Storage - OrderDetailBLL.GetOrderCount(cart.ProductId, cart.StandardValueList);
//规格集合
cart.Standards = ProductTypeStandardBLL.ReadList(Array.ConvertAll <string, int>(standardRecord.StandardIdList.Split(';'), k => Convert.ToInt32(k)));
}
else
{
cart.Price = cart.Product.SalePrice;
cart.LeftStorageCount = cart.Product.TotalStorageCount - OrderDetailBLL.GetOrderCount(cart.ProductId, cart.StandardValueList);
}
if (cart.LeftStorageCount <= 0)
{
ScriptHelper.AlertFront("您购物车中 " + cart.Product.Name + " 库存不足，请重新选择", "/Mobile/Cart.html");
}
}
#endregion
//收货地址
addressList = UserAddressBLL.ReadList(base.UserId);
addressList = addressList.OrderByDescending(k => k.IsDefault).ToList();
singleUnlimitClass.DataSource = RegionBLL.ReadRegionUnlimitClass();
totalProductMoney = cartList.Sum(k => k.BuyCount * k.Price);
//用户信息
var user = UserBLL.Read(base.UserId);
if (user.Id > 0)
{
//读取优惠券
List <UserCouponInfo> tempUserCouponList = UserCouponBLL.ReadCanUse(base.UserId);
foreach (UserCouponInfo userCoupon in tempUserCouponList)
{
CouponInfo tempCoupon = CouponBLL.Read(userCoupon.CouponId);
if (tempCoupon.UseMinAmount <= totalProductMoney)
{
userCouponList.Add(userCoupon);
}
}
moneyLeft = UserBLL.ReadUserMore(base.UserId).MoneyLeft;
}
//读取优惠活动
favorableActivity = FavorableActivityBLL.Read(DateTime.Now, DateTime.Now, 0);
if (favorableActivity.Id > 0)
{
if (("," + favorableActivity.UserGrade + ",").IndexOf("," + base.GradeID.ToString() + ",") > -1 && Sessions.ProductTotalPrice >= favorableActivity.OrderProductMoney)
{
if (favorableActivity.GiftId != string.Empty)
{
FavorableActivityGiftSearchInfo giftSearch = new FavorableActivityGiftSearchInfo();
giftSearch.InGiftIds = Array.ConvertAll <string, int>(favorableActivity.GiftId.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), k => Convert.ToInt32(k));
giftList = FavorableActivityGiftBLL.SearchList(giftSearch);
}
}
else
{
favorableActivity = new FavorableActivityInfo();
}
}
//支付方式列表
payPluginsList = PayPlugins.ReadProductBuyPayPluginsList();
Title = "结算中心";
}
public static List <FavorableActivityGiftInfo> SearchList(int currentPage, int pageSize, FavorableActivityGiftSearchInfo searchInfo, ref int count)
{
return(dal.SearchList(currentPage, pageSize, searchInfo, ref count));
}
public static List <FavorableActivityGiftInfo> SearchList(FavorableActivityGiftSearchInfo searchInfo)
{
return(dal.SearchList(searchInfo));
}
public List <FavorableActivityGiftInfo> SearchList(int currentPage, int pageSize, FavorableActivityGiftSearchInfo searchInfo, ref int count)
{
using (var conn = new SqlConnection(connectString))
{
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "FavorableActivityGift";
pc.Fields = "[Id], [Name], [Photo], [Description] ";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[Id]";
pc.MssqlCondition = PrepareCondition(searchInfo);
count = pc.Count;
return(conn.Query <FavorableActivityGiftInfo>(pc).ToList());
}
}
