protected override void OnExecuteTaskResult(object state) { Dictionary <string, DataTable> paramList = new Dictionary <string, DataTable>(); using (var _conn = conneLab.CreateConnection()) { //Get data result from database eLab ReturnDataHis_v1 his_V1 = new ReturnDataHis_v1(settings, conHis, paramList); taskQueue.QueueBackgroundWorkItem(token => his_V1.ReturnDataHis(token)); } }
public void ExecuteServices(List <MappingServices> listServices) { using (var _conn = _connection.CreateConnection()) { List <MappingServices> listMapIn = new List <MappingServices>(); List <MappingServices> listMapUp = new List <MappingServices>(); IEnumerable <MappingServices> services = _conn.ExecuteQueryAsync <MappingServices>("GetMappingService").Result; foreach (var item in listServices) { string itemCode = item.ServiceCode_His.Normalize(); MappingServices svc = services.FirstOrDefault(x => x.ServiceCode_His.Normalize() == itemCode); if (svc != null) { listMapUp.Add(item); } else { listMapIn.Add(item); } } if (listMapIn.Count > 0) { watch.Start(); int empIn = _conn.ExecuteNonQuery("InsertDichVuMappingJson" , new { JSON_DATA = JsonConvert.SerializeObject(listMapIn, Jsonsettings) }); watch.Stop(); this.Writer2("Insert Service", empIn, listMapIn.Count, watch); } if (listMapUp.Count > 0) { watch.Start(); int empUp = _conn.ExecuteNonQuery("UpdateDichVuMappingJson" , new { JSON_DATA = JsonConvert.SerializeObject(listMapUp, Jsonsettings) }); watch.Stop(); this.Writer2("Update Service", empUp, listMapUp.Count, watch); } } }
public void InsertData(CancellationToken cancellationToken) { if (cancellationToken.IsCancellationRequested) { return; } try { IExecuteDataSource executeData = new ExecuteDataSource(settings, _conneLab, _logger); using (var _conn = _conneLab.CreateConnection()) { Stopwatch watch = new Stopwatch(); if (paramList.Count > 0) { #region Get PatientType var PatientTypes = paramList["PatientType"] as List <FPT.eHospital.LISClient.PatientTypeLab>; List <PatientTypeInfo> listPatientType = new List <PatientTypeInfo>(); if (PatientTypes.Count > 0) { foreach (var p in PatientTypes) { PatientTypeInfo pTypeIU = new PatientTypeInfo(); pTypeIU.PatientType_Id = p.DOITUONG_ID; pTypeIU.PatientTypeCode = p.MADOITUONG; pTypeIU.PatientTypeName = p.TENDOITUONG; pTypeIU.Enabled = p.TAMNGUNG; listPatientType.Add(pTypeIU); } executeData.ExecutePatientType(listPatientType); } #endregion #region Get List Department var Departments = paramList["Department"] as List <FPT.eHospital.LISClient.DepartmenteLab>; List <DepartmentInfo> listDepartment = new List <DepartmentInfo>(); if (Departments.Count > 0) { foreach (var item in Departments) { DepartmentInfo dep = new DepartmentInfo(); dep.DepartmentID = item.PHONGBAN_ID; dep.DepartmentCode = item.MAPHONGBAN; dep.DepartmentName = item.TENPHONGBAN; dep.Level = item.CAP; dep.ParentID = item.CAPTREN_ID; dep.IsMadeServices = item.COTHUCHIENDICHVU; dep.Enabled = item.TAMNGUNG; listDepartment.Add(dep); } executeData.ExecuteDepartment(listDepartment); } #endregion #region Get List Employee var Employees = paramList["Employee"] as List <FPT.eHospital.LISClient.EmployeeLab>; List <EmployeeInfo> listEmployee = new List <EmployeeInfo>(); if (Employees.Count > 0) { foreach (var emp in Employees) { EmployeeInfo employee = new EmployeeInfo(); employee.Employee_ID = emp.NHANVIEN_ID; employee.EmployeeCode = emp.MANHANVIEN; employee.EmployeeName = emp.TENNHANVIEN; employee.DepartmentID = emp.PHONGBAN_ID; employee.Nationality = emp.QUOCGIA; employee.Enabled = emp.TAMNGUNG; employee.Address = emp.DIACHI; if (emp.GIOITINH == 1) { employee.Sex = "Nam"; } else { employee.Sex = "Nữ"; } listEmployee.Add(employee); } executeData.ExecuteEmployee(listEmployee); } #endregion #region Get Mapping Service var Services = paramList["Services"] as List <FPT.eHospital.LISClient.Model.DichVuModel>; List <MappingServices> mappingServices = new List <MappingServices>(); if (Services.Count > 0) { foreach (var item in Services) { MappingServices mapp = new MappingServices(); mapp.ServiceId_His = item.DichVu_Id; mapp.ServiceCode_His = item.MaDichVu; mapp.ServiceName_His = item.TenDichVu; mapp.CreateDate = DateTime.Now; mapp.ModifyDate = DateTime.Now; mappingServices.Add(mapp); } executeData.ExecuteServices(mappingServices); } #endregion #region Get Chỉ định dịch vụ var chiDinh = paramList["ChiDinhDichVu"] as List <FPT.eHospital.LISClient.PatientHasNotSID>; List <PatientHasNotSID> patientHasNots = new List <PatientHasNotSID>(); if (chiDinh.Count > 0) { foreach (var item in chiDinh) { PatientHasNotSID patientHas = new PatientHasNotSID(); patientHas.DVYeuCau_His_Id = item.DVYEUCAU_ID; patientHas.SoPhieuYeuCau = item.SOPHIEUYEUCAU; patientHas.BacSiChiDinh_Id = item.BACSICHIDINH_ID; patientHas.NoiThucHien_Id = item.NOITHUCHIEN_ID; patientHas.BenhNhan_Id = item.BENHNHAN_ID; patientHas.MaYTe = item.MAYTE; patientHas.Ho = item.HO; patientHas.Ten = item.TEN; patientHas.TenBenhNhan = item.TENBENHNHAN; patientHas.GioiTinh = item.GIOITINH; patientHas.NamSinh = item.NAMSINH; patientHas.NgaySinh = item.NGAYSINH; patientHas.DiaChiLienLac = item.DIACHILIENLAC; patientHas.NgayYeuCau = item.NGAYYEUCAU; patientHas.ThoiGianYeuCau = item.NGAYGIOYEUCAU; patientHas.DichVu_Id = item.DICHVU_ID; patientHas.NgayTao = item.NGAYTAO; patientHas.NguoiTao_Id = item.NGUOITAO_ID; patientHasNots.Add(patientHas); } executeData.ExecutePatientAndService(patientHasNots); } #endregion } } } catch (Exception ex) { ConsoleWriter.WriteMessage(ex.Message, ConsoleColor.Red); _logger.LogError(ex.Message); } finally { } }
public void InsertData(CancellationToken cancellationToken) { if (cancellationToken.IsCancellationRequested) { return; } try { IExecuteDataSource executeData = new ExecuteDataSource(_settings, _conneLab, _logger); using (var _conn = _conneLab.CreateConnection()) { if (_paramList.Count > 0) { var PatientTypes = _paramList["PatientTypes"] as List <PatientTypeInfo>; if (PatientTypes.Count > 0) { executeData.ExecutePatientType(PatientTypes); } var Departments = _paramList["Departments"] as List <DepartmentInfo>; if (Departments.Count > 0) { executeData.ExecuteDepartment(Departments); } var Employees = _paramList["Employees"] as List <EmployeeInfo>; List <EmployeeInfo> listEmployee = new List <EmployeeInfo>(); if (Employees.Count > 0) { foreach (var item in Employees) { if (item.Sex == "F") { item.Sex = "Nữ"; } else { item.Sex = "Nam"; } listEmployee.Add(item); } executeData.ExecuteEmployee(listEmployee); } var MappingServices = _paramList["MappingServices"] as List <MappingServices>; if (MappingServices.Count > 0) { executeData.ExecuteServices(MappingServices); } var PatientHasNots = _paramList["PatientHasNotSID"] as List <PatientHasNotSID>; if (PatientHasNots.Count > 0) { executeData.ExecutePatientAndService(PatientHasNots); } } } } catch (Exception ex) { ConsoleWriter.WriteMessage(ex.Message, ConsoleColor.Red); _logger.LogError(ex.Message); } finally { } }