DEV 主从表

最新推荐文章于 2022-02-20 18:04:40 发布

淡悸优伤

最新推荐文章于 2022-02-20 18:04:40 发布

阅读量1.3k

点赞数

分类专栏：人生

本文链接：https://blog.csdn.net/ge19920611/article/details/46372155

版权

人生专栏收录该内容

5 篇文章 0 订阅

订阅专栏

.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OrdersConfirm.aspx.cs" Inherits="Admin_Pages_OrdersConfirm" %>

<%@ Register Assembly="DevExpress.Web.v10.2, Version=10.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxPopupControl" TagPrefix="dxpc" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dxe" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dxwgv" %>
<!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>NAIP订单确认</title>
<link href="../../App_Themes/style_css.css" rel="stylesheet" type="text/css" />
<script language="javascript" type="text/javascript">
function CustomButtonClick(s, e) {
if (e.buttonID == "ConfirmOrder") {
if (confirm('您确认此订单吗？')) {
e.processOnServer = true;
}
else {
e.processOnServer = false;
}
}
if (e.buttonID == "CancelConfirmOrder") {
if (confirm('您确认取消确认的订单吗？')) {
// txtOrderID.SetText(e.visibleIndex);
// Hidden1.SetText('0');
// popResult.SetHeaderText("取消原因");
// popResult.Show();

e.processOnServer = true;

}
else {
e.processOnServer = false;
}
}

if (e.buttonID == "ReturnOrder") {
if (confirm('您确认打回此订单吗？')) {
txtOrderID.SetText(e.visibleIndex);
//Hidden1.SetText('1');
popResult.SetHeaderText("打回订单原因");
popResult.Show();
e.processOnServer = false;
}
else {
e.processOnServer = false;
}
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<h5>
<span>NAIP订单确认</span>
</h5>
<div class="blank">
</div>
<dxe:ASPxTextBox ID="txtVisibleIndex" runat="server" ClientInstanceName="txtOrderID"
ClientVisible="false">
</dxe:ASPxTextBox>
<dxpc:ASPxPopupControl ID="popResult" runat="server" AllowDragging="True" AllowResize="True"
EnableViewState="False" ShowFooter="false" PopupHorizontalAlign="WindowCenter"
PopupVerticalAlign="WindowCenter" Width="400px" Height="350px" Modal="true" HeaderText="取消确认原因"
CloseAction="CloseButton" ClientInstanceName="popResult" EnableHierarchyRecreation="True">
<ContentStyle>
<Paddings Padding="0px"></Paddings>
</ContentStyle>
<ContentCollection>
<dxpc:PopupControlContentControl runat="server">
<table style="width: 350px">
<tr>
<td colspan="3">
<dxe:ASPxMemo ID="ASPxMemo1" runat="server" Height="273px" Width="399px" ClientInstanceName="ASPxMemo1">
</dxe:ASPxMemo>
</td>
</tr>
<tr>
<td style="width: 280px">
</td>
<td style="text-align: right;">
<dxe:ASPxButton ID="btnReturnOrder" runat="server" Text="确定" OnClick="btnReturnOrder_Click">
<ClientSideEvents Click="function(s, e) {popResult.Hide();}" />
</dxe:ASPxButton>
</td>
<td style="text-align: center;">
<dxe:ASPxButton ID="btnCancel" runat="server" Text="取消" AutoPostBack="False">
<ClientSideEvents Click="function(s, e) {popResult.Hide();}" />
</dxe:ASPxButton>
</td>
</tr>
</table>
</dxpc:PopupControlContentControl>
</ContentCollection>
<ClientSideEvents PopUp="function(s,e){ASPxMemo1.SetText('');}" />
</dxpc:ASPxPopupControl>
<div>
<asp:RadioButtonList ID="rbType" runat="server" RepeatDirection="Horizontal" AutoPostBack="True">
<asp:ListItem Text="所有未确认订单" Value="所有未确认订单" Selected="True" />
<asp:ListItem Text="所有已确认订单" Value="所有已确认订单" />
</asp:RadioButtonList>
<div class="blank">
</div>
未确认订单<asp:Label ID="lblNum" runat="server"></asp:Label>条
<dxwgv:ASPxGridView ID="gvOrders" runat="server" ClientInstanceName="gvOrders" AutoGenerateColumns="False"
Width="100%" KeyFieldName="ORDERS_ID" OnSelectionChanged="gvOrders_SelectionChanged"
OnCustomButtonCallback="gvOrders_CustomButtonCallback" OnHtmlRowPrepared="gvOrders_HtmlRowPrepared">
<ClientSideEvents CustomButtonClick="CustomButtonClick" />
<Columns>
<dxwgv:GridViewDataTextColumn Caption="序号" VisibleIndex="0">
<DataItemTemplate>
<%# Container.ItemIndex / (gvOrders.GroupCount + 1) + 1%>
</DataItemTemplate>
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewCommandColumn Caption="确认" VisibleIndex="1" CellStyle-HorizontalAlign="Left"
Width="100px">
<CustomButtons>
<dxwgv:GridViewCommandColumnCustomButton ID="ConfirmOrder" Text="确认">
</dxwgv:GridViewCommandColumnCustomButton>
<dxwgv:GridViewCommandColumnCustomButton ID="ReturnOrder" Text="打回订单">
</dxwgv:GridViewCommandColumnCustomButton>
</CustomButtons>
</dxwgv:GridViewCommandColumn>
<dxwgv:GridViewCommandColumn Caption="取消确认" VisibleIndex="2" CellStyle-HorizontalAlign="Left"
Width="80px">
<CustomButtons>
<dxwgv:GridViewCommandColumnCustomButton ID="CancelConfirmOrder" Text="取消确认">
</dxwgv:GridViewCommandColumnCustomButton>
</CustomButtons>
</dxwgv:GridViewCommandColumn>
<dxwgv:GridViewDataTextColumn Caption="订单编号" VisibleIndex="3" FieldName="TXT_ORDER_CODE">
<%-- <DataItemTemplate>
<a id="A1" href="javascript:void(0);" οnclick="OnMoreInfoClick(this, '<%# Container.KeyValue %>')">
<%# Eval("TXT_ORDER_CODE")%>
</a>
</DataItemTemplate>--%>
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="所在单位" VisibleIndex="4" FieldName="TXT_RECEIVERCOMPANY"
Width="200px">
<Settings AutoFilterCondition="Contains" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="总公司" VisibleIndex="5" FieldName="TXT_RECEIVER_HEADOFFICE"
Width="200px">
<Settings AutoFilterCondition="Contains" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="订购人" VisibleIndex="6" FieldName="TXT_RECEIVERNAME" />
<dxwgv:GridViewDataTextColumn Caption="订单提交时间" VisibleIndex="7" FieldName="DATE_SUBMIT" />
<dxwgv:GridViewDataTextColumn Caption="确认人员" VisibleIndex="8" FieldName="TXT_CONFIRMNAME" />
<dxwgv:GridViewDataTextColumn Caption="确认时间" VisibleIndex="7" FieldName="DATE_CONFIRMED" />
<dxwgv:GridViewDataTextColumn Caption="总额" VisibleIndex="9" FieldName="VAL_TOTALPRICE" />
<dxwgv:GridViewDataTextColumn Caption="明细" VisibleIndex="10" Width="30px">
<DataItemTemplate>
<a href="../../Report/UserReport.aspx?key=<%# new Business.OrderManager().URLEncode( SiniSwi.WebCore.Utils.GetString (Eval("ORDERS_ID")) ) %>"
target="Pub_ProductReport">明细 </a>
</DataItemTemplate>
<Settings AllowGroup="False" AllowSort="False" />
</dxwgv:GridViewDataTextColumn>
</Columns>
<Settings ShowGroupPanel="True" ShowTitlePanel="True" ShowFilterRow="True" ShowFooter="True" />
<SettingsPager PageSize="20" />
<%--20150604 GYF insert start--%>
<SettingsDetail ShowDetailRow="True" />
<Templates>
<DetailRow>
<h5>
<span>该用户所有未付款订单</span>
</h5>
<br />
<%--OnBeforePerformDataSelect="gvDetilOrders_BeforePerformDataSelect" DataSourceID="detilDataSource"--%>
<dxwgv:ASPxGridView ID="gvDetilOrders" runat="server" AutoGenerateColumns="False"
OnDataBinding="gvDetilOrders_DataBinding" Width="100%" KeyFieldName="ORDERS_ID">
<SettingsDetail IsDetailGrid="true" ExportIndex="0" />
<Columns>
<dxwgv:GridViewDataTextColumn Caption="序号" VisibleIndex="0">
<DataItemTemplate>
<%# Container.ItemIndex / (gvOrders.GroupCount + 1) + 1%>
</DataItemTemplate>
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="订单编号" VisibleIndex="3" FieldName="TXT_ORDER_CODE">
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="所在单位" VisibleIndex="4" FieldName="TXT_RECEIVERCOMPANY"
Width="200px">
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="总公司" VisibleIndex="5" FieldName="TXT_RECEIVER_HEADOFFICE"
Width="200px">
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="订购人" VisibleIndex="6" FieldName="TXT_RECEIVERNAME" />
<dxwgv:GridViewDataTextColumn Caption="订单提交时间" VisibleIndex="7" FieldName="DATE_SUBMIT" />
<dxwgv:GridViewDataTextColumn Caption="确认人员" VisibleIndex="8" FieldName="TXT_CONFIRMNAME" />
<dxwgv:GridViewDataTextColumn Caption="确认时间" VisibleIndex="9" FieldName="DATE_CONFIRMED" />
<dxwgv:GridViewDataTextColumn Caption="总额" VisibleIndex="10" FieldName="VAL_TOTALPRICE" />
</Columns>
</dxwgv:ASPxGridView>
</DetailRow>
</Templates>
</dxwgv:ASPxGridView>
<%--<asp:ObjectDataSource ID="detilDataSource" runat="server" SelectMethod="GetMyCar"
DataObjectTypeName="Admin_Pages_OrdersConfirm">
<SelectParameters>
<asp:SessionParameter Name="ORDERS_ID" SessionField="ID123" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>--%>
<%--<asp:ObjectDataSource ID="objDs" runat="server" ></asp:ObjectDataSource>--%>
<%--20150604 GYF insert end--%>
</div>
</form>
</body>
</html>

.aspx.cs

protected void gvDetilOrders_DataBinding(object sender, EventArgs e)
{
ASPxGridView gvDetilOrders = sender as ASPxGridView;
int ORDERS_ID = Convert.ToInt32(Utils.GetString(gvDetilOrders.GetMasterRowFieldValues("ORDERS_ID")));
DataTable dtConfirms = new OrderManager().GetNotPayOrders(EnvironmentSettings.Dataversion, ORDERS_ID);

gvDetilOrders.DataSource = dtConfirms;
}