From b18a7c8e54b51a5caa400e55cb8cc428c0301a0c Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 21 一月 2022 17:27:22 +0800
Subject: [PATCH] 数据库连接
---
CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx | 247 +++++++++++++++++++++++++++++--------------------
1 files changed, 147 insertions(+), 100 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx
index c9426b4..d425ced 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsVisit.aspx
@@ -1,100 +1,147 @@
-锘�<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CorporateClientsVisit.aspx.cs" Inherits="CY.WebForm.Pages.business.CorporateClientsVisit" %>
-
-<!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 id="Head1" runat="server">
- <title>鏌ョ湅鍚堜綔瀹㈡埛璧勬枡</title>
- <uc:CMSHead ID="CMSHead1" runat="server" />
- <script type="text/javascript">
-
- function printview() {
- bdhtml = window.document.body.innerHTML;
- sprnstr = "<!--startprint-->"; //寮�濮嬫墦鍗版爣璇嗗瓧绗︿覆鏈�17涓瓧绗�
- eprnstr = "<!--endprint-->"; //缁撴潫鎵撳嵃鏍囪瘑瀛楃涓�
- prnhtml = bdhtml.substr(bdhtml.indexOf(sprnstr) + 17); //浠庡紑濮嬫墦鍗版爣璇嗕箣鍚庣殑鍐呭
- prnhtml = prnhtml.substring(0, prnhtml.indexOf(eprnstr)); //鎴彇寮�濮嬫爣璇嗗拰缁撴潫鏍囪瘑涔嬮棿鐨勫唴瀹�
- window.document.body.innerHTML = prnhtml; //鎶婇渶瑕佹墦鍗扮殑鎸囧畾鍐呭璧嬬粰body.innerHTML
- window.print(); //璋冪敤娴忚鍣ㄧ殑鎵撳嵃鍔熻兘鎵撳嵃鎸囧畾鍖哄煙
-
- window.document.body.innerHTML = bdhtml;//閲嶆柊缁欓〉闈㈠唴瀹硅祴鍊硷紱
- }
-
- </script>
-</head>
-<body>
- <form runat="server" id="form1" class="form">
-
- <table class="TableNewStyle" width="100%">
- <tr>
-
- <tr>
-
- <td>
-
- <input type="button" class="button" value="鎵撳嵃" onclick="printview();" />
- </td>
- </tr>
- </table>
-
- <fieldset>
- <legend>缁存姢璁板綍</legend>
- <!--startprint-->
- <table class="tableStyle" style="margin-bottom:10px;">
-
- <tr>
-
- <td class="ali03 " style="width:10%">瀹㈡埛鍗曚綅锛�</td>
- <td style="width:30%">
- <span id="spanCompanyName" runat="server" ></span>
- </td>
- <td class="ali03 " style="width:10%">涓氬姟缁忕悊锛�</td><td style="width:20%"><span id="spanBusinessManagerId" runat="server" ></span></td>
- <td class="ali03 " style="width:10%">鎵撳嵃鏃ユ湡锛�</td><td style="width:20%"><span id="spanprintdate" runat="server" ></span></td>
- </tr>
- </table>
-
- <asp:Repeater ID="RepClientList" runat="server">
- <HeaderTemplate>
- <table class="tableStyle" useclick="false" usecheckbox="true" sortmode="true" border="1" cellspacing="0" cellpadding="0" style="text-align: center;">
- <tr>
- <th style="text-align: center;width:10px;">
- 搴忓彿
- </th>
- <th style="text-align: center;">
- 缁存姢鏃ユ湡
- </th>
- <th style="text-align: center;">
- 缁存姢璁板綍
- </th>
- <th style="text-align: center;">
- 缁存姢浜�
- </th>
-
- </tr>
- </HeaderTemplate>
- <ItemTemplate>
- <tr>
-
- <td>
- <%# Container.ItemIndex + 1%>
- </td>
- <td>
- <%#Eval("VisitTime", "{0:yyyy-MM-dd}")%>
- </td>
- <td>
- <%#Eval("Remark")%>
- </td>
- <td>
- <%#Eval("CreaterName")%>
- </td>
- </tr>
- </ItemTemplate>
- <FooterTemplate>
- </table>
- </FooterTemplate>
- </asp:Repeater>
- <!--endprint-->
- </fieldset>
- </form>
-</body>
-</html>
+锘�<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CorporateClientsVisit.aspx.cs" Inherits="CY.WebForm.Pages.business.CorporateClientsVisit" %>
+
+<!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 id="Head1" runat="server">
+ <title>鏌ョ湅鍚堜綔瀹㈡埛璧勬枡</title>
+ <uc:CMSHead ID="CMSHead1" runat="server" />
+ <script type="text/javascript">
+
+ function printview() {
+ bdhtml = window.document.body.innerHTML;
+ sprnstr = "<!--startprint-->"; //寮�濮嬫墦鍗版爣璇嗗瓧绗︿覆鏈�17涓瓧绗�
+ eprnstr = "<!--endprint-->"; //缁撴潫鎵撳嵃鏍囪瘑瀛楃涓�
+ prnhtml = bdhtml.substr(bdhtml.indexOf(sprnstr) + 17); //浠庡紑濮嬫墦鍗版爣璇嗕箣鍚庣殑鍐呭
+ prnhtml = prnhtml.substring(0, prnhtml.indexOf(eprnstr)); //鎴彇寮�濮嬫爣璇嗗拰缁撴潫鏍囪瘑涔嬮棿鐨勫唴瀹�
+ window.document.body.innerHTML = prnhtml; //鎶婇渶瑕佹墦鍗扮殑鎸囧畾鍐呭璧嬬粰body.innerHTML
+ window.print(); //璋冪敤娴忚鍣ㄧ殑鎵撳嵃鍔熻兘鎵撳嵃鎸囧畾鍖哄煙
+
+ window.document.body.innerHTML = bdhtml;//閲嶆柊缁欓〉闈㈠唴瀹硅祴鍊硷紱
+ }
+
+ </script>
+</head>
+<body>
+ <form runat="server" id="form1" class="form">
+
+ <table class="TableNewStyle" width="100%">
+ <tr>
+
+ <tr>
+
+ <td>
+
+ <input type="button" class="button" value="鎵撳嵃" onclick="printview();" />
+ </td>
+ </tr>
+ </table>
+ <fieldset id="weihujilu">
+ <legend>娣诲姞缁存姢璁板綍</legend>
+ <table class="tableStyle" width="100%">
+ <tr>
<td class="ali01 ">缁存姢鏃ユ湡锛�</td>
<td ><input id="txtVisitTime" type="text" runat="server" maxlength="50" class="date w90px" datefmt="yyyy-MM-dd" /></td>
<td class="ali03 ">缁存姢璁板綍锛�</td>
<td colspan="2" ><textarea runat="server" id="txtvisitRemark" style=" width:92%; height:30px;" maxlength="200"></textarea></td>
<td ><asp:Button ID="Button1" Text="娣诲姞缁存姢璁板綍" runat="server" OnClick="btn_Submit_Visit" ToolTip="璇ヨ褰曚細娓呴櫎璇ュ鎴风殑渚嬭缁存姢鎻愰啋"/><asp:Button ID="btn_Submit" Text="娣诲姞鍋囨棩缁存姢璁板綍" runat="server" ToolTip="璇ヨ褰曚細娓呴櫎璇ュ鎴风殑鍋囨棩缁存姢鎻愰啋" OnClick="btn_Submit_Visit_jiari"/></td>
</tr>
+ </table>
+ <%-- <asp:Repeater ID="RepClientList" runat="server">
+ <HeaderTemplate>
+ <table class="tableStyle" useclick="false" usecheckbox="true" sortmode="true" style="text-align: center;">
+ <tr>
+
+ <th style="text-align: center;width:10px;">
+ 搴忓彿
+ </th>
+ <th style="text-align: center;">
+ 缁存姢鏃ユ湡
+ </th>
+ <th style="text-align: center;">
+ 缁存姢璁板綍
+ </th>
+ <th style="text-align: center;">
+ 缁存姢浜�
+ </th>
+
+ </tr>
+ </HeaderTemplate>
+ <ItemTemplate>
+ <tr>
+ <td>
+ <%# Container.ItemIndex + 1%>
+ </td>
+
+ <td>
+ <%#Eval("VisitTime", "{0:yyyy-MM-dd}")%>
+ </td>
+ <td>
+ <%#Eval("Remark")%>
+ </td>
+ <td>
+ <%#Eval("CreaterName")%>
+ </td>
+ </tr>
+ </ItemTemplate>
+ <FooterTemplate>
+ </table>
+ </FooterTemplate>
+ </asp:Repeater>--%>
+
+ </fieldset>
+ <fieldset>
+ <legend>缁存姢璁板綍</legend>
+ <!--startprint-->
+ <table class="tableStyle" style="margin-bottom:10px;">
+
+ <tr>
+
+ <td class="ali03 " style="width:10%">瀹㈡埛鍗曚綅锛�</td>
+ <td style="width:30%">
+ <span id="spanCompanyName" runat="server" ></span>
+ </td>
+ <td class="ali03 " style="width:10%">涓氬姟缁忕悊锛�</td><td style="width:20%"><span id="spanBusinessManagerId" runat="server" ></span></td>
+ <td class="ali03 " style="width:10%">鎵撳嵃鏃ユ湡锛�</td><td style="width:20%"><span id="spanprintdate" runat="server" ></span></td>
+ </tr>
+ </table>
+
+ <asp:Repeater ID="RepClientList" runat="server">
+ <HeaderTemplate>
+ <table class="tableStyle" useclick="false" usecheckbox="true" sortmode="true" border="1" cellspacing="0" cellpadding="0" style="text-align: center;">
+ <tr>
+ <th style="text-align: center;width:10px;">
+ 搴忓彿
+ </th>
+ <th style="text-align: center;">
+ 缁存姢鏃ユ湡
+ </th>
+ <th style="text-align: center;">
+ 缁存姢璁板綍
+ </th>
+ <th style="text-align: center;">
+ 缁存姢浜�
+ </th>
+
+ </tr>
+ </HeaderTemplate>
+ <ItemTemplate>
+ <tr>
+
+ <td>
+ <%# Container.ItemIndex + 1%>
+ </td>
+ <td>
+ <%#Eval("VisitTime", "{0:yyyy-MM-dd}")%>
+ </td>
+ <td>
+ <%#Eval("Remark")%>
+ </td>
+ <td>
+ <%#Eval("CreaterName")%>
+ </td>
+ </tr>
+ </ItemTemplate>
+ <FooterTemplate>
+ </table>
+ </FooterTemplate>
+ </asp:Repeater>
+ <!--endprint-->
+ </fieldset>
+ </form>
+</body>
+</html>
--
Gitblit v1.9.1