| | |
| | | //è¿æ»¤æ¡ä»¶ |
| | | if (frmCondition.SqlStr.Trim().Length == 0) |
| | | { |
| | | sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " order by åæ®å· desc,hsubid "; |
| | | sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + " order by åæ®å· desc,hsubid "; |
| | | } |
| | | else |
| | | { |
| | | sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " order by åæ®å· desc,hsubid "; |
| | | sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + " order by åæ®å· desc,hsubid "; |
| | | } |
| | | |
| | | // |