public long m_lngGetReportObject(IPrincipal p_objPrincipal, string p_strApplicationID, out clsReportObject p_objReportObject) { p_objReportObject = null; long result = -1; SqlHelper svc = null; svc = new SqlHelper(EnumBiz.onlineDB); string Sql = "select * from t_opr_lis_report_object where application_id_chr = ? "; IDataParameter[] param = null; param = svc.CreateParm(1); param[0].Value = p_strApplicationID; DataTable dataTable = null; dataTable = svc.GetDataTable(Sql, param); if (dataTable != null && dataTable.Rows.Count > 0) { p_objReportObject = new clsReportObject(); p_objReportObject.strApplicationID = p_strApplicationID; p_objReportObject.bytReportObjectArr = (dataTable.Rows[0]["REPORT_OBJECT_LOB"] as byte[]); result = 1; } return(result); }
public void m_mthGetPrintContentFromDB(string reportGroupID, string applicationId, bool blnConfirmed) { try { clsPrintValuePara clsPrintValuePara = null; clsReportObject clsReportObject = null; lisprintBiz biz = new lisprintBiz(); long num = biz.m_lngGetReportObject(null, applicationId, out clsReportObject); if (clsReportObject != null && clsReportObject.bytReportObjectArr != null) { Stream stream = new MemoryStream(clsReportObject.bytReportObjectArr); IFormatter formatter = new BinaryFormatter(); clsPrintValuePara = (formatter.Deserialize(stream) as clsPrintValuePara); stream.Close(); } if (clsPrintValuePara == null) { biz.m_lngGetReportPrintInfo(reportGroupID, applicationId, blnConfirmed, out clsPrintValuePara); } if (clsPrintValuePara != null) { this.m_strReportGroupID = reportGroupID; this.m_ObjPrintInfo = clsPrintValuePara; } } catch (Exception ex) { //new clsLogText().LogError(ex.Message); ExceptionLog.OutPutException("m_mthGetPrintContentFromDB-->" + ex); } }
public long m_lngUpdateReportObject(System.Security.Principal.IPrincipal p_objPrincipal, clsReportObject p_objReportObject) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsReportSvc", "m_lngUpdateReportObject"); if (lngRes < 0) { return(-1); } string strSQL = @"UPDATE t_opr_lis_report_object SET report_object_lob = ? WHERE application_id_chr = ?" ; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPSvc.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].Value = p_objReportObject.bytReportObjectArr; objDPArr[1].Value = p_objReportObject.strApplicationID; lngRes = 0; long lngEff = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); return(lngRes); }
/// <summary> /// 初始化报告信息查询条件 /// </summary> /// <param name="reportGroupID">报告组ID</param> /// <param name="applicationId">申请单ID</param> /// <param name="blnConfirmed">是否审核</param> public void m_mthGetPrintContentFromDB(string reportGroupID, string applicationId, bool blnConfirmed) { try { long lngRes = 0; clsPrintValuePara objPrintInfo = null; clsReportObject objReportObject = null; clsDomainController_ApplicationManage objAppDomain = new clsDomainController_ApplicationManage(); lngRes = objAppDomain.m_lngGetReportObject(applicationId, out objReportObject); if (objReportObject != null && objReportObject.bytReportObjectArr != null) { System.IO.Stream stream = new System.IO.MemoryStream(objReportObject.bytReportObjectArr); System.Runtime.Serialization.IFormatter formater = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); objPrintInfo = formater.Deserialize(stream) as clsPrintValuePara; stream.Close(); } if (objPrintInfo == null) { clsDomainController_CheckResultManage objDomain = new clsDomainController_CheckResultManage(); lngRes = 0; lngRes = objDomain.m_lngGetReportPrintInfo(reportGroupID, applicationId, blnConfirmed, out objPrintInfo); } if (objPrintInfo != null) { m_strReportGroupID = reportGroupID; this.m_ObjPrintInfo = objPrintInfo; } } catch (Exception ex) { new clsLogText().LogError(ex.Message); } }
public long m_lngGetReportObject(IPrincipal p_objPrincipal, string p_strApplicationID, out clsReportObject p_objReportObject) { long lngRes = 0; p_objReportObject = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsReportSvc", "m_lngGetReportObject"); if (lngRes < 0) { return(-1); } string strSQL = @"select * from t_opr_lis_report_object where application_id_chr = ?" ; clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strApplicationID; DataTable dtbResult = new DataTable(); lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); if (lngRes > 0 && dtbResult != null) { p_objReportObject = new clsReportObject(); p_objReportObject.strApplicationID = p_strApplicationID; p_objReportObject.bytReportObjectArr = dtbResult.Rows[0]["REPORT_OBJECT_LOB"] as byte[]; } return(lngRes); }