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();
}
}
