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