public int InfoCount() { using (var context = new FxHouseContext()) { return context.HouseBuyInfos.Count() + context.HouseTransferInfos.Count(); } }
/// <summary> /// 房屋帖子数量(求购+转让) /// </summary> /// <returns></returns> public int InfoCount() { using (var context = new FxHouseContext()) { return(context.HouseBuyInfos.Count() + context.HouseTransferInfos.Count()); } }
/// <summary> /// 获取房屋求购信息 /// </summary> /// <param name="Id">房屋求购Id</param> /// <returns>房屋求购信息</returns> public Entity.FxHouse.HouseBuyInfo Get(int Id) { using (FxHouseContext context = new FxHouseContext()) { return(context.HouseBuyInfos.Where(r => r.HouseBuyInfoId == Id).FirstOrDefault()); } }
public Entity.FxHouse.HouseBuyInfo Get(int Id) { using (FxHouseContext context = new FxHouseContext()) { return context.HouseBuyInfos.Where(r => r.HouseBuyInfoId == Id).FirstOrDefault(); } }
public void CreateHouse() { //System.Data.Entity.Database.SetInitializer(new FxHouseInitializer()); FxHouseContext context = new FxHouseContext(); var entity = new Fx.Entity.FxHouse.HouseBuyInfo() { Action = "Action", AreaId = 1, Bill = false, CatagroyId = 1, CityId = 1, Controller = "Controller", HasFurniture = false, Mark = "Mark", Price = 1000, PublishTitle = "Title", PublishUserEmail = "PublishUserEmail", RoomNumber = 6, UserAccount = "UserAccount" }; context.HouseBuyInfos.Add(entity); context.SaveChanges(); context.HouseBuyInfos.Remove(entity); context.SaveChanges(); }
public Entity.FxHouse.HouseTransferInfo Get(int Id) { using (FxHouseContext context = new FxHouseContext()) { return context.HouseTransferInfos.Include(r => r.Pictures) .Where(r => r.HouseTransferInfoId == Id).FirstOrDefault(); } }
/// <summary> /// 获取房屋转让信息 /// </summary> /// <param name="Id">房屋转让Id</param> /// <returns>房屋转让信息</returns> public Entity.FxHouse.HouseTransferInfo Get(int Id) { using (FxHouseContext context = new FxHouseContext()) { return(context.HouseTransferInfos.Include(r => r.Pictures) .Where(r => r.HouseTransferInfoId == Id).FirstOrDefault()); } }
public bool SaveBuyHouse(Entity.FxHouse.HouseBuyInfo house) { using (FxHouseContext context = new FxHouseContext()) { context.HouseBuyInfos.Add(house); context.SaveChanges(); } return house.HouseBuyInfoId > 0; }
/// <summary> /// 保存房屋求购信息 /// </summary> /// <param name="house">房屋求购信息</param> /// <returns>是否保存成功</returns> public bool SaveBuyHouse(Entity.FxHouse.HouseBuyInfo house) { using (FxHouseContext context = new FxHouseContext()) { context.HouseBuyInfos.Add(house); context.SaveChanges(); } return(house.HouseBuyInfoId > 0); }
/// <summary> /// 保存房屋转让信息 /// </summary> /// <param name="house">房屋转让信息</param> /// <returns>是否保存成功</returns> public bool SaveTransferHouse(HouseTransferInfo house) { using (var context = new FxHouseContext()) { context.HouseTransferInfos.Add(house); context.SaveChanges(); } return(house.HouseTransferInfoId > 0); }
public bool SaveTransferHouse(HouseTransferInfo house) { using (var context = new FxHouseContext()) { context.HouseTransferInfos.Add(house); context.SaveChanges(); } return house.HouseTransferInfoId > 0; }
public void Authorize() { int houseId = JobQueue.HouseBuyJobLoadQueue.GetItem(houseBuyJobService.Authorizing); if (houseId == 0) { return; } using (var context = new FxHouseContext()) { while (houseId != 0) { var house = context.HouseBuyInfos.Where(r => r.HouseBuyInfoId == houseId). Select(r => new { r.Mark, r.PublishTitle }).FirstOrDefault(); if (house != null) { if (filter.FilterContent(house.Mark).Success && filter.FilterContent(house.PublishTitle).Success) { try { houseBuyJobService.AuthorizeSuccess(houseId); houseBuyJobService.Publish(houseId); } catch (Exception ex) { ex.LogEx(string.Format("{0} {1} {2}", JobKey, "houseBuyJobService.AuthorizeSuccess", houseId)); } } else { try { string msg = ""; var filter1 = filter.FilterContent(house.Mark); var filter2 = filter.FilterContent(house.PublishTitle); if (!filter1.Success) { msg += string.Format("你的帖子中包含了[[{0}]] 这个关键字", filter1.Key); } if (!filter2.Success) { msg += string.Format("你的帖子中包含了[[{0}]] 这个关键字", filter2.Key); } houseBuyJobService.AuthorizeFaild(houseId,msg); } catch (Exception ex) { ex.LogEx(string.Format("{0} {1} {2}", JobKey, "houseBuyJobService.AuthorizeFaild", houseId)); } } houseId = JobQueue.HouseBuyJobLoadQueue.GetItem(houseBuyJobService.Authorizing); } } } }
/// <summary> /// 居住用房列表 /// </summary> /// <returns></returns> public List<HouseTransferInfo> Properties() { List<HouseTransferInfo> list; using (FxHouseContext context = new FxHouseContext()) { list = context.HouseTransferInfos.Include(r => r.Pictures) .Where(r => r.IsPublish == true && r.Action == "Properties") .OrderByDescending(r => r.CreatedTime) .Take(20).ToList(); } if ((list.Count % 4) != 0) { return list.Take(list.Count - list.Count % 4).ToList(); } return list; }
/// <summary> /// 认证成功 /// </summary> /// <param name="houseId">房屋转让帖子Id</param> /// <returns>操作是否成功</returns> public bool AuthorizeSuccess(int houseId) { using (var context = new FxHouseContext()) { var house = context.HouseTransferInfos.Where(r => r.HouseTransferInfoId == houseId).FirstOrDefault(); if (house != null) { house.InfoProcessState = (int)ProcessState.AuthorizeSuccess; house.Logs.Add(new Entity.FxHouse.HouseTransferLog() { OperteName = Enum.GetName(typeof(ProcessState), ProcessState.AuthorizeSuccess) }); return context.SaveChanges() > 0; } } return false; }
/// <summary> /// 图片CDN中... /// </summary> /// <param name="houseId">房屋转让帖子Id</param> /// <returns>操作是否成功</returns> public bool PictrueCdning(int houseId) { using (var context = new FxHouseContext()) { var house = context.HouseTransferInfos.Where(r => r.HouseTransferInfoId == houseId).FirstOrDefault(); if (house != null) { house.InfoProcessState = (int)ProcessState.PictrueCdning; house.Logs.Add(new Entity.FxHouse.HouseTransferLog() { OperteName = Enum.GetName(typeof(ProcessState), ProcessState.PictrueCdning) }); return(context.SaveChanges() > 0); } } return(false); }
/// <summary> /// 居住用房列表 /// </summary> /// <returns></returns> public List <HouseTransferInfo> Properties() { List <HouseTransferInfo> list; using (FxHouseContext context = new FxHouseContext()) { list = context.HouseTransferInfos.Include(r => r.Pictures) .Where(r => r.IsPublish == true && r.Action == "Properties") .OrderByDescending(r => r.CreatedTime) .Take(20).ToList(); } if ((list.Count % 4) != 0) { return(list.Take(list.Count - list.Count % 4).ToList()); } return(list); }
/// <summary> /// 认证失败 /// </summary> /// <param name="houseId">房屋转让帖子Id</param> /// <param name="msg">认证失败错误信息</param> /// <returns>操作是否成功</returns> public bool AuthorizeFaild(int houseId, string msg) { using (var context = new FxHouseContext()) { var house = context.HouseTransferInfos.Where(r => r.HouseTransferInfoId == houseId).FirstOrDefault(); if (house != null) { house.InfoProcessState = (int)ProcessState.AuthorizeFaild; house.ErrorMsg = msg; house.Logs.Add(new Entity.FxHouse.HouseTransferLog() { OperteName = Enum.GetName(typeof(ProcessState), ProcessState.AuthorizeFaild) }); return(context.SaveChanges() > 0); } } return(false); }
public void LoadJob() { try { List<int> list = new List<int>(); using (var context = new FxHouseContext()) { list = context.HouseTransferInfos .Where(r => r.InfoProcessState == (int)ProcessState.Commit). Select(r => r.HouseTransferInfoId).Take(20).ToList(); } JobQueue.HouseTransferJobLoadQueue.AddRange(list); } catch (Exception ex) { ex.LogEx(string.Format("{0} {1}", JobKey, "HouseBuyJobLoad")); } }
public bool AuthorizeFaild(int houseId,string msg) { using (var context = new FxHouseContext()) { var house = context.HouseBuyInfos.Where(r => r.HouseBuyInfoId == houseId).FirstOrDefault(); if (house != null) { house.InfoProcessState = (int)ProcessState.AuthorizeFaild; house.ErrorMsg = msg; house.Logs.Add(new Entity.FxHouse.HouseBuyLog() { OperteName = Enum.GetName(typeof(ProcessState), ProcessState.AuthorizeFaild) }); return context.SaveChanges() > 0; } } return false; }
public bool Publish(int houseId) { using (var context = new FxHouseContext()) { var house = context.HouseBuyInfos.Where(r => r.HouseBuyInfoId == houseId).FirstOrDefault(); if (house != null) { house.InfoProcessState = (int)ProcessState.Publish; house.IsPublish = true; house.Logs.Add(new Entity.FxHouse.HouseBuyLog() { OperteName = Enum.GetName(typeof(ProcessState), ProcessState.Publish) }); return context.SaveChanges() > 0; } } return false; }
/// <summary> /// 删除 /// </summary> /// <param name="houseId">房屋求购帖子Id</param> /// <returns>操作是否成功</returns> public bool Delete(int houseId) { using (var context = new FxHouseContext()) { var house = context.HouseBuyInfos.Where(r => r.HouseBuyInfoId == houseId).FirstOrDefault(); if (house != null) { house.InfoProcessState = (int)ProcessState.Delete; house.IsPublish = false; house.IsDelete = true; house.Logs.Add(new Entity.FxHouse.HouseBuyLog() { OperteName = Enum.GetName(typeof(ProcessState), ProcessState.Delete) }); return(context.SaveChanges() > 0); } } return(false); }
/// <summary> /// 图片CDN失败 /// </summary> /// <param name="houseId">房屋转让帖子Id</param> /// <param name="errorMsg">图片CDN失败错误信息</param> /// <returns>操作是否成功</returns> public bool PictrueCdnFailed(int houseId, string errorMsg) { using (var context = new FxHouseContext()) { var house = context.HouseTransferInfos.Where(r => r.HouseTransferInfoId == houseId).FirstOrDefault(); if (house != null) { house.InfoProcessState = (int)ProcessState.PictrueCdnFailed; house.Logs.Add(new Entity.FxHouse.HouseTransferLog() { OperteName = Enum.GetName(typeof(ProcessState), ProcessState.PictrueCdnFailed) }); context.PictureCdnErrors.Add(new PictureCdnError() { ErorMsg = errorMsg, ObjectId = houseId, SourceType = (int)ChannelCatagroy.FxHouseTrasnfer }); return(context.SaveChanges() > 0); } } return(false); }
/// <summary> /// 图片CDN失败 /// </summary> /// <param name="houseId">房屋转让帖子Id</param> /// <param name="errorMsg">图片CDN失败错误信息</param> /// <returns>操作是否成功</returns> public bool PictrueCdnFailed(int houseId, string errorMsg) { using (var context = new FxHouseContext()) { var house = context.HouseTransferInfos.Where(r => r.HouseTransferInfoId == houseId).FirstOrDefault(); if (house != null) { house.InfoProcessState = (int)ProcessState.PictrueCdnFailed; house.Logs.Add(new Entity.FxHouse.HouseTransferLog() { OperteName = Enum.GetName(typeof(ProcessState), ProcessState.PictrueCdnFailed) }); context.PictureCdnErrors.Add(new PictureCdnError() { ErorMsg = errorMsg, ObjectId = houseId, SourceType = (int)ChannelCatagroy.FxHouseTrasnfer }); return context.SaveChanges() > 0; } } return false; }
public void PictureProcess() { int houseId = JobQueue.HouseTransferJobPictureProcessQueue.GetItem(houseTransferJobService.PictrueCdning); if (houseId == 0) { return; } using (var context = new FxHouseContext()) { while (houseId != 0) { var car = context.HouseTransferInfos.Where(r => r.HouseTransferInfoId == houseId).FirstOrDefault(); if (car != null) { string source; string destnation; string destnationmin; int error = 0; string errmsg = ""; foreach (var picture in car.Pictures) { try { source = string.Format(picture.PhysicalPath); destnation = string.Format("{0}{1}", appSettings.CdnPath(), picture.ImageUrl.Replace(@"/", @"\")); destnationmin = string.Format("{0}{1}", appSettings.CdnPath(), picture.MinImageUrl.Replace(@"/", @"\")); var job = new ImageJob(source, destnation, new ResizeSettings() { MaxHeight = 500, MaxWidth = 500, }) { CreateParentDirectory = true }; var jobmin = new ImageJob(source, destnationmin, new ResizeSettings() { MaxHeight = 64, MaxWidth = 64, }) { CreateParentDirectory = true }; ImageBuilder.Current.Build(job); ImageBuilder.Current.Build(jobmin); } catch (Exception ex) { if (string.IsNullOrEmpty(errmsg)) { if (ex.InnerException != null) { errmsg = ex.InnerException.Message; } else { errmsg = ex.Message; } } error++; ex.LogEx(string.Format("{0} {1} {2}", JobKey, "PictureProcess", picture.TransferPictureId)); } } if (error == 0) { houseTransferJobService.PictrueCdnSuccessd(houseId); houseTransferJobService.Publish(houseId); } else { houseTransferJobService.PictrueCdnFailed(houseId, errmsg); } houseId = JobQueue.HouseTransferJobPictureProcessQueue.GetItem(houseTransferJobService.PictrueCdning); } } } }