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();
}
