/** * Edita un registro en la tabla * @param Error obj * @return boolean indicando si se realizo o no la actualizacion */ public ErrorResponse editarError(Error obj) { ErrorResponse resultado = new ErrorResponse(); try { ErrorDao dao = new ErrorDao(); conn = conexion.conectar(); obj.ERROR = obj.ERROR.Replace(char.Parse("'"), '_'); try { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 149); } catch (Exception exp) { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 80); } dao.save(conn, obj); resultado.correcto = true; resultado.error = ""; resultado.objeto = obj; } catch (Exception e) { resultado.correcto = false; resultado.error = e.Message; resultado.objeto = obj; } finally { if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(resultado); }
public int contarBusquedaError(Error obj) { int cantidad = -1; try { ErrorDao dao = new ErrorDao(); conn = conexion.conectar(); obj.ERROR = obj.ERROR.Replace(char.Parse("'"), '_'); try { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 149); } catch (Exception exp) { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 80); } obj.ERROR = String.Empty; cantidad = dao.countSearchMatching(conn, obj); } catch (Exception e) { cantidad = -1; } finally { if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(cantidad); }
/** * Consulta todos los registros de la tabla pero con Paginacion * @param Error obj * @return Retorna la lista de los registros en la tabla con paginacion */ public Error[] listarError(int pagina, int numRegPagina) { Error[] result = null; List <Error> lista = null; if (pagina > 0 && numRegPagina > 0) { pagina--; int limInf = 0; int limSup = 0; limInf = pagina * numRegPagina + 1; limSup = (pagina + 1) * numRegPagina; try { ErrorDao dao = new ErrorDao(); conn = conexion.conectar(); if (limInf <= dao.countAll(conn)) { lista = dao.loadAll(conn, limInf, limSup); if (lista != null && lista.Count > 0) { result = lista.ToArray(); } } } catch (Exception e) { result = null; } finally { if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } } return(result); }
/** * Busca los registros que coincidan con los datos enviados * @param Error obj * @return Retorna la lista de los registros que coinciden */ public Error[] buscarError(Error obj) { Error[] result = null; List <Error> lista = null; try { ErrorDao dao = new ErrorDao(); conn = conexion.conectar(); obj.ERROR = obj.ERROR.Replace(char.Parse("'"), '_'); try { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 149); } catch (Exception exp) { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 80); } obj.ERROR = String.Empty; lista = dao.searchMatching(conn, obj); if (lista != null && lista.Count > 0) { result = lista.ToArray(); } } catch (Exception e) { result = null; } finally { if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(result); }
/** * Inserta nuevo registro en la tabla * @param Error obj * @return Retorna el mismo objeto pero con la llave primaria configurada */ public ErrorResponse crearError(Error obj) { List <Error> lista = null; ErrorResponse objResponse = new ErrorResponse(); Error obj_new = new Error(); try { ErrorDao dao = new ErrorDao(); conn = conexion.conectar(); obj.ERROR = obj.ERROR.Replace(char.Parse("'"), '_'); try { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 149); } catch (Exception exp) { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 80); } dao.create(conn, obj); //verificar existencia obj_new.ERROR = obj.ERROR; lista = dao.searchMatching(conn, obj_new); if (lista != null && lista.Count > 0) { obj_new = (Error)lista[0]; } else { obj_new.ID_ERROR = -1; } objResponse.correcto = true; objResponse.error = ""; objResponse.objeto = obj_new; } catch (Exception e) { obj_new.ID_ERROR = -1; objResponse.correcto = false; objResponse.error = e.Message; objResponse.objeto = obj_new; } finally { if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(objResponse); }
public bool LogError(CommonManagerProxy proxy, Exception ex) { try { ErrorDao errDao = new ErrorDao { DateCreated = DateTime.Now, StackTrace = ex.StackTrace, Message = ex.Message }; SaveError(proxy, errDao); return(true); } catch { return(false); } }
public bool SaveError(CommonManagerProxy proxy, ErrorDao error) { try { using (ITransaction tx = proxy.DevelopmentManager.GetTransaction()) { tx.PersistenceManager.UserRepository.Save(error); tx.Commit(); } return(true); } catch (DBConcurrencyException ex) { return(false); } catch (Exception ex) { return(false); } }
/** * Elimina un registro de la tabla * @param Error obj * @return Retorna un boolean indicando si se realizo o no la operacion */ public ErrorResponse eliminarError(Error obj) { ErrorResponse resultado = new ErrorResponse(); try { ErrorDao dao = new ErrorDao(); conn = conexion.conectar(); dao.delete(conn, obj); resultado.correcto = true; resultado.error = ""; resultado.objeto = obj; } catch (Exception e) { resultado.correcto = false; resultado.error = e.Message; resultado.objeto = obj; } finally { if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(resultado); }
/** * Consulta todos los registros de la tabla * @param Error obj * @return Retorna la lista de los registros en la tabla */ public Error[] listarError() { Error[] result = null; List <Error> lista = null; try { ErrorDao dao = new ErrorDao(); conn = conexion.conectar(); lista = dao.loadAll(conn); if (lista != null && lista.Count > 0) { result = lista.ToArray(); } } catch (Exception e) { result = null; } finally { if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(result); }
/** * Busca el primer registro que coincida con los datos enviados * @param Error obj * @return Retorna el mismo objeto pero con los datos consultados */ public Error buscarPrimeroError(Error obj) { List <Error> lista = null; try { ErrorDao dao = new ErrorDao(); conn = conexion.conectar(); obj.ERROR = obj.ERROR.Replace(char.Parse("'"), '_'); try { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 149); } catch (Exception exp) { obj.CAMPO_DE_BUSQUEDA = obj.ERROR.Substring(0, 80); } obj.ERROR = String.Empty; lista = dao.searchMatching(conn, obj); if (lista != null && lista.Count > 0) { obj = (Error)lista[0]; } else { obj.ID_ERROR = -1; } } catch (Exception e) { obj.ID_ERROR = -1; } finally { if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(obj); }
/// <summary> /// /// </summary> /// <param name="uploadManagement">传入上传管理者实体</param> /// <returns>返回可以用来上传的辅助对象</returns> public ServiceResult GetServiceResult(UploadManagement uploadManagement) { //service返回结果对象 ServiceResult serviceResult = new ServiceResult(); //提前载入唯一Setter SetterDAO setterDAO = new SetterDAO(); Setter setter = setterDAO.getSetter(); //需要加入解密逻辑 TODO string mac = ""; //try //{ // byte[] deBytes = AesUtil.Decrypt(Encoding.GetEncoding("GBK").GetBytes(setter.Set_Unique_Id), // ProtocolConstant.USB_DOG_PASSWORD); // mac = Encoding.GetEncoding("GBK").GetString(deBytes); //} //catch (Exception ex) //{ // mac = setter.Set_Unique_Id.Replace(":", ""); //} byte[] a = ProtocolUtil.StringToBcd(setter.Set_Unique_Id); byte[] b = AesUtil.Decrypt(a, ProtocolConstant.USB_DOG_PASSWORD); mac = Encoding.GetEncoding("GBK").GetString(b).Replace(":", "-"); ///if识别出表,设置发送路径,select出实体,转化至DTO,json打成string,返回 //识别是否是权限用户添加 if (uploadManagement.UM_DataTable == "bdl_auth") { AuthDAO authDAO = new AuthDAO(); Auther auther = authDAO.Load(uploadManagement.UM_DataId); if (auther == null) { return(null); } AutherDTO autherDTO = new AutherDTO(setter, auther, mac); //serviceResult.URL = "clientController/addClient.action"; serviceResult.Data = JsonTools.Obj2JSONStrNew <AutherDTO>(autherDTO); } //bdl_customdata表 else if (uploadManagement.UM_DataTable == "bdl_customdata") { CustomDataDAO customDataDAO = new CustomDataDAO(); CustomData customData = customDataDAO.Load(uploadManagement.UM_DataId); if (customData == null) { return(null); } CustomDataDTO customDataDTO = new CustomDataDTO(customData, mac); serviceResult.Data = JsonTools.Obj2JSONStrNew <CustomDataDTO>(customDataDTO); } //bdl_datacode表 else if (uploadManagement.UM_DataTable == "bdl_datacode") { DataCodeDAO dataCodedao = new DataCodeDAO(); DataCode dataCode = dataCodedao.Load(uploadManagement.UM_DataId); if (dataCode == null) { return(null); } DataCodeDTO dataCodeDTO = new DataCodeDTO(dataCode, mac); serviceResult.Data = JsonTools.Obj2JSONStrNew <DataCodeDTO>(dataCodeDTO); } //bdl_deviceset表 else if (uploadManagement.UM_DataTable == "bdl_deviceset") { DeviceSetDAO deviceSetDAO = new DeviceSetDAO(); DeviceSet deviceSet = deviceSetDAO.Load(uploadManagement.UM_DataId); if (deviceSet == null) { return(null); } DeviceSetDTO deviceSetDTO = new DeviceSetDTO(deviceSet, mac); serviceResult.Data = JsonTools.Obj2JSONStrNew <DeviceSetDTO>(deviceSetDTO); } //bdl_devicesort表 else if (uploadManagement.UM_DataTable == "bdl_devicesort") { DeviceSortDAO deviceSortDAO = new DeviceSortDAO(); DeviceSort deviceSort = deviceSortDAO.Load(uploadManagement.UM_DataId); if (deviceSort == null) { return(null); } DeviceSortDTO deviceSortDTO = new DeviceSortDTO(deviceSort, mac); serviceResult.Data = JsonTools.Obj2JSONStrNew <DeviceSortDTO>(deviceSortDTO); } //bdl_onlinedevice表 else if (uploadManagement.UM_DataTable == "bdl_onlinedevice") { OnlineDeviceDAO onlineDeviceDAO = new OnlineDeviceDAO(); OnlineDevice onlineDevice = onlineDeviceDAO.Load(uploadManagement.UM_DataId); if (onlineDevice == null) { return(null); } OnlineDeviceDTO onlineDeviceDTO = new OnlineDeviceDTO(onlineDevice, mac); serviceResult.Data = JsonTools.Obj2JSONStrNew <OnlineDeviceDTO>(onlineDeviceDTO); } //bdl_set表 else if (uploadManagement.UM_DataTable == "bdl_set") { SetterDAO setterDAO1 = new SetterDAO(); Setter setter1 = setterDAO1.Load(uploadManagement.UM_DataId); if (setter1 == null) { return(null); } SetterDTO setterDTO = new SetterDTO(setter1, mac); serviceResult.Data = JsonTools.Obj2JSONStrNew <SetterDTO>(setterDTO); } //病人表 else if (uploadManagement.UM_DataTable == "bdl_user") { UserDAO userDAO = new UserDAO(); User user = userDAO.Load(uploadManagement.UM_DataId); if (user == null) { return(null); } UserDTO userDTO = new UserDTO(user, mac); //serviceResult.URL = "bigData/bodyStrongUser"; serviceResult.Data = JsonTools.Obj2JSONStrNew <UserDTO>(userDTO); } //症状表 else if (uploadManagement.UM_DataTable == "bdl_symptominfo") { SymptomInfoDao symptomInfoDao = new SymptomInfoDao(); var result = symptomInfoDao.Load(uploadManagement.UM_DataId); if (result == null) { return(null); } SymptomInfoDTO symptomInfoDTO = new SymptomInfoDTO(result, mac); //serviceResult.URL = "bigData/symptomInfo"; serviceResult.Data = JsonTools.Obj2JSONStrNew <SymptomInfoDTO>(symptomInfoDTO); } //训练处方总表 else if (uploadManagement.UM_DataTable == "bdl_traininfo") { TrainInfoDAO trainInfoDAO = new TrainInfoDAO(); var result = trainInfoDAO.Load(uploadManagement.UM_DataId); if (result == null) { return(null); } TrainInfoDTO trainInfoDTO = new TrainInfoDTO(result, mac); //serviceResult.URL = "bigData/trainInfo"; serviceResult.Data = JsonTools.Obj2JSONStrNew <TrainInfoDTO>(trainInfoDTO); } //总表中的一条数据对某台设备的具体处方 else if (uploadManagement.UM_DataTable == "bdl_deviceprescription") { DevicePrescriptionDAO devicePrescriptionDAO = new DevicePrescriptionDAO(); var result = devicePrescriptionDAO.Load(uploadManagement.UM_DataId); if (result == null) { return(null); } DevicePrescriptionDTO devicePrescriptionDTO = new DevicePrescriptionDTO(result, mac); //serviceResult.URL = "bigData/devicePrescription"; serviceResult.Data = JsonTools.Obj2JSONStrNew <DevicePrescriptionDTO>(devicePrescriptionDTO); } //具体处方的具体反馈 else if (uploadManagement.UM_DataTable == "bdl_prescriptionresult") { PrescriptionResultDAO prescriptionResultDAO = new PrescriptionResultDAO(); var result = prescriptionResultDAO.Load(uploadManagement.UM_DataId); if (result == null) { return(null); } PrescriptionResultDTO prescriptionResultDTO = new PrescriptionResultDTO(result, mac); //serviceResult.URL = "bigData/prescriptionResult"; serviceResult.Data = JsonTools.Obj2JSONStrNew <PrescriptionResultDTO>(prescriptionResultDTO); } else if (uploadManagement.UM_DataTable == "bdl_physicalpower") { PhysicalPowerDAO physicalPowerDAO = new PhysicalPowerDAO(); var result = physicalPowerDAO.Load(uploadManagement.UM_DataId); if (result == null) { return(null); } PhysicalPowerDTO physicalPowerDTO = new PhysicalPowerDTO(result, mac); //serviceResult.URL = "bigData/physicalPower"; serviceResult.Data = JsonTools.Obj2JSONStrNew <PhysicalPowerDTO>(physicalPowerDTO); } else if (uploadManagement.UM_DataTable == "bdl_error") { ErrorDao errorDao = new ErrorDao(); var result = errorDao.Load(uploadManagement.UM_DataId); if (result == null) { return(null); } ErrorDTO errorDTO = new ErrorDTO(result, mac); //serviceResult.URL = "bigData/physicalPower"; serviceResult.Data = JsonTools.Obj2JSONStrNew <ErrorDTO>(errorDTO); } return(serviceResult); }