dataset_views.xsd

以前为一家4S店开发的维修管理及客户管理的软件,C#开发!

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet_Views" targetNamespace="http://tempuri.org/DataSet_Views.xsd" xmlns:mstns="http://tempuri.org/DataSet_Views.xsd" xmlns="http://tempuri.org/DataSet_Views.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="mmerpConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="mmerpConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.RepairCRM.Properties.Settings.GlobalReference.Default.mmerpConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_customerdeailTableAdapter" GeneratorDataComponentClassName="v_customerdeailTableAdapter" Name="v_customerdeail" UserDataComponentName="v_customerdeailTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_customerdeail" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Ctypename, Caren, Facdate, Keyno, Passno, Carno, Carnofrom, Carnodate, Buywhere, Buyuse, Securitypassword, Keypassword, Buyprice, IcNo, Daymileage, Prekeep, Introducertel, Introducer, Paytype, Buyfor, Buytype, Specialdate, Jobuint, Position, Contents, Birthday, Email, Handtel, Tel, Cardno, Degree, Aderss, customername, Id, cidpicid, carpicid, Carmileage, indate, repairtypename, Carrack, usename, timeconst, typeconst, times, repairdate, vistname, salename, vistid, vipcardno, Adress, contactname, contacttel, contacthandtel, officetel, insurename, Safeitem, rate, safeno, BName, BTelAndAddress FROM dbo.v_customerdeail</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Ctypename" DataSetColumn="Ctypename" />
              <Mapping SourceColumn="Caren" DataSetColumn="Caren" />
              <Mapping SourceColumn="Facdate" DataSetColumn="Facdate" />
              <Mapping SourceColumn="Keyno" DataSetColumn="Keyno" />
              <Mapping SourceColumn="Passno" DataSetColumn="Passno" />
              <Mapping SourceColumn="Carno" DataSetColumn="Carno" />
              <Mapping SourceColumn="Carnofrom" DataSetColumn="Carnofrom" />
              <Mapping SourceColumn="Carnodate" DataSetColumn="Carnodate" />
              <Mapping SourceColumn="Buywhere" DataSetColumn="Buywhere" />
              <Mapping SourceColumn="Buyuse" DataSetColumn="Buyuse" />
              <Mapping SourceColumn="Securitypassword" DataSetColumn="Securitypassword" />
              <Mapping SourceColumn="Keypassword" DataSetColumn="Keypassword" />
              <Mapping SourceColumn="Buyprice" DataSetColumn="Buyprice" />
              <Mapping SourceColumn="IcNo" DataSetColumn="IcNo" />
              <Mapping SourceColumn="Daymileage" DataSetColumn="Daymileage" />
              <Mapping SourceColumn="Prekeep" DataSetColumn="Prekeep" />
              <Mapping SourceColumn="Introducertel" DataSetColumn="Introducertel" />
              <Mapping SourceColumn="Introducer" DataSetColumn="Introducer" />
              <Mapping SourceColumn="Paytype" DataSetColumn="Paytype" />
              <Mapping SourceColumn="Buyfor" DataSetColumn="Buyfor" />
              <Mapping SourceColumn="Buytype" DataSetColumn="Buytype" />
              <Mapping SourceColumn="Specialdate" DataSetColumn="Specialdate" />
              <Mapping SourceColumn="Jobuint" DataSetColumn="Jobuint" />
              <Mapping SourceColumn="Position" DataSetColumn="Position" />
              <Mapping SourceColumn="Contents" DataSetColumn="Contents" />
              <Mapping SourceColumn="Birthday" DataSetColumn="Birthday" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Handtel" DataSetColumn="Handtel" />
              <Mapping SourceColumn="Tel" DataSetColumn="Tel" />
              <Mapping SourceColumn="Cardno" DataSetColumn="Cardno" />
              <Mapping SourceColumn="Degree" DataSetColumn="Degree" />
              <Mapping SourceColumn="Aderss" DataSetColumn="Aderss" />
              <Mapping SourceColumn="customername" DataSetColumn="customername" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="cidpicid" DataSetColumn="cidpicid" />
              <Mapping SourceColumn="carpicid" DataSetColumn="carpicid" />
              <Mapping SourceColumn="Carmileage" DataSetColumn="Carmileage" />
              <Mapping SourceColumn="indate" DataSetColumn="indate" />
              <Mapping SourceColumn="repairtypename" DataSetColumn="repairtypename" />
              <Mapping SourceColumn="Carrack" DataSetColumn="Carrack" />
              <Mapping SourceColumn="usename" DataSetColumn="usename" />
              <Mapping SourceColumn="timeconst" DataSetColumn="timeconst" />
              <Mapping SourceColumn="typeconst" DataSetColumn="typeconst" />
              <Mapping SourceColumn="times" DataSetColumn="times" />
              <Mapping SourceColumn="repairdate" DataSetColumn="repairdate" />
              <Mapping SourceColumn="vistname" DataSetColumn="vistname" />
              <Mapping SourceColumn="salename" DataSetColumn="salename" />
              <Mapping SourceColumn="vistid" DataSetColumn="vistid" />
              <Mapping SourceColumn="vipcardno" DataSetColumn="vipcardno" />
              <Mapping SourceColumn="Adress" DataSetColumn="Adress" />
              <Mapping SourceColumn="contactname" DataSetColumn="contactname" />
              <Mapping SourceColumn="contacttel" DataSetColumn="contacttel" />
              <Mapping SourceColumn="contacthandtel" DataSetColumn="contacthandtel" />
              <Mapping SourceColumn="officetel" DataSetColumn="officetel" />
              <Mapping SourceColumn="insurename" DataSetColumn="insurename" />
              <Mapping SourceColumn="Safeitem" DataSetColumn="Safeitem" />
              <Mapping SourceColumn="rate" DataSetColumn="rate" />
              <Mapping SourceColumn="safeno" DataSetColumn="safeno" />
              <Mapping SourceColumn="BName" DataSetColumn="BName" />
              <Mapping SourceColumn="BTelAndAddress" DataSetColumn="BTelAndAddress" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_customrepairconstTableAdapter" GeneratorDataComponentClassName="v_customrepairconstTableAdapter" Name="v_customrepairconst" UserDataComponentName="v_customrepairconstTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_customrepairconst" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT cid, times, timeconst, timefavour, typeconst, typefavour FROM dbo.v_customrepairconst</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cid" DataSetColumn="cid" />
              <Mapping SourceColumn="times" DataSetColumn="times" />
              <Mapping SourceColumn="timeconst" DataSetColumn="timeconst" />
              <Mapping SourceColumn="timefavour" DataSetColumn="timefavour" />
              <Mapping SourceColumn="typeconst" DataSetColumn="typeconst" />
              <Mapping SourceColumn="typefavour" DataSetColumn="typefavour" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_defendTableAdapter" GeneratorDataComponentClassName="v_defendTableAdapter" Name="v_defend" UserDataComponentName="v_defendTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_defend" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Carno, Safeitem, Safestartdate, Safeenddate, Safeprice, FullName, UserCode, rate, safeno FROM dbo.v_defend</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Carno" DataSetColumn="Carno" />
              <Mapping SourceColumn="Safeitem" DataSetColumn="Safeitem" />
              <Mapping SourceColumn="Safestartdate" DataSetColumn="Safestartdate" />
              <Mapping SourceColumn="Safeenddate" DataSetColumn="Safeenddate" />
              <Mapping SourceColumn="Safeprice" DataSetColumn="Safeprice" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="UserCode" DataSetColumn="UserCode" />
              <Mapping SourceColumn="rate" DataSetColumn="rate" />
              <Mapping SourceColumn="safeno" DataSetColumn="safeno" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_employeerepairTableAdapter" GeneratorDataComponentClassName="v_employeerepairTableAdapter" Name="v_employeerepair" UserDataComponentName="v_employeerepairTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_employeerepair" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT times, timeconst, timefavour, typeconst, typefavour, employeeid FROM dbo.v_employeerepair</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="times" DataSetColumn="times" />
              <Mapping SourceColumn="timeconst" DataSetColumn="timeconst" />
              <Mapping SourceColumn="timefavour" DataSetColumn="timefavour" />
              <Mapping SourceColumn="typeconst" DataSetColumn="typeconst" />
              <Mapping SourceColumn="typefavour" DataSetColumn="typefavour" />