/// <summary> /// 消费站点 /// </summary> /// <param name="parm"></param> /// <param name="resultcount"></param> /// <returns></returns> public IEnumerable <menuplace> Get_Menuplace_List(menuplace_parm parm, out int resultcount) { resultcount = 0; using (GoldKey_DB db = new GoldKey_DB()) { StringBuilder sql = new StringBuilder(); DynamicParameters p = new DynamicParameters(); sql.Append("select * from menuplace where 1=1 "); if (!string.IsNullOrEmpty(parm.key)) { sql.Append(" and placename like @key "); p.Add("key", parm.key); } if (!string.IsNullOrEmpty(parm.cruises_no)) { sql.Append(" and cruisesno = @shipno "); p.Add("shipno", parm.cruises_no); } if (!string.IsNullOrEmpty(parm.dept_no)) { sql.Append(" and dptno = @deptno "); p.Add("deptno", parm.dept_no); } var list = db.Get_Con.Query <menuplace>(sql.ToString(), p).OrderBy(t => t.modifydate).ToPagedList(parm.pageindex, parm.pagesize); resultcount = list.TotalItemCount; return(list); } }
public IHttpActionResult Get_Placeno(menuplace_parm parm) { int totalitems = 0; try { Consume_Service sv = new Consume_Service(); var list = sv.Get_Menuplace_List(parm, out totalitems); return(Json(new { code = 1, msg = "ok", list = list, totalitems = totalitems })); } catch (Exception e) { return(Json(new { code = 0, msg = e.Message })); } }