📄 dailymoney.aspx
字号:
<%@ 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>
当前时间： <asp:Label ID="LbShowToday" runat="server" Text="Label"></asp:Label></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" DataSourceID="SqlDataSource1"
GridLines="Vertical" AllowPaging="True" AllowSorting="True" Height="249px" Width="806px">
<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" />
<Columns>
<asp:BoundField DataField="ListId" HeaderText="供应单编号" InsertVisible="False" ReadOnly="True"
SortExpression="ListId" />
<asp:BoundField DataField="ProducesKinds" HeaderText="产品种类" SortExpression="ProducesKinds" ReadOnly="True"/>
<asp:BoundField DataField="ProducesName" HeaderText="产品名称" SortExpression="ProducesName" ReadOnly="True"/>
<asp:BoundField DataField="NeedNum" HeaderText="供应数量" SortExpression="NeedNum" ReadOnly="True"/>
<asp:BoundField DataField="ListDateTime" HeaderText="入库时间" SortExpression="ListDateTime" ReadOnly="True" />
<asp:BoundField DataField="AffordMoney" HeaderText="应付资金" SortExpression="AffordMoney" ReadOnly="True"/>
<asp:BoundField DataField="WorkerName" HeaderText="数据处理员" SortExpression="WorkerName" ReadOnly="True"/>
<asp:BoundField DataField="ListMoreInfo" HeaderText="备注信息" SortExpression="ListMoreInfo" />
<asp:BoundField DataField="SupplyCompanyName" HeaderText="供应公司" SortExpression="SupplyCompanyName" ReadOnly="True"/>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT * FROM ProducesKind ,Produces, SupplyList , Cklist, SupplyCompany , WorkersList where Produces.ProducesKindId=ProducesKind.ProducesKindId and cklist.ckid=supplylist.ckid and workerslist.workerslistid=supplylist.workerslistid and supplylist.producesid=produces.producesid and supplycompany.supplyid=supplylist.supplyid and(CONVERT (VARCHAR(20), ListDateTime, 120) >= @begintime) AND (CONVERT (VARCHAR(10), ListDateTime, 120) <= @endtime)">
<SelectParameters>
<asp:ControlParameter ControlID="SearchBeginTime" DefaultValue="System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")"
Name="begintime" PropertyName="Text" />
<asp:ControlParameter ControlID="SearchEndTime" DefaultValue="System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")"
Name="endtime" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
合计：<br />
<br />
总金额：<asp:Label ID="LbCaiGouAllMon" runat="server" Text="Label" Width="181px"></asp:Label> 元
<hr /></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>
<br />
合计：<br />
<br />
总金额：<asp:Label ID="LbZhiChuAllMon" runat="server" Text="Label" Width="181px"></asp:Label> 元
<hr /> </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="SqlDataSource3" GridLines="Vertical" DataKeyNames="SellListId"
Height="226px" Width="439px">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<Columns>
<asp:BoundField DataField="SellListId" HeaderText="SellListId" InsertVisible="False"
ReadOnly="True" SortExpression="SellListId" />
<asp:BoundField DataField="ProducesName" HeaderText="ProducesName" SortExpression="ProducesName" />
<asp:BoundField DataField="SellNum" HeaderText="SellNum" SortExpression="SellNum" />
<asp:BoundField DataField="WorkerName" HeaderText="WorkerName" SortExpression="WorkerName" />
<asp:BoundField DataField="SellDateTime" HeaderText="SellDateTime" SortExpression="SellDateTime" />
</Columns>
<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="#DCDCDC" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT * FROM Produces,SellList,WorkersList where SellList.WorkersListId = WorkersList.WorkersListId and Produces.ProducesId = SellList.ProducesId and (CONVERT (VARCHAR(20), SellDateTime, 120) >= @begintime) AND (CONVERT (VARCHAR(10), SellDateTime, 120) <= @endtime) ">
<SelectParameters>
<asp:ControlParameter ControlID="SearchBeginTime" Name="begintime" PropertyName="Text" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")" />
<asp:ControlParameter ControlID="SearchEndTime" Name="endtime" PropertyName="Text" DefaultValue="System.DateTime.Now.ToString("yyyymmdd")" />
</SelectParameters>
</asp:SqlDataSource>
<br />
合计：
总金额：<asp:Label ID="LbSellAllMon" runat="server" Text="Label" Width="181px"></asp:Label> 元
<hr />
</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 (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>
<br />
合计：
总金额：<asp:Label ID="LbShouyiAllMon" runat="server" Text="Label" Width="181px"></asp:Label> 元
<hr />
</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" ForeColor="Black" Font-Size="Large"></asp:Label> 元</td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -