public static IList <BimProject> listProjects(Session paramSession)
{
string str = "\tSELECT ID, NAME FROM BC_PROJECT WHERE DELETED = 0 or DELETED is null";
System.Collections.IList list = paramSession.createSQLQuery(str).list();
List <object> arrayList = new List <object>();
list.ForEach(paramArrayOfObject =>
{
Number number = (Number)paramArrayOfObject[0];
string str = (string)paramArrayOfObject[1];
BimProject bimProject = new BimProject();
bimProject.Id = Convert.ToInt64(number.longValue());
bimProject.Name = str;
paramList.add(bimProject);
});
return(arrayList);
}
public static IDictionary <long, string> getModelsReferedInProject(UIProgress paramUIProgress, Session paramSession, long?paramLong)
{
Session session = DatabaseDBUtil.currentSession();
SQLQuery sQLQuery1 = paramSession.createSQLQuery("SELECT DISTINCT DBNAME from CNDON where PRJID = :id and TAKEOFFTYPE = :type");
sQLQuery1.setLong("id", paramLong.Value);
sQLQuery1.setString("type", "BIM");
System.Collections.IList list1 = sQLQuery1.list();
List <object> arrayList = new List <object>();
list1.ForEach(paramString =>
{
try
{
paramList.add(Convert.ToInt64(long.Parse(paramString)));
}
catch (Exception throwable)
{
logger.error(throwable);
}
});
SQLQuery sQLQuery2 = session.createSQLQuery("select BC_MODEL.ID, BC_MODEL.NAME, BC_MODEL.REV, BC_MODEL.APPNAME, SUM(LEN(BC_GEOMFILE.FDATA)) as SIZE from BC_MODEL JOIN BC_GEOMFILE ON BC_GEOMFILE.MODEL_ID = BC_MODEL.ID where BC_MODEL.ID in (:ids) group by BC_MODEL.ID, BC_MODEL.NAME, BC_MODEL.REV, BC_MODEL.APPNAME");
sQLQuery2.setParameterList("ids", arrayList);
System.Collections.IList list2 = sQLQuery2.list();
Hashtable hashMap = new Hashtable(list2.Count);
list2.ForEach(paramArrayOfObject =>
{
long?long = Convert.ToInt64(((Number)paramArrayOfObject[0]).longValue());
string str1 = (string)paramArrayOfObject[1];
string str2 = (string)paramArrayOfObject[2];
string str3 = (string)paramArrayOfObject[3];
Number number = (Number)paramArrayOfObject[4];
double d = number.doubleValue() / 1048576.0D;
paramMap.put(long, string.Format("{0} {1:F2} MB", new object[] { str1, Convert.ToDouble(d) }));
});
return(hashMap);
}
