public DataSet GetReportObject(MenuOption report, IList<String> rpParams, Location location)
{
//obtine el extension de ese menu.
MenuOptionExtension moe;
try
{
moe = Factory.DaoMenuOptionExtension().Select(new MenuOptionExtension { MenuOption = report }).First();
}
catch
{
throw new Exception("No query extension defined for this report.");
}
string selectQuery = moe.Custom1;
selectQuery= selectQuery.Replace("__LOCATION", location.LocationID.ToString());
String[] colList = moe.Custom2.Split(',');
IList<Object[]> list = Factory.DaoMenuOptionExtension().GetReportObject(selectQuery, rpParams);
if (list == null || list.Count == 0)
return null;
DataTable dt = GetDataTableSchema(colList, "dt0", list);
DataSet ds = new DataSet("dsResult");
ds.Tables.Add(dt);
return ds;
}
public IList<MenuOption> Select(MenuOption data)
{
IList<MenuOption> datos = new List<MenuOption>();
datos = GetHsql(data).List<MenuOption>();
if (!Factory.IsTransactional)
Factory.Commit();
return datos;
}
public void DeleteMenuOption(MenuOption data) { Factory.DaoMenuOption().Delete(data); }
public void UpdateMenuOption(MenuOption data) { Factory.DaoMenuOption().Update(data); }
public MenuOption SaveMenuOption(MenuOption data) { return Factory.DaoMenuOption().Save(data); }
public IList<MenuOption> GetMenuOption(MenuOption data) { return Factory.DaoMenuOption().Select(data); }
public DataSet GetReportObject(MenuOption option, IList<String> rpParams, Location location)
{
return RptMngr.GetReportObject(option, rpParams, location);
}
public MenuOption SelectById(MenuOption data)
{
return (MenuOption)base.SelectById(data);
}
public Boolean Delete(MenuOption data)
{
return base.Delete(data);
}
public Boolean Update(MenuOption data)
{
return base.Update(data);
}
public MenuOption Save(MenuOption data)
{
return (MenuOption)base.Save(data);
}