/// <summary>
/// GetInformationSchema
/// </summary>
/// <param name="pstrTableName"></param>
/// <returns></returns>
/// <author>Trada</author>
/// <date>Friday, April 14 2006</date>
public DataSet GetInformationSchema(string pstrTableName)
{
DataSet dstReturn = new DataSet();
sys_TableFieldDS dsTableField = new sys_TableFieldDS();
dstReturn = dsTableField.GetInformationSchema(pstrTableName);
return(dstReturn);
}
//**************************************************************************
/// <Description>
/// This method uses to update data to sys_TableField
/// </Description>
/// <Inputs>
/// sysTableFieldVO
/// </Inputs>
/// <Outputs>
///
/// </Outputs>
/// <Returns>
///
/// </Returns>
/// <Authors>
/// Hoang Trung Son - iSphere software
/// </Authors>
/// <History>
/// 14-Dec-2004
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public void Update(object pobjObjectVO)
{
try
{
sys_TableFieldDS ds = new sys_TableFieldDS();
ds.Update(pobjObjectVO);
}
catch (PCSDBException ex)
{
throw ex;
}
}
//**************************************************************************
/// <Description>
/// List field name
/// </Description>
/// <Inputs>
///
/// </Inputs>
/// <Outputs>
/// DataSet
/// </Outputs>
/// <Returns>
/// DataSet
/// </Returns>
/// <Authors>
/// Hoang Trung Son - iSphere software
/// </Authors>
/// <History>
/// 14-Dec-2004
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public ArrayList GetColumnProperty(string pstrTableName, string pstrFieldName)
{
try
{
sys_TableFieldDS ds = new sys_TableFieldDS();
return(ds.GetColumnProperty(pstrTableName, pstrFieldName));
}
catch (PCSDBException ex)
{
throw ex;
}
}
//**************************************************************************
/// <Description>
/// This method uses to get all data from sys_TableGroup
/// </Description>
/// <Inputs>
///
/// </Inputs>
/// <Outputs>
/// DataSet
/// </Outputs>
/// <Returns>
/// DataSet
/// </Returns>
/// <Authors>
/// Hoang Trung Son - iSphere software
/// </Authors>
/// <History>
/// 14-Dec-2004
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public DataSet List(int pintTableID)
{
try
{
sys_TableFieldDS ds = new sys_TableFieldDS();
return(ds.List(pintTableID));
}
catch (PCSDBException ex)
{
throw ex;
}
}
//**************************************************************************
/// <Description>
/// List field name
/// </Description>
/// <Inputs>
///
/// </Inputs>
/// <Outputs>
/// DataSet
/// </Outputs>
/// <Returns>
/// DataSet
/// </Returns>
/// <Authors>
/// Hoang Trung Son - iSphere software
/// </Authors>
/// <History>
/// 14-Dec-2004
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public DataSet ListFieldName(string pstrTableName)
{
try
{
sys_TableFieldDS ds = new sys_TableFieldDS();
return(ds.ListFieldName(pstrTableName));
}
catch (PCSDBException ex)
{
throw ex;
}
}
//**************************************************************************
/// <Description>
/// This method uses to delete data from sys_TableField
/// </Description>
/// <Inputs>
/// pintTableID
/// </Inputs>
/// <Outputs>
/// void
/// </Outputs>
/// <Returns>
///
/// </Returns>
/// <Authors>
/// Hoang Trung Son - iSphere software
/// </Authors>
/// <History>
/// 14-Dec-2004
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public void Delete(int pintTableFieldID)
{
try
{
sys_TableFieldDS ds = new sys_TableFieldDS();
ds.Delete(pintTableFieldID);
}
catch (PCSDBException ex)
{
throw ex;
}
}
//**************************************************************************
/// <Description>
/// This method uses to get data from sys_TableField
/// </Description>
/// <Inputs>
/// TableID
/// </Inputs>
/// <Outputs>
/// sysTableFieldVO
/// </Outputs>
/// <Returns>
/// sysTableFieldVO
/// </Returns>
/// <Authors>
/// Hoang Trung Son - iSphere software
/// </Authors>
/// <History>
/// 14-Dec-2004
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public object GetObjectVO(int pintTableFieldID)
{
try
{
sys_TableFieldDS ds = new sys_TableFieldDS();
return(ds.GetObjectVO(pintTableFieldID));
}
catch (PCSDBException ex)
{
throw ex;
}
}
public DataSet getFieldList(string pstrTableOrViewName)
{
sys_TableFieldDS objTableFieldDS = new sys_TableFieldDS();
try
{
DataSet dstFieldList = objTableFieldDS.List(pstrTableOrViewName);
return(dstFieldList);
}
catch (PCSDBException ex)
{
throw ex;
}
}
public DataSet getFieldList(int pintTableID)
{
sys_TableFieldDS objTableFieldDS = new sys_TableFieldDS();
try
{
DataSet dstFieldList = objTableFieldDS.List(pintTableID);
return(dstFieldList);
}
catch (PCSDBException ex)
{
throw ex;
}
}
public int GetTotalColumnWidth(string pstrTableName)
{
try
{
sys_TableDS objsysTableDS = new sys_TableDS();
int intTableID = objsysTableDS.GetTableID(pstrTableName);
if (intTableID > 0)
{
sys_TableFieldDS objsys_TableFieldDS = new sys_TableFieldDS();
return(objsys_TableFieldDS.GetTotalColumnWidth(intTableID));
}
else
{
return(intTableID);
}
}
catch (PCSDBException ex)
{
throw ex;
}
}
//**************************************************************************
/// <Description>
/// Return the list of Fields from database
/// </Description>
/// <Inputs>
/// Null
/// </Inputs>
/// <Outputs>
/// DataSet
/// </Outputs>
/// <Returns>
///
/// </Returns>
/// <Authors>
/// DungLA
/// </Authors>
/// <History>
/// 07-Jan-2005
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public DataSet getFieldList(int pintTableID)
{
sys_TableFieldDS objTableFieldDS = new sys_TableFieldDS();
return(objTableFieldDS.List(pintTableID));
}
/// <summary>
/// UpdateDataSetByTableID
/// </summary>
/// <param name="dstData"></param>
/// <param name="pintTableID"></param>
/// <author>Trada</author>
/// <date>Thursday, Dec 1 2005</date>
public void UpdateDataSetByTableID(DataSet dstData, int pintTableID)
{
sys_TableFieldDS dsSys_TableField = new sys_TableFieldDS();
dsSys_TableField.UpdateDataSetByTableID(dstData, pintTableID);
}
