public DataSet List() { try { sys_ReportDrillDownDS templateDS = new sys_ReportDrillDownDS(); return(templateDS.List()); } catch (PCSDBException ex) { throw ex; } }
//************************************************************************** /// <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); }
public void Delete(int pintID) { try { sys_ReportDrillDownDS templateDS = new sys_ReportDrillDownDS(); templateDS.Delete(pintID); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public DataTable GetDataForTrueDBGrid(string pstrMasterID, string pstrDetailID, out bool oblnIsEdit) { try { sys_ReportDrillDownDS dsReportDrillDown = new sys_ReportDrillDownDS(); return(dsReportDrillDown.GetDataForTrueDBGrid(pstrMasterID, pstrDetailID, out oblnIsEdit)); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public void UpdateDataSet(DataSet pData) { try { sys_ReportDrillDownDS templateDS = new sys_ReportDrillDownDS(); templateDS.UpdateDataSet(pData); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public void Update(object pobjObjecVO) { try { sys_ReportDrillDownDS templateDS = new sys_ReportDrillDownDS(); templateDS.Update(pobjObjecVO); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public DataSet GetObjectVO(string pstrMasterID, string pstrDetailID) { try { sys_ReportDrillDownDS dsReportDrillDown = new sys_ReportDrillDownDS(); DataSet dstVO = dsReportDrillDown.GetObjectVO(pstrMasterID, pstrDetailID); return(dstVO); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public object GetObjectVO(int pintID) { try { sys_ReportDrillDownDS templateDS = new sys_ReportDrillDownDS(); object objVO = templateDS.GetObjectVO(pintID); return(objVO); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public int Delete(string pstrMasterID, string pstrDetailID) { try { sys_ReportDrillDownDS dsReportDrillDown = new sys_ReportDrillDownDS(); int nReturn = dsReportDrillDown.Delete(pstrMasterID, pstrDetailID); return(nReturn); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
//************************************************************************** /// <Description> /// This method uses to make a copy of specified report to another group, /// also copy all data relative to report (sys_ReportAndGroup, sys_ReportDrillDown, /// sys_ReportFields, sys_ReportPara). /// </Description> /// <Inputs> /// Source ReportID, Destination GroupID /// </Inputs> /// <Outputs> /// New report id /// </Outputs> /// <Returns> /// new report id /// </Returns> /// <Authors> /// DungLA /// </Authors> /// <History> /// 03-Jan-2005 /// 11-Jan-2005 /// </History> /// <Notes> /// Return newly report id /// </Notes> //************************************************************************** public object CopyReport(string pstrReportID, string pstrGroupID, out int ointReportOrder) { const string METHOD_NAME = THIS + ".CopyReport()"; const int REPORT_ID_MAX_LENGTH = 20; const string CODE_DATE_FORMAT = "yyyyMMddHHmmssfff"; UtilsBO boUtils = new UtilsBO(); sys_ReportDS dsReport = new sys_ReportDS(); sys_ReportVO voReport; // use to add new report to selected group sys_ReportAndGroupVO voReportAndGroup = new sys_ReportAndGroupVO(); sys_ReportAndGroupDS dsReportAndGroup = new sys_ReportAndGroupDS(); // use to copy report para sys_ReportParaDS dsReportPara = new sys_ReportParaDS(); // use to copy report fields sys_ReportFieldsDS dsReportFields = new sys_ReportFieldsDS(); // use to copy drill down report sys_ReportDrillDownDS dsReportDrillDown = new sys_ReportDrillDownDS(); // get the data of selected object voReport = (sys_ReportVO)(dsReport.GetObjectVO(pstrReportID)); #region Copy report // make a copy report sys_ReportVO voCopiedReport = new sys_ReportVO(); voCopiedReport = voReport; // get database server date time DateTime dtmDB = boUtils.GetDBDate(); // report ID = yyyyMMddHHmmssfff voCopiedReport.ReportID = dtmDB.ToString(CODE_DATE_FORMAT); if (voCopiedReport.ReportID.Length > REPORT_ID_MAX_LENGTH) { throw new PCSBOException(ErrorCode.MESSAGE_VALUE_TOO_LONG, METHOD_NAME, new Exception()); } voCopiedReport.ReportName = Constants.COPY_OF + voCopiedReport.ReportName; // save new report to database dsReport.Add(voCopiedReport); #endregion #region Add new report to group voReportAndGroup.GroupID = pstrGroupID; voReportAndGroup.ReportID = voCopiedReport.ReportID; // increase report order by one in group. voReportAndGroup.ReportOrder = dsReportAndGroup.GetMaxReportOrder(pstrGroupID) + 1; // save data dsReportAndGroup.Add(voReportAndGroup); ointReportOrder = voReportAndGroup.ReportOrder; #endregion #region Copy all data relative from old report to new report #region ReportPara // get all parameter(s) sys_ReportParaVO voReportPara; ArrayList arrParas = dsReportPara.GetObjectVOs(pstrReportID); // make a copy of each parameter if (arrParas.Count > 0) { for (int i = 0; i < arrParas.Count; i++) { voReportPara = (sys_ReportParaVO)(arrParas[i]); // assign new report id voReportPara.ReportID = voCopiedReport.ReportID; // save new para dsReportPara.Add(voReportPara); } } #endregion #region ReportFields // get all report fields sys_ReportFieldsVO voReportFields; ArrayList arrFields = dsReportFields.GetObjectVOs(pstrReportID); // make a copy of each field if (arrFields.Count > 0) { for (int i = 0; i < arrFields.Count; i++) { voReportFields = (sys_ReportFieldsVO)arrFields[i]; // assign new report id voReportFields.ReportID = voCopiedReport.ReportID; // save new field dsReportFields.Add(voReportFields); } } #endregion #region ReportDrillDown // get all drill down report sys_ReportDrillDownVO voReportDrillDown; ArrayList arrDrillDown = dsReportDrillDown.GetObjectVOs(pstrReportID); // make a copy each drill down report if (arrDrillDown.Count > 0) { for (int i = 0; i < arrDrillDown.Count; i++) { voReportDrillDown = (sys_ReportDrillDownVO)arrDrillDown[i]; // assign new report id voReportDrillDown.MasterReportID = voCopiedReport.ReportID; // save new drill down dsReportDrillDown.Add(voReportDrillDown); } } #endregion #endregion return(voCopiedReport); }
//************************************************************************** /// <Description> /// This method uses to check whether a report has drill down report or not /// </Description> /// <Inputs> /// Master Report ID, Detail Report ID /// </Inputs> /// <Outputs> /// bool /// </Outputs> /// <Returns> /// true: if has drill down | false: if has no drill down /// </Returns> /// <Authors> /// DungLA /// </Authors> /// <History> /// 01-Feb-2004 /// </History> /// <Notes> /// </Notes> //************************************************************************** public ArrayList GetDrillDownReports(string pstrMasterReportID, string pstrDetailReportID) { sys_ReportDrillDownDS dsReportDrillDown = new sys_ReportDrillDownDS(); return(dsReportDrillDown.GetObjectVOs(pstrMasterReportID, pstrDetailReportID)); }