<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PlaceMaterial.aspx.cs" Inherits="iWareWms.View.SL.PlaceMaterial.PlaceMaterial" %>
|
|
<!DOCTYPE html>
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
<head runat="server">
|
<meta http-equiv="Content-Type" content="~\View\BCD\BarcodeTemplate\BarcodeTemplatePropData.ashx" />
|
<style>
|
.mytable {
|
border-width: 1px;
|
border-style: solid;
|
border-collapse: separate;
|
border-spacing: 0;
|
border-bottom-width: 0;
|
border-right-width: 0;
|
}
|
|
.mytable th,
|
.mytable td {
|
padding: 5px;
|
text-align: left;
|
border-bottom-width: 1px;
|
border-bottom-style: solid;
|
border-right-width: 1px;
|
border-right-style: solid;
|
width: 100px;
|
}
|
</style>
|
<title></title>
|
</head>
|
<body>
|
<form id="form1" runat="server">
|
<f:PageManager ID="PageManager1" AutoSizePanelID="Panel1" runat="server">
|
</f:PageManager>
|
<f:Panel ID="Panel1" runat="server" Layout="VBox" ShowBorder="false" ShowHeader="false">
|
<Items>
|
<f:Form ID="Form2" runat="server" BodyPadding="5px" ShowBorder="false" ShowHeader="false">
|
<Rows>
|
<f:FormRow runat="server">
|
<Items>
|
<f:TextBox ID="tbName" Label="物料名称" runat="server" EmptyText="在物料名称中搜索" NextFocusControl="SearchBtn" LabelWidth="80px">
|
</f:TextBox>
|
<f:TextBox ID="tbMaterialCode" Label="物料编号" runat="server" EmptyText="在物料编号中搜索" NextFocusControl="SearchBtn" LabelWidth="80px">
|
</f:TextBox>
|
|
</Items>
|
</f:FormRow>
|
<f:FormRow runat="server">
|
<Items>
|
<%-- <f:DropDownList ID="ddlTypeName" runat="server" Label="物料类型" AutoPostBack="true" LabelWidth="80px" OnSelectedIndexChanged="Search" AutoSelectFirstItem="true">
|
</f:DropDownList>--%>
|
<f:TextBox ID="tbPlaceCode" Label="所属库位" runat="server" EmptyText="在库位编号中搜索" NextFocusControl="SearchBtn" LabelWidth="80px">
|
</f:TextBox>
|
<f:Button ID="Button1" runat="server" Text="搜索" OnClick="Search" IconAlign="Right"></f:Button>
|
</Items>
|
</f:FormRow>
|
<%-- <f:FormRow runat="server">
|
<Items>
|
<f:DropDownList ID="ddlPlaceTypeName" runat="server" Label="库位类型" AutoPostBack="true" NextFocusControl="SearchBtn" LabelWidth="80px" OnSelectedIndexChanged="Search" AutoSelectFirstItem="true">
|
</f:DropDownList>
|
<<f:DropDownList ID="ddlMaterialType" runat="server" Label="所属大类" AutoPostBack="true" NextFocusControl="SearchBtn" LabelWidth="80px" OnSelectedIndexChanged="Search" AutoSelectFirstItem="true">
|
</f:DropDownList>
|
|
</Items>
|
</f:FormRow>--%>
|
</Rows>
|
</f:Form>
|
|
<f:Grid ID="PlaceGrid" runat="server" AllowPaging="true" IsDatabasePaging="true" BoxFlex="1"
|
DataKeyNames="Id" AllowSorting="true" SortField="Id" QuickPaging="true" MouseWheelSelection="true"
|
ShowBorder="true" OnRowCommand="GridRowCommand" OnPageIndexChange="GridPageIndexChange" ForceFit="true"
|
KeepCurrentSelection="true" EnableRowLines="True" DataIDField="Id" ShowSelectedCell="False"
|
ShowHeader="false" EnableCheckBoxSelect="true" ExpandAllRowExpanders="false" EnableTextSelection="true" >
|
|
<Toolbars>
|
<f:Toolbar runat="server">
|
<Items>
|
<f:ToolbarFill ID="ToolbarFill1" runat="server"></f:ToolbarFill>
|
|
<f:Button ID="btnClar" runat="server" Icon="Delete" Text="清除选中物料信息" OnClick="Delete" Hidden="false"></f:Button>
|
<f:Button ID="btnOut" runat="server" Icon="SoundOut" Text="物料信息出库" OnClick="btnOut_Click" ></f:Button>
|
<f:Button ID="ToExcel" EnableAjax="false" Icon="ApplicationOsxGet"
|
runat="server" Text="导出Excel" OnClick="ExportExcel">
|
</f:Button>
|
</Items>
|
</f:Toolbar>
|
</Toolbars>
|
|
<Columns>
|
<f:RowNumberField MinWidth="24px" HeaderText="" EnablePagingNumber="true" TextAlign="Left"/>
|
<f:BoundField DataField="Id" MinWidth="100px" HeaderText="库位物料Id" Hidden="true" />
|
<f:BoundField DataField="PlaceCode" MinWidth="100px" HeaderText="库位编号" />
|
<f:BoundField DataField="PlaceTypeName" MinWidth="120px" HeaderText=" 库位类型" />
|
<f:BoundField DataField="PlaceTypeRemark" MinWidth="120px" HeaderText="库位类型描述" />
|
<f:BoundField DataField="MaterialCode" MinWidth="200px" HeaderText="物料编号" />
|
<f:BoundField DataField="Name" MinWidth="120px" HeaderText="物料名称" />
|
<f:BoundField DataField="TypeName" MinWidth="120px" HeaderText="物料类型" />
|
<f:BoundField DataField="TypeRemark" MinWidth="120px" HeaderText="物料类型描述" />
|
<f:BoundField DataField="UpdateTime" MinWidth="180px" HeaderText="更新时间" />
|
<f:BoundField DataField="CreateTime" MinWidth="180px" HeaderText="创建时间" />
|
<f:TemplateField MinWidth="128px" HeaderText="库位状态" SortField="Status">
|
<ItemTemplate>
|
<asp:Label ID="Status" runat="server" Text='<%# GetStatus(Eval("Status")) %>'></asp:Label>
|
</ItemTemplate>
|
</f:TemplateField>
|
<f:TemplateField MinWidth="128px" HeaderText="是否锁定" SortField="IsLock" Hidden="true">
|
<ItemTemplate>
|
<asp:Label ID="IsLock" runat="server" Text='<%# GetEYesOrNo(Eval("Status")) %>'></asp:Label>
|
</ItemTemplate>
|
</f:TemplateField>
|
<f:TemplateField MinWidth="128px" HeaderText="是否满库" SortField="IsExecute" Hidden="true">
|
<ItemTemplate>
|
<asp:Label ID="IsExecute" runat="server" Text='<%# GetYesOrNo(Eval("IsExecute")) %>'></asp:Label>
|
</ItemTemplate>
|
</f:TemplateField>
|
</Columns>
|
|
<Listeners>
|
<f:Listener Event="rowexpanderexpand" Handler="onRowExpanderExpand" />
|
<f:Listener Event="rowexpandercollapse" Handler="onRowExpanderCollapse" />
|
</Listeners>
|
|
<PageItems>
|
<f:ToolbarSeparator ID="ToolbarSeparator1" runat="server"></f:ToolbarSeparator>
|
<f:ToolbarText ID="ToolbarText1" runat="server"></f:ToolbarText>
|
<f:DropDownList ID="ddlPageSize" runat="server" Label="每页记录数" OnSelectedIndexChanged="PageSizeSelectedIndexChanged" AutoPostBack="true">
|
<f:ListItem Text="8" Value="8" />
|
<f:ListItem Text="10" Value="10" />
|
<f:ListItem Text="15" Value="15" />
|
<f:ListItem Text="20" Value="20" />
|
</f:DropDownList>
|
</PageItems>
|
|
</f:Grid>
|
</Items>
|
|
</f:Panel>
|
|
<f:Window ID="Window1" runat="server" IsModal="true" Hidden="true" Target="Top" EnableResize="true"
|
EnableMaximize="true" EnableIFrame="true" IFrameUrl="about:blank" Width="220px"
|
Height="120px" OnClose="WindowClose">
|
</f:Window>
|
|
<f:Timer OnTick="ExcelTick" runat="server" Enabled="false" Interval="1" ID="timer1"></f:Timer>
|
|
</form>
|
<script>
|
|
var grid1 = '<%= PlaceGrid.ClientID %>';
|
|
|
function onRowExpanderExpand(event, rowId) {
|
debugger
|
var grid = this, rowEl = grid.getRowEl(rowId), rowData = grid.getRowData(rowId);
|
|
var tplEl = rowEl.find('.f-grid-rowexpander-details .f-grid-tpl');
|
|
if (!tplEl.text().trim()) {
|
|
var placeid = grid.getRowData(rowId).values["Panel1_PlaceGrid_ctl01"];
|
var data;
|
var props = rowData.values.Materials + "";
|
var beginPos = props.indexOf("[");
|
var endPos = props.lastIndexOf("]");
|
var cmd = "data=" + props.substring(beginPos, endPos + 1) + ";";
|
eval(cmd);
|
debugger
|
var headerTitles = ["物料编号", "物料名称", "条码", "数量", "采购单号", "批次", "供应商","备注", "托盘号"];
|
var htmlString = '<th class="f-widget-header">';
|
for (var i = 0; i < headerTitles.length; i++) {
|
htmlString += i == headerTitles.length - 1 ? headerTitles[i] + '</th>' : headerTitles[i] + '</th><th class="f-widget-header">';
|
}
|
|
var html = [];
|
html.push('<table class="mytable f-widget-header"><tr>' + htmlString + '</tr>');
|
debugger;
|
var containName = "";
|
for (var i = 0; i < data.length; i++) {
|
html.push('<tr>');
|
html.push('<td class="f-widget-content">' + data[i].Code + '</td>');
|
html.push('<td class="f-widget-content">' + data[i].Name + '</td>');
|
html.push('<td class="f-widget-content">' + data[i].Barcode.substring(0,10) + '...</td>');
|
html.push('<td class="f-widget-content">' + data[i].Quantity + '</td>');
|
html.push('<td class="f-widget-content">' + data[i].ListNo + '</td>');
|
html.push('<td class="f-widget-content">' + data[i].SerialNo + '</td>');
|
html.push('<td class="f-widget-content">' + data[i].Supplier + '</td>');
|
html.push('<td class="f-widget-content">' + data[i].Remark + '</td>');
|
html.push('<td class="f-widget-content">' + data[i].ContainerCode + '</td>');
|
html.push('</tr>');
|
|
}
|
html.push('</table>');
|
tplEl.html(html.join(''));
|
rowExpandersDoLayout();
|
}
|
}
|
|
|
function onRowExpanderCollapse(event, rowId) {
|
rowExpandersDoLayout();
|
}
|
|
// 重新布局表格(解决出现纵向滚动条时的布局问题)
|
function rowExpandersDoLayout() {
|
var grid1Cmp = F(grid1);
|
grid1Cmp.doLayout();
|
}
|
|
</script>
|
|
</body>
|
</html>
|