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); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { UserInfo user = userInfoController.GetUserByName(SessionInfo.LoginName); string prePassword = txtPrePassword.Password.Trim(); string password = txtPassword.Password.Trim(); string passwordTwo = txtPasswordTwo.Password.Trim(); if (password == string.Empty) { MessageBox.Show("密码不能为空!", "系统提示"); return; } if (prePassword != user.LoginPassWord) { MessageBox.Show("旧密码输入错误。", "系统提示"); return; } if (password != passwordTwo) { MessageBox.Show("确认密码错误。", "系统提示"); return; } user.LoginPassWord = password; user.UpdateTime = DateTime.Now; string message; userInfoController.Update(user, out message); LogInfoController.AddLogInfo(LogInfoLevelEnum.Operate, "修改密码 " + message, SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); MessageBox.Show(message, "系统提示"); this.Close(); }
private void SendRespons(string m_OriginMsgGUID, EVOApiErrorMsg.ErrorResponseOption Response) { //response to an error, depends on button options for each EVOware error message EVOApiErrorMsg.ErrorResponseOption iResponse; //Indicate the error display will be handled by the client application or EVOware EVOApiErrorMsg.ErrorControlModes iMode; //response message object EVOApiErrorMsg.XmlMsgResponse xmlMsg; iResponse = Response; //Error Control Mode whether let’s EVOware handling display the error, in this sample EVOware does //not need to display the error window if (Response == ErrorResponseOption.NONE) { iMode = EVOApiErrorMsg.ErrorControlModes.EvowareControled; } else { iMode = EVOApiErrorMsg.ErrorControlModes.RemotelyControled; } //Instantiate new response message // the OriginMsgGUID is the MsgGUID of the message that we want to answer (required since // EVOApiErrorMessage V2.2.0.2, see example above) xmlMsg = new XmlMsgResponse(iMode, iResponse, m_OriginMsgGUID); //Sending response back to EVOware int MCSID = m_mcsErrorWrapper.SendingXmlMsg(m_clientID, xmlMsg, m_mcsReceiver, MSGChannels.MsgResponseChannel, 0); if (onSendErrorResponse != null) { onSendErrorResponse(); } LogInfoController.AddLogInfo(LogInfoLevelEnum.Debug, "Send Reponse to EVO", SessionInfo.LoginName, this.GetType().ToString() + "->" + "SendRespons()", SessionInfo.ExperimentID); }
public bool Delete(Guid experimentId) { try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); ///todo: add control,each role user only can see the specific experiments string commandText = "Delete_Experiment"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@experimentId", experimentId); cmd.ExecuteNonQuery(); } } 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; } }
/// <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 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 bool DeleteRotationPCRTestResult(Guid rotationId) { try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); string commandText = "DELETE FROM PCRTestResult WHERE RotationID=@RotationID"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.Parameters.AddWithValue("@RotationID", rotationId); cmd.ExecuteNonQuery(); return(true); } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->DeleteRotationPCRTestResult", SessionInfo.ExperimentID); return(false); } }
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); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { string userName = txtUserName.Text.Trim(); string password = txtPassword.Password.Trim(); if (userName == string.Empty) { MessageBox.Show("用户名不允许为空", "系统提示"); return; } if (password == string.Empty) { MessageBox.Show("密码不允许为空", "系统提示"); return; } if (System.Text.Encoding.Default.GetByteCount(userName) > 255) { MessageBox.Show("用户名最大长度为127个汉字。", "系统提示"); return; } string passwordTwo = txtPasswordTwo.Password.Trim(); if (System.Text.Encoding.Default.GetByteCount(password) > 255) { MessageBox.Show("密码最大长度为127个汉字。", "系统提示"); return; } if (password == passwordTwo) { if (userInfoController.GetUserByName(userName) != null) { MessageBox.Show("用户名[" + userName + "]已经存在。", "系统提示"); } else { UserInfo userInfo = new UserInfo() { UserID = WanTaiObjectService.NewSequentialGuid(), CreateName = SessionInfo.LoginName, LoginName = userName, LoginPassWord = password, CreateTime = DateTime.Now, RoleName = comboRole.SelectedValue.ToString() }; string message; userInfoController.Add(userInfo, out message); LogInfoController.AddLogInfo(LogInfoLevelEnum.Operate, "添加用户 成功", SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); MessageBox.Show(message, "系统提示"); this.Close(); } } else { MessageBox.Show("两次输入密码不一致!请重新输入。", "系统提示"); } }
private void SettingEVOApiTestInitialState() { m_clientCookie = m_mcsErrorWrapper.Connect(m_clientName, (MCSLib.IReceiveMsg) this); if (m_clientCookie == null) { LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, "m_clientCookie is null, can not connect to MCS", SessionInfo.LoginName, this.GetType().ToString() + "->" + "SettingEVOApiTestInitialState()", SessionInfo.ExperimentID); return; } m_clientID = m_clientCookie.PartnerID; m_mcsErrorWrapper.Subscribe(m_clientID, MSGChannels.MsgErrorsChannel); LogInfoController.AddLogInfo(LogInfoLevelEnum.Info, "Successful connect to MCS", SessionInfo.LoginName, this.GetType().ToString() + "->" + "SettingEVOApiTestInitialState()", SessionInfo.ExperimentID); }
private void ErrorEvent(DateTime StartTime, DateTime EndTime, string Device, string Macro, string Object, string Message, short Status, string ProcessName, int ProcessID, string MacroID) { string msgError; msgError = string.Format(WanTai.Common.Resources.WanTaiResource.EVOAPI_EVENTLOG, StartTime, EndTime, Device, Macro, Object, Message, Status, ProcessName, ProcessID, MacroID); LogInfoController.AddLogInfo(LogInfoLevelEnum.EVORunTime, "msg:" + msgError, SessionInfo.LoginName, this.GetType().ToString() + "->" + "ErrorEvent()", SessionInfo.ExperimentID); if (errorList != null) { errorList.Add(Message); } }
public int GetTotalCount(string experimentName, LogInfoLevelEnum logLevel) { int count = 0; try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); ///todo: add control,each role user only can see the specific experiments string commandText = "SELECT count(LogID) FROM LogInfo left join ExperimentsInfo on LogInfo.ExperimentID = ExperimentsInfo.ExperimentID"; commandText = commandText + " WHERE LogInfo.LogLevel = " + (int)logLevel; if (!string.IsNullOrEmpty(experimentName)) { commandText = commandText + " AND ExperimentsInfo.ExperimentName like '%" + experimentName + "%'"; } UserInfoController userInfoController = new UserInfoController(); RoleInfo userRole = userInfoController.GetRoleByUserName(SessionInfo.LoginName); if (userInfoController.GetAuthorize(AccessAuthority.LogInfo) == AccessAuthority.All) { commandText = commandText + @" AND (LogInfo.LoginName IS NULL or LogInfo.LoginName in (SELECT LoginName FROM UserInfo u left join roleinfo r on r.RoleName=u.RoleName WHERE r.RoleLevel<=" + userRole.RoleLevel + " ))"; } else { commandText = commandText + " AND LogInfo.LoginName='" + SessionInfo.LoginName + "'"; } using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default)) { if (reader.Read()) { count = (int)reader.GetValue(0); } } } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetTotalCount", SessionInfo.ExperimentID); throw; } return(count); }
public OperationConfiguration GetOperation(Guid operationID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { OperationConfiguration record = entities.OperationConfigurations.Where(c => c.OperationID == operationID).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() + "->GetOperation", SessionInfo.ExperimentID); throw; } }
public bool CheckRotationHasPCRTestResult(Guid rotationId, Guid experimentId) { try { using (WanTaiEntities entities = new WanTaiEntities()) { var records = entities.PCRTestResults.Where(c => c.RotationID == rotationId && c.ExperimentID == experimentId); return(records.Count() > 0 ? true : false); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->CheckRotationHasPCRTestResult", SessionInfo.ExperimentID); throw; } }
public List <OperationConfiguration> GetAllOperations() { try { using (WanTaiEntities entities = new WanTaiEntities()) { var records = entities.OperationConfigurations.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() + "->GetAllOperations", SessionInfo.ExperimentID); throw; } }
private void btnSave_Click(object sender, RoutedEventArgs e) { string experimentName = txtExperimentName.Text.Trim(); if (experimentName == string.Empty) { errInfo.Text = "实验名称不能为空。"; return; } else if (System.Text.Encoding.Default.GetByteCount(experimentName) > 255) { errInfo.Text = "实验名称允许最大长度为127个汉字"; return; } ExperimentController controller = new ExperimentController(); if (controller.ExperimentNameExists(experimentName)) { errInfo.Text = "实验名称\"" + txtExperimentName.Text + "\"已存在。"; return; } ExperimentsInfo experimentsInfo = new ExperimentsInfo(); experimentsInfo.ExperimentID = WanTaiObjectService.NewSequentialGuid(); experimentsInfo.ExperimentName = experimentName; experimentsInfo.LoginName = txtOrperatorName.Text; experimentsInfo.Remark = txtRemark.Text; experimentsInfo.StartTime = DateTime.Now; experimentsInfo.State = (short)ExperimentStatus.Create;; SessionInfo.CurrentExperimentsInfo = experimentsInfo; if (controller.CreateExperiment(experimentsInfo)) { SessionInfo.ExperimentID = experimentsInfo.ExperimentID; SessionInfo.RotationFormulaParameters = new Dictionary <Guid, FormulaParameters>(); SessionInfo.PraperRotation = null; LogInfoController.AddLogInfo(LogInfoLevelEnum.Operate, "新建实验 成功", SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); this.DialogResult = true; this.Close(); } else { errInfo.Text = "添加实验失败。"; } }
public string GetBarcodePrefix(short itemType) { string barcodePrefix = null; using (WanTaiEntities entities = new WanTaiEntities()) { ReagentAndSuppliesConfiguration reagentConfig = entities.ReagentAndSuppliesConfigurations.FirstOrDefault(P => P.ItemType == itemType); if (reagentConfig != null) { barcodePrefix = reagentConfig.BarcodePrefix; } else { LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, itemType.ToString() + "doesn't exist ein ReagentAndSuppliesConfiguration", "", this.GetType().Name, null); } } return(barcodePrefix); }
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); } }
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); } }
private void btnEdit_Click(object sender, RoutedEventArgs e) { string message; DataRowView rowView = (DataRowView)dgUsers.SelectedItem; UserInfo user = usersList.FirstOrDefault(P => P.UserID == (Guid)rowView["UserID"]); user.LoginPassWord = rowView["LoginPassWord"].ToString(); if (user.LoginPassWord == string.Empty) { MessageBox.Show("密码不允许为空!", "系统提示"); return; } user.RoleName = ((ComboBox)dgUsers.Columns[3].GetCellContent(rowView)).SelectedValue.ToString(); user.UpdateTime = DateTime.Now; userInfoController.Update(user, out message); LogInfoController.AddLogInfo(LogInfoLevelEnum.Operate, "修改用户 " + message, SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); MessageBox.Show(message, "系统提示"); }
public List <RotationInfo> GetFinishedRotation(Guid experimentId) { List <RotationInfo> recordList = new List <RotationInfo>(); try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); string commandText = "SELECT distinct RotationInfo.RotationID, RotationInfo.RotationName" + " FROM Plates LEFT JOIN RotationInfo on Plates.RotationID = RotationInfo.RotationID" + " WHERE Plates.PlateType=@PlateType and Plates.ExperimentID=@ExperimentID and RotationInfo.State=@RotationState"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.Parameters.AddWithValue("@PlateType", PlateType.PCR_Plate); cmd.Parameters.AddWithValue("@ExperimentID", experimentId); cmd.Parameters.AddWithValue("@RotationState", RotationInfoStatus.Finish); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default)) { while (reader.Read()) { RotationInfo info = new RotationInfo(); info.RotationID = (Guid)reader.GetValue(0); info.RotationName = reader.GetValue(1).ToString(); recordList.Add(info); } } } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetFinishedRotation", experimentId); throw; } return(recordList); }
public Dictionary <int, DataRow> GetPCRPositionsByPlateID(Guid PCRPlateID, Guid experimentId) { DataTable dataTable = new DataTable(); Dictionary <int, DataRow> result = new Dictionary <int, DataRow>(); try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); string commandText = "SELECT TubeNumber, TestName, TubeType, PCRPosition FROM View_Tubes_PCRPlatePosition" + " WHERE PCRPlateID=@PCRPlateID order by PCRPosition"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.Parameters.AddWithValue("@PCRPlateID", PCRPlateID); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default)) { dataTable.Load(reader); } } } foreach (DataRow row in dataTable.Rows) { if (!result.ContainsKey((int)row["PCRPosition"])) { result.Add((int)row["PCRPosition"], row); } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetPCRPositionsByPlateID", experimentId); throw; } return(result); }
public bool Delete(Guid operationID) { try { using (WanTaiEntities entities = new WanTaiEntities()) { var record = entities.OperationConfigurations.Where(c => c.OperationID == operationID).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 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 List <SystemFluidConfiguration> GetAllLiquidConfiguration() { List <SystemFluidConfiguration> recordList = null; try { using (WanTaiEntities entities = new WanTaiEntities()) { var records = entities.SystemFluidConfigurations; recordList = records.ToList <SystemFluidConfiguration>(); } } 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(recordList); }
private void save_Click(object sender, RoutedEventArgs e) { if (!validate()) { return; } TestingItemConfiguration config = new TestingItemConfiguration(); config.TestingItemName = name_textBox.Text; config.TestingItemColor = color_Control.Background.ToString(); config.DisplaySequence = short.Parse(displaySequence_textBox.Text); config.WorkListFileName = workListFileName_textBox.Text; bool result = false; if (string.IsNullOrEmpty(editTestItemId)) { config.TestingItemID = WanTaiObjectService.NewSequentialGuid(); config.ActiveStatus = true; result = controller.Create(config); LogInfoController.AddLogInfo(LogInfoLevelEnum.Operate, "新建检测项目:" + config.TestingItemName + " " + (result == true ? "成功" : "失败"), SessionInfo.LoginName, this.GetType().ToString(), null); } else { result = controller.EditTestingItems(new Guid(editTestItemId), config); LogInfoController.AddLogInfo(LogInfoLevelEnum.Operate, "修改检测项目:" + config.TestingItemName + " " + (result == true ? "成功" : "失败"), SessionInfo.LoginName, this.GetType().ToString(), null); } if (result) { MessageBox.Show("保存成功", "系统提示"); this.DialogResult = true; } else { MessageBox.Show("保存失败", "系统提示"); } this.Close(); }
public List <RotationInfo> GetPCRResultRotation() { List <RotationInfo> recordList = new List <RotationInfo>(); try { string connectionString = WanTai.Common.Configuration.GetConnectionString(); //string commandText = " select RotationID, RotationName from RotationInfo"+ // " where RotationID in ( select distinct RotationID FROM PCRTestResult WHERE ExperimentID = @ExperimentID)"; string commandText = " select RotationID, RotationName from RotationInfo" + " where ExperimentID = @ExperimentID"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.Parameters.AddWithValue("@ExperimentID", SessionInfo.ExperimentID); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default)) { while (reader.Read()) { RotationInfo info = new RotationInfo(); info.RotationID = (Guid)reader.GetValue(0); info.RotationName = reader.GetValue(1).ToString(); recordList.Add(info); } } } } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetPCRResultRotation", SessionInfo.ExperimentID); throw; } return(recordList); }
public bool IsPlateHasImportedResult(Guid rotationId, Guid plateId, Guid experimentId) { bool result = false; try { using (WanTaiEntities entities = new WanTaiEntities()) { int count = entities.PCRTestResults.Where(p => p.RotationID == rotationId && p.PlateID == plateId).Count(); result = count > 0 ? true : false; } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->IsPlateHasImportedResult", experimentId); throw; } return(result); }
public List <ReagentAndSuppliesConfiguration> GetAllActived() { List <ReagentAndSuppliesConfiguration> recordList = null; try { using (WanTaiEntities entities = new WanTaiEntities()) { var records = entities.ReagentAndSuppliesConfigurations.Where(c => c.ActiveStatus == true); recordList = records.ToList <ReagentAndSuppliesConfiguration>(); } } catch (Exception e) { string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace; LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->GetAll", SessionInfo.ExperimentID); throw; } return(recordList); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { string loginName = (string)(((DataRowView)dgUsers.CurrentItem)["LoginName"]); if (loginName == SessionInfo.LoginName) { MessageBox.Show("无法删除正在登陆的用户,请退出后再删除", "系统提示"); return; } MessageBoxResult msResult = MessageBox.Show("确认要删除用户吗?", "系统提示", MessageBoxButton.YesNo); if (msResult == MessageBoxResult.Yes) { string message; Guid userID = (Guid)(((DataRowView)dgUsers.CurrentItem)["UserID"]); userInfoController.Delete(userID, out message); LogInfoController.AddLogInfo(LogInfoLevelEnum.Operate, "删除用户 " + message, SessionInfo.LoginName, this.GetType().Name, SessionInfo.ExperimentID); MessageBox.Show(message, "系统提示"); BindUserInfo(); } }