/// <summary> /// 添加查看次数 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult AddClickCount(int id = 0) { try { if (id == 0) return GetJson(new JsonResponse { status = false, message = "参数有误!" }); var product = new PoiBLL().Details<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi>(id, ConfigHelper.GeoProductTableID); if (product.poi == null) return GetJson(new JsonResponse { status = false, message = "报价不存在!" }); var clickID = new DAL.Common_Count_Click().Add(new Model.Common_Count_Click { CreateDate = System.DateTime.Now, DataID = id, DataType = "center_product", IP = Request.UserHostAddress, }); if (clickID <= 0) return GetJson(new JsonResponse { status = false, message = "统计出错!" }); var keyPrice = new DAL.Key_ViewPrice().GetEntity("kid=" + product.poi.KID); if (keyPrice != null) { var countClickDAL = new DAL.Common_Count_Click(); var productCount = Utility.GetInt(DataBase.Create().ExecuteScalar(string.Format("select count(*) from common_count_click c where c.dataid={0} and datatype='center_product' and datediff(DD,c.createdate,getdate())=0", id)), 0); if (keyPrice.Count >= productCount) { new DAL.Key_ViewPrice_Log().Add(new Model.Key_ViewPrice_Log { CountClickID = clickID, Price = keyPrice.Price, }); //扣费 } } } catch { } return GetJson(new JsonResponse { status = true }); }
private void BandKey(int id) { var productPoi = new PoiBLL().Details<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi>(id, ConfigHelper.GeoProductTableID); if (productPoi == null || productPoi.status != 0) return; var viewprice = new DAL.Key_ViewPrice().GetEntity("kid=" + productPoi.poi.KID); rpKey.DataSource = new List<object> { new { KName = productPoi.poi.KName, SelectType = productPoi.poi.SelectType, SelectPrice = productPoi.poi.SelectPrice, SelectSize = productPoi.poi.SelectSize, Count = viewprice != null ? viewprice.Count : 0, Price = viewprice != null ? viewprice.Price : 0 } }; rpKey.DataBind(); }
public void AddClickCount(int kid) { try { var id = WebUtility.GetRequestInt("id", 0); if (id == 0) return; var clickID = new DAL.Common_Count_Click().Add(new Model.Common_Count_Click { CreateDate = DateTime.Now, DataID = id, DataType = "center_product", IP = Request.UserHostAddress, }); if (clickID <= 0) return; var keyPrice = new DAL.Key_ViewPrice().GetEntity("kid=" + kid); if (keyPrice != null) { var countClickDAL = new DAL.Common_Count_Click(); var productCount = Utility.GetInt(db.ExecuteScalar(string.Format("select count(*) from common_count_click c where c.dataid={0} and datatype='center_product' and datediff(DD,c.createdate,getdate())=0", id)), 0); if (keyPrice.Count >= productCount) { new DAL.Key_ViewPrice_Log().Add(new Model.Key_ViewPrice_Log { CountClickID = clickID, Price = keyPrice.Price, }); //扣费 } } } catch { } }
private void Search() { var kid = WebUtility.GetRequestInt("kid", -1); var id = WebUtility.GetRequestInt("id", -1); if (kid == -1 || id == -1) { WebUtility.ShowAndGoBack(this, "参数有误!"); return; } if (LoginUser == null) { WebUtility.ShowMsg(this, "请登录!", "/login.aspx?url=" + Request.RawUrl); return; } var productPoi = new PoiBLL().Details<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi>(id, ADee.Project.LBS.Common.ConfigHelper.GeoProductTableID).poi; litTitle.Text = productPoi.title; litPrice.Text = productPoi.Price.ToString("F2"); var key = new DAL.Key().GetEntity(kid); litKey.Text = key.Name; var attributes = new DAL.Key_Attribute().GetEntityList("", new string[] { "kid" }, new object[] { kid }); ddlType.DataSource = attributes.Where(p => p.DataType == "SelectType").Select(p => new { ID = p.ID, Value = p.DataValue }); ddlType.DataTextField = "Value"; ddlType.DataValueField = "ID"; ddlType.DataBind(); ddlType.AppendDataBoundItems = true; ddlType.Items.Insert(0, new ListItem("")); ddlPrice.DataSource = attributes.Where(p => p.DataType == "SelectPrice").Select(p => new { ID = p.ID, Value = p.DataValue }); ddlPrice.DataTextField = "Value"; ddlPrice.DataValueField = "ID"; ddlPrice.DataBind(); ddlPrice.AppendDataBoundItems = true; ddlPrice.Items.Insert(0, new ListItem("")); ddlSize.DataSource = attributes.Where(p => p.DataType == "SelectSize").Select(p => new { ID = p.ID, Value = p.DataValue }); ddlSize.DataTextField = "Value"; ddlSize.DataValueField = "ID"; ddlSize.DataBind(); ddlSize.AppendDataBoundItems = true; ddlSize.Items.Insert(0, new ListItem("")); var viewPrice = new DAL.Key_ViewPrice().GetEntity(new string[] { "KID" }, new object[] { kid }); if (viewPrice != null && viewPrice.ID > 0) litmsg.Text = string.Format("该关键字每次点击扣费 {0} 元,每条信息当天点击 量达到 {1} 次后当日不再计费!", viewPrice.Price.Value.ToString("0.00"), viewPrice.Count); else litmsg.Text = "当前该关键字的报价点击免费"; }