Поиск нужного сертификата. Ищем по конкретному СНИЛСу и действующий на текущую дату.
<pre>X509Certificate2 CertItog = find_certificate_();</pre>

<pre> public static X509Certificate2 find_certificate_()
{

X509Store store = new X509Store("MY", StoreLocation.CurrentUser);
store.Open(OpenFlags.ReadOnly | OpenFlags.OpenExistingOnly);
X509Certificate2 cert = new X509Certificate2();
X509Certificate2Collection collection = (X509Certificate2Collection)store.Certificates;
X509Certificate2Collection fcollection = (X509Certificate2Collection)collection.Find(X509FindType.FindByTimeValid, DateTime.Now, false);
string str_SN = "";
foreach (X509Certificate2 x509 in fcollection)
{
try
{
if (x509.Subject.ToUpper().Contains("SNILS") || x509.Subject.ToUpper().Contains("СНИЛС"))
{

str_SN = x509.Subject.Substring(x509.Subject.IndexOf("SNILS") + 6, 11);
int n;
if (!int.TryParse(str_SN.Substring(0, 10), out n))
{
str_SN = x509.Subject.Substring(x509.Subject.ToUpper().IndexOf("СНИЛС") + 6, 11);
if (!int.TryParse(str_SN.Substring(0, 10), out n))
{
continue;
// System.Windows.Forms.MessageBox.Show("Снилс в сертификате не найден или пустой");
}
}
if (String.CompareOrdinal(str_SN, "NNNNNNNNNNNNN") == 0)
{
cert = x509;
// Console.WriteLine(cert.Subject);
Console.WriteLine(str_SN);
// Console.ReadKey();
break;
}
}
x509.Reset();
}
catch (CryptographicException)
{
Console.WriteLine("Information could not be written out for this certificate.");
}
}
store.Close();
return cert;
}
</pre>
Далее. Для подписи требуется библиотека GostCryptography. Заливаем через nuget, подключаем.
<pre>
using GostCryptography;
using GostCryptography.Cryptography;
using GostCryptography.Xml;
</pre>

Для СМЭВ пользуем доп. класс
Добавляем константы
<pre>
private const string WsSecurityExtNamespace = "http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd";
private const string WsSecurityUtilityNamespace = "http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd";
</pre>

<pre>
private static XmlElement GetSmevIdElement(XmlDocument document, string idValue)
{
var namespaceManager = new XmlNamespaceManager(document.NameTable);
namespaceManager.AddNamespace("wsu", WsSecurityUtilityNamespace);
return document.SelectSingleNode("//*[@wsu:Id='" + idValue + "']", namespaceManager) as XmlElement;
}
</pre>

И, собственно алгоритм подписи/ На выходе формируется отдельный файл.

<pre>
private static XmlDocument SignSmevRequestVip(string FileName, string SignedFileName, X509Certificate2 signingCertificate)
{
XmlDocument smevRequest = new XmlDocument();
smevRequest.PreserveWhitespace = true;
smevRequest.Load(new XmlTextReader(FileName));

// Создание подписчика XML-документа
var signedXml = new GostSignedXml(smevRequest) { GetIdElementHandler = GetSmevIdElement };

// Установка ключа для создания подписи
signedXml.SetSigningCertificate(signingCertificate);

// Ссылка на узел, который нужно подписать, с указанием алгоритма хэширования ГОСТ Р 34.11-94 (в соответствии с методическими рекомендациями СМЭВ)
var dataReference = new Reference { Uri = "#BODY", DigestMethod = GostSignedXml.XmlDsigGost3411ObsoleteUrl };
// Метод преобразования, применяемый к данным перед их подписью (в соответствии с методическими рекомендациями СМЭВ)
var dataTransform = new XmlDsigExcC14NTransform();
dataReference.AddTransform(dataTransform);
// Установка ссылки на узел
signedXml.AddReference(dataReference);
//reference #wsa300
var dataReferenceWSA300 = new Reference { Uri = "#WSA-300", DigestMethod = GostSignedXml.XmlDsigGost3411ObsoleteUrl };
var dataTransformWSA300 = new XmlDsigExcC14NTransform();
dataReferenceWSA300.AddTransform(dataTransformWSA300);
signedXml.AddReference(dataReferenceWSA300);
//reference #WSA-301
var dataReferenceWSA301 = new Reference { Uri = "#WSA-301", DigestMethod = GostSignedXml.XmlDsigGost3411ObsoleteUrl };
var dataTransformWSA301 = new XmlDsigExcC14NTransform();
dataReferenceWSA301.AddTransform(dataTransformWSA301);
signedXml.AddReference(dataReferenceWSA301);
//reference #WSA-302
var dataReferenceWSA302 = new Reference { Uri = "#WSA-302", DigestMethod = GostSignedXml.XmlDsigGost3411ObsoleteUrl };
var dataTransformWSA302 = new XmlDsigExcC14NTransform();
dataReferenceWSA302.AddTransform(dataTransformWSA302);
signedXml.AddReference(dataReferenceWSA302);
//reference #WSA-303
var dataReferenceWSA303 = new Reference { Uri = "#WSA-303", DigestMethod = GostSignedXml.XmlDsigGost3411ObsoleteUrl };
var dataTransformWSA303 = new XmlDsigExcC14NTransform();
dataReferenceWSA303.AddTransform(dataTransformWSA303);
signedXml.AddReference(dataReferenceWSA303);
//reference #TRHEAD
var dataReferenceTRHEAD = new Reference { Uri = "#TRHEAD", DigestMethod = GostSignedXml.XmlDsigGost3411ObsoleteUrl };
var dataTransformTRHEAD = new XmlDsigExcC14NTransform();
dataReferenceTRHEAD.AddTransform(dataTransformTRHEAD);
signedXml.AddReference(dataReferenceTRHEAD);
//reference #CertId
var dataReferenceCertId = new Reference { Uri = "#CertId", DigestMethod = GostSignedXml.XmlDsigGost3411ObsoleteUrl };
var dataTransformCertId = new XmlDsigExcC14NTransform();
dataReferenceCertId.AddTransform(dataTransformCertId);
signedXml.AddReference(dataReferenceCertId);

// Установка алгоритма нормализации узла SignedInfo (в соответствии с методическими рекомендациями СМЭВ)
signedXml.SignedInfo.CanonicalizationMethod = SignedXml.XmlDsigExcC14NTransformUrl;

// Установка алгоритма подписи ГОСТ Р 34.10-2001 (в соответствии с методическими рекомендациями СМЭВ)
signedXml.SignedInfo.SignatureMethod = GostSignedXml.XmlDsigGost3410ObsoleteUrl;

// Вычисление подписи
signedXml.ComputeSignature();

// Получение XML-представления подписи
var signatureXml = signedXml.GetXml();

// Добавление подписи в исходный документ
smevRequest.GetElementsByTagName("Signature")[0].PrependChild(smevRequest.ImportNode(signatureXml.GetElementsByTagName("SignatureValue")[0], true));
smevRequest.GetElementsByTagName("Signature")[0].PrependChild(smevRequest.ImportNode(signatureXml.GetElementsByTagName("SignedInfo")[0], true));
smevRequest.GetElementsByTagName("wsse:BinarySecurityToken")[0].InnerText = Convert.ToBase64String(signingCertificate.RawData);

using (XmlTextWriter xmltw = new XmlTextWriter(SignedFileName,
new UTF8Encoding(false)))
{
smevRequest.WriteTo(xmltw);
}
return smevRequest;
}
</pre>

Подпись ИЭМК с помощью VipNet CSP

2016-10-20T11:30:25Z

Dmitriy:

Подпись ИЭМК с помощью VipNet CSP

2016-10-20T11:25:29Z

Dmitriy:

Поиск нужного сертификата. Ищем по конкретному СНИЛСу и действующий на текущую дату.
<nowiki>#</nowiki>fghl;jdfg

Подпись ИЭМК с помощью VipNet CSP

2016-10-20T11:23:38Z

Dmitriy: Новая страница: «Поиск нужного сертификата. Ищем по конкретному СНИЛСу и действующий на ткущую дату. <!-- X50…»

Поиск нужного сертификата. Ищем по конкретному СНИЛСу и действующий на ткущую дату.

MYSQL запросы

2015-11-30T15:20:16Z

Dmitriy: /* Найти одинаковые строки */

==Найти одинаковые строки==
<pre>select a.stb1, a.stb2, a.stb3, a.stb4, COUNT(*) AS col1
from table1 a
where a.stb1> 0 and a.ctb2 >= 1
GROUP BY a.stb1, a.stb2, a.stb3, a.stb4 DESC HAVING COUNT(*) > 1
ORDER BY col1;
</pre>
блок where - не обязателен.

==update РМР из 1С==
<pre>
update registrmr2.e_cardrecord_tmp cr set cr.PositionType = (SELECT IF( EXISTS(select sp.id from s_positiontype sp WHERE cr.dop_kodEmployType=sp.ID_FROM_LPU ),(select sp.id from s_positiontype sp WHERE cr.dop_kodEmployType=sp.id_from_lpu),0)),spr_was_updated=1 WHERE cr.From_dop_data=1;
update registrmr2.e_cardrecord_tmp cr set cr.SubdivisionType = (SELECT IF( EXISTS(select sp.id from s_subdivision sp WHERE sp.id_from_lpu=cr.dop_unitorgkod AND cr.oid=sp.OID AND sp.IS_FEDERAL=0),(select sp.id from s_subdivision sp WHERE sp.id_from_lpu=cr.dop_unitorgkod AND cr.oid=sp.OID AND sp.IS_FEDERAL=0),0)),spr_was_updated=1 WHERE cr.From_dop_data=1;
update registrmr2.e_cardrecord_tmp cr set cr.Post = (SELECT IF( EXISTS(select sp.id from s_post sp WHERE sp.id_from_lpu=cr.dop_postkod AND cr.oid=sp.OID AND sp.IS_FEDERAL=0),(select sp.id from s_post sp WHERE sp.id_from_lpu=cr.dop_postkod AND cr.oid=sp.OID AND sp.IS_FEDERAL=0),0)),spr_was_updated=1 WHERE cr.From_dop_data=1;

INSERT INTO e_cardrecord (idpeople,OID,AdditionalLaborAgreement,Care,Conditions,DateBegin,DateEnd,IsActual,IsVacation,Military,OrderIn,OrderOut,Organization_OID,Organization_name,Population,PositionType,Post,PostType,Regime,SubdivisionName,SubdivisionType,TypeIn,TypeInAdd,TypeInCountry,TypeInGoIn,TypeInStudTarget,TypeInStudType,TypeInTerr,TypeOut,TypeOutCountry,TypeOutDel,TypeOutGoIn,TypeOutTerr,Wage,From_dop_data,Spr_was_updated,Dop_Typecontract,Dop_Numbercontract,Dop_Datecontract,Dop_KodEmployType,Dop_Unitorgkod,Dop_Postkod,Dop_Post,Dop_KodCategorypost,Dop_Categorypost,Dop_Ratebat,TIMEMODIFY)
(SELECT cr1.idpeople,cr1.OID,cr1.AdditionalLaborAgreement,cr1.Care,cr1.Conditions,cr1.DateBegin,cr1.DateEnd,cr1.IsActual,cr1.IsVacation,cr1.Military,cr1.OrderIn,cr1.OrderOut,cr1.Organization_OID,cr1.Organization_name,cr1.Population,cr1.PositionType,cr1.Post,cr1.PostType,cr1.Regime,cr1.SubdivisionName,cr1.SubdivisionType,cr1.TypeIn,cr1.TypeInAdd,cr1.TypeInCountry,cr1.TypeInGoIn,cr1.TypeInStudTarget,cr1.TypeInStudType,cr1.TypeInTerr,cr1.TypeOut,cr1.TypeOutCountry,cr1.TypeOutDel,cr1.TypeOutGoIn,cr1.TypeOutTerr,cr1.Wage,cr1.From_dop_data,cr1.Spr_was_updated,cr1.Dop_Typecontract,cr1.Dop_Numbercontract,cr1.Dop_Datecontract,cr1.Dop_KodEmployType,cr1.Dop_Unitorgkod,cr1.Dop_Postkod,cr1.Dop_Post,cr1.Dop_KodCategorypost,cr1.Dop_Categorypost,cr1.Dop_Ratebat,cr1.TIMEMODIFY
FROM registrmr2.e_cardrecord_tmp AS cr1
WHERE (cr1.idpeople,cr1.OID,cr1.DateBegin,cr1.PositionType,cr1.Post) NOT IN (SELECT cr.idpeople,cr.OID,cr.DateBegin,cr.PositionType,cr.Post FROM registrmr2.e_cardrecord cr
));

DELETE FROM registrmr2.e_cardrecord_tmp
WHERE (idpeople,OID,DateBegin,PositionType,Post) IN (SELECT cr.idpeople,cr.OID,cr.DateBegin,cr.PositionType,cr.Post FROM registrmr2.e_cardrecord cr WHERE cr.spr_was_updated=1);

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2, cr.AdditionalLaborAgreement=(IF (cr1.AdditionalLaborAgreement>0 AND cr1.AdditionalLaborAgreement IS NOT null,cr1.AdditionalLaborAgreement,cr.AdditionalLaborAgreement)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post ;
;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Care=(IF (cr1.Care>0 AND cr1.Care IS NOT null,cr1.Care,cr.Care)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post ;
;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Conditions=(IF (cr1.Conditions>0 AND cr1.Conditions IS NOT null,cr1.Conditions,cr.Conditions)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post ;
;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.IsActual=(IF (cr1.IsActual>0 AND cr1.IsActual IS NOT null,cr1.IsActual,cr.IsActual)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post ;
;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.IsVacation=(IF (cr1.IsVacation>0 AND cr1.IsVacation IS NOT null,cr1.IsVacation,cr.IsVacation)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post ;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Military=(IF (cr1.Military>0 AND cr1.Military IS NOT null,cr1.Military,cr.Military)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post ;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.SubdivisionName=(IF (length(cr1.SubdivisionName)>0 AND cr1.SubdivisionName IS NOT null,cr1.SubdivisionName,cr.SubdivisionName)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.SubdivisionType=(IF (cr1.SubdivisionType>0 AND cr1.SubdivisionType IS NOT null,cr1.SubdivisionType,cr.SubdivisionType)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Wage=(IF (cr1.Wage>0 AND cr1.Wage IS NOT null,cr1.Wage,cr.Wage)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Dop_Typecontract=(IF (LENGTH(cr1.Dop_Typecontract)>0 AND cr1.Dop_Typecontract IS NOT null,cr1.Dop_Typecontract,cr.Dop_Typecontract)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Dop_Numbercontract=(IF (LENGTH(cr1.Dop_Numbercontract)>0 AND cr1.Dop_Numbercontract IS NOT null,cr1.Dop_Numbercontract,cr.Dop_Numbercontract)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Dop_Datecontract=(IF (LENGTH(cr1.Dop_Datecontract)>0 AND cr1.Dop_Datecontract IS NOT null,cr1.Dop_Datecontract,cr.Dop_Datecontract)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Dop_KodEmployType=(IF (cr1.Dop_KodEmployType IS NOT null,cr1.Dop_KodEmployType,cr.Dop_KodEmployType)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Dop_Unitorgkod=(IF (cr1.Dop_Unitorgkod>0 AND cr1.Dop_Unitorgkod IS NOT null,cr1.Dop_Unitorgkod,cr.Dop_Unitorgkod)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Dop_Postkod=(IF (cr1.Dop_Postkod>0 AND cr1.Dop_Postkod IS NOT null,cr1.Dop_Postkod,cr.Dop_Postkod)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Dop_Post=(IF (LENGTH(cr1.Dop_Post)>0 AND cr1.Dop_Post IS NOT null,cr1.Dop_Post,cr.Dop_Post)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.Dop_Ratebat=(IF (cr1.Dop_Ratebat IS NOT null,cr1.Dop_Ratebat,cr.Dop_Ratebat)) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

update registrmr2.e_cardrecord AS cr, registrmr2.e_cardrecord_tmp AS cr1
set cr.From_dop_data=2,cr.TIMEMODIFY=(NOW()) where
cr1.idpeople=cr.idpeople AND cr1.OID=cr.OID AND cr.DateBegin=cr1.DateBegin AND cr.PositionType=cr1.PositionType AND cr.post=cr1.post;

TRUNCATE TABLE registrmr2.e_cardrecord_tmp;
</pre>

Сброс триала CryptoPro.Net

2015-06-15T16:29:11Z

Dmitriy:

Версия КриптоПро .NET 1.0.5425.0 от 2014-11-08

После деинсталяции остался подобный ключи
<pre>HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\EB3462F5-EF6A-4c62-AEC2-6FB1E4AE1E15\</pre>

удалить криптоПро клиент
перезагрузиться
найти и удалить в реестре по этому пути каталог(лучше искать по "EB3462F5-EF6A")
установить криптоПро клиент
проверить что сброс триала прошел

<pre>http://llikiper.com/articles/25-crypto-pro-sbros-triala.html</pre>

Сброс триала CryptoPro.Net

2015-06-15T16:01:27Z

Dmitriy: Новая страница: «Версия КриптоПро .NET 1.0.5425.0 от 2014-11-08 После деинсталяции остался подобный ключи <pre>HKEY_LOCAL_MA…»

2015-05-06T07:11:34Z

Dmitriy:

Получение хэша от строки по гост 94

2015-05-06T07:07:08Z

Dmitriy:

<pre> string signedInfo22 = "<SOAP-ENV:Body xmlns:SOAP-ENV=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:wsu=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\" wsu:Id=\"BODY\"><PRPA_IN201301RU02 xmlns=\"urn:hl7-org:v3\" ITSVersion=\"XML_1.0\"><id extension=\"0\" root=\"1.2.643.5.1.13.3.25.35.11\"></id><creationTime value=\"20150209172931\"></creationTime><interactionId extension=\"PRPA_IN201301RU02\" root=\"1.2.643.5.1.13.2.7.3\"></interactionId><processingCode code=\"P\"></processingCode><processingModeCode code=\"T\"></processingModeCode><acceptAckCode code=\"AL\"></acceptAckCode><receiver typeCode=\"RCV\"><device classCode=\"DEV\" determinerCode=\"INSTANCE\"><id root=\"d5a0f9c0-5db4-11e3-949a-0800200c9a66\"></id><asAgent classCode=\"ASSIGNED\"><representedOrganization classCode=\"ORG\" determinerCode=\"INSTANCE\"><id root=\"1.2.643.5.1.13.2.7.3\"></id><name>ИЭМК</name></representedOrganization></asAgent></device></receiver><sender typeCode=\"SND\"><device classCode=\"DEV\" determinerCode=\"INSTANCE\"><id root=\"d84c8524-d53e-43c6-973c-5076646731d8\"></id><name>МИС Вологодской области \"Статистика и счета ЛПУ\"</name><asAgent classCode=\"ASSIGNED\"><representedOrganization classCode=\"ORG\" determinerCode=\"INSTANCE\"><id root=\"1.2.643.5.1.13.3.25.35.11\"></id><name>БУЗ ВО ВОЛОГОДСКАЯ ГОРОДСКАЯ ПОЛИКЛИНИКА 3</name></representedOrganization></asAgent></device></sender><controlActProcess classCode=\"CACT\" moodCode=\"EVN\"><subject typeCode=\"SUBJ\"><registrationEvent classCode=\"REG\" moodCode=\"EVN\"><id nullFlavor=\"NA\"></id><statusCode code=\"active\"></statusCode><subject1 typeCode=\"SBJ\"><patient classCode=\"PAT\"><id extension=\"3655\" root=\"1.2.643.5.1.13.3.25.35.11\"></id><statusCode code=\"active\"></statusCode><patientPerson><name><family>XXXXXX</family><given>YYYYYYYY</given><given>ZZZZZZZZZZZZZZ</given></name><administrativeGenderCode code=\"2\" codeSystem=\"1.2.643.5.1.13.2.1.1.156\"></administrativeGenderCode><birthTime value=\"19590928\"></birthTime><addr><streetAddressLine>г. ВОЛОГДА, ул. FFFFFFFFFF кв.31</streetAddressLine><city>ВОЛОГДА</city><state>ВОЛОГОДСКАЯ</state><country>Российская Федерация</country></addr><asMember classCode=\"MBR\"><group classCode=\"PUB\"><code code=\"5\" codeSystem=\"1.2.643.5.1.13.2.1.1.366\" displayName=\"Неработающий\"></code></group></asMember><asMember classCode=\"MBR\"><group classCode=\"PUB\"><code code=\"2\" codeSystem=\"1.2.643.5.1.13.2.1.1.358\" displayName=\"инвалиды войны\"></code></group></asMember><asOtherIDs classCode=\"IDENT\"><documentType code=\"3\" codeSystem=\"1.2.643.5.1.13.2.7.1.62\"></documentType><documentNumber number=\"06377932094\"></documentNumber><scopingOrganization classCode=\"ORG\" determinerCode=\"INSTANCE\"><id nullFlavor=\"NI\"></id></scopingOrganization></asOtherIDs><asOtherIDs classCode=\"HLD\"><documentType code=\"1\" codeSystem=\"1.2.643.5.1.13.2.7.1.62\"></documentType><documentNumber number=\"3550040871001818\"></documentNumber><effectiveTime value=\"20120416\"></effectiveTime><scopingOrganization classCode=\"ORG\" determinerCode=\"INSTANCE\"><id extension=\"35003\" root=\"1.2.643.5.1.13.2.1.1.635\"></id><name>ОАО\"СТРАХОВАЯ КОМПАНИЯ \"СОГАЗ-МЕД\"</name></scopingOrganization></asOtherIDs><asOtherIDs classCode=\"IDENT\"><documentType code=\"5\" codeSystem=\"1.2.643.5.1.13.2.7.1.62\"><qualifier><name code=\"14\" codeSystem=\"1.2.643.5.1.13.2.1.1.498\" codeSystemName=\"Классификатор документов, удостоверяющих личность гражданина Российской Федерации\" displayName=\"Паспорт гражданина РФ\"></name></qualifier></documentType><documentNumber number=\"1909614992\"></documentNumber><scopingOrganization classCode=\"ORG\" determinerCode=\"INSTANCE\"><id nullFlavor=\"NI\"></id><name>УФМС Г.ВОЛОГДА</name></scopingOrganization></asOtherIDs><birthPlace><addr><city>Вологда</city><state>Российская Федерация</state></addr></birthPlace></patientPerson><providerOrganization classCode=\"ORG\" determinerCode=\"INSTANCE\"><id root=\"1.2.643.5.1.13.3.25.35.11\"></id><name>БУЗ ВО ВОЛОГОДСКАЯ ГОРОДСКАЯ ПОЛИКЛИНИКА 3</name><contactParty classCode=\"CON\"><telecom value=\"+8(8202)74-13-06\"></telecom></contactParty></providerOrganization></patient></subject1><custodian typeCode=\"CST\"><assignedEntity classCode=\"ASSIGNED\"><id root=\"1.2.643.5.1.13.3.25.35.11\"></id><assignedOrganization classCode=\"ORG\" determinerCode=\"INSTANCE\"><name>БУЗ ВО ВОЛОГОДСКАЯ ГОРОДСКАЯ ПОЛИКЛИНИКА 3</name></assignedOrganization></assignedEntity></custodian></registrationEvent></subject></controlActProcess></PRPA_IN201301RU02></SOAP-ENV:Body>";
HashAlgorithm myhash1 = HashAlgorithm.Create("Gost3411");
byte[] hashResult = myhash1.ComputeHash(Encoding.UTF8.GetBytes(signedInfo22));
string canonicalHashedSignedInfo = Convert.ToBase64String(hashResult);
Console.WriteLine(canonicalHashedSignedInfo); Console.ReadKey();
</pre>
<pre>
static void hash_from_file_not_full(string _filenameXML, string _filenameTXT)
{
StreamWriter sw = new StreamWriter(_filenameTXT);
Gost3411 gost3411 = new Gost3411CryptoServiceProvider();
const string Envelope = "/SOAP-ENV:Envelope";
const string Header = Envelope + "/SOAP-ENV:Header";
const string Action = Header + "/wsa:Action"; //wsa300
const string MessageID = Header + "/wsa:MessageID"; //wsa301
const string ReplyTo = Header + "/wsa:ReplyTo"; //wsa302
const string To = Header + "/wsa:To"; //wsa303
const string transportHeader = Header + "/egisz:transportHeader"; //TRHEAD
const string Security = Header + "/wsse:Security";
const string ClinicalDocument = Envelope + "/SOAP-ENV:Body/ClinicalDocument";
const string Body = Envelope + "/SOAP-ENV:Body";
XmlDocument doc = new XmlDocument();
doc.Load(new XmlTextReader(_filenameXML));
var ns = new XmlNamespaceManager(doc.NameTable);
ns.AddNamespace("SOAP-ENV", "http://www.w3.org/2003/05/soap-envelope");
ns.AddNamespace("wsa", "http://www.w3.org/2005/08/addressing");
ns.AddNamespace("egisz", "http://egisz.rosminzdrav.ru");
XmlElement root = doc.DocumentElement; // Полный xml файл
// Console.WriteLine(root.InnerXml); Console.ReadKey();
// Ищем тег Body, с нэмспейсом
XmlNode BodyInfo = doc.SelectSingleNode(Body, ns);
String BodyFile = BodyInfo.OuterXml; // Получаем полное содержимое тега Body
sw.Write("BodyFromFile= "); sw.WriteLine(BodyFile); // Пишем исходное body в файл
byte[] result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(BodyFile));
sw.Write("HashBodyFile= "); sw.WriteLine(Convert.ToBase64String(result)); // Пишем хэш исходного body
// Приводим тэг Body к канонической форме
String BodyCan2 = Canonicalization(BodyInfo);
sw.Write("CanonicalBody= "); sw.WriteLine(BodyCan2);
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(BodyCan2));
sw.Write("HashCanonicalBody= "); sw.WriteLine(Convert.ToBase64String(result));
export_can_node(BodyCan2, "doc/Body_cann"); // экспорт результата каноникализации в файл
sw.WriteLine("********************************");
// Ищем тег Action, с нэмспейсом
XmlNode Wsa300Info = doc.SelectSingleNode(Action, ns);
String WSA300File = Wsa300Info.OuterXml; // Получаем полное содержимое тега
sw.Write("WSA300FromFile= "); sw.WriteLine(WSA300File); // Пишем исходное в файл
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(WSA300File));
sw.Write("HashWSA300File= "); sw.WriteLine(Convert.ToBase64String(result)); // Пишем хэш исходного body
// Приводим тэг к канонической форме
String WSACan2 = Canonicalization(Wsa300Info);
sw.Write("CanonicalWSA300= "); sw.WriteLine(WSACan2);
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(WSACan2));
sw.Write("HashCanonicalWSA300= "); sw.WriteLine(Convert.ToBase64String(result));
export_can_node(WSACan2, "doc/WSA300_cann"); // экспорт результата каноникализации в файл
sw.WriteLine("********************************");
XmlNode WSA301Info = doc.SelectSingleNode(MessageID, ns);
sw.Write("WSA301FromFile= "); sw.WriteLine(WSA301Info.OuterXml); // Пишем исходное в файл
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(WSA301Info.OuterXml));
sw.Write("HashWSA301File= "); sw.WriteLine(Convert.ToBase64String(result)); // Пишем хэш исходного
// Приводим тэг к канонической форме
sw.Write("CanonicalWSA301= "); sw.WriteLine(Canonicalization(WSA301Info));
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(Canonicalization(WSA301Info)));
sw.Write("HashWSA301Cann= "); sw.WriteLine(Convert.ToBase64String(result));
export_can_node(Canonicalization(WSA301Info), "doc/WSA301_cann"); // экспорт результата каноникализации в файл
sw.WriteLine("********************************");
XmlNode WSA302Info = doc.SelectSingleNode(ReplyTo, ns);
sw.Write("WSA302FromFile= "); sw.WriteLine(WSA302Info.OuterXml); // Пишем исходное в файл
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(WSA302Info.OuterXml));
sw.Write("HashWSA302File= "); sw.WriteLine(Convert.ToBase64String(result)); // Пишем хэш исходного
// Приводим тэг к канонической форме
sw.Write("CanonicalWSA302= "); sw.WriteLine(Canonicalization(WSA302Info));
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(Canonicalization(WSA302Info)));
sw.Write("HashWSA302Cann= "); sw.WriteLine(Convert.ToBase64String(result));
export_can_node(Canonicalization(WSA302Info), "doc/WSA302_cann"); // экспорт результата каноникализации в файл
sw.WriteLine("********************************");
XmlNode WSA303Info = doc.SelectSingleNode(To, ns);
sw.Write("WSA303FromFile= "); sw.WriteLine(WSA303Info.OuterXml); // Пишем исходное в файл
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(WSA303Info.OuterXml));
sw.Write("HashWSA303File= "); sw.WriteLine(Convert.ToBase64String(result)); // Пишем хэш исходного
// Приводим тэг к канонической форме
sw.Write("CanonicalWSA303= "); sw.WriteLine(Canonicalization(WSA303Info));
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(Canonicalization(WSA303Info)));
sw.Write("HashWSA303Cann= "); sw.WriteLine(Convert.ToBase64String(result));
export_can_node(Canonicalization(WSA303Info), "doc/WSA303_cann"); // экспорт результата каноникализации в файл
sw.WriteLine("********************************");
XmlNode TRHEADInfo = doc.SelectSingleNode(transportHeader, ns);
sw.Write("TRHEADFromFile= "); sw.WriteLine(TRHEADInfo.OuterXml); // Пишем исходное в файл
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(TRHEADInfo.OuterXml));
sw.Write("HashTRHEADFile= "); sw.WriteLine(Convert.ToBase64String(result)); // Пишем хэш исходного
// Приводим тэг к канонической форме
sw.Write("CanonicalTRHEAD= "); sw.WriteLine(Canonicalization(TRHEADInfo));
result = gost3411.ComputeHash(Encoding.UTF8.GetBytes(Canonicalization(TRHEADInfo)));
sw.Write("HashTRHEADCann= "); sw.WriteLine(Convert.ToBase64String(result));
export_can_node(Canonicalization(TRHEADInfo), "doc/WSATRHEAD_cann"); // экспорт результата каноникализации в файл
sw.WriteLine("********************************");

// Console.WriteLine(signedInfo.InnerXml); Console.ReadKey();
sw.Close();
return;
</pre>

Скрипт выгрузки льготников (чернобыльцев), получивших стационарную помощь

2015-04-01T17:13:09Z

Dmitriy:

<PRE>
"\\TS\MySQL\bin\mysql.exe" --host=10.35.0.93 --default-character-set cp1251 --character-sets-dir "\\TS\MySQL\bin\share\charsets " --database statistics -udas -p12qwasZX < "C:\client\my_scripts\Talanova\1kv2015\stac_1_kv2015_norm.sql" >stac_31-03-2015n.res
</Pre>

*****
<Pre>
SELECT people.UNICOD, people.birthDate,tmp.id,CASE WHEN tmp.numberPolis <> '' THEN tmp.numberPolis ELSE 'Не найдено' END AS Полис,
people_document.NAME, office.name AS 'ЛПУ', privelege.name AS 'Наименование льготы', privelege.codOut, privelege.cod,
dynpeople.sDate AS 'Дата начала лечения',
dynpeople.eDate AS 'Дата окончания лечения', dynpeople.idlpu AS IDLPU, dynpeople.codDS
FROM dynpeople
LEFT OUTER JOIN (SELECT
people_polis_1.numberPolis,
people_polis_1.sDatePolis,
people_polis_1.eDatePolis,
people_polis_1.id,
people_polis_1.idlpu
FROM people_polis people_polis_1) tmp
ON tmp.id = dynpeople.idPeople AND tmp.idlpu = dynpeople.idlpu AND tmp.sDatePolis < dynpeople.sDate AND tmp.eDatePolis >= dynpeople.sDate
RIGHT OUTER JOIN people_lgot
ON people_lgot.id = tmp.id AND people_lgot.idlpu = tmp.idlpu
LEFT OUTER JOIN privelege
ON people_lgot.idLgot = privelege.unicod
RIGHT OUTER JOIN people
ON people_lgot.idlpu = people.idlpu AND people_lgot.id = people.unicod AND dynpeople.idPeople = people.unicod AND dynpeople.idlpu = people.idlpu
LEFT OUTER JOIN people_document
ON people.idlpu = people_document.idlpu AND people.unicod = people_document.id
LEFT OUTER JOIN office
ON office.idlpu=tmp.idlpu AND office.statusLPU=1
WHERE (dynpeople.NHist IS NOT NULL) AND privelege.codOut = '010' AND (year(dynpeople.edate) = 2015) AND (month(dynpeople.edate) < 4)
ORDER BY people.UNICOD;
</Pre>

Скрипт выгрузки льготников (чернобыльцев), получивших амбулаторную помощь

2015-04-01T17:06:40Z

Dmitriy:

<PRE>
set datetemp=start.tmp
@echo .>"C:\client\my_scripts\Talanova\1kv2015\%DATETEMP%"
"\\TS\MySQL\bin\mysql.exe" --host=10.35.0.93 --default-character-set cp1251 --character-sets-dir "\\TS\MySQL\bin\share\charsets " --database statistics -udas -p12qwasZX < "C:\client\my_scripts\Talanova\1kv2015\policl_1kv2015.sql" >pol_31-03-2015n.res
set datetemp=stop.tmp
@echo .>"C:\client\my_scripts\Talanova\1kv2015\%DATETEMP%"
</Pre>

****
<Pre>
SELECT people.UNICOD, people.birthDate,tmp.id,CASE WHEN tmp.numberPolis <> '' THEN tmp.numberPolis ELSE 'Не найдено' END AS Полис,
people_document.NAME, privelege.name AS 'Наименование льготы', privelege.codOut, privelege.cod, uslugappl.sDate AS 'Дата посещения',
uslugappl.eDate AS 'Завершено посещение', uslugappl.idlpu AS IDLPU, office.name AS 'ЛПУ', uslugappl.codDS
FROM uslugappl
LEFT OUTER JOIN (SELECT
people_polis_1.numberPolis,
people_polis_1.sDatePolis,
people_polis_1.eDatePolis,
people_polis_1.id,
people_polis_1.idlpu
FROM people_polis people_polis_1) tmp
ON tmp.id = uslugappl.idPeople AND tmp.idlpu = uslugappl.idlpu AND tmp.sDatePolis < uslugappl.sDate AND tmp.eDatePolis >= uslugappl.sDate
RIGHT OUTER JOIN people_lgot
ON people_lgot.id = tmp.id AND people_lgot.idlpu = tmp.idlpu
LEFT OUTER JOIN privelege
ON people_lgot.idLgot = privelege.unicod
RIGHT OUTER JOIN people
ON people_lgot.idlpu = people.idlpu AND people_lgot.id = people.unicod AND uslugappl.idPeople = people.unicod AND uslugappl.idlpu = people.idlpu
LEFT OUTER JOIN people_document
ON people.idlpu = people_document.idlpu AND people.unicod = people_document.id
LEFT OUTER JOIN office
ON office.idlpu=tmp.idlpu AND office.statusLPU=1
WHERE privelege.codOut = '010' AND uslugappl.YED = 2015 AND MONTH(uslugappl.eDate) < 4
ORDER BY people.UNICOD
</Pre>

Скрипт выгрузки льготников (чернобыльцев), получивших стационарную помощь

2015-04-01T17:05:19Z

Dmitriy: Новая страница: «<PRE> set datetemp=start.tmp @echo .>"C:\client\my_scripts\Talanova\1kv2015\%DATETEMP%" "\\TS\MySQL\bin\mysql.exe" --host=10.35.0.93 --default-character-set cp125…»

<PRE>
set datetemp=start.tmp
@echo .>"C:\client\my_scripts\Talanova\1kv2015\%DATETEMP%"
"\\TS\MySQL\bin\mysql.exe" --host=10.35.0.93 --default-character-set cp1251 --character-sets-dir "\\TS\MySQL\bin\share\charsets " --database statistics -udas -p12qwasZX < "C:\client\my_scripts\Talanova\1kv2015\policl_1kv2015.sql" >pol_31-03-2015n.res
set datetemp=stop.tmp
@echo .>"C:\client\my_scripts\Talanova\1kv2015\%DATETEMP%"
</Pre>

*****
<Pre>
SELECT people.UNICOD, people.birthDate,tmp.id,CASE WHEN tmp.numberPolis <> '' THEN tmp.numberPolis ELSE 'Не найдено' END AS Полис,
people_document.NAME, office.name AS 'ЛПУ', privelege.name AS 'Наименование льготы', privelege.codOut, privelege.cod,
dynpeople.sDate AS 'Дата начала лечения',
dynpeople.eDate AS 'Дата окончания лечения', dynpeople.idlpu AS IDLPU, dynpeople.codDS
FROM dynpeople
LEFT OUTER JOIN (SELECT
people_polis_1.numberPolis,
people_polis_1.sDatePolis,
people_polis_1.eDatePolis,
people_polis_1.id,
people_polis_1.idlpu
FROM people_polis people_polis_1) tmp
ON tmp.id = dynpeople.idPeople AND tmp.idlpu = dynpeople.idlpu AND tmp.sDatePolis < dynpeople.sDate AND tmp.eDatePolis >= dynpeople.sDate
RIGHT OUTER JOIN people_lgot
ON people_lgot.id = tmp.id AND people_lgot.idlpu = tmp.idlpu
LEFT OUTER JOIN privelege
ON people_lgot.idLgot = privelege.unicod
RIGHT OUTER JOIN people
ON people_lgot.idlpu = people.idlpu AND people_lgot.id = people.unicod AND dynpeople.idPeople = people.unicod AND dynpeople.idlpu = people.idlpu
LEFT OUTER JOIN people_document
ON people.idlpu = people_document.idlpu AND people.unicod = people_document.id
LEFT OUTER JOIN office
ON office.idlpu=tmp.idlpu AND office.statusLPU=1
WHERE (dynpeople.NHist IS NOT NULL) AND privelege.codOut = '010' AND (year(dynpeople.edate) = 2015) AND (month(dynpeople.edate) < 4)
ORDER BY people.UNICOD;
</Pre>

2015-02-13T09:38:14Z

Dmitriy:

#[[Получение хэша от строки по гост 94]]
#[[Подпись ИЭМК с помощью Crypto Pro]]
#[[Подпись ИЭМК с помощью VipNet CSP]]

Подпись ИЭМК

2015-02-13T09:37:17Z