private void AddSampleGroup(ref List <clsT_OPR_LIS_APP_SAMPLE_VO> lstSamples, string unitId)
{
ApplyUnitDetail detail = m_dicApplyUnitDetail[unitId];
clsSampleGroup_VO sampleGroup = detail.SampleGroup;
string sampleGroupId = sampleGroup.strSampleGroupID;
clsT_OPR_LIS_APP_SAMPLE_VO sampleGroupVO = new clsT_OPR_LIS_APP_SAMPLE_VO();
sampleGroupVO.m_strSAMPLE_GROUP_ID_CHR = sampleGroupId;
bool isExist = false;
foreach (clsT_OPR_LIS_APP_SAMPLE_VO sample in lstSamples)
{
if (sample.m_strSAMPLE_GROUP_ID_CHR == sampleGroupId)
{
isExist = true;
break;
}
}
if (!isExist)
{
sampleGroupVO.m_strREPORT_GROUP_ID_CHR = detail.ReportGroup.strReportGroupID;
lstSamples.Add(sampleGroupVO);
}
}
public ApplyUnitDetail(string unitId, clsApplUnit_VO applyUnit, clsSampleGroup_VO sampleGroup, clsReportGroup_VO reportGroup, clsCheckItem_VO[] items)
{
this.unitId = unitId;
this.applyUnit = applyUnit;
this.sampleGroup = sampleGroup;
this.reportGroup = reportGroup;
this.items = items;
}
public long m_lngGetSampleGoupVOByApplyUnitID(System.Security.Principal.IPrincipal p_objPrincipal, string p_strApplyUnitID, out clsSampleGroup_VO p_objSampleGroupVO)
{
long lngRes = 0;
p_objSampleGroupVO = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc", "m_lngGetSampleGoupVOByApplyUnitID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"select t1.sample_group_id_chr,
t1.py_code_chr,
t1.wb_code_chr,
t1.assist_code01_chr,
t1.assist_code02_chr,
t1.is_hand_work_int,
t1.device_model_id_chr,
t1.remark_vchr,
t1.check_category_id_chr,
t1.sample_group_name_chr,
t1.print_title_vchr,
t1.print_seq_int,
t3.sample_type_id_chr
from t_aid_lis_sample_group t1,
t_aid_lis_sample_group_unit t2,
t_aid_lis_group_sample_type t3
where t1.sample_group_id_chr = t2.sample_group_id_chr
and t1.sample_group_id_chr = t3.sample_group_id_chr(+)
and t2.apply_unit_id_chr ='" + p_strApplyUnitID + "'";
DataTable dtbRet = null;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbRet);
objHRPSvc.Dispose();
if (lngRes > 0 && dtbRet != null)
{
if (dtbRet.Rows.Count > 0)
{
p_objSampleGroupVO = new clsSampleGroup_VO();
ConstructSampleGroupVO(dtbRet.Rows[0], ref p_objSampleGroupVO);
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
}
return(lngRes);
}
public long m_lngAddSampleGroup(ref clsSampleGroup_VO objSampleGroupVO, ref clsSampleGroupDetail_VO[] objSampleGroupDetailVOList)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc objCheckGroupSvc =
(com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(
typeof(com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc));
lngRes = objCheckGroupSvc.m_lngAddSampleGroupAndDetail(objPrincipal, ref objSampleGroupVO, ref objSampleGroupDetailVOList);
objCheckGroupSvc.Dispose();
return(lngRes);
}
public long m_lngGetSampleGroupVOBySampleGroupID(string p_strSampleGroupID, out clsSampleGroup_VO p_objSampleGroupVO)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.LIS.clsQuerySampleGroupSvc objSampleGroupSvc =
(com.digitalwave.iCare.middletier.LIS.clsQuerySampleGroupSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(
typeof(com.digitalwave.iCare.middletier.LIS.clsQuerySampleGroupSvc));
lngRes = objSampleGroupSvc.m_lngGetSampleGroupVOBySampleGroupID(objPrincipal, p_strSampleGroupID, out p_objSampleGroupVO);
// objSampleGroupSvc.Dispose();
return(lngRes);
}
public long m_lngAddSampleGroup(ref clsSampleGroup_VO p_objSampleGroupVO, ref clsLisSampleGroupUnit_VO[] p_objSampleGroupUnitList,
clsApplUnitDetail_VO[] p_objApplUnitArr, ArrayList p_arlAdd, ArrayList p_arlRemove,
ArrayList p_arlAddSampleType, ArrayList p_arlRemoveSampleType)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc objSampleGroupSvc =
(com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(
typeof(com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc));
lngRes = objSampleGroupSvc.m_lngAddSampleGroupAndDetail(objPrincipal, ref p_objSampleGroupVO, ref p_objSampleGroupUnitList, p_objApplUnitArr
, p_arlAdd, p_arlRemove, p_arlAddSampleType, p_arlRemoveSampleType);
// objSampleGroupSvc.Dispose();
return(lngRes);
}
/// <summary>
/// 根据检验项目ID获得标本组的VO
/// </summary>
/// <param name="applyUnitId"></param>
/// <param name="p_intPrintSeq"></param>
/// <param name="sampleGroupVO"></param>
/// <returns></returns>
public long m_lngGetSampleGoupVO(string applyUnitId, out clsSampleGroup_VO sampleGroupVO)
{
long lngRes = 0;
sampleGroupVO = null;
try
{
lngRes = objSvc.m_lngGetSampleGoupVOByApplyUnitID(objPrincipal, applyUnitId, out sampleGroupVO);
}
catch
{
lngRes = 0;
}
return(lngRes);
}
public long m_lngGetReportGroupDetail(System.Security.Principal.IPrincipal p_objPrincipal, string strReportGroupID, ref clsSampleGroup_VO[] objSampleGroupList)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc", "m_lngGetAllReportGroupDetail");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT t2.*
FROM t_aid_lis_report_group_detail t1,
t_aid_lis_sample_group t2
WHERE t1.SAMPLE_GROUP_ID_CHR = t2.SAMPLE_GROUP_ID_CHR
AND t1.REPORT_GROUP_ID_CHR = '" + strReportGroupID + @"'
ORDER BY t1.PRINT_SEQ_INT" ;
DataTable dtbReportGroupDetail = null;
objSampleGroupList = null;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbReportGroupDetail);
objHRPSvc.Dispose();
if (lngRes > 0 && dtbReportGroupDetail != null)
{
if (dtbReportGroupDetail.Rows.Count > 0)
{
objSampleGroupList = new clsSampleGroup_VO[dtbReportGroupDetail.Rows.Count];
for (int i = 0; i < dtbReportGroupDetail.Rows.Count; i++)
{
objSampleGroupList[i] = new clsSampleGroup_VO();
ConstructSampleGroupVO(dtbReportGroupDetail.Rows[i], ref objSampleGroupList[i]);
}
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public static ApplyUnitDetail GetApplyUnitDetail(string unitId)
{
// new clsLogText().LogError(string.Format("申请单元ID为({0})!",unitId));
long lngRes = 0;
string message;
clsApplUnit_VO applyUnitVO = null;
lngRes = clsApplyUnitSmp.s_obj.m_lngGetApplyUnitVO(unitId, out applyUnitVO);
if (lngRes == 0 || applyUnitVO == null)
{
message = string.Format("申请单元ID为({0})的申请单元不存在或者为空!", unitId);
throw new LisCreateApplyException(message);
}
string unitName = applyUnitVO.strApplUnitName;
clsSampleGroup_VO sampleGroup = null;
lngRes = clsSampleGroupSmp.s_obj.m_lngGetSampleGoupVO(unitId, out sampleGroup);
if (lngRes == 0 || sampleGroup == null)
{
message = string.Format("申请单元ID为({0})({1})下的标本组不存在或者为空!", unitId, unitName);
throw new LisCreateApplyException(message);
}
clsCheckItem_VO[] items = null;
lngRes = clsCheckItemSmp.s_obj.m_lngGetCheckItem(unitId, out items);
if (lngRes == 0 || items == null)
{
message = string.Format("申请单元ID为({0})({1})下的检验项目不存在或者为空!", unitId, unitName);
throw new LisCreateApplyException(message);
}
clsReportGroup_VO reportGroup = null;
lngRes = clsReportGroupSmp.s_obj.m_lngGetReportGoupVO(sampleGroup.strSampleGroupID, out reportGroup);
if (lngRes == 0 || reportGroup == null)
{
message = string.Format("申请单元ID为({0})({1})下的报告组不存在或者为空!", unitId, unitName);
throw new LisCreateApplyException(message);
}
return(new ApplyUnitDetail(unitId, applyUnitVO, sampleGroup, reportGroup, items));
}
public long m_lngGetAllSampleGroup(System.Security.Principal.IPrincipal objPrincipal, ref clsSampleGroup_VO[] objSampleGroupVOList)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc", "m_lngGetAllSampleGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"select sample_group_id_chr, py_code_chr, wb_code_chr, assist_code01_chr,
assist_code02_chr, is_hand_work_int, device_model_id_chr,
remark_vchr, check_category_id_chr, sample_type_id_chr,
sample_group_name_chr, print_title_vchr, print_seq_int
from t_aid_lis_sample_group
order by sample_group_id_chr";
DataTable dtbSampleGroup = null;
objSampleGroupVOList = null;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbSampleGroup);
objHRPSvc.Dispose();
if (lngRes > 0 && dtbSampleGroup != null)
{
if (dtbSampleGroup.Rows.Count > 0)
{
objSampleGroupVOList = new clsSampleGroup_VO[dtbSampleGroup.Rows.Count];
for (int i = 0; i < dtbSampleGroup.Rows.Count; i++)
{
objSampleGroupVOList[i] = new clsSampleGroup_VO();
ConstructSampleGroupVO(dtbSampleGroup.Rows[i], ref objSampleGroupVOList[i]);
}
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
}
return(lngRes);
}
/// <summary>
/// 形成申请单报告组的标本组【4】
/// </summary>
/// <returns></returns>
private clsAppSampleGroupCollection m_objGenerateAppSampleGroups()
{
m_objGenerateAppUnitItems();
clsAppSampleGroupCollection objSampleGroups = new clsAppSampleGroupCollection();
foreach (clsLIS_AppApplyUnit objAppUnit in m_objAppApplyUnits)
{
// 样本组是否存在
bool blnAppSampleGroupExist = false;
clsSampleGroup_VO objSampleGroupVO = null;
long lngRes = clsSampleGroupSmp.s_obj.m_lngGetSampleGoupVO(objAppUnit.m_StrApplyUnitID, out objSampleGroupVO);
if (lngRes > 0 && objSampleGroupVO != null)
{
clsLIS_AppSampleGroup objAppSampleGroup = null;
foreach (clsLIS_AppSampleGroup obj in objSampleGroups)
{
if (obj.m_ObjSampleGroup.m_ObjDataVO.strSampleGroupID == objSampleGroupVO.strSampleGroupID)
{
objAppSampleGroup = obj;
blnAppSampleGroupExist = true;
break;
}
}
if (!blnAppSampleGroupExist)
{
clsLIS_SampleGroup objSampleGroup = new clsLIS_SampleGroup();
objSampleGroup.m_ObjDataVO = objSampleGroupVO;
clsT_OPR_LIS_APP_SAMPLE_VO objAppSampleGroupVO = new clsT_OPR_LIS_APP_SAMPLE_VO();
clsLIS_AppSampleGroup objAppSGroup = new clsLIS_AppSampleGroup(objAppSampleGroupVO);
objAppSGroup.m_ObjSampleGroup = objSampleGroup;
objAppSGroup.m_StrSampleGroupID = objSampleGroup.m_ObjDataVO.strSampleGroupID;
objSampleGroups.Add(objAppSGroup);
objAppSampleGroup = objAppSGroup;
}
System.Collections.ArrayList arlSU = new System.Collections.ArrayList();
if (objAppSampleGroup.m_ObjAppUnitArr != null)
{
arlSU.AddRange(objAppSampleGroup.m_ObjAppUnitArr);
}
arlSU.Add(objAppUnit);
objAppSampleGroup.m_ObjAppUnitArr = (clsLIS_AppApplyUnit[])arlSU.ToArray(typeof(clsLIS_AppApplyUnit));
for (int i = 0; i < objAppUnit.m_ObjItemArr.Length; i++)
{
bool blnItemExist = false;
foreach (clsLIS_AppCheckItem objAppItem in objAppSampleGroup.m_ObjAppCheckItems)
{
if (objAppItem.m_StrCheckItemID == objAppUnit.m_ObjItemArr[i].m_strCHECK_ITEM_ID_CHR)
{
blnItemExist = true;
break;
}
}
if (!blnItemExist)
{
clsT_OPR_LIS_APP_CHECK_ITEM_VO objAppItemVO = new clsT_OPR_LIS_APP_CHECK_ITEM_VO();
clsLIS_AppCheckItem objAppCheckItem = new clsLIS_AppCheckItem(objAppItemVO);
objAppCheckItem.m_StrCheckItemID = objAppUnit.m_ObjItemArr[i].m_strCHECK_ITEM_ID_CHR;
objAppCheckItem.m_StrSampleGroupID = objAppSampleGroup.m_StrSampleGroupID;
objAppSampleGroup.m_ObjAppCheckItems.Add(objAppCheckItem);
}
}
}
}
return(objSampleGroups);
}
public long m_lngSetSampleGroupPrintOrder(System.Security.Principal.IPrincipal p_objPrincipal, clsSampleGroup_VO p_objRecord)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsReportGroupSvc", "m_lngSetSampleGroupPrintOrder");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"UPDATE t_aid_lis_sample_group
SET print_seq_int = '" + p_objRecord.intPRINT_SEQ_INT + @"'
WHERE sample_group_id_chr = '" + p_objRecord.strSampleGroupID + @"'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx); //要在LogError方法中抛出异常。
}
return(lngRes);
}
