private void LoadData()
{
var savePath = @"d:\";
var userDAL = new DAL.Users();
var poiBLL = new PoiBLL();
var users = userDAL.Select("RegTime > '2005-05-30'", "");
if (!Directory.Exists(Path.Combine(savePath, "poi")))
Directory.CreateDirectory(Path.Combine(savePath, "poi"));
foreach (DataRow row in users.Rows)
{
var userid = row["id"].ToInt();
if (userid <= 0) continue;
var index = 0;
while (true)
{
var searchResults = GetGeoSearchResult(userid, index);
if (searchResults.IsNull() || searchResults.size <= 0) break;
//File.AppendAllText(Path.Combine(savePath, "poi", string.Format("{0}_{1}.txt", userid, index)), JsonConvert.SerializeObject(searchResults));
File.WriteAllText(Path.Combine(savePath, "poi", string.Format("{0}_{1}.txt", userid, index)), JsonConvert.SerializeObject(searchResults));
index++;
Thread.Sleep(100);
}
}
}
private void Save()
{
var kid = WebUtility.GetRequestInt("kid", -1);
var id = WebUtility.GetRequestInt("id", -1);
if (kid == -1 || id == -1)
{
WebUtility.ShowAndGoBack(this, "参数有误！");
return;
}
var result = "";
if (LoginUser == null)
{
result = JsonConvert.SerializeObject(new { statue = false, msg = "请登录！" });
}
else
{
var selecttype = WebUtility.GetRequestStr("selecttype", "");
var selectprice = WebUtility.GetRequestStr("selectprice", "");
var selectsize = WebUtility.GetRequestStr("selectsize", "");
var selecttypeid = WebUtility.GetRequestStr("selecttypeid", "");
var selectpriceid = WebUtility.GetRequestStr("selectpriceid", "");
var selectsizeid = WebUtility.GetRequestStr("selectsizeid", "");
var key = new DAL.Key().GetEntity(kid);
if (key == null) return;
var dic = new Dictionary<string, string>();
dic.Add("KID", kid.ToString());
dic.Add("SelectType", selecttype);
dic.Add("SelectPrice", selectprice);
dic.Add("SelectSize", selectsize);
dic.Add("SelectTypeID", selecttypeid);
dic.Add("SelectPriceID", selectpriceid);
dic.Add("SelectSizeID", selectsizeid);
dic.Add("KName", key.Name);
var poiBLL = new PoiBLL();
var productPoi = poiBLL.Details<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi>(id, ConfigHelper.GeoProductTableID);
if (productPoi.status != 0) return;
try
{
var tags = productPoi.poi.title+" "+key.Name;
if(!string.IsNullOrWhiteSpace(productPoi.poi.BName)) tags+=" "+productPoi.poi.BName;
poiBLL.Update(id, ADee.Project.LBS.Common.ConfigHelper.GeoProductTableID, ADee.Project.LBS.Entity.CoordType.BaiduEncrypt, dic, "", tags);
result = JsonConvert.SerializeObject(new { statue = true });
}
catch
{
result = JsonConvert.SerializeObject(new { statue = false, msg = "添加失败！" });
}
}
Response.Write(result);
Response.Flush();
Response.End();
}
/// <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();
}
private void DeleteData()
{
var userDAL = new DAL.Users();
var poiBLL = new PoiBLL();
var users = userDAL.Select("RegTime > '2014-05-30'", "");
foreach (DataRow row in users.Rows)
{
var userid = row["id"].ToInt();
if (userid <= 0) continue;
while (true)
{
var searchResults = GetGeoSearchResult(userid, 0);
if (searchResults.IsNull() || searchResults.size <= 0) break;
searchResults.pois.ForEach(poi =>
{
poiBLL.Delete(new List<string> { poi.id }, ADee.Project.LBS.Common.ConfigHelper.GeoProductTableID);
});
Thread.Sleep(10);
}
}
}
private void BandData()
{
var id = WebUtility.GetRequestInt("id", 0);
if (id == 0) return;
var product =new PoiBLL().Details<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi>(id, ADee.Project.LBS.Common.ConfigHelper.GeoProductTableID).poi;
rpProduct.DataSource = new List<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi> { product };
rpProduct.DataBind();
AddClickCount(product.KID);
}
private void PostData(List<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi> pois, Model.Key_CircleSaleMan saleman)
{
var poiBLL = new PoiBLL();
foreach (var poi in pois)
{
var dic = new Dictionary<string, string>();
dic.Add("CompanyName", saleman.CompanyName);
dic.Add("SalemanMemo", HttpUtility.HtmlDecode(saleman.Memo));
dic.Add("QQ", saleman.QQ);
dic.Add("Phone", saleman.Phone);
try
{
poiBLL.Update(
poi.id.ToInt(),
poi.geotable_id,
ADee.Project.LBS.Entity.CoordType.BaiduEncrypt,
dic,
address: saleman.CompanyAddress,
latitude: saleman.PositionX.Value,
longitude: saleman.PositionY.Value);
Thread.Sleep(10);
}
catch
{
}
}
}
private void PostData()
{
var savePath = Path.Combine(@"d:\", "poi");
foreach (var file in Directory.GetFiles(savePath))
{
var content = File.ReadAllText(file);
var result = JsonConvert.DeserializeObject<PoiListResult<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi>>(content);
if (result.IsNull() || result.size <= 0) continue;
foreach (var poi in result.pois)
{
var dic = new Dictionary<string, string>();
dic.Add("Description", HttpUtility.HtmlDecode(poi.Description));
dic.Add("Price", poi.Price.ToStr());
dic.Add("CreateUserID", poi.CreateUserID.ToStr());
dic.Add("CompanyName", poi.CompanyName);
dic.Add("SalemanMemo", HttpUtility.HtmlDecode(poi.SalemanMemo));
dic.Add("QQ", poi.QQ);
dic.Add("Phone", poi.Phone);
dic.Add("SelectPrice", poi.SelectPrice);
dic.Add("SelectPriceID", poi.SelectPriceID);
dic.Add("SelectSize", poi.SelectSize);
dic.Add("SelectSizeID", poi.SelectSizeID);
dic.Add("SelectType", poi.SelectType);
dic.Add("SelectTypeID", poi.SelectTypeID);
dic.Add("BName", poi.BName);
dic.Add("KID", poi.KID.ToStr());
dic.Add("KName", poi.KName);
var poiBLL = new PoiBLL();
try
{
var id = poiBLL.Create(
poi.location[1],
poi.location[0],
ADee.Project.LBS.Entity.CoordType.BaiduEncrypt,
ADee.Project.LBS.Common.ConfigHelper.GeoProductTableID,
dic,
poi.title,
poi.address,
poi.tags);
if (string.IsNullOrWhiteSpace(id))
Debug.Print("添加失败！");
Thread.Sleep(10);
}
catch
{
Debug.Print("发生错误！");
}
}
File.Delete(file);
}
}
private string Save()
{
if (LoginUser == null)
{
return JsonConvert.SerializeObject(new { statue = false, msg = "请登录！" });
}
else
{
var txtPrice = WebUtility.GetRequestStr("price", "");
var txtSimpleDesc = WebUtility.GetRequestStr("simpledesc", "");
var txtDesc = WebUtility.GetRequestStr("description", "");
if (string.IsNullOrWhiteSpace(txtPrice))
{
return JsonConvert.SerializeObject(new { statue = false, msg = "价格不能为空！" });
}
if (!Utility.IsFloat(txtPrice))
{
return JsonConvert.SerializeObject(new { statue = false, msg = "价格格式不正确！" });
}
if (string.IsNullOrWhiteSpace(txtPrice))
{
return JsonConvert.SerializeObject(new { statue = false, msg = "商品简单描述不能为空！" });
}
if (string.IsNullOrWhiteSpace(txtDesc))
{
return JsonConvert.SerializeObject(new { statue = false, msg = "商品详情描述不能为空！" });
}
if (txtDesc.Length>200)
{
return JsonConvert.SerializeObject(new { statue = false, msg = "商品详情描述长度应小于200！" });
}
var db = DataBase.Create();
var salemanTB = db.Select("select * from vw_Key_CircleSaleMan where UserID = " + LoginUser.UserID);
if (salemanTB.Rows.Count <= 0) return JsonConvert.SerializeObject(new { statue = false, msg = "商家未找到！" });
var saleman = salemanTB.Rows[0];
var dic = new Dictionary<string, string>();
dic.Add("Description", txtDesc);
dic.Add("Price", txtPrice);
dic.Add("CreateUserID", LoginUser.UserID.ToString());
dic.Add("CompanyName", saleman["CompanyName"].ToString());
dic.Add("SalemanMemo", saleman["Memo"].ToString());
dic.Add("QQ", saleman["QQ"].ToString());
dic.Add("Phone", saleman["Phone"].ToString());
var poiBLL = new PoiBLL();
try
{
var id = poiBLL.Create(
Utility.GetFloat(saleman["PositionX"], 0f),
Utility.GetFloat(saleman["PositionY"], 0f),
ADee.Project.LBS.Entity.CoordType.BaiduEncrypt,
ADee.Project.LBS.Common.ConfigHelper.GeoProductTableID,
dic,
txtSimpleDesc,
saleman["CompanyAddress"].ToString(),
txtSimpleDesc);
if (!string.IsNullOrWhiteSpace(id))
return JsonConvert.SerializeObject(new { statue = true });
else
return JsonConvert.SerializeObject(new { statue = false, msg = "添加失败！" });
}
catch
{
return JsonConvert.SerializeObject(new { statue = false, msg = "添加失败！" });
}
}
}
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 = "当前该关键字的报价点击免费";
}
/// <summary>
/// 获取报价信息，http://mobile.huobi3j.com/product/details
/// </summary>
/// <param name="id">报价ID</param>
/// <returns></returns>
//[OutputCache(Duration = 3600, VaryByParam = "id")]
public ActionResult Details(int id)
{
if (id == 0) return Json(new JsonResponse { status = false, message = "参数有误！" });
var poiBLL = new PoiBLL();
var poi = poiBLL.Details<ADeeWu.HuoBi3J.Libary.LBSHelper.ProductPoi>(id, ADee.Project.LBS.Common.ConfigHelper.GeoProductTableID);
AddClickCount(id);
return GetJson(poi);
}
