/// <summary> /// 获取班组列表 /// </summary> public JsonResult GetClassInfoList(int areaid) { E_ClassInfo model = new E_ClassInfo(); model.areaid = areaid; return(Json(JsonConvert.SerializeObject(dalclassinfo.GetList(model)))); }
/// <summary> /// 查询 /// </summary> public List <E_ClassInfo> GetList(E_ClassInfo model) { List <E_ClassInfo> list; StringBuilder strSql = new StringBuilder(); strSql.Append("select * from classinfo where 1=1"); if (model.areaid > 0) { strSql.Append(" and areaid=@areaid "); } using (IDbConnection conn = new SqlConnection(DapperHelper.GetConStr())) { list = conn.Query <E_ClassInfo>(strSql.ToString(), model)?.ToList(); } return(list); }