如何显示每位经理下的所有员工 [英] How to display all employees under each manager
本文介绍了如何显示每位经理下的所有员工的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
I have a 2 tables:
Mrg:
UserID || UserID_Mrg || Status
and
User:
UserID || Name
I want to display all employees (UserID) under each Manager (UserID_Mrg)
example:
UserID_Mrg = 12
So display all UserID with UserID_Mrg = 12
so far I could just display the users Information an their Manager:
我尝试过:
What I have tried:
<pre lang="c#">private void BindGridView()
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString))
using (SqlDataAdapter adapter = new SqlDataAdapter(@"
SELECT tbl_user.Name, tbl_mrg.UserID_Mrg FROM tbl_mrg
INNER JOIN tbl_user ON tbl_mrg.UserID = tbl_user.UserID
WHERE ((tbl_mag.user_ID = @UserID))
ORDER BY tbl_user.Name", con))
{
adapter.SelectCommand.Parameters.Add(new SqlParameter("@UserID", SessionHelper.UserID));
adapter.Fill(Data2);
GridView2.DataSource = Data2;
GridView2.DataBind();
}
}
<asp:GridView ID="GridView2" runat="server">
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Mrg" HeaderText="Manager" SortExpression="Manager" />
</Columns>
</asp:GridView>
推荐答案
假设@userID是经理ID,这个
Assuming @userID is the manager id, this
tbl_mgr.user_ID = @UserID
应为
tbl_mgr.UserID_Mrg = @UserID
,例如
such as
select u.userid, u.name from user u join mrg m on u.userid=m.userid where userid_mrg = 12
根据你的问题你想要的查看经理的所有用户。
因此条件应该通过 userid_mrg 而不是 userid ,查询将是。
SELECT
tbl_user.Name
,tbl_mrg.UserID_Mrg
FROM tbl_mrg
INNER JOIN tbl_user
ON tbl_mrg.UserID = tbl_user.UserID
WHERE tbl_mrg.UserID_Mrg = @managerid//这里@ managerid = 12你可以通过。
As per your question you want to see the all the users of a manager.
So the condition should be passed userid_mrg instead of userid and the query will be .
"SELECT
tbl_user.Name
,tbl_mrg.UserID_Mrg
FROM tbl_mrg
INNER JOIN tbl_user
ON tbl_mrg.UserID = tbl_user.UserID
WHERE tbl_mrg.UserID_Mrg = @managerid" // Here @managerid=12 you can pass.
这篇关于如何显示每位经理下的所有员工的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文