/**
* 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);
}
