public static void AddCompleted(string prjguid) { Guid guid = new Guid(prjguid); using (pm2Entities entities = new pm2Entities()) { int num = (from m in entities.PT_Prj_Completed_Detail where m.PrjGuid == guid select m).Count <PT_Prj_Completed_Detail>(); List <string> list = (from n in entities.PT_Prj_Completed select n.ID).ToList <string>(); if (num == 0) { for (int i = 0; i < list.Count; i++) { PrjCompleted model = new PrjCompleted { ID = Guid.NewGuid().ToString(), PrjGuid = guid, PrjCompletedId = list[i], InputDate = DateTime.Now }; model.Add(model); } } } }
public void Add(PrjCompleted model) { using (pm2Entities entities = new pm2Entities()) { if (model != null) { PT_Prj_Completed_Detail detail = new PT_Prj_Completed_Detail { ID = model.ID, PrjGuid = new Guid?(model.PrjGuid), PrepareStatus = model.PrepareStatus, UncompletedTrans = model.UncompletedTrans, Rectification = model.Rectification, InputDate = model.InputDate }; PT_Prj_Completed completed = (from pc in entities.PT_Prj_Completed where pc.ID == model.PrjCompletedId select pc).FirstOrDefault <PT_Prj_Completed>(); detail.PT_Prj_Completed = completed; PT_yhmc _yhmc = (from m in entities.PT_yhmc where m.userCode == model.InputUser select m).FirstOrDefault <PT_yhmc>(); detail.PT_yhmc = _yhmc; entities.AddToPT_Prj_Completed_Detail(detail); entities.SaveChanges(); } } }
public void Update(PrjCompleted model) { using (pm2Entities entities = new pm2Entities()) { PT_Prj_Completed_Detail detail = (from m in entities.PT_Prj_Completed_Detail where (m.PrjGuid == model.PrjGuid) && (m.PT_Prj_Completed.ID == model.PrjCompletedId) select m).FirstOrDefault <PT_Prj_Completed_Detail>(); detail.InputDate = model.InputDate; detail.PrepareStatus = model.PrepareStatus; detail.Rectification = model.Rectification; detail.UncompletedTrans = model.UncompletedTrans; PT_yhmc _yhmc = (from n in entities.PT_yhmc where n.v_yhdm == model.InputUser select n).FirstOrDefault <PT_yhmc>(); detail.PT_yhmc = _yhmc; entities.SaveChanges(); } }