this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbUpdateCommand1 // this.oleDbUpdateCommand1.CommandText = "UPDATE 管理用户 SET 用户口令 = ?, 用户名称 = ?, 用户权限 = ? WHERE (用户名称 = ?) AND (用户口令 = ? OR ? " + "IS NULL AND 用户口令 IS NULL) AND (用户权限 = ? OR ? IS NULL AND 用户权限 IS NULL)"; this.oleDbUpdateCommand1.Connection = this.oleDbConnection1; this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用户口令", System.Data.OleDb.OleDbType.VarWChar, 10, "用户口令")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用户名称", System.Data.OleDb.OleDbType.VarWChar, 15, "用户名称")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用户权限", System.Data.OleDb.OleDbType.VarWChar, 15, "用户权限")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用户名称", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用户名称", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用户口令", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用户口令", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用户口令1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用户口令", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用户权限", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用户权限", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用户权限1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用户权限", System.Data.DataRowVersion.Original, null)); |