public DataSet CreateHistoryTable(string[] parrCommand, int pintMaxID, out string ostrTableName) { sys_ReportHistoryDS dsHistory = new sys_ReportHistoryDS(); DataSet dstResult = dsHistory.CreateHistoryTable(parrCommand, pintMaxID, out ostrTableName); return(dstResult); }
//************************************************************************** /// <Description> /// This method not implements yet /// </Description> /// <Inputs> /// /// </Inputs> /// <Outputs> /// /// </Outputs> /// <Returns> /// /// </Returns> /// <Authors> /// DungLA /// </Authors> /// <History> /// Created: 28-Dec-2004 /// </History> /// <Notes> /// </Notes> //************************************************************************** public void Delete(object pObjectVO) { sys_ReportVO voReport = (sys_ReportVO)pObjectVO; sys_ReportAndGroupDS dsReportAndGroup = new sys_ReportAndGroupDS(); // delete data in sys_ReportAndGroup dsReportAndGroup.DeleteByReportID(voReport.ReportID); // delete data in sys_ReportDrillDown where master id is selected report id sys_ReportDrillDownDS dsDrillDown = new sys_ReportDrillDownDS(); dsDrillDown.Delete(voReport.ReportID); // delete data in sys_ReportFields sys_ReportFieldsDS dsReportFields = new sys_ReportFieldsDS(); dsReportFields.Delete(voReport.ReportID); // delete data in sys_ReportPara sys_ReportParaDS dsReportPara = new sys_ReportParaDS(); dsReportPara.Delete(voReport.ReportID); // retrieve history of this report sys_ReportHistoryVO voReportHistory = new sys_ReportHistoryVO(); sys_ReportHistoryDS dsReportHistory = new sys_ReportHistoryDS(); sys_ReportHistoryParaDS dsHistoryPara = new sys_ReportHistoryParaDS(); ArrayList arrHistory = new ArrayList(); arrHistory = dsReportHistory.ListByReport(voReport.ReportID); // delete all data in sys_ReportHistoryPara related to each history if (arrHistory.Count > 0) { for (int i = 0; i < arrHistory.Count - 1; i++) { voReportHistory = (sys_ReportHistoryVO)arrHistory[i]; dsHistoryPara.Delete(voReportHistory.HistoryID); } } // delete data in sys_ReportHistory dsReportHistory.DeleteByReportID(voReport.ReportID); // delete data in sys_Report sys_ReportDS dsReport = new sys_ReportDS(); dsReport.Delete(voReport.ReportID); }
//************************************************************************** /// <Description> /// Get last 10 executed report from history /// </Description> /// <Inputs> /// /// </Inputs> /// <Outputs> /// /// </Outputs> /// <Returns> /// /// </Returns> /// <Authors> /// DungLA /// </Authors> /// <History> /// 20-Jan-2005 /// </History> /// <Notes> /// </Notes> //************************************************************************** public ArrayList GetLast10Report(string pstrUserName) { try { sys_ReportHistoryDS dsHistory = new sys_ReportHistoryDS(); return(dsHistory.GetLast10Report(pstrUserName)); } catch (PCSException ex) { throw ex.CauseException; } catch (Exception ex) { throw ex; } }
public void DeleteHistory(object pobjHistory) { sys_ReportHistoryVO voReportHistory = (sys_ReportHistoryVO)pobjHistory; sys_ReportHistoryDS dsReportHistory = new sys_ReportHistoryDS(); sys_ReportHistoryParaDS dsReportHistoryPara = new sys_ReportHistoryParaDS(); // delete history param first dsReportHistoryPara.Delete(voReportHistory.HistoryID); // delete history object dsReportHistory.Delete(voReportHistory.HistoryID); // drop history table from databas try { dsReportHistory.DropHistoryTables(voReportHistory.HistoryID); } catch { dsReportHistory.DropHistoryTables(voReportHistory.TableName); } }
public void AddHistory(object pobjHistoryVO) { sys_ReportHistoryDS dsHistory = new sys_ReportHistoryDS(); dsHistory.Add(pobjHistoryVO); }
public void DropHistoryTables(int pintHistoryID) { sys_ReportHistoryDS dsReportHistory = new sys_ReportHistoryDS(); dsReportHistory.DropHistoryTables(pintHistoryID); }
public int GetMaxReportHistoryID() { sys_ReportHistoryDS dsHistoryPara = new sys_ReportHistoryDS(); return(dsHistoryPara.GetMaxReportHistoryID()); }
public bool PushDataTableIntoNewDatabaseTable(DataTable pdtb, string pstrDBNewTableName) { sys_ReportHistoryDS dsHistoryPara = new sys_ReportHistoryDS(); return(dsHistoryPara.PushDataTableIntoNewDatabaseTable(pdtb, pstrDBNewTableName)); }
public ArrayList GetHistoryReportByUser(string pstrUsername) { sys_ReportHistoryDS dsHistoryPara = new sys_ReportHistoryDS(); return(dsHistoryPara.GetHistoryReportByUser(pstrUsername)); }
public DataTable GetDataFromHistoryTable(string pstrHistoryTableName) { sys_ReportHistoryDS dsHistory = new sys_ReportHistoryDS(); return(dsHistory.GetDataFromHistoryTable(pstrHistoryTableName)); }