/// <summary>
/// Get SQLCategory
/// </summary>
/// <returns>SQLSupportData Dataset</returns>
public static SQLSupportData GetSQLCategory()
{
SQLSupportData sqlSupport = new SQLSupportData();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(sqlSupport.ListSqlCategory, "f9015_pclst_SqlCategory", ht);
return(sqlSupport);
}
/// <summary>
/// Get SQLDescription
/// </summary>
/// <param name="categoryId">The SQL category.</param>
/// <returns>SQLSupportData Dataset</returns>
public static SQLSupportData GetSQLDescription(int categoryId)
{
SQLSupportData sqlSupport = new SQLSupportData();
Hashtable ht = new Hashtable();
ht.Add("@CategoryID", categoryId);
Utility.LoadDataSet(sqlSupport.ListSqlDescription, "f9015_pclst_SqlDescription", ht);
return(sqlSupport);
}
/// <summary>
/// Gets SqlString
/// </summary>
/// <param name="categoryId">Category</param>
/// <param name="sqlId">Description</param>
/// <returns>returns the SqlString</returns>
public static SQLSupportData GetSqlString(int categoryId, int sqlId)
{
SQLSupportData sqlSupport = new SQLSupportData();
Hashtable ht = new Hashtable();
ht.Add("@CategoryID", categoryId);
ht.Add("@SQLID", sqlId);
Utility.LoadDataSet(sqlSupport.GetSqlString, "f9015_pcget_Sql", ht);
return(sqlSupport);
}
