/// <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); }