📄 kter.txt
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DailyMoney.aspx.cs" Inherits="Dailymon_DailyMoney" %>
<%@ Register Assembly="Common" Namespace="Common.Web.AppControl" TagPrefix="cc1" %>
<!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/css.css" rel="stylesheet" type="text/css" />
<script language="javascript" type="text/javascript">
<!--
function TABLE1_onclick() {
}
// -->
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
起始时间：<cc1:WebCalendar ID="SearchBeginTime" runat="server"></cc1:WebCalendar>截至时间： <cc1:WebCalendar ID="SearchEndTime" runat="server"></cc1:WebCalendar>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="报账查询" /><br />
<br />
<table border="0" cellspacing="0" cellpadding="0" style="width: 779px">
<tr>
<td style="width: 516px; height: 18px">
统计时间（默认是统计今日）：<asp:Label ID="LbShowTongBeing" runat="server" Text="Label"></asp:Label>
至
<asp:Label ID="LbShowTongEnd" runat="server" Text="Label"></asp:Label></td>
<td style="height: 18px">
当前时间：</td>
</tr>
<tr>
<td style="width: 516px"> <br />
采购情况<br />
<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" Height="136px" Width="435px" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="Gainsboro" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT SupplyCompany.SupplyCompanyName, SupplyList.ListId, Cklist.CkName, SupplyList.NeedNum, SupplyList.ListDateTime, SupplyList.AffordMoney, SupplyList.TruelyAfford, WorkersList.WorkerName, SupplyList.ListMoreInfo FROM SupplyCompany INNER JOIN SupplyList ON SupplyCompany.SupplyId = SupplyList.SupplyId INNER JOIN WorkersList ON SupplyList.WorkersListId = WorkersList.WorkersListId INNER JOIN Cklist ON SupplyList.CkId = Cklist.CkId AND WorkersList.WorkersListId = Cklist.WorkersListId WHERE (CONVERT (VARCHAR(20), ListDateTime, 120) >= @begintime) AND (CONVERT (VARCHAR(10), ListDateTime, 120) <= @endtime)">
<SelectParameters>
<asp:ControlParameter ControlID="SearchBeginTime" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")"
Name="begintime" PropertyName="Text" />
<asp:ControlParameter ControlID="SearchEndTime" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")"
Name="endtime" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
</td>
<td> 合计：<br />
<br />
总数量：<asp:Label ID="LbCaiGouNum" runat="server" Text="Label" Width="180px"></asp:Label><br />
总金额：<asp:Label ID="LbCaiGouAllMon" runat="server" Text="Label" Width="181px"></asp:Label></td>
</tr>
<tr>
<td style="width: 516px; height: 18px"> <br />
支出情况<br />
<asp:GridView ID="GridView2" runat="server" BackColor="LightGoldenrodYellow"
BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None"
Width="341px" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="MoneyMagId" DataSourceID="SqlDataSource2">
<FooterStyle BackColor="Tan" />
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<AlternatingRowStyle BackColor="PaleGoldenrod" />
<Columns>
<asp:BoundField DataField="MoneyMagId" HeaderText="MoneyMagId" InsertVisible="False"
ReadOnly="True" SortExpression="MoneyMagId" />
<asp:BoundField DataField="WorkerName" HeaderText="WorkerName" SortExpression="WorkerName" />
<asp:BoundField DataField="MoneyKindS" HeaderText="MoneyKindS" SortExpression="MoneyKindS" />
<asp:BoundField DataField="MoneyChang" HeaderText="MoneyChang" SortExpression="MoneyChang" />
<asp:BoundField DataField="JinChu" HeaderText="JinChu" SortExpression="JinChu" />
<asp:BoundField DataField="MoneyMagMoreInfo" HeaderText="MoneyMagMoreInfo" SortExpression="MoneyMagMoreInfo" />
<asp:BoundField DataField="MoneyMagDate" HeaderText="MoneyMagDate" SortExpression="MoneyMagDate" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT MoneyMag.MoneyMagId, WorkersList.WorkerName, MoneyKind.MoneyKindS, MoneyMag.MoneyChang, MoneyMag.JinChu, MoneyMag.MoneyMagMoreInfo, MoneyMag.MoneyMagDate FROM MoneyMag INNER JOIN MoneyKind ON MoneyMag.MoneyKindId = MoneyKind.MoneyKindId INNER JOIN WorkersList ON MoneyMag.WorkersListId = WorkersList.WorkersListId WHERE (CONVERT (VARCHAR(20), MoneyMag.MoneyMagDate, 120) >= @begintime) AND (CONVERT (VARCHAR(10), MoneyMag.MoneyMagDate, 120) <= @endtime) AND (MoneyMag.JinChu = '出款')">
<SelectParameters>
<asp:ControlParameter ControlID="SearchBeginTime" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")"
Name="begintime" PropertyName="Text" />
<asp:ControlParameter ControlID="SearchEndTime" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")"
Name="endtime" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
</td>
<td style="height: 18px">合计：<br />
<br />
总数量：<asp:Label ID="LbZhiChuNum" runat="server" Text="Label" Width="180px"></asp:Label><br />
总金额：<asp:Label ID="LbZhiChuAllMon" runat="server" Text="Label" Width="181px"></asp:Label></td>
</tr>
<tr>
<td style="width: 516px; height: 210px;"> <br />
销售情况<br />
<asp:GridView ID="GridView3" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource1" GridLines="Vertical"
Height="226px" Width="439px">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="Gainsboro" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT Produces.ProducesName, Produces.ProducesName AS Expr2, WorkersList.WorkerName, SellList.SellListId, SellList.SellNum, SellList.SellDateTime FROM Produces INNER JOIN SellList ON Produces.ProducesId = SellList.ProducesId INNER JOIN WorkersList ON SellList.WorkersListId = WorkersList.WorkersListId WHERE (CONVERT (VARCHAR(20), SellDateTime, 120) >= @begintime) AND (CONVERT (VARCHAR(10), SellDateTime, 120) <= @endtime)">
<SelectParameters>
<asp:ControlParameter ControlID="SearchBeginTime" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")"
Name="begintime" PropertyName="Text" />
<asp:ControlParameter ControlID="SearchEndTime" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")"
Name="endtime" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
</td>
<td style="height: 210px">合计：<br />
<br />
总数量：<asp:Label ID="LbSellNum" runat="server" Text="Label" Width="180px"></asp:Label><br />
总金额：<asp:Label ID="LbSellAllMon" runat="server" Text="Label" Width="181px"></asp:Label></td>
</tr>
<tr>
<td style="width: 516px; height: 200px">
收益情况<br />
<asp:GridView ID="GridView4" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan"
BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None" Width="338px" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="MoneyMagId" DataSourceID="SqlDataSource4">
<FooterStyle BackColor="Tan" />
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<AlternatingRowStyle BackColor="PaleGoldenrod" />
<Columns>
<asp:BoundField DataField="MoneyMagId" HeaderText="MoneyMagId" InsertVisible="False"
ReadOnly="True" SortExpression="MoneyMagId" />
<asp:BoundField DataField="WorkerName" HeaderText="WorkerName" SortExpression="WorkerName" />
<asp:BoundField DataField="MoneyKindS" HeaderText="MoneyKindS" SortExpression="MoneyKindS" />
<asp:BoundField DataField="MoneyChang" HeaderText="MoneyChang" SortExpression="MoneyChang" />
<asp:BoundField DataField="JinChu" HeaderText="JinChu" SortExpression="JinChu" />
<asp:BoundField DataField="MoneyMagMoreInfo" HeaderText="MoneyMagMoreInfo" SortExpression="MoneyMagMoreInfo" />
<asp:BoundField DataField="MoneyMagDate" HeaderText="MoneyMagDate" SortExpression="MoneyMagDate" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT MoneyMag.MoneyMagId, WorkersList.WorkerName, MoneyKind.MoneyKindS, MoneyMag.MoneyChang, MoneyMag.JinChu, MoneyMag.MoneyMagMoreInfo, MoneyMag.MoneyMagDate FROM MoneyMag INNER JOIN MoneyKind ON MoneyMag.MoneyKindId = MoneyKind.MoneyKindId INNER JOIN WorkersList ON MoneyMag.WorkersListId = WorkersList.WorkersListId WHERE (MoneyMag.JinChu = '出款')AND (CONVERT (VARCHAR(20), MoneyMag.MoneyMagDate, 120) >= @begintime) AND (CONVERT (VARCHAR(10), MoneyMag.MoneyMagDate, 120) <= @endtime)">
<SelectParameters>
<asp:ControlParameter ControlID="SearchBeginTime" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")"
Name="begintime" PropertyName="Text" />
<asp:ControlParameter ControlID="SearchEndTime" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")"
Name="endtime" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
</td>
<td style="height: 200px">
合计：<br />
<br />
总数量：<asp:Label ID="LbShouYiNum" runat="server" Text="Label" Width="180px"></asp:Label><br />
总金额：<asp:Label ID="LbShouYiAllMon" runat="server" Text="Label" Width="181px"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2"> 财务分析 ： 销售成本：<asp:Label ID="LbSellCost" runat="server" Height="42px" Text="Label"
Width="143px"></asp:Label>
销售利润：<asp:Label ID="LbSellLr" runat="server" Height="41px" Text="Label"
Width="146px"></asp:Label> 毛利润：<asp:Label ID="LbSellMaoLr" runat="server"
BackColor="#C00000" Height="41px" Text="Label" Width="133px"></asp:Label></td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -