public static List <Certificate> Query(string sSerialNo, string sCertData, string sPwd)
{
SqlDb db = new SQLiteDb();
var dbFactory = db.DbBuilder.DbFactory;
var dbOperator = dbFactory.GetDbParamOperator();
var dblist = db.Query <Certificate>("SerialNo,CertData,CommonName", "1>0");
return(dblist);
}
/// <summary>
/// 查询数据
/// </summary>
public void Query()
{
SqlDb db = new SQLiteDb(_connString);
db.IsShowSqlToConsole = _isShowSqlToConsole;
var dbFactory = db.DbBuilder.DbFactory;
var dbOperator = dbFactory.GetDbParamOperator();
//根据实体主键参数值查询数据
var data = db.QueryById <UserInfo>(5);
//根据查询字段、过滤SQL、过滤参数查询数据列表
var dataList1 = db.Query <UserInfo>("UserId,UserName", "UserId=4", null);
var dataList2 = db.Query <UserInfo>("UserId,UserName", string.Format("UserId={0}UserId", dbOperator), new { UserId = 4 });
//根据查询参数化SQL、参数列表查询数据列表
var dataList3 = db.Query <UserInfo>("select * from UserInfo where UserId=4", null);
var dataList4 = db.Query <UserInfo>(string.Format("select * from UserInfo where UserId={0}UserId", dbOperator), new { UserId = 4 });
//分页查询列表
var pageDataList1 = db.QueryPageList <UserInfo>("*", "UserId>2", "UserId", "asc", 10, 1, null);
var pageDataList2 = db.QueryPageList <UserInfo>("UserId,UserName", string.Format("UserId>{0}UserId", dbOperator), "UserId", "asc", 10, 1, new { UserId = 2 });
}