DataManage.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
namespace WatchManager
{
public partial class DataManage : System.Web.UI.Page
{
public string strTableHelper="";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
txtDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
Bind();
}
}
protected void Bind()
{
string strDate = txtDate.Text;
DBAccess.DataControl dbControl = new DBAccess.DataControl();
repData.DataSource = dbControl.GetEquip();
repData.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Bind();
}
protected void repData_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
strTableHelper = "";
DataRowView dr = e.Item.DataItem as DataRowView;
//strTableHelper = GetTableString(dr["ID"].ToString(), txtDate.Text);
Literal litlTabHelper = e.Item.FindControl("litlTabHelper") as Literal;
litlTabHelper.Text = GetTableString(dr["ID"].ToString(), txtDate.Text);
//<td>
// <input id="equip<%#Eval("ID") %>02" οnblur="SaveData('<%#Eval("ID") %>','02',this.value)"
// type="text" class="txtData" value="<%#Eval("Hour02") %>" />
// </td>
}
public string GetTableString(string strID,string strDate)
{
string result = "";
DBAccess.DataControl dbControl=new DBAccess.DataControl();
DataSet ds = dbControl.GetEquipDataByDate(strID, strDate);
foreach (DataRow dr in ds.Tables[0].Rows)
{
string value = DBNull.Value == dr["WatchValue"] ? "" : dr["WatchValue"].ToString();
result += "<td>";
result += "<input id=\"equip" + strID + dr["TimeValue"].ToString() + "\" οnblur=\"SaveData('" + strID + "','" + dr["TimeValue"].ToString() + "',this.value)\"";
result += " type=\"text\" class=\"txtData\" value=\"" +value + "\" οnkeyup=\"CheckValue(this); \" />";
}
return result;
}
}
}
DataManage.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true"
CodeBehind="DataManage.aspx.cs" Inherits="WatchManager.DataManage" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
<script src="Scripts/TableFix.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function () {
FixTable("MyTable", 4, 900, 400);
});
function SaveData(strID,strTime,num) {
var strdate = $("#<%=txtDate.ClientID %>").val();
//var num = $("#" + strID).val();
//alert(strID + ":" + num + ":" + strdate + ":" + strTime);
var url = "SaveServ.ashx?id=" + strID + "&num=" + num + "&date=" + strdate + "&time=" + strTime;
$.ajax(
{
url: url,
async: false,
type: "POST",
cache: false,
success: function (data)
{
//alert(data);
}
}
);
}
function CheckValue(textbox) {
var patrn1 = /^[-|+]?(0|[1-9][0-9]*)(\.\d{1,2})?$/;
var re = new RegExp(patrn1);
if (!re.test(textbox.value)) {
textbox.value = "";
}
}
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<div>
<div class="BannerText">
Information Input
</div>
<div class="TopControlList">
Date:<asp:TextBox ID="txtDate" runat="server" οnfοcus="WdatePicker()"></asp:TextBox>
<asp:Button ID="btnSearch" runat="server" Text="Search"
οnclick="btnSearch_Click" />
<asp:Button ID="btnSave" runat="server" Text="Save" />
</div>
<div class="MainContent">
<div id="MyTable_tableLayout">
<div id="MyTable_tableFix">
<table id="MyTable_tableFixClone" border="1" cellspacing="0" cellpadding="0">
</table>
</div>
<div id="MyTable_tableHead">
<table id="MyTable_tableHeadClone" border="1" cellspacing="0" cellpadding="0">
</table>
</div>
<div id="MyTable_tableColumn">
<table id="MyTable_tableColumnClone" border="1" cellspacing="0" cellpadding="0">
</table>
</div>
<div id="MyTable_tableData">
<table id="MyTable" border="1" cellspacing="0" cellpadding="0">
<thead>
<tr>
<td>
WatchNo
</td>
<td style="width:80px">
WatchPara
</td>
<td>
WatchUnit
</td>
<td>
WatchArrange
</td>
<td>
00:00
</td>
<td>
02:00
</td>
<td>
04:00
</td>
<td>
06:00
</td>
<td>
08:00
</td>
<td>
10:00
</td>
<td>
12:00
</td>
<td>
14:00
</td>
<td>
16:00
</td>
<td>
18:00
</td>
<td>
20:00
</td>
<td>
22:00
</td>
</tr>
</thead>
<tbody>
<asp:Repeater ID="repData" runat="server"
onitemdatabound="repData_ItemDataBound">
<ItemTemplate>
<tr>
<td>
<span style="display: none" id="equip<%#Eval("ID") %>">
<%#Eval("ID") %></span>
<%#Eval("WatchNo")%>
</td>
<td>
<%#Eval("WatchPara")%>
</td>
<td>
<%#Eval("WatchUnit")%>
</td>
<td>
<%#Eval("WatchMin")%>~<%#Eval("WatchMax")%></td>
<asp:Literal ID="litlTabHelper" runat="server"></asp:Literal>
<%--<%=strTableHelper %>--%>
<%-- <td>
<input id="equip<%#Eval("ID") %>02" οnblur="SaveData('<%#Eval("ID") %>','02',this.value)"
type="text" class="txtData" value="<%#Eval("Hour02") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>04" οnblur="SaveData('<%#Eval("ID") %>','04',this.value)"
type="text" class="txtData" value="<%#Eval("Hour04") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>06" οnblur="SaveData('<%#Eval("ID") %>','06',this.value)"
type="text" class="txtData" value="<%#Eval("Hour06") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>08" οnblur="SaveData('<%#Eval("ID") %>','08',this.value)"
type="text" class="txtData" value="<%#Eval("Hour08") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>10" οnblur="SaveData('<%#Eval("ID") %>','10',this.value)"
type="text" class="txtData" value="<%#Eval("Hour10") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>12" οnblur="SaveData('<%#Eval("ID") %>','12',this.value)"
type="text" class="txtData" value="<%#Eval("Hour12") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>14" οnblur="SaveData('<%#Eval("ID") %>','14',this.value)"
type="text" class="txtData" value="<%#Eval("Hour14") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>16" οnblur="SaveData('<%#Eval("ID") %>','16',this.value)"
type="text" class="txtData" value="<%#Eval("Hour16") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>18" οnblur="SaveData('<%#Eval("ID") %>','18',this.value)"
type="text" class="txtData" value="<%#Eval("Hour18") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>20" οnblur="SaveData('<%#Eval("ID") %>','20',this.value)"
type="text" class="txtData" value="<%#Eval("Hour20") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>22" οnblur="SaveData('<%#Eval("ID") %>','22',this.value)"
type="text" class="txtData" value="<%#Eval("Hour22") %>" />
</td>
<td>
<input id="equip<%#Eval("ID") %>24" οnblur="SaveData('<%#Eval("ID") %>','24',this.value)"
type="text" class="txtData" value="<%#Eval("Hour24") %>" />
</td>--%>
<%-- <td>02:00</td><td>04:00</td><td>06:00</td><td>08:00</td><td>10:00</td><td>12:00</td>
<td>14:00</td><td>16:00</td><td>18:00</td><td>20:00</td><td>22:00</td><td>24:00</td>--%>
</tr>
</ItemTemplate>
</asp:Repeater>
</tbody>
</table>
</div>
</div>
</div>
</div>
</asp:Content>
DataView.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true"
CodeBehind="DataView.aspx.cs" Inherits="WatchManager.DataView" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
<script src="Scripts/TableFix.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function () {
FixTable("MyTable", 0, 900, 400);
});
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<div>
<div class="BannerText">
Information View
</div>
<div class="TopControlList">
Start Date:<asp:TextBox ID="txtStartDate" runat="server" οnfοcus="WdatePicker()"></asp:TextBox>
End Date:<asp:TextBox ID="txtEndDate" runat="server" οnfοcus="WdatePicker()"></asp:TextBox>
<asp:Button ID="btnSearch" runat="server" Text="Search"
οnclick="btnSearch_Click" />
</div>
<div class="MainContent">
<div id="MyTable_tableLayout">
<div id="MyTable_tableFix">
<table id="MyTable_tableFixClone" border="1" cellspacing="0" cellpadding="0">
</table>
</div>
<div id="MyTable_tableHead">
<table id="MyTable_tableHeadClone" border="1" cellspacing="0" cellpadding="0">
</table>
</div>
<div id="MyTable_tableColumn">
<table id="MyTable_tableColumnClone" border="1" cellspacing="0" cellpadding="0">
</table>
</div>
<div id="MyTable_tableData">
<table id="MyTable" border="1" cellspacing="0" cellpadding="0">
<thead>
<tr>
<td>Title</td>
<td>
WatchNo
</td>
<td>
WatchPara
</td>
<td>
WatchUnit
</td>
<td>
WatchMAX
</td>
<td>
WatchMin
</td>
<td>OutCount</td>
<td>MaxOver</td>
<td>MinOver</td>
<td>AVGValue</td>
</tr>
</thead>
<tbody>
<asp:Repeater ID="repData" runat="server">
<ItemTemplate>
<tr>
<td><a href="ChartShow.aspx?id=<%#Eval("ID")%>">Detail</a></td>
<td><%#Eval("WatchNo")%> </td>
<td><%#Eval("WatchPara")%> </td>
<td><%#Eval("WatchUnit")%> </td>
<td><%#Eval("WatchMax") %> </td>
<td><%#Eval("WatchMin") %> </td>
<td><%#Eval("OutCount")%> </td>
<td><%#Eval("MAXOverValue") %> </td>
<td><%#Eval("MinOverValue") %> </td>
<td><%#Eval("AVGValue") %> </td>
</tr>
</ItemTemplate>
</asp:Repeater>
</tbody>
</table>
</div>
</div>
</div>
</div>
</asp:Content>
Site.Master
<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Site.master.cs" Inherits="WatchManager.SiteMaster" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head runat="server">
<title></title>
<link href="~/Styles/Site.css" rel="stylesheet" type="text/css" />
<script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="Scripts/My97DatePicker/WdatePicker.js" type="text/javascript"></script>
<asp:ContentPlaceHolder ID="HeadContent" runat="server">
</asp:ContentPlaceHolder>
</head>
<body>
<form runat="server">
<div class="page">
<div class="header">
<div class="title">
<h1>
My ASP.NET Application
</h1>
</div>
<div class="loginDisplay">
<asp:LoginView ID="HeadLoginView" runat="server" EnableViewState="false">
<AnonymousTemplate>
[ <a href="~/Account/Login.aspx" ID="HeadLoginStatus" runat="server">Log In</a> ]
</AnonymousTemplate>
<LoggedInTemplate>
Welcome <span class="bold"><asp:LoginName ID="HeadLoginName" runat="server" /></span>!
[ <asp:LoginStatus ID="HeadLoginStatus" runat="server" LogoutAction="Redirect" LogoutText="Log Out" LogoutPageUrl="~/"/> ]
</LoggedInTemplate>
</asp:LoginView>
</div>
<div class="clear hideSkiplink">
<asp:Menu ID="NavigationMenu" runat="server" CssClass="menu" EnableViewState="false" IncludeStyleBlock="false" Orientation="Horizontal">
<Items>
<asp:MenuItem NavigateUrl="~/Default.aspx" Text="Home"/>
<asp:MenuItem NavigateUrl="~/About.aspx" Text="About"/>
<asp:MenuItem NavigateUrl="~/DataManage.aspx" Text="DataManage"/>
<asp:MenuItem NavigateUrl="~/DataView.aspx" Text="DataView"/>
</Items>
</asp:Menu>
</div>
</div>
<div class="main">
<asp:ContentPlaceHolder ID="MainContent" runat="server"/>
</div>
<div class="clear">
</div>
</div>
<div class="footer">
</div>
</form>
</body>
</html>