📄 calcfee.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CalcFee.aspx.cs" Inherits="Personal_CalcFee" Title="学费统计 - 杰帮教育管理系统" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>无标题页</title>
<link href="../style/Print.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<table align="center" border="0" cellpadding="0" cellspacing="0" style="width: 80%">
<tr>
<td align="center">
<h3 style="margin-bottom: 6px">
杰邦教育集团 <asp:Literal ID="litDepartment" runat="server"></asp:Literal> 学费及招生提成统计表</h3>
时间：<asp:Label ID="lblStartDate" runat="server"></asp:Label>
～
<asp:Label ID="lblEndDate" runat="server"></asp:Label> </td>
</tr>
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
CssClass="mainView" DataSourceID="SqlDataSource1" EmptyDataText="尚无可以统计的数据" Width="100%"
AllowSorting="True">
<Columns>
<asp:BoundField DataField="em_ID" HeaderText="ID" SortExpression="em_ID">
<ItemStyle HorizontalAlign="Center" />
<HeaderStyle HorizontalAlign="Center" Width="8%" />
</asp:BoundField>
<asp:BoundField DataField="em_Name" HeaderText="姓名" SortExpression="em_Name">
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="RCount" HeaderText="人数" SortExpression="RCount">
<ItemStyle HorizontalAlign="Right" />
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="Fee" DataFormatString="{0:F2}" HeaderText="应收学费(Y)" HtmlEncode="False"
SortExpression="Fee">
<ItemStyle HorizontalAlign="Right" />
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="RealPay" DataFormatString="{0:F2}" HeaderText="实收学费(S)"
HtmlEncode="False" SortExpression="RealPay">
<ItemStyle HorizontalAlign="Right" />
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="Lack" DataFormatString="{0:F2}" HeaderText="欠费(Q)" HtmlEncode="False"
SortExpression="Lack">
<ItemStyle HorizontalAlign="Right" />
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="P" DataFormatString="{0:#.##%}" HeaderText="提成率(P)" HtmlEncode="False"
SortExpression="P">
<ItemStyle HorizontalAlign="Right" />
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="T" DataFormatString="{0:F2}" HeaderText="提成(T)" HtmlEncode="False"
SortExpression="T">
<ItemStyle HorizontalAlign="Right" />
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td height="28" valign="bottom">
<asp:Panel ID="panSign" runat="server" Width="100%">
<table width="100%" >
<tr>
<td style="width: 160px">
统计日期：<asp:Label ID="lblCalcDate" runat="server"></asp:Label>
</td>
<td align="right">
统计人：<asp:Label ID="lblCalcEmployee" runat="server"></asp:Label>
签字:</td><td style="border-bottom:1px solid black;width:83px"> </td>
<td align="right">
领导签字:</td><td style="border-bottom:1px solid black;width:83px"> </td>
</tr>
</table>
</asp:Panel>
<asp:Panel ID="panFormula" runat="server" Width="100%" HorizontalAlign="Right">
提成计算公式: T = Ｓ *
<asp:TextBox ID="txtP" runat="server" Width="28px">3</asp:TextBox>% - Q*<asp:TextBox
ID="txtQ" runat="server" Width="28px">0</asp:TextBox>%
<asp:Button ID="btnCalc" runat="server" Text="开始计算" OnClick="btnCalc_Click" /></asp:Panel>
</td>
</tr>
</table>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:keke100ConnectionString %>"
SelectCommand="select * FROM dbo.f_StatDeEmRecruit(@de_ID,@EmployeeID,@d1,@d2,@p,@q)">
<SelectParameters>
<asp:QueryStringParameter Name="de_ID" QueryStringField="de_ID" />
<asp:SessionParameter Name="EmployeeID" SessionField="LoginID" />
<asp:QueryStringParameter Name="d1" QueryStringField="d1" />
<asp:QueryStringParameter Name="d2" QueryStringField="d2" />
<asp:Parameter DefaultValue="0.03" Name="p" />
<asp:Parameter DefaultValue="0.0" Name="q" />
</SelectParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -