我一直在构建一个API，直到我尝试添加内在加入
SQL我要通过的退货，就像我在Beaver（正在使用Mac）中运行时所期望的那样
但是，当我尝试通过我的API终点访问它时，而不是组合结果，我只从join
中添加的表中获得结果我认为我正在做一些真正愚蠢的事情...
来自我的控制器：
result = dbtest.FromDatabase(
"SELECT A.FAMILY_ID
,A.START_TIME
,A.END_TIME
,A.WORKER_ID
,A.WEEK_NO
,A.ID
,A.SHIFT_NO
,A.DAY_OF_WEEK
,A.HOLIDAY_OR_TERM
,B.WORKER_NAME
FROM SHIFT_REQ_TBL A
INNER JOIN WORKER_TBL B ON A.WORKER_ID = B.WORKER_ID
WHERE A.FAMILY_ID = '" + FAMILY.FAMILY_ID + "'");
我的模型
if (query.Contains("SHIFT_REQ_TBL"))
{
var tbl_type = new TimekeeperTables.SHIFT_REQ_TBL();
tbl_type.FAMILY_ID = Convert.ToInt32(reader["FAMILY_ID"]);
tbl_type.ID = Convert.ToInt32(reader["ID"]);
tbl_type.WEEK_NO = Convert.ToInt32(reader["WEEK_NO"]);
tbl_type.WORKER_ID = Convert.ToInt32(reader["WORKER_ID"]);
tbl_type.SHIFT_NO = reader["SHIFT_NO"].ToString();
tbl_type.START_TIME = reader["START_TIME"].ToString();
tbl_type.END_TIME = reader["END_TIME"].ToString();
tbl_type.DAY_OF_WEEK = reader["DAY_OF_WEEK"].ToString();
tbl_type.HOLIDAY_OR_TERM = reader["HOLIDAY_OR_TERM"].ToString();
tbl_type.WORKER_NAME = reader["WORKER_NAME"].ToString();
db_results.Add(tbl_type);
jsonDoc = JsonConvert.SerializeObject(db_results);
}
结果（来自Postman）
" [{{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "：" wortm_name "：" unsigned "}，{}，{ " worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "： " unapsigned "}，1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "："未分配的"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "：1，" worker_name "}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "："：" novered " unsigned "}worker_id "：1，" worker_name "：" novemigned '}，{" worker_id "：1， " worker_name "： " nioned "} " worker_name "："未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{ " worker_id "： "未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "：1，" worker_name "，{" worker_id "：1，" worker_name "："未分配的"}，{" worker_id "：1，" worker_name "："："：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "worker_name "："未分配的"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{ " worker_id "：1，" 1，" worker_name "："："："："："未分配的"}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "： " worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "： " unapsigned "}，1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "："未分配的"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "：1，" worker_name "}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "："：" novered " unsigned "}worker_id "：1，" worker_name "：" novemigned '}，{" worker_id "：1， " worker_name "： " nioned "} " worker_name "："未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{ " worker_id "： "未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "：1，" worker_name "，{" worker_id "：1，" worker_name "："未分配的"}，{" worker_id "：1，" worker_name "："："：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "worker_name "："未分配的"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{ " worker_id "：1，" 1，" worker_name "："："："："："未分配的"}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "： " worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "： " unapsigned "}，1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "："未分配的"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "：1，" worker_name "}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "："：" novered " unsigned "}worker_id "：1，" worker_name "：" novemigned '}，{" worker_id "：1， " worker_name "： " nioned "} " worker_name "："未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{ " worker_id "： "未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "：1，" worker_name "，{" worker_id "：1，" worker_name "："未分配的"}，{" worker_id "：1，" worker_name "："："：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "worker_name "："未分配的"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{ " worker_id "：1，" 1，" worker_name "："："："："："未分配的"}，{" worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "： " worker_id "：1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "： " unapsigned "}，1，" worker_name "："未分配"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "："未分配的"}，{" worker_id "：1，" worker_name "：" unapsigned "}，{" worker_id "：1，" worker_name "}]"
对不起，我很愚蠢，弄清楚了
我正在使用一种非常愚蠢的方式来识别已经在较早情况下检查shift_tbl的调用URL