dspersonel.xsd

基于SQLSERVER C#2.0的企业ERP管理系统

                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT tb_Personnel.*
FROM tb_Personnel</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [tb_Personnel] SET [EmployeeID] = @EmployeeID, [EmployeeName] = @EmployeeName, [EmployeeSex] = @EmployeeSex, [EmployeeIDcard] = @EmployeeIDcard, [EmployeeBirth] = @EmployeeBirth, [EmployeeAge] = @EmployeeAge, [EmployeeFolk] = @EmployeeFolk, [EmployeeMarriage] = @EmployeeMarriage, [EmployeePoliticsVisage] = @EmployeePoliticsVisage, [EmployeePartyTime] = @EmployeePartyTime, [EmployeeNativePlace] = @EmployeeNativePlace, [EmployeeTel] = @EmployeeTel, [EmployeeMobileTel] = @EmployeeMobileTel, [EmployeeAddress] = @EmployeeAddress, [EmployeeCollege] = @EmployeeCollege, [EmployeeSpeciality] = @EmployeeSpeciality, [EmployeeKultuLevel] = @EmployeeKultuLevel, [EmployeeLongSuit] = @EmployeeLongSuit, [EmployeeJoinWorkTime] = @EmployeeJoinWorkTime, [EmployeeWorkAge] = @EmployeeWorkAge, [EmployeePhoto] = @EmployeePhoto, [EmployeeDept] = @EmployeeDept, [EmployeeWorkType] = @EmployeeWorkType, [EmployeeDutyType] = @EmployeeDutyType, [EmployeePostTitle] = @EmployeePostTitle, [EmployeeBasePay] = @EmployeeBasePay, [EmployeeOther] = @EmployeeOther, [EmployeeFoldTime] = @EmployeeFoldTime, [EmployeeUnitWorkAge] = @EmployeeUnitWorkAge, [EmployeeResume] = @EmployeeResume, [Booker] = @Booker, [BookInTime] = @BookInTime WHERE (([EmployeeID] = @Original_EmployeeID) AND ([EmployeeName] = @Original_EmployeeName) AND ((@IsNull_EmployeeSex = 1 AND [EmployeeSex] IS NULL) OR ([EmployeeSex] = @Original_EmployeeSex)) AND ((@IsNull_EmployeeIDcard = 1 AND [EmployeeIDcard] IS NULL) OR ([EmployeeIDcard] = @Original_EmployeeIDcard)) AND ((@IsNull_EmployeeBirth = 1 AND [EmployeeBirth] IS NULL) OR ([EmployeeBirth] = @Original_EmployeeBirth)) AND ((@IsNull_EmployeeAge = 1 AND [EmployeeAge] IS NULL) OR ([EmployeeAge] = @Original_EmployeeAge)) AND ((@IsNull_EmployeeFolk = 1 AND [EmployeeFolk] IS NULL) OR ([EmployeeFolk] = @Original_EmployeeFolk)) AND ((@IsNull_EmployeeMarriage = 1 AND [EmployeeMarriage] IS NULL) OR ([EmployeeMarriage] = @Original_EmployeeMarriage)) AND ((@IsNull_EmployeePoliticsVisage = 1 AND [EmployeePoliticsVisage] IS NULL) OR ([EmployeePoliticsVisage] = @Original_EmployeePoliticsVisage)) AND ((@IsNull_EmployeePartyTime = 1 AND [EmployeePartyTime] IS NULL) OR ([EmployeePartyTime] = @Original_EmployeePartyTime)) AND ((@IsNull_EmployeeNativePlace = 1 AND [EmployeeNativePlace] IS NULL) OR ([EmployeeNativePlace] = @Original_EmployeeNativePlace)) AND ((@IsNull_EmployeeTel = 1 AND [EmployeeTel] IS NULL) OR ([EmployeeTel] = @Original_EmployeeTel)) AND ((@IsNull_EmployeeMobileTel = 1 AND [EmployeeMobileTel] IS NULL) OR ([EmployeeMobileTel] = @Original_EmployeeMobileTel)) AND ((@IsNull_EmployeeAddress = 1 AND [EmployeeAddress] IS NULL) OR ([EmployeeAddress] = @Original_EmployeeAddress)) AND ((@IsNull_EmployeeCollege = 1 AND [EmployeeCollege] IS NULL) OR ([EmployeeCollege] = @Original_EmployeeCollege)) AND ((@IsNull_EmployeeSpeciality = 1 AND [EmployeeSpeciality] IS NULL) OR ([EmployeeSpeciality] = @Original_EmployeeSpeciality)) AND ((@IsNull_EmployeeKultuLevel = 1 AND [EmployeeKultuLevel] IS NULL) OR ([EmployeeKultuLevel] = @Original_EmployeeKultuLevel)) AND ((@IsNull_EmployeeLongSuit = 1 AND [EmployeeLongSuit] IS NULL) OR ([EmployeeLongSuit] = @Original_EmployeeLongSuit)) AND ((@IsNull_EmployeeJoinWorkTime = 1 AND [EmployeeJoinWorkTime] IS NULL) OR ([EmployeeJoinWorkTime] = @Original_EmployeeJoinWorkTime)) AND ((@IsNull_EmployeeWorkAge = 1 AND [EmployeeWorkAge] IS NULL) OR ([EmployeeWorkAge] = @Original_EmployeeWorkAge)) AND ((@IsNull_EmployeeDept = 1 AND [EmployeeDept] IS NULL) OR ([EmployeeDept] = @Original_EmployeeDept)) AND ((@IsNull_EmployeeWorkType = 1 AND [EmployeeWorkType] IS NULL) OR ([EmployeeWorkType] = @Original_EmployeeWorkType)) AND ((@IsNull_EmployeeDutyType = 1 AND [EmployeeDutyType] IS NULL) OR ([EmployeeDutyType] = @Original_EmployeeDutyType)) AND ((@IsNull_EmployeePostTitle = 1 AND [EmployeePostTitle] IS NULL) OR ([EmployeePostTitle] = @Original_EmployeePostTitle)) AND ((@IsNull_EmployeeBasePay = 1 AND [EmployeeBasePay] IS NULL) OR ([EmployeeBasePay] = @Original_EmployeeBasePay)) AND ((@IsNull_EmployeeOther = 1 AND [EmployeeOther] IS NULL) OR ([EmployeeOther] = @Original_EmployeeOther)) AND ((@IsNull_EmployeeFoldTime = 1 AND [EmployeeFoldTime] IS NULL) OR ([EmployeeFoldTime] = @Original_EmployeeFoldTime)) AND ((@IsNull_EmployeeUnitWorkAge = 1 AND [EmployeeUnitWorkAge] IS NULL) OR ([EmployeeUnitWorkAge] = @Original_EmployeeUnitWorkAge)) AND ((@IsNull_Booker = 1 AND [Booker] IS NULL) OR ([Booker] = @Original_Booker)) AND ((@IsNull_BookInTime = 1 AND [BookInTime] IS NULL) OR ([BookInTime] = @Original_BookInTime)));
SELECT EmployeeID, EmployeeName, EmployeeSex, EmployeeIDcard, EmployeeBirth, EmployeeAge, EmployeeFolk, EmployeeMarriage, EmployeePoliticsVisage, EmployeePartyTime, EmployeeNativePlace, EmployeeTel, EmployeeMobileTel, EmployeeAddress, EmployeeCollege, EmployeeSpeciality, EmployeeKultuLevel, EmployeeLongSuit, EmployeeJoinWorkTime, EmployeeWorkAge, EmployeePhoto, EmployeeDept, EmployeeWorkType, EmployeeDutyType, EmployeePostTitle, EmployeeBasePay, EmployeeOther, EmployeeFoldTime, EmployeeUnitWorkAge, EmployeeResume, Booker, BookInTime FROM tb_Personnel WHERE (EmployeeID = @EmployeeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeSex" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeIDcard" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeIDcard" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EmployeeBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EmployeeBirth" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeAge" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeAge" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeFolk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeFolk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeMarriage" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeMarriage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeePoliticsVisage" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeePoliticsVisage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EmployeePartyTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EmployeePartyTime" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeNativePlace" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeNativePlace" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeTel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeMobileTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeMobileTel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeAddress" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeCollege" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeCollege" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeSpeciality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeSpeciality" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeKultuLevel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeKultuLevel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeLongSuit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeLongSuit" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EmployeeJoinWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EmployeeJoinWorkTime" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeWorkAge" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeWorkAge" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@EmployeePhoto" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="EmployeePhoto" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeDept" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeDept" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeWorkType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeWorkType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeDutyType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeeDutyType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeePostTitle" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmployeePostTitle" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@EmployeeBasePay" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EmployeeBasePay" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@EmployeeOther" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EmployeeOther" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EmployeeFoldTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EmployeeFoldTime" SourceColumnNullMapping="False" SourceVersion="Current">