/// <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);
}
