using (IDbConnection conn = SessionFactory.CreateConnection(ConnectionStr))
{
string sql = "SELECT sAreaID AS AreaID, sAreaCode AS AreaCode,sSite AS Site,sAreaDesc AS AreaDesc,sCreationBy AS CreationBy,tCreationDate AS CreationDate,sLastupdateBy AS LastupdateBy,tLastupdateDate AS LastupdateDate FROM Eqp_Area";
return conn.Query<EqpArea>(sql).ToList();
}
使用SimpleCURD的GetList方法使用字符串条件时,where条件应和表的列名一致
using (IDbConnection conn = SessionFactory.CreateConnection(ConnectionStr))
{
string condition = "WHERE sModelName = @ModelName OR sModelDesc = @ModelDesc";
return conn.GetList<EqpModel>(condition, new { ModelName = modelName, ModelDesc = modelDesc}).ToList();
}