如何在每笔交易上实施数字签名？ [英] How to implement digital signature on each transaction?

问题描述

1）签名必须记录在电子期刊中，并直接链接到原始收据的完整记录。



2.必须为现金交易中报告的所有交易创建签名。这包括给出交易编号的所有收据，通常包括影响销售的交易。



3.必须记录用于生成收据签名的私钥或密钥的版本。



4



我的尝试：



i知道如何创建数字签名。我需要首先对值进行哈希处理，然后使用公钥对其进行加密。然后要看到我需要使用私钥解密的值，然后重新哈希，我将获得价值。



但是问题是在POS中我已经将数据保存在表格和不同的表格中，例如在一个表格中删除所有项目并且对于该收件人没有保存我的详细信息在另一张桌子上付款。我如何在其上实现数字签名并将其保存在数据库中，我可以在一个字段上创建数字签名，以便我如何在行og数据库上实现？

1)The signature must be recorded in the electronic journal with a direct link to the full record of the original receipt.

2. The signature must be created for all transactions that are reported in cashtransaction. This includes all receipts that are given a transaction number, and normally comprises transactions that influence sales.

3. It must be recorded which version of the private or secret key that was used to generate the signature of the receipt.

4

What I have tried:

i know how to crate digital signature. I need to hash the value first then encrypt it with public key. Then to see that value i need to decrypt with private key and then re hash and i will get value.

But question is that in POS i have saved data in tables and in different tabel for example detal of all items in one table and for that recipt no i saved detail of payment in another table . how i can implement digital signature on it and save it in database, I can crate digital signature on one field what how i can implement on row og database?

推荐答案

它似乎你还没有完全理解数字签名是什么。

对于签名，你应该用你的私钥加密，并允许每个人用公钥解密。



首先，您需要自己确定在哪里保留私钥并实际执行数字签名。

Eg在MSSQL上，您可以创建密钥作为数据库对象并执行所有操作，包括从T-SQL验证。

或者您可以创建.NET存储过程并从那里执行或使用外部签名Windows服务等

It seems that you not fully understand what a digital signature is.
For a signature you should encrypt with your private key and allow everybody to decrypt with the public key.

First you need to figure our for yourself on where are you going to keep the private key and actually preform the digital signing.
E.g. on MSSQL you can create the key as a DB object and do everything including verification from the T-SQL.
Or you can create a .NET stored procedures and do it from there or use an external signing from a windows service e.t.c

这篇关于如何在每笔交易上实施数字签名？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！