// Public Methods (9)
/// <summary>
/// Deletes the views.
/// </summary>
/// <param name="data">The data.</param>
/// <returns></returns>
public string DeleteViews(string data)
{
try
{
using (var gridViewFactory = new GridViewManagerFactory())
{
foreach (GridView gridView in GridViewUtils.ExtractViews(data))
{
using (
IGridViewManager gridViewManager = gridViewFactory.MakeGridViewManager(ComponentName,
gridView))
{
gridViewManager.Remove(gridView);
}
}
}
return("<AssignmentPlannerViews/>");
}
catch (APIException)
{
throw;
}
catch (Exception e)
{
throw new APIException((int)Errors.DeleteViews, e.Message);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
DataRow prevRow = GetPrevRow();
DateTime dt = patient.admissionDate;
if (prevRow != null)
{
DateTime prevTime = (DateTime)prevRow["Date"];
dt = new DateTime(prevTime.Year, prevTime.Month, prevTime.Day);
dt += TimeSpan.FromDays(1);
}
Reacard reacard = new Reacard(patient.Id);
reacard.date = dt;
ReacardForm form = new ReacardForm(reacard, patient);
if (form.ShowDialog() == DialogResult.OK)
{
DataRow newRow = dataTable.NewRow();
dataTable.Rows.Add(newRow);
UpdateRow(newRow, reacard);
GridViewUtils.SetCurrentRow(gridView, newRow);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
private void MainWindow_Load_1(object sender, EventArgs e)
{
// Задаём начальные пути для диалогов открытия/сохранения файла
this.LoadFileDialog.InitialDirectory = Environment.CurrentDirectory;
this.SaveFileDialog.InitialDirectory = Environment.CurrentDirectory;
// Инициализируем наши DataGridView (задаём им начальные свойства)
GridViewUtils.InitGridForArr(inputGridView, 40, false, true, true, true, true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Carrega();
GridViewUtils.BindGrid(gvTask, new List <Task>());
}
}
public void Setup()
{
TestBase.Invoke(() =>
{
grid = new GridView();
// Some platforms need at least one column for selection to work
grid.Columns.Add(new GridColumn {
HeaderText = "Text", DataCell = new TextBoxCell("Id")
});
model = GridViewUtils.CreateModel();
grid.DataStore = model;
grid.SelectionChanged += (s, e) => selectionChangedCount++;
selectionChangedCount = 0;
});
}
void LoadData()
{
string fieldName = "HospitalStay" + App.DepartmentConfig.hospitalType.ToString();
string cmdText = string.Format("select *, {0} as HospitalStay from Diagnoses where {0}>0", fieldName);
using (GmConnection conn = App.CreateConnection())
{
dataAdapter = conn.CreateDataAdapter(cmdText);
dataAdapter.Fill(dataTable);
}
gridView.DataSource = dataTable;
if (diagnosisInfo.code.Trim().Length > 0)
{
GridViewUtils.SetCurrentRow(gridView, "Code='" + diagnosisInfo.code + "'");
}
}
private void Add(ObservationTypeId observationTypeId)
{
try
{
using (WaitCursor wc = new WaitCursor())
{
DataRow dr = GetPrevObservationRow(observationTypeId);
DateTime prevTime = dr != null ? (DateTime)dr["Time"] : patient.admissionDate;
DateTime dt = App.DepartmentConfig.GetNextObservationTime(observationTypeId, patient.patientTypeId, prevTime, dr == null);
if (patient.dischargeDate != DateTime.MinValue && dt > patient.dischargeDate)
{
FormUtils.MessageExcl("Время наблюдения не должно быть позднее времени выписки.");
return;
}
Observation observation = new Observation(observationTypeId);
HandbookGroupId hgId = Observation.GetHandbookGroupId(observationTypeId);
if (dr != null)
{
observation.description = ObservationData.Create(dr["Description"] as string);
}
else
{
observation.description.Init(App.Config[hgId], patient.patientDescription);
}
observation.time = dt;
observation.patientId = patient.Id;
observation.doctorId = App.Instance.UserId;
ObservationForm form = new ObservationForm(observation, patientName);
if (form.ShowDialog() == DialogResult.OK)
{
DataRow newRow = dataTable.NewRow();
dataTable.Rows.Add(newRow);
UpdateRow(newRow, observation);
newRow["ObservationTypeId"] = (int)observationTypeId;
newRow["ObservationTypeName"] = observationTypes[observationTypeId];
GridViewUtils.SetCurrentRow(gridView, newRow);
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
public void Setup()
{
TestUtils.Invoke(() =>
{
grid = new GridView();
// Some platforms need at least one column for selection to work
grid.Columns.Add(new GridColumn {
HeaderText = "Text", DataCell = new TextBoxCell("Id")
});
model = GridViewUtils.CreateModel();
// create our filtered collection
filtered = new FilterCollection <DataItem>(model);
filtered.Change = () => grid.SelectionPreserver;
grid.DataStore = filtered;
grid.SelectionChanged += (s, e) => selectionChangedCount++;
selectionChangedCount = 0;
});
}
protected void btnPesquisa_Click(object sender, EventArgs e)
{
Sessions.ListaTask = new List <Componente.Supero.Task.Task>();
Sessions.TaskNova = new Componente.Supero.Task.Task();
Sessions.TaskNova.Descricao = txtDescricaoInicio.Text;
if (!string.IsNullOrEmpty(txtDataConclusao.Value))
{
Sessions.TaskNova.DataConclusao = Convert.ToDateTime(txtDataConclusao.Value);
}
if (!string.IsNullOrEmpty(txtDataCriacao.Value))
{
Sessions.TaskNova.DataCriacao = Convert.ToDateTime(txtDataCriacao.Value);
}
if (!string.IsNullOrEmpty(txtDataEdicao.Value))
{
Sessions.TaskNova.DataEdicao = Convert.ToDateTime(txtDataEdicao.Value);
}
if (!string.IsNullOrEmpty(txtDataRemocao.Value))
{
Sessions.TaskNova.DataRemocao = Convert.ToDateTime(txtDataRemocao.Value);
}
Sessions.TaskNova.CodigoTaskStatus = Convert.ToInt32(ddlTaskStatus.SelectedValue);
if (!string.IsNullOrEmpty(txtCodigo.Text))
{
Sessions.TaskNova.Codigo = Convert.ToInt32(txtCodigo.Text);
}
Sessions.TaskNova.Ativo = true;
TaskBLL.CarregaTask(Sessions.TaskNova, Sessions.ListaTask);
GridViewUtils.BindGrid(gvTask, Sessions.ListaTask);
}
public void ApplyFilters()
{
if (applyFilterEvents == false)
{
return;
}
dgvReceiptData.Rows.Clear();
List <ImpData> filteredLines = new List <ImpData>();
//cbGeoFilter
if (cbGeoFilter.SelectedIndex == 0) //"Όλα"
{
filteredLines = objList;
}
else if (cbGeoFilter.SelectedIndex == 1) //"Χωρίς Γεωγρ. Σημείο"
{
filteredLines = objList.Where(i => i.geostationId == 0).ToList();
}
else if (cbGeoFilter.SelectedIndex == 2) //"Νέα Σημεία Πρατηρίων"
{
filteredLines = objList.Where(i => i.geostationId == 10).ToList();
}
//dtFrom & dtTo
filteredLines = filteredLines.Where(i => i.datetime >= dtFrom.Value.Date && i.datetime < dtTo.Value.Date.AddDays(1)).ToList();
List <object[]> ObjRows = GridViewUtils.DBDataToGridViewRowList(filteredLines);
GridViewUtils.ShowDataToDataGridView(dgvReceiptData, ObjRows);
RowsForeColorFromVolDiff(dgvReceiptData);
dgvReceiptData.ClearSelection();
//lblGridCounter.Text = "Εγγραφές: " + filteredLines.Count.ToString();
toolStripCounter.Text = "Εγγραφές: " + filteredLines.Count.ToString();
//dgvReceiptData.ClearSelection(); //
}
private void MainMenuFileOpen_Click(object sender, EventArgs e)
{
if (LoadFileDialog.ShowDialog() == DialogResult.OK)
{
try
{
// Читаем содержимое выбранного файла и преобразуем его в массив
string arrText = FilesUtils.Read(LoadFileDialog.FileName);
int[,] arr = TypesConverter.StrToArray2D <int>(arrText);
// Копируем полученный массив в DataGridView
GridViewUtils.Array2ToGrid(inputGridView, arr);
if (arr.GetLength(1) == 0 || arr.GetLength(0) == 0)
{
throw new Exception();
}
MessagesUtils.Show("Данные загружены");
}
catch (Exception exception)
{
MessagesUtils.ShowError("Ошибка загрузки данных");
}
}
}
private void ProcessBtn_Click(object sender, EventArgs e)
{
try
{
int[,] matrix = GridViewUtils.GridToArray2 <int>(inputGridView);
MatrixUtils <int> utils = new MatrixUtils <int>(matrix);
bool result = utils.IsOrderedSequenceExists(MatrixUtils <int> .OrderType.Asc) ||
utils.IsOrderedSequenceExists(MatrixUtils <int> .OrderType.Desc);
string answer = "Элементы образуют упорядоченную последовательность";
if (!result)
{
answer = "Элементы не образуют упорядоченную последовательность";
}
this.OutputTextLbl.Text = "Результат проверки: " + Environment.NewLine + answer;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnImport_Click(object sender, EventArgs e)
{
DbUtilities dbu = new DbUtilities();
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "JSON files (*.json)|*.json";
DialogResult result = ofd.ShowDialog();
json_path = ofd.FileName;
if (json_path.Trim() == "" || result != DialogResult.OK)
{
return;
}
//init
lblImpFile.Text = "Αρχείο: -";
objList.Clear();
vtObjList.Clear();
stationsObjList.Clear();
dgvReceiptData.Rows.Clear();
json_filename = "";
//json_path = "";
if (fileBytes != null)
{
Array.Clear(fileBytes, 0, fileBytes.Length);
}
counters.Clear();
Output.WriteToFile("***** STARTING... *****");
Output.WriteToFile("-- Import Function --");
Output.WriteToFile("Filename: " + json_path);
string read_data = dbu.getAllDataFromJsonFile(json_path);
if (read_data.Trim() == "")
{
Output.WriteToFile("Empty file!");
return;
}
//get byte[] ready to import into table
// VehicleTrace -->
ImpData_And_VehicleTrace AllData = dbu.JsonToMultipleObject(read_data);
List <ImpData> DataToMigrateNew = AllData.impData;
List <VehicleTrace> VehicleTraceToMigrate = AllData.vehicleTrace;
vtObjList = VehicleTraceToMigrate;
List <Station> StationToMigrate = AllData.stationData;
stationsObjList = StationToMigrate;
// VehicleTrace <--
List <ImpData> DataToMigrate = dbu.JsonToObjectList(read_data);
// VehicleTrace -->
DataToMigrate = DataToMigrateNew;
// VehicleTrace <--
counters.fileRows = DataToMigrate.Count;
counters.fileAccRows = DataToMigrate.Count(i => i.accepted == true);
counters.fileNAccRows = DataToMigrate.Count(i => i.accepted == false);
Output.WriteToFile("Rows in file: " + counters.fileRows.ToString());
Output.WriteToFile("File - Accepted=true Rows: " + counters.fileAccRows.ToString() + ", Accepted=false Rows: " + counters.fileNAccRows.ToString());
objList = dbu.GetDataNotExistsInSQLSrvTable(DataToMigrate);
counters.toSaveRows = objList.Count;
Output.WriteToFile("Rows to save: " + objList.Count.ToString());
json_filename = json_path.Substring(json_path.LastIndexOf("\\") + 1);
//get file contents as byte[]
fileBytes = System.IO.File.ReadAllBytes(json_path);
if (objList.Count > 0)
{
counters.toSaveAccRows = objList.Count(i => i.accepted == true);
counters.toSaveNAccRows = objList.Count(i => i.accepted == false);
Output.WriteToFile("To save - Accepted=true Rows: " + counters.toSaveAccRows.ToString() + ", Accepted=false Rows: " + counters.toSaveNAccRows.ToString());
counters.vehicleTraceRows = vtObjList.Count;
counters.stationsUpdRows = stationsObjList.Count;
List <object[]> ObjRows = GridViewUtils.ImpDataListToGridViewRowList(objList, true);
GridViewUtils.ShowDataToDataGridView(dgvReceiptData, ObjRows);
lblImpFile.Text = "Αρχείο: " + json_filename;
}
else
{
MessageBox.Show("Δε βρέθηκαν εγγραφές προς επεξεργασία! \r\n" +
"Παρακαλώ μετακινήστε στο φάκελο αρχειοθέτησης το αρχείο " + json_path + ".");
}
}
