数据库查询

1.Query查询

//返回记录集
var seqv = 1000;
var rc1 = db1.Query("select * from ComProject where seq<@0",seqv);
@{
    foreach(var item in rc1){
        @item.Txt | @item.ProjectId <br/>
    }
}

2.QuerySingle查询

//返回单笔记录
var rs1 = db1.QuerySingle("select * from ComProject");
@rs1.Txt;
@rs1.ProjectId;
@rs1.ProjectNm;

3.QueryValue查询

//返回单个值
var rv1 = db1.QueryValue("select ProjectId from ComProjectNoMail");
@rv1;

4.其他相关

rc1.Count();  //记录数
var list1 = rc1.ToList();  //将rc转换成list，建议转换为list