//工长加入装修案例 public int AddWebBuiding(WebBuiding webBuiding) { using (AIYunNetContext context = new AIYunNetContext()) { context.WebBuiding.Add(webBuiding); DecDemand dec = context.DecDemand.Find(webBuiding.DemandID); if (dec != null) { dec.IsPlan = true; } context.SaveChanges(); if (webBuiding.constructionstageID != null) { WebBuiding org = GetWebBuidingByDemandID(webBuiding.DemandID); List <string> listid = webBuiding.constructionstageID.Split(',').Where(c => c != "").ToList(); List <string> listStage = webBuiding.constructionstage.Split(',').Where(c => c != "").ToList(); int i = 0; foreach (string id in listid) { WebBuidingStages stage = new WebBuidingStages { WebBuidingID = org.BuidingID, StageID = Convert.ToInt32(id), StageName = listStage[i], sortID = i }; context.WebBuidingStages.Add(stage); i++; } context.SaveChanges(); } return(1); } }
public ActionResult buidingStageByWorker(int DemandID = 0, int BuidingID = 0) { IWebCommon commonService = new WebCommonService(); List <WebLookup> commonworkPosition = commonService.GetLookupList("Buiding_process"); IEnumerable <SelectListItem> workPositionList = commonworkPosition.Select(com => new SelectListItem { Value = com.Code.ToString(), Text = com.Description }); ViewBag.workPositionList = workPositionList; WebBuiding buidling = buidSer.GetWebBuidingByDemandID(DemandID); if (BuidingID != 0 && DemandID == 0) { buidling = buidSer.GetWebuidingByID(BuidingID); } if (BuidingID == 0 && DemandID == 0) { buidling = new WebBuiding(); } if (buidling == null) { buidling = new WebBuiding(); } return(View(buidling)); }
public ActionResult DecBuidingDetail(int WorkerID = 0, int BuidingID = 0) { WebBuiding buiding = webbuidingSer.GetWebBuidingByID(BuidingID); WebWorker worker = webworkerService.GetWebWorkerByID(WorkerID); ViewBag.buiding = buiding; return(View(worker)); }
public ActionResult mobileStageDetail(int BuidingID, int StageID) { WebBuiding buiding = buidSer.GetWebBuidingByID(BuidingID); WebBuidingStages stage = stageSer.GetBuidingStageByBuidingIDAndStageID(BuidingID, StageID); ViewBag.stage = stage; return(View(buiding)); }
public ActionResult mTogetherBuidingDetail(int BuidingID = 0, int StageID = 0, int togetherid = 0) { WebBuiding buiding = buidSer.GetWebBuidingByID(BuidingID); WebBuidingStages stage = stageSer.GetBuidingStageByBuidingIDAndStageID(BuidingID, StageID); DecDemand demand = deSer.GetDecDemandByGuID(buiding.Guid); ViewBag.stage = stage; ViewBag.demand = demand; return(View(buiding)); }
public int AddWebBuidingCaseComment(WebBuidingCaseComment comment) { using (AIYunNetContext context = new AIYunNetContext()) { context.WebBuidingCaseComment.Add(comment); WebBuiding buiding = context.WebBuiding.FirstOrDefault(c => c.Guid == comment.Guid); buiding.IsComment = 1; context.SaveChanges(); return(1); } }
public ActionResult DecWorkerBuidingDetail(int WorkerID = 0, int BuidingID = 0) { WebWorker worker = webworkerService.GetWebWorkerByID(WorkerID); //WebBuidingSingle buidingSingle = WebBuidingSingleSer.GetWebBuidingSingleByID(BuidingSingleID); WebBuiding buiding = webbuidingSer.GetWebBuidingByID(BuidingID); DecDemand demand = DemandSer.GetDecDemandByID(buiding.DemandID); //工人在constructionstageID中只有单个id WebBuidingStages buidingstage = WebBuidingStagesSer.GetWebBuidingStagesByID(BuidingID, Convert.ToInt32(buiding.constructionstageID.Replace(",", ""))); ViewBag.buiding = buiding; ViewBag.buidingstage = buidingstage; ViewBag.demand = demand; ViewBag.worker = worker; return(View(worker)); }
/// <summary> /// 根据ID获取在建工地 /// </summary> /// <returns></returns> public WebBuiding GetWebBuidingByID(int BuidingID) { WebBuiding buiding = new WebBuiding(); using (AIYunNetContext context = new AIYunNetContext()) { try { buiding = context.WebBuiding.Find(BuidingID); } catch (Exception e) { } return(buiding); } }
public JsonResult AddOrEditBuidingStages(WebBuiding webBuiding) { WebBuidingService service = new WebBuidingService(); if (webBuiding.BuidingID > 0) { service.UpdateWebBuiding(webBuiding); } else { webBuiding.WorkerID = Convert.ToInt32(SessionHelper.Get("PositionID")); service.AddWebBuiding(webBuiding); } return(Json(new { RetCode = 1 })); }
/// <summary> /// 根据GuID获取在建工地 /// </summary> /// <returns></returns> public WebBuiding GetWebBuidingByGuID(string GuID) { WebBuiding buiding = new WebBuiding(); using (AIYunNetContext context = new AIYunNetContext()) { try { buiding = context.WebBuiding.FirstOrDefault(c => c.Guid == GuID); } catch (Exception e) { } return(buiding); } }
public int updateWebBuidingCaseComment(WebBuidingCaseComment comment) { WebBuidingCaseComment old = new WebBuidingCaseComment(); using (AIYunNetContext context = new AIYunNetContext()) { old = context.WebBuidingCaseComment.Find(comment.id); old.Score = comment.Score; old.Comment = comment.Comment; old.EditOn = DateTime.Now.ToString(); old.IsEdit = 1; WebBuiding buiding = context.WebBuiding.FirstOrDefault(c => c.Guid == comment.Guid); buiding.IsComment = 2; context.SaveChanges(); return(1); } }
public int DeleteWebBuiding(int buidingID) { using (AIYunNetContext context = new AIYunNetContext()) { WebBuiding old = context.WebBuiding.Find(buidingID); if (old != null) { old.FlagDelete = 1; old.DeleteOn = DateTime.Now; context.SaveChanges(); return(1); } else { return(0); } } }
public ActionResult BuidingDetailUser(int BuidingID = 0, string Guid = "") { WebBuiding buiding = new WebBuiding(); if (BuidingID != 0) { buiding = buidSer.GetWebBuidingByID(BuidingID); } if (Guid != "") { buiding = buidSer.GetWebBuidingByGuID(Guid); } List <WebBuidingStages> stageslist = stageSer.GetWebBuidingStagesListByBuiding(buiding.BuidingID); DecDemand demand = deSer.GetDecDemandByGuID(buiding.Guid); ViewBag.stageslist = stageslist; ViewBag.demand = demand; return(View(buiding)); }
public int IsOutByGuID(int GetUserID, string guid) { using (AIYunNetContext context = new AIYunNetContext()) { DecDemand model = new DecDemand(); if (guid != "") { model = context.DecDemand.FirstOrDefault(c => c.Guid == guid); } model.IsOut = true; WebBuiding buiding = context.WebBuiding.FirstOrDefault(c => c.Guid == guid); if (buiding != null) { context.WebBuiding.Remove(buiding); } context.SaveChanges(); return(1); } }
//装修工人确定是否完工 public int IsWorkerEnd(int buidingID) { using (AIYunNetContext context = new AIYunNetContext()) { WebBuiding old = context.WebBuiding.Find(buidingID); if (old != null) { old.IsWorkerEnd = 1; old.StageNow = old.StageNow + 1; old.EndTime = DateTime.Now.ToString("yyyy-MM-dd"); old.QualityTime = DateTime.Now.AddYears(2).ToString("yyyy-MM-dd"); context.SaveChanges(); return(1); } else { return(0); } } }
//业主确定是否完工(0没有确定,1确认完工,2延时) public int IsUserEnd(int buidingID, int IsUserend) { using (AIYunNetContext context = new AIYunNetContext()) { WebBuiding old = context.WebBuiding.Find(buidingID); if (old != null) { old.IsUserEnd = IsUserend; if (IsUserend == 2) { old.IsWorkerEnd = 0; } context.SaveChanges(); return(1); } else { return(0); } } }
//手机端修改装修阶段详情 public int mUpdateBuidingStagesInfo(WebBuidingStages buidingStage) { using (AIYunNetContext context = new AIYunNetContext()) { WebBuidingStages old = context.WebBuidingStages.Find(buidingStage.ID); WebBuiding buiding = context.WebBuiding.Find(buidingStage.WebBuidingID); if (old != null) { old.wordContent = buidingStage.wordContent; old.ImgContent = buidingStage.ImgContent; old.thumContent = buidingStage.thumContent; old.CompleteTime = DateTime.Now.ToString(); old.IsComplete = buidingStage.IsComplete; context.SaveChanges(); List <WebBuidingStages> list = new List <WebBuidingStages>(); try { list = context.WebBuidingStages.Where(c => c.WebBuidingID == buidingStage.WebBuidingID && c.IsComplete == true).OrderByDescending(c => c.sortID).ToList(); } catch (Exception e) { list = new List <WebBuidingStages>(); } if (list.Count > 0) { int stageNow = list[0].sortID; buiding.StageNow = stageNow; context.SaveChanges(); } return(1); } else { return(0); } } }
//案例详情 // GET: MobileApp/MoblieBuiding public ActionResult mBuidingDetail(int id) { WebBuiding buiding = buidSer.GetWebBuidingByID(id); DecDemand demand = DemandSer.GetDecDemandByID(buiding.DemandID); WebBuidingStages buidingstage = new WebBuidingStages(); //工人在constructionstageID中只有单个id if (buiding.constructionstageID != "" && buiding.constructionstageID != null) { buidingstage = WebBuidingStagesSer.GetWebBuidingStagesByID(id, Convert.ToInt32(buiding.constructionstageID.Replace(",", ""))); } if (buidingstage == null) { buidingstage = new WebBuidingStages(); } List <WebBuidingStages> stageslist = WebBuidingStagesSer.GetWebBuidingStagesListByBuiding(buiding.BuidingID); ViewBag.stageslist = stageslist; //ViewBag.buidingstage = buidingstage; ViewBag.demand = demand; return(View(buiding)); }
public int UpdateDecDemand(DecDemand DecDemand) { using (AIYunNetContext context = new AIYunNetContext()) { DecDemand old = context.DecDemand.Find(DecDemand.id); DecDemandAcceptService ser = new DecDemandAcceptService(); DecDemandAccept accold = ser.GetAcceptByGuid(DecDemand.Guid); WebBuidingService buidingSer = new WebBuidingService(); if (old != null) { if (DecDemand.GetUserID != 0) { if (accold != null) { DecDemandAccept oldacc = context.DecDemandAccept.FirstOrDefault(c => c.DemandGuid == accold.DemandGuid); oldacc.GetUserID = DecDemand.GetUserID; oldacc.PublicUserID = DecDemand.PublishuserID; oldacc.IsAccept = 0; } else { DecDemandAccept acc = new DecDemandAccept(); acc.DemandGuid = DecDemand.Guid; acc.GetUserID = DecDemand.GetUserID; acc.PublicUserID = DecDemand.PublishuserID; acc.IsAccept = 0; ser.AddDecDemandAccept(acc); } } old.IsAccept = 0; old.GetUserID = DecDemand.GetUserID; old.ownername = DecDemand.ownername; old.ownertel = DecDemand.ownertel; old.ProvinceID = DecDemand.ProvinceID; old.ProvinceName = DecDemand.ProvinceName; old.OneSentence = DecDemand.OneSentence; old.IsPublish = DecDemand.IsPublish; old.Info = DecDemand.Info; old.EditOn = DateTime.Now; old.DemandType = DecDemand.DemandType; old.DemandTypeName = DecDemand.DemandTypeName; old.CityID = DecDemand.CityID; old.CityName = DecDemand.CityName; old.buidingSpace = DecDemand.buidingSpace; old.buidingname = DecDemand.buidingname; old.HouseType = DecDemand.HouseType; old.IsPlan = false; old.IsOut = false; WebBuiding buiding = buidingSer.GetWebBuidingByGuID(DecDemand.Guid); if (buiding != null) { buidingSer.DeleteWebBuiding(buiding.BuidingID); } context.SaveChanges(); } return(1); } }
public int UpdateWebBuiding(WebBuiding webBuiding) { using (AIYunNetContext context = new AIYunNetContext()) { WebBuiding old = context.WebBuiding.Find(webBuiding.BuidingID); if (old != null) { old.BuidingTitle = webBuiding.BuidingTitle; old.BuidingID = webBuiding.BuidingID; old.BuidingTitle = webBuiding.BuidingTitle; old.BuidingBrief = webBuiding.BuidingBrief; old.BuidingInfo = webBuiding.BuidingInfo; old.Price = webBuiding.Price; old.Space = webBuiding.Space; if (old.constructionstageID != webBuiding.constructionstageID) { old.constructionstageID = webBuiding.constructionstageID; old.constructionstage = webBuiding.constructionstage; old.StageNow = 0; //删除 List <WebBuidingStages> liststage = context.WebBuidingStages.Where(c => c.WebBuidingID == webBuiding.BuidingID).ToList(); if (liststage != null) { foreach (WebBuidingStages item in liststage) { context.WebBuidingStages.Remove(item); } } //添加 if (webBuiding.constructionstageID != null) { WebBuiding org = GetWebBuidingByDemandID(webBuiding.DemandID); List <string> listid = webBuiding.constructionstageID.Split(',').Where(c => c != "").ToList(); List <string> listStage = webBuiding.constructionstage.Split(',').Where(c => c != "").ToList(); int i = 0; foreach (string id in listid) { WebBuidingStages stage = new WebBuidingStages { WebBuidingID = org.BuidingID, StageID = Convert.ToInt32(id), StageName = listStage[i], sortID = i }; context.WebBuidingStages.Add(stage); i++; } context.SaveChanges(); } } old.StartTime = webBuiding.StartTime; old.ShowOrder = webBuiding.ShowOrder; old.IsHot = webBuiding.IsHot; old.IsTop = webBuiding.IsTop; old.thumbnailImage = webBuiding.thumbnailImage; old.BuidingImage = webBuiding.BuidingImage; context.SaveChanges(); return(1); } else { return(0); } } }