public void UpdateDataSetViewTable(DataSet pdstData, string pstrSqlSelect, bool pblnForEdit, string pstrSqlSelectUpdate)
{
const string METHOD_NAME = THIS + ".UpdateDataSetViewTable()";
try
{
sysGenerateTableFormDS objGenerateTableFormDS = new sysGenerateTableFormDS();
objGenerateTableFormDS.UpdateDataSet(pdstData, pstrSqlSelect, pblnForEdit, pstrSqlSelectUpdate);
//
}
catch (PCSDBException ex)
{
try
{
}
catch (System.Runtime.InteropServices.COMException exCom)
{
throw new PCSBOException(ErrorCode.MESSAGE_COM_TRANSACTION, METHOD_NAME, exCom);
}
throw ex;
}
catch (System.Runtime.InteropServices.COMException ex)
{
throw new PCSBOException(ErrorCode.MESSAGE_COM_TRANSACTION, METHOD_NAME, ex);
}
}
public string BuildSqlForTrueDBDropDown(string strFromTable, string strFromField, string strFilterField1, string strFilterField2)
{
try
{
sysGenerateTableFormDS objGenerateTableFormDS = new sysGenerateTableFormDS();
return(objGenerateTableFormDS.BuildSqlForTrueDBDropDown(strFromTable, strFromField, strFilterField1, strFilterField2));
}
catch (PCSDBException ex)
{
throw ex;
}
}
public DataSet getDataListForUpdate(string pstrSql, string pstrTableName)
{
try
{
sysGenerateTableFormDS objGenerateTableFormDS = new sysGenerateTableFormDS();
DataSet dstData = objGenerateTableFormDS.List(pstrSql, pstrTableName);
return(dstData);
}
catch (PCSDBException ex)
{
throw ex;
}
}
public string BuildSQLSelect(DataSet pdstFieldList, string pstrTableName, bool pblnForEdit)
{
try
{
sysGenerateTableFormDS objGenerateTableFormDS = new sysGenerateTableFormDS();
string strSqlSelectCommand = objGenerateTableFormDS.BuildSQLSelect(pdstFieldList, pstrTableName, pblnForEdit);
return(strSqlSelectCommand);
}
catch (PCSDBException ex)
{
throw ex;
}
}
public DataSet getDataListForComboBox(string strSQL, string strTableName)
{
try
{
sysGenerateTableFormDS objGenerateTableFormDS = new sysGenerateTableFormDS();
DataSet dstData = objGenerateTableFormDS.List(strSQL, strTableName);
return(dstData);
}
catch (PCSDBException ex)
{
throw ex;
}
}
public DataRow GetFieldLength(DataSet pdstFieldList, string pstrTableName)
{
try
{
sysGenerateTableFormDS objGenerateTableFormDS = new sysGenerateTableFormDS();
return(objGenerateTableFormDS.GetFieldLength(pdstFieldList, pstrTableName));
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public int GetMaxValue(string pstrTableName, string pstrColumnName)
{
try
{
sysGenerateTableFormDS objSysGenerateTableFormDS = new sysGenerateTableFormDS();
return(objSysGenerateTableFormDS.GetMaxValue(pstrTableName, pstrColumnName) + 1);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable SearchValueForButtonColumn(string[] pstrColumnInfor, string pstrValue)
{
//strArrayValue[0] - From TableName
//strArrayValue[1] - Value Field
//strArrayValue[2] - Display Field 1
//strArrayValue[3] - Display Field 2
//strArrayValue[4] - Ogininal Column Name
try
{
sysGenerateTableFormDS objsysGenerateTableFormDS = new sysGenerateTableFormDS();
return(objsysGenerateTableFormDS.SearchValueForButtonColumn(pstrColumnInfor, pstrValue));
}
catch (PCSException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
