//这是一个将两张Excel表的产品名称进行对比并生成新Excel表的小程序
//发布之后可能会报出一个错误(具体搞忘了),除了网上的办法外,还可以试试将需要导入的文件
//与主程序放入一个盘符,这个错也有可能是IIS服务的访问权限引起,office版本为2007
--------------------------------万恶的分割线--------------------------------------------
//项目结构
//产品信息表
//订单表
--------------------------------万恶的分割线--------------------------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="_Default" %>
<!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>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td><asp:Label ID="Label2" runat="server" Text="选择产品Excel:"></asp:Label>
<asp:FileUpload ID="fu_chanpin" runat="server" /></td>
</tr>
<tr>
<td><asp:Label ID="Label1" runat="server" Text="选择订单Excel:"></asp:Label>
<asp:FileUpload ID="fu_dingdan" runat="server" />
<asp:Button ID="btnSubmit" runat="server" Text="确 定" OnClick="btnSubmit_Click" /></td>
</tr>
<tr>
<td style="width: 100%;" colspan="2">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="1500px">
<Columns>
<asp:BoundField DataField="dingdanName" HeaderText="产品名称" />
<asp:BoundField DataField="dingdanJinghanliang" HeaderText="净含量" />
<asp:BoundField DataField="dingdanChangjiajia" HeaderText="厂家价" />
<asp:BoundField DataField="dingdanPifajia" HeaderText="批发价3折" />
<asp:BoundField DataField="dingdanShuliang" HeaderText="数量" />
<asp:BoundField DataField="dingdanZongjia" HeaderText="总价" />
<asp:BoundField DataField="dingdanBeizhu" HeaderText="备注" />