![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
<%
@ Control Language="C#" AutoEventWireup="true" CodeFile="Eye.ascx.cs" Inherits="Controls_Eye" %>
<table cellpadding="1" cellspacing="0">
<tr>
<td>
<asp:ValidationSummary ID="vsCheck" runat="server" Enabled="true" Width="250px" HeaderText="Please correct the following errors:"
EnableClientScript="true" ValidationGroup="vgEye" />
<asp:ValidationSummary ID="ValidationSummary1" runat="server" Enabled="true" Width="250px"
HeaderText="Please correct the following errors:" EnableClientScript="true" ValidationGroup="vgAdd" />
<asp:SqlDataSource SelectCommand="SELECT * FROM [Eye] where TrackID=@TrackID" DeleteCommand="DELETE FROM [Eye] WHERE [EyeID] = @EyeID"
UpdateCommand="UPDATE [Eye] SET [TrackID] = @TrackID, [EyeNumber] = @EyeNumber, [Position] = @Position, [Function] = @Function, [CumulativeDistance] = @CumulativeDistance, [IntervalDistance] = @IntervalDistance WHERE [EyeID] = @EyeID"
InsertCommand="INSERT INTO [Eye](TrackID,EyeNumber,Position,[Function],CumulativeDistance,IntervalDistance) VALUES (@TrackID,@EyeNumber,@Position,@Function,@CumulativeDistance,@IntervalDistance)"
ID="sdsEye" ConnectionString="<%$ ConnectionStrings:ConnectionInfo %>" runat="server"
OnSelecting="sdsEye_Selecting">
<SelectParameters>
<asp:Parameter Name="TrackID" Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="EyeID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="TrackID" Type="Int32" />
<asp:Parameter Name="EyeNumber" Type="Int32" />
<asp:Parameter Name="Position" Type="String" />
<asp:Parameter Name="Function" Type="String" />
<asp:Parameter Name="CumulativeDistance" Type="Double" />
<asp:Parameter Name="IntervalDistance" Type="Double" />
<asp:Parameter Name="EyeID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="TrackID" Type="Int32" />
<asp:Parameter Name="EyeNumber" Type="Int32" />
<asp:Parameter Name="Position" Type="String" />
<asp:Parameter Name="Function" Type="String" />
<asp:Parameter Name="CumulativeDistance" Type="Double" />
<asp:Parameter Name="IntervalDistance" Type="Double" />
</InsertParameters>
</asp:SqlDataSource>
<asp:GridView ID="gvEye" AutoGenerateColumns="False" DataSourceID="sdsEye" DataKeyNames="EyeID"
AllowPaging="True" AllowSorting="True" runat="server" OnRowUpdating="gvEye_RowUpdating">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" CausesValidation="true"
ValidationGroup="vgEye" />
<asp:TemplateField HeaderText="EyeNumber" SortExpression="EyeNumber" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblEyeNumber" Text='<%#Bind("EyeNumber")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="Server" CssClass="EyeControlShortTextBox" ID="txtEyeNumber" Text='<%#Bind("EyeNumber")%>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvEyeNumber" runat="server" ControlToValidate="txtEyeNumber"
ErrorMessage="Eye number Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvEyeNumber" ErrorMessage="Eye number needs to be number"
Text="*" ValidationGroup="vgEye" ValidationExpression="^[0-9]+$" ControlToValidate="txtEyeNumber">
</asp:RegularExpressionValidator>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterEyeNumber" CssClass="EyeControlShortTextBox" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvEyeNumber" runat="server" ControlToValidate="txtFooterEyeNumber"
ErrorMessage="Eye number Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvEyeNumber" ErrorMessage="Eye number needs to be number"
Text="*" ValidationGroup="vgEye" ValidationExpression="^[0-9]+$" ControlToValidate="txtFooterEyeNumber">
</asp:RegularExpressionValidator>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Position" SortExpression="Position" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblPosition" Text='<%#Bind("Position")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" CssClass="EyeControlLongTextBox" ID="txtPosition" Text='<%#Bind("Position")%>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvPosition" runat="server" ControlToValidate="txtPosition"
ErrorMessage="Position Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox CssClass="EyeControlLongTextBox" ID="txtFooterPosition" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvPosition" runat="server" ControlToValidate="txtFooterPosition"
ErrorMessage="Position Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Function" SortExpression="Function" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblFunction" Text='<%#Bind("Function")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="Server" CssClass="EyeControlLongTextBox" ID="txtFunction" Text='<%#Bind("Function")%>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvFunction" runat="server" ControlToValidate="txtFunction"
ErrorMessage="Function Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox CssClass="EyeControlLongTextBox" ID="txtFooterFunction" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvFunction" runat="server" ControlToValidate="txtFooterFunction"
ErrorMessage="Function Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="CumulativeDistance" SortExpression="CumulativeDistance" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblCumulativeDistance" Text='<%#Bind("CumulativeDistance")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="Server" CssClass="EyeControlShortTextBox" ID="txtCumulativeDistance" Text='<%#Bind("CumulativeDistance")%>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvCumulativeDistance" runat="server" ControlToValidate="txtCumulativeDistance"
ErrorMessage="Cumulative Distance Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvCumulativeDistance" ErrorMessage="Cumulative Distance needs to be number"
Text="*" ValidationGroup="vgEye" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtCumulativeDistance">
</asp:RegularExpressionValidator>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox CssClass="EyeControlShortTextBox" ID="txtFooterCumulativeDistance" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvCumulativeDistance" runat="server" ControlToValidate="txtFooterCumulativeDistance"
ErrorMessage="Cumulative Distance Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvCumulativeDistance" ErrorMessage="Cumulative Distance needs to be number"
Text="*" ValidationGroup="vgEye" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtFooterCumulativeDistance">
</asp:RegularExpressionValidator>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="IntervalDistance" SortExpression="IntervalDistance" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblIntervalDistance" Text='<%#Bind("IntervalDistance")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="Server" CssClass="EyeControlShortTextBox" ID="txtIntervalDistance" Text='<%#Bind("IntervalDistance")%>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvIntervalDistance" runat="server" ControlToValidate="txtIntervalDistance"
ErrorMessage="Interval Distance Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvIntervalDistance" ErrorMessage="Interval Distance needs to be number"
Text="*" ValidationGroup="vgEye" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtIntervalDistance">
</asp:RegularExpressionValidator>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox CssClass="EyeControlShortTextBox" ID="txtFooterIntervalDistance" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvIntervalDistance" runat="server" ControlToValidate="txtFooterIntervalDistance"
ErrorMessage="Interval Distance Required" Text="*" ValidationGroup="vgEye">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvIntervalDistance" ErrorMessage="Interval Distance needs to be number"
Text="*" ValidationGroup="vgEye" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtFooterIntervalDistance">
</asp:RegularExpressionValidator>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<div runat="Server" id="inputDiv">
<asp:Label ID="lblAddEyeNumber" runat="server" Text="Eye Number:" CssClass="EyeUserControlLabel"></asp:Label>
<asp:TextBox ID="txtAddEyeNumber" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvAddEyeNumber" runat="server" ControlToValidate="txtAddEyeNumber"
ErrorMessage="Eye number Required" Text="*" ValidationGroup="vgAdd">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvAddEyeNumber" ErrorMessage="Eye number needs to be number"
Text="*" ValidationGroup="vgAdd" ValidationExpression="^[0-9]+$" ControlToValidate="txtAddEyeNumber">
</asp:RegularExpressionValidator>
<br />
<asp:Label ID="lblAddPosition" runat="server" Text="Position:" CssClass="EyeUserControlLabel"></asp:Label>
<asp:TextBox ID="txtAddPosition" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvAddPosition" runat="server" ControlToValidate="txtAddPosition"
ErrorMessage="Position Required" Text="*" ValidationGroup="vgAdd">
</asp:RequiredFieldValidator>
<br />
<asp:Label ID="lblAddFunction" runat="server" Text="Function:" CssClass="EyeUserControlLabel"></asp:Label>
<asp:TextBox ID="txtAddFunction" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvAddFunction" runat="server" ControlToValidate="txtAddFunction"
ErrorMessage="Function Required" Text="*" ValidationGroup="vgAdd">
</asp:RequiredFieldValidator>
<br />
<asp:Label ID="lblAddCumulativeDistance" runat="server" Text="Cumulative Distance:"
CssClass="EyeUserControlLabel"></asp:Label>
<asp:TextBox ID="txtAddCumulativeDistance" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvAddCumulativeDistance" runat="server" ControlToValidate="txtAddCumulativeDistance"
ErrorMessage="Cumulative Distance Required" Text="*" ValidationGroup="vgAdd">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvAddCumulativeDistance" ErrorMessage="Cumulative Distance needs to be number"
Text="*" ValidationGroup="vgAdd" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtAddCumulativeDistance">
</asp:RegularExpressionValidator>
<br />
<asp:Label ID="lblAddIntervalDistance" runat="server" Text="Interval Distance:" CssClass="EyeUserControlLabel"></asp:Label>
<asp:TextBox ID="txtAddIntervalDistance" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvAddIntervalDistance" runat="server" ControlToValidate="txtAddIntervalDistance"
ErrorMessage="Interval Distance Required" Text="*" ValidationGroup="vgAdd">
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server" ID="rxvAddIntervalDistance" ErrorMessage="Interval Distance needs to be number"
Text="*" ValidationGroup="vgAdd" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtAddIntervalDistance">
</asp:RegularExpressionValidator>
<br />
</div>
<br />
<asp:Button ID="btnAdd" runat="server" Text="Add new" OnClick="btnAdd_Click" />
<asp:Button runat="server" ID="btnSave" Text="Save" CausesValidation="true" ValidationGroup="vgAdd"
OnClick="btnSave_Click" Visible="false" />
<asp:Button runat="Server" ID="btnFooterSave" Text="Save" CausesValidation="true"
ValidationGroup="vgEye" Visible="false" OnClick="btnFooterSave_Click" />
<asp:Button runat="Server" ID="btnCancel" Text="Cancel" OnClick="btnCancel_Click"
Visible="false" />
</td>
</tr>
</table>
![](/Images/OutliningIndicators/None.gif)
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 Entities;
using DomainObjects;
![](/Images/OutliningIndicators/None.gif)
public partial class Controls_Eye : System.Web.UI.UserControl
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
public int TrackID
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
get
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return Convert.ToInt32(this.ViewState["TrackID"]);
}
set
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.ViewState["TrackID"] = value;
this.gvEye.DataBind();
}
}
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
"Page_Load"#region "Page_Load"
protected void Page_Load(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (!this.IsPostBack)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
ShowAddingLayout(false);
}
}
#endregion
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
"btnAdd_Click"#region "btnAdd_Click"
protected void btnAdd_Click(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
ShowAddingLayout(true);
}
#endregion
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
"ShowAddingLayout"#region "ShowAddingLayout"
private void ShowAddingLayout(bool IsAdding)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.btnAdd.Visible = !IsAdding;
this.btnCancel.Visible = IsAdding;
if (this.gvEye.Rows.Count == 0)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (IsAdding)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.btnSave.Visible = true;
this.btnFooterSave.Visible = false;
this.inputDiv.Visible = true;
}
else
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.btnSave.Visible = false;
this.btnFooterSave.Visible = false;
this.inputDiv.Visible = false;
}
}
else
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.gvEye.ShowFooter = IsAdding;
this.inputDiv.Visible = false;
if (IsAdding)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.btnSave.Visible = false;
this.btnFooterSave.Visible = true;
}
else
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.btnSave.Visible = false;
this.btnFooterSave.Visible = false;
}
}
}
#endregion
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
"btnSave_Click"#region "btnSave_Click"
protected void btnSave_Click(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
Eye eye = new Eye();
eye.TrackID = Convert.ToInt32(this.ViewState["TrackID"]);
eye.EyeNumber = Convert.ToInt32(this.txtAddEyeNumber.Text);
eye.Position = this.txtAddPosition.Text;
eye.Function = this.txtAddFunction.Text;
eye.CumulativeDistance = Convert.ToDouble(this.txtAddCumulativeDistance.Text);
eye.IntervalDistance = Convert.ToDouble(this.txtAddIntervalDistance.Text);
(new EyeDO()).createEye(eye);
this.gvEye.DataBind();
ShowAddingLayout(false);
this.txtAddEyeNumber.Text = "";
this.txtAddPosition.Text = "";
this.txtAddFunction.Text = "";
this.txtAddCumulativeDistance.Text = "";
this.txtAddIntervalDistance.Text = "";
}
#endregion
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
"btnCancel_Click"#region "btnCancel_Click"
protected void btnCancel_Click(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
ShowAddingLayout(false);
}
#endregion
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
"btnFooterSave_Click"#region "btnFooterSave_Click"
protected void btnFooterSave_Click(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
Eye eye = new Eye();
eye.TrackID = Convert.ToInt32(this.ViewState["TrackID"]);
TextBox txtFooterEyeNumber = (TextBox)this.gvEye.FooterRow.FindControl("txtFooterEyeNumber");
eye.EyeNumber = Convert.ToInt32(txtFooterEyeNumber.Text);
TextBox txtFooterPosition = (TextBox)this.gvEye.FooterRow.FindControl("txtFooterPosition");
eye.Position = txtFooterPosition.Text;
TextBox txtFooterFunction = (TextBox)this.gvEye.FooterRow.FindControl("txtFooterFunction");
eye.Function = txtFooterFunction.Text;
TextBox txtFooterCumulativeDistance = (TextBox)this.gvEye.FooterRow.FindControl("txtFooterCumulativeDistance");
eye.CumulativeDistance = Convert.ToDouble(txtFooterCumulativeDistance.Text);
TextBox txtFooterIntervalDistance = (TextBox)this.gvEye.FooterRow.FindControl("txtFooterIntervalDistance");
eye.IntervalDistance = Convert.ToDouble(txtFooterIntervalDistance.Text);
this.sdsEye.InsertParameters["TrackID"].DefaultValue = eye.TrackID.ToString();
this.sdsEye.InsertParameters["EyeNumber"].DefaultValue = eye.EyeNumber.ToString();
this.sdsEye.InsertParameters["Position"].DefaultValue = eye.Position;
this.sdsEye.InsertParameters["Function"].DefaultValue = eye.Function;
this.sdsEye.InsertParameters["CumulativeDistance"].DefaultValue = eye.CumulativeDistance.ToString();
this.sdsEye.InsertParameters["IntervalDistance"].DefaultValue = eye.IntervalDistance.ToString();
this.sdsEye.Insert();
this.gvEye.DataBind();
ShowAddingLayout(false);
}
#endregion
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
"sdsEye_Selecting"#region "sdsEye_Selecting"
protected void sdsEye_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
try
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
e.Command.Parameters["@TrackID"].Value = Convert.ToInt32(this.ViewState["TrackID"]);
}
catch
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
e.Command.Parameters["@TrackID"].Value = -1;
}
}
#endregion
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
"gvEye_RowUpdating"#region "gvEye_RowUpdating"
protected void gvEye_RowUpdating(object sender, GridViewUpdateEventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
e.NewValues["TrackID"] = this.ViewState["TrackID"];
}
#endregion
}
![](/Images/OutliningIndicators/None.gif)
posted @
2008-03-27 22:24
N/A2011
阅读(
257)
评论()
编辑
收藏
举报