<span style="color:#33cc00;">//查询数据,需要根据条件传入不同的值,所以选择了使用键值对的方式</span>
public List<DishInfo> GetList(Dictionary<string,string > dic)
{
List<DishInfo> list = new List<DishInfo>();
<span style="color:#33cc00;">//SQL语句有一个inner join</span>
string sql = "select di.*,dti.DTitle as dtt from dishinfo as di " +
"inner join dishtypeinfo as dti " +
"on di.DTypeId=dti.DId " +
"where di.DIsDelete=0 ";
List<SQLiteParameter> paras = new List<SQLiteParameter>();
<span style="color:#33cc00;"> //根据dic的长度