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