public bool EditOperation(Guid operationID, OperationConfiguration item) { try { using (WanTaiEntities entities = new WanTaiEntities()) { OperationConfiguration record = entities.OperationConfigurations.Where(p => p.OperationID == operationID).FirstOrDefault(); record.OperationName = item.OperationName; record.OperationType = item.OperationType; record.OperationSequence = item.OperationSequence; record.SubOperationIDs = item.SubOperationIDs; record.DisplayFlag = item.DisplayFlag; record.ScriptFileName = item.ScriptFileName; record.RunTime = item.RunTime; entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->EditConfiguration", SessionInfo.ExperimentID); return(false); } }
public void UpdataRotationOperateStatus(RotationOperate _RotationOperate, RotationInfoStatus State) { using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { RotationOperate NewRotationOperate = _WanTaiEntities.RotationOperates.Where(rotationOperate => (rotationOperate.OperationID == _RotationOperate.OperationID && rotationOperate.RotationID == _RotationOperate.RotationID)).FirstOrDefault(); if (NewRotationOperate == null) { NewRotationOperate = new RotationOperate(); NewRotationOperate.RotationOperateID = WanTaiObjectService.NewSequentialGuid(); NewRotationOperate.StartTime = _RotationOperate.StartTime; NewRotationOperate.ExperimentID = _RotationOperate.ExperimentID; NewRotationOperate.OperationConfigurationReference.Value = _WanTaiEntities.OperationConfigurations.Where(Operation => Operation.OperationID == _RotationOperate.OperationID).FirstOrDefault(); NewRotationOperate.RotationID = _RotationOperate.RotationID; NewRotationOperate.State = (short)State; _WanTaiEntities.AddToRotationOperates(NewRotationOperate); } else { NewRotationOperate.State = (short)State; NewRotationOperate.EndTime = _RotationOperate.EndTime; NewRotationOperate.ErrorLog = _RotationOperate.ErrorLog; } _WanTaiEntities.SaveChanges(); } }
public bool EditByTypeId(List <SystemFluidConfiguration> recordList, short typeId) { try { using (WanTaiEntities entities = new WanTaiEntities()) { var records = entities.SystemFluidConfigurations.Where(p => p.ItemType == typeId); foreach (SystemFluidConfiguration record in records) { entities.DeleteObject(record); } foreach (SystemFluidConfiguration record in recordList) { record.ItemID = WanTaiObjectService.NewSequentialGuid(); entities.AddToSystemFluidConfigurations(record); } entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "." + MethodBase.GetCurrentMethod(), SessionInfo.ExperimentID); return(false); } }
public void AddConsumption(DataTable dt, short volumeType) { try { using (WanTaiEntities entities = new WanTaiEntities()) { for (int i = 0; i < dt.Rows.Count; i++) { if (((double)dt.Rows[i]["AddVolume"]) > 0) { ReagentsAndSuppliesConsumption consumption = new ReagentsAndSuppliesConsumption(); consumption.ItemID = WanTaiObjectService.NewSequentialGuid(); consumption.Volume = (double)dt.Rows[i]["AddVolume"]; consumption.UpdateTime = DateTime.Now; consumption.ReagentAndSupplieID = Guid.Parse(dt.Rows[i]["ReagentAndSuppolieID"].ToString()); consumption.ExperimentID = SessionInfo.ExperimentID; consumption.RotationID = SessionInfo.PraperRotation.RotationID; consumption.VolumeType = volumeType; entities.ReagentsAndSuppliesConsumptions.AddObject(consumption); } } entities.SaveChanges(); } } catch (Exception ex) { string errorMessage = ex.Message + System.Environment.NewLine + ex.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); } }
public bool EditConfiguration(Guid itemId, ReagentAndSuppliesConfiguration item) { try { using (WanTaiEntities entities = new WanTaiEntities()) { ReagentAndSuppliesConfiguration record = entities.ReagentAndSuppliesConfigurations.Where(p => p.ItemID == itemId).FirstOrDefault(); record.EnglishName = item.EnglishName; record.DisplayName = item.DisplayName; record.Position = item.Position; record.Grid = item.Grid; record.Unit = item.Unit; record.ItemType = item.ItemType; record.CalculationFormula = item.CalculationFormula; record.ContainerName = item.ContainerName; record.BarcodePrefix = item.BarcodePrefix; record.Color = item.Color; entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->EditConfiguration", SessionInfo.ExperimentID); return(false); } }
/// <summary> /// 状态(0 Create ,10 processing 运行,20完成 finish、30失败 falled ) /// </summary> public void AddToRotationOperate(RotationOperate _RotationOperate) { using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { _WanTaiEntities.AddToRotationOperates(_RotationOperate); _WanTaiEntities.SaveChanges(); } }
public void AddReagentAndSupplies(ReagentAndSupply reagentAndSupply) { using (WanTaiEntities entities = new WanTaiEntities()) { entities.ReagentAndSupplies.AddObject(reagentAndSupply); entities.SaveChanges(); } }
public void Add(UserInfo userInfo, out string message) { message = string.Empty; using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { _WanTaiEntities.UserInfoes.AddObject(userInfo); _WanTaiEntities.SaveChanges(); message = AddSuccess; } }
public static void DeleteLogInfo(Guid experimentID) { LogInfo logInfo; using (WanTaiEntities wanTaiEntities = new WanTaiEntities()) { logInfo = wanTaiEntities.LogInfoes.First(P => P.LogID == experimentID); wanTaiEntities.LogInfoes.DeleteObject(logInfo); wanTaiEntities.SaveChanges(); } }
public void UpdateBarcode(string plateName, short plateType, Guid rotationID, string barCode) { using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { var plate = _WanTaiEntities.Plates.FirstOrDefault(P => (P.RotationID == rotationID && P.PlateType == plateType && P.PlateName == plateName)); if (plate != null) { plate.BarCode = barCode; _WanTaiEntities.SaveChanges(); } } }
public void UpdateTubesBatch(Guid rotationID, Guid tuibesBatchID) { using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { RotationInfo rotation = _WanTaiEntities.RotationInfoes.FirstOrDefault(P => P.RotationID == rotationID); if (rotation != null) { rotation.TubesBatchID = tuibesBatchID; } _WanTaiEntities.SaveChanges(); } }
public void UpdataRotationStatus(Guid RotationID, RotationInfoStatus State) { using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { RotationInfo Rotation = _WanTaiEntities.RotationInfoes.Where(_Rotation => _Rotation.RotationID == RotationID).FirstOrDefault(); if (Rotation != null) { Rotation.State = (short)State; } _WanTaiEntities.SaveChanges(); } }
public void UpdateRotationId(Guid tubesBatchID, Guid rotationID) { using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { var plates = _WanTaiEntities.Plates.Where(P => P.TubesBatchID == tubesBatchID); foreach (Plate plate in plates) { plate.RotationID = rotationID; } _WanTaiEntities.SaveChanges(); } }
public void UpdateConsumption(ReagentsAndSuppliesConsumption consumption) { using (WanTaiEntities entities = new WanTaiEntities()) { ReagentsAndSuppliesConsumption Result = entities.ReagentsAndSuppliesConsumptions.Where(Reagent => Reagent.VolumeType == 1 && Reagent.RotationID == consumption.RotationID && Reagent.ReagentAndSupplieID == consumption.ReagentAndSupplieID).FirstOrDefault(); if (Result == null) { entities.ReagentsAndSuppliesConsumptions.AddObject(consumption); } else { Result.Volume = consumption.Volume; Result.UpdateTime = DateTime.Now; } entities.SaveChanges(); } }
public void UpdataExperimentStatus(Guid ExperimentID, bool isFinal, ExperimentStatus State) { using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { ExperimentsInfo experiment = _WanTaiEntities.ExperimentsInfoes.Where(c => c.ExperimentID == ExperimentID).FirstOrDefault(); if (experiment != null) { experiment.State = (short)State; if (isFinal) { experiment.EndTime = DateTime.Now; } } _WanTaiEntities.SaveChanges(); } }
public void Update(UserInfo userInfo, out string message) { message = string.Empty; using (WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { UserInfo formerUser = _WanTaiEntities.UserInfoes.FirstOrDefault(P => P.UserID == userInfo.UserID); if (formerUser != null) { formerUser.LoginName = userInfo.LoginName; formerUser.LoginPassWord = userInfo.LoginPassWord; formerUser.RoleName = userInfo.RoleName; formerUser.CreateName = userInfo.CreateName; formerUser.UpdateTime = userInfo.UpdateTime; _WanTaiEntities.SaveChanges(); message = UpdateSuccess; } } }
public bool Create(SystemFluidConfiguration record) { try { using (WanTaiEntities entities = new WanTaiEntities()) { entities.AddToSystemFluidConfigurations(record); entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "." + MethodBase.GetCurrentMethod(), SessionInfo.ExperimentID); return(false); } }
public bool CreateExperiment(ExperimentsInfo experimentInfo) { try { using (WanTaiEntities entities = new WanTaiEntities()) { entities.AddToExperimentsInfoes(experimentInfo); entities.SaveChanges(); return(true); } } catch (Exception ex) { string errorMessage = ex.Message + System.Environment.NewLine + ex.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); return(false); } }
public bool Create(ReagentAndSuppliesConfiguration configuration) { try { using (WanTaiEntities entities = new WanTaiEntities()) { entities.AddToReagentAndSuppliesConfigurations(configuration); entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->Create", SessionInfo.ExperimentID); return(false); } }
/// <summary> /// /// </summary> /// <param name="logLevel">0 debug,1 info,2 warning,3 error,10 operate</param> /// <param name="logContent"></param> /// <param name="loginName"></param> /// <param name="module"></param> /// <param name="experimentID"></param> public static void AddLogInfo(LogInfoLevelEnum logLevel, string logContent, string loginName, string module, Guid?experimentID) { LogInfo logInfo = new LogInfo() { LogID = WanTaiObjectService.NewSequentialGuid(), LogContent = logContent, LogLevel = (short)logLevel, LoginName = loginName, CreaterTime = DateTime.Now, ExperimentID = experimentID, Module = module }; using (WanTaiEntities wanTaiEntities = new WanTaiEntities()) { wanTaiEntities.AddToLogInfoes(logInfo); wanTaiEntities.SaveChanges(); } }
public bool UpdateActiveStatus(Guid itemId, bool status) { try { using (WanTaiEntities entities = new WanTaiEntities()) { ReagentAndSuppliesConfiguration record = entities.ReagentAndSuppliesConfigurations.Where(p => p.ItemID == itemId).FirstOrDefault(); record.ActiveStatus = status; entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->UpdateActiveStatus", SessionInfo.ExperimentID); return(false); } }
public bool Delete(Guid TestingItemID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { var record = entities.TestingItemConfigurations.Where(c => c.TestingItemID == TestingItemID).FirstOrDefault(); entities.DeleteObject(record); entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->Delete", SessionInfo.ExperimentID); return(false); } }
public bool Create(List <RotationInfo> rotationInfoList) { try { using (WanTaiEntities entities = new WanTaiEntities()) { var oldRotations = entities.RotationInfoes.Where(c => c.ExperimentID == SessionInfo.ExperimentID); if (oldRotations.Count() > 0) { foreach (RotationInfo old in oldRotations) { entities.DeleteObject(old); } } foreach (RotationInfo rotationInfo in rotationInfoList) { entities.AddToRotationInfoes(rotationInfo); if (rotationInfo.TubesBatchID != null) { var plates = entities.Plates.Where(P => P.TubesBatchID == rotationInfo.TubesBatchID); foreach (Plate plate in plates) { plate.RotationID = rotationInfo.RotationID; } } } entities.SaveChanges(); } return(true); } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "Create()", SessionInfo.ExperimentID); return(false); } }
public static void InstertKingFisherLog(Guid experimentID, DateTime dtStart, DateTime dtEnd, out string ErrMsg) { ErrMsg = "success"; using (SqlConnection con = new SqlConnection(WanTai.Common.Configuration.GetKingFisherConnectionString())) { try { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "select * from tbl_log where creation_time between @dtStart and @dtEnd ";// + dtStart.ToUniversalTime().ToString() + "' and '" + dtEnd.ToString() + "'"; DateTime _dtStart = dtStart.ToUniversalTime(); DateTime _dtEnd = dtEnd.ToUniversalTime(); cmd.Parameters.AddWithValue("@dtStart", _dtStart); cmd.Parameters.AddWithValue("@dtEnd", _dtEnd); con.Open(); SqlDataReader dReader = cmd.ExecuteReader(); using (WanTaiEntities wanTaiEntities = new WanTaiEntities()) { while (dReader.Read()) { LogInfo logInfo = new LogInfo() { LogID = WanTaiObjectService.NewSequentialGuid(), LogContent = dReader["object_name"].ToString() + " " + dReader["message"].ToString(), LogLevel = (int)LogInfoLevelEnum.KingFisher, LoginName = SessionInfo.LoginName, CreaterTime = DateTime.Parse(dReader["creation_time"].ToString()).ToLocalTime(), ExperimentID = experimentID, Module = "KingFisherLog" }; wanTaiEntities.AddToLogInfoes(logInfo); } wanTaiEntities.SaveChanges(); } }catch (Exception ex) { ErrMsg = "连接KingFisher数据库失败!"; WanTai.Common.CommonFunction.WriteLog(ex.ToString()); } } }
public bool EditPoolingRules(Guid PoolingRulesID, PoolingRulesConfiguration item) { try { using (WanTaiEntities entities = new WanTaiEntities()) { PoolingRulesConfiguration record = entities.PoolingRulesConfigurations.Where(p => p.PoolingRulesID == PoolingRulesID).FirstOrDefault(); record.PoolingRulesName = item.PoolingRulesName; record.TubeNumber = item.TubeNumber; entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->EditPoolingRules", SessionInfo.ExperimentID); return(false); } }
public bool Create(List <PCRTestResult> recordList) { try { using (WanTaiEntities entities = new WanTaiEntities()) { foreach (PCRTestResult record in recordList) { entities.AddToPCRTestResults(record); } entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->Create", SessionInfo.ExperimentID); return(false); } }
public bool UpdateExperimentState(Guid ExperimentID, int State) { try { using (WanTaiEntities entities = new WanTaiEntities()) { ExperimentsInfo tempExperimentsInfo = entities.ExperimentsInfoes.FirstOrDefault(p => p.ExperimentID == ExperimentID); if (tempExperimentsInfo != null) { tempExperimentsInfo.State = (short)State; entities.SaveChanges(); } } return(true); } catch (Exception ex) { string errorMessage = ex.Message + System.Environment.NewLine + ex.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); return(false); } }
public bool EditTestingItems(Guid TestingItemID, TestingItemConfiguration item) { try { using (WanTaiEntities entities = new WanTaiEntities()) { TestingItemConfiguration record = entities.TestingItemConfigurations.Where(p => p.TestingItemID == TestingItemID).FirstOrDefault(); record.TestingItemName = item.TestingItemName; record.TestingItemColor = item.TestingItemColor; record.DisplaySequence = item.DisplaySequence; record.WorkListFileName = item.WorkListFileName; entities.SaveChanges(); return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->EditTestingItems", SessionInfo.ExperimentID); return(false); } }
public void AddConsumption(Guid rotationID, Guid reagentAndSupplieID, double volume, short volumeType) { try { using (WanTaiEntities entities = new WanTaiEntities()) { ReagentsAndSuppliesConsumption consumption = new ReagentsAndSuppliesConsumption(); consumption.ItemID = WanTaiObjectService.NewSequentialGuid(); consumption.Volume = volume; consumption.UpdateTime = DateTime.Now; consumption.ReagentAndSupplieID = reagentAndSupplieID; consumption.ExperimentID = SessionInfo.ExperimentID; consumption.RotationID = rotationID; consumption.VolumeType = volumeType; entities.ReagentsAndSuppliesConsumptions.AddObject(consumption); entities.SaveChanges(); } } catch (Exception ex) { string errorMessage = ex.Message + System.Environment.NewLine + ex.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); } }
public bool UpdatePCRTestResult(Guid itemId, string resultContent) { try { using (WanTaiEntities entities = new WanTaiEntities()) { var result = entities.PCRTestResults.Where(c => c.ItemID == itemId); if (result != null && result.Count() > 0) { PCRTestResult testResult = result.FirstOrDefault(); testResult.Result = resultContent; entities.SaveChanges(); } return(true); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->UpdatePCRTestResult", SessionInfo.ExperimentID); return(false); } }