jobdetailsdataset.xsd

这是一个保障消费者合法权益的系统．使用C ＃和SQL Server终于实现了这一功能的系统

<?xml version="1.0" standalone="yes"?>
<xs:schema id="JobDetailsDataSet" targetNamespace="http://www.tempuri.org/JobDetailsDataSet.xsd" xmlns:mstns="http://www.tempuri.org/JobDetailsDataSet.xsd" xmlns="http://www.tempuri.org/JobDetailsDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:element name="JobDetailsDataSet" msdata:IsDataSet="true">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="tblTrans">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CarNo" type="xs:string" />
              <xs:element name="JobDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="KM" type="xs:int" minOccurs="0" />
              <xs:element name="Tuning" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Alignment" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Balancing" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Tyres" type="xs:int" minOccurs="0" />
              <xs:element name="Weights" type="xs:int" minOccurs="0" />
              <xs:element name="OilChanged" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="OilQty" type="xs:double" minOccurs="0" />
              <xs:element name="OilFilter" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="GearOil" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="GearOilQty" type="xs:double" minOccurs="0" />
              <xs:element name="Point" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Condenser" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Plug" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="PlugQty" type="xs:int" minOccurs="0" />
              <xs:element name="FuelFilter" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="AirFilter" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="WADoneBy" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="STDoneBy" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Remarks" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>