public static void UpdateLatest(string progressVersionId) { using (pm2Entities entities = new pm2Entities()) { if (!string.IsNullOrEmpty(progressVersionId)) { plus_progress progress = (from m in entities.plus_progress_version where m.ProgressVersionId == progressVersionId select m.plus_progress).FirstOrDefault <plus_progress>(); List <plus_progress_version> list = (from m in entities.plus_progress_version where ((m.plus_progress.ProgressId == progress.ProgressId) && (m.IsLatest == true)) || (m.ProgressVersionId == progressVersionId) select m).ToList <plus_progress_version>(); plus_progress_version _version = (from m in entities.plus_progress_version where m.ProgressVersionId == progressVersionId select m).FirstOrDefault <plus_progress_version>(); if ((list != null) && (_version != null)) { foreach (plus_progress_version _version2 in list) { _version2.IsLatest = false; } _version.IsLatest = true; } AddWarn(progressVersionId, entities); entities.SaveChanges(); } } }
public void Add(cn.justwin.BLL.ProgressManagement.Version entity) { if (entity != null) { using (pm2Entities entities = new pm2Entities()) { plus_progress_version _version = new plus_progress_version { ProgressVersionId = entity.ProgressVersionId, ParentVersionId = entity.ParentVersionId, VersionCode = entity.VersionCode, VersionName = entity.VersionName, FlowState = new int?(entity.FlowState), InputDate = new DateTime?(entity.InputDate), IsLatest = new bool?(entity.IsLatest), Note = entity.Note, PT_yhmc = (from m in entities.PT_yhmc where m.v_yhdm == entity.InputUser select m).FirstOrDefault <PT_yhmc>(), plus_progress = (from m in entities.plus_progress where m.ProgressId == entity.ProgressId select m).FirstOrDefault <plus_progress>() }; entities.AddToplus_progress_version(_version); entities.SaveChanges(); } } }
public static void UpdateLatest(string progressId) { using (pm2Entities entities = new pm2Entities()) { plus_progress_version _version = (from m in entities.plus_progress join n in entities.plus_progress_version on m.ProgressId equals n.plus_progress.ProgressId into n where (m.ProgressId == progressId) && (n.FlowState == null) select n).FirstOrDefault <plus_progress_version>(); plus_progress progress = (from m in entities.plus_progress where m.ProgressId == progressId select m).FirstOrDefault <plus_progress>(); if ((progress != null) && progress.IsMain) { plus_progress _progress = (from m in entities.plus_progress where ((m.IsMain && (m.PrjId == progress.PrjId)) && (m.FlowState == 1)) && (m.ProgressId != progressId) select m).FirstOrDefault <plus_progress>(); if (_progress != null) { _progress.IsMain = false; } } if (_version != null) { _version.IsLatest = true; cn.justwin.BLL.ProgressManagement.Version.AddWarn(_version.ProgressVersionId, entities); entities.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(); } } }
private static void DelApply(string verId, pm2Entities context) { plus_progress_version entity = (from m in context.plus_progress_version where m.ProgressVersionId == verId select m).FirstOrDefault <plus_progress_version>(); if (entity != null) { context.DeleteObject(entity); } }
protected internal static void AddWarn(string progressVerId, pm2Entities context) { List <string> list = (from m in context.plus_progress_version join n in context.plus_progress on m.plus_progress.ProgressId equals n.ProgressId into n join l in context.plus_progress_privilege on n.ProgressId equals l.plus_progress.ProgressId into l where m.ProgressVersionId == progressVerId select l.PT_yhmc.v_yhdm).ToList <string>(); if (list != null) { plus_progress_version _version = (from m in context.plus_progress_version where m.ProgressVersionId == progressVerId select m).FirstOrDefault <plus_progress_version>(); string str = (from m in context.PT_PrjInfo join n in context.plus_progress on m.PrjGuid equals n.PrjId into n join l in context.plus_progress_version on n.ProgressId equals l.plus_progress.ProgressId into l where l.ProgressVersionId == progressVerId select m.PrjName).FirstOrDefault <string>(); string str2 = string.Empty; string str3 = string.Empty; if (_version.FlowState.HasValue) { str2 = "调整"; } else { str3 = "&modify=false"; } string str4 = "项目[" + str + "]的进度计划[" + str2 + _version.VersionName + " " + _version.VersionCode + "]已发布"; string str5 = "项目[" + str + "]的进度计划[" + str2 + _version.VersionName + " " + _version.VersionCode + "]已通过" + str2 + "审核,此版本为进度计划的执行版本"; foreach (string str6 in list) { PT_Warning warning = new PT_Warning { WarningTitle = str4, WarningContent = str5, UserCode = str6, URI = "/ProgressManagement/Modify/ApplyView.aspx?ic=" + progressVerId + str3, IsValid = true, InputDate = new DateTime?(DateTime.Now), RelationsTable = "plus_progress_version", RelationsColumn = "ProgressVersionId", RelationsKey = progressVerId }; context.AddToPT_Warning(warning); } } }