Exemplo n.º 1
0
        public long lngOnlyGetSendWindowInfo(System.Security.Principal.IPrincipal p_objPrincipal, string m_strMedStoreid, out clsMedStoreWindowsVo m_objWindowsVo, bool m_blnWindowType)
        {
            m_objWindowsVo = null;
            long lngRegs = 0;
            //权限类
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            //检查是否有使用些函数的权限
            lngRegs = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsWindowsCortrol", "lngGetSendWindowInfoByWindowid");
            if (lngRegs < 0) //没有使用的权限
            {
                return(-1);
            }
            string strSQL = "";

            com.digitalwave.iCare.middletier.HIS.clsGetServerDate objDate = new clsGetServerDate();
            string strDateTime = objDate.m_GetServerDate().ToString("yyyy-MM-dd");

            try
            {
                com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
                System.Data.DataTable        p_dtWindow = new System.Data.DataTable();
                System.Data.IDataParameter[] paramArr   = null;
                strSQL = @"select  a.windowid_chr, a.windowname_vchr, a.medstoreid_chr, 0 as windowflag_int,
                                   sum(decode(c.sid_int, null, 0, 1)) as numcount, d.lastdate
                              from t_bse_medstorewin a,
                                   (select b.sid_int, b.sendwindowid_chr
                                       from t_opr_recipesend b
                                      where b.createdate_chr = ?
                                        and b.medstoreid_chr = ?
                                        and b.called_int = 0
                                        and b.pstatus_int in (1, 2)) c,
                                   (select max(b.senddate_dat) as lastdate, b.sendwindowid_chr
                                       from t_opr_recipesend b
                                      where b.createdate_chr = ?
                                        and b.medstoreid_chr = ?
                                        and b.pstatus_int = 3
                                      group by b.sendwindowid_chr) d
                             where a.windowid_chr = c.sendwindowid_chr(+)
                               and a.windowid_chr = d.sendwindowid_chr(+)
                               and a.medstoreid_chr = ?
                               and a.windowtype_int = 0
                               and a.workstatus_int = 1
                             group by a.windowid_chr, a.windowname_vchr, a.medstoreid_chr,
                                      d.lastdate";

                objHRPSvc.CreateDatabaseParameter(5, out paramArr);
                paramArr[0].Value = strDateTime;
                paramArr[1].Value = m_strMedStoreid;
                paramArr[2].Value = strDateTime;
                paramArr[3].Value = m_strMedStoreid;
                paramArr[4].Value = m_strMedStoreid;
                lngRegs           = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtWindow, paramArr);

                if (lngRegs > 0 && p_dtWindow.Rows.Count > 0)
                {
                    if (m_blnWindowType == true)
                    {
                        p_dtWindow.DefaultView.Sort = "windowflag_int desc,numcount, lastdate";
                    }
                    else
                    {
                        p_dtWindow.DefaultView.Sort = " windowflag_int,numcount, lastdate";
                    }
                    p_dtWindow = p_dtWindow.DefaultView.ToTable();
                    DataRow drTemp = p_dtWindow.Rows[0];
                    if (m_objWindowsVo == null)
                    {
                        m_objWindowsVo = new clsMedStoreWindowsVo();
                    }
                    m_objWindowsVo.m_strSendWindowID      = drTemp["windowid_chr"].ToString();
                    m_objWindowsVo.m_strSendWindowName    = drTemp["windowname_vchr"].ToString();
                    m_objWindowsVo.m_intSendWindowOrderNo = int.Parse(drTemp["numcount"].ToString()) + 1;
                    p_dtWindow.Dispose();
                    p_dtWindow = null;
                    drTemp     = null;
                }
                else
                {
                    m_objWindowsVo = null;
                }
            }
            catch (Exception objEx)
            {
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
            }
            return(lngRegs);
        }
Exemplo n.º 2
0
        public long lngGetWindowIDByStorage(System.Security.Principal.IPrincipal p_objPrincipal, string storageID, out clsMedStoreWindowsVo m_objWindowsVo, bool CheckScope, bool m_blnWindowType, bool m_blnWindowRelation)
        {
            m_objWindowsVo = null;
            long lngRegs = 0;
            //权限类
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            //检查是否有使用些函数的权限
            lngRegs = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsWindowsCortrol", "lngGetWindowIDByStorage");
            if (lngRegs < 0) //没有使用的权限
            {
                return(-1);
            }
            string strSQL = "";

            if (CheckScope)
            {
                strSQL = @"select  a.windowid_chr, a.windowname_vchr, a.medstoreid_chr, 0 as windowflag_int,
                                   sum(decode(c.sid_int, null, 0, 1)) as numcount
                              from t_bse_medstorewin a,
                                   (select b.sid_int, b.windowid_chr
                                       from t_opr_recipesend b
                                      where b.pstatus_int = 1
                                        and b.medstoreid_chr = ?
                                        and b.createdate_chr = ?) c
                             where a.windowid_chr = c.windowid_chr(+)
                               and a.medstoreid_chr = ?
                               and a.windowtype_int = 1
                               and a.workstatus_int = 1
                             group by a.windowid_chr, a.windowname_vchr, a.medstoreid_chr";
            }
            else
            {
                strSQL = @"select  a.windowid_chr, a.windowname_vchr, a.medstoreid_chr, 0 as windowflag_int,
                                   sum(decode(c.sid_int, null, 0, 1)) as numcount
                              from t_bse_medstorewin a,
                                   (select b.sid_int, b.windowid_chr
                                       from t_opr_recipesend b
                                      where b.pstatus_int = 1
                                        and b.medstoreid_chr = ?
                                        and b.createdate_chr = ?) c
                             where a.windowid_chr = c.windowid_chr(+)
                               and a.medstoreid_chr = ?
                               and a.windowtype_int = 1
                               and a.winproperty_int = 0
                               and a.workstatus_int = 1
                             group by a.windowid_chr, a.windowname_vchr, a.medstoreid_chr";
            }
            com.digitalwave.iCare.middletier.HIS.clsGetServerDate objDate = new clsGetServerDate();
            string strDateTime = objDate.m_GetServerDate().ToString("yyyy-MM-dd");

            try
            {
                com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
                System.Data.DataTable p_dtWindow = new System.Data.DataTable();

                System.Data.IDataParameter[] paramArr = null;
                objHRPSvc.CreateDatabaseParameter(3, out paramArr);
                paramArr[0].Value = storageID;
                paramArr[1].Value = strDateTime;
                paramArr[2].Value = storageID;
                //获取当前药房所有配药窗口的配药队列
                lngRegs = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtWindow, paramArr);


                if (lngRegs > 0 && p_dtWindow.Rows.Count > 0)
                {
                    DataView dv = p_dtWindow.DefaultView;
                    if (m_blnWindowType == true)                   //对获取的表进行排序,
                    {
                        dv.Sort = " windowflag_int desc,numcount"; //将草药窗口而且队列最少的窗口排在前面
                    }
                    else
                    {
                        dv.Sort = "windowflag_int ,numcount";//将成药窗口而且队列最少的窗口排在前面
                    }
                    p_dtWindow = dv.ToTable();
                    int     m_intCount = p_dtWindow.Rows.Count;
                    DataRow dtRowTemp  = null;
                    for (int i = 0; i < m_intCount; i++)
                    {
                        dtRowTemp      = p_dtWindow.Rows[i];
                        m_objWindowsVo = new clsMedStoreWindowsVo();
                        m_objWindowsVo.m_strWindowID      = dtRowTemp["WINDOWID_CHR"].ToString();
                        m_objWindowsVo.m_strWindowName    = dtRowTemp["windowname_vchr"].ToString();
                        m_objWindowsVo.m_intWindowOrderNo = int.Parse(dtRowTemp["numcount"].ToString()) + 1;
                        if (m_blnWindowRelation == true)
                        {
                            this.lngGetSendWindowInfoByWindowid(p_objPrincipal, storageID, m_objWindowsVo.m_strWindowID, ref m_objWindowsVo);
                        }
                        else
                        {
                            this.lngGetSendWindowInfo(p_objPrincipal, storageID, CheckScope, ref m_objWindowsVo, m_blnWindowType);
                        }
                        if (m_objWindowsVo != null)//成功取到发药窗口信息
                        {
                            break;
                        }
                    }
                    dv = null;
                    p_dtWindow.Dispose();
                    p_dtWindow = null;
                    dtRowTemp  = null;
                }
                else
                {
                    m_objWindowsVo = null;//返回null到收费界面,作为取不到任何配药窗口信息的标识,请药房人员配好药房窗口设置;
                }
            }
            catch (Exception objEx)
            {
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
            }
            return(lngRegs);
        }
Exemplo n.º 3
0
        public long m_lngGetWorkStorage(System.Security.Principal.IPrincipal p_objPrincipal, string strOldStorageID, out string strNewStorageID)
        {
            long lngRes = 0;

            strNewStorageID = "";
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngAddNew");
            if (lngRes < 0)
            {
                return(-1);
            }
            com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
            if (lngRes < 0)
            {
                return(lngRes);
            }
            com.digitalwave.iCare.middletier.HIS.clsGetServerDate objDate = new clsGetServerDate();
            string           strDateTime   = objDate.m_GetServerDate().ToString("yyyy-MM-dd HH:mm:ss");
            int              weekDay_int   = 0;//星期几 (1-周一\7-周日)
            clsGetServerDate getServerDate = new clsGetServerDate();

            switch (getServerDate.m_GetServerDate().DayOfWeek.ToString())
            {
            case "Monday":
                weekDay_int = 1;
                break;

            case "Tuesday":
                weekDay_int = 2;
                break;

            case "Wednesday":
                weekDay_int = 3;
                break;

            case "Thursday":
                weekDay_int = 4;
                break;

            case "Friday":
                weekDay_int = 5;
                break;

            case "Saturday":
                weekDay_int = 6;
                break;

            case "Sunday":
                weekDay_int = 7;
                break;
            }

            string    strSQL = @"SELECT   a.*
                              FROM t_bse_deptduty a
                              WHERE a.deptid_vchr =? and a.WEEKDAY_INT=?";
            DataTable dtDuty = new DataTable();

            try
            {
                System.Data.IDataParameter[] paramArr = null;
                objHRPSvc.CreateDatabaseParameter(2, out paramArr);
                paramArr[0].Value = strOldStorageID;
                paramArr[1].Value = weekDay_int;

                lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtDuty, paramArr);
            }
            catch
            {
            }
            DateTime _serverDate = getServerDate.m_GetServerDate();

            if (dtDuty.Rows.Count > 0)
            {
                if (dtDuty.Rows[0]["WORKTIME_VCHR"] != System.DBNull.Value && dtDuty.Rows[0]["WORKTIME_VCHR"].ToString() != "")
                {
                    string   _split = "|";
                    string[] objstr = dtDuty.Rows[0]["WORKTIME_VCHR"].ToString().Split(_split.ToCharArray());
                    for (int f2 = 0; f2 < objstr.Length; f2++)
                    {
                        _split = "-";
                        string[] objstr1 = objstr[f2].Split(_split.ToCharArray());
                        if (objstr1.Length == 2)
                        {
                            string date1 = _serverDate.Date.ToString("yyyy-MM-dd") + " " + objstr1[0];
                            string date2 = _serverDate.Date.ToString("yyyy-MM-dd") + " " + objstr1[1];
                            if (_serverDate >= DateTime.Parse(date1) && _serverDate <= DateTime.Parse(date2))
                            {
                                strNewStorageID = strOldStorageID;
                                return(1);
                            }
                        }
                    }
                }
            }
            else
            {
                strNewStorageID = strOldStorageID;
                return(1);
            }
            strNewStorageID = dtDuty.Rows[0]["OBJECTDEPTID_VCHR"].ToString();
            return(lngRes);
        }
Exemplo n.º 4
0
        public long m_lngGetGiveWindID(System.Security.Principal.IPrincipal p_objPrincipal, string TreatwinID, out string windowsID, out int WaitNO)
        {
            long lngRegs = 0;

            windowsID = "";
            WaitNO    = 1;
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRegs = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngAddNew");
            if (lngRegs < 0)
            {
                return(-1);
            }
            if (lngRegs < 0)
            {
                return(lngRegs);
            }
            com.digitalwave.iCare.middletier.HIS.clsGetServerDate objDate = new clsGetServerDate();
            string strDateTime = objDate.m_GetServerDate().ToString("yyyyMMdd");
            string strSQL      = @"SELECT a.givewinid_chr,
       CASE
          WHEN b.intcount IS NULL
             THEN 0
          ELSE b.intcount
       END AS intcount
  FROM (SELECT t1.*
  FROM (SELECT   MIN (order_int) AS df, a.givewinid_chr
            FROM t_opr_medstorewinrlt a, t_bse_medstorewin b
           WHERE a.treatwinid_chr =?
             AND a.givewinid_chr = b.windowid_chr
             AND b.workstatus_int = 1
        GROUP BY givewinid_chr) t1,
       (SELECT   MIN (order_int) AS df
            FROM t_opr_medstorewinrlt a, t_bse_medstorewin b
           WHERE a.treatwinid_chr = ?
             AND a.givewinid_chr = b.windowid_chr
             AND b.workstatus_int = 1
        GROUP BY treatwinid_chr) t2
        where t1.df =t2.df) a,
 (SELECT   max(ORDER_INT) AS intcount, windowid_chr
            FROM t_opr_medstorewinque where OUTPATRECIPEID_CHR like ?
        GROUP BY windowid_chr) b
 WHERE a.givewinid_chr = b.windowid_chr(+)";

            try
            {
                com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
                System.Data.DataTable p_dtWindow = new System.Data.DataTable();

                System.Data.IDataParameter[] paramArr = null;
                objHRPSvc.CreateDatabaseParameter(3, out paramArr);
                paramArr[0].Value = TreatwinID;
                paramArr[1].Value = TreatwinID;
                paramArr[2].Value = strDateTime + "%";
                lngRegs           = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtWindow, paramArr);
                if (p_dtWindow.Rows.Count > 0)
                {
                    windowsID = p_dtWindow.Rows[0]["GIVEWINID_CHR"].ToString();
                    WaitNO    = int.Parse(p_dtWindow.Rows[0]["intcount"].ToString()) + 1;
                }
            }
            catch (Exception objEx)
            {
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
            }
            return(lngRegs);
        }
Exemplo n.º 5
0
        public long lngGetWindowIDByStorage(System.Security.Principal.IPrincipal p_objPrincipal, string storageID, out string windowsID, out int WaiteNO, bool CheckScope)
        {
//            windowsID = "";
//            WaiteNO = 1;
//            long lngRegs = 0;
//            //权限类
//            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//            //检查是否有使用些函数的权限
//            lngRegs = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReckoningReport", "lngGetWindowIDByStorage");
//            if (lngRegs < 0) //没有使用的权限
//            {
//                return -1;
//            }
//            string strSQL = "";
//            if (CheckScope)
//            {
//                strSQL = @"select   a.windowid_chr, a.medstoreid_chr,
//         decode (k.intcount, null, 0, k.intcount) as intcount1,
//         decode (k.intcount3, null, 0, k.intcount3) as intcount4
//    from t_bse_medstorewin a,
//         (select intcount, intcount3, b.windowid_chr, b.medstoreid_chr
//            from (select   max (order_int) as intcount, windowid_chr,
//                           medstoreid_chr
//                      from t_opr_medstorewinque
//                     where medstoreid_chr = ?
//                       and windowtype_int = 1
//                       and outpatrecipeid_chr like ?
//                  group by medstoreid_chr, windowid_chr) b,
//                 (select   count (order_int) as intcount3, windowid_chr,
//                           medstoreid_chr
//                      from t_opr_medstorewinque
//                     where medstoreid_chr = ?
//                       and windowtype_int = 1
//                       and outpatrecipeid_chr like ?
//                  group by medstoreid_chr, windowid_chr) c
//           where b.medstoreid_chr = c.medstoreid_chr
//             and b.windowid_chr = c.windowid_chr) k
//   where a.medstoreid_chr = ?
//     and a.windowtype_int = 1
//     and a.workstatus_int = 1
//     and a.medstoreid_chr = k.medstoreid_chr(+)
//     and a.windowid_chr = k.windowid_chr(+)
//order by intcount4
//";
//            }
//            else
//            {
//                strSQL = @"select   a.windowid_chr, a.medstoreid_chr,
//         decode (k.intcount, null, 0, k.intcount) as intcount1,
//          decode (k.intcount3, null, 0, k.intcount3) as intcount4
//    from t_bse_medstorewin a,
//         (select intcount, intcount3, b.windowid_chr, b.medstoreid_chr
//            from (select   max (order_int) as intcount, windowid_chr,
//                           medstoreid_chr
//                      from t_opr_medstorewinque
//                     where medstoreid_chr = ?
//                       and windowtype_int = 1
//                       and outpatrecipeid_chr like ?
//                  group by medstoreid_chr, windowid_chr) b,
//                 (select   count (order_int) as intcount3, windowid_chr,
//                           medstoreid_chr
//                      from t_opr_medstorewinque
//                     where medstoreid_chr = ?
//                       and windowtype_int = 1
//                       and outpatrecipeid_chr like ?
//                  group by medstoreid_chr, windowid_chr) c
//           where b.medstoreid_chr = c.medstoreid_chr
//             and b.windowid_chr = c.windowid_chr) k
//   where a.medstoreid_chr = ?
//     and a.winproperty_int = 0
//     and a.windowtype_int = 1
//     and a.workstatus_int = 1
//     and a.medstoreid_chr = k.medstoreid_chr(+)
//     and a.windowid_chr = k.windowid_chr(+)
//order by intcount4";
//            }
//            com.digitalwave.iCare.middletier.HIS.clsGetServerDate objDate = new clsGetServerDate();
//            string strDateTime = objDate.m_GetServerDate().ToString("yyyyMMdd");
//            try
//            {
//                com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//                System.Data.DataTable p_dtWindow = new System.Data.DataTable();

//                System.Data.IDataParameter[] paramArr = null;
//                objHRPSvc.CreateDatabaseParameter(5, out paramArr);
//                paramArr[0].Value = storageID.Trim();
//                paramArr[1].Value = strDateTime.Trim() + "%";
//                paramArr[2].Value = storageID.Trim();
//                paramArr[3].Value = strDateTime.Trim() + "%";
//                paramArr[4].Value = storageID.Trim();
//                lngRegs = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtWindow, paramArr);

//                if (p_dtWindow.Rows.Count > 0)
//                {
//                    windowsID = p_dtWindow.Rows[0]["WINDOWID_CHR"].ToString();
//                    WaiteNO = int.Parse(p_dtWindow.Rows[0]["intcount1"].ToString()) + 1;
//                }
//            }
//            catch (Exception objEx)
//            {
//                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
//                bool blnRes = objLogger.LogError(objEx);
//            }
//            return lngRegs;
            windowsID = "";
            WaiteNO   = 1;
            long lngRegs = 0;
            //权限类
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            //检查是否有使用些函数的权限
            lngRegs = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReckoningReport", "lngGetWindowIDByStorage");
            if (lngRegs < 0) //没有使用的权限
            {
                return(-1);
            }
            string strSQL = "";

            com.digitalwave.iCare.middletier.HIS.clsGetServerDate objDate = new clsGetServerDate();
            string strDateTime = objDate.m_GetServerDate().ToString("yyyyMMdd");

            if (CheckScope)
            {
                strSQL = @"select   a.windowid_chr, a.medstoreid_chr,
                     decode (k.intcount, null, 0, k.intcount) as intcount1,
                     decode (k.intcount3, null, 0, k.intcount3) as intcount4
                from t_bse_medstorewin a,
                     (select intcount, intcount3, b.windowid_chr, b.medstoreid_chr
                        from (select   max (order_int) as intcount, windowid_chr,
                                       medstoreid_chr
                                  from t_opr_medstorewinque
                                 where medstoreid_chr = '" + storageID.Trim() + @"'
                                   and windowtype_int = 1
                                   and outpatrecipeid_chr like '" + strDateTime + @"%'
                              group by medstoreid_chr, windowid_chr) b,
                             (select   count (order_int) as intcount3, windowid_chr,
                                       medstoreid_chr
                                  from t_opr_medstorewinque
                                 where medstoreid_chr = '" + storageID.Trim() + @"'
                                   and windowtype_int = 1
                                   and outpatrecipeid_chr like '" + strDateTime + @"%'
                              group by medstoreid_chr, windowid_chr) c
                       where b.medstoreid_chr = c.medstoreid_chr
                         and b.windowid_chr = c.windowid_chr) k
               where a.medstoreid_chr = '" + storageID.Trim() + @"'
                 and a.windowtype_int = 1
                 and a.workstatus_int = 1
                 and a.medstoreid_chr = k.medstoreid_chr(+)
                 and a.windowid_chr = k.windowid_chr(+)
            order by intcount4
            ";
            }
            else
            {
                strSQL = @"select   a.windowid_chr, a.medstoreid_chr,
                     decode (k.intcount, null, 0, k.intcount) as intcount1,
                      decode (k.intcount3, null, 0, k.intcount3) as intcount4
                from t_bse_medstorewin a,
                     (select intcount, intcount3, b.windowid_chr, b.medstoreid_chr
                        from (select   max (order_int) as intcount, windowid_chr,
                                       medstoreid_chr
                                  from t_opr_medstorewinque
                                 where medstoreid_chr = '" + storageID.Trim() + @"'
                                   and windowtype_int = 1
                                   and outpatrecipeid_chr like '" + strDateTime + @"%'
                              group by medstoreid_chr, windowid_chr) b,
                             (select   count (order_int) as intcount3, windowid_chr,
                                       medstoreid_chr
                                  from t_opr_medstorewinque
                                 where medstoreid_chr = '" + storageID.Trim() + @"'
                                   and windowtype_int = 1
                                   and outpatrecipeid_chr like '" + strDateTime + @"%'
                              group by medstoreid_chr, windowid_chr) c
                       where b.medstoreid_chr = c.medstoreid_chr
                         and b.windowid_chr = c.windowid_chr) k
               where a.medstoreid_chr = '" + storageID.Trim() + @"'
                 and a.winproperty_int = 0
                 and a.windowtype_int = 1
                 and a.workstatus_int = 1
                 and a.medstoreid_chr = k.medstoreid_chr(+)
                 and a.windowid_chr = k.windowid_chr(+)
            order by intcount4";
            }


            try
            {
                com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
                System.Data.DataTable p_dtWindow = new System.Data.DataTable();
                lngRegs = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtWindow);

                if (p_dtWindow.Rows.Count > 0)
                {
                    windowsID = p_dtWindow.Rows[0]["WINDOWID_CHR"].ToString();
                    WaiteNO   = int.Parse(p_dtWindow.Rows[0]["intcount1"].ToString()) + 1;
                }
            }
            catch (Exception objEx)
            {
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
            }
            return(lngRegs);
        }