dspersonel.xsd

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

                    <CommandText>INSERT INTO [tb_Personnel] ([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]) VALUES (@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);
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">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeUnitWorkAge" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeUnitWorkAge" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmployeeResume" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="EmployeeResume" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Booker" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Booker" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BookInTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BookInTime" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>