Пример #1
0
        /// <summary>
        ///     服务可录入范围
        /// </summary>
        /// <param name="idorg"></param>
        /// <param name="iddep"></param>
        /// <returns></returns>
        public void getdepSrvInfo(string idorg, string iddep)
        {
            srvScopeSql = qryservice.getCiSrvCondition(iddep, ICiOrdNSysParamConst.SYS_PARAM_OrChkSrvScope4MakeupFee);
            if (srvScopeSql == null)
            {
                srvScopeSql = qryservice.getCiSrvCondition(idorg, ICiOrdNSysParamConst.SYS_PARAM_OrChkSrvScope4MakeupFee);
            }
            string srvsql = "select id_srv from bd_srv where bd_srv.id_org='" + idorg +
                            "'and  BD_SRV.Fg_Use_Ip='Y' and BD_SRV . fg_active ='Y'  and BD_SRV .fg_set ='N' and BD_SRV.fg_bl='Y'  and " +
                            srvScopeSql;

            srvScope = qryservice.getSrvScope(srvsql);
        }