mainframe.cs

软件工程的课程作业

			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PostalCode1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PostalCode", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ProductName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProductName", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ProductName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProductName", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WebSite", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WebSite", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WebSite1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WebSite", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Select_ClientID", System.Data.OleDb.OleDbType.Integer, 4, "ClientID"));
			// 
			// ada_saler
			// 
			this.ada_saler.DeleteCommand = this.oleDbDeleteCommand2;
			this.ada_saler.InsertCommand = this.oleDbInsertCommand2;
			this.ada_saler.SelectCommand = this.oleDbSelectCommand2;
			this.ada_saler.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								new System.Data.Common.DataTableMapping("Table", "Saler", new System.Data.Common.DataColumnMapping[] {
																																																		 new System.Data.Common.DataColumnMapping("SalerID", "SalerID"),
																																																		 new System.Data.Common.DataColumnMapping("SalerName", "SalerName"),
																																																		 new System.Data.Common.DataColumnMapping("SalerSex", "SalerSex"),
																																																		 new System.Data.Common.DataColumnMapping("SalerBirthday", "SalerBirthday"),
																																																		 new System.Data.Common.DataColumnMapping("SalerDuty", "SalerDuty"),
																																																		 new System.Data.Common.DataColumnMapping("SalerLevel", "SalerLevel"),
																																																		 new System.Data.Common.DataColumnMapping("SalerAcount", "SalerAcount"),
																																																		 new System.Data.Common.DataColumnMapping("SalerPwd", "SalerPwd"),
																																																		 new System.Data.Common.DataColumnMapping("SWorkPhone", "SWorkPhone"),
																																																		 new System.Data.Common.DataColumnMapping("SCellPhone", "SCellPhone"),
																																																		 new System.Data.Common.DataColumnMapping("SHomePhone", "SHomePhone"),
																																																		 new System.Data.Common.DataColumnMapping("SOtherPhone", "SOtherPhone"),
																																																		 new System.Data.Common.DataColumnMapping("SEmail", "SEmail"),
																																																		 new System.Data.Common.DataColumnMapping("OnDuty", "OnDuty"),
																																																		 new System.Data.Common.DataColumnMapping("OffDuty", "OffDuty"),
																																																		 new System.Data.Common.DataColumnMapping("SNote", "SNote")})});
			this.ada_saler.UpdateCommand = this.oleDbUpdateCommand2;
			// 
			// oleDbDeleteCommand2
			// 
			this.oleDbDeleteCommand2.CommandText = @"DELETE FROM Saler WHERE (SalerID = ?) AND (OffDuty = ? OR ? IS NULL AND OffDuty IS NULL) AND (OnDuty = ? OR ? IS NULL AND OnDuty IS NULL) AND (SCellPhone = ? OR ? IS NULL AND SCellPhone IS NULL) AND (SEmail = ? OR ? IS NULL AND SEmail IS NULL) AND (SHomePhone = ? OR ? IS NULL AND SHomePhone IS NULL) AND (SNote = ? OR ? IS NULL AND SNote IS NULL) AND (SOtherPhone = ? OR ? IS NULL AND SOtherPhone IS NULL) AND (SWorkPhone = ? OR ? IS NULL AND SWorkPhone IS NULL) AND (SalerAcount = ?) AND (SalerBirthday = ? OR ? IS NULL AND SalerBirthday IS NULL) AND (SalerDuty = ? OR ? IS NULL AND SalerDuty IS NULL) AND (SalerLevel = ? OR ? IS NULL AND SalerLevel IS NULL) AND (SalerName = ?) AND (SalerPwd = ? OR ? IS NULL AND SalerPwd IS NULL) AND (SalerSex = ?)";
			this.oleDbDeleteCommand2.Connection = this.psmsconn;
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerID", System.Data.OleDb.OleDbType.Integer, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerID", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OffDuty", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OffDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OffDuty1", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OffDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OnDuty", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OnDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OnDuty1", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OnDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SCellPhone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SCellPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SCellPhone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SCellPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SEmail", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SEmail", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SEmail1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SEmail", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SHomePhone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SHomePhone", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SHomePhone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SHomePhone", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SNote", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SNote", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SNote1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SNote", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SOtherPhone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SOtherPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SOtherPhone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SOtherPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SWorkPhone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SWorkPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SWorkPhone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SWorkPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerAcount", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerAcount", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerBirthday", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerBirthday", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerBirthday1", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerBirthday", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerDuty", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerDuty1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerLevel", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerLevel", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerLevel1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerLevel", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerName", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerPwd", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerPwd", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerPwd1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerPwd", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerSex", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerSex", System.Data.DataRowVersion.Original, null));
			// 
			// oleDbInsertCommand2
			// 
			this.oleDbInsertCommand2.CommandText = @"INSERT INTO Saler(SalerID, SalerName, SalerSex, SalerBirthday, SalerDuty, SalerLevel, SalerAcount, SalerPwd, SWorkPhone, SCellPhone, SHomePhone, SOtherPhone, SEmail, OnDuty, OffDuty, SNote) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); SELECT SalerID, SalerName, SalerSex, SalerBirthday, SalerDuty, SalerLevel, SalerAcount, SalerPwd, SWorkPhone, SCellPhone, SHomePhone, SOtherPhone, SEmail, OnDuty, OffDuty, SNote FROM Saler WHERE (SalerID = ?)";
			this.oleDbInsertCommand2.Connection = this.psmsconn;
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerID", System.Data.OleDb.OleDbType.Integer, 4, "SalerID"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerName", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerName"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerSex", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerSex"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerBirthday", System.Data.OleDb.OleDbType.DBTimeStamp, 4, "SalerBirthday"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerDuty", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerDuty"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerLevel", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerLevel"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerAcount", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerAcount"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerPwd", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerPwd"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SWorkPhone", System.Data.OleDb.OleDbType.VarWChar, 50, "SWorkPhone"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SCellPhone", System.Data.OleDb.OleDbType.VarWChar, 50, "SCellPhone"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SHomePhone", System.Data.OleDb.OleDbType.VarWChar, 50, "SHomePhone"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SOtherPhone", System.Data.OleDb.OleDbType.VarWChar, 50, "SOtherPhone"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SEmail", System.Data.OleDb.OleDbType.VarWChar, 50, "SEmail"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("OnDuty", System.Data.OleDb.OleDbType.DBTimeStamp, 4, "OnDuty"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("OffDuty", System.Data.OleDb.OleDbType.DBTimeStamp, 4, "OffDuty"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SNote", System.Data.OleDb.OleDbType.VarWChar, 50, "SNote"));
			this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Select_SalerID", System.Data.OleDb.OleDbType.Integer, 4, "SalerID"));
			// 
			// oleDbSelectCommand2
			// 
			this.oleDbSelectCommand2.CommandText = "SELECT SalerID, SalerName, SalerSex, SalerBirthday, SalerDuty, SalerLevel, SalerA" +
				"count, SalerPwd, SWorkPhone, SCellPhone, SHomePhone, SOtherPhone, SEmail, OnDuty" +
				", OffDuty, SNote FROM Saler";
			this.oleDbSelectCommand2.Connection = this.psmsconn;
			// 
			// oleDbUpdateCommand2
			// 
			this.oleDbUpdateCommand2.CommandText = @"UPDATE Saler SET SalerID = ?, SalerName = ?, SalerSex = ?, SalerBirthday = ?, SalerDuty = ?, SalerLevel = ?, SalerAcount = ?, SalerPwd = ?, SWorkPhone = ?, SCellPhone = ?, SHomePhone = ?, SOtherPhone = ?, SEmail = ?, OnDuty = ?, OffDuty = ?, SNote = ? WHERE (SalerID = ?) AND (OffDuty = ? OR ? IS NULL AND OffDuty IS NULL) AND (OnDuty = ? OR ? IS NULL AND OnDuty IS NULL) AND (SCellPhone = ? OR ? IS NULL AND SCellPhone IS NULL) AND (SEmail = ? OR ? IS NULL AND SEmail IS NULL) AND (SHomePhone = ? OR ? IS NULL AND SHomePhone IS NULL) AND (SNote = ? OR ? IS NULL AND SNote IS NULL) AND (SOtherPhone = ? OR ? IS NULL AND SOtherPhone IS NULL) AND (SWorkPhone = ? OR ? IS NULL AND SWorkPhone IS NULL) AND (SalerAcount = ?) AND (SalerBirthday = ? OR ? IS NULL AND SalerBirthday IS NULL) AND (SalerDuty = ? OR ? IS NULL AND SalerDuty IS NULL) AND (SalerLevel = ? OR ? IS NULL AND SalerLevel IS NULL) AND (SalerName = ?) AND (SalerPwd = ? OR ? IS NULL AND SalerPwd IS NULL) AND (SalerSex = ?); SELECT SalerID, SalerName, SalerSex, SalerBirthday, SalerDuty, SalerLevel, SalerAcount, SalerPwd, SWorkPhone, SCellPhone, SHomePhone, SOtherPhone, SEmail, OnDuty, OffDuty, SNote FROM Saler WHERE (SalerID = ?)";
			this.oleDbUpdateCommand2.Connection = this.psmsconn;
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerID", System.Data.OleDb.OleDbType.Integer, 4, "SalerID"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerName", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerName"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerSex", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerSex"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerBirthday", System.Data.OleDb.OleDbType.DBTimeStamp, 4, "SalerBirthday"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerDuty", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerDuty"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerLevel", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerLevel"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerAcount", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerAcount"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SalerPwd", System.Data.OleDb.OleDbType.VarWChar, 50, "SalerPwd"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SWorkPhone", System.Data.OleDb.OleDbType.VarWChar, 50, "SWorkPhone"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SCellPhone", System.Data.OleDb.OleDbType.VarWChar, 50, "SCellPhone"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SHomePhone", System.Data.OleDb.OleDbType.VarWChar, 50, "SHomePhone"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SOtherPhone", System.Data.OleDb.OleDbType.VarWChar, 50, "SOtherPhone"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SEmail", System.Data.OleDb.OleDbType.VarWChar, 50, "SEmail"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("OnDuty", System.Data.OleDb.OleDbType.DBTimeStamp, 4, "OnDuty"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("OffDuty", System.Data.OleDb.OleDbType.DBTimeStamp, 4, "OffDuty"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SNote", System.Data.OleDb.OleDbType.VarWChar, 50, "SNote"));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerID", System.Data.OleDb.OleDbType.Integer, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerID", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OffDuty", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OffDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OffDuty1", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OffDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OnDuty", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OnDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OnDuty1", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OnDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SCellPhone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SCellPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SCellPhone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SCellPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SEmail", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SEmail", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SEmail1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SEmail", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SHomePhone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SHomePhone", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SHomePhone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SHomePhone", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SNote", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SNote", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SNote1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SNote", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SOtherPhone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SOtherPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SOtherPhone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SOtherPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SWorkPhone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SWorkPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SWorkPhone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SWorkPhone", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerAcount", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerAcount", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerBirthday", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerBirthday", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerBirthday1", System.Data.OleDb.OleDbType.DBTimeStamp, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerBirthday", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerDuty", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerDuty1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerDuty", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerLevel", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerLevel", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerLevel1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerLevel", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SalerName", System.Data.DataRowVersion.Original, null));
			this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SalerPwd", System.Data.OleDb.O