dswage.xsd

中小企业人力资源管理系统

            <Mappings>
              <Mapping SourceColumn="MonthWage" DataSetColumn="MonthWage" />
              <Mapping SourceColumn="EmployeeID" DataSetColumn="EmployeeID" />
              <Mapping SourceColumn="EmployeeName" DataSetColumn="EmployeeName" />
              <Mapping SourceColumn="BasisWage" DataSetColumn="BasisWage" />
              <Mapping SourceColumn="Overtime" DataSetColumn="Overtime" />
              <Mapping SourceColumn="WageAge" DataSetColumn="WageAge" />
              <Mapping SourceColumn="AllAppeared" DataSetColumn="AllAppeared" />
              <Mapping SourceColumn="Hortation" DataSetColumn="Hortation" />
              <Mapping SourceColumn="Duty" DataSetColumn="Duty" />
              <Mapping SourceColumn="Absent" DataSetColumn="Absent" />
              <Mapping SourceColumn="Chastisement" DataSetColumn="Chastisement" />
              <Mapping SourceColumn="FosterOld" DataSetColumn="FosterOld" />
              <Mapping SourceColumn="Idleness" DataSetColumn="Idleness" />
              <Mapping SourceColumn="MedicalTreatment" DataSetColumn="MedicalTreatment" />
              <Mapping SourceColumn="Deal" DataSetColumn="Deal" />
              <Mapping SourceColumn="Deduct" DataSetColumn="Deduct" />
              <Mapping SourceColumn="FactWage" DataSetColumn="FactWage" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsWage" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsWage" msprop:Generator_DataSetName="dsWage">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tb_Wage" msprop:Generator_UserTableName="tb_Wage" msprop:Generator_RowDeletedName="tb_WageRowDeleted" msprop:Generator_TableClassName="tb_WageDataTable" msprop:Generator_RowChangedName="tb_WageRowChanged" msprop:Generator_RowClassName="tb_WageRow" msprop:Generator_RowChangingName="tb_WageRowChanging" msprop:Generator_RowEvArgName="tb_WageRowChangeEvent" msprop:Generator_RowEvHandlerName="tb_WageRowChangeEventHandler" msprop:Generator_TablePropName="tb_Wage" msprop:Generator_TableVarName="tabletb_Wage" msprop:Generator_RowDeletingName="tb_WageRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MonthWage" msprop:Generator_UserColumnName="MonthWage" msprop:Generator_ColumnPropNameInRow="MonthWage" msprop:Generator_ColumnVarNameInTable="columnMonthWage" msprop:Generator_ColumnPropNameInTable="MonthWageColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeID" msprop:Generator_UserColumnName="EmployeeID" msprop:Generator_ColumnPropNameInRow="EmployeeID" msprop:Generator_ColumnVarNameInTable="columnEmployeeID" msprop:Generator_ColumnPropNameInTable="EmployeeIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeName" msprop:Generator_UserColumnName="EmployeeName" msprop:Generator_ColumnPropNameInRow="EmployeeName" msprop:Generator_ColumnVarNameInTable="columnEmployeeName" msprop:Generator_ColumnPropNameInTable="EmployeeNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BasisWage" msprop:Generator_UserColumnName="BasisWage" msprop:Generator_ColumnPropNameInRow="BasisWage" msprop:Generator_ColumnVarNameInTable="columnBasisWage" msprop:Generator_ColumnPropNameInTable="BasisWageColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Overtime" msprop:Generator_UserColumnName="Overtime" msprop:Generator_ColumnPropNameInRow="Overtime" msprop:Generator_ColumnVarNameInTable="columnOvertime" msprop:Generator_ColumnPropNameInTable="OvertimeColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="WageAge" msprop:Generator_UserColumnName="WageAge" msprop:Generator_ColumnPropNameInRow="WageAge" msprop:Generator_ColumnVarNameInTable="columnWageAge" msprop:Generator_ColumnPropNameInTable="WageAgeColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="AllAppeared" msprop:Generator_UserColumnName="AllAppeared" msprop:Generator_ColumnPropNameInRow="AllAppeared" msprop:Generator_ColumnVarNameInTable="columnAllAppeared" msprop:Generator_ColumnPropNameInTable="AllAppearedColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hortation" msprop:Generator_UserColumnName="Hortation" msprop:Generator_ColumnPropNameInRow="Hortation" msprop:Generator_ColumnVarNameInTable="columnHortation" msprop:Generator_ColumnPropNameInTable="HortationColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Duty" msprop:Generator_UserColumnName="Duty" msprop:Generator_ColumnPropNameInRow="Duty" msprop:Generator_ColumnVarNameInTable="columnDuty" msprop:Generator_ColumnPropNameInTable="DutyColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Absent" msprop:Generator_UserColumnName="Absent" msprop:Generator_ColumnPropNameInRow="Absent" msprop:Generator_ColumnVarNameInTable="columnAbsent" msprop:Generator_ColumnPropNameInTable="AbsentColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Chastisement" msprop:Generator_UserColumnName="Chastisement" msprop:Generator_ColumnPropNameInRow="Chastisement" msprop:Generator_ColumnVarNameInTable="columnChastisement" msprop:Generator_ColumnPropNameInTable="ChastisementColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="FosterOld" msprop:Generator_UserColumnName="FosterOld" msprop:Generator_ColumnPropNameInRow="FosterOld" msprop:Generator_ColumnVarNameInTable="columnFosterOld" msprop:Generator_ColumnPropNameInTable="FosterOldColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Idleness" msprop:Generator_UserColumnName="Idleness" msprop:Generator_ColumnPropNameInRow="Idleness" msprop:Generator_ColumnVarNameInTable="columnIdleness" msprop:Generator_ColumnPropNameInTable="IdlenessColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="MedicalTreatment" msprop:Generator_UserColumnName="MedicalTreatment" msprop:Generator_ColumnPropNameInRow="MedicalTreatment" msprop:Generator_ColumnVarNameInTable="columnMedicalTreatment" msprop:Generator_ColumnPropNameInTable="MedicalTreatmentColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Deal" msprop:Generator_UserColumnName="Deal" msprop:Generator_ColumnPropNameInRow="Deal" msprop:Generator_ColumnVarNameInTable="columnDeal" msprop:Generator_ColumnPropNameInTable="DealColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Deduct" msprop:Generator_UserColumnName="Deduct" msprop:Generator_ColumnPropNameInRow="Deduct" msprop:Generator_ColumnVarNameInTable="columnDeduct" msprop:Generator_ColumnPropNameInTable="DeductColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="FactWage" msprop:Generator_UserColumnName="FactWage" msprop:Generator_ColumnPropNameInRow="FactWage" msprop:Generator_ColumnVarNameInTable="columnFactWage" msprop:Generator_ColumnPropNameInTable="FactWageColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tb_Wage" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>