/// <summary> /// 验证用户名是否存在 /// </summary> /// <param name="username"></param> /// <param name="id"></param> /// <returns></returns> public bool CheckIsExist(string code, Int32?id) { List <object> _listParam = new List <object>(); String _sql = " and name=?"; _listParam.Add(code); if (id != null) { _sql += " and id<>?"; _listParam.Add(id); } int count = ClinicarItemDao.FindCountByHql(_sql, _listParam.ToArray()); return(count > 0 ? true : false); }
/// <summary> /// 验证设备编号是否存在 /// </summary> /// <param name="username"></param> /// <param name="id"></param> /// <returns></returns> public bool CheckIsExistForDeviceCode(string deviceCode, string code) { List <object> _listParam = new List <object>(); String whereSql = " and device_code =? and enabled = 1 "; _listParam.Add(deviceCode); if (!string.IsNullOrWhiteSpace(code)) { whereSql += " and code <> ?"; _listParam.Add(code); } int count = ClinicarItemDao.FindCountByHql(whereSql, _listParam.ToArray()); return(count > 0 ? true : false); }