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();
}
}
}
private void AddSingle(PT_Prj_Completed_Detail detail, string annexAddress, pm2Entities context)
{
PT_Prj_Completed_Annex annex = new PT_Prj_Completed_Annex {
ID = Guid.NewGuid().ToString(),
PT_Prj_Completed_Detail = detail,
AnnexAddress = annexAddress
};
context.AddToPT_Prj_Completed_Annex(annex);
}
public static void UpdateAnnexAddress(string prjId, string completeId, string directoryId)
{
using (pm2Entities entities = new pm2Entities())
{
Guid guid = new Guid(prjId);
PT_Prj_Completed_Detail detail = (from m in entities.PT_Prj_Completed_Detail
where (m.PrjGuid == guid) && (m.PT_Prj_Completed.ID == completeId)
select m).FirstOrDefault <PT_Prj_Completed_Detail>();
if (detail != null)
{
detail.AnnexAddress = directoryId;
entities.SaveChanges();
}
}
}
private void Update(string prjId, string prjCompletedId, List <string> annexAddress)
{
if (annexAddress != null)
{
using (pm2Entities entities = new pm2Entities())
{
string detailId = new CompletedAnnex().GetDetailId(prjId, prjCompletedId);
if (detailId != "")
{
List <string> list = this.GetAnnex(detailId);
using (List <string> .Enumerator enumerator = list.GetEnumerator())
{
string address;
while (enumerator.MoveNext())
{
address = enumerator.Current;
if (!annexAddress.Contains(address))
{
PT_Prj_Completed_Annex entity = (from m in entities.PT_Prj_Completed_Annex
where (m.PT_Prj_Completed_Detail.ID == detailId) && (m.AnnexAddress == address)
select m).FirstOrDefault <PT_Prj_Completed_Annex>();
if (entity != null)
{
entities.DeleteObject(entity);
}
}
}
}
PT_Prj_Completed_Detail detail = (from m in entities.PT_Prj_Completed_Detail
where m.ID == detailId
select m).FirstOrDefault <PT_Prj_Completed_Detail>();
if (detail != null)
{
CompletedAnnex annex2 = new CompletedAnnex();
foreach (string str in annexAddress)
{
if (!list.Contains(str))
{
annex2.AddSingle(detail, str, entities);
}
}
}
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();
}
}
private void Add(string prjId, string prjCompletedId, List <string> annexAddress)
{
if (annexAddress != null)
{
using (pm2Entities entities = new pm2Entities())
{
Guid prjGuid = new Guid(prjId);
PT_Prj_Completed_Detail detail = (from m in entities.PT_Prj_Completed_Detail
where (m.PrjGuid == prjGuid) && (m.PT_Prj_Completed.ID == prjCompletedId)
select m).FirstOrDefault <PT_Prj_Completed_Detail>();
if (detail != null)
{
CompletedAnnex annex = new CompletedAnnex();
foreach (string str in annexAddress)
{
annex.AddSingle(detail, str, entities);
}
entities.SaveChanges();
}
}
}
}
