public IHttpActionResult Create(StoreModel storeModel)
{
var store = storeModel.ToEntity();
//预处理
PrepareStore(store, storeModel);
//保存图片
var base64 = HttpUtility.HtmlDecode(storeModel.Logo.Trim());
var picture = _pictureService.InsertPicture(base64);
//保存商店
_storeService.InsertStore(store);
//关联
var storePicture = new StorePicture
{
IsLogo = true,
Picture = picture,
Store = store,
DisplayOrder = 0
};
_storeService.InsertStorePicture(storePicture);
//activity log
_customerActivityService.InsertActivity("AddNewStore", "增加 名为 {0} 的商店", store.Name);
return(Ok(store.ToModel()));
}
public void UpdateStorePicture(StorePicture storePicture)
{
if (storePicture == null)
{
throw new ArgumentNullException("storePicture");
}
_storePictureRepository.Update(storePicture);
//event notification
_eventPublisher.EntityUpdated(storePicture);
}
/// <summary>
/// 商家列表页获取
/// </summary>
/// <param name="pageUrl"></param>
/// <param name="poIndex"></param>
public List<Model.Catalogue> InsretPage(string pageUrl, int poIndex)
{
var htmlWeb = new HtmlWeb();
var htmlDoc = htmlWeb.Load(pageUrl);
var list =
htmlDoc.DocumentNode.SelectNodes(
".//div[@class='constr']/div/div[@class='res_hm_c']/div[@class='res_sch_res schResList']/div[@class='l']/a");
if (list == null)
{
return null;
}
var catalogueList = new List<Model.Catalogue>();
foreach (var htmlNode in list)
//Parallel.ForEach(list, htmlNode =>
{
var title = htmlNode.SelectSingleNode(".//img").Attributes["title"].Value;
var href = htmlNode.Attributes["href"].Value;
var keyList = href.Trim('/').Split('/');
var keyID = string.Empty;
var catalogue = new Maticsoft.Model.Catalogue();
if (keyList.Count() == 2)
{
keyID = keyList[1];
catalogue.FId = keyID;
catalogue.title = title;
catalogue.href = href;
catalogue.LocalTagID = poIndex;
catalogue.StoreId = Guid.NewGuid().ToString();
var storeInfoBll = new Maticsoft.BLL.StoreInfo();
var temStoreInfoList = storeInfoBll.GetModelList(string.Format("Fid = '{0}'", keyID));
var storePictureBll = new StorePicture();
if (temStoreInfoList != null && temStoreInfoList.Count > 0)
{
catalogue.IsRead = true;
var temStoreInfo = temStoreInfoList.FirstOrDefault();
if (temStoreInfo != null)
{
catalogue.StoreId = temStoreInfo.storeId;
}
var oldStorePicture =
storePictureBll.GetModelList(string.Format("PicType ='Shop' and StoreId = '{0}'",
catalogue.StoreId));
foreach (var storePicture in oldStorePicture)
{
storePictureBll.Delete(storePicture.PID);
}
//Parallel.ForEach(oldStorePicture, storePicture => storePictureBll.Delete(storePicture.PID));
}
else
{
catalogue.IsRead = false;
}
var imgNode = htmlNode.SelectSingleNode(".//img[@class='jsLazyImage']");
if (imgNode != null)
{
var shopPicturePath = imgNode.Attributes["data-url"].Value;
if (!string.IsNullOrEmpty(shopPicturePath) && !shopPicturePath.EndsWith("food_nopic.png"))
{
var storePicture = new Maticsoft.Model.StorePicture();
storePicture.PID = Guid.NewGuid().ToString();
var pictureName = string.Format("{0}.jpg", storePicture.PID);
storePicture.PictureName = pictureName;
storePicture.PicType = "Shop";
storePicture.PicturePath = shopPicturePath;
storePicture.StoreId = catalogue.StoreId;
storePictureBll.Add(storePicture);
catalogue.picName = storePicture.PictureName;
}
}
catalogueList.Add(catalogue);
}
//catalogueBll.Add(catalogue);
}
return catalogueList.OrderBy(x => x != null && x.IsRead).ThenBy(x => x != null ? x.FId : string.Empty).ToList();
}
/// <summary>
/// 获取图片详细
/// </summary>
public void GetPicture(Maticsoft.Model.StoreInfo storeInfo)
{
var picturePathName = "PhotoAlbum";
var picPullList = new List<PicPull>() { PicPull.Environmental, PicPull.Cake };
//var picThumbnail = string.Format(newThumbnail, picturePathName, storeInfo.StoreName);
//var newPathThumb = string.Format(newPathThu, picturePathName);
//try
//{
// string CreatePath = string.Format(newPath, storeInfo.StoreName, picturePathName, string.Empty);
// if (!Directory.Exists(CreatePath))
// {
// Directory.CreateDirectory(CreatePath);
// }
// if (!Directory.Exists(picThumbnail))
// {
// Directory.CreateDirectory(picThumbnail);
// }
// if (!Directory.Exists(newPathThumb))
// {
// Directory.CreateDirectory(newPathThumb);
// }
//}
//catch (Exception e)
//{
//}
var storePictureBll = new StorePicture();
var storePicturelist = storePictureBll.GetModelList(string.Format("StoreID = '{0}' and picType ='{1}'", storeInfo.storeId, picturePathName));
foreach (var storePicture in storePicturelist)
{
storePictureBll.Delete(storePicture.PID);
}
var storePicturesTableBll = new StorePicturesTable();
var storePicturesTableList = storePicturesTableBll.GetModelList(string.Format("businessID = '{0}'", storeInfo.storeId));
foreach (var storePicturesTable in storePicturesTableList)
{
storePicturesTableBll.Delete(storePicturesTable.StorePicturesID);
}
foreach (var picPull in picPullList)
{
var busphotoAlbumTable = new Maticsoft.Model.BusPhotoAlbumTable();
busphotoAlbumTable.BusinessID = storeInfo.storeId;
if (picPull == PicPull.Cake)
{
busphotoAlbumTable.AlbumName = @"菜品图片";
}
else
{
busphotoAlbumTable.AlbumName = @"餐厅环境";
}
busphotoAlbumTable.BusPhotoAlbumID = Guid.NewGuid().ToString();
busphotoAlbumTable.IsDefault = true;
var busPhotoAlbumTableBll = new Maticsoft.BLL.BusPhotoAlbumTable();
busPhotoAlbumTableBll.Add(busphotoAlbumTable);
var pageIndex = 1;
while (true)
{
//t=-1 2 3时有值
var picturePath = @"{0}shop/new/ajax/picpull.aspx?resid={1}&t={2}&time={3}";
picturePath = string.Format(picturePath, _pageUrl, storeInfo.Fid, (int)picPull, pageIndex);
//picturePath = @"http://www.xiaomishu.com/shop/new/ajax/picpull.aspx?resid=C21C09K22533&time=6";
pageIndex++;
var htmlWeb = new HtmlWeb();
var htmlDoc = htmlWeb.Load(picturePath);
var pictureNodeList = htmlDoc.DocumentNode.SelectNodes(".//div[@class='bdc bgf0 p10']/a/img");
if (pictureNodeList == null)
{
break;
}
foreach (var pictureNode in pictureNodeList)
{
var dishesPicturePath = pictureNode.Attributes["src"].Value;
if (string.IsNullOrEmpty(dishesPicturePath) || dishesPicturePath.EndsWith("food_nopic.png"))
{
return;
}
var storePicture = new Maticsoft.Model.StorePicture();
storePicture.PID = Guid.NewGuid().ToString();
var pictureName = string.Format("{0}.jpg", storePicture.PID);
storePicture.PictureName = pictureName;
storePicture.PicType = picturePathName;
storePicture.PicturePath = dishesPicturePath;
storePicture.StoreId = storeInfo.storeId;
//dishesPicturePath = @"http://f2.95171.cn/pic/D22I15N56303/3cfeefbe-cadd-49af-904b-a33a4b1d6c70.jpg";
//try
//{
// db.DownFile(dishesPicturePath.Replace("/320_0/", "/").Replace(@"/300_200/", "/"), string.Format(newPath, storeInfo.StoreName, picturePathName, pictureName));
//}
//catch (Exception)
//{
//}
//try
//{
// db.DownFile(dishesPicturePath, newPathThumb + pictureName);
//}
//catch (Exception)
//{
// throw;
//}
//var storePath = string.Format(newPath, storeInfo.StoreName, picturePathName, pictureName);
//db.ZoomAuto(newPathThumb + pictureName, picThumbnail + pictureName, 320, 240);//生成缩略图
//db.ZoomAuto(newPathThumb + pictureName, picThumbnail + "640_480_" + pictureName, 640, 480);//生成缩略图
//db.ZoomAuto(newPathThumb + pictureName, picThumbnail + "320_240_" + pictureName, 320, 240);//生成缩略图
//db.ZoomAuto(newPathThumb + pictureName, picThumbnail
// + "160_120_" + pictureName, 160, 120);//生成缩略图
storePictureBll.Add(storePicture);
var storePicturesTable = new Maticsoft.Model.StorePicturesTable();
storePicturesTable.StorePicturesID = Guid.NewGuid().ToString();
storePicturesTable.BusPhotoAlbumID = busphotoAlbumTable.BusPhotoAlbumID;
storePicturesTable.BusinessID = busphotoAlbumTable.BusinessID;
storePicturesTable.PictureAddress = pictureName;
storePicturesTable.PicState = 2;
//storePicturesTable.PicName = dishesPicturePath;
storePicturesTable.UploadTime = DateTime.Now;
storePicturesTableBll.Add(storePicturesTable);
}
}
}
}
public void GetFood(Maticsoft.Model.StoreInfo storeInfo)
{
var dishesPath = "Food";
try
{
//string CreatePath = string.Format(newPath, storeInfo.StoreName, dishesPath, string.Empty);
//if (!Directory.Exists(CreatePath))
//{
// Directory.CreateDirectory(CreatePath);
//}
//var foodThumbnail = string.Format(newThumbnail, dishesPath, storeInfo.StoreName);
//if (!Directory.Exists(foodThumbnail))
//{
// Directory.CreateDirectory(foodThumbnail);
//}
//var newPathThumb = string.Format(newPathThu, dishesPath);
//if (!Directory.Exists(newPathThumb))
//{
// Directory.CreateDirectory(newPathThumb);
//}
var dishesBll = new Maticsoft.BLL.Dishes();
var disheslist = dishesBll.GetModelList(string.Format("StoreId = '{0}'", storeInfo.storeId));
foreach (var dishese in disheslist)
{
dishesBll.Delete(dishese.DishesID);
}
var dishTypeBll = new Maticsoft.BLL.DishesTyepTable();
var dishTypeList = dishTypeBll.GetModelList(string.Format("BusinessID = '{0}'", storeInfo.storeId));
foreach (var dishesTyepTable in dishTypeList)
{
dishTypeBll.Delete(dishesTyepTable.DishesTypeID);
}
var dishTypePath = string.Format("{0}shop/{1}/dish/", _pageUrl, storeInfo.Fid);
var storePictureBll = new StorePicture();
var storePicturelist = storePictureBll.GetModelList(string.Format("StoreID = '{0}' and picType ='{1}'", storeInfo.storeId, dishesPath));
foreach (var storePicture in storePicturelist)
{
storePictureBll.Delete(storePicture.PID);
}
//dishPath = @"http://www.xiaomishu.com/shop/D22I15N56303/dish/";
var htmlWeb = new HtmlWeb();
var htmlDoc = htmlWeb.Load(dishTypePath);
var dishTypeNodeList = htmlDoc.DocumentNode.SelectNodes(".//div[@class='constr']/div[@class='constr_in']/div[@class='l float_four']/div[@class='bdc bgf0 pr10 pb10']/a[@class='res_food_ins_gra']");
if (dishTypeNodeList == null)
{
return;
}
foreach (var dishTypeNode in dishTypeNodeList)
{
var dishType = new Maticsoft.Model.DishesTyepTable();
dishType.BusinessID = storeInfo.storeId;
dishType.CreateDate = DateTime.Now;
dishType.DishesTypeID = Guid.NewGuid().ToString();
var dishName = dishTypeNode.InnerText;
var dishlength = dishName.IndexOf('(');
dishType.DishesTypeName = dishTypeNode.InnerText.Substring(0, dishlength);
dishTypeBll.Add(dishType);
var pageIndex = 1;
while (true)
{
var dishUrl = dishTypeNode.Attributes["href"].Value;
var dishPath = string.Format("{0}{1}p{2}/", _pageUrl, dishUrl, pageIndex);
pageIndex++;
htmlDoc = htmlWeb.Load(dishPath);
var dishesNodeList =
htmlDoc.DocumentNode.SelectNodes(
".//div[@class='constr']/div[@class='constr_in']/div[@class='cell pl10']/ul[@id='foodListUl']/li[@class='res_food_list']");
if (dishesNodeList == null || dishesNodeList.Count <= 1)
{
break;
}
foreach (var dishNode in dishesNodeList)
{
var dishes = new Maticsoft.Model.Dishes();
var foodList = dishNode.SelectSingleNode(".//div[@class='fix']");
if (foodList == null)
{
continue;
}
var foodChildList = foodList.ChildNodes;
var foodName = foodList.ChildNodes.Count > 1 ? foodChildList[1].InnerText ?? string.Empty : string.Empty;
var foodPrice = foodList.ChildNodes.Count > 3 ? foodChildList[3].InnerText ?? string.Empty : string.Empty;
var popularity = foodList.ChildNodes.Count > 5 ? foodChildList[5].InnerText ?? string.Empty : string.Empty;
dishes.DishesID = Guid.NewGuid().ToString();
dishes.DishesName = foodName.Trim();
foodPrice = foodPrice.Trim().Replace("￥", string.Empty).Replace("¥", string.Empty);
dishes.dishTypeID = dishType.DishesTypeID;
if (foodPrice.Trim() == "时价")
{
dishes.DishesMoney = "0";
dishes.IsCurrentPrice = true;
}
else if (foodPrice.Trim() == "不详")
{
dishes.DishesMoney = "0";
}
else
{
dishes.DishesMoney = foodPrice;
}
dishes.popularity = popularity.Trim();
dishes.StoreId = storeInfo.storeId;
var dishesPictureNode = dishNode.SelectSingleNode(
".//div[@class='abs_out pt10']/div[@class='fix rel']/div[@class='pct50 l']/a[@class='g3']/img");
if (dishesPictureNode != null)
{
var dishesPicturePath = dishesPictureNode.Attributes["src"].Value;
if (!string.IsNullOrEmpty(dishesPicturePath) && !dishesPicturePath.EndsWith("food_nopic.png"))
{
var storePicture = new Maticsoft.Model.StorePicture();
storePicture.PID = Guid.NewGuid().ToString();
var pictureName = string.Format("{0}.jpg", storePicture.PID);
storePicture.PictureName = pictureName;
storePicture.PicType = dishesPath;
storePicture.PicturePath = dishesPicturePath;
storePicture.StoreId = storeInfo.storeId;
storePictureBll.Add(storePicture);
dishes.PictureName = pictureName;
//try
//{
// db.DownFile(dishesPicturePath.Replace(@"/300_200/", "/").Replace("/320_0/", "/"), string.Format(newPath, storeInfo.StoreName, dishesPath, dishes.PictureName));
//}
//catch (Exception)
//{
//}
//try
//{
// db.DownFile(dishesPicturePath, newPathThumb + dishes.PictureName);
//}
//catch (Exception)
//{
// throw;
//}
//var storeInfopath = string.Format(newPath, storeInfo.StoreName, dishesPath, dishes.PictureName);
//db.ZoomAuto(newPathThumb + dishes.PictureName, foodThumbnail + dishes.PictureName, 320, 240);//生成缩略图
//db.ZoomAuto(newPathThumb + dishes.PictureName, foodThumbnail + "640_480_" + dishes.PictureName, 640, 480);//生成缩略图
//db.ZoomAuto(newPathThumb + dishes.PictureName, foodThumbnail + "320_240_" + dishes.PictureName, 320, 240);//生成缩略图
//db.ZoomAuto(newPathThumb + dishes.PictureName, foodThumbnail + "160_120_" + dishes.PictureName, 160, 120);//生成缩略图
}
}
dishesBll.Add(dishes);
}
}
}
}
catch (Exception e)
{
}
}
public IHttpActionResult ImportData()
{
// return BadRequest("导入关闭");
Near n = null;
try
{
//string url = "http://www.xianmi.me/qzxm/index.php/Wap/Wm/index/memid/511/lng/118.8702400000/lat/28.961739.html";
//string result = Request(url);
//int start = result.IndexOf("var near = ");
//int end = result.IndexOf("</script>", start);
//string json = result.Substring(start, end).Replace("var near = ", "");
string json = "{'types':[{'id':'45','name':'衢名小吃','storeids':'42,1072','storenum':2},{'id':'44','name':'营养早餐','storeids':'42,588,1067,1072,1083,1090,1107,1128,1139','storenum':9},{'id':'40','name':'精品炒菜','storeids':'42,869,873,984','storenum':4},{'id':'37','name':'鲜米水果','storeids':'1022','storenum':1},{'id':'20','name':'中式快餐','storeids':'144,499,509,515,873,983,1012','storenum':7},{'id':'21','name':'西式快餐','storeids':'960,985,1013','storenum':3},{'id':'22','name':'特色小吃','storeids':'42,50,54,465,534,582,588,746,749,750,764,825,828,829,860,892,906,940,945,954,972,974,984,1019,1028,1042,1047,1049,1051,1103,1104,1107,1122,1123,1127,1128,1130,1134,1137,1138','storenum':40},{'id':'23','name':'甜品饮料','storeids':'55,283,472,496,528,586,748,756,785,1039,1057,1126','storenum':12},{'id':'24','name':'日韩料理','storeids':'61,944','storenum':2},{'id':'35','name':'西餐','storeids':'507,519','storenum':2}],'count':73,'stores':[{'id':'1130','delivery_mode':'1','name':'绝味鸭脖（坊门街）','pic':'/qzxm/Uploads/2016-07-20/578f5220db9b8.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':17,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'54','delivery_mode':'1','name':'衢老高（原老高粉干）','pic':'/qzxm/Uploads/2015-11-18/564c574103ed2.png','fee':3,'minconsumption':'10','status':1,'ordernum':2478,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1049','delivery_mode':'1','name':'荣华凉皮','pic':'/qzxm/Uploads/2016-05-02/5726ffa333bf8.jpg','fee':8,'minconsumption':'10','status':1,'ordernum':93,'delivery_desc':'10元起送，配送费8元','district':0.5},{'id':'940','delivery_mode':'1','name':'蒸食膳','pic':'/qzxm/Uploads/2015-10-20/56261113deac1.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':340,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'55','delivery_mode':'1','name':'（衢州总店下街店）阿姨奶茶专卖（活动期间满二十送酸梅汤一杯）','pic':'/qzxm/Uploads/2015-01-18/54bb197f05490.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':2779,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'984','delivery_mode':'1','name':'瘸子实惠饭店','pic':'/qzxm/Uploads/2016-01-15/5698697f7a22f.jpeg','fee':3,'minconsumption':'20','status':1,'ordernum':322,'delivery_desc':'20元起送，配送费3元','district':0.5},{'id':'873','delivery_mode':'1','name':'（下午1：30 —— 4：30休息）好食代（原国良鸭头）','pic':'/qzxm/Uploads/2015-08-06/55c319ba31857.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':100,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'42','delivery_mode':'1','name':'余记烤饼（后街巷）','pic':'/qzxm/Uploads/2014-11-05/5459947e14968.gif','fee':3,'minconsumption':'10','status':1,'ordernum':8442,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'892','delivery_mode':'1','name':'斗潭粥铺（下午14：00--16：30休息）','pic':'/qzxm/Uploads/2015-08-28/55e007a9ad5c7.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':616,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1107','delivery_mode':'1','name':'（早餐-7-10点单配送，10-24点可接受预定）（新店上线）胖小妹肉圆，盖浇饭（下单满15送冷饮）','pic':'/qzxm/Uploads/2016-06-29/5773a67c643c1.JPG','fee':5,'minconsumption':'15','status':1,'ordernum':37,'delivery_desc':'15元起送，配送费5元','district':0.5},{'id':'144','delivery_mode':'1','name':'老焙粉干（斗潭东区）','pic':'/qzxm/Uploads/2014-10-11/54390c24bb8e7.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':3503,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'582','delivery_mode':'1','name':'传世老北京卤肉卷','pic':'/qzxm/Uploads/2015-01-20/54be4a3cadedc.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':1745,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'61','delivery_mode':'1','name':'（下街）鲜目录外带寿司','pic':'/qzxm/Uploads/2014-10-11/543907058c6ba.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':1595,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'750','delivery_mode':'1','name':'原新旺煲仔（后街巷）','pic':'/qzxm/Uploads/2015-05-10/554eda86c22f6.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':1361,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'50','delivery_mode':'1','name':'重庆酸辣粉（米兰对面弄堂棋坊巷）','pic':'/qzxm/Uploads/2015-03-26/55139e8245123.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':1285,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'828','delivery_mode':'1','name':'精武鸭脖（十年老店，卖鸭头的小伙子）','pic':'/qzxm/Uploads/2015-07-02/5594f0f23724f.jpg','fee':3,'minconsumption':'20','status':1,'ordernum':1220,'delivery_desc':'20元起送，配送费3元','district':0.5},{'id':'465','delivery_mode':'1','name':'杨家巷烤饼','pic':'/qzxm/Uploads/2015-06-27/558e697fd7eea.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':1193,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'283','delivery_mode':'1','name':'Rand B珍奶会所','pic':'/qzxm/Uploads/2014-07-30/53d8bdb7d7590.png','fee':3,'minconsumption':'10','status':1,'ordernum':1044,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'746','delivery_mode':'1','name':'爱之味铁板烧','pic':'/qzxm/Uploads/2015-05-09/554df6c441ffb.jpg','fee':3,'minconsumption':'20','status':1,'ordernum':1020,'delivery_desc':'20元起送，配送费3元','district':0.5},{'id':'528','delivery_mode':'1','name':'杨小贤','pic':'/qzxm/Uploads/2014-11-06/545b22a4edd30.gif','fee':3,'minconsumption':'10','status':1,'ordernum':996,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'499','delivery_mode':'1','name':'老杜酱果（斗潭东区）（下午14：00--16：00休息）','pic':'/qzxm/Uploads/2014-10-11/54390c683d25b.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':973,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'869','delivery_mode':'1','name':'傅家小厨（炒菜）','pic':'/qzxm/Uploads/2015-08-05/55c1cdd9857d0.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':839,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'748','delivery_mode':'1','name':'黑泷堂','pic':'/qzxm/Uploads/2015-05-09/554dff9b61159.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':793,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'749','delivery_mode':'1','name':'陆老爹','pic':'/qzxm/Uploads/2015-05-10/554f072f1ec8c.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':628,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'906','delivery_mode':'1','name':'拌面粥道','pic':'/qzxm/Uploads/2015-09-05/55ea9a7ef3490.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':492,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'829','delivery_mode':'1','name':'口口乐私房面馆','pic':'/qzxm/Uploads/2015-07-02/559500ae96c76.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':457,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1072','delivery_mode':'1','name':'（早餐-10点-24点接受预定）兰溪煎饺（钟楼底店）','pic':'/qzxm/Uploads/2016-05-22/5741978d44adf.jpg','fee':5,'minconsumption':'8','status':1,'ordernum':421,'delivery_desc':'8元起送，配送费5元','district':0.5},{'id':'588','delivery_mode':'1','name':'煎饼哥','pic':'/qzxm/Uploads/2015-06-23/55892fe4c890f.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':379,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1019','delivery_mode':'1','name':'馋嘴花甲（新桥街店）','pic':'/qzxm/Uploads/2016-03-09/56df977335d93.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':309,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'785','delivery_mode':'1','name':'甘茶度','pic':'/qzxm/Uploads/2015-06-19/5583db79ef2ea.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':304,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'825','delivery_mode':'1','name':'衢福记','pic':'/qzxm/Uploads/2015-07-02/5594e49e2421b.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':275,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'496','delivery_mode':'1','name':'muse手工烘焙','pic':'/qzxm/Uploads/2014-10-14/543cc8a9b38b2.gif','fee':3,'minconsumption':'10','status':1,'ordernum':258,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'534','delivery_mode':'1','name':'瘸子馄饨','pic':'/qzxm/Uploads/2014-11-20/546de100b1837.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':254,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'974','delivery_mode':'1','name':'（新店上线）骨汤麻辣烫（推荐）','pic':'/qzxm/Uploads/2015-12-14/566e65211d9b7.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':245,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'509','delivery_mode':'1','name':'飞鸿面馆','pic':'/qzxm/Uploads/2014-10-11/543906241486b.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':239,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'945','delivery_mode':'1','name':'武汉黑鸭','pic':'/qzxm/Uploads/2015-10-26/562de8074522f.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':197,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1039','delivery_mode':'1','name':'（新店上线）50岚（鲜茶专卖连锁）','pic':'/qzxm/Uploads/2016-04-26/571f363e53076.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':194,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'954','delivery_mode':'1','name':'渝口福重庆小面','pic':'/qzxm/Uploads/2015-11-09/56406d788433e.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':192,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'472','delivery_mode':'1','name':'柒寿司（果沫奶茶）','pic':'/qzxm/Uploads/2014-10-11/54390ad75571f.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':187,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'764','delivery_mode':'1','name':'重庆麻辣烫（十三香龙虾）','pic':'/qzxm/Uploads/2015-05-22/555edb2411222.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':102,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1090','delivery_mode':'1','name':'（早餐-7-10点单配送，10-24点可接受预定）乐行食','pic':'/qzxm/Uploads/2016-05-28/57491f81adc9b.jpg','fee':5,'minconsumption':'10','status':1,'ordernum':91,'delivery_desc':'10元起送，配送费5元','district':0.5},{'id':'586','delivery_mode':'1','name':'三公主奶茶','pic':'/qzxm/Uploads/2015-01-24/54c36fae07edb.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':90,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1051','delivery_mode':'1','name':'方记粥铺','pic':'/qzxm/Uploads/2016-05-08/572f09299d329.png','fee':3,'minconsumption':'10','status':1,'ordernum':89,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'756','delivery_mode':'1','name':'罗蒂爸爸','pic':'/qzxm/Uploads/2015-05-15/55558f82c68cd.jpg','fee':3,'minconsumption':'20','status':1,'ordernum':85,'delivery_desc':'20元起送，配送费3元','district':0.5},{'id':'507','delivery_mode':'1','name':'拉芳舍','pic':'/qzxm/Uploads/2014-10-11/5439066225598.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':70,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'519','delivery_mode':'1','name':'英爵咖啡','pic':'/qzxm/Uploads/2014-11-06/545b332c65ffb.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':69,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'944','delivery_mode':'1','name':'阿美丽韩式料理','pic':'/qzxm/Uploads/2015-10-25/562c782e47177.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':54,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'985','delivery_mode':'1','name':'小西门咖啡','pic':'/qzxm/Uploads/2016-01-21/56a0b97c547ab.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':54,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1042','delivery_mode':'1','name':'豪大大鸡排','pic':'/qzxm/Uploads/2016-04-30/5724698be55ff.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':54,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1057','delivery_mode':'1','name':'大麦Bake（衢州店）','pic':'/qzxm/Uploads/2016-05-22/574162e6c3ce9.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':48,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1083','delivery_mode':'1','name':'（早餐-7-10点单配送，10-24点可接受预定）红樱桃美食','pic':'/qzxm/Uploads/2016-05-25/574530b1ed1e1.png','fee':5,'minconsumption':'5','status':1,'ordernum':46,'delivery_desc':'5元起送，配送费5元','district':0.5},{'id':'1103','delivery_mode':'1','name':'重庆小面（中河沿）','pic':'/qzxm/Uploads/2016-06-19/57663a630b1de.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':46,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1012','delivery_mode':'1','name':'三毛煲店','pic':'/qzxm/Uploads/2016-03-07/56dd1964c245c.jpg','fee':3,'minconsumption':'68','status':1,'ordernum':39,'delivery_desc':'68元起送，配送费3元','district':0.5},{'id':'1067','delivery_mode':'1','name':'（早餐-10点-24点接受预定）肯德基早餐（香溢）','pic':'/qzxm/Uploads/2016-05-22/574187da2a8e8.jpg','fee':10,'minconsumption':'0','status':1,'ordernum':35,'delivery_desc':'0元起送，配送费10元','district':0.5},{'id':'1013','delivery_mode':'1','name':'肯德基（香溢店）','pic':'/qzxm/Uploads/2016-03-07/56dd1a7c46da9.jpg','fee':10,'minconsumption':'10','status':1,'ordernum':34,'delivery_desc':'10元起送，配送费10元','district':0.5},{'id':'515','delivery_mode':'1','name':'香雪面馆','pic':'/qzxm/Uploads/2014-10-14/543ccaaab3e47.gif','fee':3,'minconsumption':'10','status':1,'ordernum':26,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1022','delivery_mode':'1','name':'果缤纷','pic':'/qzxm/Uploads/2016-03-23/56f24791169dc.jpg','fee':3,'minconsumption':'15','status':1,'ordernum':21,'delivery_desc':'15元起送，配送费3元','district':0.5},{'id':'1104','delivery_mode':'1','name':'重庆小面（后街巷）','pic':'/qzxm/Uploads/2016-06-19/57663a7944055.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':21,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1127','delivery_mode':'1','name':'（新店上线）来自明洞（韩国炸鸡）','pic':'/qzxm/Uploads/2016-07-21/5790229ed9c48.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':19,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1047','delivery_mode':'1','name':'全旺山粉饺（裱背巷店）','pic':'/qzxm/Uploads/2016-05-02/57270025619db.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':17,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1122','delivery_mode':'1','name':'椿林麻辣烫（满十五送饮料一份）（另加打包费1元）','pic':'/qzxm/Uploads/2016-07-14/57870aaf7ac6d.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':11,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'983','delivery_mode':'1','name':'爱吧餐厅（正常）','pic':'/qzxm/Uploads/2016-01-06/568ccbee44d5a.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':7,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1126','delivery_mode':'1','name':'（新店上线）享廿茶','pic':'/qzxm/Uploads/2016-07-20/578ee8249d8e3.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':4,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1138','delivery_mode':'1','name':'（新店上线）遵义虾子张六羊肉粉','pic':'/qzxm/Uploads/2016-08-19/57b68fa70cc02.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':4,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1123','delivery_mode':'1','name':'重庆小面（日新巷）','pic':'/qzxm/Uploads/2016-07-14/57870ae0c1689.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':3,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1134','delivery_mode':'1','name':'（新店上线）开心花甲粉','pic':'/qzxm/Uploads/2016-08-06/57a5d0d2b66d1.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':1,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1139','delivery_mode':'1','name':'（早餐-7-10点单配送，10-24点可接受预定）遵义虾子张六羊肉粉','pic':'/qzxm/Uploads/2016-08-19/57b68f8b0e704.JPG','fee':5,'minconsumption':'10','status':1,'ordernum':1,'delivery_desc':'10元起送，配送费5元','district':0.5},{'id':'960','delivery_mode':'1','name':'大茴香咖啡','pic':'/qzxm/Uploads/2015-11-14/5646ff5461019.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':0,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1028','delivery_mode':'1','name':'虞家面食','pic':'/qzxm/Uploads/2016-04-02/56ff66934014f.jpg','fee':3,'minconsumption':'10','status':1,'ordernum':0,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1137','delivery_mode':'1','name':'（新店上线）蜀锦香厕所串串（另加1元打包费）（下午5:00——9:00休息）','pic':'/qzxm/Uploads/2016-08-19/57b69020a7d29.JPG','fee':3,'minconsumption':'10','status':1,'ordernum':0,'delivery_desc':'10元起送，配送费3元','district':0.5},{'id':'1128','delivery_mode':'1','name':'（新店上线）玲珑生煎馆','pic':'/qzxm/Uploads/2016-07-20/578f1e1cd3947.JPG','fee':5,'minconsumption':'10','status':0,'ordernum':95,'delivery_desc':'10元起送，配送费5元','district':0.5},{'id':'860','delivery_mode':'1','name':'虾大大（龙虾每份两斤起做）（龙虾3斤以内打包费3元。主食打包每份1元，凉菜打包每份1元）（下午4：00-凌晨1：00营业）','pic':'/qzxm/Uploads/2015-07-30/55b9e33042e5b.jpg','fee':5,'minconsumption':'30','status':0,'ordernum':75,'delivery_desc':'30元起送，配送费5元','district':0.5},{'id':'972','delivery_mode':'1','name':'金氏精武鸭脖（四季青旁边）','pic':'/qzxm/Uploads/2015-12-05/56629f5a8587c.jpg','fee':3,'minconsumption':'10','status':0,'ordernum':134,'delivery_desc':'10元起送，配送费3元','district':0.5}],'tag':1}";
n = JsonConvert.DeserializeObject <Near>(json);
foreach (var store in n.stores)
{
string url = "http://www.xianmi.me/qzxm/index.php/Wap/Wm/getStore/memid/1/lng/138.854582/lat/28.968332.html?store_id=" + store.id;
string result = SendRequest(url);
var sss = JsonConvert.DeserializeObject <Stores>(result);
store.dishes = sss.dishes;
store.types = sss.types;
}
}
catch (Exception e)
{
}
string errorStore = "";
var sCList = new List <QMTech.Core.Domain.Catalog.StoreCategory>();
//遍历商家分类
var k = 0;
foreach (var type in n.types)
{
if (_categoryService.GetAllStoreCategories(type.name).Count > 0)
{
continue;
}
var sCategory = new QMTech.Core.Domain.Catalog.StoreCategory
{
Name = type.name,
DisplayOrder = k,
Published = true,
Description = type.storeids
};
_categoryService.InsertStoreCategory(sCategory);
sCList.Add(sCategory);
k++;
}
if (sCList.Count == 0)
{
sCList = _categoryService.GetAllStoreCategories().ToList();
}
//先遍历商家
foreach (var store in n.stores)
{
try
{
#region 导入商家
var sCategory = sCList.Where(sc => sc.Description.Contains(store.id)).FirstOrDefault();
if (sCategory == null)
{
continue;
}
var storeDb = new QMTech.Core.Domain.Catalog.Store()
{
Name = store.name,
AllOpened = true,
Description = store.id,
Lat = 118.85F,
Lon = 28.62F,
SelfSupport = true,
DisplayOrder = new Random().Next(0, 100),
Address = "测试商家地址",
Published = true,
StoreCategory = sCategory
};
//保存商店
_storeService.InsertStore(storeDb);
var url = string.Format("http://www.xianmi.me{0}", store.pic);
var mimeType = GetMimeType(url);
var data = DownloadPict(url, mimeType);
var picture = _pictureService.InsertPicture(data, mimeType, "");
//关联
var storePicture = new StorePicture
{
IsLogo = true,
Picture = picture,
Store = storeDb,
DisplayOrder = 0
};
_storeService.InsertStorePicture(storePicture);
//保存商品分类
var i = 0;
foreach (var type in store.types)
{
var productCategory = new ProductCategory
{
Name = type.name,
DisplayOrder = i,
StoreId = storeDb.Id,
Published = true,
Description = type.id
};
_categoryService.InsertProductCategory(productCategory);
i++;
}
//保存商品
i = 0;
foreach (var dish in store.dishes)
{
var dishType = _categoryService.GetAllProductCategories(storeDb.Id).Where(pc => pc.Description.Contains(dish.dishtype)).FirstOrDefault();
if (dishType == null)
{
continue;
}
var product = new QMTech.Core.Domain.Catalog.Product()
{
Name = dish.name,
Price = decimal.Parse(dish.price),
OldPrice = decimal.Parse(dish.price),
ProductCategory = dishType,
Published = true,
Store = storeDb
};
_productService.InsertProduct(product);
if (string.IsNullOrEmpty(dish.pic))
{
continue;
}
url = string.Format("http://www.xianmi.me{0}", dish.pic);
mimeType = GetMimeType(url);
data = DownloadPict(url, mimeType);
try
{
picture = _pictureService.InsertPicture(data, mimeType, "");
_productService.InsertProductPicture(
new ProductPicture
{
Picture = picture,
Product = product
});
i++;
}
catch (Exception ex)
{
}
}
#endregion
}
catch (Exception e)
{
errorStore += store.name + ",";
}
}
return(Ok("导入成功"));
}
