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 void GetRotationOperates(Guid rotationID, DataTable dataTable, System.Windows.Media.Color alternativeColor, System.Windows.Media.Color defaultColor) { try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); string commandText = "SELECT RotationOperate.*, OperationConfiguration.OperationName FROM RotationOperate left join OperationConfiguration" + " on RotationOperate.OperationID = OperationConfiguration.OperationID where RotationID=@RotationID"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.Parameters.AddWithValue("@RotationID", rotationID); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default)) { int index = 1; while (reader.Read()) { System.Data.DataRow dRow = dataTable.NewRow(); dRow["Number"] = index; if (index % 2 == 0) { dRow["Color"] = alternativeColor; } else { dRow["Color"] = defaultColor; } dRow["OperationID"] = reader["OperationID"]; dRow["OperationName"] = reader["OperationName"]; dRow["StartTime"] = reader["StartTime"].ToString(); if (reader["EndTime"] != DBNull.Value) { dRow["EndTime"] = reader["EndTime"].ToString(); } dRow["State"] = ConvertEnumStatusToText((RotationOperateStatus)((short)reader["State"])); dRow["ErrorLog"] = reader["ErrorLog"]; index++; dataTable.Rows.Add(dRow); } } } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetRotationOperates", SessionInfo.ExperimentID); throw; } }
public IList <PoolingRulesConfiguration> GetPoolingRulesConfigurations() { try { using (WanTaiEntities entities = new WanTaiEntities()) { var records = entities.PoolingRulesConfigurations.OrderBy(c => c.TubeNumber); return(records.ToList <PoolingRulesConfiguration>()); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetPoolingRulesConfigurations", SessionInfo.ExperimentID); throw; } }
public TubesBatch GetTubesBatchByID(Guid batchID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { TubesBatch record = entities.TubesBatches.Where(c => c.TubesBatchID == batchID).FirstOrDefault(); return(record); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "GetTubesBatchByID()", SessionInfo.ExperimentID); throw; } }
public List <OperationConfiguration> GetDisplayedOperationConfigurations() { try { using (WanTaiEntities entities = new WanTaiEntities()) { var records = entities.OperationConfigurations.Where(c => c.DisplayFlag == true && c.ActiveStatus == true).OrderBy(c => c.OperationSequence); return(records.ToList <OperationConfiguration>()); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "GetDisplayedOperationConfigurations()", SessionInfo.ExperimentID); throw; } }
public TestingItemConfiguration GetTestingItem(Guid TestingItemID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { TestingItemConfiguration record = entities.TestingItemConfigurations.Where(c => c.TestingItemID == TestingItemID).FirstOrDefault(); return(record); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetTestingItem", SessionInfo.ExperimentID); throw; } }
public bool Create(TestingItemConfiguration configuration) { try { using (WanTaiEntities entities = new WanTaiEntities()) { entities.AddToTestingItemConfigurations(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); } }
public bool CallScanScript() { string scanTubeScriptName = WanTai.Common.Configuration.GetTubesScanScriptName(); try { IProcessor processor = ProcessorFactory.GetProcessor(); processor.StartScript(scanTubeScriptName); } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "CallScanScript()", SessionInfo.ExperimentID); return(false); } return(true); }
public RotationInfo GetRotationInfo(Guid rotationID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { RotationInfo rotation = entities.RotationInfoes.FirstOrDefault(c => c.RotationID == rotationID); return(rotation); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "GetRotationInfo(Guid rotationID)", SessionInfo.ExperimentID); throw; } }
public List <RotationInfo> GetCurrentRotationInfos(Guid experimentID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { var rotations = entities.RotationInfoes.Where(c => c.ExperimentID == experimentID).OrderBy(c => c.RotationSequence); return(rotations.ToList <RotationInfo>()); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "GetCurrentRotationInfos()", SessionInfo.ExperimentID); throw; } }
public bool DeleteExperiment(Guid experimentID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { ExperimentsInfo experimentsInfo = entities.ExperimentsInfoes.FirstOrDefault(p => p.ExperimentID == experimentID); entities.ExperimentsInfoes.DeleteObject(experimentsInfo); 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 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 List <Carrier> GetCarrier() { List <Carrier> list = new List <Carrier>(); try { using (WanTaiEntities entities = new WanTaiEntities()) { list = entities.Carriers.ToList(); } } 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(list); }
//only can be used when typeId>=100 public List <ReagentAndSupply> GetAllByTypeAndRotationId(int typeId, Guid rotationId) { List <ReagentAndSupply> list = new List <ReagentAndSupply>(); try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); string commandText = "select distinct ReagentAndSupplies.* from ReagentAndSupplies inner join ReagentsAndSuppliesConsumption" + " on ReagentAndSupplies.ItemID =ReagentsAndSuppliesConsumption.ReagentAndSupplieID" + " where ItemType=@ItemType and ReagentsAndSuppliesConsumption.RotationID=@RotationID" + " and ReagentAndSupplies.ExperimentID=@ExperimentID"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.Parameters.AddWithValue("@ItemType", typeId); cmd.Parameters.AddWithValue("@RotationID", rotationId); cmd.Parameters.AddWithValue("@ExperimentID", SessionInfo.ExperimentID); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default)) { while (reader.Read()) { list.Add(new ReagentAndSupply() { ItemID = (Guid)reader["ItemID"], ItemType = (short)reader["ItemType"] }); } } } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetNextLogs", SessionInfo.ExperimentID); throw; } return(list); }
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 UpdateActiveStatus(Guid TestingItemID, bool status) { try { using (WanTaiEntities entities = new WanTaiEntities()) { TestingItemConfiguration record = entities.TestingItemConfigurations.Where(p => p.TestingItemID == TestingItemID).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 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 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 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 bool CanDelete(Guid TestingItemID) { try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); string commandText = "select count(*) from TestItem_TubeGroup where TestingItemID=@TestingItemID"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.Parameters.AddWithValue("@TestingItemID", TestingItemID); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default)) { if (reader.Read()) { int count = (int)reader.GetValue(0); if (count > 0) { return(false); } } } } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->CanDelete", SessionInfo.ExperimentID); throw; } return(true); }
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 void GetSingleSubOperations(Guid operationID, ref List <OperationConfiguration> operations) { using (WanTaiEntities entities = new WanTaiEntities()) { OperationConfiguration operation = entities.OperationConfigurations.FirstOrDefault(P => P.OperationID == operationID); if (operation != null) { if (operation.OperationType == 0) { operations.Add(operation); } else { string subOperationIDs = operation.SubOperationIDs; if (!string.IsNullOrEmpty(subOperationIDs)) { string[] IDs = subOperationIDs.Split(new char[] { ',' }); Guid guid; for (int i = 0; i < IDs.Length; i++) { try { guid = Guid.Parse(IDs[i]); GetSingleSubOperations(guid, ref operations); } catch (Exception ex) { LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, ex.Message, null, this.GetType().ToString() + "->" + "GetSingleSubOperations(Guid operationID, ref List<OperationConfiguration> operations)", null); continue; } } } } } } }
public bool CanDelete(Guid PoolingRulesID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { var records = entities.TubeGroups.Where(p => p.PoolingRulesID == PoolingRulesID).Count(); if (records == 0) { return(true); } else { return(false); } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->CanDelete", SessionInfo.ExperimentID); return(false); } }
public bool ExperimentNameExists(string experimentName) { try { using (WanTaiEntities entities = new WanTaiEntities()) { ExperimentsInfo experimentInfo = entities.ExperimentsInfoes.FirstOrDefault(p => p.ExperimentName == experimentName); if (experimentInfo != null) { return(true); } else { return(false); } } } 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 DataTable GetTubes(Guid BatchID, List <LiquidType> LiquidTypeList) { try { DataTable Tubes = new DataTable(); for (int i = 1; i < 37; i++) { DataColumn Column = new DataColumn("Position" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("Grid" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("BarCode" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("TubeType" + i.ToString()); Column.DefaultValue = Tubetype.IsNull; Tubes.Columns.Add(Column); Column = new DataColumn("TubePosBarCode" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("TextItemCount" + i.ToString()); Column.DefaultValue = "0,0,#C0C0C0"; //是否扫描到,采血管、阴阳补、选择颜色 Tubes.Columns.Add(Column); Column = new DataColumn("IconName" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("Visibility" + i.ToString()); Column.DefaultValue = "Hidden";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("IsEnabled" + i.ToString()); Column.DefaultValue = "True";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("IsSelected" + i.ToString()); Column.DefaultValue = "#316AC5";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("DetailView" + i.ToString()); Column.DefaultValue = "";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("DetailViewTime" + i.ToString()); Column.DefaultValue = DateTime.Now;//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("TestingItem" + i.ToString()); Column.DefaultValue = "";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("Background" + i.ToString()); Column.DefaultValue = null;//Collapsed Hidden Visible Tubes.Columns.Add(Column); } for (int i = 0; i < 16; i++) { DataRow dataRow = Tubes.NewRow(); Tubes.Rows.Add(dataRow); } //1(Position);1;1(Grid);Tube 13*100mm 16 Pos;Tube1;013/035678;11 using (WanTai.DataModel.WanTaiEntities wanTaiEntities = new WanTaiEntities()) { var TubesGroup = wanTaiEntities.TubeGroups.Where(Batch => Batch.TubesBatchID == BatchID); foreach (TubeGroup tubeGroup in TubesGroup) { var tubes = wanTaiEntities.Tubes.Where(tube => tube.TubeGroupID == tubeGroup.TubeGroupID); foreach (Tube tube in tubes) { int Position = tube.Grid; int Grid = tube.Position - 1; Tubes.Rows[Grid]["Position" + Position.ToString()] = Position; Tubes.Rows[Grid]["Grid" + Position.ToString()] = Grid + 1; Tubes.Rows[Grid]["BarCode" + Position.ToString()] = tube.BarCode; Tubes.Rows[Grid]["TubeType" + Position.ToString()] = Tubetype.Tube; Tubes.Rows[Grid]["TubePosBarCode" + Position.ToString()] = tube.TubePosBarCode; tubeGroup.TestingItemConfigurations.Load(); Tubes.Rows[Grid]["TextItemCount" + Position.ToString()] = "1,1,#C0C0C0"; Tubes.Rows[Grid]["DetailView" + Position.ToString()] += tubeGroup.TubesGroupName + " " + tubeGroup.PoolingRulesConfiguration.PoolingRulesName; foreach (TestingItemConfiguration TestingItem in tubeGroup.TestingItemConfigurations) { Tubes.Rows[Grid]["TextItemCount" + Position.ToString()] += ",;" + TestingItem.TestingItemColor; Tubes.Rows[Grid]["DetailView" + Position.ToString()] += " " + TestingItem.TestingItemName; } Tubes.Rows[Grid]["DetailView" + Position.ToString()] += ","; Tubes.Rows[Grid]["IconName" + Position.ToString()] = "1"; Tubes.Rows[Grid]["Visibility" + Position.ToString()] = "Visible"; Tubes.Rows[Grid]["IsEnabled" + Position.ToString()] = "True"; Tubes.Rows[Grid]["IsSelected" + Position.ToString()] = "#316AC5"; } } foreach (SystemFluidConfiguration _SystemFluidConfiguration in wanTaiEntities.SystemFluidConfigurations) { if (Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["TubeType" + _SystemFluidConfiguration.Grid.ToString()].ToString() == "-1") { continue; } Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["TubeType" + _SystemFluidConfiguration.Grid.ToString()] = (Tubetype)_SystemFluidConfiguration.ItemType; Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["Visibility" + _SystemFluidConfiguration.Grid.ToString()] = "Visible"; Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["IsEnabled" + _SystemFluidConfiguration.Grid.ToString()] = "True"; Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["IsSelected" + _SystemFluidConfiguration.Grid.ToString()] = "#316AC5"; LiquidType _LiquidType = LiquidTypeList.Find(delegate(LiquidType lt) { return(lt.TypeId == _SystemFluidConfiguration.ItemType); }); if (_LiquidType != null) { Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["TextItemCount" + _SystemFluidConfiguration.Grid.ToString()] = "1,2," + _LiquidType.Color; } } } Tubes.Namespace = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); return(Tubes); } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "GetTubes()", SessionInfo.ExperimentID); throw; } }
public DataTable GetTubes(List <LiquidType> LiquidTypeList, DateTime fileBeforeCreatedTime, out string ErrMsg, out string SystemFluid) { ErrMsg = "success"; SystemFluid = ""; try { DataTable Tubes = new DataTable(); for (int i = 1; i < 37; i++) { DataColumn Column = new DataColumn("Position" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("Grid" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("BarCode" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("TubeType" + i.ToString()); Column.DefaultValue = Tubetype.IsNull; Tubes.Columns.Add(Column); Column = new DataColumn("TubePosBarCode" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("TextItemCount" + i.ToString()); Column.DefaultValue = "0,0,#C0C0C0"; //是否扫描到,采血管、阴阳补、选择颜色 #FFC0CB Tubes.Columns.Add(Column); Column = new DataColumn("IconName" + i.ToString()); Tubes.Columns.Add(Column); Column = new DataColumn("Visibility" + i.ToString()); Column.DefaultValue = "Hidden";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("IsEnabled" + i.ToString()); Column.DefaultValue = "True";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("IsSelected" + i.ToString()); Column.DefaultValue = "#316AC5";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("DetailView" + i.ToString()); Column.DefaultValue = "";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("DetailViewTime" + i.ToString()); Column.DefaultValue = DateTime.Now;//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("TestingItem" + i.ToString()); Column.DefaultValue = "";//Collapsed Hidden Visible Tubes.Columns.Add(Column); Column = new DataColumn("Background" + i.ToString()); Column.DefaultValue = null;//Collapsed Hidden Visible Tubes.Columns.Add(Column); } for (int i = 0; i < 16; i++) { DataRow dataRow = Tubes.NewRow(); Tubes.Rows.Add(dataRow); } string scanFilePath = WanTai.Common.Configuration.GetEvoOutputPath() + WanTai.Common.Configuration.GetTubeScanResultFileName(); if (System.IO.File.Exists(scanFilePath)) { System.IO.FileInfo fileInfo = new System.IO.FileInfo(scanFilePath); DateTime fileModifiedTime = fileInfo.LastWriteTime; if (DateTime.Compare(fileBeforeCreatedTime, fileModifiedTime) > 0) { ErrMsg = "System can not find the scan file"; throw new Exception("System can not find the scan file"); } } else { ErrMsg = "System can not find the scan file"; throw new Exception("System can not find the scan file"); } using (System.IO.StreamReader mysr = new System.IO.StreamReader(scanFilePath)) { string strline; string[] aryline; strline = mysr.ReadLine(); //1(Position);1;1(Grid);Tube 13*100mm 16 Pos;Tube1;013/035678;11 while ((strline = mysr.ReadLine()) != null) { aryline = strline.Split(new char[] { ';' }); if (aryline[6] == "$$$" || aryline[6] == "") { continue; } int Position = int.Parse(aryline[0]); int Grid = int.Parse(aryline[2]) - 1; Tubes.Rows[Grid]["Position" + Position.ToString()] = Position; Tubes.Rows[Grid]["Grid" + Position.ToString()] = Grid + 1; Tubes.Rows[Grid]["BarCode" + Position.ToString()] = aryline[6]; Tubes.Rows[Grid]["TubeType" + Position.ToString()] = Tubetype.Tube; if (!string.IsNullOrEmpty(aryline[5])) { Tubes.Rows[Grid]["TubePosBarCode" + Position.ToString()] = aryline[5]; } Tubes.Rows[Grid]["TextItemCount" + Position.ToString()] = "1,1,#C0C0C0"; Tubes.Rows[Grid]["IconName" + Position.ToString()] = "1"; Tubes.Rows[Grid]["Visibility" + Position.ToString()] = "Visible"; Tubes.Rows[Grid]["IsEnabled" + Position.ToString()] = "True"; Tubes.Rows[Grid]["IsSelected" + Position.ToString()] = "#316AC5"; } } StringBuilder builder = new StringBuilder(); StringBuilder SystemFluidName = new StringBuilder(); using (WanTai.DataModel.WanTaiEntities _WanTaiEntities = new WanTaiEntities()) { foreach (SystemFluidConfiguration _SystemFluidConfiguration in _WanTaiEntities.SystemFluidConfigurations) { if (Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["TubeType" + _SystemFluidConfiguration.Grid.ToString()].ToString() == "-1") { continue; } if (Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["TubeType" + _SystemFluidConfiguration.Grid.ToString()].ToString() == "Tube") { builder.Append("[" + _SystemFluidConfiguration.Grid.ToString() + "," + _SystemFluidConfiguration.Position.ToString() + "]"); } Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["TubeType" + _SystemFluidConfiguration.Grid.ToString()] = (Tubetype)_SystemFluidConfiguration.ItemType; Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["Visibility" + _SystemFluidConfiguration.Grid.ToString()] = "Visible"; Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["IsEnabled" + _SystemFluidConfiguration.Grid.ToString()] = "True"; Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["IsSelected" + _SystemFluidConfiguration.Grid.ToString()] = "#316AC5"; // Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["BarCode" + _SystemFluidConfiguration.Grid.ToString()] = Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["BarCode" + _SystemFluidConfiguration.Grid.ToString()].ToString()+ "[不能分组]"; LiquidType _LiquidType = LiquidTypeList.Find(delegate(LiquidType lt) { return(lt.TypeId == _SystemFluidConfiguration.ItemType); }); if (_LiquidType != null) { Tubes.Rows[(int)(_SystemFluidConfiguration.Position - 1)]["TextItemCount" + _SystemFluidConfiguration.Grid.ToString()] = "1,2," + _LiquidType.Color; SystemFluidName.Append(_LiquidType.TypeName + ";"); } } Tubes.TableName = builder.ToString(); } string message = ""; foreach (LiquidType _liquidType in LiquidTypeList) { if (SystemFluidName.ToString().IndexOf(_liquidType.TypeName + ";") < 0) { message += _liquidType.TypeName + "、"; SystemFluid += _liquidType.TypeId + ","; } } if (message.Length > 0) { ErrMsg = "没有" + message.Substring(0, message.Length - 1) + "!"; } Tubes.Namespace = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); return(Tubes); } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "GetTubes()", SessionInfo.ExperimentID); throw; } }