1 Star 2 Fork 1

Mr-Groundhog/大学生就业管理系统

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
jobDBDataSet1.xsd 78.47 KB
一键复制 编辑 原始数据 按行查看 历史
Mr-Groundhog 提交于 2022-08-07 21:47 . 大学生就业管理系统
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="jobDBDataSet1" targetNamespace="http://tempuri.org/jobDBDataSet1.xsd" xmlns:mstns="http://tempuri.org/jobDBDataSet1.xsd" xmlns="http://tempuri.org/jobDBDataSet1.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="jobDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="jobDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.job.Properties.Settings.GlobalReference.Default.jobDBConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="company_adminTableAdapter" GeneratorDataComponentClassName="company_adminTableAdapter" Name="company_admin" UserDataComponentName="company_adminTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.company_admin" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[company_admin] WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_sex = 1 AND [sex] IS NULL) OR ([sex] = @Original_sex)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_sex" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[company_admin] ([id], [name], [sex], [password]) VALUES (@id, @name, @sex, @password);
SELECT id, name, sex, password FROM company_admin WHERE (id = @id)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@sex" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT id, name, sex, password FROM dbo.company_admin</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[company_admin] SET [id] = @id, [name] = @name, [sex] = @sex, [password] = @password WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_sex = 1 AND [sex] IS NULL) OR ([sex] = @Original_sex)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)));
SELECT id, name, sex, password FROM company_admin WHERE (id = @id)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@sex" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_sex" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="id" DataSetColumn="id" />
<Mapping SourceColumn="name" DataSetColumn="name" />
<Mapping SourceColumn="sex" DataSetColumn="sex" />
<Mapping SourceColumn="password" DataSetColumn="password" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="company_newTableAdapter" GeneratorDataComponentClassName="company_newTableAdapter" Name="company_new" UserDataComponentName="company_newTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.company_new" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[company_new] WHERE (([Ccno] = @Original_Ccno) AND ((@IsNull_Ccname = 1 AND [Ccname] IS NULL) OR ([Ccname] = @Original_Ccname)) AND ((@IsNull_Cnumber = 1 AND [Cnumber] IS NULL) OR ([Cnumber] = @Original_Cnumber)) AND ((@IsNull_Cjob = 1 AND [Cjob] IS NULL) OR ([Cjob] = @Original_Cjob)) AND ((@IsNull_Cemploy = 1 AND [Cemploy] IS NULL) OR ([Cemploy] = @Original_Cemploy)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ccname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cnumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cnumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cjob" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[company_new] ([Ccno], [Ccname], [Cnumber], [Cjob], [Cemploy]) VALUES (@Ccno, @Ccname, @Cnumber, @Cjob, @Cemploy);
SELECT Ccno, Ccname, Cnumber, Cjob, Cemploy FROM company_new WHERE (Ccno = @Ccno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cnumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT Ccno, Ccname, Cnumber, Cjob, Cemploy FROM dbo.company_new</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[company_new] SET [Ccno] = @Ccno, [Ccname] = @Ccname, [Cnumber] = @Cnumber, [Cjob] = @Cjob, [Cemploy] = @Cemploy WHERE (([Ccno] = @Original_Ccno) AND ((@IsNull_Ccname = 1 AND [Ccname] IS NULL) OR ([Ccname] = @Original_Ccname)) AND ((@IsNull_Cnumber = 1 AND [Cnumber] IS NULL) OR ([Cnumber] = @Original_Cnumber)) AND ((@IsNull_Cjob = 1 AND [Cjob] IS NULL) OR ([Cjob] = @Original_Cjob)) AND ((@IsNull_Cemploy = 1 AND [Cemploy] IS NULL) OR ([Cemploy] = @Original_Cemploy)));
SELECT Ccno, Ccname, Cnumber, Cjob, Cemploy FROM company_new WHERE (Ccno = @Ccno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cnumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ccname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cnumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cnumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cjob" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Ccno" DataSetColumn="Ccno" />
<Mapping SourceColumn="Ccname" DataSetColumn="Ccname" />
<Mapping SourceColumn="Cnumber" DataSetColumn="Cnumber" />
<Mapping SourceColumn="Cjob" DataSetColumn="Cjob" />
<Mapping SourceColumn="Cemploy" DataSetColumn="Cemploy" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="company_zhaopinTableAdapter" GeneratorDataComponentClassName="company_zhaopinTableAdapter" Name="company_zhaopin" UserDataComponentName="company_zhaopinTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.company_zhaopin" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[company_zhaopin] WHERE (([Zcno] = @Original_Zcno) AND ((@IsNull_Zname = 1 AND [Zname] IS NULL) OR ([Zname] = @Original_Zname)) AND ((@IsNull_Zjob = 1 AND [Zjob] IS NULL) OR ([Zjob] = @Original_Zjob)) AND ((@IsNull_Zphone = 1 AND [Zphone] IS NULL) OR ([Zphone] = @Original_Zphone)) AND ((@IsNull_Znumber = 1 AND [Znumber] IS NULL) OR ([Znumber] = @Original_Znumber)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Zcno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zcno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zname" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Zname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zname" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zjob" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zjob" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Zjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zjob" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zphone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zphone" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Zphone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zphone" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Znumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Znumber" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Znumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Znumber" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[company_zhaopin] ([Zcno], [Zname], [Zjob], [Zphone], [Znumber]) VALUES (@Zcno, @Zname, @Zjob, @Zphone, @Znumber);
SELECT Zcno, Zname, Zjob, Zphone, Znumber FROM company_zhaopin WHERE (Zcno = @Zcno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zcno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zcno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zname" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zjob" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Zphone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zphone" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Znumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Znumber" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT Zcno, Zname, Zjob, Zphone, Znumber FROM dbo.company_zhaopin</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[company_zhaopin] SET [Zcno] = @Zcno, [Zname] = @Zname, [Zjob] = @Zjob, [Zphone] = @Zphone, [Znumber] = @Znumber WHERE (([Zcno] = @Original_Zcno) AND ((@IsNull_Zname = 1 AND [Zname] IS NULL) OR ([Zname] = @Original_Zname)) AND ((@IsNull_Zjob = 1 AND [Zjob] IS NULL) OR ([Zjob] = @Original_Zjob)) AND ((@IsNull_Zphone = 1 AND [Zphone] IS NULL) OR ([Zphone] = @Original_Zphone)) AND ((@IsNull_Znumber = 1 AND [Znumber] IS NULL) OR ([Znumber] = @Original_Znumber)));
SELECT Zcno, Zname, Zjob, Zphone, Znumber FROM company_zhaopin WHERE (Zcno = @Zcno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zcno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zcno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zname" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zjob" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Zphone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zphone" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Znumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Znumber" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Zcno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zcno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zname" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Zname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zname" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zjob" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zjob" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Zjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zjob" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zphone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zphone" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Zphone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zphone" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Znumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Znumber" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Znumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Znumber" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Zcno" DataSetColumn="Zcno" />
<Mapping SourceColumn="Zname" DataSetColumn="Zname" />
<Mapping SourceColumn="Zjob" DataSetColumn="Zjob" />
<Mapping SourceColumn="Zphone" DataSetColumn="Zphone" />
<Mapping SourceColumn="Znumber" DataSetColumn="Znumber" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="job_adminTableAdapter" GeneratorDataComponentClassName="job_adminTableAdapter" Name="job_admin" UserDataComponentName="job_adminTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.job_admin" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[job_admin] ([id], [password]) VALUES (@id, @password)</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT id, password FROM dbo.job_admin</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="id" DataSetColumn="id" />
<Mapping SourceColumn="password" DataSetColumn="password" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="student_applyTableAdapter" GeneratorDataComponentClassName="student_applyTableAdapter" Name="student_apply" UserDataComponentName="student_applyTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.student_apply" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[student_apply] WHERE (([sno] = @Original_sno) AND ([name] = @Original_name) AND ((@IsNull_Asex = 1 AND [Asex] IS NULL) OR ([Asex] = @Original_Asex)) AND ((@IsNull_Amajor = 1 AND [Amajor] IS NULL) OR ([Amajor] = @Original_Amajor)) AND ((@IsNull_Agw = 1 AND [Agw] IS NULL) OR ([Agw] = @Original_Agw)) AND ([Ccno] = @Original_Ccno))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Asex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Asex" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Asex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asex" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Amajor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Amajor" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Amajor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Amajor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Agw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Agw" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Agw" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Agw" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[student_apply] ([sno], [name], [Asex], [Amajor], [Agw], [Ccno]) VALUES (@sno, @name, @Asex, @Amajor, @Agw, @Ccno);
SELECT sno, name, Asex, Amajor, Agw, Ccno FROM student_apply WHERE (Ccno = @Ccno) AND (sno = @sno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Asex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asex" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Amajor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Amajor" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Agw" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Agw" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT sno, name, Asex, Amajor, Agw, Ccno FROM dbo.student_apply</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[student_apply] SET [sno] = @sno, [name] = @name, [Asex] = @Asex, [Amajor] = @Amajor, [Agw] = @Agw, [Ccno] = @Ccno WHERE (([sno] = @Original_sno) AND ([name] = @Original_name) AND ((@IsNull_Asex = 1 AND [Asex] IS NULL) OR ([Asex] = @Original_Asex)) AND ((@IsNull_Amajor = 1 AND [Amajor] IS NULL) OR ([Amajor] = @Original_Amajor)) AND ((@IsNull_Agw = 1 AND [Agw] IS NULL) OR ([Agw] = @Original_Agw)) AND ([Ccno] = @Original_Ccno));
SELECT sno, name, Asex, Amajor, Agw, Ccno FROM student_apply WHERE (Ccno = @Ccno) AND (sno = @sno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Asex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asex" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Amajor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Amajor" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Agw" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Agw" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Asex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Asex" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Asex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asex" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Amajor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Amajor" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Amajor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Amajor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Agw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Agw" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Agw" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Agw" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="sno" DataSetColumn="sno" />
<Mapping SourceColumn="name" DataSetColumn="name" />
<Mapping SourceColumn="Asex" DataSetColumn="Asex" />
<Mapping SourceColumn="Amajor" DataSetColumn="Amajor" />
<Mapping SourceColumn="Agw" DataSetColumn="Agw" />
<Mapping SourceColumn="Ccno" DataSetColumn="Ccno" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="student_newsTableAdapter" GeneratorDataComponentClassName="student_newsTableAdapter" Name="student_news" UserDataComponentName="student_newsTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.student_news" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[student_news] WHERE (([sno] = @Original_sno) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_Smajor = 1 AND [Smajor] IS NULL) OR ([Smajor] = @Original_Smajor)) AND ((@IsNull_Snumber = 1 AND [Snumber] IS NULL) OR ([Snumber] = @Original_Snumber)) AND ((@IsNull_Sgoto = 1 AND [Sgoto] IS NULL) OR ([Sgoto] = @Original_Sgoto)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Smajor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Smajor" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Smajor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Smajor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Snumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Snumber" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Snumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Snumber" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sgoto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sgoto" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sgoto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sgoto" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[student_news] ([sno], [name], [Smajor], [Snumber], [Sgoto]) VALUES (@sno, @name, @Smajor, @Snumber, @Sgoto);
SELECT sno, name, Smajor, Snumber, Sgoto FROM student_news WHERE (sno = @sno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Smajor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Smajor" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Snumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Snumber" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sgoto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sgoto" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT sno, name, Smajor, Snumber, Sgoto FROM dbo.student_news</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[student_news] SET [sno] = @sno, [name] = @name, [Smajor] = @Smajor, [Snumber] = @Snumber, [Sgoto] = @Sgoto WHERE (([sno] = @Original_sno) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_Smajor = 1 AND [Smajor] IS NULL) OR ([Smajor] = @Original_Smajor)) AND ((@IsNull_Snumber = 1 AND [Snumber] IS NULL) OR ([Snumber] = @Original_Snumber)) AND ((@IsNull_Sgoto = 1 AND [Sgoto] IS NULL) OR ([Sgoto] = @Original_Sgoto)));
SELECT sno, name, Smajor, Snumber, Sgoto FROM student_news WHERE (sno = @sno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Smajor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Smajor" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Snumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Snumber" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sgoto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sgoto" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Smajor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Smajor" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Smajor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Smajor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Snumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Snumber" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Snumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Snumber" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sgoto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sgoto" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sgoto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sgoto" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="sno" DataSetColumn="sno" />
<Mapping SourceColumn="name" DataSetColumn="name" />
<Mapping SourceColumn="Smajor" DataSetColumn="Smajor" />
<Mapping SourceColumn="Snumber" DataSetColumn="Snumber" />
<Mapping SourceColumn="Sgoto" DataSetColumn="Sgoto" />
</Mappings>
<Sources />
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="jobDBDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="jobDBDataSet1" msprop:Generator_UserDSName="jobDBDataSet1">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="company_admin" msprop:Generator_TableClassName="company_adminDataTable" msprop:Generator_TableVarName="tablecompany_admin" msprop:Generator_TablePropName="company_admin" msprop:Generator_RowDeletingName="company_adminRowDeleting" msprop:Generator_RowChangingName="company_adminRowChanging" msprop:Generator_RowEvHandlerName="company_adminRowChangeEventHandler" msprop:Generator_RowDeletedName="company_adminRowDeleted" msprop:Generator_UserTableName="company_admin" msprop:Generator_RowChangedName="company_adminRowChanged" msprop:Generator_RowEvArgName="company_adminRowChangeEvent" msprop:Generator_RowClassName="company_adminRow">
<xs:complexType>
<xs:sequence>
<xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sex" msprop:Generator_ColumnVarNameInTable="columnsex" msprop:Generator_ColumnPropNameInRow="sex" msprop:Generator_ColumnPropNameInTable="sexColumn" msprop:Generator_UserColumnName="sex" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="company_new" msprop:Generator_TableClassName="company_newDataTable" msprop:Generator_TableVarName="tablecompany_new" msprop:Generator_TablePropName="company_new" msprop:Generator_RowDeletingName="company_newRowDeleting" msprop:Generator_RowChangingName="company_newRowChanging" msprop:Generator_RowEvHandlerName="company_newRowChangeEventHandler" msprop:Generator_RowDeletedName="company_newRowDeleted" msprop:Generator_UserTableName="company_new" msprop:Generator_RowChangedName="company_newRowChanged" msprop:Generator_RowEvArgName="company_newRowChangeEvent" msprop:Generator_RowClassName="company_newRow">
<xs:complexType>
<xs:sequence>
<xs:element name="Ccno" msprop:Generator_ColumnVarNameInTable="columnCcno" msprop:Generator_ColumnPropNameInRow="Ccno" msprop:Generator_ColumnPropNameInTable="CcnoColumn" msprop:Generator_UserColumnName="Ccno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ccname" msprop:Generator_ColumnVarNameInTable="columnCcname" msprop:Generator_ColumnPropNameInRow="Ccname" msprop:Generator_ColumnPropNameInTable="CcnameColumn" msprop:Generator_UserColumnName="Ccname" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cnumber" msprop:Generator_ColumnVarNameInTable="columnCnumber" msprop:Generator_ColumnPropNameInRow="Cnumber" msprop:Generator_ColumnPropNameInTable="CnumberColumn" msprop:Generator_UserColumnName="Cnumber" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cjob" msprop:Generator_ColumnVarNameInTable="columnCjob" msprop:Generator_ColumnPropNameInRow="Cjob" msprop:Generator_ColumnPropNameInTable="CjobColumn" msprop:Generator_UserColumnName="Cjob" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cemploy" msprop:Generator_ColumnVarNameInTable="columnCemploy" msprop:Generator_ColumnPropNameInRow="Cemploy" msprop:Generator_ColumnPropNameInTable="CemployColumn" msprop:Generator_UserColumnName="Cemploy" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="company_zhaopin" msprop:Generator_TableClassName="company_zhaopinDataTable" msprop:Generator_TableVarName="tablecompany_zhaopin" msprop:Generator_TablePropName="company_zhaopin" msprop:Generator_RowDeletingName="company_zhaopinRowDeleting" msprop:Generator_RowChangingName="company_zhaopinRowChanging" msprop:Generator_RowEvHandlerName="company_zhaopinRowChangeEventHandler" msprop:Generator_RowDeletedName="company_zhaopinRowDeleted" msprop:Generator_UserTableName="company_zhaopin" msprop:Generator_RowChangedName="company_zhaopinRowChanged" msprop:Generator_RowEvArgName="company_zhaopinRowChangeEvent" msprop:Generator_RowClassName="company_zhaopinRow">
<xs:complexType>
<xs:sequence>
<xs:element name="Zcno" msprop:Generator_ColumnVarNameInTable="columnZcno" msprop:Generator_ColumnPropNameInRow="Zcno" msprop:Generator_ColumnPropNameInTable="ZcnoColumn" msprop:Generator_UserColumnName="Zcno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Zname" msprop:Generator_ColumnVarNameInTable="columnZname" msprop:Generator_ColumnPropNameInRow="Zname" msprop:Generator_ColumnPropNameInTable="ZnameColumn" msprop:Generator_UserColumnName="Zname" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Zjob" msprop:Generator_ColumnVarNameInTable="columnZjob" msprop:Generator_ColumnPropNameInRow="Zjob" msprop:Generator_ColumnPropNameInTable="ZjobColumn" msprop:Generator_UserColumnName="Zjob" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Zphone" msprop:Generator_ColumnVarNameInTable="columnZphone" msprop:Generator_ColumnPropNameInRow="Zphone" msprop:Generator_ColumnPropNameInTable="ZphoneColumn" msprop:Generator_UserColumnName="Zphone" type="xs:int" minOccurs="0" />
<xs:element name="Znumber" msprop:Generator_ColumnVarNameInTable="columnZnumber" msprop:Generator_ColumnPropNameInRow="Znumber" msprop:Generator_ColumnPropNameInTable="ZnumberColumn" msprop:Generator_UserColumnName="Znumber" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="job_admin" msprop:Generator_TableClassName="job_adminDataTable" msprop:Generator_TableVarName="tablejob_admin" msprop:Generator_TablePropName="job_admin" msprop:Generator_RowDeletingName="job_adminRowDeleting" msprop:Generator_RowChangingName="job_adminRowChanging" msprop:Generator_RowEvHandlerName="job_adminRowChangeEventHandler" msprop:Generator_RowDeletedName="job_adminRowDeleted" msprop:Generator_UserTableName="job_admin" msprop:Generator_RowChangedName="job_adminRowChanged" msprop:Generator_RowEvArgName="job_adminRowChangeEvent" msprop:Generator_RowClassName="job_adminRow">
<xs:complexType>
<xs:sequence>
<xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="student_apply" msprop:Generator_TableClassName="student_applyDataTable" msprop:Generator_TableVarName="tablestudent_apply" msprop:Generator_TablePropName="student_apply" msprop:Generator_RowDeletingName="student_applyRowDeleting" msprop:Generator_RowChangingName="student_applyRowChanging" msprop:Generator_RowEvHandlerName="student_applyRowChangeEventHandler" msprop:Generator_RowDeletedName="student_applyRowDeleted" msprop:Generator_UserTableName="student_apply" msprop:Generator_RowChangedName="student_applyRowChanged" msprop:Generator_RowEvArgName="student_applyRowChangeEvent" msprop:Generator_RowClassName="student_applyRow">
<xs:complexType>
<xs:sequence>
<xs:element name="sno" msprop:Generator_ColumnVarNameInTable="columnsno" msprop:Generator_ColumnPropNameInRow="sno" msprop:Generator_ColumnPropNameInTable="snoColumn" msprop:Generator_UserColumnName="sno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Asex" msprop:Generator_ColumnVarNameInTable="columnAsex" msprop:Generator_ColumnPropNameInRow="Asex" msprop:Generator_ColumnPropNameInTable="AsexColumn" msprop:Generator_UserColumnName="Asex" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Amajor" msprop:Generator_ColumnVarNameInTable="columnAmajor" msprop:Generator_ColumnPropNameInRow="Amajor" msprop:Generator_ColumnPropNameInTable="AmajorColumn" msprop:Generator_UserColumnName="Amajor" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Agw" msprop:Generator_ColumnVarNameInTable="columnAgw" msprop:Generator_ColumnPropNameInRow="Agw" msprop:Generator_ColumnPropNameInTable="AgwColumn" msprop:Generator_UserColumnName="Agw" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ccno" msprop:Generator_ColumnVarNameInTable="columnCcno" msprop:Generator_ColumnPropNameInRow="Ccno" msprop:Generator_ColumnPropNameInTable="CcnoColumn" msprop:Generator_UserColumnName="Ccno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="student_news" msprop:Generator_TableClassName="student_newsDataTable" msprop:Generator_TableVarName="tablestudent_news" msprop:Generator_TablePropName="student_news" msprop:Generator_RowDeletingName="student_newsRowDeleting" msprop:Generator_RowChangingName="student_newsRowChanging" msprop:Generator_RowEvHandlerName="student_newsRowChangeEventHandler" msprop:Generator_RowDeletedName="student_newsRowDeleted" msprop:Generator_UserTableName="student_news" msprop:Generator_RowChangedName="student_newsRowChanged" msprop:Generator_RowEvArgName="student_newsRowChangeEvent" msprop:Generator_RowClassName="student_newsRow">
<xs:complexType>
<xs:sequence>
<xs:element name="sno" msprop:Generator_ColumnVarNameInTable="columnsno" msprop:Generator_ColumnPropNameInRow="sno" msprop:Generator_ColumnPropNameInTable="snoColumn" msprop:Generator_UserColumnName="sno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Smajor" msprop:Generator_ColumnVarNameInTable="columnSmajor" msprop:Generator_ColumnPropNameInRow="Smajor" msprop:Generator_ColumnPropNameInTable="SmajorColumn" msprop:Generator_UserColumnName="Smajor" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Snumber" msprop:Generator_ColumnVarNameInTable="columnSnumber" msprop:Generator_ColumnPropNameInRow="Snumber" msprop:Generator_ColumnPropNameInTable="SnumberColumn" msprop:Generator_UserColumnName="Snumber" type="xs:int" minOccurs="0" />
<xs:element name="Sgoto" msprop:Generator_ColumnVarNameInTable="columnSgoto" msprop:Generator_ColumnPropNameInRow="Sgoto" msprop:Generator_ColumnPropNameInTable="SgotoColumn" msprop:Generator_UserColumnName="Sgoto" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:company_admin" />
<xs:field xpath="mstns:id" />
</xs:unique>
<xs:unique name="company_new_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:company_new" />
<xs:field xpath="mstns:Ccno" />
</xs:unique>
<xs:unique name="company_zhaopin_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:company_zhaopin" />
<xs:field xpath="mstns:Zcno" />
</xs:unique>
<xs:unique name="student_apply_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:student_apply" />
<xs:field xpath="mstns:sno" />
<xs:field xpath="mstns:Ccno" />
</xs:unique>
<xs:unique name="student_news_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:student_news" />
<xs:field xpath="mstns:sno" />
</xs:unique>
</xs:element>
<xs:annotation>
<xs:appinfo>
<msdata:Relationship name="FK__student_ap__Ccno__2C3393D0" msdata:parent="company_new" msdata:child="student_apply" msdata:parentkey="Ccno" msdata:childkey="Ccno" msprop:Generator_UserChildTable="student_apply" msprop:Generator_ChildPropName="Getstudent_applyRows" msprop:Generator_UserRelationName="FK__student_ap__Ccno__2C3393D0" msprop:Generator_ParentPropName="company_newRow" msprop:Generator_RelationVarName="relationFK__student_ap__Ccno__2C3393D0" msprop:Generator_UserParentTable="company_new" />
<msdata:Relationship name="FK__student_app__sno__2B3F6F97" msdata:parent="student_news" msdata:child="student_apply" msdata:parentkey="sno" msdata:childkey="sno" msprop:Generator_UserChildTable="student_apply" msprop:Generator_ChildPropName="Getstudent_applyRows" msprop:Generator_UserRelationName="FK__student_app__sno__2B3F6F97" msprop:Generator_RelationVarName="relationFK__student_app__sno__2B3F6F97" msprop:Generator_UserParentTable="student_news" msprop:Generator_ParentPropName="student_newsRow" />
</xs:appinfo>
</xs:annotation>
</xs:schema>
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/ma-menglei/job.git
git@gitee.com:ma-menglei/job.git
ma-menglei
job
大学生就业管理系统
master

搜索帮助

0d507c66 1850385 C8b1a773 1850385