/// <summary> /// id 查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public LeftMenuModels Get_LeftMenuById(int id) { string sql = "select * from LeftMenu where Id = @Id"; SqlParameter[] param = { new SqlParameter("@Id", id) }; LeftMenuModels lm = null; var dt = Class1.Query(sql, param); foreach (DataRow dr in dt.Rows) { lm = new LeftMenuModels() { Id = int.Parse(dr["Id"].ToString()), Title = dr["Title"].ToString(), Link = dr["Link"].ToString(), ParentId = int.Parse(dr["ParentId"].ToString()), UpdateTime = DateTime.Parse(dr["UpdateTime"].ToString()), }; } return(lm); }
/// <summary> /// 按照id查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public UsersModels Get_DataById(int id) { string sql = "select * from Users where Id = @Id"; SqlParameter[] sp = { new SqlParameter("@Id", id) }; var dt = Class1.Query(sql, sp); //判断这个系统续表当中是否有值 if (dt.Rows.Count > 0) //判断系统续表当中行数是否大于0 { //有值的情况 return(new UsersModels() { ID = int.Parse(dt.Rows[0]["Id"].ToString()), Email = dt.Rows[0]["Email"].ToString(), NickName = dt.Rows[0]["NickName"].ToString(), Photo = dt.Rows[0]["Photo"].ToString(), }); } else { return(null); //没有值的情况 } }
/// <summary> /// 根据ParentId 查询 /// </summary> /// <param name="pid">父级菜单id 为0的时候是根节点,其他的时候是子节点</param> /// <returns></returns> public DataTable Get_LeftMenuByParentId(int pid) { string sql = "select * from LeftMenu where ParentId = @ParentId"; SqlParameter[] sp = { new SqlParameter("@ParentId", pid) }; return(Class1.Query(sql, sp)); }