| | |
| | | //杩囨护鏉′欢 |
| | | 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 "; |
| | | } |
| | | // |
| | | DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); |