public string prjList(prjStatus status = prjStatus.active) { string sql = "select a.*,b.cName creatorNm from prjs a left join AspNetUsers b on a.creator=b.workNo where a.status=@status order by a.createDate asc"; List <prj> list = con.Query <prj>(sql, new { status = (int)status }).ToList <prj>(); dynamic r = new ExpandoObject(); r.data = list; return(JsonConvert.SerializeObject(r)); }
public string prjCodeList(prjStatus status = prjStatus.active) { string sql = "select a.* from prjCodes a left join AspNetUsers b on a.owner=b.workNo "; sql += " where a.status=@status order by a.code asc"; List <vwPrjCode> list = con.Query <vwPrjCode>(sql, new { status = "使用中" }).ToList <vwPrjCode>(); dynamic r = new ExpandoObject(); r.data = list; return(JsonConvert.SerializeObject(r)); }