/// <summary>
/// Get Table details
/// </summary>
/// <param name="ctx"></param>
/// <returns></returns>
public List <GenXModelGetTableClass> GenXModelGetTable(Ctx ctx)
{
List <GenXModelGetTableClass> obj = new List <GenXModelGetTableClass>();
string strQuery = "select Name, AD_TABLE_ID,TableName from AD_TABLE order by name";
DataSet ds = DB.ExecuteDataset(strQuery, null);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GenXModelGetTableClass tb = new GenXModelGetTableClass();
tb.AD_Table_ID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_TABLE_ID"]);
tb.Name = Util.GetValueOfString(ds.Tables[0].Rows[i]["Name"]);
obj.Add(tb);
}
}
return(obj);
}
/// <summary>
/// Get Table details
/// </summary>
/// <param name="ctx"></param>
/// <returns></returns>
public List <GenXModelGetTableClass> GenXModelGetTable(Ctx ctx)
{
List <GenXModelGetTableClass> obj = new List <GenXModelGetTableClass>();
string strQuery = "SELECT Name, AD_TABLE_ID,TableName FROM AD_TABLE ORDER BY NAME";
strQuery = MRole.GetDefault(ctx).AddAccessSQL(strQuery, "AD_TABLE", true, true);
DataSet ds = DB.ExecuteDataset(strQuery, null);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GenXModelGetTableClass tb = new GenXModelGetTableClass();
tb.AD_Table_ID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_TABLE_ID"]);
tb.Name = Util.GetValueOfString(ds.Tables[0].Rows[i]["Name"]);
obj.Add(tb);
}
}
return(obj);
}