$sqlstr= "EXEC [CurrentStore] ?,?,?,?,?,?,?";
$p1=" Where M_id ='$code'";
$p2=" Where M_id ='$code' And I_DaB>'$zjdate'";
$p3=" Where M_id ='$code' And Str001_OB.C_Xc =0 And O_DaB>'$zjdate'";
$p4=" Where M_id ='$code' And R_da >'$zjdate'";
$p5=" Where M_id ='$code' And T_da >'$zjdate'";
$p6=" Where M_id ='$code' And P_da >'$zjdate'";
$data = Db::connect('db1')->query($sqlstr,[$p1,$p2,$p3,$p4,$p5,$p6,2]);
if ($data) {
return json($data);
}else{
abort(404,'无结果');
}运行后：最佳答案
