asp.net core SqlSugar对SugarParameter 参数的调试
string sql = "select id,xm from stu where phone=@phone and pass=@pass and zcwc=true order by id desc limit 1";
var par = new List<SqlSugar.SugarParameter>();
par.Add(new SqlSugar.SugarParameter("@phone", regphone));
par.Add(new SqlSugar.SugarParameter("@pass", SecurityHelper.md5(pass)));
var dt = _db.Ado.GetDataTable(sql, par);
string debugSql = sql;
foreach (var p in par)
{
debugSql = debugSql.Replace(p.ParameterName, $"'{p.Value}'");
}
return Content(debugSql);
