数据库查询

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

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

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