<%@ Page Language=
"C#" AutoEventWireup=
"true" CodeFile=
"Default.aspx.cs" Inherits=
"_Default" %>
<%@ Register Assembly=
"PublicControls" Namespace=
"PublicControls" TagPrefix=
"mycols" %>
<!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>
<title>产品列表</title>
<style type=
"text/css">
body{background-
color: #fff;}
DIV.scott{PADDING: 2px; MARGIN: 1px; TEXT-ALIGN: right; font-
size:12px;}
DIV.scott A {PADDING-RIGHT: 5px;PADDING-LEFT: 5px; PADDING-BOTTOM: 2px; MARGIN-
RIGHT: 2px; color:#4E4639;
PADDING-TOP: 2px; BORDER: rgb(
167,
176,
185) 1px solid; TEXT-
DECORATION: none;}
DIV.scott A:hover {BORDER: rgb(167,
176,
185) 1px solid; COLOR: #
638425; BACKGROUND-
COLOR: #C3BCB0}
DIV.scott A:active {BORDER: rgb(167,
176,
185) 1px solid; COLOR: #
638425; BACKGROUND-
COLOR: #C3BCB0}
DIV.scott SPAN.current {BORDER: rgb(167,
176,
185) 1px solid; PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FONT-
WEIGHT: bold;
PADDING-BOTTOM: 2px; COLOR: #fff; MARGIN-RIGHT: 2px; PADDING-TOP: 2px; BACKGROUND-COLOR: rgb(
0,
62,
139)}
DIV.scott SPAN.disabled {BORDER: rgb(167,
176,
185) 1px solid; PADDING-RIGHT: 3px;PADDING-
LEFT: 3px;
PADDING-BOTTOM: 2px; COLOR: #ccc; MARGIN-RIGHT: 2px; PADDING-
TOP: 2px;}
</style>
<script type=
"text/javascript" src=
"js/jquery-1.5.1.min.js"></script>
<script type=
"text/javascript">
$(function(){
var tempColor;
$("th").css(
"color",
"#4A79A3");
$("tr:even").css(
"backgroundColor",
"#ecf5fe");
$("tr:gt(0)").mouseover(function(){
tempColor = $(
this).css(
"backgroundColor");
$(this).css(
"backgroundColor",
"#339900");
}).mouseout(function(){
$(this).css(
"backgroundColor",tempColor);
});
});
</script>
</head>
<body>
<%=_sbPros %>
<form id=
"form1" runat=
"server">
<mycols:MccNetPager ID=
"MyPager1" StyleString=
"class='scott'" Next=
"下一页" Last=
"尾页"
Pres=
"..." Nexts=
"..." Pre=
"上一页" First=
"首页" Pages=
"10" runat=
"server" Pagesize=
"2"
OnPageIndexChange=
"MyPager1_PageIndexChange">
</mycols:MccNetPager>
</form>
</body>
</html>
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.Linq;
public partial class _Default : System.Web.UI.Page
{
ProDALDataContext dcPro =
new ProDALDataContext();
public System.Text.StringBuilder _sbPros =
new System.Text.StringBuilder();
protected void Page_Load(
object sender, EventArgs e)
{
if (!
IsPostBack)
bind();
//(from e1 in dcPro.hr_product select 0).Count();共多少条数据
//var aa = from e1 in dcPro.hr_product select e1;查询所有数据
//var aa = from e1 in dcPro.hr_product select new { e1.pid, e1.title };查询pid，title两列
//var aa = from e1 in dcPro.hr_product select new { ID = e1.pid, bt = e1.title };查询pid，title两列取别名
//var aa = (from e1 in dcPro.hr_product select new { e1.title, e1.pid }).Distinct();去掉重复的pid,title数据
//var aa = from e1 in dcPro.hr_product where e1.title == "极速越野摩托" select new { e1.title, e1.pid };查询title为“极速越野摩托”的数据
//var aa = from e1 in dcPro.hr_product where e1.title == "极速越野摩托" && e1.pid == 28 select new { e1.title, e1.pid };查询title为“极速越野摩托”并且pid为28的数据
//var aa = from e1 in dcPro.hr_product where e1.oldprice >= 50 && e1.oldprice <= 100 select new { e1.title, e1.pid };查询oldprice区间在50-100的数据
//var aa = from e1 in dcPro.hr_product orderby e1.title select new { e1.title, e1.pid };数据按title排序
//var aa = from e1 in dcPro.hr_product orderby e1.title descending, e1.pid ascending select new { e1.title, e1.pid };数据按title降序pid升序
//var aa = from e1 in dcPro.hr_product where e1.title.StartsWith("产品") select new { e1.title, e1.pid };数据like‘产品’
//var aa = from e1 in dcPro.hr_product group e1 by e1.title into g select new { zg = g.Sum(e1 => e1.oldprice) };按照title分组后oldprice的和
//var aa = from e1 in dcPro.hr_product group e1 by e1.title into g where g.Count() >= 2 select new { bt = g.Key, zg = g.Sum(e1 => e1.oldprice) };按照title分组后记录数大于等于2的title，oldprice的和
//var aa = from e1 in dcPro.hr_product from e2 in dcPro.hr_productType where e1.Ptid == e2.Ptid select new { e1, e2 };同时查询两张表
//var aa = from e1 in dcPro.hr_product join e2 in dcPro.hr_productType on e1.Ptid equals e2.Ptid select new { e1, e2 };内连接查询
//var aa = from e1 in dcPro.hr_product join e2 in dcPro.hr_productType on new { id = e1.pid, tid = e1.pid } equals new { id = e2.Ptid, tid = e2.Ptid } select new { e1, e2 };内连接同时满足多个条件
//var aa = from e1 in dcPro.hr_product join e2 in dcPro.hr_productType on e1.Ptid equals e2.Ptid into e3 select new { e1, e3 };外连接查询
//var aa = (from e1 in dcPro.hr_product select new { id = e1.title }).Union(from e2 in dcPro.hr_productType select new { id = e2.name });联合数据且不重复
//var aa = (from e1 in dcPro.hr_product where e1.pid > 2 select e1).Take(10);查询前10条pid大于2的
//var aa = from e1 in dcPro.hr_product where (from e2 in dcPro.hr_productType where e2.Ptid == 2 select e2.Ptid).Contains(Convert.ToInt32(e1.Ptid)) select e1;查询ptid等于2的数据
}
public void bind()
{
var zjls =
from e1
in dcPro.hr_product
select 0;
int ll =
zjls.Count();
_sbPros.Append("<table><tr><th>ID</th><th>名称</th></tr>");
if (MyPager1.Pageindex ==
0)
{
var aa = (
from e1
in dcPro.hr_product
select e1).Take(MyPager1.Pagesize);
foreach (
var bb
in aa)
_sbPros.Append("<tr><td>" + bb.pid +
"</td><td>" + bb.title +
"</td></tr>");
}
else
{
int sl = MyPager1.Pageindex *
MyPager1.Pagesize;
var cc = (
from e1
in dcPro.hr_product
select e1).Skip(sl).Take(MyPager1.Pagesize);
foreach (
var bb
in cc)
_sbPros.Append("<tr><td>" + bb.pid +
"</td><td>" + bb.title +
"</td></tr>");
}
_sbPros.Append("</table>");
MyPager1.Count =
ll;
}
protected void MyPager1_PageIndexChange(
object sender, EventArgs e)
{
bind();
}
}
转载于:https://www.cnblogs.com/daixingqing/archive/2012/11/13/2768365.html
相关资源：JAVA上百实例源码以及开源项目
