【备忘】System.Data.Common.DbCommand 调用存储过程简易实现

System.Data.Common.DbCommand 调用存储过程简易实现：

public static string GetDailySurgeryCheckedMessage(int encounterId)
{
	try
	{
		string message = "";
		using (DbConnection cn = DapperHelper.CrateConnection(Dbs.IP))
		{
			DbCommand cm = cn.CreateCommand();
			cm.CommandType = CommandType.StoredProcedure;
			cm.CommandText = "PRPA.PGETDAILYSURGERYNOTALLOWINFO";
			cm.CommandTimeout = 60;

			DbParameter para1 = cm.CreateParameter();
			para1.DbType = DbType.Int32;
			para1.Direction = ParameterDirection.Input;
			para1.ParameterName = "v_EncounterId";
			para1.Value = encounterId;
			cm.Parameters.Add(para1);

			DbParameter para2 = cm.CreateParameter();
			para2.DbType = DbType.String;
			para2.Direction = ParameterDirection.Output;
			para2.ParameterName = "v_Message";
			para2.Size = 500;
			cm.Parameters.Add(para2);
			cm.ExecuteNonQuery();

			message = para2.Value.ToString();
			return message;
		}
	}
	catch (Exception ex)
	{
		return $"调用PRPA.PGETDAILYSURGERYNOTALLOWINFO异常：\r\n{ex.Message}";
	}
}