sqlCmd.Parameters.Add(sqlParameter);
}
}
SqlDataAdapter sda = new SqlDataAdapter(sqlCmd);
sda.Fill(ResponseDs);
}
}
}
catch (Exception e)
{
ResponseBool = false;
ResponseMsg = $"查询存储过程时出现异常,SQL脚本:【{sqlScript}】\n 异常原因:【{e.Message}】\n 异常详细信息:【{e.StackTrace}】!";
}
return ResponseDs;
}
入参实体建类
/// <summary>
/// 输入参数实体 参数名称(Key)/参数值(Value)
/// </summary>
public class ParameterKeyValuesEntity
{
/// <summary>
/// 参数名称
/// </summary>
public string Key { get; set; }
/// <summary>
/// 参数值
/// </summary>
public object Value { get; set; }
}
执行存储过程示例:
public Result 方法名(string 入参1,string 入参2, string 入参3)
{
try
{
&nb