SQL Server 查询参数管理类

 data_PayOrder GetOrderInfo(string id)
{
    GZDBHelper.SqlParameterProvider parameters = new GZDBHelper.SqlParameterProvider();
    parameters.AddParameter("@OrderID", System.Data.SqlDbType.VarChar, 50, id);

    string sql = "select * from data_PayOrder where OrderID=@OrderID";
    data_PayOrder orderInfo = DBHelper.DB.ExecuteDataFirst<data_PayOrder>(sql, parameters);
    return orderInfo;
}