/// <summary>
/// 获取消费项目
/// </summary>
/// <param name="parm"></param>
/// <param name="resultcount"></param>
/// <returns></returns>
public IEnumerable <menucode> Get_Consume_List(consume_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 menucode where 1=1 ");
if (!string.IsNullOrEmpty(parm.key))
{
sql.Append(" and menuname 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.place_no))
{
sql.Append(" and placeno = @placeno ");
p.Add("placeno", parm.place_no);
}
if (!string.IsNullOrEmpty(parm.xmtype_no))
{
sql.Append(" and xmtypeno = @xmtype_no ");
p.Add("xmtype_no", parm.xmtype_no);
}
var list = db.Get_Con.Query <menucode>(sql.ToString(), p).OrderBy(t => t.modifydate).ToPagedList(parm.pageindex, parm.pagesize);
resultcount = list.TotalItemCount;
return(list);
}
}
public IHttpActionResult Get_Consume_List(consume_parm parm)
{
int totalitems = 0;
try
{
Consume_Service sv = new Consume_Service();
var list = sv.Get_Consume_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 }));
}
}
