public long m_lngFind(string applicationId, out clsChargeStatusVO chargeStatusVO) { long lngRes = 0; DataTable dt = null; chargeStatusVO = null; string strSQL = @"select * from t_opr_attachrelation where attachid_vchr=? "; try { clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = applicationId; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dt, objDPArr); if (lngRes > 0 && dt != null && dt.Rows.Count != 0) { chargeStatusVO = ConstructVO(dt.Rows[0]); } objHRPSvc.Dispose(); } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
/// <summary> /// 构造VO /// </summary> /// <param name="dtRow"></param> /// <returns></returns> public clsChargeStatusVO ConstructVO(DataRow dtRow) { clsChargeStatusVO obj = new clsChargeStatusVO(); obj.m_strSeq = dtRow["ATTARELAID_CHR"].ToString(); obj.m_strSourceItemId = dtRow["SOURCEITEMID_VCHR"].ToString(); obj.m_strApplicationId = dtRow["ATTACHID_VCHR"].ToString(); obj.m_intType = DBAssist.ToInt32(dtRow["ATTACHTYPE_INT"]); obj.m_intModuleId = DBAssist.ToInt32(dtRow["SYSFROM_INT"]); obj.m_blnUrgency = DBAssist.ToInt32(dtRow["URGENCY_INT"]) == 1 ? true : false; obj.m_intChargeStatus = DBAssist.ToInt32(dtRow["STATUS_INT"]); return(obj); }
/// <summary> /// 根据申请单元Id获取收费信息 /// </summary> /// <param name="applicationId"></param> /// <param name="chargeStatusVO"></param> /// <returns></returns> public long m_lngFind(string applicationId, out clsChargeStatusVO chargeStatusVO) { long lngRes = 0; chargeStatusVO = null; try { lngRes = objSvc.m_lngFind(applicationId, out chargeStatusVO); } catch { lngRes = 0; } return(lngRes); }
/// <summary> /// 获取收费状态 /// </summary> /// <param name="applicationId"></param> /// <returns></returns> private bool IsPay(string applicationId) { clsChargeStatusVO chargeStatusVO = null; clsChargeInfoStatusSmp.s_obj.m_lngFind(applicationId, out chargeStatusVO); if (chargeStatusVO == null) { return(false); } if (chargeStatusVO.m_intChargeStatus == 1) { return(true); } return(false); }