private Procedure CalculateScreenTimeWindow(ProcedureEntity procedureEntity) { if (procedureEntity == null) { return(null); } string currentTime = procedureEntity.CurrentTime.ToString("HH:mm"); Procedure procedure = new Procedure(currentTime); int.TryParse(procedureEntity.CurrentTime.ToString("HH"), out int currentHour); // set the startpoint and end point of the procedure screen. // start point is -2hr of the current hour and end is +8hr of start hour // below logic is to handle if current time is 0 hr, 1 hr int stPoint = (currentHour - 2) % 24; if (stPoint < 0) { stPoint += 24; } procedure.StartTime = Helper.StringToIntTime($"{stPoint.ToString()}:00"); procedure.EndTime = Helper.StringToIntTime($"{((currentHour + 6) % 24).ToString()}:00"); return(procedure); }
public List <ProcedureEntity> GetDataFromDB(ProjectAllocationFramework.Statues.ProgressChangedEventHandler OnProgress, ProcedureSearchCondtion searchCondition = null) { List <ProcedureEntity> entityList = new List <ProcedureEntity>(); string sql = "select ProcedureCode, ProcedureName, Percent FROM [Procedure] WHERE 1=1 and ProcedureCode like @ProcedureCode and ProcedureName like @ProcedureName ORDER BY ProcedureCode"; DbCommand cmd = DatabaseUtil.GetCommand(db.GetSqlStringCommand(sql)); string procedureCode = string.Empty; string procedureName = string.Empty; if (searchCondition != null) { procedureCode = searchCondition.ProcedureCode.Trim(); procedureName = searchCondition.ProcedureName.Trim(); } db.AddInParameter(cmd, "ProcedureCode", DbType.String, '%' + procedureCode + '%'); db.AddInParameter(cmd, "ProcedureName", DbType.String, '%' + procedureName + '%'); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { ProcedureEntity item = new ProcedureEntity(); item.ProcedureCode = ConvertUtil.ToString(reader["ProcedureCode"]); item.ProcedureName = ConvertUtil.ToString(reader["ProcedureName"]); item.Percent = ConvertUtil.ToString(reader["Percent"]); item.Action = Constant.ACTION_UPDATE; item.ReadOnly = true; //throw new Exception(); entityList.Add(item); } } return(entityList); }
public StructureModel(ProcedureEntity procedureEntity) { Type = "v"; Name = procedureEntity.ProcedureName; if (string.IsNullOrEmpty(procedureEntity.Comment) == false) { Comment = procedureEntity.Comment; } Items = new List <StructureItemModel>(); }
private PatientInfo GetPatientData(ProcedureEntity pro) { PatientInfo patientInfo = new PatientInfo(); patientInfo.Name = $"{pro.FirstName},{pro.LastName}"; patientInfo.Info = pro.MRN; patientInfo.SurgeonName = $"{pro.SurgeonFirstName},{pro.SurgeonLastName}"; patientInfo.Anesthologist = $"{pro.AnestFirstName},{pro.AnestLastName}"; patientInfo.Crna = $"{pro.CrnaFirstName},{pro.CrnaLastName}"; patientInfo.CircleNurse = $"{pro.NuresFirstName},{pro.NurseLastName}"; return(patientInfo); }
public ProcedureEntity GetProcedure(string connStr, string databaseName, string schemaName, string procedureName) { var sql = $"SHOW PROCEDURE STATUS WHERE Db='{databaseName}' and Name='{procedureName}'"; var helper = SqlHelperFactory.OpenDatabase(connStr, _provider.GetProviderFactory(), SqlType.MySql); var dt = helper.ExecuteDataTable(sql); helper.Dispose(); ProcedureEntity result = new ProcedureEntity(); result.DatabaseName = databaseName; result.ProcedureName = procedureName; result.Comment = dt.Rows[0]["Comment"].ToString(); result.Params = GetProcedureParams(connStr, databaseName, schemaName, procedureName); return(result); }
public List <ProcedureEntity> GetProcedures(string connStr, string databaseName) { var sql = $"SHOW PROCEDURE STATUS WHERE Db='{databaseName}'"; var helper = SqlHelperFactory.OpenDatabase(connStr, _provider.GetProviderFactory(), SqlType.MySql); var dt = helper.ExecuteDataTable(sql); helper.Dispose(); List <ProcedureEntity> procedureEntities = new List <ProcedureEntity>(); for (int i = 0; i < dt.Rows.Count; i++) { var row = dt.Rows[i]; var entity = new ProcedureEntity { DatabaseName = row["Db"].ToString(), ProcedureName = row["Name"].ToString(), Comment = row["Comment"].ToString(), }; procedureEntities.Add(entity); } return(procedureEntities); }
public override IList <ProcedureEntity> GetProcedures(DataBaseEntity database) { IList <ProcedureEntity> list = null; using (MySqlConnection connection = new MySqlConnection(database.DbConnectionStringBuilder.ConnectionString)) { connection.Open(); DataTable procedures = connection.GetSchema(SqlClientMetaDataCollectionNames.Procedures, new string[] { null, null, null, "PROCEDURE" }); if (procedures != null && procedures.Rows.Count > 0) { list = new List <ProcedureEntity>(); foreach (DataRow procedure in procedures.Rows) { string name = string.Format("{0}", procedure["SPECIFIC_NAME"]); string des = string.Format("{0}.{1}", procedure["ROUTINE_SCHEMA"], procedure["SPECIFIC_NAME"]); ProcedureEntity proc = new ProcedureEntity(database.DbConnectionStringBuilder, name, des); proc.DataBase = database; list.Add(proc); } } } return(list); }
public List <ProcedureEntity> GetData(params object[] paras) { this.EndEdit(); List <ProcedureEntity> entityList = new List <ProcedureEntity>(); int rowIdx = 1; foreach (DataGridViewRow item in this.Rows) { ProcedureEntity entity = new ProcedureEntity(); entity.Del = ConvertUtil.ToBoolean(item.Cells[this.delColumn.Name].Value); entity.ProcedureCode = ConvertUtil.ToString(item.Cells[this.procedureCodeColumn.Name].Value); entity.ProcedureName = ConvertUtil.ToString(item.Cells[this.procedureNameColumn.Name].Value); entity.Percent = ConvertUtil.ToString(item.Cells[this.percentColumn.Name].Value, "0.00"); entity.ReadOnly = item.Cells[this.procedureCodeColumn.Name].ReadOnly; entity.Row = rowIdx; rowIdx++; if (!string.IsNullOrEmpty(entity.ProcedureCode)) { entityList.Add(entity); } } return(entityList); }