2024-09-18 10:48:34 +08:00
|
|
|
|
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ArrivalStatistics.aspx.cs" Inherits="FineUIPro.Web.CLGL.ArrivalStatistics" %>
|
|
|
|
|
|
|
|
|
|
|
|
<!DOCTYPE html>
|
|
|
|
|
|
|
|
|
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
|
|
|
|
<head runat="server">
|
|
|
|
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
|
|
|
|
<title>到货统计分析</title>
|
|
|
|
|
|
<link href="../../res/css/common.css" rel="stylesheet" type="text/css" />
|
|
|
|
|
|
<style type="text/css">
|
|
|
|
|
|
.f-grid-row .f-grid-cell-inner {
|
|
|
|
|
|
white-space: normal;
|
|
|
|
|
|
word-break: break-all;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
.f-grid-row.yellow {
|
|
|
|
|
|
background-color: YellowGreen;
|
|
|
|
|
|
background-image: none;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
.f-grid-row.red {
|
2024-12-06 22:17:50 +08:00
|
|
|
|
background-color: red;
|
2024-09-18 10:48:34 +08:00
|
|
|
|
}
|
|
|
|
|
|
</style>
|
|
|
|
|
|
</head>
|
|
|
|
|
|
<body>
|
|
|
|
|
|
<form id="form1" runat="server">
|
|
|
|
|
|
<f:PageManager ID="PageManager1" AutoSizePanelID="Panel1" runat="server" />
|
|
|
|
|
|
<f:Panel ID="Panel1" runat="server" Margin="5px" BodyPadding="5px" ShowBorder="false" AutoScroll="true"
|
|
|
|
|
|
ShowHeader="false" Layout="VBox" BoxConfigAlign="Stretch">
|
|
|
|
|
|
<Items>
|
|
|
|
|
|
<f:Grid ID="Grid1" ShowBorder="true" ShowHeader="false" Title="到货统计分析表" EnableCollapse="true"
|
2024-09-27 18:17:21 +08:00
|
|
|
|
runat="server" BoxFlex="1" DataKeyNames="MaterialCode" AllowCellEditing="true" ForceFit="true"
|
2024-09-18 10:48:34 +08:00
|
|
|
|
ClicksToEdit="2" DataIDField="MaterialCode" AllowSorting="true" SortField="MaterialCode"
|
|
|
|
|
|
SortDirection="DESC" OnSort="Grid1_Sort" EnableColumnLines="true"
|
|
|
|
|
|
AllowPaging="true" IsDatabasePaging="true" PageSize="10" OnPageIndexChange="Grid1_PageIndexChange">
|
|
|
|
|
|
<Toolbars>
|
|
|
|
|
|
<f:Toolbar ID="Toolbar2" Position="Top" runat="server" ToolbarAlign="Right">
|
|
|
|
|
|
<Items>
|
2024-10-10 10:06:11 +08:00
|
|
|
|
<f:DropDownList ID="drpWarehouse" runat="server" Label="仓库" AutoSelectFirstItem="true"
|
|
|
|
|
|
LabelWidth="70px" LabelAlign="Right" Width="170px">
|
|
|
|
|
|
</f:DropDownList>
|
2024-10-09 17:20:12 +08:00
|
|
|
|
<f:TextBox runat="server" ID="txtMaterialCode" Label="材料编码" EmptyText="输入查询条件" Width="230px" LabelWidth="100px"></f:TextBox>
|
2025-02-19 17:48:46 +08:00
|
|
|
|
<f:CheckBox runat="server" ID="cbIsItAPerfectMatch" Label="仅未完全匹配材料" LabelWidth="150px"></f:CheckBox>
|
2024-09-27 18:17:21 +08:00
|
|
|
|
<f:Label runat="server" ID="lbRate"></f:Label>
|
2024-09-18 10:48:34 +08:00
|
|
|
|
<f:ToolbarFill ID="ToolbarFill1" runat="server">
|
|
|
|
|
|
</f:ToolbarFill>
|
|
|
|
|
|
<f:Button ID="btnSearch" ToolTip="查询" Icon="SystemSearch" runat="server" Text="查询" OnClick="btnSearch_Click">
|
|
|
|
|
|
</f:Button>
|
|
|
|
|
|
<f:Button ID="btnOut" OnClick="btnOut_Click" runat="server" Text="导出" ToolTip="导出" Icon="FolderUp"
|
|
|
|
|
|
EnableAjax="false" DisableControlBeforePostBack="false">
|
|
|
|
|
|
</f:Button>
|
|
|
|
|
|
</Items>
|
|
|
|
|
|
</f:Toolbar>
|
|
|
|
|
|
</Toolbars>
|
|
|
|
|
|
<Columns>
|
|
|
|
|
|
<f:TemplateField ColumnID="tfNumber" Width="50px" HeaderText="序号" HeaderTextAlign="Center"
|
|
|
|
|
|
TextAlign="Center">
|
|
|
|
|
|
<ItemTemplate>
|
|
|
|
|
|
<asp:Label ID="lblNumber" runat="server" Text='<%# Grid1.PageIndex * Grid1.PageSize + Container.DataItemIndex + 1 %>'></asp:Label>
|
|
|
|
|
|
</ItemTemplate>
|
|
|
|
|
|
</f:TemplateField>
|
|
|
|
|
|
<f:RenderField Width="150px" ColumnID="MaterialCode" DataField="MaterialCode" SortField="MaterialCode"
|
|
|
|
|
|
FieldType="String" HeaderText="材料编码" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
|
|
|
|
|
<f:RenderField Width="150px" ColumnID="MaterialName" DataField="MaterialName" SortField="MaterialName"
|
|
|
|
|
|
FieldType="String" HeaderText="类型" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
2024-09-27 18:17:21 +08:00
|
|
|
|
<f:RenderField Width="300px" ColumnID="MaterialDef" DataField="MaterialDef" SortField="MaterialDef"
|
|
|
|
|
|
FieldType="String" HeaderText="材料描述" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
2024-09-18 10:48:34 +08:00
|
|
|
|
<f:RenderField Width="150px" ColumnID="MaterialSpec" DataField="MaterialSpec" SortField="MaterialSpec"
|
|
|
|
|
|
FieldType="String" HeaderText="规格" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
2024-10-10 10:06:11 +08:00
|
|
|
|
<f:RenderField Width="80px" ColumnID="MaterialUnit" DataField="MaterialUnit" SortField="MaterialUnit"
|
2024-09-18 10:48:34 +08:00
|
|
|
|
FieldType="String" HeaderText="单位" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
2024-10-10 10:06:11 +08:00
|
|
|
|
<f:RenderField Width="90px" ColumnID="NeedNum" DataField="NeedNum" SortField="NeedNum"
|
2024-09-18 10:48:34 +08:00
|
|
|
|
FieldType="String" HeaderText="所需量" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
2024-10-10 10:06:11 +08:00
|
|
|
|
<f:RenderField Width="90px" ColumnID="RealNum" DataField="RealNum" SortField="RealNum"
|
2024-09-18 10:48:34 +08:00
|
|
|
|
FieldType="String" HeaderText="到货量" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
2024-10-10 10:06:11 +08:00
|
|
|
|
<f:RenderField Width="90px" ColumnID="StockNum" DataField="StockNum" SortField="StockNum"
|
2024-10-09 17:20:12 +08:00
|
|
|
|
FieldType="String" HeaderText="库存量" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
2024-10-10 10:06:11 +08:00
|
|
|
|
<f:RenderField Width="90px" ColumnID="MatchRateString" DataField="MatchRateString" SortField="MatchRateString"
|
2024-09-27 18:17:21 +08:00
|
|
|
|
FieldType="String" HeaderText="匹配率" TextAlign="Left" HeaderTextAlign="Center">
|
|
|
|
|
|
</f:RenderField>
|
2024-09-18 10:48:34 +08:00
|
|
|
|
</Columns>
|
|
|
|
|
|
<%-- <Listeners>
|
|
|
|
|
|
<f:Listener Event="beforerowcontextmenu" Handler="onRowContextMenu" />
|
|
|
|
|
|
</Listeners>--%>
|
|
|
|
|
|
<PageItems>
|
|
|
|
|
|
<f:ToolbarSeparator ID="ToolbarSeparator1" runat="server">
|
|
|
|
|
|
</f:ToolbarSeparator>
|
|
|
|
|
|
<f:ToolbarText ID="ToolbarText1" runat="server" Text="每页记录数：">
|
|
|
|
|
|
</f:ToolbarText>
|
|
|
|
|
|
<f:DropDownList runat="server" ID="ddlPageSize" Width="80px" AutoPostBack="true"
|
|
|
|
|
|
OnSelectedIndexChanged="ddlPageSize_SelectedIndexChanged">
|
|
|
|
|
|
<f:ListItem Text="10" Value="10" />
|
|
|
|
|
|
<f:ListItem Text="15" Value="15" />
|
|
|
|
|
|
<f:ListItem Text="20" Value="20" />
|
|
|
|
|
|
<f:ListItem Text="25" Value="25" />
|
|
|
|
|
|
<f:ListItem Text="所有行" Value="100000" />
|
|
|
|
|
|
</f:DropDownList>
|
|
|
|
|
|
</PageItems>
|
|
|
|
|
|
</f:Grid>
|
|
|
|
|
|
</Items>
|
|
|
|
|
|
</f:Panel>
|
|
|
|
|
|
<f:Window ID="Window1" runat="server" Hidden="true" ShowHeader="true"
|
|
|
|
|
|
IsModal="true" Target="Parent" EnableMaximize="true" EnableResize="true" OnClose="Window1_Close"
|
|
|
|
|
|
Title="编辑Tw_MaterialStock" EnableIFrame="true" Height="650px"
|
|
|
|
|
|
Width="1200px">
|
|
|
|
|
|
</f:Window>
|
|
|
|
|
|
<%-- <f:Menu ID="Menu1" runat="server">
|
|
|
|
|
|
<f:MenuButton ID="btnMenuEdit" OnClick="btnEdit_Click" EnablePostBack="true"
|
|
|
|
|
|
Hidden="true" runat="server" Text="编辑" Icon="TableEdit" >
|
|
|
|
|
|
</f:MenuButton>
|
|
|
|
|
|
<f:MenuButton ID="btnMenuDelete" OnClick="btnDelete_Click" EnablePostBack="true" Icon="Delete"
|
|
|
|
|
|
Hidden="true" ConfirmText="删除选中行？" ConfirmTarget="Parent" runat="server" Text="删除">
|
|
|
|
|
|
</f:MenuButton>
|
|
|
|
|
|
</f:Menu>--%>
|
|
|
|
|
|
</form>
|
|
|
|
|
|
<script type="text/javascript">
|
|
|
|
|
|
<%-- var menuID = '<%= Menu1.ClientID %>';
|
|
|
|
|
|
// 返回false，来阻止浏览器右键菜单
|
|
|
|
|
|
function onRowContextMenu(event, rowId) {
|
|
|
|
|
|
F(menuID).show(); //showAt(event.pageX, event.pageY);
|
|
|
|
|
|
return false;
|
|
|
|
|
|
}--%>
|
|
|
|
|
|
function reloadGrid() {
|
|
|
|
|
|
__doPostBack(null, 'reloadGrid');
|
|
|
|
|
|
}
|
|
|
|
|
|
</script>
|
|
|
|
|
|
</body>
|
|
|
|
|
|
</html>
|
|
|
|
|
|
|
