public CategoryItems Get(object key) { int id = Convert.ToInt32(key); CategoryItems item = new CategoryItems() { Id = id }; string sql = item.GetFirstOneSql(); DataSet ds = new SqlCmdHelper() { SqlConnString = SqlConnString }.GenerateQuerySqlAndExcute(sql, item); List <CategoryItems> data = DataHelp.DataReflection.DataSetConvert <CategoryItems>(ds); if (data == null || data.Count == 0) { return(null); } return(data[0]); }