//工长加入装修案例
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);
}
}
}
