mvc+EF+EASYUI问题，求大神解决

[鲜蛋网]

上面两张图，我想实现在发放记录里，根据当前用户的职位名称，获取薪资标准的基本工资。


比如：高莉 是 经理，薪资标准里，经理的基本工资是5000，我想在发放记录里多一个列获取经理的基本工资，然后把当前的金额进行一个结算，显示在总金额列里，大神帮忙，小弟十分感谢！

[鲜蛋网]

@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_HrmsMaster.cshtml";
}

<div style="padding-left: 250px;">
    <table >
        <tr>
            <td>
               查询条件:

            </td>
            <td>
                <input type="text" id="Search" class="easyui-validatebox" />

            </td>
            <td>
            <input id="ToName" name="Searchs" class="easyui-validatebox" type="radio" checked="checked" />按姓名
            </td>
        <td>
            <input id="ToPosition" name="Searchs" class="easyui-validatebox" type="radio" />按职位
        </td>
            <td>
                <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-search" plain="true">搜索</a>
            </td>
            <td>
                <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-reload" plain="true">刷新</a></td>
        </tr>
    </table>
</div>

<div id="mian" style="width: 100%;">
    <div title="发放记录" style="padding: 5px">

        <table id="trainItem-dg" title="发放记录" class="easyui-datagrid" style="width: 1150px;" url="/PaymentGrant/LoadGrant" toolbar="#toolbar" pagination="true" rownumbers="true" fitcolumns="true" singleselect="true">
            <thead>
                <tr>
                    <th data-options="field:'ck',checkbox:true"></th>
                    <th field="Employee" formatter="formatterEmployee" width="20">员工姓名</th>
                    <th field="DutyName" width="20">职位名称</th>
                   <!-- <th field="Payment" formatter="formatterPayment" width="20">基本工资</th>-->
                    <th field="TraficSubsidy" width="20">交通补贴</th>
                    <th field="CommunicationSubsidy" width="20">通讯补贴</th>
                    <th field="LunchSubsidy" width="20">午餐补贴</th>
                    <th field="FloatingWage" width="50">浮动工资</th>
                    <th field="Deduction" width="50">扣除工资</th>
                     <th field="Reward" width="50">奖金</th>
                    <th field="Grant" width="50">发放时间</th>
                    <th field="EmployeeName" width="50">发放人</th>

                </tr>
            </thead>
        </table>

        <div id="toolbar">
            <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-add" plain="true" onclick="newUser()">添加</a>
            <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-edit" plain="true" onclick="editUser()">修改</a>
            <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-cancel" plain="true" onclick="destroyUser()">删除</a>
            <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-search" plain="true" onclick="visitUser()">浏览</a>
        </div>
    </div>
</div>
<script>
    function formatterEmployee(value)
    {
        return value.RealName
    }

</script>

[鲜蛋网]

@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_HrmsMaster.cshtml";
}

<div style="padding-left: 250px;">
    <table >
        <tr>
            <td>
               查询条件:

            </td>
            <td>
                <input type="text" id="Search" class="easyui-validatebox" />

            </td>
            <td>
            <input id="ToName" name="Searchs" class="easyui-validatebox" type="radio" checked="checked" />按姓名
            </td>
        <td>
            <input id="ToPosition" name="Searchs" class="easyui-validatebox" type="radio" />按职位
        </td>
            <td>
                <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-search" plain="true">搜索</a>
            </td>
            <td>
                <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-reload" plain="true">刷新</a></td>
        </tr>
    </table>
</div>

<div id="mian" style="width: 100%;">
    <div title="薪资标准" style="padding: 5px">

        <table id="trainItem-dg" title="薪资标准" class="easyui-datagrid" style="width: 1150px;" url="/Payment/LoadPayment" toolbar="#toolbar" pagination="true" rownumbers="true" fitcolumns="true" singleselect="true">
            <thead>
                <tr>
                    <th data-options="field:'ck',checkbox:true"></th>
                    <th field="Position" formatter="formatterPosition" width="20">职位名称</th>
                    <th field="BasicWage" width="20">基本工资</th>
                    <th field="TraficSubsidy" width="20">交通补贴</th>
                    <th field="CommunicationSubsidy" width="20">通讯补贴</th>
                    <th field="LunchSubsidy" width="20">午餐补贴</th>
                    <th field="FloatingWage" width="50">浮动工资</th>
                    <th field="CustomTime" width="50">制定时间</th>
                </tr>
            </thead>
        </table>

        <div id="toolbar">
            <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-add" plain="true" onclick="newUser()">添加</a>
            <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-edit" plain="true" onclick="editUser()">修改</a>
            <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-cancel" plain="true" onclick="destroyUser()">删除</a>
            <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-search" plain="true" onclick="visitUser()">浏览</a>
        </div>
    </div>
</div>

<script>
    function formatterPosition(value)
    {
        return value.PositionName
    }

    function newUser() {
        $('#DivAddUser').dialog('open').dialog('setTitle', '添加用户');
        $('#fm').form('clear');
        url = '/Home/RegistUser';
    }

</script>

[走着看世界]

1：修改返回数据集，查询经理的基本工资。

[鲜蛋网]

大神，怎么写哈，给个示例什么的

[zijiang001]

不能直接用SQL语句取的基本工资后绑定到前台吗?

[鲜蛋网]

多表查询是吧？

[zijiang001]

对呀 连接到基本工资表直接取基本工资就好了呀

[david_88888]

建个视图,在后数据库里把数据处理好再返回给"发放记录"