Default.aspx Web Interface
<%@ page language= "C #" autoeventwireup= "true" codefile= "Default.aspx.cs" inherits= "_default"%>
<! DOCTYPE html>
<meta http-equiv= "Content-type" content= "text/html; Charset=utf-8 "/>
<title></title>
<body>
<form id= "Form1" runat= "Server" >
<div>
<asp:label id= "Label1" runat= "Server" text= "serial number Generation" font-bold= "True" font-size= "30px" ></asp:Label>
<br/>
Code: <asp:textbox id= "TextBox1" runat= "Server" ></asp:TextBox>
<asp:button id= "Button1" runat= "Server" onclick= "Button1_Click" text= "Generate serial number"/>
<br/>
Name: <asp:textbox id= "TextBox2" runat= "Server" ></asp:TextBox>
<br/>
Gender: <asp:textbox id= "TextBox3" runat= "Server" ></asp:TextBox>
<br/>
National:
<asp:textbox id= "TextBox4" runat= "Server" ></asp:TextBox>
<br/>
Birthday:
<asp:textbox id= "TEXTBOX5" runat= "Server" ></asp:TextBox>
<br/>
<asp:button id= "Button2" runat= "Server" text= "commit"/>
<br/>
<br/>
</div>
</form>
</body>
Defaule.aspx.cs C # interface
Using System;
Using System.Collections.Generic;
Using System.Linq;
Using System.Web;
Using System.Web.UI;
Using System.Web.UI.WebControls;
public partial class _default:system.web.ui.page
{
Private Mydbdatacontext _context = new Mydbdatacontext ();
protected void Page_Load (object sender, EventArgs e)
{
}
protected void Button1_Click (object sender, EventArgs e)
{
string prefix = "p" + DateTime.Now.ToString ("YyyyMMdd");
1 Check the day's largest serial number
int maxflow = 0;
var query = _context.info.where (p=>p.code.startswith (prefix));
if (query. Count () > 0)
{
query = query. OrderByDescending (P=>p.code);//ORDER by serial number
String maxcode = query. First (). code;//Get maximum serial number
Maxflow =convert.toint32 (maxcode.substring (9));
}
Combination query the latest serial number
String flowcode = prefix + (maxflow + 1). ToString ("000");
Show in text box
TextBox1.Text = Flowcode;
}
}
*********************************************************************************************
Combination Query
*********************************************************************************************
Default.aspx Web Interface
<%@ page language= "C #" autoeventwireup= "true" codefile= "Default2.aspx.cs" inherits= "DEFAULT2"%>
<! DOCTYPE html>
<meta http-equiv= "Content-type" content= "text/html; Charset=utf-8 "/>
<title></title>
<body>
<form id= "Form1" runat= "Server" >
<div>
Car name: <asp:textbox id= "txtname" runat= "Server" ></asp:TextBox>
Series: <asp:dropdownlist id= "Ddlbrand" runat= "Server" appenddatabounditems= "True" >
<asp:listitem value= "-1" >== Please select ==</asp:listitem>
</asp:DropDownList>
Fuel consumption: <asp:textbox id= "Txtoil" runat= "Server" ></asp:TextBox>
<asp:button id= "Button1" runat= "server" text= "query" onclick= "Button1_Click"/>
<br/>
<asp:repeater id= "Repeater1" runat= "Server" >
<HeaderTemplate>
<ul>
</HeaderTemplate>
<ItemTemplate>
<li>
<%# Eval ("Name")%>
<font color= "Red" ><%# Eval ("Brand")%></font>
<font color= "Blue" ><%# Eval ("oil")%></font>
</li>
</ItemTemplate>
<FooterTemplate>
</ul>
</FooterTemplate>
</asp:Repeater>
</div>
</form>
</body>
Defaule.aspx.cs C # interface
Using System;
Using System.Collections.Generic;
Using System.Linq;
Using System.Web;
Using System.Web.UI;
Using System.Web.UI.WebControls;
public partial class Default2:System.Web.UI.Page
{
Private Mydbdatacontext _context = new Mydbdatacontext ();
private void Fillbrand ()
{
var query = _context.brand;
Ddlbrand.datasource = query;
Ddlbrand.datatextfield = "Brand_Name";
Ddlbrand.datavaluefield = "Brand_Code";
Ddlbrand.databind ();
}
protected void Page_Load (object sender, EventArgs e)
{
if (! IsPostBack)
{
Fillbrand ();
}
}
Core code:
protected void Button1_Click (object sender, EventArgs e)
{
var query1 = _context.car.asqueryable (); According to the name of the default should be the complete
var query2 = _context.car.asqueryable ();//based on series check
var query3 = _context.car.asqueryable ();//based on fuel consumption check
Complete the above three query conditions according to the input box fill situation
if (TxtName.Text.Trim (). Length > 0)
{
Query1 = Query1. Where (p = p.name.contains (txtName.Text));
}
if (ddlbrand.selectedvalue! = "-1")
{
Query2 = Query2. Where (p = = P.brand = = Ddlbrand.selectedvalue);
}
if (TxtOil.Text.Trim (). Length > 0)
{
Query3 = Query3. Where (p = = P.oil = = Convert.todecimal (txtoil.text));
}
Three query conditions are logical relationships that can be implemented using the intersection of collection operations
var query = Query1. Intersect (Query2). Intersect (Query3);
Binding display
Repeater1.datasource = query;
Repeater1.databind ();
}
}
*********************************************************************************************
The use of single and check controls in Repeater JS Combat application
*********************************************************************************************
Default.aspx Web Interface
<%@ page language= "C #" autoeventwireup= "true" codefile= "Default3.aspx.cs" inherits= "DEFAULT3"%>
<! DOCTYPE html>
<meta http-equiv= " Content-type "content=" text/html; Charset=utf-8 "/>
<title></title>
<script language=" javascript ";
function Checkall ( Ckall) {
//Find all the check boxes to the left of each item.
var cks = document.getelementsbyname ("ck");
//Iterate through each check box to set the selected state of each check box to be the same as Chkall
for (var i = 0; i < cks.length; i++) {
cks[i].checked = ckall.checked;}
}
function Setcheckall () {
///idea: Iterate through the check boxes of all items to determine whether to select all. If it is all selected, set the Ckall to selected, or leave it unchecked.
//1. Locate the check box for all items.
var cks = document.getelementsbyname ("ck");
//2. Traverse each check box to record whether it is selected all.
var selectedall = true;
for (var i = 0; i < cks.length; i++) {
Selectedall = Selectedall && cks[i].checked;
}
//3. Determine the selected state of Ckall
var ckall = document.getElementById ("Ckall") depending on whether the state is selected as a whole,
ckall.checked = Selectedall;
}
Function Dodelete () {
//1. Find the check box for all items.
var cks = document.getelementsbyname ("ck");
2. Determine if there are any selected items
var SelectedItem = false;
for (var i = 0; i < cks.length; i++) {
SelectedItem = cks[i].checked | | SelectedItem;
}
3. Give different dialog box prompts depending on the selected item
if (SelectedItem = = False) {
Alert ("Please select the item to delete");
return false;
}
else {
var del = confirm ("Confirm that you want to delete the selected item?") ");
Return del;
}
}
</script>
<body>
<form id= "Form1" runat= "Server" >
<div>
<asp:repeater id= "Repeater1" runat= "Server" >
<HeaderTemplate>
<table width= "100%" border= "0" cellspacing= "5" >
<tr>
<td>
<input id= "Ckall" name= "Ckall" type= "checkbox" onclick= "Checkall (This)"/>
</td>
<td> name </td>
<td> Series </td>
<td> Manufacturers </td>
<td> Price </td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<input id= "ck_<%# eval (" code ")%>" name= "ck" type= "checkbox" Value= "<%# Eval (" code ")%>" onclick= " Setcheckall () "/>
</td>
<td><%# Eval ("Name")%></td>
<td><%# Eval ("brandname")%></td>
<td><%# Eval ("ProdName")%></td>
<td><%# Eval ("Price")%></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</div>
<asp:button id= "Button1" runat= "Server" onclientclick= "return Dodelete ()" onclick= "Button1_Click" text= "delete"/>
<br/>
<asp:label id= "Label1" runat= "Server" text= "Label" ></asp:Label>
<asp:literal id= "Literal1" runat= "Server" ></asp:Literal>
</form>
</body>
Defaule.aspx.cs C # interface
Using System;
Using System.Collections.Generic;
Using System.Linq;
Using System.Web;
Using System.Web.UI;
Using System.Web.UI.WebControls;
public partial class Default3:System.Web.UI.Page
{
Private Mydbdatacontext _context = new Mydbdatacontext ();
protected void Page_Load (object sender, EventArgs e)
{
if (! IsPostBack)
{
Show ();
}
}
private void Show ()
{
var query = _context.car;
Repeater1.datasource = query;
Repeater1.databind ();
}
protected void Button1_Click (object sender, EventArgs e)
{
if (request["CK"]! = NULL)
{
Gets the primary key value of the selected item
string s = request["CK"]. ToString (); The value of the selected item, used, separated.
String[] keys = s.split (', '); Splits the string above to form an array of primary key values.
Delete data based on the primary key value above
foreach (string key in keys)
{
var query = _context.car.where (P=>p.code = = key);
if (query. Count () > 0)
{
Car data = query. First ();
_context.car.deleteonsubmit (data);
_context.submitchanges ();
}
}
Refresh Display
Show ();
Literal1.text = "<script language= ' JavaScript ' >alert (' delete succeeded ') </script>";
}
}
}
Webfrom Generate serial number combination query repeater the use of radio and check control JS combat application