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