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 static void AddUser(string prjGuid, System.Collections.Generic.List <string> userCodes)
{
System.Guid guid = new System.Guid(prjGuid);
using (pm2Entities context = new pm2Entities())
{
PTPrjInfoZTBUserService prjUserSer = new PTPrjInfoZTBUserService();
prjUserSer.Delete(prjGuid);
if (userCodes != null)
{
foreach (string code in userCodes)
{
PT_yhmc yh = (
from m in context.PT_yhmc
where m.v_yhdm == code
select m).FirstOrDefault <PT_yhmc>();
if (yh != null)
{
PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User
{
Id = System.Guid.NewGuid().ToString(),
PrjGuid = guid,
UserCode = code
};
context.AddToPT_PrjInfo_ZTB_User(user);
}
}
}
context.SaveChanges();
}
}
public void Add(Progress entity)
{
if (entity != null)
{
using (pm2Entities entities = new pm2Entities())
{
PT_yhmc _yhmc = (from m in entities.PT_yhmc
where m.v_yhdm == entity.InputUser
select m).FirstOrDefault <PT_yhmc>();
plus_progress _progress = new plus_progress {
ProgressId = entity.ProgressId,
PrjId = new Guid?(entity.PrjId),
ProgressName = entity.ProgressName,
IsMain = entity.IsMain,
FlowState = new int?(entity.FlowState),
Note = entity.Note,
InputDate = new DateTime?(entity.InputDate),
PT_yhmc = _yhmc
};
entities.AddToplus_progress(_progress);
if (entity.IsMain)
{
List <plus_progress> list = (from m in entities.plus_progress
where (m.PrjId == entity.PrjId) && m.IsMain
select m).ToList <plus_progress>();
if (list.Count > 0)
{
foreach (plus_progress _progress2 in list)
{
_progress2.IsMain = false;
}
}
}
string str = Guid.NewGuid().ToString();
plus_progress_version _version = new plus_progress_version {
ProgressVersionId = str,
ParentVersionId = null,
VersionCode = entity.VersionCode,
VersionName = entity.ProgressName,
FlowState = null,
InputDate = new DateTime?(entity.InputDate),
IsLatest = false,
Note = entity.Note,
plus_progress = _progress
};
entities.AddToplus_progress_version(_version);
List <string> userCodes = new List <string> {
entity.InputUser
};
if (entity.InputUser != "00000000")
{
userCodes.Add("00000000");
}
Privilege.AddPrivilege(userCodes, _progress, entities);
entities.SaveChanges();
}
}
}
public User GetChargeMan(int departmentId)
{
using (pm2Entities entities = new pm2Entities())
{
PT_yhmc _yhmc = (from u in entities.PT_yhmc
where (u.i_bmdm == departmentId) && u.IsChargeMan
select u).FirstOrDefault <PT_yhmc>();
return(this.ConvertToUser(_yhmc));
}
}
public User GetByCode(string userCode)
{
using (pm2Entities entities = new pm2Entities())
{
PT_yhmc _yhmc = (from u in entities.PT_yhmc
where u.v_yhdm == userCode
select u).FirstOrDefault <PT_yhmc>();
return(this.ConvertToUser(_yhmc));
}
}
private User ConvertToUser(PT_yhmc pt_user)
{
User user = null;
if (pt_user != null)
{
user = new User {
UserCode = pt_user.v_yhdm,
UserName = pt_user.v_xm,
DepartmentId = pt_user.i_bmdm.Value
};
}
return(user);
}
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();
}
}
