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