1688.com,阿里巴巴打造的全球最大的采购批发平台
1688/淘宝会员（仅限会员名）请在此登录
cbulogin.et2Server is OK1688.com,阿里巴巴打造的全球最大的采购批发平台
1688/淘宝会员（仅限会员名）请在此登录
cbulogin.et2Server is OK1688.com,阿里巴巴打造的全球最大的采购批发平台
1688/淘宝会员（仅限会员名）请在此登录
cbulogin.center.eu13Server is OKjingmeifeng的专栏
https://blog.csdn.net/
https://static-blog.csdn.net/images/logo.gif
https://blog.csdn.net/jingmeifeng
https://blog.csdn.net/
https://blog.csdn.net/jingmeifeng/article/details/
https://blog.csdn.net/jingmeifeng/article/details/
jingmeifeng
int? id 表示id是可以为null的整型 跟Nullable&int& id 是一样的
id ?? 1等于 id==null?1:
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/
阅读：2456
https://blog.csdn.net/jingmeifeng/article/details/8934715
https://blog.csdn.net/jingmeifeng/article/details/8934715
jingmeifeng
js里用escape编码后，在asp.net后台页面是不需要再解码的
在前台只需
window.location.href = "/CustomerIndex/ProductByCategory?pname=" +escape(“苹果”);
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/8934715
https://blog.csdn.net/jingmeifeng/article/details/8153907
https://blog.csdn.net/jingmeifeng/article/details/8153907
jingmeifeng
说明：用于判断集合中是否包含有某一元素；不延迟。它是对两个序列进行连接操作的。
string[] customerID_Set =
new string[] { "AROUT", "BOLID", "FISSA" };
from o in db.Orders
where customerID_Set.Contains(o.CustomerID)
select o).ToList();
语句描述：查找"AROUT", "BOLID" 和 "FISSA" 这三个客户的订单。先定义了一个数组，在LINQ to SQL中使用Contains，数组中包含了所有的CustomerID，即返回结果中，所有的CustomerID都在这个集合内。也就是in。 你也可以把数组的定义放在LINQ to SQL语句里。比如：
from o in db.Orders
new string[] { "AROUT", "BOLID", "FISSA" })
.Contains(o.CustomerID)
select o).ToList();
var tagMapIdList = from tagMap in nplusDatabaseDataContext.TagMap
where contentId == tagMap.ContentId
select tagMap.TagId;
var tagIdList = from tag in nplusDatabaseDataContext.Tag
where tagMapIdList.Contains(tag.Id) && tag.ContentType == contentType
select tag.Id;
如果查找数据中是否存在单个值时，可直接取值。
如果需查找多个数据时。
数据需存在string[]里进行查找
Linq to Sql 语句查出的多个值，不能First()及ToList()，只有是Linq语句时，才可以查找
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/8153907
阅读：4508
https://blog.csdn.net/jingmeifeng/article/details/8129414
https://blog.csdn.net/jingmeifeng/article/details/8129414
jingmeifeng
var id = $("#newstable").jqGrid("getGridParam", "selrow");　　　//单行
var selectedId = $("#newstable").jqGrid("getGridParam", "selarrrow"); //多行
jqgrid使用：常用属性用法和含义
1. 如何获取grid选中的行的ID？
Javascript代码
var rowid = $( "#searchResultList" ).getGridParam( "selrow" );
var rowid = $("#searchResultList").getGridParam("selrow");
2. 如何在表格中动态增加一行数据？
Javascript代码
//$("#jqgrid").addRowData(rowId, data, pos, idx);
//pos可以为[first,last,before,after],为后两者是需要指定相对的行ID
$( "#jqgrid" ).addRowData( "1" , { "name" : "test" , "age" :12}, "first" );
//$("#jqgrid").addRowData(rowId, data, pos, idx);
//pos可以为[first,last,before,after],为后两者是需要指定相对的行ID
$("#jqgrid").addRowData("1", {"name":"test","age":12}, "first");
3. 如何动态修改某行的数据内容，如某几列的值？
Javascript代码
//setRowData( rowid, data );
$( "#jqgrid" ).setRowData( "1" , { tax: "5" , total: "205" });
//setRowData( rowid, data );
$("#jqgrid").setRowData( "1", { tax:"5", total:"205" });
4. jqgrid的常用属性？
Javascript代码
$( "#jqgrid" ).jqGrid({
url: "${ctx}/sys/role/search.dm" ,
colNames:[ "角色名称" ], //,"角色代码"
colModel:[ "roleName" ], //"roleCode"还可以用对象替换
jsonReader:{id: "roleId" ,root: "dataList" },
width:240,
height:250,
rowNum:20, //每页20条记录
pager: "logListPager" , //分页显示的DIVID
sortname: "actionTime" , //默认排序的列名
sortorder: "desc" , //默认排序的顺序
scroll: true , //鼠标滚动翻页
onSelectRow: function (rowid) {}
$("#jqgrid").jqGrid({
url:"${ctx}/sys/role/search.dm",
colNames:["角色名称"],//,"角色代码"
colModel:["roleName"],//"roleCode"还可以用对象替换
jsonReader:{id:"roleId",root:"dataList"},
width:240,
height:250,
rowNum:20,//每页20条记录
pager: "logListPager",//分页显示的DIVID
sortname: "actionTime",//默认排序的列名
sortorder: "desc",//默认排序的顺序
scroll:true,//鼠标滚动翻页
onSelectRow: function(rowid) {}
5. 获取某一行的数据对象？
Javascript代码
var rowid = $( "#searchResultList" ).getGridParam( "selrow" );
var rowData = $( "#searchResultList" ).getRowData(rowid);
var rowid = $("#searchResultList").getGridParam("selrow");
var rowData = $("#searchResultList").getRowData(rowid);
6. 如何使用API动态修改选中的行？
Javascript代码
//true:重新加载表格数据, false:不重新加载表格数据
$( "#jqGrid" ).setSelection( "1" , true );
//true:重新加载表格数据, false:不重新加载表格数据
$("#jqGrid").setSelection("1", true);
7.如何获取某一列的值
Javascript代码
var col= jQuery("#jqGrid ").jqGrid('getCol',4,false);//获取第4列的值
var col= jQuery("#jqGrid ").jqGrid('getCol','name',false);//获取列名为name的列的值
8.如何删除一行或多行
var selectedId = $("#gridTable").jqGrid("getGridParam", "selrow");
$("#gridTable").jqGrid('delRowData', selectedId);
还有以下常用的API，
Javascript代码
$( "#jqgrid" ).resetSelection();
$( "#jqgrid" ).clearGridData();
$( "#jqgrid" ).setCell(rowid,colname,nData,cssp,attrp);
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/8129414
阅读：7644 评论：1
https://blog.csdn.net/jingmeifeng/article/details/7904915
https://blog.csdn.net/jingmeifeng/article/details/7904915
jingmeifeng
JQuery 元素选择器
jQuery 使用 CSS 选择器来选取 HTML 元素。
$("p") 选取 &p& 元素。
$("p.intro") 选取所有 class="intro" 的 &p& 元素。
$("p#demo") 选取 id="demo" 的第一个 &p& 元素
JQuery 属性选择器。
jQuery 使用 XPath 表达式来选择带有给定属性的元素。
$("[href]") 选取所有带有 href 属性的元素。
$("[href='#']") 选取所有带有 href 值等于 "#" 的元素。
$("[href!='#']") 选取所有带有 href 值不等于 "#" 的元素。
$("[href$='.jpg']") 选取所有 href 值以 ".jpg" 结尾的元素。
JQuery css选择器
jQuery CSS 选择器可用于改变 HTML 元素的 CSS 属性。
下面的例子把所有 p 元素的背景颜色更改为红色：
$("p").css("background-color","red");
更多的选择器
$(this) 当前 HTML 元素
$("p") 所有 &p& 元素
$("p.intro") 所有 class="intro" 的 &p& 元素
$(".intro") 所有 class="intro" 的元素
$("#intro") id="intro" 的第一个元素
$("ul li:first") 每个 &ul& 的第一个 &li& 元素
$("[href$='.jpg']") 所有带有以 ".jpg" 结尾的属性值的 href 属性
$("div#intro .head") id="intro" 的 &div& 元素中的所有 class="head" 的元素
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7904915
https://blog.csdn.net/jingmeifeng/article/details/7903941
https://blog.csdn.net/jingmeifeng/article/details/7903941
jingmeifeng
Css3中新增了resize缩放属性，这个属性可以应用到任意元素。目前只有Webkit内核的浏览器才支持这个css3属性，即Google chrome和Apple safari都支持。
如textarea标签中，Webkit内核的浏览器会默认resize的值为both，即用户可以调节元素的宽度和高度。如下图就是在Google chrome中的textarea的默认显示，textarea右下角有一个可以控制缩放的按钮。
一般情况下，textarea是被固定宽度和高度的，如果你不愿意让其任意缩放，你可以为textarea添加resize:none的css属性。这样就可以去除Webkit内核的浏览器的默认显示。
将textarea中resize的属性值设置成vertical，这个是允许用户只能调节高度，这样页面就不会变形了。
以下是resize属性的的各个取值:
none：用户不能操纵机制调节元素的尺寸；
both：用户可以调节元素的宽度和高度；
horizontal：用户可以调节元素的宽度；
vertical：让用户可以调节元素的高度；
inherit：默认继承。
&textarea name="Remarks" rows="2" cols="20" id="Remarks" class="textBox" onfocus="this.className='textBoxOver';myfocus()"
onblur="this.className='textBox';myblur();"
style="height: 60 width: 86%;max-height: 60max-width:420 resize="&特殊要求请在这里中标明&/textarea&
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7903941
阅读：7681
https://blog.csdn.net/jingmeifeng/article/details/7844024
https://blog.csdn.net/jingmeifeng/article/details/7844024
jingmeifeng
下面这个存储过程将列出数据库的所有表的创建时间:
Create proc usp_alldatabases
declare @script as nvarchar(2000)
exists(select 1 from sysobjects where name='tab_alltables') drop table tab_alltables
create table tab_alltables (db nvarchar(1000), tab nvarchar(1000),cdate datetime)
declare c cursor
select 'insert into tab_alltables (tab,db,cdate) select name,'''+name+ ''',crdate from ' +name+'..sysobjects where xtype=''u''' from master..sysdatabases
where dbid&4
fetch c into @script
while @@fetch_status=0
exec (@script)
print @script
fetch c into @script
close c deallocate c
select * from tab_alltables --You can add your criteria here to serach for a particular table name
这个SP将产生三列：
1) db: 数据库名称
2) tab : 表名称
3) cdate： 表的创建时间
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7844024
阅读：2217
https://blog.csdn.net/jingmeifeng/article/details/7843973
https://blog.csdn.net/jingmeifeng/article/details/7843973
jingmeifeng
List&string& list = new List&string&();
list.Add("I");
list.Add("Love");
list.Add("You");
string kk = string.E
kk = string.Join("-", list);
Response.Write(kk);
I-Love-You
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7843973
阅读：15515
https://blog.csdn.net/jingmeifeng/article/details/7843871
https://blog.csdn.net/jingmeifeng/article/details/7843871
jingmeifeng
public static string Pinyin(string Chstr)
//定义拼音区编码数组
int[] getValue = new int[]
-2,-2,-2,-2,-2,-2,
-2,-2,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1, -1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1,
-1,-1,-1,-1,-1,-1
//定义拼音数组
string[] getName = new string[]
"A","Ai","An","Ang","Ao","Ba","Bai","Ban","Bang","Bao","Bei","Ben",
"Beng","Bi","Bian","Biao","Bie","Bin","Bing","Bo","Bu","Ba","Cai","Can",
"Cang","Cao","Ce","Ceng","Cha","Chai","Chan","Chang","Chao","Che","Chen","Cheng",
"Chi","Chong","Chou","Chu","Chuai","Chuan","Chuang","Chui","Chun","Chuo","Ci","Cong",
"Cou","Cu","Cuan","Cui","Cun","Cuo","Da","Dai","Dan","Dang","Dao","De",
"Deng","Di","Dian","Diao","Die","Ding","Diu","Dong","Dou","Du","Duan","Dui",
"Dun","Duo","E","En","Er","Fa","Fan","Fang","Fei","Fen","Feng","Fo",
"Fou","Fu","Ga","Gai","Gan","Gang","Gao","Ge","Gei","Gen","Geng","Gong",
"Gou","Gu","Gua","Guai","Guan","Guang","Gui","Gun","Guo","Ha","Hai","Han",
"Hang","Hao","He","Hei","Hen","Heng","Hong","Hou","Hu","Hua","Huai","Huan",
"Huang","Hui","Hun","Huo","Ji","Jia","Jian","Jiang","Jiao","Jie","Jin","Jing",
"Jiong","Jiu","Ju","Juan","Jue","Jun","Ka","Kai","Kan","Kang","Kao","Ke",
"Ken","Keng","Kong","Kou","Ku","Kua","Kuai","Kuan","Kuang","Kui","Kun","Kuo",
"La","Lai","Lan","Lang","Lao","Le","Lei","Leng","Li","Lia","Lian","Liang",
"Liao","Lie","Lin","Ling","Liu","Long","Lou","Lu","Lv","Luan","Lue","Lun",
"Luo","Ma","Mai","Man","Mang","Mao","Me","Mei","Men","Meng","Mi","Mian",
"Miao","Mie","Min","Ming","Miu","Mo","Mou","Mu","Na","Nai","Nan","Nang",
"Nao","Ne","Nei","Nen","Neng","Ni","Nian","Niang","Niao","Nie","Nin","Ning",
"Niu","Nong","Nu","Nv","Nuan","Nue","Nuo","O","Ou","Pa","Pai","Pan",
"Pang","Pao","Pei","Pen","Peng","Pi","Pian","Piao","Pie","Pin","Ping","Po",
"Pu","Qi","Qia","Qian","Qiang","Qiao","Qie","Qin","Qing","Qiong","Qiu","Qu",
"Quan","Que","Qun","Ran","Rang","Rao","Re","Ren","Reng","Ri","Rong","Rou",
"Ru","Ruan","Rui","Run","Ruo","Sa","Sai","San","Sang","Sao","Se","Sen",
"Seng","Sha","Shai","Shan","Shang","Shao","She","Shen","Sheng","Shi","Shou","Shu",
"Shua","Shuai","Shuan","Shuang","Shui","Shun","Shuo","Si","Song","Sou","Su","Suan",
"Sui","Sun","Suo","Ta","Tai","Tan","Tang","Tao","Te","Teng","Ti","Tian",
"Tiao","Tie","Ting","Tong","Tou","Tu","Tuan","Tui","Tun","Tuo","Wa","Wai",
"Wan","Wang","Wei","Wen","Weng","Wo","Wu","Xi","Xia","Xian","Xiang","Xiao",
"Xie","Xin","Xing","Xiong","Xiu","Xu","Xuan","Xue","Xun","Ya","Yan","Yang",
"Yao","Ye","Yi","Yin","Ying","Yo","Yong","You","Yu","Yuan","Yue","Yun",
"Za", "Zai","Zan","Zang","Zao","Ze","Zei","Zen","Zeng","Zha","Zhai","Zhan",
"Zhang","Zhao","Zhe","Zhen","Zheng","Zhi","Zhong","Zhou","Zhu","Zhua","Zhuai","Zhuan",
"Zhuang","Zhui","Zhun","Zhuo","Zi","Zong","Zou","Zu","Zuan","Zui","Zun","Zuo"
Regex reg = new Regex("^[\u4e00-\u9fa5]$");//验证是否输入汉字
byte[] arr = new byte[2];
string pystr = "";
int asc = 0, M1 = 0, M2 = 0;
char[] mChar = Chstr.ToCharArray();//获取汉字对应的字符数组
for (int j = 0; j & mChar.L j++)
//如果输入的是汉字
if (reg.IsMatch(mChar[j].ToString()))
arr = System.Text.Encoding.Default.GetBytes(mChar[j].ToString());
M1 = (short)(arr[0]);
M2 = (short)(arr[1]);
asc = M1 * 256 + M2 - 65536;
if (asc & 0 && asc & 160)
pystr += mChar[j];
switch (asc)
case -9254:
pystr += "Zhen";
case -8985:
pystr += "Qian";
case -5463:
pystr += "Jia";
case -8274:
pystr += "Ge";
case -5448:
pystr += "Ga";
case -5447:
pystr += "La";
case -4649:
pystr += "Chen";
case -5436:
pystr += "Mao";
case -5213:
pystr += "Mao";
case -3597:
pystr += "Die";
case -5659:
pystr += "Tian";
for (int i = (getValue.Length - 1); i &= 0; i--)
if (getValue[i] &= asc)//判断汉字的拼音区编码是否在指定范围内
pystr += getName[i];//如果不超出范围则获取对应的拼音
else//如果不是汉字
pystr += mChar[j].ToString();//如果不是汉字则返回
//返回获取到的汉字拼音
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7843871
阅读：1604
https://blog.csdn.net/jingmeifeng/article/details/7843728
https://blog.csdn.net/jingmeifeng/article/details/7843728
jingmeifeng
let子句用于在LINQ表达式中存储子表达式的计算结果。let子句创建一个范围变量来存储结果，变量被创建后，不能修改或把其他表达式的结果重新赋值给它。此范围变量可
//以再后续的LINQ子句中使用。
public class Singer
public string Name { }
public int Age { }
List&Singer& list = new List&Singer&(){
new Singer{Name="zhangs" ,Age=21},
new Singer{Name="zhangs",Age=25},
new Singer{Name="margy",Age=21}
var query = from a in list
let b = a.Name
let c=a.Age
where b =="zhangs" & c&21
foreach (var item in query)
Response.Write("姓名: "+item.Name+"
年龄:"+item.Age);
姓名: zhangs 年龄:25
//使用let 建立了个范围变量，这个范围变量在后续的where子句中使用，如果不使用let子句，where子句的表达式将写成这样：
//where a.Name=="zhangs" & a.Age&21
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7843728
阅读：5547 评论：1
https://blog.csdn.net/jingmeifeng/article/details/7835199
https://blog.csdn.net/jingmeifeng/article/details/7835199
jingmeifeng
public class Stu
public int ID { } //学生的编号
public string Name { } //学生的姓名
public int CourseId { } //学生所选课程的id
public class Course
public int ID { } //课程的编号
public string Cname { }//课程的名称
protected void Page_Load(object sender, EventArgs e)
List&Stu& list = new List&Stu& {
new Stu { ID = 1001, Name = "zhangsan", CourseId=1},
new Stu{ID=1002,Name="lisi", CourseId=2},
new Stu{ID=1003,Name="wangwu", CourseId=3},
new Stu{ID=1004,Name="zhouliu", CourseId=1}
List&Course& clist = new List&Course&{
new Course{ ID=1,Cname="php"},
new Course{ID=3,Cname=".net"}
1.内部联接
var query = from a in list
join b in clist
on a.CourseId equals b.ID
//根据学生所选的课程id，得到学生所选课程的名称
select new { a.Name, b.Cname };
foreach (var item in query)
Response.Write("姓名: "+item.Name+"
课程: "+item.Cname+"&br/&");
//姓名: zhangsan 课程: php
//姓名: wangwu 课程: .net
//姓名: zhouliu 课程: php
//类似于sql中右连接查询
var query = from a in list
join b in clist
on a.CourseId equals b.ID into hh
select new
sname = a.Name,
cname = hh
foreach (var item in query)
Response.Write(item.sname + " :");
foreach (var s in item.cname)
Response.Write(s.Cname + ",");
Response.Write("&br/&");
//zhangsan :php,
//wangwu :.net,
//zhouliu :php,
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7835199
https://blog.csdn.net/jingmeifeng/article/details/7814350
https://blog.csdn.net/jingmeifeng/article/details/7814350
jingmeifeng
说明：在查询表达式中，select 子句可以指定将在执行查询时产生的值的类型。 该子句的结果将基于前面所有子句的计算结果以及 select 子句本身中的所有表达式。 查询表达式必须以 select 子句或 group 子句结束。
Select操作包括7种形式，分别为简单用法、匿名类型形式、条件形式、筛选形式、嵌套类型形式、本地方法调用形式、Distinct形式.。
class Student
public string Name { }
public int Score { }
List&Student& students = new List&Student&{
new Student {Name="Terry", Score=50},
new Student {Name="AI", Score=80},
new Student {Name="AI", Score=70},
1.简单用法
说明:当以select结尾时表示的只是一个声明或者一个描述，并没有真正把数据取出来，只有当你需要该数据的时候，它才会执行这个语句，这就是延迟加载(deferred loading)。
var query = from student in students
select student.N
foreach (var student in query)
response.write("姓名："+student);
2.匿名类型形式
说明：其实质是编译器根据我们自定义产生一个匿名的类来帮助我们实现临时变量的储存。例如 var ob = new {Name = "Harry"}，编译器自动产生一个有property叫做Name的匿名类，然后按这个类型分配内存，并初始化对象。
var query = from student in students
select new
newName = "学生姓名：" + student.Name
foreach (var student in query)
response.write(student.newName);
//学生姓名：Terry
//学生姓名：AI
//学生姓名：AI
3.条件形式
说明：三元运算，类似于SQL语句case when condition then else的用法。
var query = from student in students
select new
student.Name,
level = student.Score & 60 ? "不及格" : "合格"
foreach (var student in query)
response.write(student.Name+":"+student.level);
//Terry:不及格
4.筛选形式
说明：结合where用起到过滤的作用。
var query = from student in students
where student.Name == "Terry"
foreach (var student in query)
response.write(student.Name,student.Score);
//Terry:50
5.嵌套类型形式
说明：如果一个数据源里面又包含了一个或多个集合列表，那么应该使用复合的select子句来进行查询。
查询大于80分的学生分数：
class Student
public string Name { }
public List&int& Scores { }
List&Student& students = new List&Student&{
new Student {Name="Terry", Scores=new List&int& {97, 72, 81, 60}},
new Student {Name="AI", Scores=new List&int& {75, 84, 91, 39}},
new Student {Name="Wade", Scores=new List&int& {88, 94, 65, 85}},
new Student {Name="Tracy", Scores=new List&int&{97, 89, 85, 82}},
new Student {Name="Kobe", Scores=new List&int& {35, 72, 91, 70}}
var query = from student in students
select new
student.Name,
//生成新的集合对象
highScore=from sc in student.Scores
where sc&80
foreach (var student in query)
Console.Write("{0}:",student.Name);
foreach (var scores in student.highScore)
Console.Write("{0},",scores);
Console.WriteLine();
//Terry:97,81,
//AI:84,91,
//Wade:88,94,85,
//Tracy:97,89,85,82,
//Kobe:91,
6.本地方法调用形式
说明：调用自定义方法。
var query = from student in students
select new
student.Name,
//调用GetLevel方法
level = GetLevel(student.Score)
foreach (var student in query)
Console.WriteLine("{0}:{1}", student.Name, student.level);
//Terry:不及格
protected static string GetLevel(int score)
if (score & 60)
return "及格";
return "不及格";
7.Distinct形式
说明：用于查询不重复的结果集。类似于SQL语句SELECT DISTINCT 。
查询不重复的学生姓名：
var query = (from student in students
select student.Name).Distinct();
foreach (var student in query)
Console.WriteLine("{0}", student);
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7814350
阅读：3758
https://blog.csdn.net/jingmeifeng/article/details/7803105
https://blog.csdn.net/jingmeifeng/article/details/7803105
jingmeifeng
第一种(多个from的查询)(我的理解
相当于sql中 的子查询 、
比如一个学生类
注意此时的分数是一个集合
class Student
public string Name { }
public List&int& Scores { }
List&Student& list = new List&Student&{
new Student{ Name="张三", Scores=new List&int&{45,89,73}},
new Student{ Name="李四",Scores=new List&int&{90,89,63}},
new Student{ Name="Mery",Scores=new List&int&{86,89,63}},
new Student{ Name="Mei",Scores=new List&int&{88,89,63}}
//选出学生的科目中有不及格的同学的信息
var query = from A in list
from score in A.Scores
where score & 60
select new { name=A.Name, score };
foreach (var item in query)
Response.Write("姓名:
"+item.name+"
未及格的成绩:"+item.score);
姓名：张三
未及格的成绩：45
第二种（使用多个from相当于SQL中的合并查询但有点不一样）
我再增加一个类
public int Age { }
List&a& Mya = new List&a& { new a{Age=99}};
var query = from s in list
from s2 in Mya
select new { name1=s.Name, age=s2.Age };
foreach (var item in query)
Response.Write(item.name1+item.age+“&br/&”);
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7803105
阅读：1547
https://blog.csdn.net/jingmeifeng/article/details/7803035
https://blog.csdn.net/jingmeifeng/article/details/7803035
jingmeifeng
比如一个学生类
class Student
public string Name { }
public int Score { }
public string Sex { }
List&Student& list = new List&Student&{
new Student{ Name="张三",Score=96, Sex="男"},
new Student{ Name="李四",Score=80, Sex="男"},
new Student{ Name="Mery",Score=96, Sex="女"},
new Student{ Name="Mei",Score=85, Sex="女"}
//得到第一个学生的信息
var s = list.First();
Response.Write(s.Name);
//结果 张三
//得到分数大于85，并且性别为女的第一个学生的信息
var student2 = list.First(a=&a.Score&85 &&a.Sex=="女");
Response.Write(student2.Name);
//结果 Mary
//得到分数大于85最后一个学生的信息
var student3 = list.Last(a =& a.Score & 85);
Response.Write(student2.Name);
//结果 Mary
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7803035
阅读：2739
https://blog.csdn.net/jingmeifeng/article/details/7802991
https://blog.csdn.net/jingmeifeng/article/details/7802991
jingmeifeng
比如有一个学生类
class Student
public string Name { }
public int Score { }
public string Sex { }
List&Student& list = new List&Student&{
new Student{ Name="张三",Score=96, Sex="男"},
new Student{ Name="李四",Score=80, Sex="男"},
new Student{ Name="Mery",Score=96, Sex="女"},
new Student{ Name="Mei",Score=85, Sex="女"}
//选择分数大于90并且性别为女的学生
var query1 = from A in list
where A.Score & 90 && A.Sex == "女"
foreach (var s in query1)
Response.Write("姓名："+s.Name+"
成绩:"+s.Score);
//得到的结果
姓名：Mery
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7802991
https://blog.csdn.net/jingmeifeng/article/details/7802753
https://blog.csdn.net/jingmeifeng/article/details/7802753
jingmeifeng
LINQ，语言集成查询（Language INtegrated Query）是一组用于c#和Visual Basic语言的扩展。
它允许编写C#或者Visual Basic代码以查询数据库相同的方式操作内存数据。
1. LINQ的读法：(1)lin k (2)lin q
　　2. LINQ的关键词：from, select, in, where, group by, orderby, …
　　3. LINQ的注意点：必须以select或者是group by 结束。
　　4. LINQ的语义：
　　from 临时变量 in 集合对象或数据库对象
　　where 条件表达式
　　[orderby条件]
　　[group by 条件]
　　select 临时变量中被查询的值
　　LINQ的查询返回值的类型是临时变量的类型，可能是一个对象也可能是一个集合。并且LINQ的查询表达式是在最近一次创建对象时才被编译的。LINQ的查询一般跟var关键字一起联用 (什么是var？匿名对象) 。
　　5. LINQ的全称：Language-Integrated Query
　　6. LINQ的分类：LINQ to Object（对对象），LINQ to XML（对xml）, LINQ to SQL(对Sql数据库), LINQ to DataSet（对数据集），LINQ to ADO.NET
　　7. 命名空间：System.L
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7802753
https://blog.csdn.net/jingmeifeng/article/details/7800775
https://blog.csdn.net/jingmeifeng/article/details/7800775
jingmeifeng
定义和用法
fieldset 元素可将表单内的相关元素分组。
&fieldset& 标签将表单内容的一部分打包，生成一组相关表单的字段。
当一组表单元素放到 &fieldset& 标签内时，浏览器会以特殊方式来显示它们，它们可能有特殊的边界、3D 效果，或者甚至可创建一个子表单来处理这些元素。
&fieldset& 标签没有必需的或唯一的属性。
&legend& 标签为 fieldset 元素定义标题。
组合表单中的相关元素：
&fieldset&
&legend&health information&/legend&
height: &input type="text" /&
weight: &input type="text" /&
&/fieldset&
&fieldset&
&legend&我的专业&/legend&
&label&选择所学的科目&/label&
&select id="myclass" name="myclass"&
&optgroup label="client"&
&option value="HTML"&HTML&/option&
&option value="CSS"&CSS&&/option&
&option value="JAVASCRIPT"&javascript&/option&
&/optgroup&
&optgroup label="DataBase"&
&option value="Access"&Access&/option&
&option value="MySql"&MySql&/option&
&option value="SqlServer"&SqlServer&/option&
&/optgroup&
&/fieldset&
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7800775
https://blog.csdn.net/jingmeifeng/article/details/7794608
https://blog.csdn.net/jingmeifeng/article/details/7794608
jingmeifeng
&head runat="server"&
&title&DIV始终居中的半透明弹出层&/title&
&style type="text/css"&
html, body
height: 100%;
font-size: 12
text-align:
line-height: 40
font-size: 12
font-weight:
z-index: 999;
width: 300
height: 200
left: 50%;
margin-left: -150px ! /*FF IE7 该值为本身宽的一半 */
margin-top: -60px ! /*FF IE7 该值为本身高的一半*/
margin-top: 0
position: fixed ! /* FF IE7*/
position: /*IE6*/
_top: expression(eval(document.compatMode &&
document.compatMode=='CSS1Compat') ?
documentElement.scrollTop + (document.documentElement.clientHeight-this.offsetHeight)/2 :/*IE6*/
document.body.scrollTop + (document.body.clientHeight - this.clientHeight)/2); /*IE5 IE5.5*/
background: #
width: 100%;
height: 100%;
top: 0; /*FF IE7*/
filter: alpha(opacity=50); /*IE*/
z-index: 1;
position: fixed ! /*FF IE7*/
position: /*IE6*/
_top: expression(eval(document.compatMode &&
document.compatMode=='CSS1Compat') ?
documentElement.scrollTop + (document.documentElement.clientHeight-this.offsetHeight)/2 :/*IE6*/
document.body.scrollTop + (document.body.clientHeight - this.clientHeight)/2);
margin: 0;
padding: 0;
text-align:
font: normal 14px/180% Tahoma,sans-
padding: 0
border: 1px solid #829AFF;
filter: alpha(opacity=90);
#loginBox .title
text-align:
padding-left: 10
font-size: 11
border-bottom: 1px solid #829AFF;
height: 25
line-height: 25
#loginBox .t1
font-weight:
text-decoration:
#loginBox .t2
text-align:
line-height: 18
height: 18
margin-top: 3
margin-right: 2
border: 1px solid #FF5889;
#loginBox .login
text-align:
width: 100%;
height: 100%;
input.submit
border: 1px solid #829AFF;
font-size: 9
height: 20
margin-top: 5
margin-right: 70
&script language="javascript" type="text/javascript"&
function showDiv() {
document.getElementById('loginBox').style.display = 'block';
document.getElementById('bg').style.display = 'block';
function closeDiv() {
document.getElementById('loginBox').style.display = 'none';
document.getElementById('bg').style.display = 'none';
&div id="loginBox" class="mydiv" style="display: background: #"&
&p class="title" id="Mdown"&
&span class="t1"&登录&/span&&span class="t2" title="关闭" onclick="javascript:closeDiv()"&X&/span&&/p&
&div class="login" style="z-index: 1000;"&
&form method="post" action="#"&
用户名:&input type="text" name="UserName" size="12" maxlength="10" value=""&&div class="login"&
密 码:&input type="text" name="Password" size="12" maxlength="10"&&/div&
&input class="submit" type="submit" value="登录"&&/form&
&div id="bg" class="bg" style="display:"&
&a href="javascript:showDiv()"&点击这里弹出层&/a&
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7794608
阅读：1459
https://blog.csdn.net/jingmeifeng/article/details/7792151
https://blog.csdn.net/jingmeifeng/article/details/7792151
jingmeifeng
一 Html.ActionLink("linkText","actionName")
该重载的第一个参数是该链接要显示的文字，第二个参数是对应的控制器的方法，
默认控制器为当前页面的控制器，如果当前页面的控制器为Products，则 Html.ActionLink("detail","Detail")
则会生成 &a href="/Products/Detail"&all&/a&
二 Html.ActionLink("linkText","actionName","controlName")
该重载比第一个重载多了一个参数，他指定了控制器的名称，
如Html.ActionLink("detail","Detail","Products")则会生成
&a href="Products/Detail"&all&/a&
三 Html.ActionLik("linkText","actionName",routeValues)
routeValue可以向action传递参数，如Html.ActionLink("detail","Detail",new { id=1})
会生成 &a href="Products/Detail/1"&detail&/a&，
此处假设当前的控制器是Products.
四 Html.ActionLink("linkText","actionName",routeValues,htmlAttributes)
htmlAttribute可以设置&a&标签的属性，
如 Html.ActionLink("detail","Detail",new{id=1},new{ target="_blank"})
会生成 &a href="Products/Detail/1" target="_blank"&detail&/a&,
需要主要的是如果写成 new{ target="_blank",class="className"}则会报错，
因为class是关键字，此处应该写成 @class="className"。
五 Html.ActionLink("linkText","actionName","controlName",routeValues,htmlAttributes)
该重载包含了上面提到的所有参数类型
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7792151
阅读：60982 评论：9
https://blog.csdn.net/jingmeifeng/article/details/7788603
https://blog.csdn.net/jingmeifeng/article/details/7788603
jingmeifeng
强大的Razor引擎
　一、Razor基础简介
　　Razor采用了cshtml后缀的文件名,截图如下：
　　A、 版面布局
　　从图上看到，新的视图引擎已经没有了Site.Master这种MasterPage了，取而代之的是_Layout.cshtml和_ViewStart.cshtml。
　　_Layout.cshtml等同于MasterPage；如下图所示：
这个_Layout.cshtml文件中已没有了MasterPage中&asp:ContentPlaceHolder ID="MainContent" runat="server" /&的标签语句了，取而代之的是
　　@RenderBody（）:呈现子页的主体内容
　　@RenderSection（）：呈现特别的节部分。
　　HelperResult RenderSection(string name, bool required = true);
　　required默认为true必须覆写，设为false则为可选覆写；
　　注意的是：该函数在RC版中参数有所改变，参数中optional改为required，据说和VB的关键字冲突
　　下图则为我在子页的页脚部分覆写，在子页实现时，使用@section 自定义节名{ }格式。
　如果我们想在父页里写一个默认实现节，在子页作为可选实现该怎么做呢?
　　这个在MasterPage是直接支持的，但在Razor里就要稍显复杂些，个人觉得这种写法还可以改进下；
　　如下图所示，我在父页写了一个默认的页脚实现，如果子页有实现则使用子页实现，没有就用默认实现。
　　这里要先通过bool IsSectionDefined(string name)函数判断是否有子页实现，有则调用子页实现。
　　_ViewStart.cshtml：该页面可以理解为其它View的基类。它默认的代码就3行如下所示：
在该页面里定义了其它View的默认MasterPage是“~/Views/Shared/_Layout.cshtml”;
　　当然在这里还可以定义一些公用的函数及变量，以供其它页面可以直接调用。
作者：jingmeifeng 发表于
https://blog.csdn.net/jingmeifeng/article/details/7788603
阅读：50761 评论：7