显示详细信息

来源：互联网发布：如何分辨中日韩人知乎编辑：程序博客网时间：2024/05/20 19:32

前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Contract_detail.aspx.cs" Inherits="Contract_detail" %>
<!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>
</head>
<body style="margin-top: 0px; margin-left: 0px; margin-right: 0px;  font-family:宋体; font-size:14px; text-align: center;">
    <form id="form1" runat="server">
    <div>
        <table border="0" cellpadding="0" cellspacing="0" style="width: 100%; heihgt: 100%">
            <tr>
                <td style="width: 176px; height: 14px" valign="top">
                    <menu1:menu ID="menu1" runat="server" />
                </td>
                <td style="height: 14px; width: 777px;" valign="top">
                    <table id="Table1" border="1" cellpadding="1" cellspacing="1" style="width: 539px;
                        height: 248px">
                        <tr>
                            <td style="width: 534px; height: 31px; background-color: #cccccc">
                                <p>
                                    <strong>合同明细表</strong></p>
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 534px; height: 189px" valign="middle">                            
                                
                                <span >
                                    <asp:Repeater ID="Repeater1" runat="server">
                                    <ItemTemplate>
                                        <table style="width: 600px">
                        <tr>
                            <td style="width: 150px">客户名称
                            </td>
                            <td style="width: 150px"><%#Eval("custom_name") %>
                            </td>
                            <td style="width: 150px">产品名称
                            </td>
                            <td style="width: 150px"><%#Eval("product_name") %>
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 150px">订货数量
                            </td>
                            <td style="width: 150px"><%#Eval("product_book") %>
                            </td>
                            <td style="width: 150px">已发货数量
                            </td>
                            <td style="width: 150px"><%#Eval("product_send") %>
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 150px">单价
                            </td>
                            <td style="width: 150px"><%#Eval("product_price") %>
                            </td>
                            <td style="width: 150px">签署日期
                            </td>
                            <td style="width: 150px"><%#Eval("contract_start") %>
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 150px">发货日期
                            </td>
                            <td style="width: 150px"><%#Eval("contract_send") %>
                            </td>
                            <td style="width: 150px">完成日期
                            </td>
                            <td style="width: 150px"><%#Eval("contract_finish") %>
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 150px">经办人
                            </td>
                            <td style="width: 150px"><%#Eval("contract_person") %>
                            </td>
                            <td style="width: 150px">总金额
                            </td>
                            <td style="width: 150px"><%#Eval("contract_price") %>
                            </td>
                        </tr>
                        <tr>
                            <td colspan="4">合同执行状态：<%#Eval("contract_state") %>
                            </td>                            
                        </tr>
                    </table>
                                    </ItemTemplate>
                        
                 </asp:Repeater>
                                    合同状态：0－签署态，1－发货态，2－完成态</span><br />
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 534px; background-color: #cccccc">
                                <asp:Button ID="Btn_back" runat="server" OnClick="Btn_back_Click" Text="返回" /></td>
                        </tr>
                    </table>
                    
                </td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>

后台代码：

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
public partial class Contract_detail : System.Web.UI.Page
{
    string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            Display();
    }
    public void Display()
    {
        OracleConnection connection = new OracleConnection(connectionString);
        string sqlstr = "select c.*,d.product_book,d.product_send,d.product_price,custom_name,product_name  from contract c,contract_detail d,customer r,product t where c.contract_id=d.contract_id and c.contract_id=:contract_id and r.custom_id=c.custom_id and d.product_id=t.product_id";
        OracleCommand cmd = new OracleCommand(sqlstr, connection);
        cmd.Parameters.Add("contract_id", OracleType.Char).Value = Request.QueryString["contract_id"];
        DataTable dt = new DataTable("细节");
        OracleDataAdapter da = new OracleDataAdapter(cmd);
        da.Fill(dt);
        Repeater1.DataSource = dt;
        Repeater1.DataBind();
    }
    protected void Btn_back_Click(object sender, EventArgs e)
    {
        Response.Redirect("Contract.aspx");
    }
}