PDA

View Full Version : XSD رابطه XML



mandanim
دوشنبه 22 شهریور 1395, 22:12 عصر
سلام دوستان
من برای اولین بار یه فایل XSD دیدم
XML هم اصلا کار نکردم


تو سایتهای مختلف هم دیدم که XSD برای اعتبار سنجی XML مورد استفاده قرار می گیره
من دو تا فایل دارم XSD و XML
و دیتابیستم دو تا Table دارم
یکی Master اون یکی Details


چه بکنم فایل xml این رو بوجود بیارم
آیا رابطه این بین این دو تا هست
XSD
<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="OD">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="unbounded" ref="TC"/>
<xs:element minOccurs="0" maxOccurs="unbounded" ref="SP"/>
</xs:sequence>
<xs:attribute name="NO" type="xs:unsignedInt" use="required" />
<xs:attribute name="MD" type="xs:date" use="required" />
<xs:attribute name="ED" type="xs:date" use="required" />
<xs:attribute name="SC" type="SCString" use="required" />
<xs:attribute name="BN" type="BNString" use="required" />
<xs:attribute name="DC" type="NCString " use="required" />
<xs:attribute name="OC" type="NCString " use="required" />
<xs:attribute name="LC" type="xs:unsignedInt" use="required" />
<xs:attribute name="PX" type="PXString" use="required" />
</xs:complexType>
</xs:element>
<xs:element name="TC">
<xs:complexType>
<xs:attribute name="HC" type="HCString" use="required" />
<xs:attribute name="BC" type="BCString" use="required" />
</xs:complexType>
</xs:element>
<xs:element name="SP">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="unbounded" ref="TC"/>
<xs:element minOccurs="0" maxOccurs="unbounded" ref="SP"/>
</xs:sequence>
<xs:attribute name="PBC" type="BCString" use="required" />
</xs:complexType>
</xs:element>
<xs:simpleType name="NCString">
<xs:restriction base="xs:string">
<xs:minLength value="11" />
<xs:maxLength value="11" />
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="BNString">
<xs:restriction base="xs:string">
<xs:minLength value="0" />
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="SCString">
<xs:restriction base="xs:string">
<xs:minLength value="16" />
<xs:maxLength value="16" />
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="PXString">
<xs:restriction base="xs:string">
<xs:minLength value="4" />
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="HCString">
<xs:restriction base="xs:string">
<xs:minLength value="40" />
<xs:maxLength value="40" />
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="BCString">
<xs:restriction base="xs:string">
<xs:minLength value="48" />
</xs:restriction>
</xs:simpleType>
</xs:schema>


XMLبوجود آمده به این صورت هست

<?xml version="1.0" encoding="UTF-8"?>

-<OD PX="9999" LC="365499" OC="10101010101" DC="10101010101" BN="1104856" SC="9999999999999999" ED="2016-10-21" MD="2013-10-22" NO="38">


-<SP PBC="01 2 9999999999999 21 99990 2 10550160260318 17 161001 10 1104856">


-<SP PBC="01 1 9999999999999 21 99990 1 10550160260318 17161001101104856">

<TC BC="01 0 9999999999999 21 99990 0 34369627158810 17161001101104856" HC="CFED75C97606D5889C49FFF6C07A1ECBDE1DD56B"/>

<TC BC="01099999999999992199990099549562159116171610011011 04856" HC="F27DC6D45B75C489E7CFAD6210100E9AB1CFA657"/>

<TC BC="01099999999999992199990012874909611773171610011011 04856" HC="5EC2F62335C85EECF85666CA63F741EA1C1A8F46"/>

<TC BC="01099999999999992199990064866882086055171610011011 04856" HC="44D0AFC95C2397F88C4524FA4C38E1255B393391"/>

<TC BC="01099999999999992199990036072995647181171610011011 04856" HC="8F0E2DEDFF0DF068D1D4584A0EBD61D3959287F7"/>

<TC BC="01099999999999992199990047777634874303171610011011 04856" HC="2B24F95DA76953A14E1899ECFF0307E3F586F481"/>

<TC BC="01099999999999992199990083278931927922171610011011 04856" HC="FC666C9017CB71B94CB9FB374E94301846CE37B7"/>

<TC BC="01099999999999992199990080769780927758171610011011 04856" HC="E5F23DBA090FDBF360BF430267EE9E455C03D706"/>

<TC BC="01099999999999992199990067427659597215171610011011 04856" HC="22AD66D3939081AB6D0861B38CAB8DFA741EEECD"/>

<TC BC="01099999999999992199990076316379783613171610011011 04856" HC="47D249D1AADC63DDE32A19B802BAFE1249B5A4A7"/>

<TC BC="01099999999999992199990095781986931854171610011011 04856" HC="5C4C8D85BA0539145BD9714C920738E811B21AF3"/>

<TC BC="01099999999999992199990042237064303620171610011011 04856" HC="8D491C3420DC23C69B4323D4639D2E890DE7A93D"/>

<TC BC="01099999999999992199990018095178562148171610011011 04856" HC="8B0105A01FAB5DF4227498B443D2808355D1A6E7"/>

<TC BC="01099999999999992199990042730654443570171610011011 04856" HC="CDD10AFFC521D3A62FD3D6602E7E3540EB75A581"/>

</SP>


-<SP PBC="01199999999999992199990110977967261133171610011011 04856">

<TC BC="01099999999999992199990031851748283014171610011011 04856" HC="895A12094E0FA6FC412D37766173C5A7D1CE69F0"/>

<TC BC="01099999999999992199990024652924112188171610011011 04856" HC="6BA1C1E9735E1ABBA93E8F1296740FF3F0C5B1DE"/>

<TC BC="01099999999999992199990032294938353092171610011011 04856" HC="1D884A0A5637095AABBE845E625BC48EB367BB3B"/>

<TC BC="01099999999999992199990051040502837747171610011011 04856" HC="244B744439C4FBEFADECE7A6904388BD23DAA84A"/>

<TC BC="01099999999999992199990070449277311210171610011011 04856" HC="F62C66A87D1059C1994AEB3EC3EE8926FDC9AC3A"/>

<TC BC="01099999999999992199990090659572945828171610011011 04856" HC="3F9A8679923CD04483CF5CCFDF7C4EDF3ED79A6B"/>

<TC BC="01099999999999992199990047194230063554171610011011 04856" HC="73EB5BBA7815CBC2384C8D2DA061304613E2ECB2"/>

<TC BC="01099999999999992199990028569684979756171610011011 04856" HC="3C336CC2C5D64ED88F82EC610B5E70C7CFFF8A0A"/>

<TC BC="01099999999999992199990064671804779180171610011011 04856" HC="849DE89959A34518B6E2BBE81AC2653ADBB45335"/>

<TC BC="01099999999999992199990042715788978120171610011011 04856" HC="617C51FE51C0024BECB40D4A240EF1F134C10CD9"/>

<TC BC="01099999999999992199990049812183906902171610011011 04856" HC="942703743DB5BC407FB4ED3D445A60C1851E394A"/>

<TC BC="01099999999999992199990050424488205339171610011011 04856" HC="34D5F46B0C6E2145E8C389FB35154B30465BA598"/>

<TC BC="01099999999999992199990013080869255916171610011011 04856" HC="1FE60AE4C11B46E972CDE90FF5FFA1EA914DD790"/>

<TC BC="01099999999999992199990015223137246917171610011011 04856" HC="064A58EF5916D092A341A03366D41E071A2CB087"/>

<TC BC="01099999999999992199990067853744393413171610011011 04856" HC="9A2CD724283DA1D3235A52426195FEFD302BD313"/>

<TC BC="01099999999999992199990053641844079110171610011011 04856" HC="D03D23EF0C9E551AF053A55EB0753BAB5D29E87B"/>

<TC BC="01099999999999992199990094852585210749171610011011 04856" HC="B02C4DC2DC5C3AB997DA95A57C9ECE930CF86485"/>

<TC BC="01099999999999992199990068697256105436171610011011 04856" HC="FCC19986026CE4EF9762B2D4167C4698889E645F"/>

<TC BC="01099999999999992199990045159244680738171610011011 04856" HC="550FC2103DD74CCD4E3B4537EDCBF68511D3CC5C"/>

<TC BC="01099999999999992199990057195646934899171610011011 04856" HC="C67D959B0AEF36716420AF126301C8106E6F3047"/>

<TC BC="01099999999999992199990025036339064306171610011011 04856" HC="E8E8C5B86D6DACDFC7AC32E5B5C217F4A68C8BDA"/>

<TC BC="01099999999999992199990016583783401169171610011011 04856" HC="B6B09A52CA6F965CA13C91B65398901C249613BB"/>

<TC BC="01099999999999992199990029422051463936171610011011 04856" HC="97A6FC7F0767C74D0030A9AF7FE96AC90D0D03E9"/>

<TC BC="01099999999999992199990079199655278200171610011011 04856" HC="7A4DFD519592419A64117A68909B1CDA7972E3E8"/>

</SP>

</SP>

</OD>

mandanim
سه شنبه 23 شهریور 1395, 00:08 صبح
رابطه بسیار جالبی با هم داشتن
پیداش کردم
ممنون

amir_mhdi
شنبه 08 آبان 1395, 15:54 عصر
من هم مشکلی مشابه شما دارم . رابطه اونها چی هست؟