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);
}
}
