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