/// <summary>
/// Switch two field order
/// </summary>
/// <param name="pobjSourceField">Source Field</param>
/// <param name="pobjDestField">Destination Field</param>
public void SwitchFields(object pobjSourceField, object pobjDestField)
{
sys_ReportFieldsDS dsReportField = new sys_ReportFieldsDS();
dsReportField.UpdateByName(pobjSourceField);
dsReportField.UpdateByName(pobjDestField);
}
/// <summary>
/// Insert a new record into database
/// </summary>
public int AddAndReturnID(object pobjFieldGroup, ArrayList parrSelectedItem)
{
try
{
Sys_FieldGroupVO voFieldGroup = (Sys_FieldGroupVO)pobjFieldGroup;
Sys_FieldGroupDS dsFieldGroup = new Sys_FieldGroupDS();
sys_ReportFieldsDS dsReportField = new sys_ReportFieldsDS();
Sys_FieldGroupDetailDS dsFieldGroupDetail = new Sys_FieldGroupDetailDS();
// get current field group order
voFieldGroup.GroupOrder = dsFieldGroup.GetFieldGroupOrder(voFieldGroup.ReportID, voFieldGroup.ParentFieldGroupID) + 1;
// save new field group to database
int intNewID = dsFieldGroup.AddAndReturnID(voFieldGroup);
// save all selected sub group/field to database if any
for (int i = 0; i < parrSelectedItem.Count; i++)
{
switch (voFieldGroup.GroupLevel)
{
case (int)GroupFieldLevel.One:
// update sub group
Sys_FieldGroupVO voSubGroup = (Sys_FieldGroupVO)parrSelectedItem[i];
// parent field group id
voSubGroup.ParentFieldGroupID = intNewID;
// new order in group
voSubGroup.GroupOrder = i + 1;
// save to database
dsFieldGroup.Update(voSubGroup);
break;
case (int)GroupFieldLevel.Two:
// update report field
sys_ReportFieldsVO voReportField = (sys_ReportFieldsVO)parrSelectedItem[i];
// new field order in group
voReportField.FieldOrder = i + 1;
dsReportField.UpdateByName(voReportField);
// create new Field Group Detail
Sys_FieldGroupDetailVO voFieldGroupDetail = new Sys_FieldGroupDetailVO();
voFieldGroupDetail.FieldGroupID = intNewID;
voFieldGroupDetail.ReportID = voFieldGroup.ReportID;
voFieldGroupDetail.FieldName = voReportField.FieldName;
// save to database
dsFieldGroupDetail.Add(voFieldGroupDetail);
break;
}
}
return(intNewID);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception 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);
}
/// <summary>
/// Delete record by condition
/// </summary>
public void Delete(object pObjectVO, ArrayList parrSelected)
{
try
{
Sys_FieldGroupVO voFieldGroup = (Sys_FieldGroupVO)pObjectVO;
Sys_FieldGroupDS dsFieldGroup = new Sys_FieldGroupDS();
sys_ReportFieldsDS dsReportField = new sys_ReportFieldsDS();
Sys_FieldGroupDetailDS dsFieldGroupDetail = new Sys_FieldGroupDetailDS();
int intCurrentGroupOrder = dsFieldGroup.GetFieldGroupOrder(voFieldGroup.ReportID, 0);
int intCurrentFieldOrder = dsReportField.GetMaxFieldOrder(voFieldGroup.ReportID);
for (int i = 0; i < parrSelected.Count; i++)
{
switch (voFieldGroup.GroupLevel)
{
case (int)GroupFieldLevel.One:
// update sub group (order and parent id)
Sys_FieldGroupVO voSubGroup = (Sys_FieldGroupVO)parrSelected[i];
voSubGroup.ParentFieldGroupID = 0;
voSubGroup.GroupOrder = intCurrentGroupOrder + i + 1;
dsFieldGroup.Update(voSubGroup);
break;
case (int)GroupFieldLevel.Two:
// update report field
sys_ReportFieldsVO voReportField = (sys_ReportFieldsVO)parrSelected[i];
// new field order in group
voReportField.FieldOrder = intCurrentFieldOrder + i + 1;
dsReportField.UpdateByName(voReportField);
// delete field group detail records first
dsFieldGroupDetail.Delete(voFieldGroup.FieldGroupID, voFieldGroup.ReportID);
break;
}
}
// delete field group
dsFieldGroup.Delete(voFieldGroup.FieldGroupID);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public bool MoveDownField(string pstrReportID, string pstrFieldName)
{
const string METHOD_NAME = THIS + ".MoveDownField()";
bool blnResult = true;
sys_ReportFieldsDS dsReportField = new sys_ReportFieldsDS();
sys_ReportFieldsVO voPreviousField = new sys_ReportFieldsVO();
sys_ReportFieldsVO voCurrentField = new sys_ReportFieldsVO();
ArrayList arrFields = new ArrayList();
arrFields = dsReportField.GetObjectVOs(pstrReportID);
for (int i = 0; i < arrFields.Count; i++)
{
sys_ReportFieldsVO voReportField = (sys_ReportFieldsVO)arrFields[i];
string strFieldName = voReportField.FieldName;
if (strFieldName.Equals(pstrFieldName))
{
int intCurrentOrder = voReportField.FieldOrder;
// if current order reached the bottom of layout then return false
if (intCurrentOrder >= arrFields.Count)
{
blnResult = false;
}
else
{
// get the previous group
voPreviousField = (sys_ReportFieldsVO)arrFields[i + 1];
// get the current group
voCurrentField = (sys_ReportFieldsVO)arrFields[i];
// switch order
voCurrentField.FieldOrder = voPreviousField.FieldOrder;
voPreviousField.FieldOrder = intCurrentOrder;
//update two rows into database
dsReportField.UpdateByName(voPreviousField);
dsReportField.UpdateByName(voCurrentField);
blnResult = true;
}
}
}
return(blnResult);
}
public bool MoveUpField(string pstrReportID, string pstrFieldName)
{
bool blnResult = true;
sys_ReportFieldsDS dsReportField = new sys_ReportFieldsDS();
sys_ReportFieldsVO voPreviousField = new sys_ReportFieldsVO();
sys_ReportFieldsVO voCurrentField = new sys_ReportFieldsVO();
ArrayList arrFields = new ArrayList();
arrFields = dsReportField.GetObjectVOs(pstrReportID);
for (int i = 0; i < arrFields.Count; i++)
{
sys_ReportFieldsVO voReportField = (sys_ReportFieldsVO)arrFields[i];
string strFieldName = voReportField.FieldName;
if (strFieldName.Equals(pstrFieldName))
{
int intCurrentOrder = voReportField.FieldOrder;
// if current order reached the top of layout then return false
if (intCurrentOrder <= 1)
{
blnResult = false;
}
else
{
// get previous group
voPreviousField = (sys_ReportFieldsVO)arrFields[i - 1];
// get current group
voCurrentField = (sys_ReportFieldsVO)arrFields[i];
// switch order between two groups
voCurrentField.FieldOrder = voPreviousField.FieldOrder;
voPreviousField.FieldOrder = intCurrentOrder;
//update two rows into database
dsReportField.UpdateByName(voPreviousField);
dsReportField.UpdateByName(voCurrentField);
blnResult = true;
}
}
}
return(blnResult);
}
/// <summary>
/// Update into Database
/// </summary>
public void Update(object pobjFieldGroup, ArrayList parrSelectedItem, ArrayList parrAvailableItem)
{
try
{
Sys_FieldGroupVO voFieldGroup = (Sys_FieldGroupVO)pobjFieldGroup;
Sys_FieldGroupDS dsFieldGroup = new Sys_FieldGroupDS();
sys_ReportFieldsDS dsReportField = new sys_ReportFieldsDS();
Sys_FieldGroupDetailDS dsFieldGroupDetail = new Sys_FieldGroupDetailDS();
// update Field Group
dsFieldGroup.Update(voFieldGroup);
int intCurrentGroupOrder = dsFieldGroup.GetFieldGroupOrder(voFieldGroup.ReportID, 0);
int intCurrentFieldOrder = dsReportField.GetMaxFieldOrder(voFieldGroup.ReportID);
for (int i = 0; i < parrAvailableItem.Count; i++)
{
switch (voFieldGroup.GroupLevel)
{
case (int)GroupFieldLevel.One:
Sys_FieldGroupVO voSubGroup = (Sys_FieldGroupVO)parrAvailableItem[i];
// remove parent field group
voSubGroup.ParentFieldGroupID = 0;
voSubGroup.GroupOrder = intCurrentGroupOrder + 1 + i;
dsFieldGroup.Update(voSubGroup);
break;
case (int)GroupFieldLevel.Two:
// update report field
sys_ReportFieldsVO voReportField = (sys_ReportFieldsVO)parrSelectedItem[i];
// new field order in group
voReportField.FieldOrder = intCurrentFieldOrder + i + 1;
dsReportField.UpdateByName(voReportField);
// create new Field Group Detail
Sys_FieldGroupDetailVO voFieldGroupDetail = new Sys_FieldGroupDetailVO();
voFieldGroupDetail.FieldGroupID = voFieldGroup.FieldGroupID;
voFieldGroupDetail.ReportID = voFieldGroup.ReportID;
voFieldGroupDetail.FieldName = voReportField.FieldName;
// save to database
dsFieldGroupDetail.Add(voFieldGroupDetail);
break;
}
}
// delete old field group detail
dsFieldGroupDetail.Delete(voFieldGroup.FieldGroupID, voFieldGroup.ReportID);
// update selected group/field
for (int i = 0; i < parrSelectedItem.Count; i++)
{
switch (voFieldGroup.GroupLevel)
{
case (int)GroupFieldLevel.One:
Sys_FieldGroupVO voSubGroup = (Sys_FieldGroupVO)parrSelectedItem[i];
voSubGroup.ParentFieldGroupID = voFieldGroup.FieldGroupID;
voSubGroup.GroupOrder = i + 1;
dsFieldGroup.Update(voSubGroup);
break;
case (int)GroupFieldLevel.Two:
// update report field
sys_ReportFieldsVO voReportField = (sys_ReportFieldsVO)parrSelectedItem[i];
// new field order in group
voReportField.FieldOrder = i + 1;
dsReportField.UpdateByName(voReportField);
// create new Field Group Detail
Sys_FieldGroupDetailVO voFieldGroupDetail = new Sys_FieldGroupDetailVO();
voFieldGroupDetail.FieldGroupID = voFieldGroup.FieldGroupID;
voFieldGroupDetail.ReportID = voFieldGroup.ReportID;
voFieldGroupDetail.FieldName = voReportField.FieldName;
// save to database
dsFieldGroupDetail.Add(voFieldGroupDetail);
break;
}
}
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public ArrayList ListByReport(string pstrReportID)
{
sys_ReportFieldsDS dsReportFields = new sys_ReportFieldsDS();
return(dsReportFields.GetObjectVOs(pstrReportID));
}
public void UpdateDataSet(DataSet pData)
{
sys_ReportFieldsDS templateDS = new sys_ReportFieldsDS();
templateDS.UpdateDataSet(pData);
}
public DataSet List()
{
sys_ReportFieldsDS templateDS = new sys_ReportFieldsDS();
return(templateDS.List());
}
//**************************************************************************
/// <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);
}
public void Delete(string pstrReportID)
{
sys_ReportFieldsDS dsReportField = new sys_ReportFieldsDS();
dsReportField.Delete(pstrReportID);
}
public void Delete(int pintID)
{
sys_ReportFieldsDS templateDS = new sys_ReportFieldsDS();
templateDS.Delete(pintID);
}
/// <summary>
/// Update Report field by name
/// </summary>
/// <param name="pobjObjectVO">sys_ReportFieldsVO</param>
public void UpdateByName(object pobjObjectVO)
{
sys_ReportFieldsDS dsReportField = new sys_ReportFieldsDS();
dsReportField.UpdateByName(pobjObjectVO);
}
public ArrayList GetSortFields(string pstrReportID)
{
sys_ReportFieldsDS dsFields = new sys_ReportFieldsDS();
return(dsFields.GetSortFields(pstrReportID));
}
public void Add(object pobjObjectVO)
{
sys_ReportFieldsDS templateDS = new sys_ReportFieldsDS();
templateDS.Add(pobjObjectVO);
}
public int SumFieldsWidth(string pstrReportID)
{
sys_ReportFieldsDS dsField = new sys_ReportFieldsDS();
return(dsField.SumFieldsWidth(pstrReportID));
}
public object GetObjectVO(int pintID)
{
sys_ReportFieldsDS templateDS = new sys_ReportFieldsDS();
return(templateDS.GetObjectVO(pintID));
}
public void Update(object pobjObjecVO)
{
sys_ReportFieldsDS templateDS = new sys_ReportFieldsDS();
templateDS.UpdateByName(pobjObjecVO);
}
public int GetMaxFieldOrder(string pstrReportID)
{
sys_ReportFieldsDS dsField = new sys_ReportFieldsDS();
return(dsField.GetMaxFieldOrder(pstrReportID));
}