using System; using System.Linq; using ADM.ProgressMonitor.DataObjects; using System.Collections.Generic; using System.Web.UI; using ADM.ProgressMonitor.WebControl; using System.Web.SessionState; using ADM.ProgressMonitor.BusinessRules; using System.Data.Objects; namespace ADM.ProgressMonitor.DataAccess { /// <summary> /// 基于Session为Cache的Oracle DAO类。 /// 如果Cache中已有相关数据，直接从Cache中读取。 /// </summary> public class SessionCachedOracleDAO { /// <summary> /// 关联的页面 /// </summary> private Page _page; /// <summary> /// 关联的用户控件 /// </summary> private UserControl _userControl; /// <summary> /// 构造函数 /// </summary> /// <param name="page">关联页面</param> public SessionCachedOracleDAO(Page page) { _page = page; } /// <summary> /// 构造函数 /// </summary> /// <param name="userControl">关联控件</param> public SessionCachedOracleDAO(UserControl userControl) { _userControl = userControl; } /// <summary> /// 获取关联的Session /// </summary> HttpSessionState Session { get { if (_page != null) { return _page.Session; } if (_userControl != null) { return _userControl.Session; } throw new Exception("No available session."); } } /// <summary> /// 获取M1分册开工时间 /// </summary> /// <param name="aeroId">型号Id</param> /// <returns>M1分册开工时间。如没找到，返回NULL</returns> public DateTime? GetM1StartDate(string aeroId) { List<SRC_DEF_STAGE> stages = GetStages(aeroId); foreach (SRC_DEF_STAGE stage in stages) { if (Parser.ParseStageCode(stage.TECHNICS_NAME) == "M1") { SRC_DEF_PROCEDURE proce = GetProceduresFromStage(stage.STAGE_ID).FirstOrDefault(item => item.SORT_ID == 1); if (proce != null && proce.WORKING_BEGIN_TIME.HasValue) { return proce.WORKING_BEGIN_TIME.Value.Date; } } } return null; } public DateTime GetAeroEndDate(string aeroId) { List<SRC_DEF_STAGE> stages = GetStages(aeroId); return stages.Where(item => item.WORKING_END_TIME.HasValue && item.WORKING_END_TIME.Value.Year != 9999).Max (item => item.WORKING_END_TIME.Value); } public DateTime GetAeroBeginDate(string aeroId) { List<SRC_DEF_STAGE> stages = GetStages(aeroId); return stages.Where(item => item.WORKING_BEGIN_TIME.HasValue && item.WORKING_BEGIN_TIME.Value.Year != 9999).Min (item => item.WORKING_BEGIN_TIME.Value); } /// <summary> /// 返回DB中所有型号 /// </summary> /// <returns>DB中所有型号</returns> public List<SRC_DEF_AEROCRAFT> GetAllAeros() { string sessionKey = "AERO"; if (Session[sessionKey] == null) { Session[sessionKey] = context.SRC_DEF_AEROCRAFT.ToList(); } return (List<SRC_DEF_AEROCRAFT>)Session[sessionKey]; } /// <summary> /// 返回相关型号的日统计数据。 /// </summary> /// <param name="aeroId">型号ID</param> /// <returns>相关型号的日统计数据</returns> public List<SRC_DEF_AERO_DAILY_STATISTICS> GetSRC_DEF_AERO_DAILY_STATISTICS(string aeroId) { string sessionKey = "AERO_DAILY_STATISTICS_" + aeroId; if (Session[sessionKey] == null) { Session[sessionKey] = context.SRC_DEF_AERO_DAILY_STATISTICS.Where(item => item.AEROCRAFT_ID == aeroId).ToList(); } return (List<SRC_DEF_AERO_DAILY_STATISTICS>)Session[sessionKey]; } /// <summary> /// 返回相关型号们的日统计数据。 /// </summary> /// <param name="aeroIds">型号ID列表</param> /// <returns>相关型号集的日统计数据</returns> public List<SRC_DEF_AERO_DAILY_STATISTICS> GetSRC_DEF_AERO_DAILY_STATISTICS(List<string> aeroIds) { List<SRC_DEF_AERO_DAILY_STATISTICS> ret = new List<SRC_DEF_AERO_DAILY_STATISTICS>(); foreach (string aeroId in aeroIds) { ret.AddRange(GetSRC_DEF_AERO_DAILY_STATISTICS(aeroId)); } return ret; } public void ClearTemplate(int baselineId) { string sessionKey = "TEMPLATE_" + baselineId; Session[sessionKey] = null; } /// <summary> /// 返回相关平台的阶段模版 /// </summary> /// <param name="baselineId">平台ID</param> /// <returns>该平台的阶段模版</returns> public List<SRC_DEF_BASE_PHASE_TEMPLATE> GetTemplate(int baselineId) { string sessionKey = "TEMPLATE_" + baselineId; if (Session[sessionKey] == null) { string PLATFORM_NAME = context.SRC_DEF_PLATFORM.First(item => item.PLATFORM_ID == baselineId).PLATFORM_NAME; Session[sessionKey] = context.SRC_DEF_BASE_PHASE_TEMPLATE.Where(item => item.PLATFORM_NAME == PLATFORM_NAME).OrderBy(item1 => item1.SORT_ID).ToList(); } return (List<SRC_DEF_BASE_PHASE_TEMPLATE>)Session[sessionKey]; } /// <summary> /// 获取相关型号的分册 /// </summary> /// <param name="aeroId">型号ID</param> /// <returns>该型号的分册</returns> public List<SRC_DEF_STAGE> GetStages(string aeroId) { string sessionKey = "STAGE_BY_AERO_" + aeroId; if (Session[sessionKey] == null) { Session[sessionKey] = context.SRC_DEF_STAGE.Where( item => item.AEROCRAFT_ID == aeroId && item.WORKING_BEGIN_TIME.HasValue && item.WORKING_END_TIME.HasValue && item.WORKING_BEGIN_TIME.Value.Year != 9999 && item.WORKING_END_TIME.Value.Year != 9999).OrderBy(item => item.STAGE_ID).ToList(); } return (List<SRC_DEF_STAGE>)Session[sessionKey]; } /// <summary> /// 获取型号列表中所有型号的所属分册 /// </summary> /// <param name="aeroIds">型号ID列表</param> /// <returns>型号列表中所有型号的所属分册</returns> public List<SRC_DEF_STAGE> GetStages(List<string> aeroIds) { List<SRC_DEF_STAGE> ret = new List<SRC_DEF_STAGE>(); foreach (string aeroId in aeroIds) { ret.AddRange(GetStages(aeroId)); } return ret; } /// <summary> /// 获取分册列表中所有分册的所属工序 /// </summary> /// <param name="stageIds">分册ID列表</param> /// <returns>分册列表中所有分册的所属工序</returns> public List<SRC_DEF_PROCEDURE> GetProcedures(List<string> stageIds) { List<SRC_DEF_PROCEDURE> ret = new List<SRC_DEF_PROCEDURE>(); foreach (string stageId in stageIds) { ret.AddRange(GetProceduresFromStage(stageId)); } return ret; } /// <summary> /// 获取型号列表中所有型号的所属工序 /// </summary> /// <param name="aeroIds">型号ID列表</param> /// <returns>型号列表中所有型号的所属工序</returns> public List<SRC_DEF_PROCEDURE> GetProceduresFromAero(List<string> aeroIds) { List<SRC_DEF_PROCEDURE> ret = new List<SRC_DEF_PROCEDURE>(); foreach (string aeroId in aeroIds) { ret.AddRange(GetProceduresFromAero(aeroId)); } return ret; } /// <summary> /// 获取型号所属工序 /// </summary> /// <param name="aeroId"></param> /// <returns></returns> public List<SRC_DEF_PROCEDURE> GetProceduresFromAero(string aeroId) { string sessionKey = "PROCEDURE_BY_AERO_" + aeroId; if (Session[sessionKey] == null) { List<SRC_DEF_STAGE> stages = GetStages(aeroId); List<SRC_DEF_PROCEDURE> ret = new List<SRC_DEF_PROCEDURE>(); foreach (SRC_DEF_STAGE stage in stages) { ret.AddRange(GetProceduresFromStage(stage.STAGE_ID)); } Session[sessionKey] = ret; } return (List<SRC_DEF_PROCEDURE>)Session[sessionKey]; } /// <summary> /// 获取分册下工序 /// </summary> /// <param name="stageId"></param> /// <returns></returns> public List<SRC_DEF_PROCEDURE> GetProceduresFromStage(string stageId) { string sessionKey = "PROCEDURE_BY_STAGE_" + stageId; if (Session[sessionKey] == null) { Session[sessionKey] = context.SRC_DEF_PROCEDURE.Where(item => item.WORKING_BEGIN_TIME.HasValue && item.WORKING_END_TIME.HasValue && item.STAGE_ID == stageId).ToList(); } return (List<SRC_DEF_PROCEDURE>)Session[sessionKey]; } /// <summary> /// 数据库Oracle Context /// </summary> Entities context = new Entities(); /// <summary> /// 删除基线 /// </summary> /// <param name="baselineId">基线Id</param> /// <param name="dataSet">数据集</param> public void DeleteBaseline(int baselineId, AeroDataSet dataSet) { foreach (SRC_DEF_TEMP_WORK_DEVIATION item in context.SRC_DEF_TEMP_WORK_DEVIATION.Where(item => item.BASELINE_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_TEMP_WORK_DEVIATION2 item in context.SRC_DEF_TEMP_WORK_DEVIATION2.Where(item => item.BASELINE_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_QUESTION_LIST_DEV item in context.SRC_DEF_QUESTION_LIST_DEV.Where(item => item.BASELINE_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_PROGRESS_DEVIATION item in context.SRC_DEF_PROGRESS_DEVIATION.Where(item => item.BASELINE_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_PROGRESS_DEVIATION2 item in context.SRC_DEF_PROGRESS_DEVIATION2.Where(item => item.BASELINE_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_PROCEDURE_DEVIATION item in context.SRC_DEF_PROCEDURE_DEVIATION.Where(item => item.BASELINE_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_PROCEDURE_DEVIATION2 item in context.SRC_DEF_PROCEDURE_DEVIATION2.Where(item => item.BASELINE_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_PHASE_PARAMETER item in context.SRC_DEF_PHASE_PARAMETER.Where(item => item.PLATFORM_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_BASELINE_PHASE_STAT item in context.SRC_DEF_BASELINE_PHASE_STAT.Where(item => item.PLATFORM_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_BASELINE_AEROCRAFT item in context.SRC_DEF_BASELINE_AEROCRAFT.Where(item => item.PLATFORM_ID == baselineId)) { context.DeleteObject(item); } foreach (SRC_DEF_BASELINE item in context.SRC_DEF_BASELINE.Where(item => item.PLATFORM_ID == baselineId)) { context.DeleteObject(item); } //foreach ( // SRC_DEF_BASE_PHASE_TEMPLATE item in // context.SRC_DEF_BASE_PHASE_TEMPLATE.Where(item => item.PLATFORM_ID == baselineId)) //{ // context.DeleteObject(item); //} foreach (AeroDataSet.AeroPhaseRow carPhaseRow in dataSet.AeroPhase) { foreach (SRC_DEF_BASE_AEROCRAFT_PHASE srcDefBaseAerocraftPhase in context.SRC_DEF_BASE_AEROCRAFT_PHASE.Where(item => item.AEROCRAFT_ID == carPhaseRow.AeroId)) { context.DeleteObject(srcDefBaseAerocraftPhase); } } context.SaveChanges(); } public void AutoFillAeroStatus() { context.Connection.Open(); using (System.Data.Common.DbTransaction transaction = context.Connection.BeginTransaction()) { foreach (SRC_DEF_AEROCRAFT aerocraft in context.SRC_DEF_AEROCRAFT) { SRC_DEF_AEROCRAFT_STATUS status = context.SRC_DEF_AEROCRAFT_STATUS.FirstOrDefault( item => item.AEROCRAFT_ID == aerocraft.AEROCRAFT_ID); if (status == null) { ObjectParameter objectParameter = new ObjectParameter("isOVER",typeof(string)); context.AERO_STATUS_JUDGE(aerocraft.AEROCRAFT_ID, objectParameter); status = new SRC_DEF_AEROCRAFT_STATUS(); status.AEROCRAFT_ID = aerocraft.AEROCRAFT_ID; status.TYPE = "自动"; //status.STATUS = aerocraft.WORKING_END_TIME.HasValue ? "已完成" : "在研"; status.STATUS = objectParameter.Value == "true" ? "已完成" : "在研"; context.AddToSRC_DEF_AEROCRAFT_STATUS(status); } } context.SaveChanges(); transaction.Commit(); } } /// <summary> /// 填充型号状态表中缺失的数据。 /// </summary> public void FillAeroStatus() { context.Connection.Open(); using (System.Data.Common.DbTransaction transaction = context.Connection.BeginTransaction()) { foreach (SRC_DEF_AEROCRAFT aerocraft in context.SRC_DEF_AEROCRAFT) { SRC_DEF_AEROCRAFT_STATUS status = context.SRC_DEF_AEROCRAFT_STATUS.FirstOrDefault( item => item.AEROCRAFT_ID == aerocraft.AEROCRAFT_ID); if (status == null) { status = new SRC_DEF_AEROCRAFT_STATUS(); status.AEROCRAFT_ID = aerocraft.AEROCRAFT_ID; status.TYPE = "手动"; status.STATUS = aerocraft.WORKING_END_TIME.HasValue ? "已完成" : "在研"; context.AddToSRC_DEF_AEROCRAFT_STATUS(status); } } context.SaveChanges(); transaction.Commit(); } } /// <summary> /// 获取平台下型号ID集合 /// </summary> /// <param name="platformId"></param> /// <returns></returns> public List<string> GetAeroIds(int platformId) { return context.SRC_DEF_PLATFORM_AEROCRAFT.Where(item => item.PLATFORM_ID == platformId).Select(item1 => item1.AEROCRAFT_ID).ToList(); } /// <summary> /// 依据工序名称、分册号、型号号、工序号查找对应工序。 /// </summary> /// <param name="procedureName"></param> /// <param name="stageCode"></param> /// <param name="procedureCode"></param> /// <param name="platformId"></param> /// <param name="aeroId"></param> /// <returns></returns> public AeroStageProcedureSearchResult Search(string procedureName, string stageCode, string procedureCode, int platformId, string aeroId) { if (GetProceduresFromAero(GetAeroIds(platformId)).Count(item => item.TECHNICS_NAME == procedureName) != 0) { SRC_DEF_PROCEDURE startProcedure = GetProceduresFromAero(GetAeroIds(platformId)).First(item => item.TECHNICS_NAME == procedureName); AeroStageProcedureSearchResult ret = new AeroStageProcedureSearchResult(); ret.ProcedureId = startProcedure.PROCEDURE_ID; ret.StageId = startProcedure.STAGE_ID; ret.AeroId = context.SRC_DEF_STAGE.First(item => item.STAGE_ID == ret.StageId).AEROCRAFT_ID; return ret; } else { List<SRC_DEF_STAGE> stages = GetStages(GetAeroIds(platformId)); SRC_DEF_STAGE matchedStage = stages.FirstOrDefault( item => item.TECHNICS_NAME.Contains("(" + stageCode + ")") || item.TECHNICS_NAME.Contains("（" + stageCode + "）")); if (matchedStage != null) { List<SRC_DEF_PROCEDURE> procedures = GetProceduresFromStage(matchedStage.STAGE_ID); SRC_DEF_PROCEDURE matchedProcedure = procedures.FirstOrDefault(item => item.SORT_ID.ToString() == procedureCode); if (matchedProcedure != null) { AeroStageProcedureSearchResult ret = new AeroStageProcedureSearchResult(); ret.ProcedureId = matchedProcedure.PROCEDURE_ID; ret.StageId = matchedProcedure.STAGE_ID; ret.AeroId = matchedStage.AEROCRAFT_ID; return ret; } } } return null; } } }