public void setActiveAll(bool active, bool eccflag, string aliasName) { string sql = "UPDATE DbCostCenter SET Active = ? from DbCompany "; if (eccflag) { sql += " inner join DbSapInstance on DbCompany.SAPCode = DbSapInstance.Code "; } sql += " where DbCostCenter.CompanyID = DbCompany.CompanyID and DbCompany.UseEcc = ? "; if (eccflag) { sql += " and DbSapInstance.AliasName = ? "; } ISQLQuery query = GetCurrentSession().CreateSQLQuery(sql); query.SetBoolean(0, active); query.SetBoolean(1, eccflag); if (eccflag) { query.SetString(2, aliasName); } query.AddScalar("count", NHibernateUtil.Int32).UniqueResult(); }