小新新2015

导航

 
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MenuName,URL,ParentID,Sort,Domain,Levels from Menu ");
strSql.Append(" where Domain=@Domain AND Levels=@Levels");
SqlParameter[] parameters = {
new SqlParameter("@Domain", SqlDbType.VarChar,50),
new SqlParameter("@Levels", SqlDbType.Int,4)
};
parameters[0].Value = domain;
parameters[1].Value = 0;

YuanBo.Model.Menu model = new YuanBo.Model.Menu();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

 

posted on 2015-10-13 16:22  小新新2015  阅读(148)  评论(0编辑  收藏  举报