public List <ReagentAndSuppliesConfiguration> GetPCRHeatLiquidPlate()
{
using (WanTaiEntities entities = new WanTaiEntities())
{
return(entities.ReagentAndSuppliesConfigurations.Where(ReagentAndSupplies => ReagentAndSupplies.ItemType == 205).ToList());
}
}
public static string GetRotationLog(Guid RotationID)
{
using (WanTaiEntities wanTaiEntities = new WanTaiEntities())
{
var RotationOperates = wanTaiEntities.RotationOperates.Where(Rotation => Rotation.RotationID == RotationID);
DateTime dtStart = DateTime.MaxValue;
DateTime dtEnd = DateTime.MinValue;
Guid experimentID = new Guid();
foreach (RotationOperate _RotationOperate in RotationOperates)
{
experimentID = _RotationOperate.ExperimentID;
if (_RotationOperate.StartTime != null)
{
dtStart = (dtStart > _RotationOperate.StartTime ?(DateTime)_RotationOperate.StartTime : dtStart);
}
if (_RotationOperate.EndTime != null)
{
dtEnd = (dtEnd < _RotationOperate.EndTime ? (DateTime)_RotationOperate.EndTime : dtEnd);
}
}
var Logs = wanTaiEntities.LogInfoes.Where(log => log.ExperimentID == experimentID && log.CreaterTime >= dtStart && log.CreaterTime <= dtEnd && (log.LogLevel == (short)LogInfoLevelEnum.EVORunTime || log.LogLevel == (short)LogInfoLevelEnum.KingFisher));
StringBuilder LogConnt = new StringBuilder();
foreach (LogInfo log in Logs)
{
LogConnt.Append(log.CreaterTime.ToString() + ":" + ((LogInfoLevelEnum)log.LogLevel).ToString() + log.Module + " " + log.LogContent + "\r\n");
}
return(LogConnt.ToString());
}
}
public Guid GetSameSequenceSubOperation(Guid operationID)
{
Guid subOperationID = Guid.Empty;
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
OperationConfiguration operation = _WanTaiEntities.OperationConfigurations.FirstOrDefault(P => P.OperationID == operationID);
if (operation != null || !string.IsNullOrEmpty(operation.SubOperationIDs.Trim()))
{
string[] subIDs = operation.SubOperationIDs.Split(new char[] { ',' });
List <Guid> listSubIDs = new List <Guid>();
for (int i = 0; i < subIDs.Count(); i++)
{
listSubIDs.Add(new Guid(subIDs[i]));
}
List <OperationConfiguration> subOperations = new List <OperationConfiguration>();
subOperations = _WanTaiEntities.OperationConfigurations.Where(P => listSubIDs.Contains(P.OperationID)).ToList();
foreach (OperationConfiguration subOperate in subOperations)
{
if (subOperate.OperationSequence == operation.OperationSequence)
{
subOperationID = subOperate.OperationID;
break;
}
}
}
}
return(subOperationID);
}
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 PoolingRulesConfiguration GetPoolingRulesConfiguration()
{
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
return(_WanTaiEntities.PoolingRulesConfigurations.FirstOrDefault <PoolingRulesConfiguration>());
}
}
/// <summary>
/// ReagentAndSuppliesConfiguration of one rotation
/// </summary>
/// <param name="operationsOrders"></param>
/// <returns></returns>
public List <ReagentAndSuppliesConfiguration> GetReagentAndSuppliesNeeded(Dictionary <short, bool> operationsOrders, FormulaParameters formulaParameters)
{
List <ReagentAndSuppliesConfiguration> list = new List <ReagentAndSuppliesConfiguration>();
try
{
using (WanTaiEntities wanTaiEntites = new WanTaiEntities())
{
list = wanTaiEntites.ReagentAndSuppliesConfigurations.Where(c => c.ActiveStatus == true).ToList();
}
foreach (ReagentAndSuppliesConfiguration r in list)
{
double volumne = CalcVolume(r.CalculationFormula, operationsOrders, formulaParameters);
r.NeedVolume = r.ItemType >= 100 ? Math.Ceiling(volumne) : volumne;
if (r.ItemType == DiTiType.DiTi200 || r.ItemType == DiTiType.DiTi1000)
{
r.ActualSavedVolume = volumne;
r.NeedVolume = Math.Ceiling(volumne / 96 * 10) / 10;
}
}
}
catch (Exception ex)
{
string errorMessage = ex.Message + System.Environment.NewLine + ex.StackTrace;
LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID);
throw;
}
return(list);
}
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 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);
}
}
/// <summary>
/// NeededVolume of processing rotations
/// </summary>
/// <returns></returns>
public List <ReagentsAndSuppliesConsumption> GetProcessingRotationsVolume()
{
List <ReagentsAndSuppliesConsumption> listNeededVolume = new List <ReagentsAndSuppliesConsumption>();
using (WanTaiEntities entities = new WanTaiEntities())
{
Dictionary <Guid, RotationInfo> processingRotation = new RotationController().GetRotations(RotationInfoStatus.Processing);
var query =
entities.ReagentsAndSuppliesConsumptions.Where(P =>
(P.RotationID != null && processingRotation.Keys.Contains((Guid)P.RotationID) &&
P.VolumeType == 0))
.GroupBy(P => P.ReagentAndSupplieID);
foreach (IGrouping <Guid?, ReagentsAndSuppliesConsumption> consumption in query)
{
listNeededVolume.Add(new ReagentsAndSuppliesConsumption
{
Volume = consumption.Sum(C => C.Volume),
ExperimentID = SessionInfo.ExperimentID,
ReagentAndSupplieID = consumption.Key
});
}
}
return(listNeededVolume);
}
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);
}
}
//public ObservableCollection<TestingItemConfiguration> GetPoolingRulesConfigurations()
//{
// using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
// {
// ObservableCollection<TestingItemConfiguration> Result =new ObservableCollection<TestingItemConfiguration>();
// foreach (TestingItemConfiguration _TextingItem in _WanTaiEntities.TestingItemConfigurations)
// {
// Result.Add(_TextingItem);
// }
// return Result;
// }
//}
//get all active TestItemConfigurations
public IList <TestingItemConfiguration> GetActiveTestItemConfigurations()
{
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
return(_WanTaiEntities.TestingItemConfigurations.Where(c => c.ActiveStatus == true).OrderBy(c => c.DisplaySequence).ToList <TestingItemConfiguration>());
}
}
//get all TestItemConfigurations
public IList <TestingItemConfiguration> GetTestItemConfigurations()
{
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
return(_WanTaiEntities.TestingItemConfigurations.OrderBy(c => c.DisplaySequence).ToList <TestingItemConfiguration>());
}
}
public List <RotationInfo> GetExperimentRotation(Guid ExperimentID)
{
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
return(_WanTaiEntities.RotationInfoes.Where(Rotation => Rotation.ExperimentID == ExperimentID).OrderBy(c => c.RotationSequence).ToList());
}
}
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 UserInfo GetUserByName(string userName)
{
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
UserInfo userInfo = _WanTaiEntities.UserInfoes.FirstOrDefault(P => P.LoginName == userName);
return(userInfo);
}
}
public void AddReagentAndSupplies(ReagentAndSupply reagentAndSupply)
{
using (WanTaiEntities entities = new WanTaiEntities())
{
entities.ReagentAndSupplies.AddObject(reagentAndSupply);
entities.SaveChanges();
}
}
public ExperimentsInfo GetExperimentById(Guid experimentId)
{
using (WanTaiEntities entities = new WanTaiEntities())
{
ExperimentsInfo experimentInfo = entities.ExperimentsInfoes.FirstOrDefault(p => p.ExperimentID == experimentId);
return experimentInfo;
}
}
public Dictionary <Guid, RotationInfo> GetRotations(RotationInfoStatus state)
{
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
return(_WanTaiEntities.RotationInfoes.Where(
P => (P.ExperimentID == SessionInfo.ExperimentID && P.State == (short)state)).ToDictionary(P => P.RotationID));
}
}
/// <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 List <UserInfo> GetSubUser(string userName)
{
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
List <UserInfo> users = _WanTaiEntities.UserInfoes.Where(P => P.CreateName == userName).ToList();
return(users);
}
}
public List <RoleInfo> GetAll()
{
using (WanTaiEntities _WanTaiEntities = new WanTaiEntities())
{
UserInfo user = _WanTaiEntities.UserInfoes.FirstOrDefault(P => P.LoginName == SessionInfo.LoginName);
RoleInfo role = _WanTaiEntities.RoleInfoes.FirstOrDefault(P => P.RoleName == user.RoleName);
return(_WanTaiEntities.RoleInfoes.Where(P => P.RoleLevel <= role.RoleLevel).OrderBy(P => P.RoleLevel).ToList());
}
}
public List <OperationConfiguration> GetAllOperations()
{
List <OperationConfiguration> list = new List <OperationConfiguration>();
using (WanTaiEntities entities = new WanTaiEntities())
{
list = entities.OperationConfigurations.ToList();
return(list);
}
}
public List <OperationConfiguration> GetAllSingleOperations()
{
List <OperationConfiguration> list = new List <OperationConfiguration>();
using (WanTaiEntities entities = new WanTaiEntities())
{
list = entities.OperationConfigurations.Where(P => P.OperationType == 0).OrderBy(Operation => Operation.OperationSequence).ToList();
return(list);
}
}
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 List <ReagentAndSupply> GetAllByType(int typeId)
{
List <ReagentAndSupply> list = new List <ReagentAndSupply>();
using (WanTaiEntities entities = new WanTaiEntities())
{
list = entities.ReagentAndSupplies.Where(P => P.ExperimentID == SessionInfo.ExperimentID && P.ItemType == typeId).ToList();
}
return(list);
}
public static LogInfo GetLogInfoByID(Guid experimentID)
{
LogInfo logInfo;
using (WanTaiEntities wanTaiEntities = new WanTaiEntities())
{
logInfo = wanTaiEntities.LogInfoes.First(P => P.LogID == experimentID);
}
return(logInfo);
}
public List <ReagentAndSupply> GetAll(Guid experimentID)
{
List <ReagentAndSupply> list = new List <ReagentAndSupply>();
using (WanTaiEntities entities = new WanTaiEntities())
{
list = entities.ReagentAndSupplies.Where(P => P.ExperimentID == experimentID).ToList();
}
return(list);
}
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 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 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();
}
}
}
