public IEnumerable <xmtype> Get_Xmtype_List(xmtype_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 xmtype 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.place_no))
{
sql.Append(" and placeno = @placeno ");
p.Add("placeno", parm.place_no);
}
var list = db.Get_Con.Query <xmtype>(sql.ToString(), p).OrderBy(t => t.modifydate).ToPagedList(parm.pageindex, parm.pagesize);
resultcount = list.TotalItemCount;
return(list);
}
}
public IHttpActionResult Get_Xmtype(xmtype_parm parm)
{
int totalitems = 0;
try
{
Consume_Service sv = new Consume_Service();
var list = sv.Get_Xmtype_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 }));
}
}
