public string InsertintoCollect()
{
string skuid = "";
string type = ""; bool result = false;
if (Request.Cookies["UserInfo"] != null)
{
if (!string.IsNullOrEmpty(RequestBase.GetString("skuid")))
{
skuid = RequestBase.GetString("skuid").ToString();
}
if (!string.IsNullOrEmpty(RequestBase.GetString("type")))
{
type = RequestBase.GetString("type").ToString();
}
Model.VipCollectionBase cmodel = new Model.VipCollectionBase();
int mid = (CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies["UserInfo"].Value) as Model.MemberBase).m_ID;
new BLL.VipCollectionBase().Deletebyskuid(mid, int.Parse(skuid));
cmodel.sku_ID = int.Parse(skuid);
cmodel.m_ID = mid;
cmodel.vc_CreateOn = DateTime.Now;
result = new BLL.VipCollectionBase().Add(cmodel);
if (result)
{
return "操作成功";
}
else
{
return "操作失败";
}
}
else
{
return "未登陆";
}
}
//我的收藏
public ActionResult VipMycollect()
{
var model = new ListModel();
string where2 = "";
int page = 1;
string skulist = "";
int mid = 0;
if (LoginMember != null)
{
mid = (CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies["UserInfo"].Value) as Model.MemberBase).m_ID;
ViewData["mid"] =mid;
Model.VipCollectionBase cmodel = new Model.VipCollectionBase();
var clist = new BLL.VipCollectionBase().GetModelList(" m_Id=" + mid + " and vc_IsDel=0");
if (clist.Count > 0)
{
ViewData["collect"] = true;
foreach (var item in clist)
{
skulist += item.sku_ID + ",";
}
skulist = skulist.Substring(0, skulist.Length - 1);
where2 = " and sku_ID in(" + skulist + ")";
List<Model.vw_PInfo> list = new BLL.vw_PInfo().GetModelList(" p_IsDel=0 and p_SellStatus=1 and p_StatusCode=0 " + where2);
return View(list.ToList());
}
else
{
ViewData["collect"] = false;
return View();
}
}
else
{
Response.Redirect("/wapLogin/Login");
return View();
}
}
//删除收藏夹里的商品
public bool delcollect()
{
string vcid = "";
if (!string.IsNullOrEmpty(RequestBase.GetString("id")))
{
vcid = RequestBase.GetString("id").ToString();
}
Model.VipCollectionBase vcmodel = new Model.VipCollectionBase();
bool result = new BLL.VipCollectionBase().Delete(int.Parse(vcid));
return result;
}
public ActionResult vipCollect()
{
var model = new ListModel();
string where = "";
string where2 = "";
string sortby = "";
int page = 1;
int pagerows = 2;
string skulist = "";
int mid = 0;
if (LoginMember != null)
{
mid = (CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies["UserInfo"].Value) as Model.MemberBase).m_ID;
Model.VipCollectionBase cmodel = new Model.VipCollectionBase();
var clist = new BLL.VipCollectionBase().GetModelList(" m_Id=" + mid + " and vc_IsDel=0");
if (clist.Count > 0)
{
ViewData["collect"] = true;
foreach (var item in clist)
{
skulist += item.sku_ID + ",";
}
skulist = skulist.Substring(0, skulist.Length - 1);
where = " and vw.sku_ID in(" + skulist + ")";
where2 = " and sku_ID in(" + skulist + ")";
model.vmpinfolist = new BLL.vw_PInfo().GetModelListVC(" vc.m_ID=" + mid + " and p_IsDel=0 and p_StatusCode=0 and p_SellStatus=1 and vw.sku_ID = vc.sku_ID and vc.vc_IsDel=0 " + where, page, pagerows, sortby);
List<Model.vw_PInfo> list = new BLL.vw_PInfo().GetModelList(" p_IsDel=0 and p_SellStatus=1 and p_StatusCode=0 " + where2);
ViewData["count"] = list.Count;
ViewData["pagerows"] = pagerows;
ViewData["page"] = page;
return View(model.vmpinfolist);
}
else
{
ViewData["collect"] = false;
return View();
}
}
else
{
Response.Redirect("/Index/Index");
return View();
}
}
public string collectpage()
{
int pageSize = 2;//每一页的行数
int pageNumber = 1;//当前页数
string html = "";
string skuid = "";
string where = "";
string where2 = "";
string skulist = "";
string sortby = "";
int mid = 0;
if (LoginMember != null)
{
mid = (CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies["UserInfo"].Value) as Model.MemberBase).m_ID;
}
Model.VipCollectionBase cmodel = new Model.VipCollectionBase();
var clist = new BLL.VipCollectionBase().GetModelList(" m_Id=" + mid + " and vc_IsDel=0");
if (clist.Count > 0)
{
foreach (var item in clist)
{
skulist += item.sku_ID + ",";
}
skulist = skulist.Substring(0, skulist.Length - 1);
where = " and sku_ID in(" + skulist + ")";
where2 = " and vw.sku_ID in(" + skulist + ")";
}
if (!string.IsNullOrEmpty(RequestBase.GetString("pageNum")))
{
pageNumber = Convert.ToInt32(RequestBase.GetString("pageNum"));
}
List<Model.vw_PInfo> list = new BLL.vw_PInfo().GetModelList(" p_IsDel=0 and p_SellStatus=1 and p_StatusCode=0 " + where);
ViewBag.collect = new BLL.vw_PInfo().GetModelListVC(" vc.m_ID=" + mid + " and p_IsDel=0 and p_StatusCode=0 and p_SellStatus=1 and vw.sku_ID = vc.sku_ID and vc.vc_IsDel=0 " + where2, pageNumber, pageSize, sortby);
//ViewBag.collect = list.ToPagedList(pageNumber, pageSize);
foreach (var item in ViewBag.collect)
{
html += "<li><table class=\"order-list\"><tbody><tr><td width=\"345\"><div class=\"pro-imgs\"><a href=\"/ProDetail/ProDetail?skuid="+item.sku_ID+"\"><img name=\"page_cnt_1\" src=\""+item.pi_Url+"\" alt=\""+item.p_Name+"\" /></a></div><p><a href=\"/ProDetail/ProDetail?skuid="+item.sku_ID+"\">"+item.p_Name+" "+item.shuxing+"</a></p></td><td width=\"100\" align=\"center\">"+item.sku_Price+"</td><td width=\"80\" align=\"center\">"+item.vc_CreateOn+"</td><td width=\"90\" align=\"center\"><a href=\"javascript:void(0)\" onclick=\"delcollect("+item.vc_id+")\">删除</a><br /><a href=\"javascript:void(0)\" onclick=\"TuiinsertintoCart("+item.sku_ID+")\">添加到购物车</a><br /></td></tr></tbody></table></li>";
}
return html;
}
