/// <summary>
/// Get data from RoleParty/RoleProduct/RoleWC
/// </summary>
/// <param name="pintRoleID"></param>
/// <param name="pstrSecurityTableName"></param>
/// <returns></returns>
/// <author>Trada</author>
/// <date>Thursday, Nov 17 2005</date>
public DataSet GetRightByRecord(int pintRoleID, string pstrSecurityTableName, string pstrSourceTableName)
{
DataSet dstSecurityTable = new DataSet();
sys_RolePartyDS dsRoleParty = new sys_RolePartyDS();
dstSecurityTable = dsRoleParty.GetDataByRoleID(pintRoleID, pstrSecurityTableName, pstrSourceTableName);
return(dstSecurityTable);
}
/// <summary>
/// GetPKColumnName
/// </summary>
/// <param name="primaryTable"></param>
/// <returns>Primary Key column or string.Emty if table has not configed</returns>
public string GetPKColumnName(string primaryTable)
{
string strColumnName = string.Empty;
const string PKCOLUMN_NAME = "COLUMN_NAME";
var dsRoleParty = new sys_RolePartyDS();
DataTable dtbFKTable = dsRoleParty.GetPKColumnName(primaryTable);
if (dtbFKTable.Rows.Count == 0)
{
return(string.Empty);
}
else
{
strColumnName = dtbFKTable.Rows[0][PKCOLUMN_NAME].ToString();
return(strColumnName);
}
}
/// <summary>
/// GetFKColumnName
/// </summary>
/// <param name="primaryTable"></param>
/// <param name="foreignTable"></param>
/// <returns>FK Column Name else return string.Emty</returns>
public string GetFKColumnName(string primaryTable, string foreignTable)
{
string strColumnName = string.Empty;
const string FKTABLE_NAME = "FKTABLE_NAME";
const string FKCOLUMN_NAME = "FKCOLUMN_NAME";
var dsRoleParty = new sys_RolePartyDS();
DataTable dtbFKTable = dsRoleParty.GetFKColumnName(primaryTable);
foreach (DataRow drow in dtbFKTable.Rows)
{
if (drow[FKTABLE_NAME].ToString() == foreignTable)
{
strColumnName = drow[FKCOLUMN_NAME].ToString();
}
}
return(strColumnName);
}
/// <summary>
/// UpdateSecurityTable
/// </summary>
/// <param name="pdstSecurityTable"></param>
/// <param name="pstrSecurityTableName"></param>
/// <author>Trada</author>
/// <date>Friday, Nov 18 2005</date>
public void UpdateSecurityTable(DataSet pdstSecurityTable, string pstrSecurityTableName, string pstrSourceTableName)
{
sys_RolePartyDS dsRoleParty = new sys_RolePartyDS();
dsRoleParty.UpdateSecurityTable(pdstSecurityTable, pstrSecurityTableName, pstrSourceTableName);
}
