public IHttpActionResult Get_ShipClass_List(shipclass_parm parm)
{
try
{
int resultcount = 0;
ShipClass_Service svc = new ShipClass_Service();
var list = svc.Get_List(parm, out resultcount);
return(Json(new { code = 1, list = list, msg = "ok", resultcount = resultcount }));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message }));
}
}
public IEnumerable <shipclass> Get_List(shipclass_parm parms, out int resultcount)
{
using (GoldKey_DB db = new GoldKey_DB())
{
resultcount = 0;
DynamicParameters q = new DynamicParameters();
StringBuilder sql = new StringBuilder();
sql.Append("select * from shipclass where 1=1");
if (!string.IsNullOrEmpty(parms.key))
{
sql.Append(" and rcno like @rcno ");
q.Add("rcno", '%' + parms.key + '%');
}
if (!string.IsNullOrEmpty(parms.ksrq) && !string.IsNullOrEmpty(parms.jsrq))
{
sql.Append(" and convert(date,bdate) between @ksrq and @jsrq ");
q.Add("ksrq", parms.ksrq);
q.Add("jsrq", parms.jsrq);
}
var list = db.Get_Con.Query <shipclass>(sql.ToString(), q).OrderByDescending(t => t.modifydate).ToPagedList(parms.pageindex, parms.pagesize);
resultcount = list.TotalItemCount;
return(list);
}
}
